(Proftpd + mod_sql) groupowner = wheel... why?

Проблемы с установкой, настройкой и работой системных и сетевых программ.

Модераторы: GRooVE, alexco

Правила форума
Убедительная просьба юзать теги [code] при оформлении листингов.
Сообщения не оформленные должным образом имеют все шансы быть незамеченными.
Ответить
sheva
проходил мимо
Сообщения: 4
Зарегистрирован: 2012-02-14 16:04:53

(Proftpd + mod_sql) groupowner = wheel... why?

Непрочитанное сообщение sheva » 2012-02-14 19:08:55

Всем привет!
Начну сразу с описания ПО:
- FreeBSD 8.2-STABLE #0 amd64, вся файловая система на zfs
- mysql-server-5.5.19
- proftpd 1.3.3g + mod_sql
- conf и информация ниже

Имеем настроенный proftpd + mod_sql, mysql с настроенной базой юзеров. Проблема состоит в том, что при записи нового файла, groupowner=0.

Код: Выделить всё

# lf /www/ftp/
-rw-r--r--  1 2003  wheel   3.2k Feb 14 15:19 proftpd.sql
Если использовать без mod_sql, то все нормально. Кто-то сталкивался с такой проблемой?

dump.sql

Код: Выделить всё

select * from groups;
+------+----------+--------+---------+---------------------+
| id   | name     | enable | members | created             |
+------+----------+--------+---------+---------------------+
| 2003 | ftpusers | y      | test    | 2012-02-14 00:00:00 |
+------+----------+--------+---------+---------------------+

select * from users;
+------+-------+--------+-------------------------------------------+----------+-----------+---------+---------------------+                                 
| id   | name  | enable | pass                                      | group_id | home      | shell   | created             |                                 
+------+-------+--------+-------------------------------------------+----------+-----------+---------+---------------------+                                                                
| 2003 | test  | y      | .... |     2003 | /www/ftp/ | /bin/sh | 2012-02-14 00:00:00 |                                 
+------+-------+--------+-------------------------------------------+----------+-----------+---------+---------------------+
proftpd.conf

Код: Выделить всё

ServerType			standalone
Port				21
DefaultServer		off
User				nobody
Group				nogroup
SystemLog			/var/log/proftpd/system.log

MaxInstances		30
CommandBufferSize	512
ScoreboardFile		/var/run/proftpd/proftpd.scoreboard

ServerName 			"..."
ServerAdmin 		"..."
ServerIdent on 		"..."
DefaultAddress		127.0.0.1

AccessDenyMsg 		"..."
AccessGrantMsg 		"..."

Umask				022
AllowOverwrite		on
RootLogin 			off

<virtualhost ip1>
	ServerName 			"..."
	ServerAdmin 		"..."
	ServerIdent on 		"..."
	AccessDenyMsg 		"..."
	AccessGrantMsg 		"..."
	ServerLog			/var/log/proftpd/ip1.log
	Umask				022
	AllowOverwrite		on
</virtualhost>

<virtualhost ip2>
	ServerName 			"..."
	ServerAdmin 		"..."
	ServerIdent on 		"..."
	ServerLog			/var/log/proftpd/ip2.log
	PassivePorts		min max
	
	AccessDenyMsg 		"..."
	AccessGrantMsg 		"..."

	AuthOrder			mod_sql.c
	SQLAuthenticate		users groups
	SQLAuthTypes		Backend
	SQLBackend 			mysql
	SQLDefaultUID      	2001
	SQLDefaultGID		2001
	SQLMinUserUID		2001
	SQLMinUserGID		2001
	SQLConnectInfo		...
	SQLGroupInfo		groups name id members
	SQLGroupWhereClause	"enable='y'"
	SQLUserInfo			users name pass id group_id home shell
	SQLUserWhereClause 	"enable='y'"

	DirFakeUser			off
	DirFakeGroup		off
	DefaultChdir		~
	DefaultRoot			~
	Umask				022
	AllowOverwrite		on

	SQLLogFile			/var/log/proftpd/sql.log
</virtualhost>
Ну и собственно логи:
Server(ip2.log):

Код: Выделить всё

Feb 14 15:19:10  proftpd[4927] ...: FTP session opened.
Feb 14 15:19:17  proftpd[4927] ...: Preparing to chroot to directory '/www/ftp'
Feb 14 15:19:17  proftpd[4927] ...: USER test: Login successful.
Feb 14 15:19:44  proftpd[4927] ...: FTP session closed.
SQL:

