sqlrelay-discussion — Discussion of topics related to SQL Relay

Re: [Sqlrelay-discussion] performance statistics

[Rodney H. <rh...@et...>]

Here is a short thread regarding the implementation of statistics gathering.

Unfortunately Im not able to work on this anytime soon, hopefully this 
information will come in handy to others looking to add this most desirable 
feature to sqlrelay.










Hey Rodney,

Sorry to take forever to get back to you.

I'd be happy to accept whatever work you're interested in doing on this.

In the past, I had considered implementing it using a block of shared
memory and then having a monitor program that just reads the values from
the shared memory segment and displays them on the screen.

The listener already maintains a block of shared memory to coordinate
communication between the listener and the connections.  There's a
struct in src/common/defines.h called shmdata that defines the contents
of the shared memory segment.  You could add any parameters that you'd
like to keep track of to that struct and then the connections could
increment/decrement them as necessary.

The sqlrconnection_svr class has a member variable called idmemoryptr
that points to the shared memory segment.  So, for instance, you could
add a parameter called querycount and increment it using
idmemoryptr->querycount++.

I'd recommend against coordinating access to the parameters with
semaphores, it would add way too much overhead.  The program that
monitors the parameters should just poll them periodically.

Those are my ideas.  Give it a shot and keep me posted  :)

Dave
dav...@fi...

On Thu, 2006-02-02 at 08:32 -0700, Rodney Holm wrote:

 >> David,
 >>
 >> I would be interested in working to implement this feature.  That is of
 >> course if you are willing to accept the help.
 >>
 >> Im new to sqlrelay and would like to get some guidance from you before
 >> embarking down this path.  Have you given some thought to where it would
 >> make the most sense to add the statistics gathering and retrieval?
 >>
 >> Since the connection processes can dynamically increase and decrease
 >> depending on configuration and load, storing the information at that
 >> level is probably not an option.
 >>
 >> What are your thoughts?
 >>
 >> thanks
 >> rodney
 >>
 >>
 >> David Muse wrote:
 >
 >>> > Sorry, it's not currently possible to get live statistics.  It's on the
 >>> > TODO list, but I haven't implemented it yet.
 >>> >
 >>> > Dave
 >>> > dav...@fi...
 >>> >
 >>> > On Tue, 2006-01-31 at 11:43 -0700, Rodney Holm wrote:
 >>> >
 >>
 >>>> >>Greetings.
 >>>> >>
 >>>> >>Is it currently possible to obtain live statistics for the defined
 >>>> >>instances?
 >>>> >>
 >>>> >>What I would like to see is things like:
 >>>> >># of active connections
 >>>> >># of queries sent
 >>>> >># of rows returned
 >>>> >># of ORA errors
 >>>> >># of requests handled by the listener
 >>>> >>
 >>>> >>Is that information stored somewhere currently and just not accessible
 >>>> >>or would the storage mechanisms need to be built into the objects?
 >>>> >>
 >>>> >>thanks
 >>>> >>rodney

Devananda wrote:
> Hello, list!
> 
> I've been testing sqlrelay for a few days, and would like the 
> development team here to be able to start using it soon, but one thing 
> is bothering me -- I have not found a way to monitor a running instance 
> of sqlrelay (or any of it's components), short of turning on debugging 
> and doing a lot of grep'ing and counting in the log files (which 
> wouldn't be feasible on a production system).
> 
> So ... does anyone know of a tool or method whereby I can see statistics 
> about the current performance of sqlrelay? ie, open connections, memory 
> usage, # of connections created, # of connections timed out, # of 
> connections waiting? I'm hoping for something similar to 'apachectl 
> status', though simple text output of a lot of variables (similar to 
> 'mysql> show status;') would be a huge help.
> 
> 
> Thanks in advance!
> 
> Devananda
> 
> 
> -------------------------------------------------------
> 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

[Sqlrelay-discussion] performance statistics

[Devananda <kar...@ya...>]

Hello, list!

I've been testing sqlrelay for a few days, and would like the 
development team here to be able to start using it soon, but one thing 
is bothering me -- I have not found a way to monitor a running instance 
of sqlrelay (or any of it's components), short of turning on debugging 
and doing a lot of grep'ing and counting in the log files (which 
wouldn't be feasible on a production system).

So ... does anyone know of a tool or method whereby I can see statistics 
about the current performance of sqlrelay? ie, open connections, memory 
usage, # of connections created, # of connections timed out, # of 
connections waiting? I'm hoping for something similar to 'apachectl 
status', though simple text output of a lot of variables (similar to 
'mysql> show status;') would be a huge help.


Thanks in advance!

Devananda

Re: Re: [Sqlrelay-discussion] Help please . Error Size of a Query -Segmentation Fault.

[Rony C. <coh...@gm...>]

Thank You Dave!
Amazing!
Rony

Re: [Sqlrelay-discussion] Bind (bytea) with Postgresql

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

SQL Relay 0.36.4 doesn't support postgresql 8's bind syntax.  I added it
in 0.37.  If you upgrade to 0.37, it should work.

In 0.36, you could write the query like:

UPDATE queue_job_info SET job_request = :1 WHERE job_id = :2

And SQL Relay will rewrite the query, substituting in the bind values.
However, there were other bugs in 0.36.4 that could cause blob data to
get truncated and/or cause errors if it had single or double-quotes in
it, so I'd recommend upgrading to 0.37.

Dave
dav...@fi...

