samba - Dec 2003 - MySQL passdb backend (mysql_init)?

Greetings All,

I am trying to use MySQL4 as the backend for authentication through Samba 3.0.0.
When I finally got it to compile ok (damn that mysql/mysql.h) I cannot get it to
work. Below you'll find the log transcript from when I try to connect with
any client -- smbclient in this case. And yes, I have the MySQL-part setup
correctly using the example mysql.dump from the dist and the user can connect ok
and perform selects...

I would appreciate to hear from anyone who has attempted to pull off the same
setup to see if this actually can be done!

Thanks!


The relevant rows from smb.conf are:
        passdb backend = mysql:mailserv
        mailserv:mysql host = [IP]
        mailserv:mysql password = [PASSWD]
        mailserv:mysql user = samba
        mailserv:mysql database = samba
        mailserv:mysql port = 3306
        mailserv:table = users


Log file entries:
[2003/12/08 13:07:48, 5] passdb/pdb_interface.c:make_pdb_methods_name(431)
  Attempting to find an passdb backend to match mysql:mailserv (mysql) No
builtin backend found, trying to load plugin
[2003/12/08 13:07:48, 5] lib/module.c:smb_probe_module(102)
  Probing module 'mysql'
[2003/12/08 13:07:48, 5] lib/module.c:smb_probe_module(113)
  Probing module 'mysql': Trying to load from
/usr/local/samba3/lib/pdb/mysql.so
[2003/12/08 13:07:48, 5] passdb/pdb_interface.c:smb_register_passdb(55)
  Attempting to register passdb backend mysql
[2003/12/08 13:07:48, 5] passdb/pdb_interface.c:smb_register_passdb(68)
  Successfully added passdb backend 'mysql'
[2003/12/08 13:07:48, 2] lib/module.c:do_smb_load_module(64)
  Module '/usr/local/samba3/lib/pdb/mysql.so' loaded
[2003/12/08 13:07:48, 5] passdb/pdb_interface.c:make_pdb_methods_name(452)
  Found pdb backend mysql
[2003/12/08 13:07:48, 1] passdb/pdb_mysql.c:mysqlsam_init(922)
  Connecting to database server, host: [IP], user: samba, password: [PASSWD],
database: samba, port: 3306
sbin/smbd: relocation error: /usr/local/samba3/lib/pdb/mysql.so: undefined
symbol: mysql_init

Looks like the compilation didn't worked well.

Did you used ?

        --with-mysql
        --with-expsam=mysql

regards
thiago


> -----Original Message-----
> From: 
> samba-bounces+thiagolima=webforce.com.br@lists.samba.org 
> [mailto:samba-bounces+thiagolima=webforce.com.br@lists.samba.o
> rg] On Behalf Of Didde Brockman
> Sent: Monday, December 08, 2003 10:16 AM
> To: samba@lists.samba.org
> Subject: [Samba] MySQL passdb backend (mysql_init)?
> 
> 
> Greetings All,
> 
> I am trying to use MySQL4 as the backend for authentication 
> through Samba 3.0.0. When I finally got it to compile ok 
> (damn that mysql/mysql.h) I cannot get it to work. Below 
> you'll find the log transcript from when I try to connect 
> with any client -- smbclient in this case. And yes, I have 
> the MySQL-part setup correctly using the example mysql.dump 
> from the dist and the user can connect ok and perform selects...
> 
> I would appreciate to hear from anyone who has attempted to 
> pull off the same setup to see if this actually can be done!
> 
> Thanks!
> 
> 
> The relevant rows from smb.conf are:
>         passdb backend = mysql:mailserv
>         mailserv:mysql host = [IP]
>         mailserv:mysql password = [PASSWD]
>         mailserv:mysql user = samba
>         mailserv:mysql database = samba
>         mailserv:mysql port = 3306
>         mailserv:table = users
> 
> 
> Log file entries:
> [2003/12/08 13:07:48, 5] 
> passdb/pdb_interface.c:make_pdb_methods_name(431)
>   Attempting to find an passdb backend to match 
> mysql:mailserv (mysql) No builtin backend found, trying to 
> load plugin    
> [2003/12/08 13:07:48, 5] lib/module.c:smb_probe_module(102)
>   Probing module 'mysql'
> [2003/12/08 13:07:48, 5] lib/module.c:smb_probe_module(113)
>   Probing module 'mysql': Trying to load from 
> /usr/local/samba3/lib/pdb/mysql.so
> [2003/12/08 13:07:48, 5] 
> passdb/pdb_interface.c:smb_register_passdb(55)
>   Attempting to register passdb backend mysql
> [2003/12/08 13:07:48, 5] 
> passdb/pdb_interface.c:smb_register_passdb(68)
>   Successfully added passdb backend 'mysql'
> [2003/12/08 13:07:48, 2] lib/module.c:do_smb_load_module(64)
>   Module '/usr/local/samba3/lib/pdb/mysql.so' loaded 
> [2003/12/08 13:07:48, 5] 
> passdb/pdb_interface.c:make_pdb_methods_name(452)
>   Found pdb backend mysql
> [2003/12/08 13:07:48, 1] passdb/pdb_mysql.c:mysqlsam_init(922)
>   Connecting to database server, host: [IP], user: samba, 
> password: [PASSWD], database: samba, port: 3306
> sbin/smbd: relocation error: 
> /usr/local/samba3/lib/pdb/mysql.so: undefined symbol: mysql_init
> -- 
> To unsubscribe from this list go to the following URL and read the
> instructions:  http://lists.samba.org/mailman/listinfo/samba
>