Rebooted…1 hour later still seeing same thing. I’m thinking there is something going on with apache. While i write this there is 259 httpd processes chewing up everything.
In the apache log, i get:
[Thu Oct 22 16:54:22 2015] [error] server reached MaxClients setting, consider raising the MaxClients setting
I just don’t know what would be causing this all of a sudden… Was something changed in the apache v/host settings in the past few weeks with the installer?
Adam
Sorry, I haven’t gotten back lately…had a sick child.
I have tried 5040 and 5042 this morning and I am still seeing almost complete CPU usage to the point that the web gui will talk 20-30 seconds to respond or not respond at all or not render most of the page.
I will try to go back to older ones to see where the problem was introduced.
I forgot to add.
We have 1892 hosts currently.
As for the logs…the only logs i am getting are:
[Tue Oct 20 16:09:34 2015] [error] [client 10.69.15.60] PHP Warning: mysqli::real_connect(): (08004/1040): Too many connections in /var/www/html/fog/lib/db/MySQL.class.php on line 29
This is when the client hits the server to see if it has any tasks.
If i set the max_connections in sql to something huge (2k plus), in about 45 minutes i will start to get that message. The connections just keep racking up and up…never go down…
I also tried setting “wait_timeout” and “interactive_timeout” to something like 10 seconds to try and make the connections go down…nada…connections keep rising.
I’m about to get off work, but first thing in the morning i am going to start bouncing around the svn versions to see if i can find which one might be causing this.
Thanks!
Adam
I understand what you are saying and i am happy to help try and figure out where it went south. My only question is the DB schema backtracking…
Do you know how far i can go back in revisions before i hit a change that will cause a problem? I know fog can’t downgrade so i want to make sure i don’t blow up the DB 
Adam
Just updated to svn 5020 and we are having a system resource overload. Mysql doesn’t seem to be dropping any connections now and apache has over 120+ children spawning when then computers check in with the client. From the time I started this topic to right now the sql connections have jumped from 300 to 1100…
mysql is running around 30-35% CPU and the httpd processes are chewing up the rest of the CPU.
This only started happening when we updated to 5020 from 4960 (but svn shows revision 4189?)
Ok, ok…i meant not there in the host screen or viewable(at least that i can find). 
So the table is still there in the DB i see so i am going to assume the function to set it is also still available?
I guess i just need to know if it is still viewable somewhere or if i need to add that field to the host screen like it was before.
Or do you know of a better way to do what I am asking currently?
Appreciate your help!
Adam
Hey guys,
Back in .32 there was an IP address field when viewing the host. In 1.2 that field is gone.
I added two lines of code to the hostname.php service checkin that grabbed the current IP address of the machine ‘$_SERVER[‘REMOTE_ADDR’]’ and then replaced the IP for that host with the current one in the DB. We did this since our campus is all DHCP and we have over 1000 computers all over the place we use in FOG.
This made it VERY easy when someone would move a computer and not change anything in the FOG system. We would see a different IP (Or campus has a different range for every building so the IP is a identifier for us) and be able to figure out where it went. It also helped to keep our management tools updates when the address changed.
Since that field is not there anymore…it kinda broke that…lol
So my request is…any chance of getting this back? It was exceptional useful for us back in .32 days.
Sorry Wolf…didn’t see yours. Yes, i was using MPI - non-resizeable for the image type as to try and not break the array while imaging.
Yea…that is what is required(mdadm). I looked for it and could not find it in init so that’s why i asked. I just know that RAID 1 is starting to become standard (we even have some laptops now with 2 drives in raid 1…lol) in ALOT of cases around here where i work. Just figured i would see if it was on anybody’s radar.
Thanks,
Hey guys,
Does anyone know if Intel RAID (fake raid) is supported?
I have a load of Optiplex 9020 that i need to image, but either when i pull or push, it will only grab or put to a single disk which breaks the raid 1 mirror.
Using upload/download-debug shows the two drives (sda sdb) but it doesn’t seemt to see the mapper device for the raid.
If it is not supported, can i ask that it be looked into? More and more systems we are getting are comming with RAID 1 (two drives) by default. And i can’t believe i am going to be the only one fighting this as time goes on.
Any ideas.
What Tom said is correct. Once the install is updated to current SVN, just upload and deploy.
I will say this. Getting to the lattest SVN will also fix ALOT of other issues too.
I’ve got one last tiny tiny issue that seems to just be a GUI display issue with the dev build.
When i click on Image Management -> List all images -> Click on any image
Everything pops up but i am getting a weird box at the top and it seems to be trying to ping all hosts in the system.
[CODE]
Pinging: image-
Progress: 77/1948
<*------------> 4%
[/CODE]
Any ideas?
Adam
[S]Unfortunally…we do not have email turned on (FOG_EMAIL ACTION) is unchecked.[/S]
Now that the right test is done…Yes, it now works without the * all the time. This is with the 2579 checkout.
Sorry about that!
We are trying that svn trunk now. On a note…the * issue does not happen on upload…only downloads does it happen.
On one other note. This line is repeating ALOT (~5-10 a second) in apache when just sitting at the dashboard doing nothing.
[CODE][Wed Nov 05 09:22:33 2014] [error] [client 10.16.0.153] PHP Warning: mysqli::select_db(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 74, referer: http://ulm-fog.ulm.edu/fog/management/index.php[/CODE]
I know it’s just a warning in PHP…but man it fills the logs up quick. Also, anything you do on the web interface (and links clicked, etc…) also shows up as the “line 74” error.
Here is my apache error log when sending my last image:
[CODE][Tue Nov 04 17:14:25 2014] [error] [client 10.96.14.226] PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /var/www/html/fog/lib/db/MySQL.class.php on line 164
[Tue Nov 04 17:14:25 2014] [error] [client 10.96.14.226] PHP Warning: mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /var/www/html/fog/lib/db/MySQL.class.php on line 69
[Tue Nov 04 17:14:25 2014] [error] [client 10.96.14.226] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 102
[Tue Nov 04 17:14:25 2014] [error] [client 10.96.14.226] PHP Warning: MySQL::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 103
[Tue Nov 04 17:14:25 2014] [error] [client 10.96.14.226] PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /var/www/html/fog/lib/db/MySQL.class.php on line 164
[Tue Nov 04 17:14:25 2014] [error] [client 10.96.14.226] PHP Warning: mysqli::escape_string(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 262
[/CODE]
I also have a load of other SQL errors from many other clients…all like the above but in slightly different orders.
That is spanning tree making sure there are no loops before allowing data to pass on the port. All managed switches have it turned on by default (which is a good thing). All our switches on campus have it, so if you have 3-4 swithces in a row that have to learn its new path, it does take longer then usual to come up then on unmanaged switches, hense our issue we were having.
Just pushed an image…
It’s still doing the same thing with the *…we also see that it is not updateing the progress bar of the task and the task doesn’t even look like it thinks its running…
This fixed it. It now gives our network enough time to actualy grab a DHCP address.
I really appreciate your help!