Posts made by adukes40

@Wayne-Workman Ok, well I will go grab some lunch and then check on it.

should I still continue on going up to RC-11?

@Tom-Elliott mysql> update hosts set hostPubKey=‘’, hostSecToken=‘’, hostSecTime=‘0000-00-00 00:00:00’;
Query OK, 2590 rows affected (0.16 sec)
Rows matched: 6222 Changed: 2590 Warnings: 0

@Tom-Elliott mysql> describe hosts \G
*************************** 1. row ***************************
Field: hostID
Type: int(11)
Null: NO
Key: PRI
Default: NULL
Extra: auto_increment
*************************** 2. row ***************************
Field: hostName
Type: varchar(16)
Null: NO
Key: UNI
Default: NULL
Extra:
*************************** 3. row ***************************
Field: hostDesc
Type: longtext
Null: NO
Key:
Default: NULL
Extra:
*************************** 4. row ***************************
Field: hostIP
Type: varchar(25)
Null: NO
Key: MUL
Default: NULL
Extra:
*************************** 5. row ***************************
Field: hostImage
Type: int(11)
Null: NO
Key:
Default: NULL
Extra:
*************************** 6. row ***************************
Field: hostBuilding
Type: int(11)
Null: NO
Key:
Default: NULL
Extra:
*************************** 7. row ***************************
Field: hostCreateDate
Type: timestamp
Null: NO
Key:
Default: CURRENT_TIMESTAMP
Extra:
*************************** 8. row ***************************
Field: hostLastDeploy
Type: datetime
Null: NO
Key:
Default: NULL
Extra:
*************************** 9. row ***************************
Field: hostCreateBy
Type: varchar(50)
Null: NO
Key:
Default: NULL
Extra:
*************************** 10. row ***************************
Field: hostUseAD
Type: char(1)
Null: NO
Key: MUL
Default: NULL
Extra:
*************************** 11. row ***************************
Field: hostADDomain
Type: varchar(250)
Null: NO
Key:
Default: NULL
Extra:
*************************** 12. row ***************************
Field: hostADOU
Type: longtext
Null: NO
Key:
Default: NULL
Extra:
*************************** 13. row ***************************
Field: hostADUser
Type: varchar(250)
Null: NO
Key:
Default: NULL
Extra:
*************************** 14. row ***************************
Field: hostADPass
Type: varchar(250)
Null: NO
Key:
Default: NULL
Extra:
*************************** 15. row ***************************
Field: hostADPassLegacy
Type: longtext
Null: NO
Key:
Default: NULL
Extra:
*************************** 16. row ***************************
Field: hostProductKey
Type: longtext
Null: YES
Key:
Default: NULL
Extra:
*************************** 17. row ***************************
Field: hostPrinterLevel
Type: varchar(2)
Null: NO
Key:
Default: NULL
Extra:
*************************** 18. row ***************************
Field: hostKernelArgs
Type: varchar(250)
Null: NO
Key:
Default: NULL
Extra:
*************************** 19. row ***************************
Field: hostKernel
Type: varchar(250)
Null: NO
Key:
Default: NULL
Extra:
*************************** 20. row ***************************
Field: hostDevice
Type: varchar(250)
Null: NO
Key:
Default: NULL
Extra:
*************************** 21. row ***************************
Field: hostInit
Type: longtext
Null: YES
Key:
Default: NULL
Extra:
*************************** 22. row ***************************
Field: hostPending
Type: enum(‘0’,‘1’)
Null: NO
Key:
Default: NULL
Extra:
*************************** 23. row ***************************
Field: hostPubKey
Type: longtext
Null: NO
Key:
Default: NULL
Extra:
*************************** 24. row ***************************
Field: hostSecToken
Type: longtext
Null: NO
Key:
Default: NULL
Extra:
*************************** 25. row ***************************
Field: hostSecTime
Type: timestamp
Null: NO
Key:
Default: 0000-00-00 00:00:00
Extra:
*************************** 26. row ***************************
Field: hostPingCode
Type: varchar(20)
Null: YES
Key:
Default: NULL
Extra:
*************************** 27. row ***************************
Field: hostExitBios
Type: longtext
Null: YES
Key:
Default: NULL
Extra:
*************************** 28. row ***************************
Field: hostExitEfi
Type: longtext
Null: YES
Key:
Default: NULL
Extra:
*************************** 29. row ***************************
Field: hostEnforce
Type: enum(‘0’,‘1’)
Null: NO
Key:
Default: 1
Extra:
29 rows in set (0.00 sec)

