Re: [Sqlrelay-discussion] Could not open: /var/cache/sqlrelay/tmp/ipc/myid

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

thanks a lot Leandro, it works.
but now I have another problem: I can't connect with the database. I get:

antonio@HAL9000:~$ sqlr-start -id myid

Starting listener:
  sqlr-listener -id myid -config /usr/local/firstworks/etc/sqlrelay.conf

Starting 3 connections to db1 :
  sqlr-connection-odbc -id myid -connectionid db1 -config
/usr/local/firstworks/etc/sqlrelay.conf
Couldn't log into database.
*** glibc detected *** sqlr-connection-odbc: double free or corruption
(fasttop): 0x08052f00 ***
======= Backtrace: =========
/lib/tls/i686/cmov/libc.so.6[0xb7bf7a85]
/lib/tls/i686/cmov/libc.so.6(cfree+0x90)[0xb7bfb4f0]
/usr/lib/libiodbc.so.2(SQLFreeHandle+0x183)[0xb7f69d83]
sqlr-connection-odbc[0x804c590]
/usr/local/firstworks/lib/libsqlrconnection-0.39.4.so.1(_ZN18sqlrconnection_svr17logOutUpdateStatsEv+0x18)[0xb7f2330a]
/usr/local/firstworks/lib/libsqlrconnection-0.39.4.so.1(_ZN18sqlrconnection_svr15closeConnectionEv+0xc2)[0xb7f2237a]
sqlr-connection-odbc[0x804d0fa]
sqlr-connection-odbc[0x804d2db]
/lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe0)[0xb7ba2450]
sqlr-connection-odbc(_ZN14sqlrcursor_svr17checkForTempTableEPKcj+0x31)[0x804abe1]
======= Memory map: ========
08048000-0804f000 r-xp 00000000 08:03 8915075
/usr/local/firstworks/bin/sqlr-connection-odbc
0804f000-08050000 rw-p 00006000 08:03 8915075
/usr/local/firstworks/bin/sqlr-connection-odbc
08050000-08071000 rw-p 08050000 00:00 0          [heap]
b7a00000-b7a21000 rw-p b7a00000 00:00 0
b7a21000-b7b00000 ---p b7a21000 00:00 0
b7b54000-b7b5d000 r-xp 00000000 08:03 7578995
/lib/tls/i686/cmov/libnss_files-2.7.so
b7b5d000-b7b5f000 rw-p 00008000 08:03 7578995
/lib/tls/i686/cmov/libnss_files-2.7.so
b7b5f000-b7b67000 r-xp 00000000 08:03 7578999
/lib/tls/i686/cmov/libnss_nis-2.7.so
b7b67000-b7b69000 rw-p 00007000 08:03 7578999
/lib/tls/i686/cmov/libnss_nis-2.7.so
b7b69000-b7b7d000 r-xp 00000000 08:03 7578989
/lib/tls/i686/cmov/libnsl-2.7.so
b7b7d000-b7b7f000 rw-p 00013000 08:03 7578989
/lib/tls/i686/cmov/libnsl-2.7.so
b7b7f000-b7b81000 rw-p b7b7f000 00:00 0
b7b81000-b7b88000 r-xp 00000000 08:03 7578991
/lib/tls/i686/cmov/libnss_compat-2.7.so
b7b88000-b7b8a000 rw-p 00006000 08:03 7578991
/lib/tls/i686/cmov/libnss_compat-2.7.so
b7b8a000-b7b8c000 rw-p b7b8a000 00:00 0
b7b8c000-b7cd5000 r-xp 00000000 08:03 7578978    /lib/tls/i686/cmov/libc-2.7.so
b7cd5000-b7cd6000 r--p 00149000 08:03 7578978    /lib/tls/i686/cmov/libc-2.7.so
b7cd6000-b7cd8000 rw-p 0014a000 08:03 7578978    /lib/tls/i686/cmov/libc-2.7.so
b7cd8000-b7cdc000 rw-p b7cd8000 00:00 0
b7cdc000-b7ce6000 r-xp 00000000 08:03 7561280    /lib/libgcc_s.so.1
b7ce6000-b7ce7000 rw-p 0000a000 08:03 7561280    /lib/libgcc_s.so.1
b7ce7000-b7d0a000 r-xp 00000000 08:03 7578986    /lib/tls/i686/cmov/libm-2.7.so
b7d0a000-b7d0c000 rw-p 00023000 08:03 7578986    /lib/tls/i686/cmov/libm-2.7.so
b7d0c000-b7df4000 r-xp 00000000 08:03 8669242    /usr/lib/libstdc++.so.6.0.9
b7df4000-b7df7000 r--p 000e8000 08:03 8669242    /usr/lib/libstdc++.so.6.0.9
b7df7000-b7df9000 rw-p 000eb000 08:03 8669242    /usr/lib/libstdc++.so.6.0.9
b7df9000-b7dff000 rw-p b7df9000 00:00 0
b7dff000-b7e01000 r-xp 00000000 08:03 7578984    /lib/tls/i686/cmov/libdl-2.7.so
b7e01000-b7e03000 rw-p 00001000 08:03 7578984    /lib/tls/i686/cmov/libdl-2.7.so
b7e03000-b7e0c000 r-xp 00000000 08:03 7578982
/lib/tls/i686/cmov/libcrypt-2.7.so
b7e0c000-b7e0e000 rw-p 00008000 08:03 7578982
/lib/tls/i686/cmov/libcrypt-2.7.so
b7e0e000-b7e35000 rw-p b7e0e000 00:00 0
b7e35000-b7e3c000 r-xp 00000000 08:03 7579008    /lib/tls/i686/cmov/librt-2.7.so
b7e3c000-b7e3e000 rw-p 00006000 08:03 7579008    /lib/tls/i686/cmov/librt-2.7.so
b7e3e000-b7e3f000 rw-p b7e3e000 00:00 0
b7e3f000-b7e53000 r-xp 00000000 08:03 7579004
/lib/tls/i686/cmov/libpthread-2.7.so
b7e53000-b7e55000 rw-p 00013000 08:03 7579004
/lib/tls/i686/cmov/libpthread-2.7.so
b7e55000-b7e57000 rw-p b7e55000 00:00 0
b7e57000-b7edf000 r-xp 00000000 08:03 9937056
/usr/lib/librudiments-0.30.so.1.0.0
b7edf000-b7ee2000 rw-p 00087000 08:03 9937056
/usr/lib/librudiments-0.30.so.1.0.0
b7ee2000-b7efe000 r-xp 00000000 08:03 8847621
/usr/local/firstworks/lib/libsqlrclient-0.39.4.so.1.0.0
b7efe000-b7eff000 rw-p 0001c000 08:03 8847621
/usr/local/firstworks/lib/libsqlrclient-0.39.4.so.1.0.0
b7eff000-b7f0f000 r-xp 00000000 08:03 8847617
/usr/local/firstworks/lib/libsqlrutil-0.39.4.so.1.0.0
b7f0f000-b7f10000 rw-p 0000f000 08:03 8847617
/usr/local/firstworks/lib/libsqlrutil-0.39.4.so.1.0.0
b7f10000-b7f2a000 r-xp 00000000 08:03 8848309
/usr/local/firstworks/lib/libsqlrconnection-0.39.4.so.1.0.0
b7f2a000-b7f2b000 rw-p 0001a000 08:03 8848309
/usr/local/firstworks/lib/libsqlrconnection-0.39.4.so.1.0.0
b7f2b000-b7f2c000 rw-p b7f2b000 00:00 0
b7f2c000-b7f3d000 r-xp 00000000 08:03 9937166    /usr/lib/libiodbcinst.so.2.1.18
b7f3d000-b7f3e000 rw-p 00010000 08:03 9937166    /usr/lib/libiodbcinst.so.2.1.18
b7f3e000-b7f85000 r-xp 00000000 08:03 9937165    /usr/lib/libiodbc.so.2.1.18
b7f85000-b7f87000 rw-p 00046000 08:03 9937165    /usr/lib/libiodbc.so.2.1.18
b7f8e000-b7f95000 r--s 00000000 08:03 3457263
/usr/lib/gconv/gconv-modules.cache
b7f95000-b7f96000 rw-s 00000000 00:09 2687028    /SYSV010345b0 (deleted)
b7f96000-b7f98000 rw-p b7f96000 00:00 0
b7f98000-b7f99000 r-xp b7f98000 00:00 0          [vdso]
b7f99000-b7fb3000 r-xp 00000000 08:03 7561235    /lib/ld-2.7.so
b7fb3000-b7fb5000 rw-p 00019000 08:03 7561235    /lib/ld-2.7.so
bfda1000-bfdb6000 rw-p bffeb000 00:00 0          [stack]
Aborted

sqlr-connection-odbc failed to start.

Thanks to MP3.com for sponsoring:
	Clustered/Replicated database support.
	Perl API.
Thanks to FeedLounge for sponsoring:
	Query routing and filtering.

while my sqlrelay.conf's section is:

	<instance id="myid" port="9000" socket="/tmp/example.socket"
dbase="odbc" connections="3" maxconnections="15" maxqueuelength="5"
growby="1" ttl="60" endofsession="commit" sessiontimeout="600"
runasuser="antonio" runasgroup="antonio" cursors="5"
authtier="listener" handoff="pass" deniedips="" allowedips=""
debug="none" maxquerysize="65536" maxstringbindvaluelength="4000"
maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1"
listenertimeout="0" reloginatstart="false">
		<users>
			<user user="antonio" password="thepassword1"/>
		</users>
		<connections>
			<connection connectionid="db1"
string="user=sergio;password=thepassword2;server=138.66.220.19;db=anagrafe;dns=FreeTDS;"
metric="1" behindloadbalancer="no"/>
		</connections>
	</instance>

any help about this?
thanks again.

-- 
Antonio Fittipaldi
http://www.python-it.org # il punto di riferimento italiano per gli
appassionati di Python