On Fri, 2006-04-07 at 11:51 +0200, Marcel C. Pantigny wrote:
> Hi,
> 
> I use sqlrelay 36.4 with the programming language C.
> 
> with the following code:
> 
> /* C-CODE */
> FILE *file;
> char *fileName="input.dat";
> long id = 1;
> unsigned int len = 14112;
> 
> file = fopen(fileName, "r");
> char data[len+1];
> if( fread(data, 1, len, file) != len )
>      printf ("NOK\n");
> data[len]=NULL;
> fclose(file);
> 
> sqlrcur_prepareQuery(cur, "UPDATE data SET info = ? WHERE id = ?");
> sqlrcur_inputBindBlob(cur, "1", data, len);
> sqlrcur_inputBindLong(cur, "2", id);
> if (!sqlrcur_executeQuery(cur))
>        printf (" %s\n", sqlrcur_errorMessage(cur));
> /* C-CODE END */
> 
> This returns an error (cur.getErrorMessage):
> 
> ERROR:  syntax error at or near "WHERE" at character 42
> 
> Attempted Query:
> UPDATE queue_job_info SET job_request = ? WHERE job_id = ?
> 
> For what do I make wrong around blob to read/write?
> 
> Thanks and Regards,
> Marcel C. Pantigny

Re: [Sqlrelay-discussion] Help please . Error Size of a Query - Segmentation Fault.

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

In SQL Relay 0.37, the max query size is confiugrable in the
sqlrelay.conf file.

In older versions, it was set by a macro in the src/common/defines.h
file and there was a bug in older versions that could cause a crash if
the query was too large.  If you can upgrade to 0.37, it should solve
your problems.  If you can't upgrade, then you should be able to edit
src/common/defines.h and change the line:

#define MAXQUERYSIZE 32768

to

#define MAXQUERYSIZE 565536

and rebuild/reinstall to increase the maximum query size.

Dave
dav...@fi...


On Tue, 2006-04-11 at 09:51 +0200, Rony Cohen wrote:
> Hello Everybody,
> 
> I'm working with Sql Relay 0.35, with Mysq & PHP5.
> 
> I've got a problem on querying with 2 MEDIUMBLOB inside.
> 
> If My blobs is under 10ko the sent query is OK. 
> But if it's bigger I've probs : segmentation faults. 
> 
> I did :
> <!ATTLIST instance maxquerysize CDATA "565536"
> >
> 
> for being sure about the size... but this don't work....
> 
> I need to work with 2 blobs of 150k each....
> 
> Can someone help me ??
> 
> Thank you very much.
> 
> 
> Rony

RE: [Sqlrelay-discussion] error loading libraries

[Davide C. <dav...@re...>]

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/

RE: [Sqlrelay-discussion] error loading libraries

[Pedro B. <pba...@in...>]

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/

RE: [Sqlrelay-discussion] error loading libraries

[Davide C. <dav...@re...>]

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/

RE: [Sqlrelay-discussion] error loading libraries

[Pedro B. <pba...@in...>]

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/

RE: [Sqlrelay-discussion] error loading libraries

[Davide C. <dav...@re...>]

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/

RE: [Sqlrelay-discussion] error loading libraries

[Pedro B. <pba...@in...>]

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/

[Sqlrelay-discussion] Help please . Error Size of a Query - Segmentation Fault.

[Rony C. <coh...@gm...>]

Hello Everybody,

I'm working with Sql Relay 0.35, with Mysq & PHP5.

I've got a problem on querying with 2 MEDIUMBLOB inside.

If My blobs is under 10ko the sent query is OK.
But if it's bigger I've probs : segmentation faults.

I did :

<!*ATTLIST* instance maxquerysize *CDATA* "565536">

for being sure about the size... but this don't work....

I need to work with 2 blobs of 150k each....

Can someone help me ??

Thank you very much.

Rony

RE: [Sqlrelay-discussion] error loading libraries

[Davide C. <dav...@re...>]

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/

RE: [Sqlrelay-discussion] error loading libraries

[Pedro B. <pba...@in...>]

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

RE: [Sqlrelay-discussion] error loading libraries

[Pedro B. <pba...@in...>]

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/

RE: [Sqlrelay-discussion] error loading libraries

[Davide C. <dav...@re...>]

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/

RE: [Sqlrelay-discussion] error loading libraries

[Pedro B. <pba...@in...>]

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/

[Sqlrelay-discussion] Segmentation Error, on a query with SQL-RELAY.

[Rony C. <coh...@gm...>]

Hello Everybody,

I'm working with Sql Relay, with Mysq & PHP5.

I've got a problem on querying with 2 MEDIUMBLOB inside.

If My blobs is under 10ko the sendquery is OK.
But if it's bigger I've probs with segmentation.

I did :

<!*ATTLIST* instance maxquerysize *CDATA* "565536">


for be sure about the size... but that don't work....

Can someone help ??

Thank you very much.

Rony

RE: [Sqlrelay-discussion] error loading libraries

[Davide C. <dav...@re...>]

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/

RE: [Sqlrelay-discussion] error loading libraries

[Pedro B. <pba...@in...>]

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/

[Sqlrelay-discussion] (no subject)

[Rony C. <coh...@gm...>]

coh...@gm...

RE: [Sqlrelay-discussion] error loading libraries

[Davide C. <dav...@re...>]

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/

RE: [Sqlrelay-discussion] error loading libraries

[Pedro B. <pba...@in...>]

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/

Re: [Sqlrelay-discussion] error loading libraries

[Davide C. <dav...@re...>]

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/

[Sqlrelay-discussion] error loading libraries

[Pedro B. <pba...@in...>]

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