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, [EMAIL PROTECTED] wrote :
> 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]
--
Markus Fischer, http://guru.josefine.at/~mfischer/
EMail: [EMAIL PROTECTED]
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-
--
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]
