libopendbx-devel — Help and discussion about OpenDBX

Re: [opendbx] Problems compiling 1.3.7 in OSX

[OpenDBX d. l. <lib...@li...>]

Hi Esteban

> I'm having problems compiling the last version with OSX, the linker
> throws "Undefined symbols: _bindtextdomain", this error did not
> happen in the previous version.
> Maybe there are some new dependency not default in OSX?

Could you please send me the complete output of ./configure && make? It seems 
that -lintl is missing in your case.

Thanks


Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

[opendbx] Problems compiling 1.3.7 in OSX

[OpenDBX d. l. <lib...@li...>]

Hi,
I'm having problems compiling the last version with OSX, the linker  
throws "Undefined symbols: _bindtextdomain", this error did not  
happen in the previous version.
Maybe there are some new dependency not default in OSX?

Thanks,
Esteban

"Querer es suscitar las paradojas"
Camus - El mito de Sísifo

Re: [opendbx] odbx_error_type

[OpenDBX d. l. <lib...@li...>]

Ahh okokok. Yes, you were very helpfull.
Very thanks!!


On Tue, Apr 22, 2008 at 4:50 AM, OpenDBX devel list <
lib...@li...> wrote:

> Hi Mariano
>
> > Hi! I have some dudes with this function.  I really don't understand its
> > use. I read this:
> > http://www.linuxnetworks.de/doc/index.php/OpenDBX/API/odbx_error_typebut i
> > am still don't know when to use it.
> > can someone explain me why should I use this function?
>
> Let's take odbx_query() (or any other function) as example, which returned
> an
> error. If the return value of odbx_error_type() is negative, you've hit a
> severe error like the connection to the server is broken. In this case you
> have to call odbx_unbind(), odbx_finish(), odbx_init() and odbx_bind() in
> this order to recreate the connection. Otherwise, if the return value was
> positive your statement might have been not understood by the database
> server. Here you can continue to send the next statement to the server
> without the need to recreate the connection.
>
> Hope I could help you
>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
>
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>

Re: [opendbx] odbx_error_type

[OpenDBX d. l. <lib...@li...>]

Hi Mariano

> Hi! I have some dudes with this function.  I really don't understand its
> use. I read this:
> http://www.linuxnetworks.de/doc/index.php/OpenDBX/API/odbx_error_type but i
> am still don't know when to use it.
> can someone explain me why should I use this function?

Let's take odbx_query() (or any other function) as example, which returned an 
error. If the return value of odbx_error_type() is negative, you've hit a 
severe error like the connection to the server is broken. In this case you 
have to call odbx_unbind(), odbx_finish(), odbx_init() and odbx_bind() in 
this order to recreate the connection. Otherwise, if the return value was 
positive your statement might have been not understood by the database 
server. Here you can continue to send the next statement to the server 
without the need to recreate the connection.

Hope I could help you


Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

[opendbx] odbx_error_type

[OpenDBX d. l. <lib...@li...>]

Hi! I have some dudes with this function.  I really don't understand its
use. I read this:
http://www.linuxnetworks.de/doc/index.php/OpenDBX/API/odbx_error_type but i
am still don't know when to use it.

can someone explain me why should I use this function?

thanks,

mariano

Re: [opendbx] The best way of upgrading openDBX

[OpenDBX d. l. <lib...@li...>]

ok....perfect. I have upgrated to the last version perfectly.

thanks

mariano

On Sat, Apr 19, 2008 at 8:29 AM, OpenDBX devel list <
lib...@li...> wrote:

> Hi Mariano
>
> > Hi everybody! I want to know which way you think is the best to upgrade
> > openDBX to another version. Should i need to write a script that removes
> > all the openDBX files or i can simply re compile and install ir?
>
> The best way is to use a packaging system like deb, rpm or OpenPKG.
>
> If you compiled and installed the sources by hand (via make && make
> install),
> you can do it again to replace the existing files (the files names are the
> same). This executes also the necessary ldconfig to update the linker.
>
> To clean up your system you can also execute a "make uninstall" on the old
> package.
>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
>
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>

Re: [opendbx] The best way of upgrading openDBX

[OpenDBX d. l. <lib...@li...>]

Hi Mariano

