Best posts made by KnightRaven

@zln1996
I had troubles this past week after updating as well. My issues I’m sure was due to my own clumsyness. We had a fire drill and in my haste I kicked the power to the station during fog update. The DB was not in good shape after and had similar problems. I am by no means a MySQL/DB pro so please use caution with my assistance.

So what I found was to stop mysql service and use this command to get into the DB…

sudo mysqld --skip-grant-tables

Then in another terminal run:

mysql
use mysql

After trying a bunch of other things(table repairs and such) I realized the root account was missing(as were others).
You can use this to check existance and should show rights assigned.

select * from user where User='root';

I can’t find the page that helped me most but I think next is:

FLUSH PRIVILEGES
#if root doesnt exist...
insert into user (Host, User, Password) values ('localhost','root','');

#IF/after root exists...
update user set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',Reload_priv='Y',Shutdown_priv='Y',Process_priv='Y',File_priv='Y',Grant_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Show_db_priv='Y',Super_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',Repl_slave_priv='Y',Repl_client_priv='Y',Create_view_priv='Y',Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y',Create_user_priv='Y' where user='root';

#
grant all privileges on *.* to 'root'@'%' with grant option;
grant all privileges on *.* to 'root'@'localhost' with grant option;

while I didnt use this site:http://www.helpfromfriend.com/featured/how-to-recreate-root-account-in-mysql/ initially ,
it does layout basically what i had to do.

you may need to add: IDENTIFIED WITH mysql_native_password BY ‘’ to the end of the GRANT statements. I think I had to.

If you want to check/repair tablesyou can check this site on how to:
http://www.thegeekstuff.com/2011/12/mysqlcheck

The experts here may over rule me but it helped me.

hopefully this helps you. Or at least someone.

Jason

@george1421
Just wanted to add some more notes after using/trying this setup in another location.
You may encounter rights issues and errors if nothing is changed. I opened up the File Browser as root to copy and paste files for Win setup along with other tools.

You very likely may need to use chown and chmod to give proper access to your files. By default on my testing the user and group was set to root:root. I did NOT use root as my user when mapping my drive for pxe setup. So I needed to change.

so you may need to try:

#to change who owns the folder or files

sudo chown -R jdoe:root /location/of/folder

