Hi

I posted this problem quite some time ago. I know that its a small
problem but i would be happy if i would be able to get a fix for it.

Thx

oizs wrote:
> I've attached a file to this mail, i hope this time i was able to
> provide sufficient information.
>
> TJ Saunders wrote:
>>> I have a very strange problem, im using the latest proftpd version with
>>> 4.1.16 mysql on a freebsd 6.1 (amd64)server. My problem is that when i
>>> put these lines(at the end of my mail) into the config file, i get
>>> strange sig11's. Selecting a few files and downloading them triggers a
>>> sig11 after the first file. If i reconnect i can download the rest of
>>> the files without getting sig11, but if i change the dir to another i
>>> get the same sig11 again. Any ideas ?
>>>
>>> SQLLog RETR download
>>> SQLNamedQuery download UPDATE "dl_count=dl_count+1,
>>> dl_bytes=dl_bytes+%b WHERE userid='%u'" users
>>> SQLLog STOR upload
>>> SQLNamedQuery upload UPDATE "ul_count=ul_count+1,
>>> ul_bytes=ul_bytes+%b WHERE userid='%u'" users
>>>

>>
>> What does your full proftpd.conf look like? What does server debugging
>> output show? What does an SQLLogFile show?
>>
>>
>> http://www.castaglia.org/proftpd/doc...Debugging.html
>>
>> http://www.castaglia.org/proftpd/mod...tml#SQLLogFile
>>
>> TJ
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>
>>
>> I walked beside the evening sea
>> And dreamed a dream that could not be;
>> The waves that plunged along the shore
>> Said only: "Dreamer, dream no more!"
>>
>> -George William Curtis
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by xPML, a groundbreaking scripting
>> language
>> that extends applications into web and mobile media. Attend the live
>> webcast
>> and join the prime developer group breaking into this new coding
>> territory!
>> http://sel.as-us.falkag.net/sel?cmd=...720&dat=121642
>> _______________________________________________
>> ProFTPD Users List
>> Unsubscribe problems?
>> http://www.proftpd.org/list-unsub.html
>>
>>
>>

> ------------------------------------------------------------------------
>
> the configfile:
>
> ServerName "servername"
> ServerType standalone
> ServerIdent on "Servers identifying string"
> DeferWelcome on
> DefaultServer on
> DefaultTransferMode binary
> PassivePorts 50100 65534
>
> AuthPAM off
>

> TimesGMT on
>
> DisplayLogin .legal # Textfile to display on login
> DisplayConnect .legal # Textfile to display on connection
>
> IdentLookups off
>
> Port 31337
> Umask 002
> MaxInstances 400
> MaxClients 400 "Only %m total simultanious logins allowed"
> MaxClientsPerUser 2 "Only %m connections per user allowed"
>
> User nobody
> Group nogroup
>
> ScoreboardFile /var/run/proftpd/scoreboard
>
> # Logging options
> TransferLog /var/log/xferlog
>
> # Some logging formats
> LogFormat default "%h %l %u %t \"%r\" %s %b"
> LogFormat auth "%v [%P] %h %t \"%r\" %s"
> LogFormat write "%h %l %u %t \"%r\" %s %b"
>
> ExtendedLog /var/log/proftpd.access_log WRITE write
> ExtendedLog /var/log/proftpd.auth_log AUTH auth
> ExtendedLog /var/log/proftpd.paranoid_log ALL default
> #SQLLogFile /var/log/proftpd.mysql
>
>
> SQLConnectInfo proftpd@localhost proftpd password 10
> SQLAuthenticate on
> AuthOrder mod_sql.c
> SQLAuthTypes OpenSSL
> SQLGroupInfo groups groupid gid members
>
> SQLNamedQuery users SELECT "userid, CONCAT('{MD5}', base64encode(hexdecode(passwd))) AS passwd, uid, gid, homedir, shell FROM users WHERE userid='%U' limit 1"
> SQLUserInfo custom:/users
>
> SQLUserWhereClause "0"
> SQLNegativeCache on
>
> SQLDefaultHomedir /nonexistent
>
> SQLLog PASS logincount
> SQLNamedQuery logincount UPDATE "login_count=login_count+1 WHERE userid='%u'" users
> SQLLog PASS lastlogin
> SQLNamedQuery lastlogin UPDATE "last_login=now() WHERE userid='%u'" users
> SQLLog RETR download
> SQLNamedQuery download UPDATE "dl_count=dl_count+1, dl_bytes=dl_bytes+%b WHERE userid='%u'" users
> SQLLog STOR upload
> SQLNamedQuery upload UPDATE "ul_count=ul_count+1, ul_bytes=ul_bytes+%b WHERE userid='%u'" users
>
> AllowOverwrite on
> AllowRetrieveRestart on
> AllowStoreRestart on
> AllowForeignAddress on
> DirfakeUser on
> DirfakeGroup on
>
> RequireValidShell off
> DefaultRoot ~
> DenyFilter \*.*/
>
>
>
> DenyAll
>