> Hi everybody! I want to know which way you think is the best to upgrade
> openDBX to another version. Should i need to write a script that removes
> all the openDBX files or i can simply re compile and install ir?

The best way is to use a packaging system like deb, rpm or OpenPKG.

If you compiled and installed the sources by hand (via make && make install), 
you can do it again to replace the existing files (the files names are the 
same). This executes also the necessary ldconfig to update the linker.

To clean up your system you can also execute a "make uninstall" on the old 
package.


Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

[opendbx] The best way of upgrading openDBX

[OpenDBX d. l. <lib...@li...>]

Hi everybody! I want to know which way you think is the best to upgrade
openDBX to another version. Should i need to write a script that removes all
the openDBX files or i can simply re compile and install ir?

Thanks

Mariano

[opendbx] OpenDBX 1.3.7 released

[OpenDBX d. l. <lib...@li...>]

Hi all

Many improvements and bugfixes are included in this release, both in the 
library itself as well as in the supplementary parts. It's recommended to all 
developers who are using the OpenDBX library to upgrade to the latest 
version. 

The existing function odbx_result_free() is deprecated in favor of the new 
odbx_result_finish() which is able to return error codes. Additionally, the 
C++ Stmt::bind() method of API was removed until the prepared statement API 
will arrive and the Stmt::escape() method was moved to the connection object. 

It's now also possible to write data into large objects in firebird and oracle 
backends but the oracle LOB implementation doesn't work at the moment. I 
would be glad if an oracle specialist would be able to have a look what could 
be wrong.

The new release is avalable at
http://linuxnetworks.de/opendbx/download/opendbx-1.3.7.tar.gz


Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

Re: [opendbx] OpenDBX in OSX

[OpenDBX d. l. <lib...@li...>]

Hi Esteban

> I'm working with Mariano in making a Squeak Plugin for OpenDBX.
> This mail is just for tell you that I could succesfuly compile
> OpenDBX (for postgresql) in OSX 10.4.1 (tiger).
> It was very easy and without any problems. So thanks for this great
> library and you can modify the web page adding the OSX on the tested
> platforms :)

Great! :-)


Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

[opendbx] OpenDBX in OSX

[OpenDBX d. l. <lib...@li...>]

Hi Norbert,
I'm working with Mariano in making a Squeak Plugin for OpenDBX.
This mail is just for tell you that I could succesfuly compile  
OpenDBX (for postgresql) in OSX 10.4.1 (tiger).
It was very easy and without any problems. So thanks for this great  
library and you can modify the web page adding the OSX on the tested  
platforms :)

Cheers,
Esteban

"Querer es suscitar las paradojas"
Camus - El mito de Sísifo

Re: [opendbx] OpenDBX + Oracle

[OpenDBX d. l. <lib...@li...>]

Grate! very thanks.

Sorry i didn't do it by myself but the problem is that as i know very little
about this ( C, openDBX, etc) , i don't want to wrong things. I don't feel
ready to edit something everybody looks.

Regards,

Mariano

On Feb 6, 2008 5:59 PM, OpenDBX devel list <
lib...@li...> wrote:

> On Wednesday 06 February 2008 16:00:40 Mariano Martinez Peck wrote:
> > What could be a good idea is to put in the wiki the paths we know at the
> > moment. We can put for each backend, not only which package (at least
> for
> > debian or ubuntu) have the things we need but also the directory we
> should
> > need for
> > CPPFLAGS and LDFLAGS. Perhaps with this, there is less people bothering
> you
> > like me jajajaja.
>
> I've added the flags for Oracle to the Wiki.
>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>

Re: [opendbx] OpenDBX + Oracle

[OpenDBX d. l. <lib...@li...>]

On Wednesday 06 February 2008 16:00:40 Mariano Martinez Peck wrote:
> What could be a good idea is to put in the wiki the paths we know at the
> moment. We can put for each backend, not only which package (at least for
> debian or ubuntu) have the things we need but also the directory we should
> need for
> CPPFLAGS and LDFLAGS. Perhaps with this, there is less people bothering you
> like me jajajaja.

I've added the flags for Oracle to the Wiki.


Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

Re: [opendbx] OpenDBX + Oracle

[Mariano M. P. <mar...@gm...>]

