Re: Connection problem after long idle periods

2006-02-10 Thread Mark Matthews
Michael Lai wrote: David Logan wrote: Michael Lai wrote: I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I can access the database from my JSPs with no problem except for one small issue. After a long delay (usually overnight), when someone first tries to access the da

Re: Connection problem after long idle periods

2006-02-09 Thread Michael Lai
David Logan wrote: Michael Lai wrote: I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I can access the database from my JSPs with no problem except for one small issue. After a long delay (usually overnight), when someone first tries to access the database, I would get

Re: Connection problem after long idle periods

2006-02-01 Thread David Logan
Michael Lai wrote: I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I can access the database from my JSPs with no problem except for one small issue. After a long delay (usually overnight), when someone first tries to access the database, I would get the following error:

Re: Connection Problem

2005-11-18 Thread Tripp Bishop
Michael, you hit the nail on the head. We added --skip-name-resolve and changed our connnection string to use the IP instead of FQDN and now things are working fine. It must have been something with our DNS/ISP since we changed nothing and that stuff is out of our control. The other thing was capt

Re: Connection Problem

2005-11-18 Thread Michael Stassen
Tripp Bishop wrote: Hello all, Suddenly in the last hour or so the connection speed between our webserver and database server has skyrocketed to the point that our site is no longer usable! Just trying to connection via the mysql client takes a long time. Once the connection is established, howe

Re: Connection problem

2005-05-24 Thread Warren Young
razat gupta wrote: But it gives an exception on the reach of 150 connections.It should allow us to create almost 500 connection. Use netstat on the server to find out how many connections are actually in use. You may find that your program is not properly closing down connnections, for inst

Re: connection problem with 4.1.7

2004-11-09 Thread P.V.Anthony
P.V.Anthony wrote: Hi, I am having an intermitten connection problem with MySQL 4.1.7 . Here is the setup. Intel P4 with HT Fedora Core 1 kernel 2.4.27 smp MySQL version 4.1.7 (RPM install from mysql.org) Qmail with vpopmail using mysql (www.qmailtoaster.com) Sometimes I cannot login to qmail to ch

RE: Connection problem!!! Windows to Linux

2003-07-16 Thread Rob A. Brahier
Aric, Are you running the linux version of your database on a shared web host? Some web hosts prevent you from using % as a host identifier for security reasons. I would also check to see if the permissions were defined at the proper level (in other words, have you set up access prvis for

RE: Connection problem!!! Windows to Linux

2003-07-16 Thread Rudy Metzger
If you manually updated the tables, use flush privileges to inform the DB server of your changes. Cheers /rudy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 11:23 To: [EMAIL PROTECTED] Subject: Re: Connection problem!!! Windows to Linux Aric

Re: Connection problem!!! Windows to Linux

2003-07-16 Thread Egor Egorov
Aric Cheah <[EMAIL PROTECTED]> wrote: > > I wrote a program application for windows which can add and delete data > from this application, it working fine with my own MySQL install on the > same windows OS.. Now I try to change the connection this dayabase to > the server whihc runnign under l

Re: Connection Problem

2002-05-27 Thread Mike(mickalo)Blezien
Will, In your $dbh connection handler, you need to change the host=localhost and database= to just localhost and the database name. $dbh = DBI->connect ("DBI:mysql:localhost;database_name", "**", "***", {PrintError => 0, RaiseError => 1}); >>On Fri, 24 May 2002 16:4

Re: Connection Problem - We're almost there...

2001-12-10 Thread Sinisa Milivojevic
Dr. Randy Frid writes: > I recently wrote in that I've tried everything in the book to connect to > MySQL but I'm still getting the infamous "socket (111) error. I've had a > few good suggestions and I think we are almost there. > > Here's where I am. > > With MySQLGUI trying to connect, I chan

Re: Connection problem

2001-10-30 Thread Lazy Dumbness
MYSQL> >>Hi! >> >>When i type: mysql -u franck -p then my password, it's ok. >> >>My machine's name is r-lx-collineau >> >>When i type mysql - h r-lx-collineau -u franck -p then my password, i have >>this message: >>"ERROR 1130: host 'r-lx-collineau' is not allowed to connect to this MySQL >>serve

Re: Connection problem

2001-10-30 Thread John Barton
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 check mysql.user, you probably have permission for franck@localhost, which succeeds when you omit the -h, but no permission for [EMAIL PROTECTED], so you fail when you specify that is where you are coming from. John Barton [EMAIL PROTECTED] http://jb