www.ProFTPD.de
13. März 2007, 21:38:52 *
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: mod_conf_sql und proftpd 1.2.9RC2p  (Gelesen 219 mal)
0 Mitglieder und 1 Gast betrachten dieses Thema.
Wörsty
Moderator
ProFTPD
*****
Offline Offline

Beiträge: 1602


50772603
Profil anzeigen WWW E-Mail
« am: 13. Oktober 2003, 12:16:41 »

Meine funktionierende Konfig habe ich mit
Code:
[root@knowledgebase scripts]# ./conf2sql.pl --dbdriver=mysql --dbname=ftp --dbuser=ftp --dbpass=ftp --dbserver=localhost --verbose /www/conf/proftpd.conf  

umgewandelt und danach kann ich mich nicht mehr einloggen:
Code:
[root@knowledgebase root]# proftpd -nd9
 - parsing '/www/conf/proftpd.conf' configuration
 - FS: using sqlconf open()
 - FS: using sqlconf read()
 - parsing 'sql://ftp:ftp@localhost/db:ftp/ctxt:ftpctxt/conf:ftpconf/map:ftpmap' configuration
 - FS: using sqlconf open()
 - mod_conf_sql/0.3: db.user: 'ftp'
 - mod_conf_sql/0.3: db.server: 'localhost'
 - mod_conf_sql/0.3: db.database: 'ftp'
 - mod_conf_sql/0.3: ctxt.tab: 'ftpctxt'
 - mod_conf_sql/0.3: ctxt.id: 'id'
 - mod_conf_sql/0.3: ctxt.parent_id: 'parent_id'
 - mod_conf_sql/0.3: ctxt.name: 'name'
 - mod_conf_sql/0.3: ctxt.value: 'value'
 - mod_conf_sql/0.3: conf.tab: 'ftpconf'
 - mod_conf_sql/0.3: conf.id: 'id'
 - mod_conf_sql/0.3: conf.name: 'name'
 - mod_conf_sql/0.3: conf.value: 'value'
 - mod_conf_sql/0.3: map.tab: 'ftpmap'
 - mod_conf_sql/0.3: map.conf_id: 'conf_id'
 - mod_conf_sql/0.3: map.ctxt_id: 'ctxt_id'
 - FS: using sqlconf read()
 - mod_conf_sql/0.3: AccessDenyMsg "Zugriff verweigert! (%u)"

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: AccessGrantMsg "Herzlich Willkommen %u!"

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: AllowFilter "^[a-zA-Z0-9]*"

 - Compiling allow regex '^[a-zA-Z0-9]*'.
 - Allocated allow regex at location 0x80cf348.
 - FS: using sqlconf read()
 - mod_conf_sql/0.3: AllowForeignAddress On

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: AllowOverwrite Off

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: AllowRetrieveRestart On

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: AllowStoreRestart On

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: AuthAliasOnly Off

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: TransferRate RETR,STOR 4096:52428800

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: DeleteAbortedStores On

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: DirFakeGroup On ftp

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: DirFakeMode 700

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: DirFakeUser On ftp

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: DisplayConnect /www/vhosts/ftp/121/.DisplayConnect.msg

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: DisplayFirstChdir .DisplayFirstChdir.msg

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: DisplayGoAway .DisplayGoAway.msg

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: DisplayLogin .DisplayLogin.msg

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: DisplayQuit .DisplayQuit.msg

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: ExtendedLog /www/vhosts/administration/linux/logfiles/proftpd_queue.log ALL ftpqueue

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLLogfile /www/vhosts/administration/linux/logfiles/proftpd_queue_sql.log

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: HiddenStor Off

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: IdentLookups Off

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: MaxClients 15 "FEHLER: Es sind bereits %m Benutzer    verbunden!"

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: MaxClientsPerHost 10 "FEHLER: Sie     (%u) sind bereits 10x verbunden!"

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: MaxHostsPerUser 20 "FEHLER: Dieser Benutzer ist       bereits von %m Rechnern verbunden!"

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: LoginPasswordPrompt Off

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: MasqueradeAddress kb.de.nx1

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: MaxLoginAttempts 2

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: PathDenyFilter "(\\.ftpaccess)|(\\.htaccess)|(\\.DisplayConnect.msg)|(\\.DisplayFirstChdir.msg)|(\\.DisplayGoAway.msg)|(\\.DisplayLogin.msg)|(\\.DisplayGoAway.msg)|(\\.DisplayQuit.msg)"

 - Compiling deny regex '(\.ftpaccess)|(\.htaccess)|(\.DisplayConnect.msg)|(\.DisplayFirstChdir.msg)|(\.DisplayGoAway.msg)|(\.DisplayLogin.msg)|(\.DisplayGoAway.msg)|(\.DisplayQuit.msg)'.
 - Allocated deny regex at location 0x80cf158.
 - FS: using sqlconf read()
 - mod_conf_sql/0.3: Port 121

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: RequireValidShell Off

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: ServerAdmin christian.woestenfeld@nextiraone.de

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: ServerIdent On        "NetxiraOne Knowledgebase - FTP-Warteschlange"

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: ServerName "Knowledgebase - Warteschlange"

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: ShowSymlinks On

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SyslogLevel notice

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLAuthenticate users*

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLAuthTypes Backend

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLConnectInfo ebd@localhost:3306 ftp ftp PERSESSION

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLDefaultGID 502

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLDefaultUID 502

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLHomedirOnDemand On

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLLog PASS  updatecount

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLLog PASS  letzter_zugriff

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLLog DELE  delfile

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLLog RETR  getfile

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLLog *  history

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLLOG ERR_* history_err

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLNamedQuery updatecount     UPDATE "ftp_login_count=ftp_login_count+1 WHERE loginname='%u'" users

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLNamedQuery letzter_zugriff UPDATE "last_ftp_login = now() where loginname = '%u'" users

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLNamedQuery delfile         UPDATE "deleted ='ja' where loginname = '%u' and        dateiname = '%f'" ftp_query

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLNamedQuery getfile         UPDATE "downloadcount = downloadcount + 1, last_download = now() where fullpath =       '%f' and loginname = '%u'" ftp_query

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLNamedQuery history         INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'ok', NULL" ftp_history

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLNamedQuery history_err     INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'nicht ok', NULL" ftp_history

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: SQLUserInfo users loginname   passwort users_id NULL concat('/www/vhosts/ftp/121/',loginname) NULL

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: TimeoutLogin 30

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: TimeoutIdle 3600

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: TimeoutNoTransfer 3600

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: TimeoutStalled 3300

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: TimesGMT Off

 - FS: using sqlconf read()
 - mod_conf_sql/0.3: Umask 0111 0000

 - FS: using sqlconf read()
 - FS: using system close()
 - FS: using sqlconf read()
 - FS: using system close()
