-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Try also turning persistent connects on off. Also log into the db from which ever server your script runs on and try and run some queries from your application - this will help narrow down whether or not it's a db problem or a code/php/apache problem. Do you have mysql logging turned on? I would have it running before moving any further - quite often, with mysql, the answer is in the logs. In addition, do you know at what point in the application you lose the connection? You could just be running one nasty query that is disrupting the process...
Have you googled "Warning: mysql_connect(): Lost connection to MySQL server during query"? There are lots of results.
Jason Hayes - HHC wrote: | I had the same thing happen yesterday on one of my sites. I didn't have | to search for a cause too hard as I was also having several other issues | at the same time (no connection to SMTP or POP3 servers, very slow site | loading or time outs, etc.). | | I contacted the hosting company I use and got them to check on the | server. Turns out, two of the other accounts on the server were running | some massive scripts that were maxing the server out. When the host | nuked their accounts, the server went back to normal and no more lost | connections to MySQL. | | Could be that a similar thing is happening in your situation (server | overworked, bad connection to the server, or something like that). | | ------------------------ | Jason Hayes - Principal | Hayes Holdings Consulting | [EMAIL PROTECTED] / www.hayz.ws | Blog: www.hayz.ws/blog | #1936 - 246 Stewart Green SW | Calgary, AB, Canada T3H 3C8 | ------------------------ | | | |>-----Original Message----- |>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On |>Behalf Of Nick W |>Sent: Thursday, December 18, 2003 8:27 AM |>To: CLUG General |>Subject: [clug-talk] OT: PHP/MySQL question |> |>any idea what would cause this? |> |>Warning: mysql_connect(): Lost connection to MySQL server during query |> |>it doesnt seem to authenticate b/c it does the same whether login/pass | | are | |>correct or not. |>-- |>Nick W (nickw77 at shaw.ca) |>Registered Linux User #324288 (http://counter.li.org) |>MSN Messenger: [EMAIL PROTECTED] |>Yahoo: foolish_gambit |>ICQ: 303276221 |> |> |>_______________________________________________ |>clug-talk mailing list |>[EMAIL PROTECTED] |>http://clug.ca/mailman/listinfo/clug-talk_clug.ca | | | | _______________________________________________ | clug-talk mailing list | [EMAIL PROTECTED] | http://clug.ca/mailman/listinfo/clug-talk_clug.ca | |
- -- "No, mon, let's go home to Jamaica. I and I been in Babylon too long." -- Homer Simpson -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE/4kfXLeoSBberRbgRAjblAJ9KGKcii+j5UHekd/d/3dMzd2fCCQCfTg1h i/LReoZ5ItACsCD5IPc+ows= =9a1u -----END PGP SIGNATURE-----
_______________________________________________ clug-talk mailing list [EMAIL PROTECTED] http://clug.ca/mailman/listinfo/clug-talk_clug.ca