# use a "*" wildcard to do all items at named location or at 
# current location
sudo chown -R jdoe:root /location/of/files/*
sudo chown -R jdoe:root *

# you can use ls -l to check

#for ref: https://en.wikipedia.org/wiki/Chown

#to change the actual rights, as in read/write/execute...

sudo chmod 774 /location/of/folder/or files  (or again use a *)

#again use ls -l to check


# 774 will give user and group full rights. the 4 gives guest read only.  Not sure that full rights are needed but used to test and didn't reduce as of yet to know if just read or anything less will work.

for ref: https://en.wikipedia.org/wiki/Chmod

To recap my trials…
At first I forgot to change user and mapped drive wouldn’t work. After changing user I would get access denied to setup.exe. After making sure I had rights to setup.exe, I got a winsetup.dll error. Saying it was corrupted or missing(Something like that I forget the actual wording now).

I ended up recopying to be sure but ended up being a rights issue to the whole sources directory.

Just wanted anyone else reading to know what you might run into. While I dont yet consider myself an expert here, I will be glad to answer questions if something is not clear. My knowledge has come from trial and errors, and then finally asking questions.
thanks to all who have helped answer or wrote other related topics to get me/us here.

Hope this helps someone.

Jason
KnightRaven

@zln1996
hmmm… Maybe the server isn’t stopping all the way. I think you can try:

killall mysqld

Mine gave me this error as well but don’t rem. what all I did now.

You may also need to check your mysql config file “my.cnf”.
should be located in /etc/mysql/my.cnf
while I didn’t find them here, you can also check:
/etc/my.cnf
/var/lib/mysql/my.cnf

Make sure any IPs match your server and check where it says the .sock file is supposed to be. There is also a bind statement listed, but from what I read(and as was in my file) it should be commented out.
As I checked mine just now I don’t see any IPs or names other than at the bind-address which is commented out.

You could also try just making the .sock file:

touch /var/run/mysqld/myssqld.sock

keep in mind when making these changes you will need to use sudo or run as root(sudo -i).

Check your error.log file in /var/log/mysql/error.log
It may have some more info.
also: /var/log/mysql.err and /var/log/mysql.log
although for me the last two were empty.

Now I will tell you that I eventually re-installed mysql but I would use that as a last resort. My DB data stayed intact(as far as fog info goes anyway) but I may have been lucky.

after re-installing I used the steps provided previously to re-add the root user and it’s rights. I didn’t realize the root user was gone til after the re-install so I figure I may not have had to do that.

@lukebarone
Oh apparently its just a little further up the chain…
Using the same xml file you can customize both.
https://docs.microsoft.com/en-us/windows/configuration/configure-windows-10-taskbar

Jason

@zln1996
I forgot to mention you can use

ps -ef | grep mysql

to find other potential instances of mysql running.

as far as removal goes…

sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean

then to re-install…

sudo apt-get update
sudo apt-get install mysql-server mysql-client mysql-common

If you don’t have a .sql backup you can try backing up these folders:
/etc/mysql and /var/lib/mysql
it looks like, at least on mine, that the data is in /var/lib/mysql. It has matching info for my databases anyway.

Using --purge will certainly get rid of config files. Maybe it leaves the data though?

If this is a full blown live production server I might wait til i hear back from one of the Fog pros. While I use mine regularly it is not mission critical so to speak. I also had backups I could use. I was also prepared that I would have to just manually re-enter the image info as the files would still be there.
My killer would have been losing my advanced pxe scripts lol.

@zln1996
Also you are quite welcome. I just hope its useful info. These guys on here have helped me quite a bit to keep things running and setup stuff. So I try to help or add my $.02 worth.

I dunno they might would like for me to stop.

@ttrammell
It looks like something similar when I had changed the IP and didn’t finish configuring everything. I had left out checking and configuring the Storage group/nodes.
If you have changed your IP(or maybe even Server name) try following these instructions:
https://wiki.fogproject.org/wiki/index.php/Change_FOG_Server_IP_Address
The key part I missed(becasue I didn’t really use storage nodes) was:

Update the IP address for the storage node on the FOG system where you changed the IP address - Web Interface -> Storage Management
Make sure you actually click the node and check the IP setting.

that line in the bandwith.php file points to a location in /sys/class/net/<net_adapter_name>/operstate

I’m not sure if CentOS is diferent but my adapter name is eth0 so look for that in place of adapter name.
Im not sure if you can simply recreate it it if it doesn’t exist. It simply appears to display whether or not your adapter is up or not.

I also found this article but refers more to the fog client install.
https://forums.fogproject.org/topic/5926/change-fog-server-name

Hope that helps,
Jason

@zln1996
Wow. I’m not really sure. I would hate to think you’d have to go that extreme. Maybe someone else knows better than I.

However…
Did it ask you for a password during re-install? I will say that mine did but the login still didn’t work. Root was still missing I still had to use the --skip-grant-tables to get in. There is also a network related switch/option but I don’t know for sure what that does. Maybe skips issues if it denies login from localhost?
I think its --skip-networking. You can try that. I may have used both now that I think about it. I’ve slept a couple of times since then though. LOL

The only other thing I could think(if you didn’t) is to verify that the config files are gone from /etc/mysql when re-installing.

The next thing would be purely experimental… But there is a mariadb that is supposed to be a drop in replacement for mysql. You could try installing that and see if that fixes it. But I have not tried this.

I’m sorry I can’t be of more help.

@george1421
You’re are welcome to use anything of mine. In fact I think you helped get the windows boot working awhile back. I’ve borrowed and tweaked just a bit from sources here at Fog anyway myself.

I have to much going on right now to test what I posted but I know it has worked. My current location has a bare bones setup just for deploying an image. I haven’t had time to setup the advanced menu items(well the actual files anyway).