ber06075 - 10.138.131.75:121 masquerading as 10.138.131.75
ber06075 -
ber06075 - Config for Knowledgebase - Warteschlange:
ber06075 - AccessDenyMsg
ber06075 - AccessGrantMsg
ber06075 - AllowFilter
ber06075 - AllowForeignAddress
ber06075 - AllowOverwrite
ber06075 - AllowRetrieveRestart
ber06075 - AllowStoreRestart
ber06075 - AuthAliasOnly
ber06075 - TransferRate
ber06075 - DeleteAbortedStores
ber06075 - DirFakeGroup
ber06075 - DirFakeMode
ber06075 - DirFakeUser
ber06075 - DisplayConnect
ber06075 - DisplayFirstChdir
ber06075 - DisplayGoAway
ber06075 - DisplayLogin
ber06075 - DisplayQuit
ber06075 - ExtendedLog
ber06075 - SQLLogFile
ber06075 - HiddenStores
ber06075 - IdentLookups
ber06075 - MaxClients
ber06075 - MaxClientsPerHost
ber06075 - MaxHostsPerUser
ber06075 - LoginPasswordPrompt
ber06075 - MasqueradeAddress
ber06075 - MaxLoginAttempts
ber06075 - PathDenyFilter
ber06075 - RequireValidShell
ber06075 - ServerIdent
ber06075 - ShowSymlinks
ber06075 - SyslogLevel
ber06075 - SQLAuthenticate
ber06075 - SQLAuthTypes
ber06075 - SQLConnectInfo
ber06075 - SQLDefaultGID
ber06075 - SQLDefaultUID
ber06075 - SQLHomedirOnDemand
ber06075 - SQLLog_PASS
ber06075 - SQLLog_PASS
ber06075 - SQLLog_DELE
ber06075 - SQLLog_RETR
ber06075 - SQLLog_*
ber06075 - SQLLog_ERR_*
ber06075 - SQLNamedQuery_updatecount
ber06075 - SQLNamedQuery_letzter_zugriff
ber06075 - SQLNamedQuery_delfile
ber06075 - SQLNamedQuery_getfile
ber06075 - SQLNamedQuery_history
ber06075 - SQLNamedQuery_history_err
ber06075 - SQLUserTable
ber06075 - SQLUsernameField
ber06075 - SQLPasswordField
ber06075 - SQLUidField
ber06075 - SQLHomedirField
ber06075 - TimeoutLogin
ber06075 - TimeoutIdle
ber06075 - TimeoutNoTransfer
ber06075 - TimeoutStalled
ber06075 - TimesGMT
ber06075 - Umask
ber06075 - DirUmask
ber06075 - mod_conf_sql/0.3: fs unregistered
ber06075 - SETUP PRIVS at main.c:2711
ber06075 - ROOT PRIVS at main.c:1953
ber06075 - RELINQUISH PRIVS at main.c:1959
ber06075 - ROOT PRIVS at main.c:2320
ber06075 - opening scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
ber06075 - RELINQUISH PRIVS at main.c:2344
ber06075 - ROOT PRIVS at inet.c:452
ber06075 - RELINQUISH PRIVS at inet.c:510
ber06075 - ProFTPD 1.2.9rc2 (devel) (built Fre Okt 10 15:12:10 CEST 2003) standalone mode STARTUP
ber06075 - ROOT PRIVS at main.c:2168
ber06075 - RELINQUISH PRIVS at main.c:2174
ber06075 - FS: using system lstat()
ber06075 - FS: using system lstat()
ber06075 - ROOT PRIVS at main.c:1145
ber06075 - RELINQUISH PRIVS at main.c:1149
ber06075 - FS: using system lstat()
ber06075 (ber07220.de.nx1[10.138.134.159]) - ident lookup disabled
ber06075 (ber07220.de.nx1[10.138.134.159]) - performing module session initializations
ber06075 (ber07220.de.nx1[10.138.134.159]) - ROOT PRIVS at mod_sql.c:3630
ber06075 (ber07220.de.nx1[10.138.134.159]) - RELINQUISH PRIVS at mod_sql.c:3632
ber06075 (ber07220.de.nx1[10.138.134.159]) - error deleting scoreboard entry: Invalid argument
ber06075 (ber07220.de.nx1[10.138.134.159]) - FTP session closed.
ber06075 - FS: using system lstat()