Код: Выделить всё

Feb 14 15:19:10 mod_sql/4.2.5[4927]: defaulting to 'mysql' backend
Feb 14 15:19:10 mod_sql/4.2.5[4927]: backend module 'mod_sql_mysql/4.0.8'
Feb 14 15:19:10 mod_sql/4.2.5[4927]: backend api    'mod_sql_api_v1'
Feb 14 15:19:10 mod_sql/4.2.5[4927]: >>> sql_sess_init
Feb 14 15:19:10 mod_sql/4.2.5[4927]: entering 	mysql cmd_defineconnection
Feb 14 15:19:10 mod_sql/4.2.5[4927]:   name: 'default'
Feb 14 15:19:10 mod_sql/4.2.5[4927]:   user: '...'
Feb 14 15:19:10 mod_sql/4.2.5[4927]:   host: '...'
Feb 14 15:19:10 mod_sql/4.2.5[4927]:     db: '...'
Feb 14 15:19:10 mod_sql/4.2.5[4927]:   port: '...'
Feb 14 15:19:10 mod_sql/4.2.5[4927]:    ttl: '0'
Feb 14 15:19:10 mod_sql/4.2.5[4927]: exiting 	mysql cmd_defineconnection
Feb 14 15:19:10 mod_sql/4.2.5[4927]: mod_sql engine     : on
Feb 14 15:19:10 mod_sql/4.2.5[4927]: negative_cache     : off
Feb 14 15:19:10 mod_sql/4.2.5[4927]: authenticate       : users groups 
Feb 14 15:19:10 mod_sql/4.2.5[4927]: usertable          : users
Feb 14 15:19:10 mod_sql/4.2.5[4927]: userid field       : name
Feb 14 15:19:10 mod_sql/4.2.5[4927]: password field     : pass
Feb 14 15:19:10 mod_sql/4.2.5[4927]: UID field          : id
Feb 14 15:19:10 mod_sql/4.2.5[4927]: GID field          : group_id
Feb 14 15:19:10 mod_sql/4.2.5[4927]: homedir field      : home
Feb 14 15:19:10 mod_sql/4.2.5[4927]: shell field        : shell
Feb 14 15:19:10 mod_sql/4.2.5[4927]: group table        : groups
Feb 14 15:19:10 mod_sql/4.2.5[4927]: groupname field    : name
Feb 14 15:19:10 mod_sql/4.2.5[4927]: grp GID field      : id
Feb 14 15:19:10 mod_sql/4.2.5[4927]: grp members field  : members
Feb 14 15:19:10 mod_sql/4.2.5[4927]: SQLMinUserUID      : 2001
Feb 14 15:19:10 mod_sql/4.2.5[4927]: SQLMinUserGID      : 2001
Feb 14 15:19:10 mod_sql/4.2.5[4927]: SQLDefaultUID      : 2001
Feb 14 15:19:10 mod_sql/4.2.5[4927]: SQLDefaultGID      : 2001
Feb 14 15:19:10 mod_sql/4.2.5[4927]: <<< sql_sess_init
Feb 14 15:19:17 mod_sql/4.2.5[4927]: >>> sql_pre_pass
Feb 14 15:19:17 mod_sql/4.2.5[4927]: <<< sql_pre_pass
Feb 14 15:19:17 mod_sql/4.2.5[4927]: >>> cmd_getpwnam
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_escapestring
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: MySQL client version: 5.5.20
Feb 14 15:19:17 mod_sql/4.2.5[4927]: MySQL server version: 5.5.19
Feb 14 15:19:17 mod_sql/4.2.5[4927]: MySQL connection character set now 'utf8' (from 'UTF-8')
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' opened
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 2
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 1
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_escapestring
Feb 14 15:19:17 mod_sql/4.2.5[4927]: cache miss for user 'test'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: : entering 	mysql cmd_select
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 2
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: query "SELECT name, pass, id, group_id, home, shell FROM users WHERE (name='test') AND (((enable='y'))) LIMIT 1"
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 1
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_select
Feb 14 15:19:17 mod_sql/4.2.5[4927]: cache miss for user 'test'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: user 'test' cached
Feb 14 15:19:17 mod_sql/4.2.5[4927]: + pwd.pw_name  : test
Feb 14 15:19:17 mod_sql/4.2.5[4927]: + pwd.pw_uid   : 2003
Feb 14 15:19:17 mod_sql/4.2.5[4927]: + pwd.pw_gid   : 2003
Feb 14 15:19:17 mod_sql/4.2.5[4927]: + pwd.pw_dir   : /www/ftp/
Feb 14 15:19:17 mod_sql/4.2.5[4927]: + pwd.pw_shell : /bin/sh
Feb 14 15:19:17 mod_sql/4.2.5[4927]: <<< cmd_getpwnam
Feb 14 15:19:17 mod_sql/4.2.5[4927]: >>> cmd_gid2name
Feb 14 15:19:17 mod_sql/4.2.5[4927]: cache miss for GID '2003'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: : entering 	mysql cmd_select
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 2
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: query "SELECT name FROM groups WHERE (id = 2003) AND (((enable='y'))) LIMIT 1"
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 1
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_select
Feb 14 15:19:17 mod_sql/4.2.5[4927]: : entering 	mysql cmd_select
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 2
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: query "SELECT name, id, members FROM groups WHERE (name = 'ftpusers') AND (((enable='y')))"
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 1
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_select
Feb 14 15:19:17 mod_sql/4.2.5[4927]: cache miss for group 'ftpusers'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: group 'ftpusers' cached
Feb 14 15:19:17 mod_sql/4.2.5[4927]: + grp.gr_name : ftpusers
Feb 14 15:19:17 mod_sql/4.2.5[4927]: + grp.gr_gid  : 2003
Feb 14 15:19:17 mod_sql/4.2.5[4927]: + grp.gr_mem  : test
Feb 14 15:19:17 mod_sql/4.2.5[4927]: <<< cmd_gid2name
Feb 14 15:19:17 mod_sql/4.2.5[4927]: >>> cmd_getgroups
Feb 14 15:19:17 mod_sql/4.2.5[4927]: cache hit for user 'test'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: cache hit for group 'ftpusers'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_escapestring
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 2
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 1
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_escapestring
Feb 14 15:19:17 mod_sql/4.2.5[4927]: : entering 	mysql cmd_select
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 2
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: query "SELECT name, id, members FROM groups WHERE (members = 'test' OR members LIKE 'test,%' OR members LIKE '%,test' OR members LIKE '%,test,%') AND (((enable='y')))"
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 1
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_select
Feb 14 15:19:17 mod_sql/4.2.5[4927]: cache hit for group 'ftpusers'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: <<< cmd_getgroups
Feb 14 15:19:17 mod_sql/4.2.5[4927]: >>> cmd_auth
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_escapestring
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 2
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_open
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: connection 'default' count is now 1
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_close
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_escapestring
Feb 14 15:19:17 mod_sql/4.2.5[4927]: cache hit for user 'test'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: >>> cmd_check
Feb 14 15:19:17 mod_sql/4.2.5[4927]: checking password using SQLAuthType 'Backend'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: entering 	mysql cmd_checkauth
Feb 14 15:19:17 mod_sql/4.2.5[4927]: exiting 	mysql cmd_checkauth
Feb 14 15:19:17 mod_sql/4.2.5[4927]: 'Backend' SQLAuthType handler reports success
Feb 14 15:19:17 mod_sql/4.2.5[4927]: cache hit for user 'test'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: <<< cmd_check
Feb 14 15:19:17 mod_sql/4.2.5[4927]: <<< cmd_auth
Feb 14 15:19:17 mod_sql/4.2.5[4927]: >>> cmd_getpwnam
Feb 14 15:19:17 mod_sql/4.2.5[4927]: cache hit for user 'test'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: <<< cmd_getpwnam
Feb 14 15:19:17 mod_sql/4.2.5[4927]: >>> cmd_getpwnam
Feb 14 15:19:17 mod_sql/4.2.5[4927]: cache hit for user 'test'
Feb 14 15:19:17 mod_sql/4.2.5[4927]: <<< cmd_getpwnam
Feb 14 15:19:41 mod_sql/4.2.5[4927]: >>> sql_post_stor
Feb 14 15:19:41 mod_sql/4.2.5[4927]: <<< sql_post_stor
Feb 14 15:19:44 mod_sql/4.2.5[4927]: entering 	mysql cmd_exit
Feb 14 15:19:44 mod_sql/4.2.5[4927]: entering 	mysql cmd_close
Feb 14 15:19:44 mod_sql/4.2.5[4927]: connection 'default' closed
Feb 14 15:19:44 mod_sql/4.2.5[4927]: connection 'default' count is now 0
Feb 14 15:19:44 mod_sql/4.2.5[4927]: exiting 	mysql cmd_close
Feb 14 15:19:44 mod_sql/4.2.5[4927]: exiting 	mysql cmd_exit
P.S. Прошу прощения, если оффтоп.
Вернуться к началу
Хостинговая компания Host-Food.ru
Хостинг HostFood.ru
 

