Re: [Sqlrelay-discussion] Accessing SQL Server 2000 database using SQL Relay
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] Accessing SQL Server 2000 database using SQL Relay
|
From: Deepak M. <dee...@ma...> - 2005-11-17 07:28:32
|
Hi, I have tried all you mentioned. I saw that sqlr-connection daemon is not running. Here is result of commands. The output of "sqlr-start -id MyID" is Starting listener: sqlr-listener-debug -id MyID -config /usr/local/firstworks/etc/sqlrelay.conf & Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9703 Starting 3 connections to MyID : sqlr-connection-freetds-debug -id MyID -connectionid MyID -config /usr/local/firstworks/etc/sqlrelay.conf & Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.9705 sqlr-connection-freetds-debug -id MyID -connectionid MyID -config /usr/local/firstworks/etc/sqlrelay.conf & Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.9707 sqlr-connection-freetds-debug -id MyID -connectionid MyID -config /usr/local/firstworks/etc/sqlrelay.conf & Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.9709 Starting scaler: sqlr-scaler -id MyID -debug -config /usr/local/firstworks/etc/sqlrelay.conf cache manager already running. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. ------------------------------------------------------- The output of "ps -efa | grep sqlr" is root 8116 1 0 10:29 ? 00:00:00 sqlr-cachemanager nobody 9703 1 0 12:13 pts/5 00:00:00 sqlr-listener-debug -id MyID -config /usr/local/firstworks/etc/sqlrelay.conf nobody 9711 1 0 12:13 ? 00:00:00 sqlr-scaler -id MyID -debug -config /usr/local/firstworks/etc/sqlrelay.conf root 9724 8755 0 12:14 pts/5 00:00:00 grep sqlr ------------------------------------------------------ The file "/usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9703" contains following: 11/17/2005 12:13:43 IST listener [9703] : creating shared memory and semaphores 11/17/2005 12:13:43 IST listener [9703] : id filename: 11/17/2005 12:13:43 IST listener [9703] : /usr/local/firstworks/var/sqlrelay/tmp/MyID 11/17/2005 12:13:43 IST listener [9703] : creating shared memory... 11/17/2005 12:13:43 IST listener [9703] : creating semaphores... 11/17/2005 12:13:43 IST listener [9703] : waiting for client connection... 11/17/2005 12:13:59 IST listener [9703] : done waiting for client connection 11/17/2005 12:13:59 IST listener [9703] : de-registering handoff... 11/17/2005 12:13:59 IST listener [9703] : done de-registering handoff... 11/17/2005 12:13:59 IST listener [9703] : waiting for client connection... --------------------------------------------------------- The file "/usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.9705" and all other contains following with incremented sequence number : 11/17/2005 12:13:44 IST connection [9705] : getting unix socket... 11/17/2005 12:13:44 IST connection [9705] : opening /usr/local/firstworks/var/sqlrelay/tmp/sockseq 11/17/2005 12:13:44 IST connection [9705] : locking... 11/17/2005 12:13:44 IST connection [9705] : got sequence number: 34 11/17/2005 12:13:44 IST connection [9705] : writing new sequence number: 35 11/17/2005 12:13:44 IST connection [9705] : unlocking... 11/17/2005 12:13:44 IST connection [9705] : done getting unix socket 11/17/2005 12:13:44 IST connection [9705] : logging in... 11/17/2005 12:13:45 IST connection [9705] : done logging in 11/17/2005 12:13:45 IST connection [9705] : setting autocommit... 11/17/2005 12:13:45 IST connection [9705] : done setting autocommit 11/17/2005 12:13:45 IST connection [9705] : initializing cursors... 11/17/2005 12:13:45 IST connection [9705] : 0 ----- Original Message ----- From: "Firstworks/4access" To: sql...@li... Subject: Re: [Sqlrelay-discussion] Accessing SQL Server 2000 database using SQL Relay Date: Wed, 16 Nov 2005 11:43:11 -0500 What version of SQL Relay are you using? 0.36.4 should have printed out some more debug right after "incrementing session count". It's possible that the connection daemons didn't get started up properly. Either they shut down or hung at startup. They should have printed out an error at startup if there was a problem though. Do a ps -efa | grep sqlr-connection and see if they're running. If they're not running, the most common cause of a problem with the sqlr-connection daemons getting logged in is having the wrong tds version set in your freetds.conf file. I don't remember offhand what version you have to use with SQL Server 2000. I believe that valid versions are 4.2, 5.0, 7.0 and 8.0 though. You may want to try each of them. If you do all that and still have a problem, send me the output of the sqlr-start command and of "ps -efa | grep sqlr" and I'll see if I can spot the problem. Dave dav...@fi... On Mon, 2005-11-14 at 23:15 -0500, Deepak Mangal wrote: > > > > -- ___________________________________________________ > Play 100s of games for FREE! http://games.mail.com/ > > email message attachment > On Mon, 2005-11-14 at 23:15 -0500, Deepak Mangal wrote: > > Hi, > > > I am having problem to run queries to access SQL Server 2000 > database using SQL Relay. > -------------------------------------- > > I first started the SQL Relay as follows: > > > sqlr-start -id MyID > > > It worked fine. But when i tried to run the queries as follow: > > > sqlrsh -id MyID > > > SQLRShell - Version 0.22 > > Connected to: localhost:4000 as ele2006 > > > type help; for a help. > > > 0> select * from editorial_tempmaster; > > Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9475 > > > ---------------------------- > > No result was shown.The > /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9475 > contains: > > > 11/11/2005 16:39:10 IST listener [9475] : getting authentication... > > > 11/11/2005 16:39:10 IST listener [9475] : > listener-based authentication succeeded > > > 11/11/2005 16:39:10 IST listener [9475] : incrementing session count... > > > 11/11/2005 16:39:10 IST listener [9475] : 2 > > > ------------------ > > > Please help me!! > > > -- > > Deepak Mangal > > > ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion --=20 ___________________________________________________ Play 100s of games for FREE! http://games.mail.com/ |
