[dspam-users] Re: mysql_init: unable to initialize handle to database

On Thu, Mar 15, 2007 at 10:16:34PM +0000, 24x7server wrote:
> we configured and installed dspam with these options
>
> ./configure ...
> --with-storage-driver=mysql_drv
> --with-mysql-includes=/usr/include/mysql
> --with-mysql-libraries=/usr/lib/mysql
> --enable-preferences-extension
> --enable-signature-headers
> --enable-mysql4-initialization
>
> we are getting this error in dspam.debug
>
> _ds_init_storage() failed
> _ds_init_storage: mysql_init: unable to initialize handle to database

Double-check that your MySQL configuration in your dspam.conf is
correct, i.e. MySQLServer, MySQLUser, MySQLPass, and MySQLdb.

> and further on we noted that the file libmysql_drv.so does not exist
> at all
>
> /etc/dspam/lib/libmysql_drv.so

It won't do; if you only specify one storage driver, it is statically
linked into dspam. If you really want it as an external library, you can
specify the same storage driver twice:

  --with-storage-driver=mysql_drv,mysql_drv
Received on Fri Mar 16 00:27:44 2007