List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:August 18 2002 10:05pm
Subject:Re: Another one on lost connections( using web interface)
View as plain text  
PHP's more than likely just loosing persistent connections to the DB.

It's a coding thing I think... You need to call mysql_connect() on every
page where you need to use the database, even if you use mysql_pconnect().

If there's a mysql specific error, I think MySQL would most definitely write
something to the error log...

Tweaking your my.cnf and php.ini may also help you cause here...

--
me


----- Original Message -----
From: "Defryn, Guy" <G.P.Defryn@stripped>
To: <mysql@stripped>
Sent: Sunday, August 18, 2002 11:25 PM
Subject: Another one on lost connections( using web interface)


>
> I also have a problem with lost connections.
> I have small mysql database (version 3.23.49 on FreeBSD 4.5)
>
> I have created a website interface to enter and retrieve data.
> I used ASP to do this. Sometimes when I go to the website
> I get the error "can't connect or lost connection to server."
>
> The mysql install has been done with default settings and
> There are never more than 2 people using the database at the same time.
>
> I also created a PHP interface to the database and I received the same
error.
>
> The error does not occur all the time and when it occurs it goes away by
refreshing the web browser.
>
> I never have any problems when working on the mysql server from the
command line.
>
> Any ideas?
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread117497@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-savage=savage.za.org@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
Another one on lost connections( using web interface)Guy Defryn19 Aug
  • Re: Another one on lost connections( using web interface)Chris Knipe19 Aug