Hey,
I'm trying to use the mysql plugin with Samba 3.0.2 and am running
into problems with the password storing aspect of the equation.
Specifically, here is how I have the smb.conf file setup:
[global]
workgroup = SRS
netbios name = DustPuppy
passdb backend = mysql:mysql
mysql:mysql host = localhost
mysql:mysql user = samba
mysql:mysql password = blah
mysql:mysql database = samba
mysql:fullname column = fullname:
mysql:domain column = 'SRS':
mysql:lanman pass column = lm_pw:
mysql:nt pass column = nt_pw:
mysql:plain pass column = plain_pw:
mysql:unknown_3 column = NULL
security = user
encrypt passwords = yes
smb passwd file = /etc/samba/private/smbpasswd
Now if I try to add a user either with smbpasswd or pdbedit, it
appears to accept the username gracefully.
dustpuppy root # pdbedit -a cverges
No builtin backend found, trying to load plugin
Module '/usr/lib/samba/pdb/mysql.so' loaded
Connecting to database server, host: localhost,
user: samba, password: blah, database: samba, port: 3306
Connecting to database server, host: localhost,
user: samba, password: blah, database: samba, port: 3306
new password: <entered here>
retype new password: <entered here>
Unix username: cverges
NT username:
Account Flags: [U ]
User SID: S-1-5-21-517885770-1754025824-426584352-3000
Primary Group SID: S-1-5-21-517885770-1754025824-426584352-1881
Full Name:
Home Directory: \\dustpuppy\cverges
HomeDir Drive:
Logon Script:
Profile Path: \\dustpuppy\cverges\profile
Domain: SRS
Account desc:
Workstations:
Munged dial:
Logon time: 0
Logoff time: 0
Kickoff time: 0
Password last set: Mon, 31 May 2004 21:16:58 GMT
Password can change: Mon, 31 May 2004 21:16:58 GMT
Password must change: Mon, 18 Jan 2038 21:14:07 GMT
And the username appears with a pdbedit -L query. But if I try to
login from a WinXP client, it simply says that I do not have a valid
password. I looked in the mysql tables, and sure enough no password
information was stored in any of the fields. For giggles, I
set "encrypt passwords = no", but nothing was stored in the plain
password column either.
I'm now at a loss for things to try. Any advice would be greatly
appreciated.
Thanks!
chris verges
gte699u@mail.gatech.edu
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@mail.gatech.edu
Quoting "Collen Blijenberg <MLHJ>" <systeembeheer@hermanjordan.nl>:> Dunno, try to comment out all mysql collumns.. > (mysql:host -till- mysql:unknow_3) > and fire up your debug level.. to get more info..Commenting out the columns seemed to help. Why does the Samba Collection HOWTO say to include those? *Very confused* Thanks for your help, Collen! chris verges gte699u@mail.gatech.edu 404-909-5486 Ham Radio: KG4YSN