Re: Bug #13715 Updated: Cannot open 'multiple' database connections while running from shell

Hmm .. just a stupid question: are you absolutely positive that the second username/password is correct? What output do you get from mysql_error() ? - Markus On Tue, Nov 20, 2001 at 06:38:15PM -0000, chuckc@sonic.net wrote : > ID: 13715 > User updated by: chuckc@sonic.net > Reported By: chuckc@sonic.net > Old Status: Feedback > Status: Open > Bug Type: MySQL related > Operating System: > PHP Version: 4.0.5 > New Comment: > > Upgraded to 4.1.0RC3. Did not fix the problem or change any of the symptoms. > > The Install was very smooth though :) > > Chuckc > > Previous Comments: > ------------------------------------------------------------------------ > > [2001-11-20 12:52:44] mfischer@php.net > > Please try the latest RC and see if the problem persists: > > http://www.php.net/~zeev/php-4.1.0RC3.tar.gz > > Feedback. > > ------------------------------------------------------------------------ > > [2001-10-17 13:42:02] chuckc@sonic.net > > I'm trying to open multiple database connections to a 'non-local' mysql server > from the shell. > > It is important to note that this problem only occurs while running from the shell. When > running the same code from the web server, there is no problem. > > #!/usr/bin/php > <?php > > //connect to database 1 > $link_a = mysql_connect ("server", "uname1", "pword1") > or die ("Could not connect to db1\n"); > print ("Connected to db1 successfully\n"); > > //connect to database 2 > $link_b = mysql_connect ("server", "uname2", "pword2") > or die ("Could not connect to db2\n"); > print ("Connected to db2 successfully\n"); > > ?> > > It does not matter which database you try to connect to first. Regardless, the first > connection succeeds, the second connection fails. > > > Some output: > Connected to domains successfully > <br> > <b>Warning</b>: MySQL Connection Failed: Can't connect to MySQL server on > spiff (111) > in <b>./qtest.php</b> on line <b>23</b><br> > Could not connect to users db > > > I compiled PHP like so: > ./configure --with-mysql=/opt/mysql --with-gd --prefix=/opt/php-4.0.5 > --sysconfdir=/opt/php-4.0.5/etc --with-zlib-dir=/usr/local/ -- > with-dom=/usr/local/lib/libxml12.so --with-mcrypt=/usr/local/lib/libmcrypt.so > --with-cybercash=/opt/mck-3.2.0.4-linux --enable-force > -cgi-redirect > > Thanks, > chuckc@sonic.net > > > ------------------------------------------------------------------------ > > > > Edit this bug report at > http://bugs.php.net/?id=13715&edit=1 > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Markus Fischer, http://guru.josefine.at/~mfischer/ EMail: mfischer@guru.josefine.at PGP Public Key: http://guru.josefine.at/~mfischer/C2272BD0.asc PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0 -All your scripts are belong to Zend-