jajajajaj okok. I imagined something like that jajaja. P

What could be a good idea is to put in the wiki the paths we know at the
moment. We can put for each backend, not only which package (at least for
debian or ubuntu) have the things we need but also the directory we should
need for
CPPFLAGS and LDFLAGS. Perhaps with this, there is less people bothering you
like me jajajaja.

Thanks again.

Mariano



On Feb 6, 2008 9:30 AM, Norbert Sendetzky <no...@li...> wrote:

> On Wednesday 06 February 2008 12:40:13 Mariano Martinez Peck wrote:
> > As you may see, i am a bit curious with all this. So, i have another
> > question for you jaja. Suppose i want to look in my oracle installation
> by
> > myself where did he put the header and where did he put the client. Can
> i
> > do that? what files should i look? I mean, how do you know that XXX
> header
> > is what you need and that the client is in YYY directory ?? I am asking
> > this in case i have to install OTHER backend.
>
> That's highly dependent on the (commercial) database vendors.
> I found it after I checked where the function is declared (via grep on all
> newly installed header files) and which library contains the symbol (via
> nm
> on the libraries inside the created directories).
>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>

Re: [opendbx] OpenDBX + Oracle

[Norbert S. <no...@li...>]

On Wednesday 06 February 2008 12:40:13 Mariano Martinez Peck wrote:
> As you may see, i am a bit curious with all this. So, i have another
> question for you jaja. Suppose i want to look in my oracle installation by
> myself where did he put the header and where did he put the client. Can i
> do that? what files should i look? I mean, how do you know that XXX header
> is what you need and that the client is in YYY directory ?? I am asking
> this in case i have to install OTHER backend.

That's highly dependent on the (commercial) database vendors.
I found it after I checked where the function is declared (via grep on all 
newly installed header files) and which library contains the symbol (via nm 
on the libraries inside the created directories).


Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

Re: [opendbx] OpenDBX + Oracle

[Mariano M. P. <mar...@gm...>]

Excellent!!!!! Thank you.

As you may see, i am a bit curious with all this. So, i have another
question for you jaja. Suppose i want to look in my oracle installation by
myself where did he put the header and where did he put the client. Can i do
that? what files should i look? I mean, how do you know that XXX header is
what you need and that the client is in YYY directory ?? I am asking this in
case i have to install OTHER backend.

thanks.

mariano



On Feb 6, 2008 6:18 AM, Norbert Sendetzky <no...@li...> wrote:

> Hi Mariano
>
> > Hi Norbert! I have just installed Oracle 10g XE in my Ubuntu Gutsy
> Gibbon.
> > As you know i had already installed MySQL and Postgresql and they both
> > worked fine. But with them, i have to install the "dev" package which
> > contains the headers.I see in /usr/include and there is nothing related
> to
> > oracle. I neither know if the installation of Oracle has installed the
> > Oracle client library.
>
> Oracle installs the files on my PC in:
>
> headers: /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/
> libs: /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib
>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>

Re: [opendbx] OpenDBX + Oracle

[Norbert S. <no...@li...>]

Hi Mariano

> Hi Norbert! I have just installed Oracle 10g XE in my Ubuntu Gutsy Gibbon.
> As you know i had already installed MySQL and Postgresql and they both
> worked fine. But with them, i have to install the "dev" package which
> contains the headers.I see in /usr/include and there is nothing related to
> oracle. I neither know if the installation of Oracle has installed the
> Oracle client library.

Oracle installs the files on my PC in:

headers: /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/rdbms/public/
libs: /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib


Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

[opendbx] OpenDBX + Oracle

[Mariano M. P. <mar...@gm...>]

Hi Norbert! I have just installed Oracle 10g XE in my Ubuntu Gutsy Gibbon.
As you know i had already installed MySQL and Postgresql and they both
worked fine. But with them, i have to install the "dev" package which
contains the headers.I see in /usr/include and there is nothing related to
oracle. I neither know if the installation of Oracle has installed the
Oracle client library.

So, do you know which package or what is i need to install for Oracle?

very thanks

Mariano

Re: [opendbx] Problems generating .deb

[Mariano M. P. <mar...@gm...>]

Hi Norbert,

