SQL Commands for Proftpd 1.2.10rc1

[Syswatch]

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....

[Syswatch]

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

[Wörsty]

I can't see your configuration file here. :shock:
EDIT: OH - okay - now - just a second... reading....

Please try SQLLogfile and post the results here.

[Syswatch]

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 !

[Wörsty]

No problem.
You're welcome :wink: