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
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.
My mysql box has external access. I do have 5 asterisk servers connecting to it. Any other suggestion. Regards, Al
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: ([email protected]) [INFO] New connection from 216.xx.xx.xx Mar 30 07:46:52 www pure-ftpd: ([email protected]) [INFO] PAM_RHOST enabled. Getting the peer address Mar 30 07:46:58 www pure-ftpd: ([email protected]) [WARNING] Authentication failed for user [user alex] Mar 30 07:47:01 www pure-ftpd: ([email protected]) [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)
