[Samba] RE: MYSQL - Was Functional till Update to 3.13

Ben Gaide bgaide at Mines.EDU
Sat Apr 2 01:15:52 GMT 2005


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'



More information about the samba mailing list