On Feb 3, 2008 8:53 PM, Norbert Sendetzky <no...@li...> wrote:

> Hi Mariano
>
> > Yes. I recompiled my application, but happends the same.
> > But it doesn't matter. Its something in my pc. I made symbolic links and
> > thats all.
>
> That may solve your problem on your local PC but I fear that you get the
> same
> problem if you copy your test binary application to another PC. The
> problem
> is that there's still referencing something the /usr/local/lib/ instead
> of /usr/lib/ - maybe you will find out later what it is. If you build
> the .deb package on another PC (not using "make install" before) and
> compile
> the test it will work for sure.
>

Ok. Perfect. That's why this doesn't care too much.


>
> > Norbert: i want to explain you what i understand about .deb with openDBX
> so
> > that you tell me if i am correct or not.
> >
> > When i generate a .deb, for example for mysql, i need to have openDBX
> > compiled and installed. To to this, i also need to have mySQL installed
> in
> > that pc. Now, i can give someone this .deb and he will be able to use
> > openDBX with mysql without having mySQL installed in the pc (pointing to
> > other ip, not localhost) .
>
> You don't need the OpenDBX library or the headers compiled or installed to
> build the .deb packages as they are generated from the source .tar.gz. For
> your required database backend you need the header files and client
> library
> for this database - you don't need the server package. You can give the
> generated .deb packages to another user who's using the same distribution
> and
> version. He only needs the database client library in addition (not the
> headers and not the server).
>

Ahhh okok. There was my misunderstanding. I thought that when i generate a
.deb for a specific RDBMS, it also put in there, the database header and the
database client library. I thought this could be the reason why you don't
have a deb package for Oracle (license problems).


>
> > So, supouse i have a special db server (PC 1) with oracle and an
> > application that uses openDBX (PC2) i don't need to have installed
> Oracle
> > in PC2. I just need a .deb generated for oracle. How i obtain my .deb
> for
> > oracle, is another problem.
>
> No, you don't need the Oracle server on PC2 but you need the Oracle client
> library on PC2 for the communication between PC2 and the Oracle server on
> PC1.
>
> Here the software stack on PC2 and how they depend on (Oracle as example):
>
> Your Application
> -------------------------
> OpenDBX library
> -------------------------
> OpenDBX oracle backend
> -------------------------
> Oracle client library
>
>

Ok. Perfect. Now i have understood everything! Thanks for the patient you
have.

Mariano


>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>

Re: [opendbx] Problems generating .deb

[Norbert S. <no...@li...>]

Hi Mariano

> Yes. I recompiled my application, but happends the same.
> But it doesn't matter. Its something in my pc. I made symbolic links and
> thats all.

That may solve your problem on your local PC but I fear that you get the same 
problem if you copy your test binary application to another PC. The problem 
is that there's still referencing something the /usr/local/lib/ instead 
of /usr/lib/ - maybe you will find out later what it is. If you build 
the .deb package on another PC (not using "make install" before) and compile 
the test it will work for sure.

> Norbert: i want to explain you what i understand about .deb with openDBX so
> that you tell me if i am correct or not.
>
> When i generate a .deb, for example for mysql, i need to have openDBX
> compiled and installed. To to this, i also need to have mySQL installed in
> that pc. Now, i can give someone this .deb and he will be able to use
> openDBX with mysql without having mySQL installed in the pc (pointing to
> other ip, not localhost) .

You don't need the OpenDBX library or the headers compiled or installed to 
build the .deb packages as they are generated from the source .tar.gz. For 
your required database backend you need the header files and client library 
for this database - you don't need the server package. You can give the 
generated .deb packages to another user who's using the same distribution and 
version. He only needs the database client library in addition (not the 
headers and not the server).

> So, supouse i have a special db server (PC 1) with oracle and an
> application that uses openDBX (PC2) i don't need to have installed Oracle
> in PC2. I just need a .deb generated for oracle. How i obtain my .deb for
> oracle, is another problem.

No, you don't need the Oracle server on PC2 but you need the Oracle client 
library on PC2 for the communication between PC2 and the Oracle server on 
PC1.

Here the software stack on PC2 and how they depend on (Oracle as example):