@Tom-Elliott mysql> update hosts set hostSecToc=‘’;
ERROR 1054 (42S22): Unknown column ‘hostSecToc’ in ‘field list’

@Tom-Elliott root@MSDCATS09:~# mysql -u fog
ERROR 1045 (28000): Access denied for user ‘fog’@‘localhost’ (using password: NO)

@Wayne-Workman Computer CPU - Chrome hit 02% max…

here is best I could get you from TOP

@Wayne-Workman All graphs are now disabled. Still having issues connecting to home page. and still looks like this:

OK, all disabled except the master, but no change in performance.

@Tom-Elliott It is brutal, but I will try to disable the nodes first.Good news is that imaging actually works here at the master site. Takes a bit longer to get to the image part, but its actually makes it. Just anytime it needs to communicate to the DB it takes its sweet time.

BTW its almost feels like the slowness when one of the remote nodes can’t contact the master, and causes it to load slower. except in this situation when I see the dashboard, it cannot see any of the remote sites. It shows then on the graph, but this is all I see.

@Tom-Elliott Ok, so max_connections is now set to 300
when I type mysql it lets me in now. it was saying too many connections before. However the GUI is still the same. can’t load/slow. I haven’t updated yet though.

@Tom-Elliott Before I read this I found the my.cnf file. It currently shows:

#max_connections = 100

Do I also need to remove the # sign?

Ok, so I can just SVN up? and Where would I increase max_connections, and by how much?

On a side note, It seems the remote sites cant get past network boot. If I try to boot a machine from the local site where the master server is, it will work, and get to the FOG pxe screen, but its does take longer than normal.

@Sebastian-Roth I just learned how to tail a file and dump it to a file last night at class lol. IT WORKED. (sorry small linux golfclap for myself) Anyway here is the last 25 lines of the error.log