>

>
>
>
>
> AllowAll
>

>
>
> DenyGroup !admins
>

> Groupowner admins
>

>
>
>
> DenyGroup !admins
>

>
>
> DenyGroup !admins
>

> Groupowner admins
>

>
> proftpd -c configfile -td5
> Checking syntax of configuration file
> - mod_tls/2.1.1: using OpenSSL 0.9.7e-p1 25 Oct 2004
> - parsing '/root/cuccok/proftpd.conf' configuration
> - : using 'mod_auth_pam.c' section at line 8
> - DenyFilter: compiling deny regex '\*.*/'
> - : deferring resolution of path
> - : deferring resolution of path
> - : deferring resolution of path
> severname -
> severname - Config for servername:
> severname - /anotherdir/*
> severname - Limit
> severname - DenyGroup
> severname - Limit
> severname - DenyGroup
> severname - GroupOwner
> severname - TimesGMT
> severname - DisplayLogin
> severname - Umask
> severname - MaxClients
> severname - MaxClientsPerUser
> severname - TransferLog
> severname - SQLConnectInfo
> severname - SQLAuthenticate
> severname - SQLAuthTypes
> severname - SQLNamedQuery_users
> severname - SQLLog_PASS
> severname - SQLNamedQuery_logincount
> severname - SQLLog_PASS
> severname - SQLNamedQuery_lastlogin
> severname - SQLLog_RETR
> severname - SQLNamedQuery_download
> severname - SQLLog_STOR
> severname - SQLNamedQuery_upload
> severname - AllowOverwrite
> severname - AllowRetrieveRestart
> severname - AllowStoreRestart
> severname - AllowForeignAddress
> severname - DirFakeUser
> severname - DirFakeGroup
> severname - RequireValidShell
> severname - DenyFilter
> severname - /somedir/*
> severname - Limit
> severname - DenyGroup
> severname - Limit
> severname - AllowAll
> severname - GroupOwner
> severname - TimesGMT
> severname - DisplayLogin
> severname - Umask
> severname - MaxClients
> severname - MaxClientsPerUser
> severname - TransferLog
> severname - SQLConnectInfo
> severname - SQLAuthenticate
> severname - SQLAuthTypes
> severname - SQLNamedQuery_users
> severname - SQLLog_PASS
> severname - SQLNamedQuery_logincount
> severname - SQLLog_PASS
> severname - SQLNamedQuery_lastlogin
> severname - SQLLog_RETR
> severname - SQLNamedQuery_download
> severname - SQLLog_STOR
> severname - SQLNamedQuery_upload
> severname - AllowOverwrite
> severname - AllowRetrieveRestart
> severname - AllowStoreRestart
> severname - AllowForeignAddress
> severname - DirFakeUser
> severname - DirFakeGroup
> severname - RequireValidShell
> severname - DenyFilter
> severname - /*
> severname - Limit
> severname - DenyAll
> severname - TimesGMT
> severname - DisplayLogin
> severname - Umask
> severname - MaxClients
> severname - MaxClientsPerUser
> severname - TransferLog
> severname - SQLConnectInfo
> severname - SQLAuthenticate
> severname - SQLAuthTypes
> severname - SQLNamedQuery_users
> severname - SQLLog_PASS
> severname - SQLNamedQuery_logincount
> severname - SQLLog_PASS
> severname - SQLNamedQuery_lastlogin
> severname - SQLLog_RETR
> severname - SQLNamedQuery_download
> severname - SQLLog_STOR
> severname - SQLNamedQuery_upload
> severname - AllowOverwrite
> severname - AllowRetrieveRestart
> severname - AllowStoreRestart
> severname - AllowForeignAddress
> severname - DirFakeUser
> severname - DirFakeGroup
> severname - RequireValidShell
> severname - DenyFilter
> severname - ServerIdent
> severname - DeferWelcome
> severname - DefaultServer
> severname - DefaultTransferMode
> severname - PassivePorts
> severname - AuthPAM
> severname - TimesGMT
> severname - DisplayLogin
> severname - DisplayConnect
> severname - IdentLookups
> severname - Umask
> severname - MaxClients
> severname - MaxClientsPerUser
> severname - UserID
> severname - UserName
> severname - GroupID
> severname - GroupName
> severname - TransferLog
> severname - ExtendedLog
> severname - ExtendedLog
> severname - ExtendedLog
> severname - SQLLogFile
> severname - SQLConnectInfo
> severname - SQLAuthenticate
> severname - AuthOrder
> severname - SQLAuthTypes
> severname - SQLGroupTable
> severname - SQLGroupnameField
> severname - SQLGroupGIDField
> severname - SQLGroupMembersField
> severname - SQLNamedQuery_users
> severname - SQLCustomUserInfo
> severname - SQLUserWhereClause
> severname - SQLNegativeCache
> severname - SQLDefaultHomedir
> severname - SQLLog_PASS
> severname - SQLNamedQuery_logincount
> severname - SQLLog_PASS
> severname - SQLNamedQuery_lastlogin
> severname - SQLLog_RETR
> severname - SQLNamedQuery_download
> severname - SQLLog_STOR
> severname - SQLNamedQuery_upload
> severname - AllowOverwrite
> severname - AllowRetrieveRestart
> severname - AllowStoreRestart
> severname - AllowForeignAddress
> severname - DirFakeUser
> severname - DirFakeGroup
> severname - RequireValidShell
> severname - DefaultRoot
> severname - DenyFilter
> Syntax check complete.
>
> the debuginfo with -nd5
> servername (myip[myip]) - in dir_check_full(): path = '/test', fullpath = '/servername/ftp/test'.
> servername (myip[myip]) - dispatching POST_CMD command 'PORT someip,someport,fxp' to mod_sql
> servername (myip[myip]) - dispatching LOG_CMD command 'PORT someip,someport,fxp' to mod_sql
> servername (myip[myip]) - dispatching LOG_CMD command 'PORT someip,someport,fxp' to mod_log
> servername (myip[myip]) - dispatching PRE_CMD command 'STOR DSCN1605.JPG' to mod_tls
> servername (myip[myip]) - dispatching PRE_CMD command 'STOR DSCN1605.JPG' to mod_rewrite
> servername (myip[myip]) - dispatching PRE_CMD command 'STOR DSCN1605.JPG' to mod_core
> servername (myip[myip]) - dispatching PRE_CMD command 'STOR DSCN1605.JPG' to mod_core
> servername (myip[myip]) - dispatching PRE_CMD command 'STOR DSCN1605.JPG' to mod_quotatab
> servername (myip[myip]) - dispatching PRE_CMD command 'STOR DSCN1605.JPG' to mod_ratio
> servername (myip[myip]) - dispatching PRE_CMD command 'STOR DSCN1605.JPG' to mod_xfer
> servername (myip[myip]) - in dir_check_full(): path = '/test/DSCN1605.JPG', fullpath = '/servername/ftp/test/DSCN1605.JPG'.
> servername (myip[myip]) - in dir_check_full(): setting umask to 0002 (was 0002)
> servername (myip[myip]) - dispatching CMD command 'STOR DSCN1605.JPG' to mod_xfer
> servername (myip[myip]) - active data connection opened - local : serveriport
> servername (myip[myip]) - active data connection opened - remote : someip,someport,fxp
> servername (myip[myip]) - dispatching POST_CMD command 'STOR DSCN1605.JPG' to mod_sql
> servername (myip[myip]) - dispatching POST_CMD command 'STOR DSCN1605.JPG' to mod_quotatab
> servername (myip[myip]) - dispatching POST_CMD command 'STOR DSCN1605.JPG' to mod_sql
> servername (myip[myip]) - dispatching POST_CMD command 'STOR DSCN1605.JPG' to mod_ratio
> servername (myip[myip]) - dispatching LOG_CMD command 'STOR DSCN1605.JPG' to mod_sql
> servername (myip[myip]) - ProFTPD terminating (signal 11)
> servername (myip[myip]) - FTP session closed.
>
> And the sqllog
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: defaulting to 'mysql' backend
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: backend module 'mod_sql_mysql/4.05'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: backend api 'mod_sql_api_v2'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: >>> sql_sess_init
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_defineconnection
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: name: 'default'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: user: 'proftpd'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: host: 'localhost'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: db: 'proftpd'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: port: '3306'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: ttl: '10'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_defineconnection
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_open
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: connection 'default' - 10 second timer started
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: connection 'default' opened
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: connection 'default' count is now 2
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_open
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: backend successfully connected.
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: mod_sql engine : on
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: negative_cache : on
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: authenticate : users groups userset groupset
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: usertable : users
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: userid field : userid
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: password field : passwd
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: uid field : uid
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: gid field : gid
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: homedir field : homedir
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: homedir(default) : '/nonexistent'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: shell field : shell
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: homedirondemand : false
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: group table : groups
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: groupname field : groupid
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: grp gid field : gid
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: grp members field : members
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: SQLMinUserUID : 999
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: SQLMinUserGID : 999
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: SQLDefaultUID : 65533
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: SQLDefaultGID : 65533
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: <<< sql_sess_init
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: >>> cmd_endpwent
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: <<< cmd_endpwent
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: >>> cmd_endgrent
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: <<< cmd_endgrent
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: >>> cmd_getgroups
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_escapestring
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_escapestring
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: cache miss for user 'username'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: >>> sql_lookup
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: >>> _process_named_query
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_escapestring
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_escapestring
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: : entering mysql cmd_select
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_open
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: connection 'default' count is now 3
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_open
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: query "SELECT userid, CONCAT('{MD5}', base64encode(hexdecode(passwd))) AS passwd, uid, gid, homedir, shell FROM users W
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_close
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: connection 'default' count is now 2
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_close
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_select
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: <<< _process_named_query
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: <<< sql_lookup
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: cache miss for user 'username'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: user 'username' cached
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: + pwd.pw_name : username
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: + pwd.pw_uid : 10000
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: + pwd.pw_gid : 10000
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: + pwd.pw_dir : /servername/ftp
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: + pwd.pw_shell : /sbin/nologin
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: cache miss for gid '10000'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: : entering mysql cmd_select
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_open
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: connection 'default' count is now 3
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_open
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: query "SELECT groupid FROM groups WHERE (gid = 10000) LIMIT 1"
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_close
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: connection 'default' count is now 2
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_close
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_select
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: : entering mysql cmd_select
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_open
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: connection 'default' count is now 3
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_open
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: query "SELECT groupid, gid, members FROM groups WHERE (groupid = 'admins')"
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_close
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: connection 'default' count is now 2
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_close
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_select
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: cache miss for group 'admins'
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: group 'admins' cached
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: + grp.gr_name : admins
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: + grp.gr_gid : 10000
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: + grp.gr_mem :
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_escapestring
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_escapestring
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: : entering mysql cmd_select
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_open
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: connection 'default' count is now 3
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_open
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: query "SELECT groupid, gid, members FROM groups WHERE (members = 'username' OR members LIKE 'username,%' OR members LIKE '%
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: entering mysql cmd_close
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: connection 'default' count is now 2
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_close
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: exiting mysql cmd_select
> Mar 01 18:45:30 mod_sql/4.2.1[59857]: <<< cmd_getgroups
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> sql_pre_pass
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_getgroups
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: cache hit for user 'username'
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: cache hit for group 'admins'
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_escapestring
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_escapestring
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: : entering mysql cmd_select
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 3
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: query "SELECT groupid, gid, members FROM groups WHERE (members = 'username' OR members LIKE 'username,%' OR members LIKE '%
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 2
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_select
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_getgroups
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< sql_pre_pass
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_endpwent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_endpwent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_endgrent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_endgrent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_getpwnam
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: cache hit for user 'username'
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_getpwnam
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_gid2name
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: cache hit for group 'admins'
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_gid2name
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_auth
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_escapestring
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_escapestring
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: cache hit for user 'username'
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_check
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: checking auth_type OpenSSL
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: 'OpenSSL' auth handler reports success
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: cache hit for user 'username'
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_check
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_auth
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_setgrent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: : entering mysql cmd_select
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 3
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: query "SELECT DISTINCT groupid FROM groups"
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 2
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_select
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: cache hit for group 'admins'
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: cache miss for group 'users'
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: : entering mysql cmd_select
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 3
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: query "SELECT groupid, gid, members FROM groups WHERE (groupid = 'users')"
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 2
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_select
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: cache miss for group 'users'
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: group 'users' cached
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: + grp.gr_name : users
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: + grp.gr_gid : 10001
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: + grp.gr_mem :
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_setgrent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_getpwnam
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: cache hit for user 'username'
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_getpwnam
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_setpwent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: : entering mysql cmd_select
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 3
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: query "SELECT userid FROM users WHERE ((0))"
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 2
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_select
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_setpwent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_setgrent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_setgrent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_getpwent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_getpwent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> cmd_getgrent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< cmd_getgrent
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> log_master
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> _process_named_query
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_escapestring
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_escapestring
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_update
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 3
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: query "UPDATE users SET login_count=login_count+1 WHERE userid='username'"
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 2
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_update
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< _process_named_query
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< log_master
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> log_master
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: >>> _process_named_query
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_escapestring
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_escapestring
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_update
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 3
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_open
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: query "UPDATE users SET last_login=now() WHERE userid='username'"
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: entering mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: connection 'default' count is now 2
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_close
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: exiting mysql cmd_update
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< _process_named_query
> Mar 01 18:45:33 mod_sql/4.2.1[59857]: <<< log_master
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: defaulting to 'mysql' backend
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: backend module 'mod_sql_mysql/4.05'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: backend api 'mod_sql_api_v2'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: >>> sql_sess_init
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: entering mysql cmd_defineconnection
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: name: 'default'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: user: 'proftpd'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: host: 'localhost'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: db: 'proftpd'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: port: '3306'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: ttl: '10'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_defineconnection
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: entering mysql cmd_open
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: connection 'default' - 10 second timer started
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: connection 'default' opened
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: connection 'default' count is now 2
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_open
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: backend successfully connected.
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: mod_sql engine : on
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: negative_cache : on
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: authenticate : users groups userset groupset
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: usertable : users
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: userid field : userid
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: password field : passwd
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: uid field : uid
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: gid field : gid
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: homedir field : homedir
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: homedir(default) : '/nonexistent'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: shell field : shell
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: homedirondemand : false
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: group table : groups
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: groupname field : groupid
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: grp gid field : gid
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: grp members field : members
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: SQLMinUserUID : 999
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: SQLMinUserGID : 999
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: SQLDefaultUID : 65533
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: SQLDefaultGID : 65533
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: <<< sql_sess_init
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: >>> cmd_endpwent
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: <<< cmd_endpwent
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: >>> cmd_endgrent
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: <<< cmd_endgrent
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: >>> cmd_getgroups
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: entering mysql cmd_escapestring
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_escapestring
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: cache miss for user 'exit'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: >>> sql_lookup
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: >>> _process_named_query
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: entering mysql cmd_escapestring
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_escapestring
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: : entering mysql cmd_select
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: entering mysql cmd_open
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: connection 'default' count is now 3
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_open
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: query "SELECT userid, CONCAT('{MD5}', base64encode(hexdecode(passwd))) AS passwd, uid, gid, homedir, shell FROM users W
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: entering mysql cmd_close
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: connection 'default' count is now 2
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_close
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_select
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: <<< _process_named_query
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: <<< sql_lookup
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: cache miss for user 'exit'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: user 'exit' cached
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: + pwd.pw_name : exit
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: + pwd.pw_uid : 4294967295
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: + pwd.pw_gid : 0
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: + pwd.pw_dir : (null)
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: + pwd.pw_shell : (null)
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: cache miss for gid '0'
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: : entering mysql cmd_select
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: entering mysql cmd_open
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: connection 'default' count is now 3
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_open
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: query "SELECT groupid FROM groups WHERE (gid = 0) LIMIT 1"
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: entering mysql cmd_close
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: connection 'default' count is now 2
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_close
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_select
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: entering mysql cmd_escapestring
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_escapestring
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: : entering mysql cmd_select
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: entering mysql cmd_open
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: connection 'default' count is now 3
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_open
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: query "SELECT groupid, gid, members FROM groups WHERE (members = 'exit' OR members LIKE 'exit,%' OR members LIKE '%,exi
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: entering mysql cmd_close
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: connection 'default' count is now 2
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_close
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: exiting mysql cmd_select
> Mar 01 18:45:34 mod_sql/4.2.1[59858]: <<< cmd_getgroups
> Mar 01 18:45:43 mod_sql/4.2.1[59857]: timer expired for connection 'default'
> Mar 01 18:45:43 mod_sql/4.2.1[59857]: entering mysql cmd_close
> Mar 01 18:45:43 mod_sql/4.2.1[59857]: connection 'default' - timer stopped
> Mar 01 18:45:43 mod_sql/4.2.1[59857]: connection 'default' closed
> Mar 01 18:45:43 mod_sql/4.2.1[59857]: connection 'default' count is now 0
> Mar 01 18:45:43 mod_sql/4.2.1[59857]: exiting mysql cmd_close
> Mar 01 18:45:44 mod_sql/4.2.1[59858]: timer expired for connection 'default'
> Mar 01 18:45:44 mod_sql/4.2.1[59858]: entering mysql cmd_close
> Mar 01 18:45:44 mod_sql/4.2.1[59858]: connection 'default' - timer stopped
> Mar 01 18:45:44 mod_sql/4.2.1[59858]: connection 'default' closed
> Mar 01 18:45:44 mod_sql/4.2.1[59858]: connection 'default' count is now 0
> Mar 01 18:45:44 mod_sql/4.2.1[59858]: exiting mysql cmd_close
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: >>> sql_pre_pass
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: >>> cmd_getgroups
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: cache hit for user 'exit'
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: negative cache entry for user 'exit'
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: <<< cmd_getgroups
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: <<< sql_pre_pass
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: >>> cmd_endpwent
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: <<< cmd_endpwent
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: >>> cmd_endgrent
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: <<< cmd_endgrent
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: >>> cmd_getpwnam
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: cache hit for user 'exit'
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: negative cache entry for user 'exit'
> Mar 01 18:45:57 mod_sql/4.2.1[59858]: <<< cmd_getpwnam
> Mar 01 18:46:32 mod_sql/4.2.1[59857]: >>> sql_post_stor
> Mar 01 18:46:32 mod_sql/4.2.1[59857]: <<< sql_post_stor
> Mar 01 18:46:32 mod_sql/4.2.1[59857]: >>> log_master
> Mar 01 18:46:32 mod_sql/4.2.1[59857]: >>> _process_named_query
> Mar 01 18:46:32 mod_sql/4.2.1[59857]: entering mysql cmd_escapestring
> Mar 01 18:47:30 mod_sql/4.2.1[59858]: entering mysql cmd_exit
> Mar 01 18:47:30 mod_sql/4.2.1[59858]: exiting mysql cmd_exit
>


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=...057&dat=121642
_______________________________________________
ProFTPD Users List
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html