The MYSQL pdb addon for samba appears to have had an error since version 3.0.12. In doing some investigations with 3.0.20 and 3.0.14-r3 I have found that the smbpasswd command does not create a query that adds enough information to the database. smbpasswd -a username causes 2 queries to be performed. The first of the two looks for an existing user and that does check all of the appropriate fields, but the next command which is for inserting information runs the following command. INSERT INTO user (acct_ctrl,pass_can_change_time,pass_must_change_time,pass_last_set_time,lm_pw,nt_pw) VALUES (16,1124620545,2147483647,1124620545,'AAAAAAA71AA612E1ED5A6FED37AAAAAA','AAAAAAA6293F6293129F9BE9EBAAAAAA') You will note that there is no username, domain, nt_username, nt_fullname, home_dir, dir_drive, logon_script, profile_path, uid, gid, user_sid, or group_sid in that query. This shows that the error is not on the part of the sql database as this is the query it was sent, received, and processed properly. Since existing users can function properly it seems that the error is only with adding new users and not with changing passwords of existing users. I have checked the smb.conf file and tryed this with both defining all of the colums, and with just defining the mysql connection information with the same result. It appears that in the source file the insert function is just the update function with the isupdate set to 0. This seems to be a problem as the update function seems to only update the fields associated with the password and not those associated with the rest of the users information. Please advise. Thanks Ben G __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
The MYSQL pdb addon for samba appears to have had an error since version 3.0.12. In doing some investigations with 3.0.20 and 3.0.14-r3 I have found that the smbpasswd command does not create a query that adds enough information to the database. smbpasswd -a username causes 2 queries to be performed. The first of the two looks for an existing user and that does check all of the appropriate fields, but the next command which is for inserting information runs the following command. INSERT INTO user (acct_ctrl,pass_can_change_time,pass_must_change_time,pass_last_set_time,lm_pw,nt_pw) VALUES (16,1124620545,2147483647,1124620545,'AAAAAAA71AA612E1ED5A6FED37AAAAAA','AAAAAAA6293F6293129F9BE9EBAAAAAA') You will note that there is no username, domain, nt_username, nt_fullname, home_dir, dir_drive, logon_script, profile_path, uid, gid, user_sid, or group_sid in that query. This shows that the error is not on the part of the sql database as this is the query it was sent, received, and processed properly. Since existing users can function properly it seems that the error is only with adding new users and not with changing passwords of existing users. I have checked the smb.conf file and tryed this with both defining all of the colums, and with just defining the mysql connection information with the same result. It appears that in the source file the insert function is just the update function with the isupdate set to 0. This seems to be a problem as the update function seems to only update the fields associated with the password and not those associated with the rest of the users information. Please advise. Thanks Ben G __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com