Re: [Sqlrelay-discussion] SQL Relay with Sybase Connections

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Hi Carlos,

See comments below.

Dave
dav...@fi...

On 08/06/2010 02:36 PM, Carlos Vergara wrote:
>
>  I have two more questions unrelated to each other.  Any help is 
> appreciated.
>
> The first:  is there a way to configure sqlrsh to use some basic shell 
> editing features?  I am running sqlrsh on redhat with in a bash shell, 
> but I cannot use my arrow keys for history or even the backspace key 
> in sqlrsh.  I have to type my query perfectly each time or start 
> completely over.  If I could tell sqlrsh to use vim as my editor or if 
> it is reading from the $ENV, I would like to know.
>

If you have the readline development packages installed, then the 
configure script should detect them and enable those features in the 
build.  I believe on a redhat'ish machine, the package is 
readline-devel, and on an ubuntu, I think it's readline-dev.

> The second involves a possible bug, but I am just starting to dig into 
> the connection code.
>
> I have 4 logical databases on 1 database server so I have setup 4 sqlr 
> instances each with a different connection string to Sybase.  They 
> look something like this:
>
> <!-- MBX SQL Relay Instance SQLRelay_Instance_tran -->
>
> <instance id="SQLRelay_Instance_tran" port="9003" 
> socket="/tmp/_relay_db_tran.socket" dbase="sybase" connecti
>
> ons="10" maxconnections="250" maxqueuelength="1" growby="1" 
> idleclienttimeout="20" ttl="60" endofsession="commit" sessiont
>
> imeout="600" runasuser="vergarc" runasgroup="app" cursors="25" 
> authtier="listener" handoff="pass">
>
> <users>
>
> <user user="testuser" password="testpw"/>
>
> </users>
>
> <connections>
>
> <connection connectionid="SQLRelay_Instance_tran" 
> string="server=devChaos;user=testuser;password=testpw;db=db_tran"  
> metric="" behindloadbalancer=""/>
>
> </connections>
>
> </instance>
>
> <!-- MBX SQL Relay Instance SQLRelay_Instance_cache -->
>
> <instance id="SQLRelay_Instance_cache" port="9004" 
> socket="/tmp/_relay_db_cache.socket" dbase="sybase" connections="10" 
> maxconnections="250" maxqueuelength="1" growby="1" 
> idleclienttimeout="20" ttl="60" endofsession="commit" 
> sessiontimeout="600" runasuser="vergarc" runasgroup="app" cursors="25" 
> authtier="listener" handoff="pass">
>
> <users>
>
> <user user="testuser" password="testpw"/>
>
> </users>
>
> <connections>
>
> <connection connectionid="SQLRelay_Instance_cache" 
> string="server=devChaos;user=testuser;password=testpw;db=db_cache"  
> metric="" behindloadbalancer=""/>
>
> </connections>
>
> </instance>
>
> As you can see my setup starts 10 initial connections with a growby 1 
> as needed up to 250 connections.  The problem I am seeing is that the 
> first 10 connections work as normal.  However, when a new connection 
> is dynamically spawned it will connect to the DB Server fine, but it 
> is not connecting to the logical DB specified in the connection 
> string.   So I start getting SQL failures ("Table not found").  My 
> default Sybase user is set to login into the master table space if no 
> logical db is specified.
>
> If I issue a "use propval_cache" statement, it then sets the 
> connections to use the right logical database.  Shouldn't new 
> connections connect to the right logical database the same way the 
> first initial 10 connections do.  It seems like it is ignoring the 
> "db=propval_cache" portion of the connection string.  Has anyone else 
> encountered this?
>

I recently ran into something that might explain this.  If I fire up 
sybase, then fire up sqlrelay, then immediately try to run queries, I 
get errors, but then after a few seconds, everything starts to work.  I 
haven't looked too hard into it, but it could be the same thing.

I'm using sybase 15.  I never saw it in older versions.  It could be 
that after logging in, sybase requires a "settling" period now before 
queries will work.

When the sqlr-connection daemon first logs it, it runs a "use xxx" 
command to select the proper database.  It's possible that it's failing 
with recent versions of sybase, but that the connection daemon isn't 
detecting that properly.  I may need to make it loop, running that 
command until it works, and only then declare that it's logged in.

> CJ Vergara
>
> Lead Web Developer III
>
> Mindbrix, LP
>
> 8317 Whitley Rd.
>
> Fort Worth, TX 76148
>
> 817-488-4485
>
> / /
>
> /Confidentiality Note: This e-mail, and any attachment to it, contains 
> privileged and confidential information intended only for the use of 
> the individual(s) or entity named on the e-mail. If the reader of this 
> e-mail is not the intended recipient, you are hereby notified that 
> reading it is strictly prohibited. If you have received this e-mail 
> erroniously, please immediately return it to the sender and delete it 
> from your system. Thank you./
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by
>
> Make an app they can't live without
> Enter the BlackBerry Developer Challenge
> http://p.sf.net/sfu/RIM-dev2dev
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>
>
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com

_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
              http://www.doteasy.com 