libopendbx-devel — Help and discussion about OpenDBX

Re: [opendbx] Problems generating .deb

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

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=
=2E1
> and libmysqlbackend.so.1.1.0.

You should also have /usr/lib/libopendbx.so.1.1.0=20
and /usr/lib/libopendbx.so.1.1

> 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 application=
s=20
using OpenDBX.


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

Re: [opendbx] Problems generating .deb

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

Norbert:  I'll answer in the mail.


> > Good. I installed that dependency, and there were generated this files:
> > libopendbx1_1.2.3-1_i386.deb, libopendbx1-dev_1.2.3-1_i386.deb,
> > libopendbx1-mysql_1.2.3-1_i386.deb and
> libopendbx1-pgsql_1.2.3-1_i386.deb
> >
> > When i try to execute libopendbx1_1.2.3-1_i386.deb i have this error:
> >
> > Error: dependency is not satisfiable libopendbx1-backends
> >
> > And if i want to execute any of the other three
> > (libopendbx1-dev_1.2.3-1_i386.deb, libopendbx1-mysql_1.2.3-1_i386.deb or
> > libopendbx1-pgsql_1.2.3-1_i386.deb) i have this error:
> >
> > Error: dependency is not satisfiable libopendbx1
> >
> > This error is logic because i couldn't install de first one
> > (libopendbx1-dev_1.2.3-1_i386.deb). But i don't know how to solve the
> first
> > error.
>
> The answer is simple. Install the main library and at least one backend
> together:
>
> dpkg -i libopendbx1_1.2.3-1_i386.deb libopendbx1-mysql_1.2.3-1_i386.deb
>
>

I did what you said:

*dpkg -i libopendbx1_1.2.3-1_i386.deb libopendbx1-mysql_1.2.3-1_i386.deb*
I seems it finish ok. I copy the results, in case you see something wrong:

*mariano@mariano-ubuntu:~/Documents/OpenDBX$ sudo dpkg -i
libopendbx1_1.2.3-1_i386.deb libopendbx1-mysql_1.2.3-1_i386.deb
[sudo] password for mariano:
(Reading database ... 145455 files and directories currently installed.)
Preparing to replace libopendbx1 1.2.3-1 (using
libopendbx1_1.2.3-1_i386.deb) ...
Unpacking replacement libopendbx1 ...
Preparing to replace libopendbx1-mysql 1.2.3-1 (using
libopendbx1-mysql_1.2.3-1_i386.deb) ...
Unpacking replacement libopendbx1-mysql ...
Setting up libopendbx1-mysql (1.2.3-1) ...
Setting up libopendbx1 (1.2.3-1) ...

Processing triggers for libc6 ...
ldconfig deferred processing now taking place
*

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.
I olso look in /usr/local/include and /usr/include but i found nothing. I
can't find odbx.h

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?

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

> Norbert: Sorry i am bothering you a lot . The thing is that i am very
> interesting i am trying to make it work with all RDBMS, in all pcs, in
> different formats.

Don't worry. I also want to get it working for your.

> Good. I installed that dependency, and there were generated this files:
> libopendbx1_1.2.3-1_i386.deb, libopendbx1-dev_1.2.3-1_i386.deb,
> libopendbx1-mysql_1.2.3-1_i386.deb and libopendbx1-pgsql_1.2.3-1_i386.deb
>
> When i try to execute libopendbx1_1.2.3-1_i386.deb i have this error:
>
> Error: dependency is not satisfiable libopendbx1-backends
>
> And if i want to execute any of the other three
> (libopendbx1-dev_1.2.3-1_i386.deb, libopendbx1-mysql_1.2.3-1_i386.deb or
> libopendbx1-pgsql_1.2.3-1_i386.deb) i have this error:
>
> Error: dependency is not satisfiable libopendbx1
>
> This error is logic because i couldn't install de first one
> (libopendbx1-dev_1.2.3-1_i386.deb). But i don't know how to solve the fir=
st
> error.

The answer is simple. Install the main library and at least one backend=20
together:

