I didnt try to comment out foo:domain column = 'DOMAIN' because I reverted before I received your last message. I know that samba was able to read and insert the sql (permission wise) because I did check useing the samba_sql_user with samba_sql_password. I also know this because the samba password file, which is the only backup login method, did not contain anyone but administrator; yet people who already had accounts were able to login and there profile loaded etc.
Also, users that I added BY HAND to the Sql database worked just fine.
Does Anyone know if the SMB.conf requires changes with 3.13 so that samba will insert the data for the following fields. Is is possible that samba is trying to change the type versus what used to be there? Ie # instead of V char etc.
username domain nt_username nt_fullname home_dir dir_drive
Note that there were no other changes to the system nor any changes to the smb.conf besides compileing samba 3.10 to make the system work again.
System:
Gentoo Linux
x86 Core
Kernel 2.6.10
Samba Configured as PDC, Mysql passdb
Mysql on same physical machine. Accepts local host connections useing samba sql_username/pass
Collen wrote:
Hmm, You don't miss mutch.. straingely you miss a username aswell in the DB!
Did you make the posix users aswell ?? (with a script?) try to comment 'foo:domain column = 'DOMAIN' ' out, and try again
also try to connect to the databse with a mysql-client, to see if that part works.!
use the exact same settings you use with samba!
(user, ip, pass)
and try to update a record, ea. username ?
if that part works (the mysqlclient), you know that the problem is something else.
my guesses is that it's a matter of eliminating possebilety's..
Collen.
Ben Gaide wrote:
Samba is Connecting and Inserting 1 Row, but It only sets 2 colums. NT Password and Lanman Password, The other colums Stay as Default.
For Insance. For the Attached log file I started Samba
As Root Did smbpasswd -a username password password
Stop Samba
The mysql Database has the following new row
Row Headers
logon_time logoff_time kickoff_time pass_last_set_time pass_can_change_time pass_must_change_time username domain nt_username nt_fullname home_dir dir_drive logon_script profile_path acct_desc workstations unknown_str munged_dial uid gid user_sid group_sid lm_pw nt_pw acct_ctrl unknown_3 logon_divs hours_len unknown_5 unknown_6 bad_password_count logon_count
Values
NULL NULL NULL 1112742397 1112742397 2147483647 NULL FIJINET NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 75 NULL NULL NULL AAA8B176C3D8E3DEAAD3AA35B51404EE AAA899154197E8AAA33121D76A240AB5 16 NULL NULL NULL NULL NULL NULL NULL
Collen wrote:
No errors in the log ??? try setting the debug level a little higher.. (2 - 5) if samba can't connect to the db, it will show's up.
you could also try to login with a mysql client, with the same settings of your samba config, to see if that part is right.
dunno how you configed the mysql-server, sometimes people
set it to only connect to the localhost (127.0.0.1)
or disable localhost, and make it use the network IP.
just be sure, that the settings you use within samba also work with the mysql-client.
but in both cases you should see debug info in the samba log's
(like can't connect to the passwd-backend mysql, or something like that)
Laterz Collen.
Ben Gaide wrote:
I didnt change anything else excludeing printer settings which when I reverted to the old config file still made no difference. I can add foo:mysql host = xxx.xxx.xxx.xxx, but I understand it deafults to local host and it is clear to see that it does actually connect and insert the correct lanman password. It even will change the password of people that were added before the update properly.
Log file lists No errors and I could not find any useful info. I will stop samba, Clear the log, start samba add user stop samba and attach that log later today.
i miss the ' foo:mysql host = xxx.xxx.xxx.xxx '
also what is your log-file telling you? does it find the backend? did something else change aswell ? Greet's Collen
Ben Gaide wrote:
I updated samba from 3.10 to 3.13 to get the updated print fixes, but I noticed today that the smbpasswd script no longer functions. It fails to update the the following fields.
Please let me know if you have any ideas.
Sorry I didnt include the appropriate config file so I will atach the appropriate section now. Please not it is 3.0.13 not 3.13 as that would be impossible.
# Samba Password Database configuration: passdb backend = mysql:foo foo:mysql user = samba foo:mysql password = PASSWORD foo:mysql database = samba foo:domain column = 'DOMAIN'
-- To unsubscribe from this list go to the following URL and read the instructions: https://lists.samba.org/mailman/listinfo/samba
