frage zu mod_sql, un anderem.

[Wörsty]

Muß mich korrigieren:

Code:

INSERT INTO users (username, passwd, fullname, valid, count, lastlogin, homedir)
VALUES ('loginname', password('passwort'), 'kompletter name', 1, 0,now(),'/home/verzeichnis');

Das Paßwort wird ja verschlüsselt gespeichert.

[Anonymous]

also habe 530 login inorect??

die proftpd_sql,log sagt :

Code:

Jun 23 13:31:30 mod_sql/4.10[17987]: backend module 'mod_sql_mysql/4.04'
Jun 23 13:31:30 mod_sql/4.10[17987]: backend api    'mod_sql_api_v1'
Jun 23 13:31:30 mod_sql/4.10[17987]: >>> sql_getconf
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_defineconnection
Jun 23 13:31:30 mod_sql/4.10[17987]:  name: 'default'
Jun 23 13:31:30 mod_sql/4.10[17987]:  user: 'ftp'
Jun 23 13:31:30 mod_sql/4.10[17987]:  host: 'localhost'
Jun 23 13:31:30 mod_sql/4.10[17987]:    db: 'ftp'
Jun 23 13:31:30 mod_sql/4.10[17987]:  port: '3306'
Jun 23 13:31:30 mod_sql/4.10[17987]:   ttl: '0'
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_defineconnection
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' opened
Jun 23 13:31:30 mod_sql/4.10[17987]: : connection 'default' count is now 1
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: backend successfully connected.
Jun 23 13:31:30 mod_sql/4.10[17987]: mod_sql status     : on
Jun 23 13:31:30 mod_sql/4.10[17987]: negative_cache     : off
Jun 23 13:31:30 mod_sql/4.10[17987]: authenticate       : users* groups*
Jun 23 13:31:30 mod_sql/4.10[17987]: usertable          : users
Jun 23 13:31:30 mod_sql/4.10[17987]: userid field       : username
Jun 23 13:31:30 mod_sql/4.10[17987]: password field     : passwd
Jun 23 13:31:30 mod_sql/4.10[17987]: uid field          : NULL
Jun 23 13:31:30 mod_sql/4.10[17987]: gid field          : NULL
Jun 23 13:31:30 mod_sql/4.10[17987]: homedir field      : homedir
Jun 23 13:31:30 mod_sql/4.10[17987]: shell field        : NULL
Jun 23 13:31:30 mod_sql/4.10[17987]: homedirondemand    : true
Jun 23 13:31:30 mod_sql/4.10[17987]: group table        : gruppen
Jun 23 13:31:30 mod_sql/4.10[17987]: groupname field    : name
Jun 23 13:31:30 mod_sql/4.10[17987]: grp gid field      : ID
Jun 23 13:31:30 mod_sql/4.10[17987]: grp members field  : mitglieder
Jun 23 13:31:30 mod_sql/4.10[17987]: SQLMinUserUID      : 999
Jun 23 13:31:30 mod_sql/4.10[17987]: SQLMinUserGID      : 999
Jun 23 13:31:30 mod_sql/4.10[17987]: SQLDefaultUID      : 65533
Jun 23 13:31:30 mod_sql/4.10[17987]: SQLDefaultGID      : 65533
Jun 23 13:31:30 mod_sql/4.10[17987]: <<< sql_getconf
Jun 23 13:31:30 mod_sql/4.10[17987]: >>> cmd_getgroups
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_escapestring
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_escapestring
Jun 23 13:31:30 mod_sql/4.10[17987]: cache miss for user 'liq'
Jun 23 13:31:30 mod_sql/4.10[17987]: : entering         mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 2
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: query "SELECT username, passwd, homedir FR
Jun 23 13:31:30 mod_sql/4.10[17987]: query "SELECT username, passwd, homedir FR
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 1
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: cache miss for user 'liq'
Jun 23 13:31:30 mod_sql/4.10[17987]: user 'liq' cached
Jun 23 13:31:30 mod_sql/4.10[17987]: + pwd.pw_name  : liq
Jun 23 13:31:30 mod_sql/4.10[17987]: + pwd.pw_uid   : 65533
Jun 23 13:31:30 mod_sql/4.10[17987]: + pwd.pw_gid   : 65533
Jun 23 13:31:30 mod_sql/4.10[17987]: + pwd.pw_shell :
Jun 23 13:31:30 mod_sql/4.10[17987]: + pwd.pw_dir   : /home
Jun 23 13:31:30 mod_sql/4.10[17987]: cache miss for gid '65533'
Jun 23 13:31:30 mod_sql/4.10[17987]: : entering         mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 2
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: query "SELECT name FROM gruppen WHERE (ID
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 1
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: : entering         mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 2
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: query "SELECT name, ID, mitglieder FROM gr
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 1
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: <<< cmd_getgroups
Jun 23 13:31:30 mod_sql/4.10[17987]: >>> cmd_getgroups
Jun 23 13:31:30 mod_sql/4.10[17987]: cache hit for user 'liq'
Jun 23 13:31:30 mod_sql/4.10[17987]: cache miss for gid '65533'
Jun 23 13:31:30 mod_sql/4.10[17987]: : entering         mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 2
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: query "SELECT name FROM gruppen WHERE (ID
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 1
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: : entering         mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 2
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: query "SELECT name, ID, mitglieder FROM gr
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 1
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: <<< cmd_getgroups
Jun 23 13:31:30 mod_sql/4.10[17987]: >>> cmd_getpwnam
Jun 23 13:31:30 mod_sql/4.10[17987]: cache hit for user 'liq'
Jun 23 13:31:30 mod_sql/4.10[17987]: <<< cmd_getpwnam
Jun 23 13:31:30 mod_sql/4.10[17987]: >>> cmd_gid2name
Jun 23 13:31:30 mod_sql/4.10[17987]: cache miss for gid '65533'
Jun 23 13:31:30 mod_sql/4.10[17987]: : entering         mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 2
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_open
Jun 23 13:31:30 mod_sql/4.10[17987]: query "SELECT name FROM gruppen WHERE (ID
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: connection 'default' count is now 1
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_close
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_select
Jun 23 13:31:30 mod_sql/4.10[17987]: <<< cmd_gid2name
Jun 23 13:31:30 mod_sql/4.10[17987]: >>> cmd_auth
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_escapestring
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_escapestring
Jun 23 13:31:30 mod_sql/4.10[17987]: cache hit for user 'liq'
Jun 23 13:31:30 mod_sql/4.10[17987]: >>> cmd_check
Jun 23 13:31:30 mod_sql/4.10[17987]: checking auth_type Backend
Jun 23 13:31:30 mod_sql/4.10[17987]: entering   mysql cmd_checkauth
Jun 23 13:31:30 mod_sql/4.10[17987]: exiting    mysql cmd_checkauth
Jun 23 13:31:30 mod_sql/4.10[17987]: checking auth_type Empty
Jun 23 13:31:30 mod_sql/4.10[17987]: <<< cmd_check
Jun 23 13:31:30 mod_sql/4.10[17987]: <<< cmd_auth