[Tue Sep 13 07:42:16.555758 2016] [:error] [pid 15621] [client 10.103.69.25:50786] PHP Warning: array_combine(): Both parameters should have an equal number of elements in /var/www/html/fog/lib/fog/fogbase.class.php on line 899
[Tue Sep 13 07:42:16.594268 2016] [:error] [pid 15532] [client 10.103.12.229:62782] PHP Warning: PDO::__construct(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 152
[Tue Sep 13 07:42:17.556278 2016] [:error] [pid 15742] [client 10.103.65.30:50729] PHP Warning: PDO::query(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 196
[Tue Sep 13 07:42:17.556331 2016] [:error] [pid 15742] [client 10.103.65.30:50729] PHP Warning: PDO::query(): Error reading result set’s header in /var/www/html/fog/lib/db/pdodb.class.php on line 196
[Tue Sep 13 07:42:17.556427 2016] [:error] [pid 15742] [client 10.103.65.30:50729] PHP Strict Standards: Non-static method FOGBase::debug() should not be called statically in /var/www/html/fog/lib/db/pdodb.class.php on line 208
[Tue Sep 13 07:42:17.897870 2016] [:error] [pid 15472] [client 10.104.12.57:50771] PHP Warning: PDO::query(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 196
[Tue Sep 13 07:42:17.897931 2016] [:error] [pid 15472] [client 10.104.12.57:50771] PHP Warning: PDO::query(): Error reading result set’s header in /var/www/html/fog/lib/db/pdodb.class.php on line 196
[Tue Sep 13 07:42:17.898069 2016] [:error] [pid 15472] [client 10.104.12.57:50771] PHP Strict Standards: Non-static method FOGBase::debug() should not be called statically in /var/www/html/fog/lib/db/pdodb.class.php on line 208
[Tue Sep 13 07:42:17.940687 2016] [:error] [pid 15710] [client 10.103.66.15:50724] PHP Warning: PDO::query(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 196
[Tue Sep 13 07:42:17.940745 2016] [:error] [pid 15710] [client 10.103.66.15:50724] PHP Warning: PDO::query(): Error reading result set’s header in /var/www/html/fog/lib/db/pdodb.class.php on line 196
[Tue Sep 13 07:42:17.940827 2016] [:error] [pid 15710] [client 10.103.66.15:50724] PHP Strict Standards: Non-static method FOGBase::debug() should not be called statically in /var/www/html/fog/lib/db/pdodb.class.php on line 208
[Tue Sep 13 07:42:18.074087 2016] [:error] [pid 15671] [client 10.103.13.134:50659] PHP Warning: PDO::query(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 196
[Tue Sep 13 07:42:18.074205 2016] [:error] [pid 15671] [client 10.103.13.134:50659] PHP Warning: PDO::query(): Error reading result set’s header in /var/www/html/fog/lib/db/pdodb.class.php on line 196
[Tue Sep 13 07:42:18.074304 2016] [:error] [pid 15671] [client 10.103.13.134:50659] PHP Strict Standards: Non-static method FOGBase::debug() should not be called statically in /var/www/html/fog/lib/db/pdodb.class.php on line 208
[Tue Sep 13 07:42:19.016080 2016] [:error] [pid 15558] [client 10.105.65.97:61732] PHP Warning: PDO::__construct(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 152
[Tue Sep 13 07:42:19.312576 2016] [:error] [pid 15577] [client 10.103.67.98:50743] PHP Warning: PDO::__construct(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 152
[Tue Sep 13 07:42:19.724552 2016] [:error] [pid 15773] [client 10.102.12.235:50724] PHP Warning: PDO::__construct(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 152
[Tue Sep 13 07:42:19.824479 2016] [:error] [pid 15667] [client 10.103.14.42:50786] PHP Warning: PDO::__construct(): MySQL server has gone away in /var/www/html/fog/lib/db/pdodb.class.php on line 152
[Tue Sep 13 07:42:21.895462 2016] [mpm_prefork:notice] [pid 15466] AH00169: caught SIGTERM, shutting down
[Tue Sep 13 07:42:41.586125 2016] [mpm_prefork:notice] [pid 1098] AH00163: Apache/2.4.7 (Ubuntu) OpenSSL/1.0.1f configured – resuming normal operations
[Tue Sep 13 07:42:41.587691 2016] [core:notice] [pid 1098] AH00094: Command line: ‘/usr/sbin/apache2’
[Tue Sep 13 07:42:55.604072 2016] [mpm_prefork:error] [pid 1098] AH00161: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting
[Tue Sep 13 08:47:15.270770 2016] [mpm_prefork:notice] [pid 1105] AH00163: Apache/2.4.7 (Ubuntu) OpenSSL/1.0.1f configured – resuming normal operations
[Tue Sep 13 08:47:15.359753 2016] [core:notice] [pid 1105] AH00094: Command line: ‘/usr/sbin/apache2’
[Tue Sep 13 08:47:31.006640 2016] [mpm_prefork:error] [pid 1105] AH00161: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting

ran df -h still showing 97G free on main drive. I will look for those logs here in a minute

Ok, watched it reboot this time. I am still getting very slow loading times, and sometimes

I did notice during the boot up, it has a few lines saying something about Apache, then went to the linux login screen. I didn’t have enough time to see what it said.

Where can I find that?

@Tom-Elliott I did issue a reboot command earlier, I will do it once more to be certain

Seems like it already is: