Fog 0.32 upgrade and user fix

  • Hello, I am running an old version of Fog 0.32 on CentOS 6 and recently after being terminated an admin deleted all the users in the fog application. I have 3 questions:

    1. Should I upgrade and if I do am I looking at likely issues.
      a) If I should upgrade should I look at doing a complete reinstall?
      b) Will my old images be compatible with the new Fog software?
    2. Is there a way to create a new user from the command line? I have root access to the system but do not know how to create a user.
    3. Once a user is created how do I reset it’s password? I tried the instructions I found online but it says not records changed.

    Any help will be greatly appreciated.

    Thank You,

  • Senior Developer

    Did the admin delete all of the users or just ones he felt would overall hurt the company?

    1. What you can do is get into the Database “fog” and the table “users” and inject a line to create a user.
    2. Once the user is created, you can login and add/edit/delete users.

    SSH into the server
    mysql -u root -p
    Enter password
    connect fog;
    INSERT INTO fog.users (uId, uName, uPass, uCreateDate, uCreateBy, uType) VALUES (NULL, ‘newuser’, ‘5f4dcc3b5aa765d61d8327deb882cf99’, CURRENT_TIMESTAMP, ‘’, ‘’);

    If you do those steps and past that INSERT INTO line exactly, it will create a user called “newuser” with the password “password”.

    1. You will most likely have issues unless you’ve done an install before however if you search the forums you should find posts related to your issues.
      a. I think a fresh install is always better then an upgrade but that’s really a preference thing
      b. Yes (kinda)… FOG 1.0.0+ uses PartClone and below 1.0.0 uses PartImage. Now with 1.0.0+ you can still deploy PartImage files however when you reupload the image it will be a PartClone file. It’s kind of a process to migrate all your images to PartClone images if you have a lot but it’s not really hard either. Tom’s post in this thread can help with this ([url][/url])

    2. and 3) I have no idea on this issue.

Log in to reply