dpkg -i libopendbx1_1.2.3-1_i386.deb libopendbx1-mysql_1.2.3-1_i386.deb


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

Re: [opendbx] Problems generating .deb

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

Norbert: Sorry i am bothering you a lot . The thing is that i am very
interesting i am trying to make it work with all RDBMS, in all pcs, in
different formats.

I answer in the mail.

On Jan 31, 2008 8:50 AM, Norbert Sendetzky <no...@li...> wrote:

> Hi Mariano
>
> > 1) I can specify n backends (and the wiki shows me how) but i don't know
> > how to specify n CPPFLAGS and LDFLAGS parametres. I tried a bit, using
> > logic, and i figurated that i have to do this:
> >
> > CPPFLAGS="-I/usr/include/postgresql -I/usr/include/mysql"
> > LDFLAGS="-L/usr/lib/postgresql -L/usr/lib/mysql" ./configure
> > --with-backends="pgsql mysql"
>
> Thanks, I've added this to the Wiki.



I have already saw it. Thanks to take this into consideration.


>
>
> > 2) Image i have now postgresql and mysql. And then i want to add oracle.
> My
> > question is, do i have to recompile and install openDBX with the 3
> backends
> > (mySQL, postgresql and oracle) or i can just add oracle? If i can, how?
>
> If you do it by by using ./configure && make && make install, you will
> install
> all backends again. By using a .deb or .rpm package you can install the
> packages separately and install e.g. the oracle backend later on.
>

Excelente. That was exactly my doubt. Thanks.



>
> > dh_installman -plibopendbx1 debian/tmp/usr/share/man/man?/*
> > debian/tmp/usr/share/man/man?/*: No such file or directory at
> > /usr/bin/dh_installman line 120, <COMPAT_IN> line 1.
> > make: *** [binary-arch] Error 2
>
> You should have gotten a warning by ./configure that docbook2x isn't
> installed. I've updated the Wiki section about the requirements for the
> .deb
> packages and how to fulfill them:
>
> http://linuxnetworks.de/doc/index.php/OpenDBX/Setup#.deb_packages
>
>
Good. I installed that dependency, and there were generated this files:
libopendbx1_1.2.3-1_i386.deb, libopendbx1-dev_1.2.3-1_i386.deb,
libopendbx1-mysql_1.2.3-1_i386.deb and libopendbx1-pgsql_1.2.3-1_i386.deb

When i try to execute libopendbx1_1.2.3-1_i386.deb i have this error:

Error: dependency is not satisfiable libopendbx1-backends

And if i want to execute any of the other three
(libopendbx1-dev_1.2.3-1_i386.deb, libopendbx1-mysql_1.2.3-1_i386.deb or
libopendbx1-pgsql_1.2.3-1_i386.deb) i have this error:

Error: dependency is not satisfiable libopendbx1

This error is logic because i couldn't install de first one
(libopendbx1-dev_1.2.3-1_i386.deb). But i don't know how to solve the first
error.

Do you know what this can be?

Sorry again for beeing so...i can't finde the word in english jajaja

Regards,

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

> 1) I can specify n backends (and the wiki shows me how) but i don't know
> how to specify n CPPFLAGS and LDFLAGS parametres. I tried a bit, using
> logic, and i figurated that i have to do this:
>
> CPPFLAGS=3D"-I/usr/include/postgresql -I/usr/include/mysql"
> LDFLAGS=3D"-L/usr/lib/postgresql -L/usr/lib/mysql" ./configure
> --with-backends=3D"pgsql mysql"

Thanks, I've added this to the Wiki.

> 2) Image i have now postgresql and mysql. And then i want to add oracle. =
My
> question is, do i have to recompile and install openDBX with the 3 backen=
ds
> (mySQL, postgresql and oracle) or i can just add oracle? If i can, how?

If you do it by by using ./configure && make && make install, you will inst=
all=20
all backends again. By using a .deb or .rpm package you can install the=20
packages separately and install e.g. the oracle backend later on.

> dh_installman -plibopendbx1 debian/tmp/usr/share/man/man?/*
> debian/tmp/usr/share/man/man?/*: No such file or directory at
> /usr/bin/dh_installman line 120, <COMPAT_IN> line 1.
> make: *** [binary-arch] Error 2

You should have gotten a warning by ./configure that docbook2x isn't=20
installed. I've updated the Wiki section about the requirements for the .de=
b=20
packages and how to fulfill them:

http://linuxnetworks.de/doc/index.php/OpenDBX/Setup#.deb_packages


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

[opendbx] Problems generating .deb

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

Hi!

First of all, i am happy because i had compiled and installed openDBX for
mySQL and postgresql. When i did this, i had 2 questions:

1) I can specify n backends (and the wiki shows me how) but i don't know how
to specify n CPPFLAGS and LDFLAGS parametres. I tried a bit, using logic,
and i figurated that i have to do this:

CPPFLAGS="-I/usr/include/postgresql -I/usr/include/mysql"
LDFLAGS="-L/usr/lib/postgresql -L/usr/lib/mysql" ./configure
--with-backends="pgsql mysql"

I think maybe its a good idea to put an example like this in the wiki.

2) Image i have now postgresql and mysql. And then i want to add oracle. My
question is, do i have to recompile and install openDBX with the 3 backends
(mySQL, postgresql and oracle) or i can just add oracle? If i can, how?


Finally, now i have mysql and postgresql working, i wanted to generate a
.deb distribution. So, i installed fakeroot package. When i tried to run the
command: fakeroot debian/rules binary i had the error : "make: dh_testdir:
Command not found". To get this work, i installed the package debhelper.
When i run the command again, i had this error:

dh_testdir
dh_testroot
dh_installman -plibopendbx1 debian/tmp/usr/share/man/man?/*
debian/tmp/usr/share/man/man?/*: No such file or directory at
/usr/bin/dh_installman line 120, <COMPAT_IN> line 1.
make: *** [binary-arch] Error 2


So, do you know what can this problem be? I am using Ubuntu Gutsy Gibbon.

Thanks in advance,

Mariano

Re: [opendbx] Very simple tutorial

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

On Jan 29, 2008 5:13 AM, Norbert Sendetzky <no...@li...> wrote:

> Hi Mariano
>
> > Yes. I was going to do a distribution in deb and rpm package. I first
> > wanted all of use can compile and install openDBX. But it is in my plan,
> to
> > generate a binary package.
> > When i tryied to download and install the .deb of postgresql i had an
> error
> > trying to resolve dependencies and that's why i then tried to compile
> it.
>
> The packages on the website are built on Debian. For Ubuntu you have to
> build
> themselfes.
>

Ok...perfect. I thought that maybe they work, because sometimes there are
some .deb that work fine in ubuntu. I will do a binary distribution for
ubuntu then. When they are ready, i can send them to you if you like.


>
> > I need to install openDBX in a Mac with OS Tiger. is there andy problem
> or
> > it should works well?
>
> Nobody reported a problem yet but I don't know if anybody already tried
> that.
> I'm keen on getting your response and will help you in case of problems.
>

Ok....greate!

Mariano


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

Re: [opendbx] Very simple tutorial

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

Hi Mariano

> Yes. I was going to do a distribution in deb and rpm package. I first
> wanted all of use can compile and install openDBX. But it is in my plan, =
to
> generate a binary package.
> When i tryied to download and install the .deb of postgresql i had an err=
or
> trying to resolve dependencies and that's why i then tried to compile it.

The packages on the website are built on Debian. For Ubuntu you have to bui=
ld=20
themselfes.

> I need to install openDBX in a Mac with OS Tiger. is there andy problem or
> it should works well?

Nobody reported a problem yet but I don't know if anybody already tried tha=
t.=20
I'm keen on getting your response and will help you in case of problems.


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

Re: [opendbx] error while loading shared libraries

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

OK. Thanks Norbert.

I will see where it is installed and check if /etc/ld.so.conf  is correct.

thanks

mariano

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

> On Friday 25 January 2008 12:24:02 Mariano Martinez Peck wrote:
> > ./Prueba: error while loading shared libraries: libopendbx.so.1: cannot
> > open shared object file: No such file or directory
> >
> > LDFLAGS = -L/usr/local/lib -L/usr/local/lib/opendbx
> > -L/usr/local/lib/pkgconfig
>
> You've installed libopendbx in /usr/local/lib instead of /usr/lib.
> If /usr/local/lib isn't configured in /etc/ld.so.conf, it won't be found
> by
> the library loader (like on your second PC).
>
> > If i look in my filesystem, i don't have that file. Neither i in MY pc
> > where this example work well. The file i DO have is  libopendbx.so.1.1.0
>
> The library loader is smart and knows that ibopendbx.so.1.1.0 is
> compatible
> with ibopendbx.so.1 and therefore uses ibopendbx.so.1.1.0.
>
> Regards,
>
>
> 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] error while loading shared libraries

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

On Friday 25 January 2008 12:24:02 Mariano Martinez Peck wrote:
> ./Prueba: error while loading shared libraries: libopendbx.so.1: cannot
> open shared object file: No such file or directory
>
> LDFLAGS =3D -L/usr/local/lib -L/usr/local/lib/opendbx
> -L/usr/local/lib/pkgconfig

You've installed libopendbx in /usr/local/lib instead of /usr/lib.=20
If /usr/local/lib isn't configured in /etc/ld.so.conf, it won't be found by=
=20
the library loader (like on your second PC).

> If i look in my filesystem, i don't have that file. Neither i in MY pc
> where this example work well. The file i DO have is  libopendbx.so.1.1.0

The library loader is smart and knows that ibopendbx.so.1.1.0 is compatible=
=20
with ibopendbx.so.1 and therefore uses ibopendbx.so.1.1.0.

Regards,


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

[opendbx] error while loading shared libraries

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

Hi everybody!

I could install and use openDBX in my ubuntu with postgreSQL. Now i am
trying to install it in other pc and i have a problem. I installed openDBX
without problem, but when i try to execute a simple example to use it, i
have this error:

./Prueba: error while loading shared libraries: libopendbx.so.1: cannot open
shared object file: No such file or directory

If i look in my filesystem, i don't have that file. Neither i in MY pc where
this example work well. The file i DO have is  libopendbx.so.1.1.0

This test is a Prueba.c that connects to postgresql and do some querys. I
compile it with this:

COMPILER = gcc

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

OBJS =        Prueba.o

LIBS = -lopendbx

TARGET =    Prueba

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

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

all:    $(TARGET)

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



Very thanks in advance

Mariano

[opendbx] OpenDBX 1.2.4 released

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

Hi all

I'm proud to announce the availability of OpenDBX 1.2.4

This is a bugfix release for the current stable series. It contains a backp=
ort=20
from the development branch which removes the automake dependency from the=
=20
main OpenDBX header file (odbx.h). Thanks to Mariano Martinez Peck for the=
=20
hint. Furthermore, it fixes the SYBDATETIME4 type definition in the mssql=20
backend and adds support for the SYBLONGCHAR and SYBLONGBINARY types in mss=
ql=20
backend.=20

It does also contain a fix in the regression test program so it will build =
on=20
the latest Linux installations. The documentation was updated too.

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

Regards,


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

Re: [opendbx] Build documentation

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

Hi Norbert,

Ok. Very cool. I have noticed the changes. Give me a couple of days (i am a
bit complicated with work) and i will give you my little feedback about
them. I think i can have some additions, but i don't feel as confident as to
edit it in the wiki myself. I'd rather send it to you, so that you can
modify, remove, add, and so on, if necessary before adding it in the wiki. I
will also send what i told you before.

Thanks,

Mariano

On Jan 15, 2008 7:28 PM, Norbert Sendetzky <no...@li...> wrote:

> Hi Mariano
>
> > Norbert:  I have to do a couple of things with openDBX to make it work
> in
> > my ubuntu 7.10 and postgresql. As i have to make a mini-tutorial for my
> > project's companions, i wonder if you like to know which where the
> issues i
> > had. Perhaps it helps you. So, if you think it can help you, just let me
> > know and i send it to you too.
>
> I've updated the documentation in the Wiki regarding this. It's available
> at
>
> http://linuxnetworks.de/doc/index.php/OpenDBX/Setup
>
> If you have further additions, please feel free to add them there.
>
> Thanks
>
>
> 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
>
>

[opendbx] Build documentation

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

Hi Mariano

> Norbert:  I have to do a couple of things with openDBX to make it work in
> my ubuntu 7.10 and postgresql. As i have to make a mini-tutorial for my
> project's companions, i wonder if you like to know which where the issues=
 i
> had. Perhaps it helps you. So, if you think it can help you, just let me
> know and i send it to you too.

I've updated the documentation in the Wiki regarding this. It's available at

http://linuxnetworks.de/doc/index.php/OpenDBX/Setup

If you have further additions, please feel free to add them there.

Thanks


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

Re: [opendbx] Error in odbx.h

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

Hi Mariano

> Norbert:  I have to do a couple of things with openDBX to make it work in
> my ubuntu 7.10 and postgresql. As i have to make a mini-tutorial for my
> project's companions, i wonder if you like to know which where the issues=
 i
> had. Perhaps it helps you. So, if you think it can help you, just let me
> know and i send it to you too.

I would love to get more information about this topic and I would appreciat=
e=20
to add it to the Wiki.

Thanks


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

Re: [opendbx] Error in odbx.h

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

yeah!! now it works perfectly! i connect to postgresql, do some query and
show the results.

Norbert:  I have to do a couple of things with openDBX to make it work in my
ubuntu 7.10 and postgresql. As i have to make a mini-tutorial for my
project's companions, i wonder if you like to know which where the issues i
had. Perhaps it helps you. So, if you think it can help you, just let me
know and i send it to you too.

Very thanks for your quick answers,

Mariano




On Jan 13, 2008 8:19 PM, Norbert Sendetzky <no...@li...> wrote:

> Hi Mariano
>
> > make all
> > cc    -c -o Prueba.o Prueba.c
> > g++ -o Prueba Prueba.o
> > Prueba.o: In function `main':
> > Prueba.c:(.text+0x3c): undefined reference to `odbx_init'
> > Prueba.c:(.text+0x57): undefined reference to `odbx_error'
> > collect2: ld returned 1 exit status
> > make: *** [Prueba] Error 1
> >
> > it doesn't find the reference....do you know what can it be ?
>
> Don't forget to add the OpenDBX library for linking:
>
> g++ -o Prueba.o Prueba.c -lopendbx
>
> or use the pkg-config tool
>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
>
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>

Re: [opendbx] Error in odbx.h

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

Hi Mariano

> make all
> cc    -c -o Prueba.o Prueba.c
> g++ -o Prueba Prueba.o
> Prueba.o: In function `main':
> Prueba.c:(.text+0x3c): undefined reference to `odbx_init'
> Prueba.c:(.text+0x57): undefined reference to `odbx_error'
> collect2: ld returned 1 exit status
> make: *** [Prueba] Error 1
>
> it doesn't find the reference....do you know what can it be ?

Don't forget to add the OpenDBX library for linking:

g++ -o Prueba.o Prueba.c -lopendbx

or use the pkg-config tool


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

Re: [opendbx] Error in odbx.h

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

Hi Norbert,

Right now i can't tell you if every works well because i am just trying to
do a simple example. I can tell you if the program i show you in the other
mails, compiles. And yes, it does. If i put #include <inttypes.h> before
#include <odbx.h> without defining HAVE_STDINT_H it compiles.

However, if i try to use any function, i have an error. This error happen
with all the solutions we talk, because it has nothing to do with the other
problem. I the program i show you, i add the lines to connect to a database,
just like this:

#include <stdio.h>
#include <stdlib.h>
#include <stdint.h>
#include <inttypes.h>
#include <odbx.h>

int main(void) {
    puts("Hello World!!");

        int err;
        odbx_t* handle;

        if( ( err = odbx_init( &handle, "mysql", "127.0.0.1", "" ) ) < 0 )
        {
            fprintf( stderr, "odbx_init(): %s\n", odbx_error( handle, err )
);
            return err;
        }

        return EXIT_SUCCESS;
}



And i have the following error:

**** Build of configuration Linux GCC for project Prueba ****

make all
cc    -c -o Prueba.o Prueba.c
g++ -o Prueba Prueba.o
Prueba.o: In function `main':
Prueba.c:(.text+0x3c): undefined reference to `odbx_init'
Prueba.c:(.text+0x57): undefined reference to `odbx_error'
collect2: ld returned 1 exit status
make: *** [Prueba] Error 1


it doesn't find the reference....do you know what can it be ?

thanks,

mariano




On 1/13/08, Norbert Sendetzky <no...@li...> wrote:
>
> Hi Mariano
>
> > So...those are the solutions i found. which one do you think is the
> better
> > ? Just by curious, why can't odbx.h include <stdint.h> always ? whats
> the
> > problem with this ? i ask just because i know very little about C.
>
> The problem is that uint64_t is defined in different headers on different
> platforms (Linux, Solaris, etc). As far as I understand inttypes.h is
> available on all platforms and we are no longer dependent on using
> automake
> or defining symbols ourselves. Could you test if everything works without
> errors with OpenDBX 1.3.4? If yes, I wll backport the change to the stable
> series.
>
> Thanks
>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
>
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>
>

Re: [opendbx] Error in odbx.h

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

Hi Mariano

> So...those are the solutions i found. which one do you think is the better
> ? Just by curious, why can't odbx.h include <stdint.h> always ? whats the
> problem with this ? i ask just because i know very little about C.

The problem is that uint64_t is defined in different headers on different=20
platforms (Linux, Solaris, etc). As far as I understand inttypes.h is=20
available on all platforms and we are no longer dependent on using automake=
=20
or defining symbols ourselves. Could you test if everything works without=20
errors with OpenDBX 1.3.4? If yes, I wll backport the change to the stable=
=20
series.

Thanks


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

Re: [opendbx] Error in odbx.h

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

Hi Norbert

Before receiving you answer i found the error. The problem is this: In
odbx.h you use uint64_t. This, is in stdint.h . In your odbx.h you have
this:

#ifdef HAVE_STDINT_H
#include <stdint.h>
#else
#include <sys/types.h>
#endif


So....if in your client program, you don't define this,it won't work. So, i
found 2 solutions:

1) Do the #include <stdint.h> before the #include <odbx.h> in MY program.

2) Define HAVE_STDINT_H in my program, before the #include <odbx.h>. I can
defined it just like this:

#ifndef HAVE_STDINT_H // if not already defined, then we'll define the
symbol here
#define HAVE_STDINT_H
#endif


So...those are the solutions i found. which one do you think is the better ?
Just by curious, why can't odbx.h include <stdint.h> always ? whats the
problem with this ? i ask just because i know very little about C.

No need you answer me while you are in holidays. Just take advantage of it
and have a good time.

Very thanks.

Mariano


On Jan 13, 2008 4:35 AM, Norbert Sendetzky <no...@li...> wrote:

> Hi Mariano
>
> > In file included from Prueba.c:11:
> > /usr/local/include/odbx.h:206: error: expected '=', ',', ';', 'asm' or
> > '__attribute__' before 'odbx_rows_affected'
> > make: *** [Prueba.o] Error 1
> >
> >
> > I saw the header odbx.h at line 206 and it is like this:
> > uint64_t odbx_rows_affected( odbx_result_t* result );
>
> Seems like uint64_t is not defined for you. Up to OpenDBX 1.3.1 the
> inclusion
> of the required header defining this type is problematic. Could you try to
> add an
>
> #include <inttypes.h>
>
> in your file?
>
> Seems that this error is more problematic than I thought so I will
> backport
> the change in 1.3.1 to the 1.2 series.
>
> Thanks
>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
>
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>

Re: [opendbx] Error in odbx.h

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

Hi Mariano

> In file included from Prueba.c:11:
> /usr/local/include/odbx.h:206: error: expected '=3D', ',', ';', 'asm' or
> '__attribute__' before 'odbx_rows_affected'
> make: *** [Prueba.o] Error 1
>
>
> I saw the header odbx.h at line 206 and it is like this:
> uint64_t odbx_rows_affected( odbx_result_t* result );

Seems like uint64_t is not defined for you. Up to OpenDBX 1.3.1 the inclusi=
on=20
of the required header defining this type is problematic. Could you try to=
=20
add an

#include <inttypes.h>

in your file?

Seems that this error is more problematic than I thought so I will backport=
=20
the change in 1.3.1 to the 1.2 series.

Thanks


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

[opendbx] Error in odbx.h

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

Hi! Once i could compile and install openDBX with the postgresql backend, i
tried to do a very simple C application that connects to a Postgresql
database.

I see the example of the benchmark
here<http://www.linuxnetworks.de/doc/index.php/OpenDBX/Comparison>and
i use it as a base.

Mi example is called Prueba.c i this:

#include <stdio.h>
#include <stdlib.h>
#include <odbx.h>


int main(void) {

    puts("Hello World!!");
    return EXIT_SUCCESS;

}

When i tried to compile mi Prueba.c (even if i do nothing with openDBX) it
has an error in the odbx.h. Here i paste the result:

**** Build of configuration Linux GCC for project Prueba ****

make all
cc    -c -o Prueba.o Prueba.c
In file included from Prueba.c:11:
/usr/local/include/odbx.h:206: error: expected '=', ',', ';', 'asm' or
'__attribute__' before 'odbx_rows_affected'
make: *** [Prueba.o] Error 1


I saw the header odbx.h at line 206 and it is like this:
uint64_t odbx_rows_affected( odbx_result_t* result );

Ok. That's the problem. Very thanks in advance.

Mariano

Re: [opendbx] First post...trying to compile OpenDBX

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

Hi Mariano

> CPPFLAGS=3D"-I/home/mariano/Documents/OpenDBX/opendbx-1.2.3/backends/pgsq=
l"
> LDFLAGS=3D"-L/usr/lib/postgresql" ./configure --with-backends=3D"pgsql"
>
> I put in CPPFLAGS the directory where there is the pgsqlbackend.h,
> pgsqlbackend.c and so on.

Your CPPFLAGS must point to the location where the PostgreSQL libpq-fe.h fi=
le=20
resides. Ubuntu should be similar to Debian in this case and you should try=
=20
something like /usr/include/postgresql


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

[opendbx] First post...trying to compile OpenDBX

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

Hi everybody! This is mi first post. First of all, sorry for my English, i
am Argentinian.

I tried to install openDBX and i couldn't. I downloaded
opendbx-1.2.3.tar-gzand i put it in
/home/mariano/Documents/OpenDBX/opendbx-
1.2.3.
I am using Ubuntu Gutsy Gibbon. I have installed PostgreSQL from sinapsis
and all work good.

Then i tried to compile openDBX. I followed
this<http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup>link. I
tried this:

CPPFLAGS="-I/home/mariano/Documents/OpenDBX/opendbx-1.2.3/backends/pgsql"
LDFLAGS="-L/usr/lib/postgresql" ./configure --with-backends="pgsql"

I put in CPPFLAGS the directory where there is the pgsqlbackend.h,
pgsqlbackend.c and so on.
I put in LDFLAGS the directory where there is my postgresql libraries. In
fact, inside /usr/lib/postgresql i have a directory called 8.2 (the version)
and inside it i have two more directories: bin and lib.

If i execute what i said above, i have this error:
"configure: error: postgresql header not found"

what i am doing wrong?

And then, once i did ./configure and worked well, whats what i have to do
??? just make  ??

Very thanks,

Mariano

[opendbx] New OpenDBX mailing list

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

Hi all

The OpenDBX mailing list has moved from freelists.org to Sourceforge.
Together with the new publically available SVN repository it will be the=20
central place for a real community driven project.


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