Gentoo PostgreSQL Problem

DBMail Enthusiasts,

I'm trying to set up DBMail on a Gentoo box(via Gentoo
Sunrise) for personal
use.  I've created a dbmail Postgres user, created the
database and tables,
and I think I've set all the appropriate options in
/etc/dbmail/dbmail.conf
for use with Postgres.  If I try to start the imap server,
add a user via
dbmail-user, etc, I get the following error:

FATAL cannot find function `db_connect':
/usr/lib/dbmail/libpgsql.so:
undefined symbol: db_connect



Kevin
http://www.RawFedDogs.net
http://www.WacoAgilit
yGroup.org
Bruceville, TX

Si hoc legere scis nimium eruditionis habes.
Longum iter est per praecepta, breve et efficax per
exempla!!!

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Kevin Monceaux wrote:
> DBMail Enthusiasts,
> 
> I'm trying to set up DBMail on a Gentoo box(via Gentoo
Sunrise) for personal
> use.  I've created a dbmail Postgres user, created the
database and tables,
> and I think I've set all the appropriate options in
/etc/dbmail/dbmail.conf
> for use with Postgres.  If I try to start the imap
server, add a user via
> dbmail-user, etc, I get the following error:
> 
> FATAL cannot find function `db_connect':
/usr/lib/dbmail/libpgsql.so:
> undefined symbol: db_connect

level 5 logs please.

that is trace_syslog=5 in your dbmail.conf, then run
'dbmail-users -l'
and send us the relevant lines from your syslog.


-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Paul,

On Tue, Jan 30, 2007 at 07:59:32PM +0100, Paul J Stevens
wrote:
 
> level 5 logs please.
> 
> that is trace_syslog=5 in your dbmail.conf, then run
'dbmail-users -l'
> and send us the relevant lines from your syslog.

Okay, this is what's being written to syslog:

Jan 30 13:16:19 Phideaux dbmail/user[2677]: Debug:[db]
dbmodule.c,db_load_driver(+67): looking for pgsql as
modules/.libs/libpgsql.so
Jan 30 13:16:19 Phideaux dbmail/user[2677]: Info:[db]
dbmodule.c,db_load_driver(+71): cannot load
modules/.libs/libpgsql.so: cannot open shared object file:
No such file or directory
Jan 30 13:16:19 Phideaux dbmail/user[2677]: Debug:[db]
dbmodule.c,db_load_driver(+67): looking for pgsql as
/usr/lib/dbmail/libpgsql.so
Jan 30 13:16:19 Phideaux dbmail/user[2677]: FATAL:[db]
dbmodule.c,db_load_driver(+98): cannot find function
`db_connect': /usr/lib/dbmail/libpgsql.so: undefined symbol:
db_connect



Kevin
http://www.RawFedDogs.net
http://www.WacoAgilit
yGroup.org
Bruceville, TX

Si hoc legere scis nimium eruditionis habes.
Longum iter est per praecepta, breve et efficax per
exempla!!!

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

On Tuesday 30 January 2007 20:22, Kevin Monceaux wrote:
> Paul,
>
> On Tue, Jan 30, 2007 at 07:59:32PM +0100, Paul J
Stevens wrote:
> > level 5 logs please.
> >
> > that is trace_syslog=5 in your dbmail.conf, then
run 'dbmail-users -l'
> > and send us the relevant lines from your syslog.
>
> Okay, this is what's being written to syslog:
>
> Jan 30 13:16:19 Phideaux dbmail/user[2677]: Debug:[db]
> dbmodule.c,db_load_driver(+67): looking for pgsql as
> modules/.libs/libpgsql.so Jan 30 13:16:19 Phideaux
dbmail/user[2677]:
> Info:[db] dbmodule.c,db_load_driver(+71): cannot load
> modules/.libs/libpgsql.so: cannot open shared object
file: No such file or
> directory Jan 30 13:16:19 Phideaux dbmail/user[2677]:
Debug:[db]
> dbmodule.c,db_load_driver(+67): looking for pgsql as
> /usr/lib/dbmail/libpgsql.so Jan 30 13:16:19 Phideaux
dbmail/user[2677]:
> FATAL:[db] dbmodule.c,db_load_driver(+98): cannot find
function
> `db_connect': /usr/lib/dbmail/libpgsql.so: undefined
symbol: db_connect
>

Looks like you installed dbmail without Postgresql support.
Did you include "postgres" as a keyword  in your
USE variable ?

env USE="postgres" emerge -v dbmail


Steffen
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Steffen,

On Tue, Jan 30, 2007 at 08:52:10PM +0100, Steffen Schuetz
wrote:

> Looks like you installed dbmail without Postgresql
support.  Did you
> include "postgres" as a keyword  in your USE
variable ?
> 
> env USE="postgres" emerge -v dbmail

I have postgres is set as a global USE flag, and eix shows
that dbmail was
compiled with the postgres USE flag set.  But, just to make
sure I
re-emerged it with the above command.  I still get the same
error.



Kevin
http://www.RawFedDogs.net
http://www.WacoAgilit
yGroup.org
Bruceville, TX

Si hoc legere scis nimium eruditionis habes.
Longum iter est per praecepta, breve et efficax per
exempla!!!

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Aaron,

On Tue, Jan 30, 2007 at 08:21:44PM -0000, Aaron Stone
wrote:
 
> It doesn't sound like you'd be caught with stale
modules, but just the
> same, blow away /usr/lib/dbmail, check for a
/usr/local/lib/dbmail, and
> check to make sure that there aren't any other modules
named
> /usr/lib/dbmail* or /usr/local/lib/dbmail*, then
re-emerge.
> 
> If that fails, send output of `nm
/usr/lib/dbmail/libpgsql.so`

There definitely appears to be a problem with the Gentoo
ebuild.  I tried
the above:

nm: /usr/lib/dbmail/libpgsql.so: no symbols

I checked the other libraries installed under
/usr/lib/dbmail and none
contain any symbols.  I tried building dbmail from source
myself and ended
up with libraries that do contain symbols, so my build
environment appears
to be okay.  For the time being I just copied the libraries
I built over the
ones portage installed and I'm able to access dbmail, but
that's not the
ideal solution.  


Kevin
http://www.RawFedDogs.net
http://www.WacoAgilit
yGroup.org
Bruceville, TX

Si hoc legere scis nimium eruditionis habes.
Longum iter est per praecepta, breve et efficax per
exempla!!!

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

On Tue, 2007-01-30 at 17:07 -0600, Kevin Monceaux wrote:
> Aaron,
> 
> On Tue, Jan 30, 2007 at 08:21:44PM -0000, Aaron Stone
wrote:
>  
> > It doesn't sound like you'd be caught with stale
modules, but just the
> > same, blow away /usr/lib/dbmail, check for a
/usr/local/lib/dbmail, and
> > check to make sure that there aren't any other
modules named
> > /usr/lib/dbmail* or /usr/local/lib/dbmail*, then
re-emerge.
> > 
> > If that fails, send output of `nm
/usr/lib/dbmail/libpgsql.so`
> 
> There definitely appears to be a problem with the
Gentoo ebuild.  I tried
> the above:
> 
> nm: /usr/lib/dbmail/libpgsql.so: no symbols

Martin Hierling maintains this ebuild, please be sure to
make a bug
report with him or with Sunrise (if they have their own bug
tracker,
definitely use it rather than personal email).

Aaron

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail