PureFTD Problem AUTH (maybe mysql)

Discussion in 'Installation/Configuration' started by safsound, Oct 7, 2009.

  1. safsound

    safsound New Member

    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: (?@localhost.localdomain) [INFO] New connection from localhost.localdomain
    Oct 7 14:58:30 stock pure-ftpd: (?@localhost.localdomain) [INFO] PAM_RHOST enabled. Getting the peer address
    Oct 7 14:58:32 stock pure-ftpd: (?@localhost.localdomain) [WARNING] Authentication failed for user [safsound]
    Oct 7 14:58:36 stock pure-ftpd: (?@localhost.localdomain) [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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Looks as if you have a pureftpd without mysql running (as it tries pam which is not the case when you run the mysql version. Please uninstall pureftpd and reinstall just the pureftpd with mysql version.

    apt-get remove pure-ftpd
    apt-get install pure-ftpd-mysql
     
  3. safsound

    safsound New Member

    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
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

  5. safsound

    safsound New Member

    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)
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Please post the output of:

    ls -la /var/www/clients/client3/web4
     
  7. safsound

    safsound New Member

    # 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
     
  8. safsound

    safsound New Member

    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 !
     
  9. safsound

    safsound New Member

    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
     

Share This Page