Pure FTP MySQL is different server.

Discussion in 'Server Operation' started by aberrio, Mar 29, 2012.

  1. aberrio

    aberrio New Member

    Hi,

    I am working on this Howto..

    Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Management) On Debian Lenny

    My caviat is that the mysql server is in another box. I changed the db/mysqld.conf to reflect the server bos as follow:

    #MYSQLSocket /var/run/mysqld/mysqld.sock
    MYSQLServer mysql.xcxcxcxcxc.net
    MYSQLPort 3306
    MYSQLUser pureftpd
    MYSQLPassword ftpdpass
    MYSQLDatabase pureftpd
    [...]

    but it is not working. it is not able to retrive the user's paswd.


    BTW I was able to connect as an Anonymous user, so the FTP server is working.

    Do I need to change something else in order to be able to use it with mysql?

    Warm regards,

    Al
     
  2. till

    till Super Moderator

    Are you able to connect to mysql from the ftp server with the "mysql" command? If not, then either mysql does not listen on the external network interface or it is blocked by a firewall or you did not allow external access for the pureftpd user.
     
  3. aberrio

    aberrio New Member

    My mysql box has external access. I do have 5 asterisk servers connecting to it. Any other suggestion.

    Regards,

    Al
     
  4. till

    till Super Moderator

    enable verbose logging in pure-ftpd to see the details why the authentication fails.
     
  5. aberrio

    aberrio New Member

    Hi,

    There is not much info. Ports 20, 21,22 are open in my firewall. The mysql box does not show a connection try. The pure-ftp server is not querying the mysql server. IFrom pure-ftp server I was able to manually login with mysql-client and test mysql commands.

    What porr does pure-ftp use to send querys?

    Mar 30 07:46:41 www kernel: [172128.356452] SFW2-INext-ACC-TCP IN=eth0 OUT= MAC=00:0d:87:70:5b:44:00:1f:ca:20:02:d9:08:00 SRC=216.XX.xx.xx DST=zz.zz.zz.zz LEN=48 TOS=0x00 PREC=0x00 TTL=111 ID=46988 DF PROTO=TCP SPT=32153 DPT=21 WINDOW=64512 RES=0x00 SYN URGP=0 OPT (0204056401010402)
    Mar 30 07:46:42 www pure-ftpd: (?@216.xx.xx.xx) [INFO] New connection from 216.xx.xx.xx
    Mar 30 07:46:52 www pure-ftpd: (?@216.xx.xx.xx) [INFO] PAM_RHOST enabled. Getting the peer address
    Mar 30 07:46:58 www pure-ftpd: (?@216.xx.xx.xx) [WARNING] Authentication failed for user [user alex]
    Mar 30 07:47:01 www pure-ftpd: (?@216.xx.xx.xx) [INFO] Logout.
    Mar 30 07:47:29 www kernel: [172176.374067] SFW2-INext-ACC-TCP IN=eth0 OUT= MAC=00:0d:87:70:5b:44:00:1f:ca:20:02:d9:08:00 SRC=216.xx.xx.xx DST=zz.zz.zz.zz LEN=48 TOS=0x00 PREC=0x00 TTL=111 ID=47036 DF PROTO=TCP SPT=29090 DPT=10000 WINDOW=64512 RES=0x00 SYN URGP=0 OPT (0204056401010402)
    Mar 30 07:47:39 www kernel: [172185.622533] SFW2-INext-ACC-TCP IN=eth0 OUT= MAC=00:0d:87:70:5b:44:00:1f:ca:20:02:d9:08:00 SRC=216.xx.xx.xx DST=zz.zz.zz.zz LEN=48 TOS=0x00 PREC=0x00 TTL=111 ID=47066 DF PROTO=TCP SPT=64092 DPT=10000 WINDOW=64512 RES=0x00 SYN URGP=0 OPT (0204056401010402)
     
    Last edited: Mar 31, 2012
  6. aberrio

    aberrio New Member

    Solved

    The pure-ftps-mysql was the problem. I reintalled and solved the issue.

    Regards,

    Al
     

Share This Page