[Samba] mysql passwd backend

[Collen Blijenberg <MLHJ>]

Dunno, try to comment out all mysql collumns..
(mysql:host -till- mysql:unknow_3)
and fire up your debug level.. to get more info..
l8r
-----------------------------------------------------
Collen Blijenberg   (Montessori Lyceum Herman Jordan)

Tuesday, June 1, 2004, 4:21:53 AM, you wrote:

CV> Hey,

CV> I'm trying to use the mysql plugin with Samba 3.0.2 and am running
CV> into problems with the password storing aspect of the equation.  
CV> Specifically, here is how I have the smb.conf file setup:

CV>    [global]
CV>       workgroup = SRS
CV>       netbios name = DustPuppy

CV>       passdb backend           = mysql:mysql
CV>       mysql:mysql host         = localhost
CV>       mysql:mysql user         = samba
CV>       mysql:mysql password     = blah
CV>       mysql:mysql database     = samba
CV>       mysql:fullname column    = fullname:
CV>       mysql:domain column      = 'SRS':
CV>       mysql:lanman pass column = lm_pw:
CV>       mysql:nt pass column     = nt_pw:
CV>       mysql:plain pass column  = plain_pw:
CV>       mysql:unknown_3 column   = NULL

CV>       security = user
CV>       encrypt passwords = yes
CV>       smb passwd file = /etc/samba/private/smbpasswd

CV> Now if I try to add a user either with smbpasswd or pdbedit, it 
CV> appears to accept the username gracefully.

CV>    dustpuppy root # pdbedit -a cverges
CV>    No builtin backend found, trying to load plugin
CV>    Module '/usr/lib/samba/pdb/mysql.so' loaded
CV>    Connecting to database server, host: localhost,
CV>       user: samba, password: blah, database: samba, port: 3306
CV>    Connecting to database server, host: localhost,
CV>       user: samba, password: blah, database: samba, port: 3306
CV>    new password:          <entered here>
CV>    retype new password:   <entered here>
CV>    Unix username:        cverges
CV>    NT username:
CV>    Account Flags:        [U          ]
CV>    User SID:            
CV> S-1-5-21-517885770-1754025824-426584352-3000
CV>    Primary Group SID:   
CV> S-1-5-21-517885770-1754025824-426584352-1881
CV>    Full Name:
CV>    Home Directory:       \\dustpuppy\cverges
CV>    HomeDir Drive:
CV>    Logon Script:
CV>    Profile Path:         \\dustpuppy\cverges\profile
CV>    Domain:               SRS
CV>    Account desc:
CV>    Workstations:
CV>    Munged dial:
CV>    Logon time:           0
CV>    Logoff time:          0
CV>    Kickoff time:         0
CV>    Password last set:    Mon, 31 May 2004 21:16:58 GMT
CV>    Password can change:  Mon, 31 May 2004 21:16:58 GMT
CV>    Password must change: Mon, 18 Jan 2038 21:14:07 GMT

CV> And the username appears with a pdbedit -L query.  But if I try to
CV> login from a WinXP client, it simply says that I do not have a valid
CV> password.  I looked in the mysql tables, and sure enough no password
CV> information was stored in any of the fields.  For giggles, I 
CV> set "encrypt passwords = no", but nothing was stored in the plain 
CV> password column either.

CV> I'm now at a loss for things to try.  Any advice would be greatly 
CV> appreciated.

CV> Thanks!

CV> chris verges
CV> gte699u at mail.gatech.edu