Can No Longer Login to Web GUI - Invalid Login (FOG 1.1.2/Ubuntu 14.04)



  • Hi all,

    I am testing out FOG in my company environment. It’s not a pressing need, more a QOL upgrade for me and, as such, I’ve been sort of on-and-off testing it. I’m currently running FOG 1.1.2 on Ubuntu 14.04 Workstation 64-bit. The Ubuntu workstation is running on an ESXi host.

    My problem is as follows: I am able to set up the FOG server initially with no problems. After installation, I am able to log into the Web GUI with the default user name and password. I then set up new user names and passwords for security purposes (defaults = sad face emoticon). I am able at that point to set up my images, register workstations, send commands, etc.

    However, and this is the second run-through that I’ve encountered this, after a certain amount of time or one reset, going to the web GUI would suddenly prompt me with the Database Schema Installer/Updater prompt and, upon clicking, would fail that update. I found a forum post that gave a workaround for this – link here-- where it was recommended that I had the following code to the /etc/init/mysql.conf file:

    start on (net-device-up IFACE=eth0
    and local-filesystems
    and runlevel http://"
    http://"
    http://“
    http://”

    • Yes, the error about line 247 repeats twice, then the error circles back around to line 89.
    • I have looked at /var/www/fog/lib/db/MySQL.class.php at the aforementioned lines and could see nothing strange about them, but I can provide them, or the whole file, upon request.

  • Senior Developer

    Try this
    You know what username you used?

    Do you know what type you entered it as?

    FOG Uses MD5 encryption to the passwords to set the password. This way there’s kind of a level of security making cracking your passwords that much more difficult.

    Try this:

    mysql -u root [ -p #only if you have a password for your database ] fog
    select * from users WHERE uName='<YOURUSERNAMEHERE>';
    update users set uType='0' where uName='<YOURUSERNAMEHERE>';
    update users set uPass=MD5('<YOURNEWPASSWORDHERE>') WHERE uName='<YOURUSERNAMEHERE>':
    

    Hopefully everything will work properly and you’ll be able to sign into your FOG system.


  • Developer

    I’m sorry, I’ve not tried to change my default user, I am trying to think of inventive ways to solve the issue. Please be patient.



  • Any other suggestions? I already have a couple images saved to the server and would rather not start from scratch, but if I can’t figure this out, I guess that’ll have to be my solution.



  • Renaming the account did not work.



  • Hi,

    rename the user in the db, install phpmyadmin (apt-get install phpmyadmin) login and rename the user:

    ""

    Regards X23



  • I always change default usernames in my environment, out of habit and for security purposes. I changed this account name within the Web GUI, so without access to the Web GUI I’m unsure how to change it back.


  • Developer

    Why did you change the default username? Did you try changing it back to fog?



  • I did not create a user named Fog. I did change the default user’s name from fog to fog_admin. I tried resetting the Ubuntu machine’s user password for the account ‘fog’, which succeeded, but this did not resolve my login issue.



  • This post is deleted!

  • Developer

    Did you by chance create a user named FOG?

    Did you try resetting the password for the FOG user?

    
    sudo passwd fog
    

    Make the password “password” as it should be and attempt to log in again.


Log in to reply
 

327
Online

38729
Users

10555
Topics

99938
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.