Massive fan, first time poster -be gentle.
In a horrible rush (aren’t we all these days) and I’m hoping someone with MySQL query experience can help me avoid some serious rework I can’t afford mid-project.
I’m running 1.5.1 on a main server, with 10 storage nodes connected on sites with horrible bandwidth. The main server only provides pxe boot, using location plugin & wolbroadcast plugins to utilize node inits/kernals.
Anyway - after a server crash I rebuilt on 1.5.1 (I suspected 1.5.2 created some trouble for me - my bad - rushing).
I also was seeing some ‘odd’ behavior with location plugin - which resolved itself fine and I’m not concerned about.
However - my real issue is due to the odd behavior I witnessed, I thought - lets just make the default storage node not able to support any client connections for imaging, just in case - thus I set its max clients to 0.
Pretty certain I’ve now run into this issue here: https://forums.fogproject.org/topic/11725/storage-node-vanished-after-upgrading-to-1-5-2
My question - can anyone supply me with a MySQL query to run to change my "default’ storage node max clients back from 0 to 2 (or some real number) so I can then view my storage nodes again?
I realize upgrading to 1.5.2 working branch would fix, however I’m too time poor to do that mid-project across all my nodes… I’m imaging machines at night in my spare time outside work as it is…
Any help much appreciated for the MySQL noobie.