Your Application
-------------------------
OpenDBX library
-------------------------
OpenDBX oracle backend
-------------------------
Oracle client library



Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

Re: [opendbx] Problems generating .deb

[Mariano M. P. <mar...@gm...>]

On Feb 3, 2008 6:16 PM, Norbert Sendetzky <no...@li...> wrote:

> Hi Mariano
>
> > Yes, its true. I had manually installed the packages before installing
> > .deb. So i did what you tell me. I check the /usr/local/lib and
> /usr/lib/
> > directories doesn't contain any OpenDBX and i finally installed the .deb
> > packages. The result is the same: MY application, i mean, the test I do
> to
> > use openDBX looks at /usr/local/lib instead of /usr/lib. And obiously,
> it
> > doesn't find the files.
>
> Did you recompile your application while the libraries are only installed
> in /usr/lib/? It might be that the path to the old library is compiled
> into
> your application.


Yes. I recompiled my application, but happends the same.



>
>
> > The only extrange thing is that my /etc/ld.so.conf looks like this:
> >
> > include /etc/ld.so.conf.d/*.conf
> >
> > Thats all the file. And if i see /etc/ld.so.conf.d i can't find it. It
> > doesn't exist.
>
> /etc/ld.so.conf.d/ is a directory and the include statement above means:
> Add
> the contents of all files in /etc/ld.so.conf.d/ into ld.so.conf for the
> linker.
>


Good. Inside /etc/ld.so.conf.d/ i found the file libc.conf that was like
this:
# libc default configuration
/usr/local/lib

So, i changed to /usr/lib, save and then execute ldconfig. but i still have
the same error.

But it doesn't matter. Its something in my pc. I made symbolic links and
thats all.

Norbert: i want to explain you what i understand about .deb with openDBX so
that you tell me if i am correct or not.

When i generate a .deb, for example for mysql, i need to have openDBX
compiled and installed. To to this, i also need to have mySQL installed in
that pc. Now, i can give someone this .deb and he will be able to use
openDBX with mysql without having mySQL installed in the pc (pointing to
other ip, not localhost) .
So, supouse i have a special db server (PC 1) with oracle and an application
that uses openDBX (PC2) i don't need to have installed Oracle in PC2. I just
need a .deb generated for oracle. How i obtain my .deb for oracle, is
another problem.

is that right ?

Thanks.

mariano



>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>

Re: [opendbx] Problems generating .deb

[Norbert S. <no...@li...>]

Hi Mariano

> Yes, its true. I had manually installed the packages before installing
> .deb. So i did what you tell me. I check the /usr/local/lib and /usr/lib/
> directories doesn't contain any OpenDBX and i finally installed the .deb
> packages. The result is the same: MY application, i mean, the test I do to
> use openDBX looks at /usr/local/lib instead of /usr/lib. And obiously, it
> doesn't find the files.

Did you recompile your application while the libraries are only installed=20
in /usr/lib/? It might be that the path to the old library is compiled into=
=20
your application.

> The only extrange thing is that my /etc/ld.so.conf looks like this:
>
> include /etc/ld.so.conf.d/*.conf
>
> Thats all the file. And if i see /etc/ld.so.conf.d i can't find it. It
> doesn't exist.

/etc/ld.so.conf.d/ is a directory and the include statement above means: Ad=
d=20
the contents of all files in /etc/ld.so.conf.d/ into ld.so.conf for the=20
linker.


Norbert
=2D-=20
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

Re: [opendbx] Problems generating .deb

[Mariano M. P. <mar...@gm...>]

Hi Norbert

On Feb 3, 2008 9:28 AM, Norbert Sendetzky <no...@li...> wrote:

> Hi Mariano
>
> > Sorry. You are right. The problem is that when i compile and install
> > openDBX, it put some files in some places, but when i install it from
> deb
> > it put them in other place.
>
> Yes, that's true but not limited to the OpenDBX package. If you do
> a ./configure without --prefix on a .tar.gz package which uses automake as
> build tool, it wil always install the files to /usr/local/. This conforms
> to
> the filesystem hierarchy standard and don't mess up the rest of the
> system.
>
> Installing the distribution specific package is different because it's
> usually
> not self-compiled and must work not only on the machine where it was built
> but also on all others. Therefore the files are installed in /usr/ and are
> then available for all applications.
>

Good explanation! thanks.


>
> > Ok. Perfect. I installed that package and i now have the odbx so that to
> > compile applications who use opendDBX. Just by curious, how can i use
> > openDBX without a application? i mean, supose i don't have any
> application
> > who uses, can i use openDBX? How? using those scripts? Would you mine
> > giving me some example?
>
> I don't understand your question. OpenDBX is only a shared library which
> can't
> be used on it's own. You need at least some sort of application or a
> script
> in a scripting language which can provide access to the library functions
> to
> make the library do something useful.
>
> > *_odbx_lib_open(): Loading backend library failed:
> > /usr/local/lib/opendbx/libpgsqlbackend.so -
> > /usr/local/lib/opendbx/libpgsqlbackend.so: cannot open shared object
> file:
> > No such file or directory
> >
> > The same happends if i run the test you put in project (odbxtest.sh). I
> > have get it work if a generate a symbolic link. But it don't know why
> the
> > linker is looking in */usr/local/lib/ *and not in /usr/lib. Where i can
> > tell it where to search them? i put this in the makefile. The makefile
> of
> > my test is like this:
>
> You installed the files manually using "make install" and also installed
> the
> packages. Now the linker uses the wrong library file. Please remove all
> packages (apt-get remove libopendbx1), go the the directory where you did
> the "./configure", "make" and "make install" and do a "make uninstall". If
> you don't have this directory any more, unpack the .tar.gz package again,
> start the "./configure" script with the same options you used before and
> do
> a "make install". Then do a "make uninstall", remove the
> line "/usr/local/lib" from /etc/ld.so.conf an run ldconfig. Check if
> the /usr/local/lib and /usr/lib/ directories doesn't contain any OpenDBX
> files. At the end install the .deb package files again.
>


Yes, its true. I had manually installed the packages before installing .deb.
So i did what you tell me. I check the /usr/local/lib and /usr/lib/
directories doesn't contain any OpenDBX and i finally installed the .deb
packages. The result is the same: MY application, i mean, the test I do to
use openDBX looks at /usr/local/lib instead of /usr/lib. And obiously, it
doesn't find the files.

The only extrange thing is that my /etc/ld.so.conf looks like this:

include /etc/ld.so.conf.d/*.conf

Thats all the file. And if i see /etc/ld.so.conf.d i can't find it. It
doesn't exist.

Thanks,

Mariano


>
> > LDFLAGS = -L/usr/lib -L/usr/lib/opendbx -L/usr/lib/pkgconfig
>
> You don't need this line. /usr/lib is automatically used and the rest
> isn't
> necessary.
>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>

Re: [opendbx] Problems generating .deb

[Norbert S. <no...@li...>]

Hi Mariano

> Sorry. You are right. The problem is that when i compile and install
> openDBX, it put some files in some places, but when i install it from deb
> it put them in other place.

Yes, that's true but not limited to the OpenDBX package. If you do=20
a ./configure without --prefix on a .tar.gz package which uses automake as=
=20
build tool, it wil always install the files to /usr/local/. This conforms t=
o=20
the filesystem hierarchy standard and don't mess up the rest of the system.

Installing the distribution specific package is different because it's usua=
lly=20
not self-compiled and must work not only on the machine where it was built=
=20
but also on all others. Therefore the files are installed in /usr/ and are=
=20
then available for all applications.=20

> Ok. Perfect. I installed that package and i now have the odbx so that to
> compile applications who use opendDBX. Just by curious, how can i use
> openDBX without a application? i mean, supose i don't have any application
> who uses, can i use openDBX? How? using those scripts? Would you mine
> giving me some example?

I don't understand your question. OpenDBX is only a shared library which ca=
n't=20
be used on it's own. You need at least some sort of application or a script=
=20
in a scripting language which can provide access to the library functions t=
o=20
make the library do something useful.

> *_odbx_lib_open(): Loading backend library failed:
> /usr/local/lib/opendbx/libpgsqlbackend.so -
> /usr/local/lib/opendbx/libpgsqlbackend.so: cannot open shared object file:
> No such file or directory
>
> The same happends if i run the test you put in project (odbxtest.sh). I
> have get it work if a generate a symbolic link. But it don't know why the
> linker is looking in */usr/local/lib/ *and not in /usr/lib. Where i can
> tell it where to search them? i put this in the makefile. The makefile of
> my test is like this:

