Turns out it was a problem with permissions, the machine was looking at itself as its external ip instead of loopback, and b/c the user was only allowed to login from localhost it was saying nay.
On the upside, mysql security works :) On December 19, 2003 12:35 am, [EMAIL PROTECTED] wrote: > -----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 -- 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
