[Sqlrelay-discussion] I'm having to coninually restart sqlrelay. Why?

[Rob T. <rt...@li...>]

I'm afraid that I'm definitely a newbie using sqlrelay, so I'm not sure
what information to provide.

I built and installed sqlrelay on a RedHat AS3 system running apache,
php and perl.  The database I want to provide connection pooling for is
a mysql database running on a different machine.  I can start sqlrelay
using the linux service command (service sqlrelay start) and all is well
for a while.  Database accesses work both in php and perl.  Then
suddenly (and I don't know what causes the "suddenly"), both php and
perl apps hang while trying to retrieve data from the database. 
Sqlrelay has not stopped running and so I do a restart (service sqlrelay
restart), and everything is working again.

Any ideas how to figure out the cause of the hanging on the database
access?  This is the connection string from the sqlrelay.conf file:

      <connections>
                  <connection connectionid="db1"
string="user=dbuser;password=secret;db=webapps;host=dbhost.linfield.edu;port=3306;fakebinds=no;"
metric="1" behindloadbalancer="1"/>
       </connections>

Thanks,
Rob


-- 
Rob Tanner
UNIX Services Manager
Linfield College, McMinnville OR