Posts made by Hanz

@Hanz sry I didn’t c that last part…I’ve been doing it wrong apparently…will test.

mysql -u fogstorage -p’fogstorage password’ -h 10.72.3.50 fog yields

ERROR 1045 (28000): Access denied for user ‘fogstorage’@‘10.72.216.50’ (using password: YES)

@Tom-Elliott Yes I’ve made sure the fogstorage password is correct on server as well as nodes. This problem didn’t arise until I updated to from version 4972…I don’t understand how any setting I have could affect this. I’ve also tried to manually assign privileges to the db on server by issuing (grant all privileges on fog.* to fogstorage@‘%’ identified by ‘(fogstorage password)’

@Uncle-Frank I typed it wrong, but all nodes show same error
ERROR 1045 (28000): Access denied for user ‘fogstorage’@‘XXX.XXX.XXX.XXX’ (using password: NO)

They are different versions, because I updated the two nodes when the error started presenting itself.

@Uncle-Frank yes, this ip 10.72.208.55 is one of the storage nodes and the 3.50 is my server. I was trying to connect to db on server manually, from the node.

@Uncle-Frank No the problem is still present, and I the apache error log is throwing in lin 29 of /var/www/html/fog/lib/db/MySQL.class.php…which mentions the DATABASE_HOST, USERNAME ,AND PASSWORD…

The nodes that are working correctly as far as the main page not saying “MYSQL server not currently running” in place of the kernel ver.,
ERROR 1045 (28000): Access denied for user ‘fogstorage’@‘10.72.208.55’ (using password: NO) when trying to connect manually to db.
This is error msg. for two stating that “MYSQL server not currently running”
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘10.7.3.50’ (113 “No route to host”)

They two nodes not working correctly are also missing the connection type= “MYSQL_ASYNC” line in /opt/fog/.fogsettings and line can’t be manually added, installer overwrites somehow.

Your image is probably not complete…you should have all these files under that image folder.

d1.fixed_size_partitions d1.original.fstypes d1p1.img
d1.mbr d1.original.partitions d1p2.img
d1.minimum.partitions d1.original.swapuuids

For Windows 7 I use single disk resizable and it has worked fine so far. That error is from the hard drive not having a proper image installed. I would try recreating the image and make sure you have all the files. I am running trunk and also do not use FOGprep, but you will need to sysprep.

SYSPREP will format and repartition the drive on install.

Your PXE Boot Menu Configuration…I added one and named it Ubuntu14

kernel http://10.72.3.50/fog/service/ipxe/Ubuntu14/casper/vmlinuz
initrd http://10.72.3.50/fog/service/ipxe/Ubuntu14/casper/initrd.lz
imgargs vmlinuz root=/dev/nfs boot=casper netboot=nfs nfsroot=10.72.3.50:/var/www/html/fog/service/ipxe/Ubuntu14
boot

/etc/fstab should have an entry like this…I mounted mine here at startup.

/home/bcs/Desktop/ISO/ubuntu-14.04.2-desktop-i386.iso /var/www/html/fog/service/ipxe/Ubuntu14 iso9660 loop 0 0

Exports should have an entry like…or wherever your mount point is.

/var/www/html/fog/service/ipxe/Ubuntu14 *(ro,async)

This entry in exports will need to be recreated after any svn updates, since the installer overwrites the exports file.

I would like to add that although the other two nodes (that are still running 4972) don’t have the MYSQL error on Main Page, but also can’t connect manually to db.

unfortunately the two nodes running 4972 are working correctly…The password is the same in all locations, so I don’t believe that is the issue.

Images and snapins are however being replicated correctly.

I updated another node to the 4980 from 4972 and the same " MYSQL does not appear to be running" issue

Wayne had me try to connect to mysql from new node manually with

mysql -u fogstorage -h 10.72.3.50 -p fs9694191133
it prompts for another password when I enter the above fs********** I get this error

ERROR 1045 (28000): Access denied for user 'fogstorage;@‘10.72.2.16’ (using password:YES)

if I try it with No password and just hit enter I get the same error, but (using password:NO)

This may be related but I have a new storage node named “travel” that is showing

FOG Configuration
FOG Version Information
Version: 4980

Fog-Server
Your verson of FOG is up to date.
Kernel Versions
Travel
MySQL does not appear to be running
Wharton
bzImage Version: 4.2.3
bzImage32 Version: 4.2.3
Ramage
bzImage Version: 4.2.3
bzImage32 Version: 4.2.3
VanElem
bzImage Version: 4.2.3
bzImage32 Version: 4.2.3

The "MYSQL does not appear to be running on the main page under “disk information” drop-down too.

I’m currently running 4980

Would this be considered a web timeout when it actually loads a page that states No storage nodes available in this group ?

Just curious if these sizes are normal. My error log fileis at around 250MB, while the access file is almost 700MB

When I try to load the “Log Viewer” page, I’m greeted with a “There are no enabled storage nodes for this group” page.

Apache error log is insanely large as I’m getting:

[Thu Oct 15 18:49:51.394280 2015] [:error] [pid 1043] [client 10.73.98.207:50720] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64.

for just about every host it looks like (I’ve got close to 600 so far).

Thanks Wayne, I had some 20 disassociated hosts and ID’s. The pending host issue is resolved after deleting hosts from output of
SELECT hostID from hosts WHERE hostID NOT IN (SELECT hmHostID FROM hostMAC WHERE hmPrimary=1);

by

DELETE FROM hosts WHERE hostID IN (firstID,secondID,thirdID,etc…);

storage mgmt.docx