You installed the files manually using "make install" and also installed th=
e=20
packages. Now the linker uses the wrong library file. Please remove all=20
packages (apt-get remove libopendbx1), go the the directory where you did=20
the "./configure", "make" and "make install" and do a "make uninstall". If=
=20
you don't have this directory any more, unpack the .tar.gz package again,=20
start the "./configure" script with the same options you used before and do=
=20
a "make install". Then do a "make uninstall", remove the=20
line "/usr/local/lib" from /etc/ld.so.conf an run ldconfig. Check if=20
the /usr/local/lib and /usr/lib/ directories doesn't contain any OpenDBX=20
files. At the end install the .deb package files again.=20

> LDFLAGS =3D -L/usr/lib -L/usr/lib/opendbx -L/usr/lib/pkgconfig

You don't need this line. /usr/lib is automatically used and the rest isn't=
=20
necessary.


Norbert
=2D-=20
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

Re: [opendbx] Problems generating .deb

[Mariano M. P. <mar...@gm...>]

Hi Norbert

On Feb 2, 2008 10:34 PM, Norbert Sendetzky <no...@li...> wrote:

> Hi Mariano
>
> > *dpkg -i libopendbx1_1.2.3-1_i386.deb
> libopendbx1-mysql_1.2.3-1_i386.deb*
> >
> > And there it finished. If i see the files it had installed, i only have
> > this 3 files in /usr/lib/opendbx : libmysqlbackend.so,
> libmysqlbackend.so.1
> > and libmysqlbackend.so.1.1.0.
>
> You should also have /usr/lib/libopendbx.so.1.1.0
> and /usr/lib/libopendbx.so.1.1


Sorry. You are right. The problem is that when i compile and install
openDBX, it put some files in some places, but when i install it from deb it
put them in other place.


>
>
> > I olso look in /usr/local/include and /usr/include but i found nothing.
> I
> > can't find odbx.h
>
> This file is in the libopendbx1-dev packages.
>
> > So, i don't know if i had bad generated .debs or they ar ok but bad
> > installed. do you know what this can be?
>
> Please install the generated dev package if you want to compile
> applications
> using OpenDBX.
>
>
Ok. Perfect. I installed that package and i now have the odbx so that to
compile applications who use opendDBX. Just by curious, how can i use
openDBX without a application? i mean, supose i don't have any application
who uses, can i use openDBX? How? using those scripts? Would you mine giving
me some example?

Ahh once i installed the dev package, i could compile my example. but when i
try tu run it, i have this error:

*_odbx_lib_open(): Loading backend library failed:
/usr/local/lib/opendbx/libpgsqlbackend.so -
/usr/local/lib/opendbx/libpgsqlbackend.so: cannot open shared object file:
No such file or directory
_odbx_lib_open(): Loading backend library failed: libpgsqlbackend.so -
libpgsqlbackend.so: cannot open shared object file: No such file or
directory
odbx_init(): Loading backend library failed
*

The same happends if i run the test you put in project (odbxtest.sh). I have
get it work if a generate a symbolic link. But it don't know why the linker
is looking in */usr/local/lib/ *and not in /usr/lib. Where i can tell it
where to search them? i put this in the makefile. The makefile of my test is
like this:

COMPILER = gcc

CCFLAGS =    -O2 -g -Wall -fmessage-length=0 -I/usr/include

OBJS =        openDBXTest.o

LIBS = -lopendbx

TARGET =    openDBXTest

LDFLAGS = -L/usr/lib -L/usr/lib/opendbx -L/usr/lib/pkgconfig

$(TARGET):    $(OBJS)
    ${COMPILER} ${CCFLAGS} $(LDFLAGS) -o $(TARGET) $(OBJS) $(LIBS)

all:    $(TARGET)

clean:
    rm -f $(OBJS) $(TARGET)



As you can see, i a very newie in C. I programed in C years ago i don't
remember too much. I know these things are trivial.

Thanks.

Mariano



>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>