error 99(?) : can't connect to MySQL server

2007-02-06 Thread Fagyal Csongor
Hi, I have an interesting (a.k.a. frustrating) problem on MySQL 4.1.11. I try to connect to the database via DBD::mysql. Everything works - except in a few cases (once in every 1 occasions, approximately) I get: DBI connect('database=test:host=192.168.0.200','test',...) failed: Can't

Re: error 99(?) : can't connect to MySQL server

2007-02-06 Thread Nils Meyer
Hi Faygal, Fagyal Csongor wrote: for (1..5) { $dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} ); my $sth = $dbh-prepare('SELECT * FROM users'); } I think you are simply running out of available outgoing ports with that. Here is some more insight on that topic:

Re: error 99(?) : can't connect to MySQL server

2007-02-06 Thread Fagyal Csongor
Nils Meyer wrote: Hi Faygal, Fagyal Csongor wrote: for (1..5) { $dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} ); my $sth = $dbh-prepare('SELECT * FROM users'); } I think you are simply running out of available outgoing ports with that. Here is some more insight