Hi,
I looked into the archive and I coun't find anything that looks like my
problem.
I was using mysql 3.22.x without no problems, but I needed the replication
feature, so I upgraded it to 3.23.36. Where was my scenario :
http server. apache 1.3.19 + mod_perl 2.25 + php 3.0.18.
sql1 -> mysql 3.23.36 (server id 1, this is the Master RW)
sql2 -> mysql 3.23.36 (server id 2, slave RO)
Then I wrote a new function into my php scripts to redirect some selects to
sql2 server, and it worked just well.
In this very moment, everything is running just fine, except for many
connection timeout/error reading communication packets in my sql2.err
logfile.
As it says on the manual I recompiled my apache suite to use the new mysql
libraries.
Then all my php3 scripts tried to connect on both servers. Even if the
scripts has NO calls to server 2, it tried to connect on it. I saw thousands
of permission denied entrys in my sql2 server, because sql2 server has
diferent usernames than sql1.
Any tip on it? I'm using persistente connections in php and php is compiled
with enable-track-vars.
I really can figure out if it is a mysql lib problem or an php3 problem.
Thanks alot and sorry for the bad english..
Thiago Lima.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