Услуги хостинговой компании Host-Food.ru

Хостинг HostFood.ru

Тарифы на хостинг в России, от 12 рублей: https://www.host-food.ru/tariffs/hosting/
Тарифы на виртуальные сервера (VPS/VDS/KVM) в РФ, от 189 руб.: https://www.host-food.ru/tariffs/virtualny-server-vps/
Выделенные сервера, Россия, Москва, от 2000 рублей (HP Proliant G5, Intel Xeon E5430 (2.66GHz, Quad-Core, 12Mb), 8Gb RAM, 2x300Gb SAS HDD, P400i, 512Mb, BBU):
https://www.host-food.ru/tariffs/vydelennyi-server-ds/
Недорогие домены в популярных зонах: https://www.host-food.ru/domains/
Вернуться к началу
GhOsT_MZ
лейтенант
Сообщения: 662
Зарегистрирован: 2011-04-25 11:40:35
Контактная информация:
Контактная информация пользователя GhOsT_MZ

Re: (Proftpd + mod_sql) groupowner = wheel... why?

Непрочитанное сообщение GhOsT_MZ » 2012-02-14 19:25:10

http://www.opennet.ru/openforum/vsluhfo ... 29000.html
Вернуться к началу
sheva
проходил мимо
Сообщения: 4
Зарегистрирован: 2012-02-14 16:04:53

