Invalid Login

[A Former User]

I installed FOG last week and everything was working fine. However when I tried to log in today I received an invalid login message on the /fog/management page. I have checked config.php and all passwords are still set as the default.

Any ideas please?

[Wayne Workman]

What version of FOG? what revision?

[A Former User]

[quote=“Wayne Workman, post: 45350, member: 28155”]What version of FOG? what revision?[/quote]

FOG version 1.2.0

[Wayne Workman]

Have you rebooted since the last time it worked?

I’d recommend beginning by making sure the various services are running… and I’d check MySQL first.

[CODE]mysqladmin -u root -p status[/CODE]

The password will be blank unless you set one.

[A Former User]

These are the responses from the checks, I’m pretty sure I didn’t set a password, but it would have been ‘password’ if I did so I tried that too.

$ sudo service mysql status
mysql start/running, process 5318

$ mysqladmin -u fog -p status
Enter password:
mysqladmin: connect to server at ‘localhost’ failed
error: ‘Access denied for user ‘fog’@‘localhost’ (using password: YES)’

$ mysqladmin -u fog -p status
Enter password:
mysqladmin: connect to server at ‘localhost’ failed
error: ‘Access denied for user ‘fog’@‘localhost’ (using password: NO)’

[Wayne Workman]

Try this, as seen here: [url]http://fogproject.org/forum/threads/cant-login-to-management-after-saving-fog-settings.12534/page-2#post-43286[/url]
[CODE]sudo service apache2 stop;sudo rm -rf /var/lib/php5/sess_*; sudo service apache2 start;[/CODE]

If that doesn’t work, try this as seen here: [url]http://fogproject.org/forum/threads/cant-login-to-management-after-saving-fog-settings.12534/page-3#post-43757[/url]
[CODE]mysql -u root fog
update globalSettings set settingValue=‘1’ where settingKey=‘FOG_INACTIVITY_TIMEOUT’;
exit;[/CODE]

Let us know.

[A Former User]

sadly neither worked, FOG_INACTIVITY_TIMEOUT was already set to 1.

mysql> update globalSettings set settingValue=‘1’ where settingKey=‘FOG_INACTIVITY_TIMEOUT’;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

[Wayne Workman]

What I’d like to try next is manually changing (or creating) the WEB user “fog” with password = “password”

If we can just get you into the web console, you’re likely able to delete the old user and make a new one.
But I’m not sure of the SQL that is needed.

I’m going to look through the installation files for 1.2.0, I should be able to find the code that does it…

[Wayne Workman]

What distro & version of Linux are you running?

[A Former User]

sorry, I reinstalled Ubuntu and now it works fine. Not an ideal solution but I was under pressure to have it working that evening.

[A Former User]

Thanks for your help anyway

[Wayne Workman]

Glad you got it working.