Posts made by jherron

it appears to have fixed itself, i tried again on a whim today and im no longer having issues with the locations plugin. sooo problem solved i guess.

@jherron

I was able to resolve my own issue. ID10T error.

After reinstalling the storage servers at the respective sites and reassigning them to their groups, i had forgotten to set the locations plugin. After i set the servers in the location plugin everything resumed working as normal.

i have two storage nodes that i replaced at the beginning of the summer. everything seemed fine came up in the server, images replicated to them thought everything was good. if i try to image from them i get a chainloading error after the initial fog menu. i checked some logs and they both have some PHP-FPM error logs that repeat the same lines:

[23-Jul-2021 18:06:18 UTC] PHP Fatal error: Uncaught Exception: No valid storage nodes found in /var/www/html/fog/lib/fog/bootmenu.class.php:1495
Stack trace:
#0 /var/www/html/fog/lib/fog/bootmenu.class.php(434): BootMenu->getTasking()
#1 /var/www/html/fog/service/ipxe/boot.php(52): BootMenu->__construct()
#2 {main}
thrown in /var/www/html/fog/lib/fog/bootmenu.class.php on line 1495

i tried re-running the installer on one that wasnt working but nothign seemes to have changed. so i feel like i must have messed up a setting somewhere but im not sure where or what to look for.

server and nodes are all running 1.5.9 on cent os 7

@Sebastian-Roth on the fog server itself. it is not relevant to the error previosly posted sorry. i saw it when i logged into my vm server.

@Sebastian-Roth Thanks! i tried new tasks and it seems to be back in working order. is there a recommended amount of ram i should be using, i have it set to 10gigs and its using almost all of it.

https://imgur.com/KZcLjI5

picture to help out

i feel like im just a little off now. a successful pxe boot. but now if i deploy and image from the pxe menu it seems to start the task, but sits at a black screen where it occasionally tells me about how its missing some jiffies.

My fog server was running well on version 1.5.0. However we are moving offices, and we were 5 revisions behind so i decided i would migrate the fog server to a newer Vm server at the new building.

i Followed this guide :
https://wiki.fogproject.org/wiki/index.php?title=Migrate_FOG
everything seemed to go smoothly. i changed the ip address of the new server to the ip of the old server after turning the old one off. After upgrading my storage nodes there was a db connection issue, that after resetting the fogstorage password on the server seemed to get fixed. but im currently having two issues:

the first problem comes when i try to pxe boot a client. it looks to the correct Ip for tftp but it looks to its old address for http and then fails.
https://imgur.com/4ZqHn7D

the second issue is when i look at the logs for replication, all of the storage nodes continually say " waiting for mysql to become availiable" and im not sure what to do with that or if that is normal now.

@Sebastian-Roth
apparently i did not put the mac in properly. after hacing unintsalled the one who ip address was in the error log ther is still one in the DB

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 14046881
Server version: 5.5.56-MariaDB MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use fog;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [fog]> SELECT * FROM hostMAC WHERE hmMAC LIKE '%C8:D7:19:C2:E3:24%';
+------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+
| hmID | hmHostID | hmMAC             | hmDesc | hmPrimary | hmPending | hmIgnoreClient | hmIgnoreImaging |
+------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+
| 1317 |     1272 | c8:d7:19:c2:e3:24 |        | 1         |           |                |                 |
+------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+
1 row in set (0.01 sec)

MariaDB [fog]>

how would i go removing it from the DB? quickly looking through i might have others as well

@Sebastian-Roth said in CPU maxed when Storage nodes go down:

SELECT * FROM hostMAC WHERE hmMAC LIKE ‘%aa:bb:cc:dd:ee:ff%’;

i ran the command and it comes up empty set again. the only thing different between now and then was i had uninstalled the client on that machine. its still maxed out utilization though.

i have also noticed that during the hours when no one is in CPU utilization is really low. am i just not throwing enough resources at this or is something fundamentally wrong with my setup?

[btsdit@localhost ~]$ mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1831044
Server version: 5.5.56-MariaDB MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use fog;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [fog]> desc hostMAC;
+-----------------+---------------+------+-----+---------+----------------+
| Field           | Type          | Null | Key | Default | Extra          |
+-----------------+---------------+------+-----+---------+----------------+
| hmID            | int(11)       | NO   | PRI | NULL    | auto_increment |
| hmHostID        | int(11)       | NO   | MUL | NULL    |                |
| hmMAC           | varchar(59)   | NO   | UNI | NULL    |                |
| hmDesc          | longtext      | NO   |     | NULL    |                |
| hmPrimary       | enum('0','1') | NO   |     | NULL    |                |
| hmPending       | enum('0','1') | NO   |     | NULL    |                |
| hmIgnoreClient  | enum('0','1') | NO   |     | NULL    |                |
| hmIgnoreImaging | enum('0','1') | NO   |     | NULL    |                |
+-----------------+---------------+------+-----+---------+----------------+
8 rows in set (0.03 sec)

MariaDB [fog]> SELECT COUNT(hmMAC),hmID,hmHostID,hmMAC from hostMAC GROUP BY hmMAC HAVING COUNT(hmMAC)>1;
Empty set (0.03 sec)

MariaDB [fog]> quit

Bye

0_1537223105054_new_error_log.txt

apparently it was too large so i cut it down to this. but it should get the messge across.

UPDATE
i was able to throw another vcpu at the box and got it to less than 100% utilization. looks like all the dbs connected. i can see anything wrong with the main server but i do have a BUNCH of apache errors that i do not understand.[0_1537200874571_error_log](Uploading 100%)

I have a 2 fold issue.

1st is if one of my storage nodes goes down or cant connect to the server my server cpu maxes out. im not sure why and its a bit frustrating because of my next issue:
My fog server says it cant connect to 2 of my storage nodes even though they are up, i can SSH into them, and i have restated them and the server. but the frustrating part is i cant really dig into the logs because the web GUI is mostly unresponsive.

im running
Fog 1.5
Cent OS 7

Thanks for all the help! things seem to be back in order!

forgive me im not versed in sql, how do i grant myself the priveleges necessary to make that change?

My fog database computer CPU is being maxed so logging and changing tabs takes a while. the webpage crashes when i try to look at the logs.

this led me to try and run the Database Maintenance Commands listed here :
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Database_Maintenance_Commands

when i try to run this it tells me there are too many connections
ERROR 1040 (HY000): Too many connections
[btsdit@localhost ~]$

at this point im not sure what to do as i am not a SQL guy nor a Linux guy so i dont know where to look or what to look at to fix the connections issues

Stats of My box:
2 CPU with 2 cores @ 2ghz each
6 gigs ram
Cento os 7
fog version 1.5.0

that worked amazingly thank you very much!

One of my storage groups says it has a few active tasks and some qued even though i know they are not there anymore. is there a way to clear the graph or where can i go to cancel the tasks. there are none listed under the tasks button.