Страница 1 из 1
proftp
Добавлено: 2006-05-30 20:13:43
Dimrix
Решил поставить профтп+мускуль, но:
Код: Выделить всё
mod_sql_mysql.c: In function `cmd_checkauth':
mod_sql_mysql.c:1287: warning: implicit declaration of function `make_scrambled_password'
gmake[1]: *** [mod_sql_mysql.o] Error 1
gmake[1]: Leaving directory `/usr/ports/ftp/proftpd-mysql/work/proftpd-1.3.0rc3/modules'
gmake: *** [modules] Error 2
*** Error code 2
Что может быть?
Добавлено: 2006-05-30 21:01:38
Alex Keda
а выше что было?
MySQL стоит? какой?
Добавлено: 2006-05-30 21:13:46
Dimrix
Фря 6.0, мускул Server version 4.1.15 Мускуль работает(ведётся трафик по вашей статейке)
Добавлено: 2006-05-30 22:48:07
Alex Keda
Для начала обнови порты, сделай make clean в той директории где собираешь.
И если ошибка повториться, дай побольше строчек, с конца... штук 50 можно...
Добавлено: 2006-05-31 8:28:22
Dimrix
Код: Выделить всё
cc -DHAVE_CONFIG_H -DFREEBSD6_0 -DFREEBSD6 -I.. -I../include -I/usr/local/inclu de -O -pipe -Wall -c mod_sql_mysql.c
mod_sql_mysql.c:135:19: mysql.h: No such file or directory
mod_sql_mysql.c:162: error: syntax error before "MYSQL"
mod_sql_mysql.c: In function `_build_error':
mod_sql_mysql.c:301: warning: implicit declaration of function `mysql_errno'
mod_sql_mysql.c:301: error: structure has no member named `mysql'
mod_sql_mysql.c:303: warning: implicit declaration of function `mysql_error'
mod_sql_mysql.c:303: error: structure has no member named `mysql'
mod_sql_mysql.c: In function `_build_data':
mod_sql_mysql.c:314: error: `MYSQL' undeclared (first use in this function)
mod_sql_mysql.c:314: error: (Each undeclared identifier is reported only once
mod_sql_mysql.c:314: error: for each function it appears in.)
mod_sql_mysql.c:314: error: `mysql' undeclared (first use in this function)
mod_sql_mysql.c:315: error: `MYSQL_RES' undeclared (first use in this function)
mod_sql_mysql.c:315: error: `result' undeclared (first use in this function)
mod_sql_mysql.c:316: error: syntax error before "row"
mod_sql_mysql.c:325: error: structure has no member named `mysql'
mod_sql_mysql.c:331: warning: implicit declaration of function `mysql_store_resu lt'
mod_sql_mysql.c:337: warning: implicit declaration of function `mysql_num_rows'
mod_sql_mysql.c:338: warning: implicit declaration of function `mysql_num_fields '
mod_sql_mysql.c:343: error: `row' undeclared (first use in this function)
mod_sql_mysql.c:343: warning: implicit declaration of function `mysql_fetch_row'
mod_sql_mysql.c:353: warning: implicit declaration of function `mysql_free_resul t'
mod_sql_mysql.c: In function `cmd_open':
mod_sql_mysql.c:406: warning: implicit declaration of function `mysql_ping'
mod_sql_mysql.c:406: error: structure has no member named `mysql'
mod_sql_mysql.c:418: error: structure has no member named `mysql'
mod_sql_mysql.c:418: warning: implicit declaration of function `mysql_init'
mod_sql_mysql.c:420: error: structure has no member named `mysql'
mod_sql_mysql.c:431: warning: implicit declaration of function `mysql_options'
mod_sql_mysql.c:431: error: structure has no member named `mysql'
mod_sql_mysql.c:431: error: `MYSQL_READ_DEFAULT_GROUP' undeclared (first use in this function)
mod_sql_mysql.c:433: warning: implicit declaration of function `mysql_real_conne ct'
mod_sql_mysql.c:433: error: structure has no member named `mysql'
mod_sql_mysql.c:435: error: `CLIENT_INTERACTIVE' undeclared (first use in this f unction)
mod_sql_mysql.c: In function `cmd_close':
mod_sql_mysql.c:527: warning: implicit declaration of function `mysql_close'
mod_sql_mysql.c:527: error: structure has no member named `mysql'
mod_sql_mysql.c:528: error: structure has no member named `mysql'
mod_sql_mysql.c: In function `cmd_select':
mod_sql_mysql.c:801: warning: implicit declaration of function `mysql_real_query '
mod_sql_mysql.c:801: error: structure has no member named `mysql'
mod_sql_mysql.c: In function `cmd_insert':
mod_sql_mysql.c:914: error: structure has no member named `mysql'
mod_sql_mysql.c: In function `cmd_update':
mod_sql_mysql.c:1012: error: structure has no member named `mysql'
mod_sql_mysql.c: In function `cmd_query':
mod_sql_mysql.c:1127: error: structure has no member named `mysql'
mod_sql_mysql.c:1142: warning: implicit declaration of function `mysql_field_cou nt'
mod_sql_mysql.c:1142: error: structure has no member named `mysql'
mod_sql_mysql.c: In function `cmd_escapestring':
mod_sql_mysql.c:1221: warning: implicit declaration of function `mysql_escape_st ring'
mod_sql_mysql.c: In function `cmd_checkauth':
mod_sql_mysql.c:1287: warning: implicit declaration of function `make_scrambled_ password'
gmake[1]: *** [mod_sql_mysql.o] Error 1
gmake[1]: Leaving directory `/usr/ports/ftp/proftpd-mysql/work/proftpd-1.3.0rc3/ modules'
gmake: *** [modules] Error 2
*** Error code 2
Добавлено: 2006-05-31 8:53:47
Alex Keda
Dimrix писал(а):Код: Выделить всё
cc -DHAVE_CONFIG_H -DFREEBSD6_0 -DFREEBSD6 -I.. -I../include -I/usr/local/inclu de -O -pipe -Wall -c mod_sql_mysql.c
mod_sql_mysql.c:135:19: mysql.h: No such file or directory
mod_sql_mysql.c:162: error: syntax error before "MYSQL"
во. ты уверен что MySQL клиент стоит?
Добавлено: 2006-05-31 12:51:04
Dimrix
Код: Выделить всё
May 31 12:07:53 mod_sql/4.2.1[35501]: homedir field : `homedir`
May 31 12:07:53 mod_sql/4.2.1[35501]: shell field : `shell`
May 31 12:07:53 mod_sql/4.2.1[35501]: homedirondemand : false
May 31 12:07:53 mod_sql/4.2.1[35501]: SQLMinUserUID : 999
May 31 12:07:53 mod_sql/4.2.1[35501]: SQLMinUserGID : 999
May 31 12:07:53 mod_sql/4.2.1[35501]: <<< sql_sess_init
May 31 12:08:03 mod_sql/4.2.1[35501]: >>> sql_pre_pass
May 31 12:08:03 mod_sql/4.2.1[35501]: <<< sql_pre_pass
May 31 12:08:03 mod_sql/4.2.1[35501]: >>> cmd_getpwnam
May 31 12:08:03 mod_sql/4.2.1[35501]: entering mysql cmd_escapestring
May 31 12:08:03 mod_sql/4.2.1[35501]: exiting mysql cmd_escapestring
May 31 12:08:03 mod_sql/4.2.1[35501]: cache miss for user 'dimrix'
May 31 12:08:03 mod_sql/4.2.1[35501]: : entering mysql cmd_select
May 31 12:08:03 mod_sql/4.2.1[35501]: entering mysql cmd_open
May 31 12:08:03 mod_sql/4.2.1[35501]: connection 'default' count is now 2
May 31 12:08:03 mod_sql/4.2.1[35501]: exiting mysql cmd_open
May 31 12:08:03 mod_sql/4.2.1[35501]: query "SELECT `username`, `password`, `uid`, `gid`, `homedir`, `shell` FROM `users_table` WHERE (`username`='dimrix') LI
May 31 12:08:03 mod_sql/4.2.1[35501]: entering mysql cmd_close
May 31 12:08:03 mod_sql/4.2.1[35501]: connection 'default' count is now 1
May 31 12:08:03 mod_sql/4.2.1[35501]: exiting mysql cmd_close
May 31 12:08:03 mod_sql/4.2.1[35501]: exiting mysql cmd_select
May 31 12:08:03 mod_sql/4.2.1[35501]: cache miss for user 'dimrix'
May 31 12:08:03 mod_sql/4.2.1[35501]: user 'dimrix' cached
May 31 12:08:03 mod_sql/4.2.1[35501]: + pwd.pw_name : dimrix
May 31 12:08:03 mod_sql/4.2.1[35501]: + pwd.pw_uid : 1001
May 31 12:08:03 mod_sql/4.2.1[35501]: + pwd.pw_gid : 1001
May 31 12:08:03 mod_sql/4.2.1[35501]: + pwd.pw_dir : /usr/home/Dimrix
May 31 12:08:03 mod_sql/4.2.1[35501]: + pwd.pw_shell : /sbin/nologin
May 31 12:08:03 mod_sql/4.2.1[35501]: <<< cmd_getpwnam
May 31 12:08:03 mod_sql/4.2.1[35501]: >>> cmd_auth
May 31 12:08:03 mod_sql/4.2.1[35501]: entering mysql cmd_escapestring
May 31 12:08:03 mod_sql/4.2.1[35501]: exiting mysql cmd_escapestring
May 31 12:08:03 mod_sql/4.2.1[35501]: cache hit for user 'dimrix'
May 31 12:08:03 mod_sql/4.2.1[35501]: >>> cmd_check
May 31 12:08:03 mod_sql/4.2.1[35501]: checking auth_type Plaintext
May 31 12:08:03 mod_sql/4.2.1[35501]: 'Plaintext' auth handler reports success
May 31 12:08:03 mod_sql/4.2.1[35501]: cache hit for user 'dimrix'
May 31 12:08:03 mod_sql/4.2.1[35501]: <<< cmd_check
May 31 12:08:03 mod_sql/4.2.1[35501]: <<< cmd_auth
May 31 12:08:03 mod_sql/4.2.1[35501]: >>> cmd_getpwnam
May 31 12:08:03 mod_sql/4.2.1[35501]: cache hit for user 'dimrix'
May 31 12:08:03 mod_sql/4.2.1[35501]: <<< cmd_getpwnam
May 31 12:08:03 mod_sql/4.2.1[35501]: >>> cmd_getpwnam
May 31 12:08:03 mod_sql/4.2.1[35501]: cache hit for user 'dimrix'
May 31 12:08:03 mod_sql/4.2.1[35501]: <<< cmd_getpwnam
May 31 12:08:03 mod_sql/4.2.1[35501]: >>> cmd_getpwnam
May 31 12:08:03 mod_sql/4.2.1[35501]: cache hit for user 'dimrix'
May 31 12:08:03 mod_sql/4.2.1[35501]: <<< cmd_getpwnam
May 31 12:08:03 mod_sql/4.2.1[35501]: entering mysql cmd_exit
May 31 12:08:03 mod_sql/4.2.1[35501]: entering mysql cmd_close
May 31 12:08:03 mod_sql/4.2.1[35501]: connection 'default' closed
May 31 12:08:03 mod_sql/4.2.1[35501]: connection 'default' count is now 0
May 31 12:08:03 mod_sql/4.2.1[35501]: exiting mysql cmd_close
May 31 12:08:03 mod_sql/4.2.1[35501]: exiting mysql cmd_exit
Работает только для анонима
Добавлено: 2006-05-31 13:01:12
Alex Keda
а в auth.log что?
Добавлено: 2006-05-31 13:33:09
Dimrix
Код: Выделить всё
May 31 12:04:28 dimrix proftpd[35497]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - USER dimrix: Login successful.
May 31 12:04:28 dimrix proftpd[35497]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - notice: unable to use '~/' [resolved to '/usr/home/Dimrix/']: No
May 31 12:04:28 dimrix proftpd[35497]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - Preparing to chroot to directory '~/'
May 31 12:04:28 dimrix proftpd[35497]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - dimrix chroot("~/"): No such file or directory
May 31 12:04:28 dimrix proftpd[35497]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - error: unable to set default root directory
May 31 12:04:28 dimrix proftpd[35497]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - FTP session closed.
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - USER dimrix: Login successful.
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - notice: unable to use '~/' [resolved to '/usr/home/Dimrix/']: No
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - Preparing to chroot to directory '~/'
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - dimrix chroot("~/"): No such file or directory
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - error: unable to set default root directory
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - FTP session closed.
Добавлено: 2006-05-31 13:38:03
Alex Keda
Dimrix писал(а):Код: Выделить всё
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - USER dimrix: Login successful.
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - notice: unable to use '~/' [resolved to '/usr/home/Dimrix/']: No
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - Preparing to chroot to directory '~/'
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - dimrix chroot("~/"): No such file or directory
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - error: unable to set default root directory
May 31 12:08:03 dimrix proftpd[35501]: host1.dimrix.sumy.ua (sotik.sumy.ua[194.153.149.32]) - FTP session closed.
ну так создай хомяк-то.... или явно укажи а не тильдой.
Добавлено: 2006-05-31 16:08:26
Dima666
в FreeBSD новечёк.
rc.conf:
defaultrouter="10.7.105.1"
gateway_enable="YES"
ifconfig_rl0="inet 10.7.105.245 netmask 255.255.0.0"
keymap="ru.koi8-r"
linux_enable="YES"
usbd_enable="YES"
sshd_enable="YES"
firewall_enable="YES"
firewall_type="/etc/rc.firewall"
firewall_logging="YES"
apache_enable="YES"
mysql_enable="YES"
proftpd_enable="YES"
sendmail_enable="NONE"
tcp_extensions="NO"
tcp_drop_synfin="YES"
tcp_restrict_rst="YES"
всё вроде заводитсо при загрузке
а не получаетсо зайти на фтп-ник
вот что в логе:
May 31 16:56:06 mod_sql/4.2.1[606]: defaulting to 'mysql' backend
May 31 16:56:06 mod_sql/4.2.1[606]: backend module 'mod_sql_mysql/4.05'
May 31 16:56:06 mod_sql/4.2.1[606]: backend api 'mod_sql_api_v2'
May 31 16:56:06 mod_sql/4.2.1[606]: >>> sql_sess_init
May 31 16:56:06 mod_sql/4.2.1[606]: entering mysql cmd_defineconnection
May 31 16:56:06 mod_sql/4.2.1[606]: name: 'default'
May 31 16:56:06 mod_sql/4.2.1[606]: user: 'ftp'
May 31 16:56:06 mod_sql/4.2.1[606]: host: 'localhost'
May 31 16:56:06 mod_sql/4.2.1[606]: db: 'ftp'
May 31 16:56:06 mod_sql/4.2.1[606]: port: '3306'
May 31 16:56:06 mod_sql/4.2.1[606]: ttl: '0'
May 31 16:56:06 mod_sql/4.2.1[606]: exiting mysql cmd_defineconnection
May 31 16:56:06 mod_sql/4.2.1[606]: entering mysql cmd_open
May 31 16:56:06 mod_sql/4.2.1[606]: exiting mysql cmd_open
May 31 16:56:06 mod_sql/4.2.1[606]: unrecoverable backend error
May 31 16:56:06 mod_sql/4.2.1[606]: error: '1045'
May 31 16:56:06 mod_sql/4.2.1[606]: message: 'Access denied for user 'ftp'@'localhost' (using password: YES)'
Добавлено: 2006-05-31 16:23:52
Alex Keda
что в /var/log/auth.log ?
mysql-то запущен хоть?
Добавлено: 2006-05-31 17:11:12
Dima666
мускул запущен, базы создаютсо
есть у меня подозрения что я гдето в пользователях и правах путаюсь....
отсутсует опыт:(
Код: Выделить всё
web#top
485 mysql 5 20 0 57296K 26252K kserel 0:07 0.00% mysqld
438 root 1 96 0 17288K 11896K select 0:01 0.00% httpd
544 root 1 96 0 6080K 3112K select 0:00 0.00% sshd
548 root 1 5 0 5120K 2780K ttyin 0:00 0.00% csh
817 root 1 96 0 6080K 3088K select 0:00 0.00% sshd
392 root 1 96 0 4568K 3676K select 0:00 0.00% proftpd
821 root 1 20 0 4988K 2876K pause 0:00 0.00% csh
315 root 1 96 0 1300K 948K select 0:00 0.00% syslogd
493 root 1 8 0 1312K 1044K nanslp 0:00 0.00% cron
547 root 1 8 0 1592K 1268K wait 0:00 0.00% login
824 root 1 96 0 2264K 1528K RUN 0:00 0.00% top
820 root 1 8 0 1592K 1268K wait 0:00 0.00% login
449 mysql 1 8 0 1652K 1276K wait 0:00 0.00% sh
432 root 1 96 0 1212K 780K select 0:00 0.00% usbd
539 root 1 5 0 1268K 904K ttyin 0:00 0.00% getty
486 root 1 96 0 3356K 2540K select 0:00 0.00% sshd
535 root 1 5 0 1268K 904K ttyin 0:00 0.00% getty
537 root 1 5 0 1268K 904K ttyin 0:00 0.00% getty
542 root 1 5 0 1268K 904K ttyin 0:00 0.00% getty
541 root 1 5 0 1268K 904K ttyin 0:00 0.00% getty
538 root 1 5 0 1268K 904K ttyin 0:00 0.00% getty
536 root 1 5 0 1268K 904K ttyin 0:00 0.00% getty
540 root 1 5 0 1268K 904K ttyin 0:00 0.00% getty
459 www 1 4 0 17324K 11920K accept 0:00 0.00% httpd
460 www 1 4 0 17324K 11920K accept 0:00 0.00% httpd
462 www 1 4 0 17324K 11920K accept 0:00 0.00% httpd
Код: Выделить всё
web# less auth.log
May 31 16:52:33 web shutdown: reboot by root:
May 31 16:53:47 web sshd[486]: Server listening on :: port 22.
May 31 16:53:47 web sshd[486]: Server listening on 0.0.0.0 port 22.
May 31 16:54:27 web sshd[544]: Accepted keyboard-interactive/pam for root from 10.7.104.45 port 2150 ssh2
May 31 16:54:27 web login: login from www.xxx.ru on ttyp0 as root
May 31 18:06:45 web sshd[817]: Accepted keyboard-interactive/pam for root from 10.7.115.11 port 2763 ssh2
May 31 18:06:45 web login: login from q12.xxx.ru on ttyp1 as root
Добавлено: 2006-05-31 18:03:26
Dimrix
А как дать фул доступ на хом?
Добавлено: 2006-05-31 20:03:26
Alex Keda
жто не логи... это название одно.
Добавлено: 2006-05-31 21:29:17
Dimrix
А как насчёт доступа в хоме? как его открыть юзверю?
Добавлено: 2006-06-01 7:55:43
Alex Keda
Dimrix писал(а):А как насчёт доступа в хоме? как его открыть юзверю?
man chmod
Добавлено: 2006-06-01 7:59:14
Dima666
ага.....
я тоже думаю что гдето прав недодал....
щас буду читать и пробывать
пасиб
Добавлено: 2006-06-02 13:39:04
Dromok
Что-то я не могу понять как раздать права на чтение-запись. Вот к примеру в папке ftp есть папки pub и upload. Как разрешить анонимусам заходить только для чтения в pub, а созданым юзерам можно заходить и в upload но только для чтения, отдельному юзеру разрешить запись в upload?
Добавлено: 2006-06-02 13:44:12
Alex Keda
man chmod читал?
А вообще на уровне конфига сделай - там тоже возможностей масса...
Добавлено: 2006-06-02 13:46:39
Dromok
lissyara писал(а):
А вообще на уровне конфига сделай - там тоже возможностей масса...
Я как раз про конфиг и спрашивал.
Добавлено: 2006-06-04 9:00:20
Dimrix
lissyara писал(а):man chmod читал?
А вообще на уровне конфига сделай - там тоже возможностей масса...
А описалово конфига где можно найти(остальные функции что у тебя не описаны?) Пусть даже ин инглиш
Добавлено: 2006-06-04 10:18:16
Alex Keda
на сайте программы, но там некоторые веши описаны меньше чем у меня...
proftpd не до конца документирован....