Pure-ftpd not start, no error

[mixian]

Hi,
i have installed succesfully ispconfig 3.
I'm very happy.

I see that only ftp service is down and not start.
No error is given, no message in the log.

I have see the post at this link, but the result is the same.

But is valid this tutorial for ispconfig 3 post installation ?

This problem may depend from quota management ?

Depens

I'm on Ec2 Amazon virtual server.

Thanks in advance.

[damir]

Which perfect guide have you followed?

If it's Debian, than make sure you have in /etc/default/pure-ftpd-common

STANDALONE_OR_INETD=standalone
VIRTUALCHROOT=true

and uncommented line in /etc/inetd.conf

ftp    stream  tcp     nowait  root    /usr/sbin/tcpd /usr/sbin/pure-ftpd-wrapper

[mixian]

thanks,
i was sure of my configuration ...i set INETD in the conf file.

But your next advice..."uncommented line in /etc/inetd.conf"
...the line is COMMENTED!???!

[damir]

You should comment out the line. Remove the # in front of:

ftp    stream  tcp     nowait  root    /usr/sbin/tcpd /usr/sbin/pure-ftpd-wrapper

Than restart inetd:

/etc/init.d/openbsd-inetd restart

and pureftpd

/etc/init.d/pure-ftpd-mysql stop

/etc/init.d/pure-ftpd-mysql start

[theflame]

I have the same problem but in Ubuntu Server 10.04.
All work but I cannot access to my site through ftp connection.

In file /etc/inetd.conf there is no line with "ftp stream tcp ..."

But I tried it too ((( No result.

[damir]

How and when you connect what is the error message?

[theflame]

I suppose ftp is working because I can connect to ftp using name of server user. But all login wich create ISPConfig return error "530 Login authentication failed".

netstat -tap | grep ftp
return:
tcp 0 0 *:ftp *:* LISTEN 1655/pure-ftpd (SER
tcp6 0 0 [::]:ftp [::]:* LISTEN 1655/pure-ftpd (SER
tcp6 0 0 localhost:44100 localhost:ftp TIME_WAIT -

During server setup as Internet getaway I use:
sudo iptables -A FORWARD -i eth0 -o eth1 -s 192.168.0.0/24 -m conntrack --ctstate NEW -j ACCEPT
sudo iptables -A FORWARD -m conntrack --ctstate ESTABLISHED,RELATED -j ACCEPT
sudo iptables -A POSTROUTING -t nat -j MASQUERADE

Using this advice:
http://www.faqforge.com/linux/contro...-debian-linux/
I get:
Aug 11 15:12:58 server pure-ftpd: (?@192.168.0.128) [INFO] New connection from 192.168.0.128
Aug 11 15:13:01 server CRON[2526]: (root) CMD (/usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
Aug 11 15:13:04 server pure-ftpd: (?@192.168.0.128) [ERROR] The SQL server seems to be down [Access denied for user 'ispconfig'@'server.el-dom.net.ua' (using password: YES)]
Aug 11 15:13:04 server pure-ftpd: (?@192.168.0.128) [INFO] PAM_RHOST enabled. Getting the peer address
Aug 11 15:13:11 server pure-ftpd: (?@192.168.0.128) [WARNING] Authentication failed for user [eldom]
Aug 11 15:13:13 server pure-ftpd: (?@192.168.0.128) [INFO] Logout.
Aug 11 15:13:15 server pure-ftpd: (?@192.168.0.128) [INFO] New connection from 192.168.0.128
Aug 11 15:13:21 server postfix/anvil[2503]: statistics: max connection rate 1/60s for (smtp:188.231.191.148) at Aug 11 15:10:01
Aug 11 15:13:21 server postfix/anvil[2503]: statistics: max connection count 1 for (smtp:188.231.191.148) at Aug 11 15:10:01
Aug 11 15:13:21 server postfix/anvil[2503]: statistics: max cache size 1 at Aug 11 15:10:01
Aug 11 15:13:22 server pure-ftpd: (?@192.168.0.128) [ERROR] The SQL server seems to be down [Access denied for user 'ispconfig'@'server.el-dom.net.ua' (using password: YES)]
Aug 11 15:13:22 server pure-ftpd: (?@192.168.0.128) [INFO] PAM_RHOST enabled. Getting the peer address
Aug 11 15:13:29 server pure-ftpd: (?@192.168.0.128) [WARNING] Authentication failed for user [eldomftp]
Aug 11 15:13:32 server pure-ftpd: (?@192.168.0.128) [INFO] Logout.

What can I do?

[theflame]

How can I change 'ispconfig'@'server.el-dom.net.ua' to 'ispconfig'@'localhost'?
Where can I edit it?


P.S. Sorry for my poor linux )

[damir]

Via Phpmyadmin you can login as root and check out Mysql/users tables. Also check /etc/pure-ftpd/db/mysql.conf

[theflame]

OK. I opened phpmyadmin as root. In DB mysql in table users I was surprise. Fields "host", "user", "password" contain random symbols. Five records in this table look like md5 code. Is it correct? But in dbispconfig/ftp_user I found all users which I had created.

Where should I look for?

This is my /etc/pure-ftpd/db/mysql.conf

MYSQLServer 127.0.0.1
MYSQLUser ispconfig
MYSQLPassword *************
MYSQLDatabase dbispconfig
MYSQLCrypt crypt
MYSQLGetPW SELECT password FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="\L"
MYSQLGetUID SELECT uid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="\L"
MYSQLGetGID SELECT gid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="\L"
MYSQLGetDir SELECT dir FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="\L"
MySQLGetQTAFS SELECT quota_files FROM ftp_user WHERE active = 'y' AND server_id = '1' AND quota_files != '-1' AND username="\L"
MySQLGetQTASZ SELECT quota_size FROM ftp_user WHERE active = 'y' AND server_id = '1' AND quota_size != '-1' AND username="\L"
MySQLGetRatioUL SELECT ul_ratio FROM ftp_user WHERE active = 'y' AND server_id = '1' AND ul_ratio != '-1' AND username="\L"
MySQLGetRatioDL SELECT dl_ratio FROM ftp_user WHERE active = 'y' AND server_id = '1' AND dl_ratio != '-1' AND username="\L"
MySQLGetBandwidthUL SELECT ul_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '1' AND ul_bandwidth != '-1' AND username="\L"
MySQLGetBandwidthDL SELECT dl_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '1' AND dl_bandwidth != '-1' AND username="\L"
MySQLTransactions On

As I see all right. Or not?

Maybe should I change "MYSQLServer 127.0.0.1" on "MYSQLServer localhost"?