Re: [Sqlrelay-discussion] I need help -- Sometimes I got this : nativecode=Couldn't connect to the listener

[<ma...@si...>]

Thanks for your response.

I log the host,port number, user/password when that error occurs,
there's nothing different between sqlrelay.conf and settings in php scripts.

I wonder if it's caused by TIME_WAIT ?
So I do the following things that documented:
echo 30 > /proc/sys/net/ipv4/tcp_fin_timeout
echo 1 > /proc/sys/net/ipv4/tcp_tw_reuse
echo 1 > /proc/sys/net/ipv4/tcp_tw_recycle

but it still happens.

Here is how I make that error message comes up
(I wrote a simple bash script):
#!/bin/bash
for i in `seq 1 200`
do
   /usr/bin/php -f ./sr.php &
done

After I executed that bash script,=20
the frequency of "Couldn't connect to the listener" comes up
is about 1~2 times in 200 php executing.


On Fri, Sep 07, 2007 at 11:15:08AM -0400, David Muse wrote:
> That message means that the client software (the PHP script) couldn't
> connect to the sqlrelay server.
>=20
> What parameters are you using in your PHP code to connect to the server?
>=20
> A common mistake is to aim your PHP script at the oracle db rather than
> at SQL Relay.  Make sure that in the parameters, the host is set to
> whatever machine SQL Relay is running on, the port is set to 9000 and
> the user/password are set to whatever user/password you set up in the
> <users> section of your config file.
>=20
> David Muse
> dav...@fi...
>=20
> On Fri, 2007-09-07 at 17:12 +0800, Dante Mason wrote:
> > Hello,
> >=20
> > This is the 4th mail I sent this afternoon,=20
> > the content of previous 3 mails are the same as this one.
> > But some how gmail sent them in MIME. That was a mass.
> > I am really sorry sent suplicate content,
> > but I really need a direction to solve my problem.
> >=20
> > I use sqlrelay-0.39.2, and I did not use previous versions before.
> > I am using it to connect to oracle.
> > Everything goes fine till I got some complains from my users,
> > they claimed that they get the error message from php PEAR's getUserInf=
o,
> > and that message is "[nativecode=3DCouldn't connect to the listener]".
> >=20
> > But I didn't see any strange information from sqlr-connection.<pid>s.
> >=20
> > here is my sqlrelay.conf (only the instance part)=EF=BC=9A
> > <instance id=3D"orcl_dev" port=3D"9000" socket=3D"/tmp/orcl_dev.socket"
> > dbase=3D"oracle8" connections=3D"30" maxconnections=3D"150"
> > maxqueuelength=3D"2" growby=3D"1" ttl=3D"600" endofsession=3D"commit"
> > sessiontimeout=3D"600" runasuser=3D"webuser" runasgroup=3D"webuser"
> > cursors=3D"5" authtier=3D"listener" handoff=3D"pass" deniedips=3D""
> > allowedips=3D"" debug=3D"connection" maxquerysize=3D"65536"
> > maxstringbindvaluelength=3D"4000" maxlobbindvaluelength=3D"71680"
> > idleclienttimeout=3D"-1" maxlisteners=3D"-1" listenertimeout=3D"0"
> > reloginatstart=3D"yes">
> >=20
> > Is there any setting I should try to change in the config file?
> > Or, does this is apparently a network problem ?
> > I really appreciate any help.
> >=20
> > Regards,
> >=20
> > Dante Mason
> >=20
> > -----------------------------------------------------------------------=
--
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >>  http://get.splunk.com/
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> > &#0;&#0;5=E7=9D=A5v7zf=D7=8B'=17"=1Ej=CC=B0C=D7=9A-=16y=D8=A7y=0C=1D=D7=
=9A'(
>=20
>=20
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion