Pure FTP MySQL is different server.

[aberrio]

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

[till]

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.

[aberrio]

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

Regards,

Al

[till]

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

[aberrio]

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)

[aberrio]

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

Regards,

Al