PureFTD Problem AUTH (maybe mysql)

Hello,

I've installed ISPCONFIG 3.0.1.4 on Debian 5.0.3

When i create en user FTP on ispconfig, i cannot use it with FTP (local and remote)

The logfile :


MESSAGE :

Oct 7 14:58:26 stock pure-ftpd: ([email protected]) [INFO] New connection from localhost.localdomain
Oct 7 14:58:30 stock pure-ftpd: ([email protected]) [INFO] PAM_RHOST enabled. Getting the peer address
Oct 7 14:58:32 stock pure-ftpd: ([email protected]) [WARNING] Authentication failed for user [safsound]
Oct 7 14:58:36 stock pure-ftpd: ([email protected]) [INFO] Logout.

AUTH :

Oct 7 15:08:10 stock mysqld[26008]: refused connect from 127.0.0.1
Oct 7 15:08:11 stock mysqld[26008]: refused connect from 127.0.0.1
Oct 7 15:08:11 stock mysqld[26008]: refused connect from 127.0.0.1
Oct 7 15:08:11 stock mysqld[26008]: refused connect from 127.0.0.1
Oct 7 15:08:11 stock mysqld[26008]: refused connect from 127.0.0.1
Oct 7 15:08:11 stock mysqld[26008]: refused connect from 127.0.0.1


I test the ispconfig user and his pass found on /etc/pure-ftpd/conf/MySQLConfigFile and i work well with mysql prompt command

I see that the user was in the mysql "ftp_user" table with phpmyadmin

Any Idea ? Maybe problem with pam auth ?

Bye

Safsound

 

Already installed on my system :

# dpkg -l | grep -i pure-ftpd
ii pure-ftpd-common 1.0.21-11.4 Pure-FTPd FTP server (Common Files)
ii pure-ftpd-mysql 1.0.21-11.4 Pure-FTPd FTP server with MySQL user authentication

and start with :

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

 

After enable loggin : (the mysql error is just after typing the password)

Oct 8 13:35:48 stock mysqld[26008]: refused connect from 127.0.0.1
Oct 8 13:35:48 stock pure-ftpd: pam_unix_auth(pure-ftpd:auth): check pass; user unknown
Oct 8 13:35:48 stock pure-ftpd: pam_unix_auth(pure-ftpd:auth): authentication failure; logname= uid=0 euid=0 tty=pure-ftpd ruser=safsound rhost=localhost.localdomain


# mysql -uispconfig -p dbispconfig
Enter password:


mysql> SELECT uid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="safsound" ;
+------+
| uid |
+------+
| web4 |
+------+
1 row in set (0.00 sec)


mysql> select * from ftp_user;
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
| ftp_user_id | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | server_id | parent_domain_id | username | password | quota_size | active | uid | gid | dir | quota_files | ul_ratio | dl_ratio | ul_bandwidth | dl_bandwidth |
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
| 1 | 7 | 5 | riud | riud | | 1 | 4 | safsound | <the crypt password> | -1 | y | web4 | client3 | /var/www/clients/client3/web4 | -1 | -1 | -1 | -1 | -1 |
+-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+----------+------------------------------------+------------+--------+------+---------+-------------------------------+-------------+----------+----------+--------------+--------------+
1 row in set (0.00 sec)

 

# ls -la /var/www/clients/client3/web4
total 24
drwxr-xr-x 6 root root 4096 oct 5 12:31 .
drwxr-xr-x 5 root root 4096 oct 5 12:35 ..
drwxr-xr-x 2 web4 client3 4096 oct 5 12:31 cgi-bin
lrwxrwxrwx 1 web4 client3 42 oct 5 12:31 log -> /var/log/ispconfig/httpd/www.website.com
drwxr-xr-x 2 web4 client3 4096 oct 5 12:31 ssl
drwxrwxrwx 2 web4 client3 4096 oct 5 12:31 tmp
drwxr-xr-x 4 web4 client3 4096 oct 5 12:31 web

 

the warning : (Always before AUTH with pure-ftpd)

Oct 12 15:03:48 ks306078 mysqld[8704]: refused connect from 127.0.0.1



I doing all AUTH with mysql for user ispconfig (localhost and 127.0.0.1)

i dont see where is the problem !

 

ok i found the problem :

##############################################
# #
# Sample Pure-FTPd Mysql configuration file. #
# See README.MySQL for explanations. #
# #
##############################################


# Optional : MySQL server name or IP. Don't define this for unix sockets.

MYSQLServer 127.0.0.1


Must replace this line by :

MYSQLServer localhost