Re: (Proftpd + mod_sql) groupowner = wheel... why?

Непрочитанное сообщение sheva » 2012-02-14 20:40:04

- Спасибо за линк... похожая ситуация, только не такая :) решение той проблемы мне не подходит, так как у меня uid и gid больше минимальных...
- SQLDefaultGID я менял и экспериментировал, но результата 0.
- Если мыслить логически, то надо копать с gid=0, который указан только в файле /etc/group, но в конфиге "AuthOrder mod_sql.c", а сам демон запускал и от ftp:ftp, и от nobody:nogroup...
еще есть идеи?
Вернуться к началу
sheva
проходил мимо
Сообщения: 4
Зарегистрирован: 2012-02-14 16:04:53

Re: (Proftpd + mod_sql) groupowner = wheel... why?

Непрочитанное сообщение sheva » 2012-02-15 11:53:33

Вот лог при "-n -d10":

Код: Выделить всё

# proftpd -n -d10
 - using TCP receive buffer size of 65536 bytes
 - using TCP send buffer size of 32768 bytes
 - testing Unix domain socket using S_ISFIFO
 - testing Unix domain socket using S_ISSOCK
 - using S_ISSOCK macro for Unix domain socket detection
 - mod_sql_passwd/0.2: registered 'md5' SQLAuthType handler
 - mod_sql_passwd/0.2: registered 'sha1' SQLAuthType handler
 - mod_sql_passwd/0.2: registered 'sha256' SQLAuthType handler
 - mod_sql_passwd/0.2: registered 'sha512' SQLAuthType handler
 - mod_tls/2.4.2: using OpenSSL 0.9.8q 2 Dec 2010
 - retrieved UID 14 for user 'ftp'
 - retrieved GID 14 for group 'ftp'
 - ROOT PRIVS at mod_log.c:535
 - RELINQUISH PRIVS at mod_log.c:540
 - setting default address to 127.0.0.1
