RC10 Broken Items on upgrade

[adukes40]

@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.

[adukes40]

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]

@adukes40 to test your theory just disable graph enabled on all nodes. For now it’s likely faster to do this than to try testing potentially many other unknowns. Of course this could all be fixed in RC 11 already but I doubt it. There is minimal reliance on nodes being available or not though. It really only needs “access” to see if the node is available or not. This shouldn’t hurt anything but it may delay load up of dashboard page by two seconds per node that’s disabled. This is because I have to check twice if the page is available to generate my URL lists for bandwidth and client checks. I’ll rework it tonight to generate the list of URLs only once on initial load up of the page. This should help limit redundant checks and improve overall availability

If you can

[adukes40]

@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.

[adukes40]

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

[Wayne Workman]

@adukes40 graph disabled and node disabled are two different things. Graph disabled just doesn’t report disk usage or bandwidth usage. The node still operates fully.

[adukes40]

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

[Wayne Workman]

@adukes40 check your cpu usage on your desktop when accessing the web interface. See how much power the browser is using.

Also, the output from top on the server when trying to access the dashboard would be useful.

[adukes40]

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

here is best I could get you from TOP

[Wayne Workman]

@adukes40 apache is working pretty hard. And I’m not positive but it looks like some of those apache processes have been running a long time. @Tom-Elliott @george1421?

[Tom Elliott]

@adukes40 said in RC10 Broken Items on upgrade:

Can you reset all host encryption data? Do this from mysql cli

Connect by:
mysql -u root fog

Run command
update hosts set hostSecToc='';

[adukes40]

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

[Tom Elliott]

@adukes40 please see same post after edit sorry I forgot to add root for the -u arg

[adukes40]

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

[Tom Elliott]

@adukes40 can you get output of describe hosts \G

[adukes40]

@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]

@adukes40 Run:
update hosts set hostPubKey='', hostSecToken='', hostSecTime='0000-00-00 00:00:00';

[adukes40]

@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

[Wayne Workman]

https://wiki.fogproject.org/wiki/index.php?title=FOG_Client#Manually_Reset_Encryption_On_ALL_Hosts

[Tom Elliott]

@adukes40 Now it’s a waiting game. I suspect you have some older new clients who were stuck in a loop trying to update their clients.