[Samba] pdb_mysql.c | SQL insert command missing data

[John Smith Jr]

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