ProFTPd s autorizací uživatelů via mod_sql

Zdravím místní komunitu,
po koketování s vsftpd a pure-ftpd jsem se rozhodl nasadit ProFTPd na svůj stroj, kde běží OpenSUSE 11.1 (x86_64) s verzí jádra 2.6.27.7-9-default (SMP). Protože ProFTPd není ve standartních repositářích, byl jsem nucen stáhnout zdroják a zkompilovat vše sám.

Stáhl jsem poslední stable verzi proftpd:
wget ftp://ftp.proftpd.org/distrib/source/proftpd-1.3.1.tar.gz
archiv jsem rozbalil:
tar xvfz proftpd-1.3.1.tar.gz
provedl jsem konfiguraci balíku tak, aby jsem poté nainstalil i sql modul:
./configure --with-modules=mod_sql
make
sudo make install
Po úspěšném proběhnutí make i make install jsem chtěl službu nahodit:
sudo /etc/init.d/proftpd start
bohužel, vypisuje při pokusu o spuštění tuto chybu:
Starting ProFTPD Server: - mod_sql/4.2.2: notice: no backend modules have been registered startproc: exit status of parent of /usr/local/sbin/proftpd: 1 failed

Konfigurák na /etc/proftpd.conf vypadá následovně:

# This is a basic ProFTPD configuration file (rename it to # 'proftpd.conf' for actual use. It establishes a single server # and a single anonymous login. It assumes that you have a user/group # "nobody" and "ftp" for normal operation and anon. ServerName "Vydra" ServerType standalone DefaultServer on # Welcome message DeferWelcome on AccessGrantMsg "Pristup na server povolen." # Port 21 is the standard FTP port. Port 21 # Don't use IPv6 support by default. # UseIPv6 on # vlastni nastaveni UseReverseDNS off IdentLookups off #DefaultAddress 180.10.10.11 PassivePorts 20000 20050 # Umask 022 is a good standard umask to prevent new dirs and files # from being group and world writable. Umask 022 # To prevent DoS attacks, set the maximum number of child processes # to 30. If you need to allow more than 30 concurrent connections # at once, simply increase this value. Note that this ONLY works # in standalone mode, in inetd mode you should use an inetd server # that allows you to limit maximum number of processes per service # (such as xinetd). MaxInstances 30 MaxLoginAttempts 5 # Set the user and group under which the server will run. User nobody Group nogroup SQLLogFile /var/log/proftpd.sqllog # To cause every FTP user to be "jailed" (chrooted) into their home # directory, uncomment this line. DefaultRoot /var/ftp-data # Normally, we want files to be overwriteable. AllowOverwrite on <IfModule mod_dso.c> # Ak je moznost prace s DSO, tak <IfModule !mod_sql.c> # Ak mod_sql este nie je, tak skusime loadnut LoadModule mod_sql.c </IfModule> <IfModule !mod_sql_mysql.c> # Ak mod_sql_mysql este nie je, tak skusime loadnut LoadModule mod_sql_mysql.c </IfModule> </IfModule> # Enable PAM for authentication... # AuthPAM on # Use SQL tables first, then LDAP, for authentication AuthOrder mod_sql.c ######################### # Nastaveni pro mod_sql # ######################### SQLBackend mysql SQLAuthTypes backend SQLAuthenticate users SQLConnectInfo proftpd@localhost root ******* SQLDefaultGID 65534 SQLDefaultUID 65534 SQLMinUserGID 100 SQLMinUserUID 500 SQLUserInfo ftp username password uid gid homedir shell # # aktive SQL Kommandos, ab hier passiert etwas # #SQLLog PASS counter #SQLNamedQuery counter UPDATE "letzter_zugriff=now(), count=count+1 WHERE username='%u'" ftp # xfer Log in mysql #SQLLog RETR,STOR transfer1 #SQLNamedQuery transfer1 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'c', NULL" xfer_stat #SQLLOG ERR_RETR,ERR_STOR transfer2 #SQLNamedQuery transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i', NULL" xfer_stat # Bar use of SITE CHMOD by default <Limit SITE_CHMOD> DenyAll </Limit> <Limit LOGIN> # AllowUser radek # DenyAll </Limit>

Nevíte někdo z jakého důvodu vzniká tato chyba? Myslel bych si skoro, že registration of backend modules proběhne pomocí jedné (obou?) z těchto direktiv:

SQLBackend mysql SQLAuthTypes backend

