Titel: SQL Commands for Proftpd 1.2.10rc1 Beitrag von: Syswatch am 23. Juni 2004, 22:22:01 Hi, can anyone tell me whats wrong with these SQL comamnds i my conf file ?
When I add these lines to the conf file, the ftp server does not accept any connections, if I remove them again everything works fine with the built in accounts. Please help me here.... Titel: SQL Commands for Proftpd 1.2.10rc1 Beitrag von: Syswatch am 23. Juni 2004, 22:22:42 SQLAuthTypes Backend
SQLAuthenticate users* SQLConnectInfo proftpd@localhost:3306 proftpd 1q2w3e PERSESSION SQLGroupInfo groups groupname gid members SQLUserInfo users userid passwd uid gid homedir shell SQLUserWhereClause "LoginAllowed=1" SQLLog PASS counter SQLNamedQuery counter UPDATE "last_login=now(), count=count+1 WHERE userid='%u'" users SQLLog EXIT time_logout SQLNamedQuery time_logout UPDATE "last_logout=now() WHERE userid='%u'" users SQLLog RETR,STOR,APPE,STOU transfer_success SQLNamedQuery transfer_success INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'c'" xfer_stats SQLLog ERR_RETR,ERR_STOR,ERR_APPE,ERR_STOU transfer_error SQLNamedQuery transfer_error INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i'" xfer_stats Titel: SQL Commands for Proftpd 1.2.10rc1 Beitrag von: Wörsty am 23. Juni 2004, 22:23:10 I can't see your configuration file here. :shock:
EDIT: OH - okay - now - just a second... reading.... Please try SQLLogfile (http://www.proftpd.de/index.php?id=28&language=en&directive_name=SQLLogfile) and post the results here. Titel: SQL Commands for Proftpd 1.2.10rc1 Beitrag von: Syswatch am 23. Juni 2004, 22:34:30 I did't not know the Logfile comamnd... But I see it's very useful.
The problem was a little bit stupid, and I am not much for saying this.... I made a spelling error in the username for the sql database... Jun 23 21:40:05 mod_sql/4.10[338]: backend module 'mod_sql_mysql/4.04' Jun 23 21:40:05 mod_sql/4.10[338]: backend api 'mod_sql_api_v1' Jun 23 21:40:05 mod_sql/4.10[338]: >>> sql_getconf Jun 23 21:40:05 mod_sql/4.10[338]: entering mysql cmd_defineconnection Jun 23 21:40:05 mod_sql/4.10[338]: name: 'default' Jun 23 21:40:05 mod_sql/4.10[338]: user: 'proftpd' Jun 23 21:40:05 mod_sql/4.10[338]: host: 'localhost' Jun 23 21:40:05 mod_sql/4.10[338]: db: 'proftpd' Jun 23 21:40:05 mod_sql/4.10[338]: port: '3306' Jun 23 21:40:05 mod_sql/4.10[338]: ttl: '0' Jun 23 21:40:05 mod_sql/4.10[338]: exiting mysql cmd_defineconnection Jun 23 21:40:05 mod_sql/4.10[338]: entering mysql cmd_open Jun 23 21:40:05 mod_sql/4.10[338]: exiting mysql cmd_open Jun 23 21:40:05 mod_sql/4.10[338]: unrecoverable backend error Jun 23 21:40:05 mod_sql/4.10[338]: error: '1045' Jun 23 21:40:05 mod_sql/4.10[338]: message: 'Access denied for user: 'proftpd@localhost' (Using password: YES)' THANKS FOR YOUR HELP ! Best regards from here... Great site ! Titel: SQL Commands for Proftpd 1.2.10rc1 Beitrag von: Wörsty am 23. Juni 2004, 22:37:06 No problem. 8)
You're welcome :wink: |