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

[David M. <dav...@fi...>]

That message means that the client software (the PHP script) couldn't
connect to the sqlrelay server.

What parameters are you using in your PHP code to connect to the server?

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.

David Muse
dav...@fi...

On Fri, 2007-09-07 at 17:12 +0800, Dante Mason wrote:
> Hello,
> 
> This is the 4th mail I sent this afternoon, 
> 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.
> 
> 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 getUserInfo,
> and that message is "[nativecode=Couldn't connect to the listener]".
> 
> But I didn't see any strange information from sqlr-connection.<pid>s.
> 
> here is my sqlrelay.conf (only the instance part)：
> <instance id="orcl_dev" port="9000" socket="/tmp/orcl_dev.socket"
> dbase="oracle8" connections="30" maxconnections="150"
> maxqueuelength="2" growby="1" ttl="600" endofsession="commit"
> sessiontimeout="600" runasuser="webuser" runasgroup="webuser"
> cursors="5" authtier="listener" handoff="pass" deniedips=""
> allowedips="" debug="connection" maxquerysize="65536"
> maxstringbindvaluelength="4000" maxlobbindvaluelength="71680"
> idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0"
> reloginatstart="yes">
> 
> 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.
> 
> Regards,
> 
> Dante Mason
> 
> -------------------------------------------------------------------------
> 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睥v7zf׋'"j̰Cך-yاyך'(