[Wörsty]

Siehe 1 Sekunde vor dir.  :oops:

[Anonymous]

meine db sieht so aus :

Code:

mysql> select * from users;
+----------+--------+----------+-------+-------+---------------------+----------
---+
| username | passwd | fullname | valid | count | lastlogin           | homedir
   |
+----------+--------+----------+-------+-------+---------------------+----------
---+
| lolo    | XXXXX | chulu    |     1 |     0 | 2003-06-23 13:24:51 | /home/chu
lu |
| liq      | XXXX | liqiuem  |     1 |     0 | 2003-06-23 13:29:21 | /home
   |
+----------+--------+----------+-------+-------+---------------------+----------
---+
2 rows in set (0.00 sec)

mysql>

[Anonymous]

aso hehe okay, wie lösche ich die userb aus der db?

[Wörsty]

Junge, junge - du bist aber hartnäckig.
Probier doch mal selbst was... :wink:

Code:

DELETE FROM users WHERE username='lolo';
DELETE FROM users WHERE username='liq';

Oder du änderst das Paßwort einfach:

Code:

UPDATE users SET passwd=password('XXXXX') WHERE username='lolo';
UPDATE users SET passwd=password('XXXXX') WHERE username='liq';

[Anonymous]

also der db eintag sieht jezt so asu :

Code:

test     | 50b2ce7901afbce | test_only |     1 |     0 | 2003-06-23 13:39:30 | /home/

aber habe immernoch 530?? (

[Anonymous]

hartnäckig jaja, ich mus den server hochbekommen, das ist sehr wichtig, hab auch schon nen buch über sql, werde es sobald ich zeit habe lesen

[Wörsty]

Also das ist noch an?

Code:

RequireValidShell Off

Und das sieht so aus?

Code:

SQLUserInfo users username passwd NULL NULL homedir NULL

Dann weiß ich momentan nicht weiter.
Lege doch mal einen user anonymous ohne PW an.

Code:

SQLAuthTypes Backend Empty

Und guck dir mal die an:

Code:

SQLDefaultGID xyz
SQLDefaultUID xyz

[Anonymous]

ja meine .conf sieht so aus

:

Code:

RequireValidShell Off
SQLAuthenticate         users* groups*
SQLAuthTypes         Backend   Empty
SQLConnectInfo         ftp@localhost:3306 ftp ftp
SQLHomedirOnDemand      On
SQLUserInfo users username passwd NULL NULL homedir NULL
SQLGroupInfo          gruppen name ID mitglieder
SQLLogfile /var/log/proftpd_sql.log

[Wörsty]

Ändern:

Code:

SQLAuthenticate         users*

Löschen:

Code:

SQLGroupInfo          gruppen name ID mitglieder

Testen und üben üben üben

[Anonymous]

okay ich mus was essen dann jmus weg, danke dir vielmals für deine hilfe, ich werde es später nochma versuchen und mich dann in diesem topic melden

[Anonymous]

so habe jezt nen anonymous angelegt :

Code:

anonymous |                 | test_user |     1 |     0 | 2003-06-23 14:41:49
| /var/www/web1/files |

aber ich bekomme immer noch ein :

Code:

220 ProFTPD 1.2.9rc1 Server (ProFTPD Default Installation) [152048.vserver.de]
USER anonymous
331 Password required for anonymous.
PASS (hidden)
530 Login incorrect.

[Wörsty]

Tja - was soll ich sagen?
Ohne Debug und SQL-Log kann ich da nicht helfen. :??
P.S. Auf das Home-Verzeichniss mal chmod 777 /var/www/web1/files gemacht? So zum Test?
 :wait)

[Anonymous]

habbssssssss , die rechte wahren falsch vergeben