can't login after reboot, sles9, latest sugarcrm.

[oskare]

mail:/srv/www/htdocs/sugarcrm # cat sugarcrm.log
Sun Aug 6 23:38:38 2006,699 [6159] INFO SugarCRM - Connect:Resource id #151
Sun Aug 6 23:38:38 2006,704 [6159] INFO SugarCRM - Query:SELECT category, name, value FROM config WHERE category='system'
Sun Aug 6 23:38:38 2006,707 [6159] INFO SugarCRM - Query Execution Time:0.002125
Sun Aug 6 23:38:38 2006,709 [6159] DEBUG SugarCRM - ****Starting Application for session 45eba145f94a0b8d6df8f2896ae9ac59
Sun Aug 6 23:38:38 2006,710 [6159] DEBUG SugarCRM - We are authenticating user now
Sun Aug 6 23:38:38 2006,716 [6159] DEBUG SugarCRM - array (
'gmto' => '360',
'module' => 'Users',
'action' => 'Authenticate',
'return_module' => 'Users',
'return_action' => 'Login',
'cant_login' => '',
'login_module' => '',
'login_action' => '',
'login_record' => '',
'user_name' => 'admin',
'user_password' => 'password',
'Login' => ' Login ',
'login_theme' => 'Sugar',
'login_language' => 'en_us',
'PHPSESSID' => '45eba145f94a0b8d6df8f2896ae9ac59',
)
Sun Aug 6 23:38:38 2006,717 [6159] INFO SugarCRM - In module: Users -- About to take action Authenticate
Sun Aug 6 23:38:38 2006,718 [6159] DEBUG SugarCRM - in module Users -- in Authenticate
Sun Aug 6 23:38:38 2006,718 [6159] DEBUG SugarCRM - ----------------------------------------------------------------------------------------------------------------------------------------------
Sun Aug 6 23:38:38 2006,719 [6159] INFO SugarCRM - current page is modules/Users/Authenticate.php
Sun Aug 6 23:38:38 2006,720 [6159] INFO SugarCRM - current module is Users
Sun Aug 6 23:38:38 2006,721 [6159] INFO SugarCRM - Query:SELECT count(*) as the_count FROM config WHERE category='info' AND name='sugar_version' AND value = '4.2.1'
Sun Aug 6 23:38:38 2006,723 [6159] INFO SugarCRM - Query Execution Time:0.00092
Sun Aug 6 23:38:38 2006,724 [6159] DEBUG SugarCRM - current_language is: en_us
Sun Aug 6 23:38:38 2006,745 [6159] DEBUG SugarCRM - Current theme is: Sugar
Sun Aug 6 23:38:38 2006,749 [6159] INFO SugarCRM - Query:
SELECT meetings.id, name,reminder_time, description,location, date_start, time_start,
CONCAT( date_start, CONCAT(' ', time_start ) ) AS dateTime
FROM meetings LEFT JOIN meetings_users ON meetings.id = meetings_users.meeting_id
WHERE meetings_users.user_id =''
AND meetings.reminder_time != -1
AND meetings_users.deleted != 1
HAVING dateTime >= '2006-08-07 04:38:38' AND dateTime <= '2006-08-07 05:38:38'
Sun Aug 6 23:38:38 2006,751 [6159] INFO SugarCRM - Query Execution Time:0.001345
Sun Aug 6 23:38:38 2006,753 [6159] INFO SugarCRM - Query:
SELECT calls.id, name, reminder_time, description, date_start, time_start,
CONCAT( date_start, CONCAT(' ', time_start) ) AS dateTime
FROM calls LEFT JOIN calls_users ON calls.id = calls_users.call_id
WHERE calls_users.user_id =''
AND calls.reminder_time != -1
AND calls_users.deleted != 1
HAVING dateTime >= '2006-08-07 04:38:38' AND dateTime <= '2006-08-07 05:38:38'
Sun Aug 6 23:38:38 2006,755 [6159] INFO SugarCRM - Query Execution Time:0.001284
Sun Aug 6 23:38:38 2006,756 [6159] DEBUG SugarCRM - skipping headers
Sun Aug 6 23:38:38 2006,758 [6159] INFO SugarCRM - Query:SELECT category, name, value FROM config WHERE category='license'
Sun Aug 6 23:38:38 2006,759 [6159] INFO SugarCRM - Query Execution Time:0.000686
Sun Aug 6 23:38:38 2006,764 [6159] INFO SugarCRM - Query:SELECT category, name, value FROM config WHERE category='MySettings'
Sun Aug 6 23:38:38 2006,766 [6159] INFO SugarCRM - Query Execution Time:0.000801
Sun Aug 6 23:38:38 2006,773 [6159] INFO SugarCRM - Query:SELECT count(*) AS num FROM roles_users WHERE user_id='' AND deleted=0
Sun Aug 6 23:38:38 2006,775 [6159] INFO SugarCRM - Query Execution Time:0.000939
Sun Aug 6 23:38:38 2006,776 [6159] DEBUG SugarCRM - ---------> BEGING INCLUDING REQUESTED PAGE: [modules/Users/Authenticate.php] <------------
Sun Aug 6 23:38:38 2006,780 [6159] FATAL SugarCRM - SECURITY: admin has attempted to login 15 times from IP address: 10.100.1.200.
Sun Aug 6 23:38:38 2006,781 [6159] DEBUG SugarCRM - Starting user load for admin
Sun Aug 6 23:38:38 2006,783 [6159] DEBUG SugarCRM - Limit Query:SELECT * from users where user_name='admin' AND user_hash='5f4dcc3b5aa765d61d8327deb882cf99' AND (portal_only IS NULL OR portal_only !='1') AND (is_group IS NULL OR is_group !='1') Start: 0 count: 1
Sun Aug 6 23:38:38 2006,784 [6159] INFO SugarCRM - Query:SELECT * from users where user_name='admin' AND user_hash='5f4dcc3b5aa765d61d8327deb882cf99' AND (portal_only IS NULL OR portal_only !='1') AND (is_group IS NULL OR is_group !='1') LIMIT 0,1
Sun Aug 6 23:38:38 2006,786 [6159] INFO SugarCRM - Query Execution Time:0.001345
Sun Aug 6 23:38:38 2006,787 [6159] FATAL SugarCRM - SECURITY: User authentication for admin failed
Sun Aug 6 23:38:38 2006,788 [6159] DEBUG SugarCRM - ---------> END INCLUDING REQUESTED PAGE:

[bretweinraub]

check your apache log

I just had a similar problem that showed its face in the apache error_log:

[Sun Oct 26 19:15:06 2008] [error] [client 127.0.0.1] PHP Warning: Unknown(): open(/tmp/sess_99e1b4f2b96ee9da535b32237629df2a, O_RDWR) failed: Permission denied (13) in Unknown on line 0, referer: http://localhost:8084/Bret5/index.ph...n&module=Users

It looks like if sugar can't write out its session data; you can't login.