www.ProFTPD.de
13. März 2007, 18:18:15 *
Willkommen Gast. Bitte einloggen oder registrieren.
Haben Sie Ihre Aktivierungs E-Mail übersehen?

Einloggen mit Benutzername, Passwort und Sitzungslänge
News: SMF - Neu installiert!
 
   Übersicht   Hilfe Suche Login Registrieren  
Seiten: [1]   Nach unten
  Drucken  
Autor Thema: SQL Commands for Proftpd 1.2.10rc1  (Gelesen 1221 mal)
0 Mitglieder und 2 Gäste betrachten dieses Thema.
Syswatch
Gast
« 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....
Gespeichert
Syswatch
Gast
« Antwort #1 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
Gespeichert
Wörsty
Moderator
ProFTPD
*****
Offline Offline

Beiträge: 1602


50772603
Profil anzeigen WWW E-Mail
« Antwort #2 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 and post the results here.
Gespeichert

RedHat 8.0 (2.4er Kernel)
proftpd 1.2.10
-mod_sql_mysql
-mow_wrap
-mod_exec
-mod_ifsession[/size]
Syswatch
Gast
« Antwort #3 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 !
Gespeichert
Wörsty
Moderator
ProFTPD
*****
Offline Offline

Beiträge: 1602


50772603
Profil anzeigen WWW E-Mail
« Antwort #4 am: 23. Juni 2004, 22:37:06 »

No problem. Cool
You're welcome :wink:
Gespeichert

RedHat 8.0 (2.4er Kernel)
proftpd 1.2.10
-mod_sql_mysql
-mow_wrap
-mod_exec
-mod_ifsession[/size]
Seiten: [1]   Nach oben
  Drucken  
 
Gehe zu:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Prüfe XHTML 1.0 Prüfe CSS
Seite erstellt in 0.052 Sekunden mit 18 Zugriffen.