Dear All,
wasn't sure my last question got posted, i decided to re-post with more
concise explanation of the problem i'm facing.
I have samba PDC (version 3.0.14a) working fine before with smbpasswd
backend.
a few weeks ago, we decide to move to mysql backend since we have email
server with mysql backend as well. I'm trying to use one username and
password for both email and samba services.
so, re-configure samba with pdb mysql.
As of now, samba connects to mysql server (samba log shows no problem
connecting to mysql).
However, when i tried to add user ( via "pdbedit -a <username>"
command
or "smbpasswd -a" command or via SWAT add user interface), the entry
in
mysql only shows "NULL" value for all fields, except ACCT_CTRL field
(inserted value of "16").
Samba and MySQL logs shows no error whatsoever.
I believe the problem is with samba, not mysql.
My smb.conf for MySQL backend as follow :
passdb backend = mysql:bmais
bmais:mysql database = <database>
bmais:mysql password = <password>
bmais:mysql user = root
bmais:mysql host = db.bmais.or.id
bmais:table = bmais_or_id
bmais:domain column = 'bmais.or.id'
bmais:username column = pw_name:
bmais:nt username column = pw_name:
bmais:fullname column = pw_gecos:
bmais:lanman pass column = pw_passwd:
I assume the fields that are not being specify would follow pdb_mysql
default values, isn't it?
can someone give pointer what's wrong?
pardon my explanation. if anything is unclear, i would be more than happy
to elaborate more.
Thanks
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Edy Sulai wrote: | I have samba PDC (version 3.0.14a) working fine | before with smbpasswd backend. a few weeks ago, | we decide to move to mysql backend since we have email | server with mysql backend as well. I'm trying to use | one username and password for both email and samba | services. There were fixed to the pdb_mysql backend in 3.0.20a (we got new maintainers). Before you do anything, you sould retest against that release. cheers, jerry -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD4DBQFDTlZAIR7qMdg1EfYRAreTAJdeuk5s9n7POKv7iDBi/4Ej/pXOAKDRg/8k iearNF6/lsqTUg1cVIXvww==fPCE -----END PGP SIGNATURE-----
The 3.0.20 version had a bug, so mysql passwd backend will not work the
normal/standard way.
did not tested the 3.0.20 a & b version, but it might be fixed..
passdb backend = mysql:bmais
bmais:mysql database = <database>
bmais:mysql password = <password>
bmais:mysql user = root
bmais:mysql host = db.bmais.or.id
> bmais:table = bmais_or_id
> bmais:domain column = 'bmais.or.id'
> bmais:username column = pw_name:
> bmais:nt username column = pw_name:
> bmais:fullname column = pw_gecos:
> bmais:lanman pass column = pw_passwd:
|
-> try to comment these out with #, your problem might be here. (but i'm
not sure)
Goodluck
Edy Sulai wrote:> Thanks for the quick response.
> yes, I did create unix users first. then proceed to create samba users.
>
> I tried upgrading samba version from 3.0.14a to 3.0.20, i still does the
> same thing.
>
> Now, I'm redoing all the samba works from scratch again. hopefully
samba
> 3.0.20 doesn't give me the same problem. any idea what's wrong if
samba
> pdb_mysql still behave this way?
>
> thanks
>
>
> Edy
>
>> Did you create the unix users before the mysql users ??
>>
>> Greetz, Collen
>>
>> Gerald (Jerry) Carter wrote:
>>> -----BEGIN PGP SIGNED MESSAGE-----
>>> Hash: SHA1
>>>
>>> Edy Sulai wrote:
>>>
>>> | I have samba PDC (version 3.0.14a) working fine
>>> | before with smbpasswd backend. a few weeks ago,
>>> | we decide to move to mysql backend since we have email
>>> | server with mysql backend as well. I'm trying to use
>>> | one username and password for both email and samba
>>> | services.
>>>
>>> There were fixed to the pdb_mysql backend in 3.0.20a (we
>>> got new maintainers). Before you do anything, you sould
>>> retest against that release.
>>>
>> --
>> To unsubscribe from this list go to the following URL and read the
>> instructions: https://lists.samba.org/mailman/listinfo/samba
>>
>
>