Bohužel tomu asi tak není...
Jinak jsem ochoten poskytnout i exporty těch tabulek, co mám v databázi, ale odhaduji, že to bude k této chybě zbytečné...

Pokoušel jsem se o konfiguraci i s konkrétním modulem pro mysql:
./configure --with-modules=mod_sql:mod_sql_mysql

Výpis sudo make install probíhal v pořádku až na konečných pár řádek s errory:
mod_sql_mysql.c:138:19: error: mysql.h: není souborem ani adresářem mod_sql_mysql.c:164: error: expected specifier-qualifier-list before ‘MYSQL’ mod_sql_mysql.c: In function ‘_build_error’: mod_sql_mysql.c:303: warning: implicit declaration of function ‘mysql_errno’ mod_sql_mysql.c:303: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c:305: warning: implicit declaration of function ‘mysql_error’ mod_sql_mysql.c:305: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c:305: warning: cast to pointer from integer of different size mod_sql_mysql.c: In function ‘_build_data’: mod_sql_mysql.c:316: error: ‘MYSQL’ undeclared (first use in this function) mod_sql_mysql.c:316: error: (Each undeclared identifier is reported only once mod_sql_mysql.c:316: error: for each function it appears in.) mod_sql_mysql.c:316: error: ‘mysql’ undeclared (first use in this function) mod_sql_mysql.c:317: error: ‘MYSQL_RES’ undeclared (first use in this function) mod_sql_mysql.c:317: error: ‘result’ undeclared (first use in this function) mod_sql_mysql.c:318: error: ‘MYSQL_ROW’ undeclared (first use in this function) mod_sql_mysql.c:318: error: expected ‘;’ before ‘row’ mod_sql_mysql.c:327: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c:333: warning: implicit declaration of function ‘mysql_store_result’ mod_sql_mysql.c:339: warning: implicit declaration of function ‘mysql_num_rows’ mod_sql_mysql.c:340: warning: implicit declaration of function ‘mysql_num_fields’ mod_sql_mysql.c:345: error: ‘row’ undeclared (first use in this function) mod_sql_mysql.c:345: warning: implicit declaration of function ‘mysql_fetch_row’ mod_sql_mysql.c:355: warning: implicit declaration of function ‘mysql_free_result’ mod_sql_mysql.c: In function ‘cmd_open’: mod_sql_mysql.c:408: warning: implicit declaration of function ‘mysql_ping’ mod_sql_mysql.c:408: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c:420: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c:420: warning: implicit declaration of function ‘mysql_init’ mod_sql_mysql.c:422: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c:433: warning: implicit declaration of function ‘mysql_options’ mod_sql_mysql.c:433: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c:433: error: ‘MYSQL_READ_DEFAULT_GROUP’ undeclared (first use in this function) mod_sql_mysql.c:435: warning: implicit declaration of function ‘mysql_real_connect’ mod_sql_mysql.c:435: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c:437: error: ‘CLIENT_INTERACTIVE’ undeclared (first use in this function) mod_sql_mysql.c: In function ‘cmd_close’: mod_sql_mysql.c:529: warning: implicit declaration of function ‘mysql_close’ mod_sql_mysql.c:529: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c:530: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c: In function ‘cmd_select’: mod_sql_mysql.c:843: warning: implicit declaration of function ‘mysql_real_query’ mod_sql_mysql.c:843: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c: In function ‘cmd_insert’: mod_sql_mysql.c:956: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c: In function ‘cmd_update’: mod_sql_mysql.c:1054: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c: In function ‘cmd_query’: mod_sql_mysql.c:1169: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c:1184: warning: implicit declaration of function ‘mysql_field_count’ mod_sql_mysql.c:1184: error: ‘db_conn_t’ has no member named ‘mysql’ mod_sql_mysql.c: In function ‘cmd_escapestring’: mod_sql_mysql.c:1264: warning: implicit declaration of function ‘mysql_escape_string’ mod_sql_mysql.c: In function ‘cmd_checkauth’: mod_sql_mysql.c:1330: warning: implicit declaration of function ‘make_scrambled_password’ make[1]: *** [mod_sql_mysql.o] Error 1 make[1]: Leaving directory `/home/radek/downloads/proftpd-1.3.1/modules' make: *** [modules] Error 2

Dotaz: ProFTPd s autorizací uživatelů via mod_sql - chyba při spouštění

Odpovědi