[SOGo] Install database connector (debian)

[Nikolaus Krismer]

Hi,

since I am still having problems installing SOGo on my debian lenny, i read
the install instructions again.
In the install instructions it is said that after installing sogo, the
installation of a databse conector is necessary...
...so my question is:

Is there a debian-alternative for the rpm packages sope47-gdl1-*?
(In fact i would only need a alternative for sope47-gdl1-mysql)

At first i thought that compiling SOPE would do the job, but i am still
getting "failed to link optional library: mysqlclient", although "aptitude
search libmysqlclient" prints:
i libmysqlclient15-dev - MySQL database development files
i A libmysqlclient15off - MySQL database client library
i A libmysqlclient16 - MySQL database client library

Regards,
Niko

[Ludovic Marcotte]

Post by Nikolaus Krismer
Hi,
since I am still having problems installing SOGo on my debian lenny, i read
the install instructions again.
In the install instructions it is said that after installing sogo, the
installation of a databse conector is necessary...
Is there a debian-alternative for the rpm packages sope47-gdl1-*?
(In fact i would only need a alternative for sope47-gdl1-mysql)
At first i thought that compiling SOPE would do the job, but i am still
getting "failed to link optional library: mysqlclient", although "aptitude
i libmysqlclient15-dev - MySQL database development files

What's the output when you run:

1- the SOPE's configure script
2- /usr/bin/mysql_config --libs
3- /usr/bin/mysql_config --cflags

Thanks,

[Nikolaus Krismer]

Post by Ludovic Marcotte
1- the SOPE's configure script

GNUstep environment:
system: /usr/System
local: /usr/Local
user: /root/GNUstep
path: /root/GNUstep:/usr/Local:/usr/Network:/usr/System
flat: yes
arch: x86_64-pc-linux-gnu
combo: gnu-gnu-gnu

Note: will install in default location: /usr/local/

Configuration:
FHS: install in FHS root
debug: yes
strip: yes
prefix: /usr/local/
frameworks:
gstep: /usr/share/GNUstep/Makefiles
config: /share/Data/www/files/SOGo/sope/config.make
script: /usr/share/GNUstep/Makefiles/GNUstep.sh

creating: /share/Data/www/files/SOGo/sope/config.make
optional library found: xml2
optional library found: ldap
required library found: ssl
failed to link optional library: pq
failed to link optional library: sqlite3
failed to link optional library: mysqlclient
configuring NGStreams library .... done (log in config-NGStreams.log).

Post by Ludovic Marcotte
2- /usr/bin/mysql_config --libs

-L/usr/lib/mysql -lmysqlclient

Post by Ludovic Marcotte
3- /usr/bin/mysql_config --cflags

-I/usr/include/mysql -DBIG_JOINS=1 -fPIC

Regards,
Niko

[Francis Dufour]

Post by Nikolaus Krismer
Hi,
since I am still having problems installing SOGo on my debian lenny, i read
the install instructions again.
In the install instructions it is said that after installing sogo, the
installation of a databse conector is necessary...
Is there a debian-alternative for the rpm packages sope47-gdl1-*?
(In fact i would only need a alternative for sope47-gdl1-mysql)
At first i thought that compiling SOPE would do the job, but i am still
getting "failed to link optional library: mysqlclient", although "aptitude
i libmysqlclient15-dev - MySQL database development files
i A libmysqlclient15off - MySQL database client library
i A libmysqlclient16 - MySQL database client library
Regards,
Niko

Hello,

I think I have the same problem, except I use postgresql and ubuntu.
What should I do to install the db connector ?

Message I get when I start sogod :

2009-04-17 14:20:34.647 sogod[30832] EOAdaptor: cannot find adaptor
bundle: 'PostgreSQL'
### child 30832 (#442) was terminated by signal 6 (uptime=0s).

SOGo compiled from svn trunk.

Thanks.

[Francis Dufour]

Post by Francis Dufour
Hello,
I think I have the same problem, except I use postgresql and ubuntu.
What should I do to install the db connector ?
2009-04-17 14:20:34.647 sogod[30832] EOAdaptor: cannot find adaptor
bundle: 'PostgreSQL'
### child 30832 (#442) was terminated by signal 6 (uptime=0s).
SOGo compiled from svn trunk.
Thanks.

No ideas ?

I installed all required and optionals libraries but with no more success.

Thanks for help!

[Gaël ROSSIGNOL]

Hello,

Did you have installed all the following packets? :

sudo aptitude install apache2-prefork-dev gnustep-make
libgnustep-base1.16 libgnustep-base-dev make libsqlite3-dev
libmysqlclient-dev libpq-dev libssl-dev libldap-dev libxml2-dev
libfoundation-dev

Post by Francis Dufour

Post by Francis Dufour
Hello,
I think I have the same problem, except I use postgresql and ubuntu.  What
should I do to install the db connector ?
2009-04-17 14:20:34.647 sogod[30832] EOAdaptor: cannot find adaptor
bundle: 'PostgreSQL'
### child 30832 (#442) was terminated by signal 6 (uptime=0s).
SOGo compiled from svn trunk.
Thanks.

No ideas ?
I installed all required and optionals libraries but with no more success.
Thanks for help!
--
OpenGroupware.org SOGo
http://mail.opengroupware.org/mailman/listinfo/sogo

[Francis Dufour]

Post by Francis Dufour
Hello,
sudo aptitude install apache2-prefork-dev gnustep-make
libgnustep-base1.16 libgnustep-base-dev make libsqlite3-dev
libmysqlclient-dev libpq-dev libssl-dev libldap-dev libxml2-dev
libfoundation-dev

Yes all are installed.

[Gaël ROSSIGNOL]

Which version of gcc do you use?

I use :

***@debian:~# gcc --version
gcc (Debian 4.3.2-1.1) 4.3.2
Copyright (C) 2008 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

And it work correctly with mysql... And before I have tested the
product with ubuntu and postgresql (SOGo version 1.0rc8)

The version of GNUstep make is 2.0.6...

I don't know what others things can differ...

[Francis Dufour]

Post by Gaël ROSSIGNOL
Which version of gcc do you use?
gcc (Debian 4.3.2-1.1) 4.3.2
Copyright (C) 2008 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
And it work correctly with mysql... And before I have tested the
product with ubuntu and postgresql (SOGo version 1.0rc8)
The version of GNUstep make is 2.0.6...
I don't know what others things can differ...

Same (using ubuntu 8.10).

***@mail:~# gcc --version
gcc (Ubuntu 4.3.2-1ubuntu12) 4.3.2

***@mail:~# dpkg --list gnustep-make
Souhait=inconnU/Installé/suppRimé/Purgé/H=à garder
|
État=Non/Installé/fichier-Config/dépaqUeté/échec-conFig/H=semi-installé/W=attend-traitement-déclenchements
|/ Err?=(aucune)/H=à garder/besoin Réinstallation/X=les deux (État,Err:
majuscule=mauvais)
||/ Nom
Version Description
+++-=====================================-=====================================-==========================================================================================
ii gnustep-make
2.0.6-2 Basic GNUstep Makefiles

[Wolfgang Sourdeau]

Post by Nikolaus Krismer
Hi,
since I am still having problems installing SOGo on my debian lenny, i read
the install instructions again.
In the install instructions it is said that after installing sogo, the
installation of a databse conector is necessary...

Hi Nikolaus,


I have been able to reproduce and diagnose your problem.
When executing the configure script, the "checkLinking" function keeps
the old library names in the list of libraries it links its test scripts
with. Therefore, if you have the libpq or libsqlite missing in your
system, it will fail "exponentially".

I do not have the time right now to fix that issue, but as a quick fix,
you could remove the following lines in your local copy (lines 477 and 478):

checkLinking "pq" optional;
checkLinking "sqlite3" optional;

This will ensure that only libmysqlclient is being tested.

Tell me if it works...

[Gael Rossignol]

Hello,

Yes I confirm installing debian package "libpq-dev" and "libsqlite-dev"
have fixed the problem for me.

Post by Wolfgang Sourdeau

Post by Nikolaus Krismer
Hi,
since I am still having problems installing SOGo on my debian lenny, i read
the install instructions again.
In the install instructions it is said that after installing sogo, the
installation of a databse conector is necessary...

Hi Nikolaus,
I have been able to reproduce and diagnose your problem.
When executing the configure script, the "checkLinking" function keeps
the old library names in the list of libraries it links its test scripts
with. Therefore, if you have the libpq or libsqlite missing in your
system, it will fail "exponentially".
I do not have the time right now to fix that issue, but as a quick fix,
checkLinking "pq" optional;
checkLinking "sqlite3" optional;
This will ensure that only libmysqlclient is being tested.
Tell me if it works...
--

[Nikolaus Krismer]

Post by Francis Dufour
Hello,
sudo aptitude install apache2-prefork-dev gnustep-make
libgnustep-base1.16 libgnustep-base-dev make libsqlite3-dev
libmysqlclient-dev libpq-dev libssl-dev libldap-dev libxml2-dev
libfoundation-dev

After installing "apache2-prefork-dev" (which was the only package missing
in the list) the mysqlclient library is found by the sope configuration
script (i am not sure why ... in my opinion the package has nothing to do
with mysql, but anyway... it works ;-))...

... i haven't tried configurating sogo to see if the database connection is
working, but i will do so this week (and i will use sogo 1.0.1 instead of
1.0)... i will post my results here :)

Thanks,
Niko

Post by Francis Dufour
OpenGroupware.org SOGo
http://mail.opengroupware.org/mailman/listinfo/sogo