krolik26
n00b
Joined: 23 Mar 2004
Posts: 56
Location: Germany
|
 Posted: Sun Oct 09, 2005 4:28 pm Post subject: Problem mit pdbedit; Samba mit Mysql als Backend |
 |
|
halo leute,
hab mir samba mit mysql als backend installiert. mein system hab ich mir vor einer woche frisch aufgesetzt.
mein problem:
samba erstellt neue eintraege im mysql nachdem ich mit windows dateien erstelle oder loesche.
hier ausschnitt von smb.conf:
| Code: | [global]
load printers = no
netbios name = hades
security = share
socket options = TCP_NODELAY IPTOS_LOWDELAY SO_RCVBUF=8192 SO_SNDBUF=8192
socket address = 192.168.0.100 #server-ip
workgroup = Xintern
log file = /var/log/samba/%m.log
log level = 2
interfaces = lo eth1
bind interfaces only = yes
hosts allow = 127.0.0.1 192.168.0.10 #meine windows-maschiene
hosts deny = 0.0.0.0/0
guest account = smbuser
guest ok = yes
browseable = yes
remote browse sync = 192.168.0.255
passdb backend = mysql:mysql
mysql:mysql host = localhost
mysql:mysql user = samba
mysql:mysql password = xxx
mysql:mysql database = sys_smb
mysql:mysql table = user
# fuer mein rechner
[www]
path = /var/www
comment = www
browseable = yes
writeable = yes
force user = www #benutzer steht im mysql
force group = apache #gruppe steht im system
create mask = 0740
directory mask = 0740
valid users = www
guest ok = no
# fuer alle
[public]
path = /tmp/public
browseable = yes
comment = public
writeable = yes
force group = nogroup
force user = nobody
create mask = 0644
directory mask = 0644 |
smbuser: | Code: | janus / # cat /etc/samba/smbusers
# Unix_name = SMB_name1 SMB_name2 ...
# $Header: /var/cvsroot/gentoo/src/patchsets/samba/configs/smbusers,v 1.1 2005/08/09 12:56:26 seemant Exp $
apache = www |
hier die logs:
| Code: | [2005/10/09 18:08:47, 2] lib/access.c:check_access(324)
Allowed connection from (192.168.0.10)
[2005/10/09 18:08:47, 0] passdb/pdb_mysql.c:mysqlsam_replace_sam_account(390)
Error executing UPDATE user SET WHERE user_sid = 'S-1-5-21-3119157750-2486268994-1132829598-500', You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_sid = 'S-1-5-21-3119157750-2486268994-1132829598-500
[2005/10/09 18:08:47, 1] auth/auth_sam.c:check_sam_security(291)
Failed to modify entry.
[2005/10/09 18:08:47, 2] auth/auth.c:check_ntlm_password(312)
check_ntlm_password: Authentication for user [www] -> [www] FAILED with error NT_STATUS_WRONG_PASSWORD
[2005/10/09 18:08:47, 2] auth/auth.c:check_ntlm_password(312)
check_ntlm_password: Authentication for user [smbuser] -> [smbuser] FAILED with error NT_STATUS_WRONG_PASSWORD
|
nach dem fehler: "Error executing UPDATE user SET WHERE user_sid" steht ein neuer eintrag in der tabelle, mit neuer uid, wert 17 in acct_ctrl und "NULL" werten in anderen spalten.
je oefter ich eine neue datei erstelle oder loesche, desto mehr eintraege krieg ich in der tabelle!
hier das verz. vom www:
| Code: | janus / # ls -alhF /var/www/
total 0
drwxr--r-- 7 apache apache 176 Oct 9 04:25 ./
drwxr-xr-x 16 root root 440 Sep 27 22:43 ../
drwxr--r-- 6 apache apache 168 Sep 29 10:12 development/
drwxr--r-- 6 apache apache 168 Sep 29 10:12 download/
drwxr--r-- 6 apache apache 168 Sep 29 10:11 test/
drwxr--r-- 6 apache apache 168 Sep 25 05:25 localhost/ |
hier ein mysql-dump vom phpmyadmin: | Code: |
CREATE TABLE `user` (
`uid` int(9) unsigned NOT NULL auto_increment,
`gid` int(9) unsigned default NULL,
`acct_ctrl` int(9) unsigned default NULL,
`logon_divs` int(9) unsigned default NULL,
`hours_len` int(9) unsigned default NULL,
`logon_time` int(9) unsigned default NULL,
`logoff_time` int(9) unsigned default NULL,
`kickoff_time` int(9) unsigned default NULL,
`pass_last_set_time` int(9) unsigned default NULL,
`pass_can_change_time` int(9) unsigned default NULL,
`pass_must_change_time` int(9) unsigned default NULL,
`bad_password_count` int(9) unsigned NOT NULL default '0',
`logon_count` int(9) unsigned NOT NULL default '0',
`dir_drive` varchar(4) default NULL,
`user_sid` varchar(255) default NULL,
`group_sid` varchar(255) default NULL,
`username` varchar(255) default NULL,
`domain` varchar(255) default NULL,
`nt_username` varchar(255) default NULL,
`nt_fullname` varchar(255) default NULL,
`home_dir` varchar(255) default NULL,
`logon_script` varchar(255) default NULL,
`profile_path` varchar(255) default NULL,
`acct_desc` varchar(255) default NULL,
`workstations` varchar(255) default NULL,
`unknown_str` varchar(255) default NULL,
`munged_dial` varchar(255) default NULL,
`lm_pw` varchar(255) default NULL,
`nt_pw` varchar(255) default NULL,
`unknown_3` int(9) default NULL,
`unknown_5` int(9) default NULL,
`unknown_6` int(9) default NULL,
PRIMARY KEY (`uid`)
) TYPE=MyISAM AUTO_INCREMENT=56 ;
INSERT INTO `user` VALUES (1, NULL, 16, NULL, NULL, NULL, NULL, NULL, 1128822613, 1128822613, 2147483647, 0, 0, NULL, 'S-1-5-21-3119157750-2486268994-1132829598-500', NULL, 'www', NULL, NULL, NULL, '/var/www', NULL, NULL, NULL, NULL, NULL, NULL, 'A72DCC2D06EA3A79D9DD7235D9567AEC', '178D0349095556F12D3035634DE05667', NULL, NULL, NULL);
INSERT INTO `user` VALUES (39, NULL, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
|
der erste benutzer ist "www", alle anderen "NULL". es sind mitlerweile 56 "NULL"-benutzer. ich hab jetzt den samba gestopt.
hat jemand eine idee woran es liegen kann?
ich moechte einfach nur die samba-benutzer in der mysql stehen haben, weil es spaeter noch mehr benutzer geben wird. moechte keine weiteren benutzer in der /etc/passwd haben als noetig.
danke |
|
Deutsches Forum (German)
