Re: SMSD + PostgreSQL

[Pawel Kot]

Hi,

On Sun, Apr 13, 2008 at 12:34 AM, Jan Derfinak <address@hidden> wrote:
> On Sat, 12 Apr 2008, Pawel Kot wrote:
>
>  > Hi,
>  >
>  > On Sat, Apr 12, 2008 at 11:54 PM, Jan Derfinak <address@hidden> wrote:
>  > > On Sat, 12 Apr 2008, Pawel Kot wrote:
>  > >  > I tried to compile fully blown SMSD (with all plugins) on Ubuntu 7.10
>  > >  > with all updates. And I failed due to PostgreSQL issue. With gnokii
>  > >
>  > >  which version of PostgreSQL?
>  >
>  > 8.3.0
>
>  I didn't find anything in postgresql documentation that indicate any change
>  in build process. libpq is still main library for C API.
>
>  Can you send build log?

Here you go:
Making all in smsd
make[1]: Entering directory `/home/pkot/gnokii-work/smsd'
/bin/sh ../libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I.
-I../include    -I../include -I./ -I/usr/include/glib-2.0
-I/usr/lib/glib-2.0/include   -I/usr/include/postgresql
-I/usr/include/mysql -DBIG_JOINS=1
-DMODULES_DIR=\"/usr/local/lib/smsd\" -pthread -g -O2 -Wall
-Wno-pointer-sign -fvisibility=hidden -fno-strict-aliasing  -MT
file.lo -MD -MP -MF .deps/file.Tpo -c -o file.lo file.c
 gcc -DHAVE_CONFIG_H -I. -I../include -I../include -I./
-I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/include/postgresql -I/usr/include/mysql -DBIG_JOINS=1
-DMODULES_DIR=\"/usr/local/lib/smsd\" -pthread -g -O2 -Wall
-Wno-pointer-sign -fvisibility=hidden -fno-strict-aliasing -MT file.lo
-MD -MP -MF .deps/file.Tpo -c file.c  -fPIC -DPIC -o .libs/file.o
 gcc -DHAVE_CONFIG_H -I. -I../include -I../include -I./
-I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/include/postgresql -I/usr/include/mysql -DBIG_JOINS=1
-DMODULES_DIR=\"/usr/local/lib/smsd\" -pthread -g -O2 -Wall
-Wno-pointer-sign -fvisibility=hidden -fno-strict-aliasing -MT file.lo
-MD -MP -MF .deps/file.Tpo -c file.c -o file.o >/dev/null 2>&1
mv -f .deps/file.Tpo .deps/file.Plo
/bin/sh ../libtool  --tag=CC   --mode=link gcc -I../include -I./
-I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/include/postgresql -I/usr/include/mysql -DBIG_JOINS=1
-DMODULES_DIR=\"/usr/local/lib/smsd\" -pthread -g -O2 -Wall
-Wno-pointer-sign -fvisibility=hidden -fno-strict-aliasing
-avoid-version -module -no-undefined  -o libsmsd_file.la -rpath
/usr/local/lib/smsd file.lo utils.lo
rm -fr  .libs/libsmsd_file.a .libs/libsmsd_file.la
.libs/libsmsd_file.lai .libs/libsmsd_file.so
gcc -shared  .libs/file.o .libs/utils.o   -pthread -Wl,-soname
-Wl,libsmsd_file.so -o .libs/libsmsd_file.so
ar cru .libs/libsmsd_file.a  file.o utils.o
ranlib .libs/libsmsd_file.a
creating libsmsd_file.la
(cd .libs && rm -f libsmsd_file.la && ln -s ../libsmsd_file.la libsmsd_file.la)
/bin/sh ../libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I.
-I../include    -I../include -I./ -I/usr/include/glib-2.0
-I/usr/lib/glib-2.0/include   -I/usr/include/postgresql
-I/usr/include/mysql -DBIG_JOINS=1
-DMODULES_DIR=\"/usr/local/lib/smsd\" -pthread -g -O2 -Wall
-Wno-pointer-sign -fvisibility=hidden -fno-strict-aliasing  -MT pq.lo
-MD -MP -MF .deps/pq.Tpo -c -o pq.lo pq.c
 gcc -DHAVE_CONFIG_H -I. -I../include -I../include -I./
-I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/include/postgresql -I/usr/include/mysql -DBIG_JOINS=1
-DMODULES_DIR=\"/usr/local/lib/smsd\" -pthread -g -O2 -Wall
-Wno-pointer-sign -fvisibility=hidden -fno-strict-aliasing -MT pq.lo
-MD -MP -MF .deps/pq.Tpo -c pq.c  -fPIC -DPIC -o .libs/pq.o
 gcc -DHAVE_CONFIG_H -I. -I../include -I../include -I./
-I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/include/postgresql -I/usr/include/mysql -DBIG_JOINS=1
-DMODULES_DIR=\"/usr/local/lib/smsd\" -pthread -g -O2 -Wall
-Wno-pointer-sign -fvisibility=hidden -fno-strict-aliasing -MT pq.lo
-MD -MP -MF .deps/pq.Tpo -c pq.c -o pq.o >/dev/null 2>&1
mv -f .deps/pq.Tpo .deps/pq.Plo
/bin/sh ../libtool  --tag=CC   --mode=link gcc -I../include -I./
-I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/include/postgresql -I/usr/include/mysql -DBIG_JOINS=1
-DMODULES_DIR=\"/usr/local/lib/smsd\" -pthread -g -O2 -Wall
-Wno-pointer-sign -fvisibility=hidden -fno-strict-aliasing
-avoid-version -module -no-undefined  -o libsmsd_pq.la -rpath
/usr/local/lib/smsd pq.lo utils.lo -L/usr/lib -lpq

*** Warning: Linking the shared library libsmsd_pq.la against the
loadable module
*** libpq.so is not portable!
rm -fr  .libs/libsmsd_pq.a .libs/libsmsd_pq.la .libs/libsmsd_pq.lai
.libs/libsmsd_pq.so
gcc -shared  .libs/pq.o .libs/utils.o  -Wl,--rpath
-Wl,/home/pkot/gnokii-work/smsd/.libs -Wl,--rpath
-Wl,/usr/local/lib/smsd -L/usr/lib
/home/pkot/gnokii-work/smsd/.libs/libpq.so  -pthread -Wl,-soname
-Wl,libsmsd_pq.so -o .libs/libsmsd_pq.so
gcc: /home/pkot/gnokii-work/smsd/.libs/libpq.so: No such file or directory
make[1]: *** [libsmsd_pq.la] Error 1
make[1]: Leaving directory `/home/pkot/gnokii-work/smsd'
make: *** [all-recursive] Error 1

MySQL builds just fine. (Here it isn't shown as PostgreSQL is the
first one to compile).

>  What printed this warning?

See above.

>  Why is libpq.so named as loadable module?

I have no idea.
address@hidden:~$ dpkg -l \*libpq\*
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-f/Unpacked/Failed-cfg/Half-inst/t-aWait/T-pend
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Nazwa          Wersja         Opis
+++-==============-==============-============================================
ii  libpq-dev      8.3.0-1~gutsy1 header files for libpq5 (PostgreSQL library)
ii  libpq4         8.1.10-1       PostgreSQL C client library
ii  libpq5         8.3.0-1~gutsy1 PostgreSQL C client library
address@hidden:~$ file /usr/lib/libpq.
libpq.a       libpq.so.4    libpq.so.5
libpq.so      libpq.so.4.1  libpq.so.5.1
address@hidden:~$ file /usr/lib/libpq.so.5.1
/usr/lib/libpq.so.5.1: ELF 32-bit LSB shared object, Intel 80386,
version 1 (SYSV), stripped

>  What parameters for gcc are generated by autoconf?

See above.

pkot
-- 
Pawel Kot