can't login after reboot, latest version, sles9

[oskare]

hello,
I've installed the latest stable version on sles9 for a trial run.
I make the users and can login as admin or the users.

However, after a reboot, I can't login!

what is causing this?

I've looked in the forums but can't find anything about this.

thanks,

Oskar

[kbrill]

Does it give you errors?

Is your mysql running? Can you get to the Sugar tables and look at the users table and see if your data is there?

[oskare]

yes,
I can see the mysql database via phpmyadmin.
I can see it all, it only does this after I reboot. If I install and leave it running, it works fine for days.
Only after I reboot it doesn't let me login anymore from any user.

[kbrill]

yes,
I can see the mysql database via phpmyadmin.
I can see it all, it only does this after I reboot. If I install and leave it running, it works fine for days.
Only after I reboot it doesn't let me login anymore from any user.

What is the error it gives you. Change your logging level to debug. Edit the file log4php.properties and make it so that the lne with DEBUG in it is uncommented and the line with FATAL is commented out. Then get the error and check your log file.

[oskare]

i've made the changes in the log4php.properties file.
i restarted apache and mysql.
mysql log is a /var/lib/mysql/mysqld.log
apache2 log is at /var/log/apache2/

I've checked both apache and mysql logs and don't see anything.

I've also checked the system log at /var/log/messages but no luck.

what else can i do?

[kbrill]

Look in /sugarcrm.log

[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: