From: Micah Stevens <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: DBMail mailinglist <[email protected]>
Subject: Re: [Dbmail] Receiving mail
Date: Sat, 11 Mar 2006 12:07:39 -0800
libtool: link : cannot find library '/usr/lib/mysql/libz.la'
http://bugs.mysql.com/bug.php?id=15223
maybe
On Saturday 11 March 2006 11:57 am, Jim Douglas wrote:
> >From: Micah Stevens <[EMAIL PROTECTED]>
> >Reply-To: DBMail mailinglist <[email protected]>
> >To: DBMail mailinglist <[email protected]>
> >Subject: Re: [Dbmail] Receiving mail
> >Date: Sat, 11 Mar 2006 11:00:25 -0800
> >
> >
> >Well, one of two things is going on, either it's not using that
> > dbmail.conf file, or the user/pw is incorrect. I don't see many other
> > alternatives.
> >
> >-Micah
> >
> >On Saturday 11 March 2006 10:47 am, Jim Douglas wrote:
> > > >From: Micah Stevens <[EMAIL PROTECTED]>
> > > >Reply-To: DBMail mailinglist <[email protected]>
> > > >To: DBMail mailinglist <[email protected]>
> > > >Subject: Re: [Dbmail] Receiving mail
> > > >Date: Sat, 11 Mar 2006 10:13:17 -0800
> > > >
> > > >On Saturday 11 March 2006 10:04 am, Jim Douglas wrote:
> > > > > When I login to mysql with
> > > > >
> > > > > mysql -u dbmail -p
> > > > > it prompts for a password, I enter it and can connect. No
problem.
> > > > >
> > > > > When I try to connect with,
> > > > >
> > > > > dbmail-users -l
> > > > >
> > > > > I get
> > > > > Opening connection to database...
> > > > > Failed. Could not connect to database (check log)
> > > > > Command Failed.
> > > > >
> > > > >
> > > > > This is my dbmail.conf, I know the socket, username, password,
> >
> >database
> >
> > > >are
> > > >
> > > > > correct...
> > > > >
> > > > > Thanks for your help..
> > > > >
> > > > >
> > > > >
> > > > > # $Id: dbmail.conf 1539 2004-12-27 21:41:07Z paul $
> > > > > # (c) 2000-2002 IC&S, The Netherlands
> > > > > #
> > > > > # Configuration file for DBMAIL
> > > > > # This configuration file needs to be run through dbmail-config
to
> >
> >be
> >
> > > > > effective
> > > > > # after that, changes are effective inmediatly
> > > > >
> > > > >
> > > > > [DBMAIL]
> > > > > # Database settings
> > > > > host=localhost # host for database, set to localhost
> > > > > if
> > > >
> > > >database
> > > >
> > > > > is om
> > > > > # the same host as
> > > > > dbmail and you
> > > >
> > > >want to use a
> > > >
> > > > > local socket
> > > > > # for connecting.
> > > > > sqlport=3306 # if you want to use TCP/IP for
> > > > > connecting
> > > >
> > > >to the
> > > >
> > > > > database,
> > > > > # and have the database
> > > > > running on a
> > > >
> > > >non-standard
> > > >
> > > > > port.
> > > > >
> > > > > # when using a local
> > > > > socket
> > > >
> > > >connection to the
> > > >
> > > > > database, fill
> > > > > # in the path to the
> > > > > socket here
> > > >
> > > >(e.g.
> > > >
> > > > > /var/run/mysql.sock)
> > > > > sqlsocket=/var/lib/mysql/mysql.sock
> > > > >
> > > > > user=dbmail # user to connect as to database
> > > > > pass=mypassword # password for user to database
> > > > > db=dbmail # name of database
> > > > >
> > > > >
> > > > > # postmaster's email
> > > >
> > > >address.
> > > >
> > > > > [EMAIL PROTECTED]
> > > > >
> > > > > # trace level for dbmail-util
> > > > > TRACE_LEVEL=2
> > > > >
> > > > > [SMTP]
> > > > > SENDMAIL=/usr/sbin/sendmail # sendmail executable for
> > > >
> > > >forwarding mail
> > > >
> > > > > AUTO_NOTIFY=no
> > > > > AUTO_REPLY=no
> > > > > TRACE_LEVEL=2
> > > > >
> > > > > [LMTP]
> > > > > # the user that dbmail-lmtpd will run as (need to be root to
bind
> > > > > to
> >
> >a
> >
> > > > > port<1024)
> > > > > EFFECTIVE_USER=root
> > > > >
> > > > > # the group that dbmail-lmtpd will run as
> > > > > EFFECTIVE_GROUP=dbmail
> > > > > BINDIP=* # the
> > > > > ipaddress the
> > > >
> > > >dbmail-lmtpd server has to
> > > >
> > > > > bind # to, * for all adresses. Use 127.0.0.1 to only # bind to
> > > >
> > > >localhost.
> > > >
> > > > > PORT=24
> > > > > # the port
> > > >
> > > >number the dbmail-lmtpd server
> > > >
> > > > > has to bind to. NCHILDREN=20
> > > > > #
> > > >
> > > >default number of LMTP
> > > >
> > > > > handlers (each is a process) MAXCHILDREN=10
> > > >
> > > > # max.
> > > >
> > > > > number of LMTP handlers
> > > > > MINSPARECHILDREN=2
> > > > > MAXSPARECHILDREN=4
> > > > > MAXCONNECTS=10000 # the
> > > > > maximum number
> > > >
> > > >of connections a
> > > >
> > > > > default childs makes
> > > > > TIMEOUT=300
> > > > > # the time (s)
> > > >
> > > >before the dbmail-lmtpd
> > > >
> > > > > should shutdown a connection which is being idle.
> > > > > RESOLVE_IP=yes # if yes, the
> > > > > lmtp daemon
> > > >
> > > >resolves IP
> > > >
> > > > > numbers to DNS names in the log
> > > > > TRACE_LEVEL=2
> > > > > MAX_ERRORS=500
> > > > >
> > > > > [POP]
> > > > > EFFECTIVE_USER=nobody # the user
> > > > > that
> > > >
> > > >dbmail-pop3d will run as
> > > >
> > > > > (need to be root to bind to a port<1024)
> > > > > EFFECTIVE_GROUP=nogroup # the group that
> > > > > dbmail-pop3d
> > > >
> > > >will run as
> > > >
> > > > > BINDIP=*
> > > > > # the
> > > >
> > > >ipaddress the dbmail-pop3d server
> > > >
> > > > > has to bind to, * for all addresses
> > > > > PORT=110
> > > > > # the port
> > > >
> > > >number the dbmail-pop3d server
> > > >
> > > > > has to bind to. NCHILDREN=50
> > > > > #
> > > >
> > > >default number of POP3
> > > >
> > > > > handlers (each is a process) MAXCHILDREN=200
> > > >
> > > > # mac.
> > > >
> > > > > number of POP3 handlers
> > > > > MINSPARECHILDREN=2
> > > > > MAXSPARECHILDREN=4
> > > > > MAXCONNECTS=10000 # the
> > > > > maximum number
> > > >
> > > >of connections a
> > > >
> > > > > default childs makes
> > > > > TIMEOUT=300
> > > > > # the time (s)
> > > >
> > > >before the dbmail-pop3d
> > > >
> > > > > should shutdown a connection which is being idle.
> > > > > RESOLVE_IP=yes # if yes, the pop
> > > > > daemon
> > > >
> > > >resolves IP
> > > >
> > > > > numbers to DNS names in the log
> > > > > POP_BEFORE_SMTP=no
> > > > > TRACE_LEVEL=2
> > > > >
> > > > > [IMAP]
> > > > > EFFECTIVE_USER=nobody
> > > > > EFFECTIVE_GROUP=nogroup
> > > > > BINDIP=*
> > > > > PORT=143
> > > > > NCHILDREN=50
> > > > > MAXCHILDREN=200 #
> > > > > mac. number of
> > > >
> > > >IMAPD handlers
> > > >
> > > > > MINSPARECHILDREN=2
> > > > > MAXSPARECHILDREN=4
> > > > > MAXCONNECTS=10000 # the
> > > > > maximum number
> > > >
> > > >of connections a
> > > >
> > > > > default childs makes
> > > > > TIMEOUT=4000
> > > > > # the time (s)
> > > >
> > > >before the dbmail-imapd
> > > >
> > > > > should shutdown a connection which is being idle.
> > > > > RESOLVE_IP=yes # if yes, the
> > > > > imap daemon
> > > >
> > > >resolves IP
> > > >
> > > > > numbers to DNS names in the log
> > > > > IMAP_BEFORE_SMTP=no
> > > > > TRACE_LEVEL=2
> > > > >
> > > > > # end of configuration file
> > > >
> > > >Did you check your log like it says?
> > > >
> > > >
> > > >_______________________________________________
> > > >Dbmail mailing list
> > > >[email protected]
> > > >https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > >
> > > Entering this,
> > >
> > > dbmail-users -l
> > >
> > > this is what is in the log file....
> > >
> > > Mar 11 13:39:30 cpe-66-65-161-178 dbmail/adduser[4139]:
> > > dbmysql.c,db_connect: mysql_real_connect failed: Access denied for
user
> > > 'root'@'localhost' (using password: NO)
> > >
> > > I would have thought it would be using dbuser from the
/etc/dbmail.conf
> > > file...
> > >
> > >
> > > Jim
> > >
> > >
> > > _______________________________________________
> > > Dbmail mailing list
> > > [email protected]
> > > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> >_______________________________________________
> >Dbmail mailing list
> >[email protected]
> >https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
> I tried rebuilding dbmail, that is my problem.
> ./configure --with -mysql runs ok
> make all gives me this error,
> libtool: link : cannot find library '/usr/lib/mysql/libz.la'
>
> I rebuilt and reinstalled the MySQL source RPM's yesterday.
>
> I have no idea what file it may be missing from the MySQl install, but
> that's what I think is the problem.
>
> Any suggestions?
>
> Jim
>
>
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
I saw that. That upgrade will resolve the dbmail build with mysql but...
When I upgrade to MySQL 5.0.18 the Postfix build with mysql can't complete
because it can't find libsqlclient.so.14. (I spent a few hours trying to
resolve the libsqlclient.so.14. before going back to MySQL 4.0.16)
I'm using Fedora Core 4.
Jim
