Can you verify that the session actually exists in the location you are attempting to store it?
sys_get_temp_dir() is your location. The id of auth_sessions is the CI session ID, and it's only NULL because that's what's being passed to it from the CI session library.
My advice is to make sure plain CI sessions are working with your application, and you'll probably see that Community Auth starts working.