ID: 13715 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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, [EMAIL PROTECTED] ------------------------------------------------------------------------ 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