Das SQL-Log zeigt, dass der Username für die DB Schrott ist.
Code:
Oct 13 12:12:30 mod_sql/4.10[21668]: backend module 'mod_sql_mysql/4.04'
Oct 13 12:12:30 mod_sql/4.10[21668]: backend api    'mod_sql_api_v1'
Oct 13 12:12:30 mod_sql/4.10[21668]: >>> sql_getconf
Oct 13 12:12:30 mod_sql/4.10[21668]: entering   mysql cmd_defineconnection
Oct 13 12:12:30 mod_sql/4.10[21668]:  name: 'default'
Oct 13 12:12:30 mod_sql/4.10[21668]:  user: 'Lg
                                              '
Oct 13 12:12:30 mod_sql/4.10[21668]:  host: 'localhost'
Oct 13 12:12:30 mod_sql/4.10[21668]:    db: 'ebd'
Oct 13 12:12:30 mod_sql/4.10[21668]:  port: '3306'
Oct 13 12:12:30 mod_sql/4.10[21668]:   ttl: '0'
Oct 13 12:12:30 mod_sql/4.10[21668]: exiting    mysql cmd_defineconnection
Oct 13 12:12:30 mod_sql/4.10[21668]: entering   mysql cmd_open
Oct 13 12:12:30 mod_sql/4.10[21668]: exiting    mysql cmd_open
Oct 13 12:12:30 mod_sql/4.10[21668]: unrecoverable backend error
Oct 13 12:12:30 mod_sql/4.10[21668]: error: '1045'
Oct 13 12:12:30 mod_sql/4.10[21668]: message: 'Access denied for user: 'Lg
                                                                         @localhost' (Using password: YES)'

Kennt jemand das Problem?
Gespeichert

RedHat 8.0 (2.4er Kernel)
proftpd 1.2.10
-mod_sql_mysql
-mow_wrap
-mod_exec
-mod_ifsession[/size]
Wörsty
Moderator
ProFTPD
*****
Offline Offline

Beiträge: 1602


50772603
Profil anzeigen WWW E-Mail
« Antwort #1 am: 21. Oktober 2003, 10:51:47 »

Geht auch in 1.2.9rc3 nicht.
TJ weiß Bescheid:
Zitat
Ah, right.  Now I remember why this isn't supported yet -- the requirement of mod_conf_sql to lookup the "server config" context ID.
  I'm thinking that even with an Include directive in the "server config" context, that requirement will cause problems.

It may have to wait for a future release of mod_conf_sql, which will allow you to specify what the target context is for the configuration being loaded from the SQL tables...

Mal sehen was kommt. Lächelnd
Gespeichert

RedHat 8.0 (2.4er Kernel)
proftpd 1.2.10
-mod_sql_mysql
-mow_wrap
-mod_exec
-mod_ifsession[/size]
RemsGHost
Gast
« Antwort #2 am: 21. Oktober 2003, 19:18:06 »

Zitat von: "Wörsty"
Geht auch in 1.2.9rc3 nicht.
TJ weiß Bescheid:
Zitat
Ah, right.  Now I remember why this isn't supported yet -- the requirement of mod_conf_sql to lookup the "server config" context ID.
  I'm thinking that even with an Include directive in the "server config" context, that requirement will cause problems.

It may have to wait for a future release of mod_conf_sql, which will allow you to specify what the target context is for the configuration being loaded from the SQL tables...

Mal sehen was kommt. Lächelnd


.. fix on the way... wan fertig ? NO date now.

MfG
Gespeichert
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.06 Sekunden mit 17 Zugriffen.