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.
domain
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60domain%60+ASC>
nt_username
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60nt_username%60+ASC>
nt_fullname
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60nt_fullname%60+ASC>
home_dir
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60home_dir%60+ASC>
dir_drive
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60dir_drive%60+ASC>
logon_script
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60logon_script%60+ASC>
profile_path
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60profile_path%60+ASC>
acct_desc
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60acct_desc%60+ASC>
workstations
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60workstations%60+ASC>
unknown_str
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60unknown_str%60+ASC>
munged_dial
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60munged_dial%60+ASC>
uid
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60uid%60+ASC>
gid
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60gid%60+ASC>
user_sid
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60user_sid%60+ASC>
group_sid
<http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60group_sid%60+ASC>
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'
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. > > domain > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60domain%60+ASC> > > > nt_username > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60nt_username%60+ASC> > > > nt_fullname > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60nt_fullname%60+ASC> > > > home_dir > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60home_dir%60+ASC> > > > dir_drive > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60dir_drive%60+ASC> > > > logon_script > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60logon_script%60+ASC> > > > profile_path > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60profile_path%60+ASC> > > > acct_desc > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60acct_desc%60+ASC> > > > workstations > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60workstations%60+ASC> > > > unknown_str > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60unknown_str%60+ASC> > > > munged_dial > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60munged_dial%60+ASC> > > > uid > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60uid%60+ASC> > > > gid > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60gid%60+ASC> > > > user_sid > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60user_sid%60+ASC> > > > group_sid > <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60group_sid%60+ASC> > > > > 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' >
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. >>> >>> domain >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60domain%60+ASC> >>> >>> nt_username >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60nt_username%60+ASC> >>> >>> nt_fullname >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60nt_fullname%60+ASC> >>> >>> home_dir >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60home_dir%60+ASC> >>> >>> dir_drive >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60dir_drive%60+ASC> >>> >>> logon_script >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60logon_script%60+ASC> >>> >>> profile_path >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60profile_path%60+ASC> >>> >>> acct_desc >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60acct_desc%60+ASC> >>> >>> workstations >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60workstations%60+ASC> >>> >>> unknown_str >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60unknown_str%60+ASC> >>> >>> munged_dial >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60munged_dial%60+ASC> >>> >>> uid >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60uid%60+ASC> >>> >>> gid >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60gid%60+ASC> >>> >>> user_sid >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60user_sid%60+ASC> >>> >>> group_sid >>> <http://db.csmfiji.org/mysql/sql.php?lang=en-iso-8859-1&server=1&db=samba&table=user&pos=30&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=SELECT+%2A+FROM+%60user%60++ORDER+BY+%60group_sid%60+ASC> >>> >>> >>> >>> 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' >>> >