Fog 0.32 upgrade and user fix

[Kelly Estes]

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,
Kelly

[SuP3R_Ch1cKeN]

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]http://fogproject.org/forum/threads/partimage-aborts.10275/#post-24893[/url])

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

[Fhajad]

2. What you can do is get into the Database “fog” and the table “users” and inject a line to create a user.
3. 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, ‘’, ‘’);
exit

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

[Tom Elliott]

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