localhost - 
localhost - Config for FTP server for localhost:
localhost - UserID
localhost - UserName                                                                                                                                         
localhost - GroupID                                                                                                                                          
localhost - GroupName                                                                                                                                        
localhost - CommandBufferSize                                                                                                                                
localhost - ServerIdent                                                                                                                                      
localhost - AccessDenyMsg                                                                                                                                    
localhost - AccessGrantMsg                                                                                                                                   
localhost - Umask                                                                                                                                            
localhost - AllowOverwrite                                                                                                                                   
localhost - RootLogin                                                                                                                                        
localhost -                                                                                                                                                  
localhost - Config for ...:                                                                                                           
localhost - ServerIdent                                                                                                                                      
localhost - AccessDenyMsg                                                                                                                                    
localhost - AccessGrantMsg                                                                                                                                   
localhost - ServerLog                                                                                                                                        
localhost - Umask                                                                                                                                            
localhost - AllowOverwrite                                                                                                                                   
localhost -                                                                                                                                                  
localhost - Config for ...:                                                                                                               
localhost - ServerIdent                                                                                                                                      
localhost - ServerLog                                                                                                                                        
localhost - PassivePorts                                                                                                                                     
localhost - AccessDenyMsg                                                                                                                                    
localhost - AccessGrantMsg
localhost - AuthOrder
localhost - SQLAuthenticate
localhost - SQLAuthTypes
localhost - SQLBackend
localhost - SQLDefaultUID
localhost - SQLDefaultGID
localhost - SQLMinUserUID
localhost - SQLMinUserGID
localhost - SQLConnectInfo
localhost - SQLGroupTable
localhost - SQLGroupnameField
localhost - SQLGroupGIDField
localhost - SQLGroupMembersField
localhost - SQLGroupWhereClause
localhost - SQLUserTable
localhost - SQLUsernameField
localhost - SQLPasswordField
localhost - SQLUidField
localhost - SQLGidField
localhost - SQLHomedirField
localhost - SQLShellField
localhost - SQLUserWhereClause
localhost - DirFakeUser
localhost - DirFakeGroup
localhost - DefaultChdir
localhost - DefaultRoot
localhost - Umask
localhost - AllowOverwrite
localhost - SQLLogFile
localhost - ROOT PRIVS at mod_delay.c:354
localhost - RELINQUISH PRIVS at mod_delay.c:359
localhost - ROOT PRIVS at mod_ctrls.c:1139
localhost - RELINQUISH PRIVS at mod_ctrls.c:1141
localhost - mod_lang/0.9: binding to text domain 'proftpd' using locale path '/usr/local/share/locale'
localhost - mod_lang/0.9: using locale files in '/usr/local/share/locale'
localhost - mod_lang/0.9: added the following supported languages: ja_JP.UTF-8, ja_JP, zh_CN.UTF-8, zh_CN, zh_TW.UTF-8, zh_TW, ru_RU.UTF-8, ru_RU, it_IT.UTF-8, it_IT, bg_BG.UTF-8, bg_BG, ko_KR.UTF-8, ko_KR, en_US.UTF-8, en_US, fr_FR.UTF-8, fr_FR
localhost - retrieved group ID: 14
localhost - setting group ID: 14
localhost - SETUP PRIVS at main.c:3133
localhost - ROOT PRIVS at main.c:2155
localhost - RELINQUISH PRIVS at main.c:2162
localhost - ROOT PRIVS at main.c:2490
localhost - opening scoreboard '/var/run/proftpd/proftpd.scoreboard'
localhost - RELINQUISH PRIVS at main.c:2516
localhost - ROOT PRIVS at mod_ctrls_admin.c:1180
localhost - opening scoreboard '/var/run/proftpd/proftpd.scoreboard'
localhost - RELINQUISH PRIVS at mod_ctrls_admin.c:1182
localhost - ROOT PRIVS at inet.c:238
localhost - RELINQUISH PRIVS at inet.c:256
localhost - ROOT PRIVS at inet.c:350
localhost - RELINQUISH PRIVS at inet.c:413
localhost - ProFTPD 1.3.3g (maint) (built Wed Jan 25 2012 10:18:02 UTC) standalone mode STARTUP
localhost - ROOT PRIVS at pidfile.c:48
localhost - RELINQUISH PRIVS at pidfile.c:50
localhost - ROOT PRIVS at mod_ctrls.c:693
localhost - RELINQUISH PRIVS at mod_ctrls.c:697
localhost - ROOT PRIVS at main.c:1247
localhost - RELINQUISH PRIVS at main.c:1251
... - session requested from client in unknown class
... - performing module session initializations
... - ROOT PRIVS at mod_sql.c:4961
... - RELINQUISH PRIVS at mod_sql.c:4963
... - mod_sql/4.2.5: defaulting to 'mysql' backend
... - mod_ident/1.0: ident lookup disabled
... - ROOT PRIVS at mod_delay.c:1465
... - RELINQUISH PRIVS at mod_delay.c:1470
... - ROOT PRIVS at mod_log.c:1367
... - RELINQUISH PRIVS at mod_log.c:1370
... - ROOT PRIVS at mod_auth.c:133
... - opening scoreboard '/var/run/proftpd/proftpd.scoreboard'
... - RELINQUISH PRIVS at mod_auth.c:135
... - AuthOrder in effect, resetting auth module order
... - connected - local  : ...
... - connected - remote : ...
... - FTP session opened.
... - dispatching PRE_CMD command 'USER test' to mod_tls
... - dispatching PRE_CMD command 'USER test' to mod_rewrite
...  - dispatching PRE_CMD command 'USER test' to mod_core
... - dispatching PRE_CMD command 'USER test' to mod_core
... - dispatching PRE_CMD command 'USER test' to mod_delay
... - dispatching PRE_CMD command 'USER test' to mod_auth
... - dispatching CMD command 'USER test' to mod_ratio
... - dispatching CMD command 'USER test' to mod_auth
... - dispatching POST_CMD command 'USER test' to mod_sql
... - dispatching POST_CMD command 'USER test' to mod_delay
... - dispatching LOG_CMD command 'USER test' to mod_sql
... - dispatching LOG_CMD command 'USER test' to mod_log
localhost - scrubbing scoreboard
localhost - ROOT PRIVS at scoreboard.c:1081
localhost - RELINQUISH PRIVS at scoreboard.c:1083
localhost - ROOT PRIVS at scoreboard.c:1121
localhost - RELINQUISH PRIVS at scoreboard.c:1155
... - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls
... - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite
... - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
... - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
... - dispatching PRE_CMD command 'PASS (hidden)' to mod_sql_passwd
... - dispatching PRE_CMD command 'PASS (hidden)' to mod_sql
... - dispatching PRE_CMD command 'PASS (hidden)' to mod_ban
... - dispatching PRE_CMD command 'PASS (hidden)' to mod_radius
... - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap2
... - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay
...- dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
...- dispatching CMD command 'PASS (hidden)' to mod_auth
... - [b]retrieved UID 2003 for user 'test'[/b]
... - [b]retrieved group IDs: 2003, 2003[/b]
... - [b]retrieved group names: ftpusers, ftpusers[/b]
... - user 'test' authenticated by mod_sql.c
... - ROOT PRIVS at auth.c:1252
... - RELINQUISH PRIVS at auth.c:1254
... - USER PRIVS 2003 at mod_auth.c:1071
... - RELINQUISH PRIVS at mod_auth.c:1073
... - 
... - Config for FTP server for hosting:
... - ServerIdent
... - ServerLog
... - PassivePorts
...- AccessDenyMsg
... - AccessGrantMsg
... - AuthOrder
... - SQLAuthenticate
... - SQLAuthTypes
... - SQLBackend
... - SQLDefaultUID
... - SQLDefaultGID
... - SQLMinUserUID
... - SQLMinUserGID
... - SQLConnectInfo
... - SQLGroupTable
... - SQLGroupnameField
... - SQLGroupGIDField
... - SQLGroupMembersField
... - SQLGroupWhereClause
... - SQLUserTable
... - SQLUsernameField
... - SQLPasswordField
... - SQLUidField
... - SQLGidField
... - SQLHomedirField
... - SQLShellField
... - SQLUserWhereClause
... - DirFakeUser
... - DirFakeGroup
... - DefaultChdir
... - DefaultRoot
... - Umask
... - AllowOverwrite
... - SQLLogFile
... - ROOT PRIVS at mod_auth.c:1161
... - opening TransferLog '/var/log/xferlog'
... - [b]setting group ID: 2003[/b]
... - RELINQUISH PRIVS at mod_auth.c:1201
... - USER PRIVS 2003 at mod_auth.c:604
... - retrieved UID 2003 for user 'test'
... - RELINQUISH PRIVS at mod_auth.c:608
... - Preparing to chroot to directory '/www/ftp'
... - ROOT PRIVS at auth.c:1356
... - RELINQUISH PRIVS at auth.c:1358
... - Environment successfully chroot()ed
... - ROOT PRIVS at mod_auth.c:1242
... - SETUP PRIVS at mod_auth.c:1254
... - retrieved UID 2003 for user 'test'
... - unable to chdir to ~/ (No such file or directory), defaulting to chroot directory /www/ftp
... - in dir_check_full(): path = '/', fullpath = '/www/ftp/'.
... - dispatching POST_CMD command 'PASS (hidden)' to mod_sql
... - dispatching POST_CMD command 'PASS (hidden)' to mod_ifsession
... - dispatching POST_CMD command 'PASS (hidden)' to mod_quotatab
... - dispatching POST_CMD command 'PASS (hidden)' to mod_tls
... - dispatching POST_CMD command 'PASS (hidden)' to mod_radius
... - dispatching POST_CMD command 'PASS (hidden)' to mod_wrap2
... - dispatching POST_CMD command 'PASS (hidden)' to mod_readme
... - dispatching POST_CMD command 'PASS (hidden)' to mod_ratio
... - dispatching POST_CMD command 'PASS (hidden)' to mod_delay
... - dispatching POST_CMD command 'PASS (hidden)' to mod_log
... - dispatching POST_CMD command 'PASS (hidden)' to mod_ls
... - dispatching POST_CMD command 'PASS (hidden)' to mod_auth
... - RELINQUISH PRIVS at mod_auth.c:1614
... - dispatching POST_CMD command 'PASS (hidden)' to mod_xfer
... - dispatching POST_CMD command 'PASS (hidden)' to mod_core
... - dispatching LOG_CMD command 'PASS (hidden)' to mod_sql
... - dispatching LOG_CMD command 'PASS (hidden)' to mod_log
... - dispatching LOG_CMD command 'PASS (hidden)' to mod_ratio
... - dispatching LOG_CMD command 'PASS (hidden)' to mod_auth
... - USER test: Login successful.
... - dispatching PRE_CMD command 'SYST' to mod_tls
... - dispatching PRE_CMD command 'SYST' to mod_rewrite
... - dispatching PRE_CMD command 'SYST' to mod_core
... - dispatching PRE_CMD command 'SYST' to mod_core
... - dispatching CMD command 'SYST' to mod_core
... - dispatching POST_CMD command 'SYST' to mod_sql
... - dispatching LOG_CMD command 'SYST' to mod_sql
... - dispatching LOG_CMD command 'SYST' to mod_log
... - dispatching PRE_CMD command 'FEAT' to mod_tls
... - dispatching PRE_CMD command 'FEAT' to mod_rewrite
... - dispatching PRE_CMD command 'FEAT' to mod_core
... - dispatching PRE_CMD command 'FEAT' to mod_core
... - dispatching CMD command 'FEAT' to mod_core
... - in dir_check_full(): path = '/', fullpath = '/www/ftp/'.
... - dispatching POST_CMD command 'FEAT' to mod_sql
... - dispatching LOG_CMD command 'FEAT' to mod_sql
... - dispatching LOG_CMD command 'FEAT' to mod_log
... - dispatching PRE_CMD command 'PWD' to mod_tls
... - dispatching PRE_CMD command 'PWD' to mod_rewrite
... - dispatching PRE_CMD command 'PWD' to mod_core
... - dispatching PRE_CMD command 'PWD' to mod_core
... - dispatching CMD command 'PWD' to mod_core
... - in dir_check_full(): path = '/', fullpath = '/www/ftp/'.
... - dispatching POST_CMD command 'PWD' to mod_sql
... - dispatching LOG_CMD command 'PWD' to mod_sql
... - dispatching LOG_CMD command 'PWD' to mod_log
... - dispatching PRE_CMD command 'TYPE I' to mod_tls
... - dispatching PRE_CMD command 'TYPE I' to mod_rewrite
... - dispatching PRE_CMD command 'TYPE I' to mod_core
... - dispatching PRE_CMD command 'TYPE I' to mod_core
... - dispatching CMD command 'TYPE I' to mod_xfer
... - dispatching POST_CMD command 'TYPE I' to mod_sql
... - dispatching LOG_CMD command 'TYPE I' to mod_sql
... - dispatching LOG_CMD command 'TYPE I' to mod_log
... - dispatching PRE_CMD command 'EPSV' to mod_tls
... - dispatching PRE_CMD command 'EPSV' to mod_rewrite
... - dispatching PRE_CMD command 'EPSV' to mod_core
... - dispatching PRE_CMD command 'EPSV' to mod_core
... - dispatching CMD command 'EPSV' to mod_core
... - in dir_check_full(): path = '/', fullpath = '/www/ftp/'.
... - ROOT PRIVS at inet.c:238
... - RELINQUISH PRIVS at inet.c:256
... - Entering Extended Passive Mode (|||65287|)
... - dispatching POST_CMD command 'EPSV' to mod_sql
... - dispatching LOG_CMD command 'EPSV' to mod_sql
... - dispatching LOG_CMD command 'EPSV' to mod_log
... - dispatching PRE_CMD command 'STOR akonadiserver.core' to mod_tls
... - dispatching PRE_CMD command 'STOR akonadiserver.core' to mod_rewrite
... - dispatching PRE_CMD command 'STOR akonadiserver.core' to mod_core
... - dispatching PRE_CMD command 'STOR akonadiserver.core' to mod_core
... - dispatching PRE_CMD command 'STOR akonadiserver.core' to mod_quotatab
... - dispatching PRE_CMD command 'STOR akonadiserver.core' to mod_ratio
... - dispatching PRE_CMD command 'STOR akonadiserver.core' to mod_xfer
... - in dir_check_full(): path = '/akonadiserver.core', fullpath = '/www/ftp/akonadiserver.core'.
... - in dir_check_full(): setting umask to 0022 (was 0022)
... - dispatching CMD command 'STOR akonadiserver.core' to mod_xfer
... - passive data connection opened - local  : ...
... - passive data connection opened - remote : ...
... - dispatching POST_CMD command 'STOR akonadiserver.core' to mod_sql
... - dispatching POST_CMD command 'STOR akonadiserver.core' to mod_quotatab
... - dispatching POST_CMD command 'STOR akonadiserver.core' to mod_sql
... - dispatching POST_CMD command 'STOR akonadiserver.core' to mod_ratio
... - dispatching LOG_CMD command 'STOR akonadiserver.core' to mod_sql
... - dispatching LOG_CMD command 'STOR akonadiserver.core' to mod_log
... - dispatching LOG_CMD command 'STOR akonadiserver.core' to mod_xfer
... - Transfer completed: 8835072 bytes in 0.14 seconds
... - dispatching PRE_CMD command 'QUIT' to mod_tls
... - dispatching PRE_CMD command 'QUIT' to mod_rewrite
... - dispatching PRE_CMD command 'QUIT' to mod_core
... - dispatching PRE_CMD command 'QUIT' to mod_core
... - dispatching CMD command 'QUIT' to mod_core
... - dispatching POST_CMD command 'QUIT' to mod_sql
... - dispatching LOG_CMD command 'QUIT' to mod_sql
... - dispatching LOG_CMD command 'QUIT' to mod_log
... - dispatching LOG_CMD command 'QUIT' to mod_core
... - FTP session closed.
localhost - scrubbing scoreboard
localhost - ROOT PRIVS at scoreboard.c:1081
localhost - RELINQUISH PRIVS at scoreboard.c:1083
localhost - ROOT PRIVS at scoreboard.c:1121
localhost - RELINQUISH PRIVS at scoreboard.c:1155
localhost - ProFTPD terminating (signal 2)
localhost - ROOT PRIVS at main.c:2018
localhost - ROOT PRIVS at mod_delay.c:1346
localhost - RELINQUISH PRIVS at mod_delay.c:1351
localhost - RELINQUISH PRIVS at main.c:2040
localhost - ProFTPD 1.3.3g standalone mode SHUTDOWN
localhost - ROOT PRIVS at main.c:2047
localhost - deleting existing scoreboard '/var/run/proftpd/proftpd.scoreboard'
localhost - RELINQUISH PRIVS at main.c:2049
... - retrieved UID 2003 for user 'test'
... - retrieved group IDs: 2003, 2003
... - retrieved group names: ftpusers, ftpusers
... - setting group ID: 2003
Наводит на мысль, что все ок, но в действительности файл записуется $user:wheel...
Вернуться к началу
sheva
проходил мимо
Сообщения: 4
Зарегистрирован: 2012-02-14 16:04:53

Re: (Proftpd + mod_sql) groupowner = wheel... why?

Непрочитанное сообщение sheva » 2012-02-19 11:24:09

Решение проблемы найдено, тему можно закрывать...

P.S. для тех кому интересно:
- groupowner копировался из текущей папки
- Решение: добавить в конфиг сервера

Код: Выделить всё

<Directory />
GroupOwner   ~
</Directory>
Вернуться к началу