phpbar.de logo

Mailinglisten-Archive

Signal 11 with ProFTPd & MySQL

Signal 11 with ProFTPd & MySQL

Berthold Tenhumberg mysql_(at)_lists.phpcenter.de
Wed, 10 Oct 2001 16:28:42 +0200


Hi,

we have a big problem with signal 11 ;-)
Linux 2.4.10, dual-processor
ProFTPD 1.2.2
MySQL   3.23.43
----------------------------------------------------------------------------------------------------------- 
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): connected - local  :192.168.0.1:21
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): connected - remote :192.168.0.1:32976
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql_mysql/3.2: configured: www_server_de_(at)_localhost:3306 for matti
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: entering sql_getconf
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: entering fixup_SQLAuthTypes
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: exiting fixup_SQLAuthTypes
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql_mysql/3.2: open [1] for mod_sql/3.2.4
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql_mysql/3.2: connect OK 3.23.37 -> 3.23.43 (matti_(at)_localhost)
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: backend successfully connected.
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: SQLDoAuth         : true
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: authoritative     : true
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: usertable         : ftpuser
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: userid field      : username
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: password field    : password
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: uid field         : uid
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: gid field         : gid
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: shell field       : shell
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: homedir field     : homedir
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: default homedir   : (none)
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: homedirondemand   : false
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: SQLDoGroupAuth    : true
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: group table       : groups
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: groupname field   : groupname
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: grp gid field     : gid
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: grp members field : members
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: processgrent      : false
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: processpwent      : false
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: SQLMinUserUID     : 999
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: SQLMinUserGID     : 999
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: SQLDefaultUID     : 65534
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: SQLDefaultGID     : 65534
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: exiting  sql_getconf
Oct 10 10:48:04 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): FTP session opened.
Oct 10 10:48:11 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): received: USER username
Oct 10 10:48:11 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): received: USER username
Oct 10 10:48:11 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): received: USER username
Oct 10 10:48:11 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: entering auth_cmd_getpwnam
Oct 10 10:48:11 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: no cache hit for user 'username'
Oct 10 10:48:11 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql_mysql/3.2: select OK: [www_server_de] "SELECT username, uid, gid, shell, homedir,password FROM ftpuser WHERE (username='username') LIMIT 1"
Oct 10 10:48:11 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): ProFTPD terminating (signal 11)
Oct 10 10:48:11 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql/3.2.4: closing backend connection
Oct 10 10:48:11 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql_mysql/3.2: close [1] for mod_sql/3.2.4
Oct 10 10:48:11 db proftpd[2764] db.server.de (db.server.de[192.168.0.1]): mod_sql_mysql/3.2: disconnecting: Uptime: 148507  Threads: 1  Questions: 140  Slow queries: 0  Opens: 17 Flush tables: 1  Open tables: 8 Queries per second avg: 0.001
-----------------------------------------------------------------------------------------------------------

Login-messages:
----------------------------------------------------------------------------------------------------------- 
Connected to db.server.de (192.168.0.1).
220 ProFTPD 1.2.2 Server (test) [db.server.de]
Name (db.server.de:test): username
421 Service not available, remote server has closed connection
Login failed.
No control connection for command: No such file or directory
-----------------------------------------------------------------------------------------------------------

Berthold 
(live long and prosper...)

---
!!NEU!!
Fragen und Antworten zu MySQL und dieser Liste unter
-->>  http://www.4t2.com/mysql 



php::bar PHP Wiki   -   Listenarchive