Thread: [Sqlrelay-discussion] error loading libraries
Brought to you by:
mused
Menu
▾
▴
sqlrelay-discussion
|
From: Pedro B. <pba...@in...> - 2006-04-10 14:04:54
|
Hi! =20 I=92m trying to connect to a sql server database but when I do=20 Sqlr-start =96id myid I get the following: =20 sqlr-connection-freetds: error while loading shared libraries: libsqlrconnection-0.37.so.1: cannot open shared object file: No such = file or directory =20 What can I do to solve this? =20 Thanks for any help! =20 =20 Pedro Barbosa, =20 Servi=E7o de Informa=E7=E3o de Gest=E3o=20 INESC Porto - Laborat=F3rio Associado =20 Campus da FEUP R. Dr. Roberto Frias, n=BA 378 4200-465 PORTO Ph :+351 22 209 4131 http://www.inescporto.pt =20 =20 |
|
From: Davide C. <dav...@re...> - 2006-04-10 14:07:09
|
Il giorno lun, 10/04/2006 alle 15.04 +0100, Pedro Barbosa ha scritto: > sqlr-connection-freetds: error while loading shared libraries: > libsqlrconnection-0.37.so.1: cannot open shared object file: No such > file or directory Hi, are you using packages from Debian Sid? --=20 Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Pedro B. <pba...@in...> - 2006-04-10 14:18:37
|
No, although I'm using FC4 i used the tarballs from http://sqlrelay.sourceforge.net/download.html Followed the typical steps and didn't change anything in the ./configure step. Pedro Barbosa -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of Davide Corio Sent: segunda-feira, 10 de Abril de 2006 15:07 To: sql...@li... Subject: Re: [Sqlrelay-discussion] error loading libraries Il giorno lun, 10/04/2006 alle 15.04 +0100, Pedro Barbosa ha scritto: > sqlr-connection-freetds: error while loading shared libraries: > libsqlrconnection-0.37.so.1: cannot open shared object file: No such > file or directory Hi, are you using packages from Debian Sid? -- Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Davide C. <dav...@re...> - 2006-04-10 14:24:58
|
Il giorno lun, 10/04/2006 alle 15.18 +0100, Pedro Barbosa ha scritto: > No, although I'm using FC4 i used the tarballs from > http://sqlrelay.sourceforge.net/download.html=20 >=20 > Followed the typical steps and didn't change anything in the ./configure > step. It seems to be a common problem (maybe a mistake with makefile) I think you could copy libraries manually to avoid this problem --=20 Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Pedro B. <pba...@in...> - 2006-04-10 14:35:49
|
But where should i put this file? I located it in the unpacked folder and in the install-destination folder (/usr/local/firstworks/lib/libsqlrconnection-0.37.so.1). I assume they are in the right folder so that must not be the problem :S Any thoughts? Pedro Barbosa -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of Davide Corio Sent: segunda-feira, 10 de Abril de 2006 15:25 To: sql...@li... Subject: RE: [Sqlrelay-discussion] error loading libraries Il giorno lun, 10/04/2006 alle 15.18 +0100, Pedro Barbosa ha scritto: > No, although I'm using FC4 i used the tarballs from > http://sqlrelay.sourceforge.net/download.html > > Followed the typical steps and didn't change anything in the ./configure > step. It seems to be a common problem (maybe a mistake with makefile) I think you could copy libraries manually to avoid this problem -- Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Davide C. <dav...@re...> - 2006-04-10 14:39:35
|
Il giorno lun, 10/04/2006 alle 15.35 +0100, Pedro Barbosa ha scritto: > But where should i put this file? >=20 > I located it in the unpacked folder and in the install-destination folder > (/usr/local/firstworks/lib/libsqlrconnection-0.37.so.1).=20 >=20 > I assume they are in the right folder so that must not be the problem :S >=20 > Any thoughts? you're right, they are in the right place. Maybe you have to correct your LD_LIBRARY_PATH=20 --=20 Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Pedro B. <pba...@in...> - 2006-04-10 14:50:07
|
Sorry but i didn't get that, where should i change the path to the libraries? I included it in my PATH variable but that doesn't do the trick. Pedro Barbosa -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of Davide Corio Sent: segunda-feira, 10 de Abril de 2006 15:40 To: sql...@li... Subject: RE: [Sqlrelay-discussion] error loading libraries Il giorno lun, 10/04/2006 alle 15.35 +0100, Pedro Barbosa ha scritto: > But where should i put this file? > > I located it in the unpacked folder and in the install-destination folder > (/usr/local/firstworks/lib/libsqlrconnection-0.37.so.1). > > I assume they are in the right folder so that must not be the problem :S > > Any thoughts? you're right, they are in the right place. Maybe you have to correct your LD_LIBRARY_PATH -- Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Davide C. <dav...@re...> - 2006-04-10 14:57:09
|
Il giorno lun, 10/04/2006 alle 15.48 +0100, Pedro Barbosa ha scritto: > Sorry but i didn't get that, where should i change the path to the > libraries? > I included it in my PATH variable but that doesn't do the trick. Hi, I think you have to do the same work, but with the LD_LIBRARY_PATH environment variable export LD_LIBRARY_PATH=3D$LD_LIBRARY_PATH:/usr/local/firstworks/lib --=20 Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Pedro B. <pba...@in...> - 2006-04-10 15:47:18
|
Thanks for that i can now start my instance :)
I installed this to have access from zope so I created the z sql relay
connection and I connect but whenever I try do a select statement I get a
"Page cannot be displayed" error.
In sqlrelay.conf I only changed from default dbase to "freetds" and
connections to "1".
In connections i have:
<connections>
<connection connectionid="db1"
string="sybase=/etc;user=user;password=password;server=dilas;db=database;"
/>
</connections>
Any help here?
Pedro Barbosa
-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Davide
Corio
Sent: segunda-feira, 10 de Abril de 2006 15:57
To: sql...@li...
Subject: RE: [Sqlrelay-discussion] error loading libraries
Il giorno lun, 10/04/2006 alle 15.48 +0100, Pedro Barbosa ha scritto:
> Sorry but i didn't get that, where should i change the path to the
> libraries?
> I included it in my PATH variable but that doesn't do the trick.
Hi,
I think you have to do the same work, but with the LD_LIBRARY_PATH
environment variable
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/firstworks/lib
--
Davide Corio dav...@re...
Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy
Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/
|
|
From: Pedro B. <pba...@in...> - 2006-04-10 16:29:04
|
I already solved the problem, thanks to anyone who where about to help :)
Does anyone ever had this error when querying a db: global name
'_SQLRCursor__getRowRange' is not defined ??
Pedro Barbosa
-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Pedro
Barbosa
Sent: segunda-feira, 10 de Abril de 2006 16:46
To: sql...@li...
Subject: RE: [Sqlrelay-discussion] error loading libraries
Thanks for that i can now start my instance :)
I installed this to have access from zope so I created the z sql relay
connection and I connect but whenever I try do a select statement I get a
"Page cannot be displayed" error.
In sqlrelay.conf I only changed from default dbase to "freetds" and
connections to "1".
In connections i have:
<connections>
<connection connectionid="db1"
string="sybase=/etc;user=user;password=password;server=dilas;db=database;"
/>
</connections>
Any help here?
Pedro Barbosa
-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Davide
Corio
Sent: segunda-feira, 10 de Abril de 2006 15:57
To: sql...@li...
Subject: RE: [Sqlrelay-discussion] error loading libraries
Il giorno lun, 10/04/2006 alle 15.48 +0100, Pedro Barbosa ha scritto:
> Sorry but i didn't get that, where should i change the path to the
> libraries?
> I included it in my PATH variable but that doesn't do the trick.
Hi,
I think you have to do the same work, but with the LD_LIBRARY_PATH
environment variable
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/firstworks/lib
--
Davide Corio dav...@re...
Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy
Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
|
|
From: Davide C. <dav...@re...> - 2006-04-10 16:49:13
|
Il giorno lun, 10/04/2006 alle 17.28 +0100, Pedro Barbosa ha scritto: > I already solved the problem, thanks to anyone who where about to help :) >=20 > Does anyone ever had this error when querying a db: global name > '_SQLRCursor__getRowRange' is not defined ?? Hi Pedro, I had the same problem. 1. edit /usr/lib/python2.3/site-packages/SQLRelay/PySQLRDB.py (this is the path on my debian servers) 2. search for this line: rc=3D__getRowRange(self.cur_row, size) end change it in: rc=3Dself.__getRowRange(self.cur_row, size) PS: you have to do the same for __getRow and similar method 3. recompile with: cd /usr/lib/python2.3/site-packages python ../compileall.py SQLRelay/ --=20 Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Pedro B. <pba...@in...> - 2006-04-11 09:37:24
|
Davide i change every line in that file that had __getRow and __getRowRange to self.__getRow and self.__getRowRange and recompile just like you said. I then reboot my zope instance and my sqlrelay conection but the errors remain :( It still states : Module Products.ZSQLRelayDA.SQLRelay.PySQLRDB, line 166, in fetchmany NameError: global name '_SQLRCursor__getRowRange' is not defined Is there anything else I have to do? Pedro Barbosa -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of Davide Corio Sent: segunda-feira, 10 de Abril de 2006 17:49 To: sql...@li... Subject: RE: [Sqlrelay-discussion] error loading libraries Il giorno lun, 10/04/2006 alle 17.28 +0100, Pedro Barbosa ha scritto: > I already solved the problem, thanks to anyone who where about to help :) > > Does anyone ever had this error when querying a db: global name > '_SQLRCursor__getRowRange' is not defined ?? Hi Pedro, I had the same problem. 1. edit /usr/lib/python2.3/site-packages/SQLRelay/PySQLRDB.py (this is the path on my debian servers) 2. search for this line: rc=__getRowRange(self.cur_row, size) end change it in: rc=self.__getRowRange(self.cur_row, size) PS: you have to do the same for __getRow and similar method 3. recompile with: cd /usr/lib/python2.3/site-packages python ../compileall.py SQLRelay/ -- Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Davide C. <dav...@re...> - 2006-04-11 09:42:10
|
Il giorno mar, 11/04/2006 alle 10.36 +0100, Pedro Barbosa ha scritto: > Davide i change every line in that file that had __getRow and __getRowRan= ge > to self.__getRow and self.__getRowRange and recompile just like you said. > I then reboot my zope instance and my sqlrelay conection but the errors > remain :( It still states : >=20 > Module Products.ZSQLRelayDA.SQLRelay.PySQLRDB, line 166, in fetchmany > NameError: global name '_SQLRCursor__getRowRange' is not defined >=20 >=20 > Is there anything else I have to do? umh...er... :) try to post here line 166, or better...the entire function ...and also the output of compileall.py maybe something went wrong --=20 Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Pedro B. <pba...@in...> - 2006-04-11 09:51:57
|
The function is :
def fetchmany(self, size=3DNone):
if not size:
size=3Dself.arraysize
num_rows=3DCSQLRelay.rowCount(self.cursor)
if size>=3Dnum_rows:
size=3Dnum_rows-1
rc=3D self.__getRowRange(self.cur_row, size) #line 166
self.cur_row=3Dsize
return rc
when I compile I get:
Listing SQLRelay/ ...
Compiling SQLRelay/PySQLRDB.py ...
Pedro Barbosa
-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of =
Davide
Corio
Sent: ter=E7a-feira, 11 de Abril de 2006 10:42
To: sql...@li...
Subject: RE: [Sqlrelay-discussion] error loading libraries
Il giorno mar, 11/04/2006 alle 10.36 +0100, Pedro Barbosa ha scritto:
> Davide i change every line in that file that had __getRow and
__getRowRange
> to self.__getRow and self.__getRowRange and recompile just like you =
said.
> I then reboot my zope instance and my sqlrelay conection but the =
errors
> remain :( It still states :
>=20
> Module Products.ZSQLRelayDA.SQLRelay.PySQLRDB, line 166, in fetchmany
> NameError: global name '_SQLRCursor__getRowRange' is not defined
>=20
>=20
> Is there anything else I have to do?
umh...er... :)
try to post here line 166, or better...the entire function
...and also the output of compileall.py
maybe something went wrong
--=20
Davide Corio dav...@re...
Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy
Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/
|
|
From: Davide C. <dav...@re...> - 2006-04-11 09:58:56
|
Il giorno mar, 11/04/2006 alle 10.51 +0100, Pedro Barbosa ha scritto: > Listing SQLRelay/ ... > Compiling SQLRelay/PySQLRDB.py ... strange, it should work...try to remove PySQLRDB.pyc before compiling --=20 Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Pedro B. <pba...@in...> - 2006-04-11 10:29:43
|
FINALLY :D Thanks for all your help Davide, the problem was that I had 2 = PySQLRDB.py files, one in the location you pointed and another over zope. I was changing the wrong one :s, sorry but I'm not very cleaver :) Once again thanks for all the help Cheers Pedro Barbosa -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of = Davide Corio Sent: ter=E7a-feira, 11 de Abril de 2006 10:59 To: sql...@li... Subject: RE: [Sqlrelay-discussion] error loading libraries Il giorno mar, 11/04/2006 alle 10.51 +0100, Pedro Barbosa ha scritto: > Listing SQLRelay/ ... > Compiling SQLRelay/PySQLRDB.py ... strange, it should work...try to remove PySQLRDB.pyc before compiling --=20 Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
|
From: Davide C. <dav...@re...> - 2006-04-11 10:31:57
|
Il giorno mar, 11/04/2006 alle 11.29 +0100, Pedro Barbosa ha scritto: > FINALLY :D >=20 > Thanks for all your help Davide, the problem was that I had 2 PySQLRDB.py > files, one in the location you pointed and another over zope. > I was changing the wrong one :s, sorry but I'm not very cleaver :) >=20 > Once again thanks for all the help you're welcome :) --=20 Davide Corio dav...@re... Redomino S.r.l. C.so Monte Grappa 90/b - 10145 Torino - Italy Tel: +39 011 19502871 - Fax: +39 011 19791122 - http://www.redomino.com/ |
