Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 29th March 2012, 06:17
aberrio aberrio is offline
Senior Member
 
Join Date: Sep 2007
Posts: 150
Thanks: 13
Thanked 3 Times in 3 Posts
Default Pure FTP MySQL is different server.

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
Reply With Quote
Sponsored Links
  #2  
Old 29th March 2012, 08:30
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,446
Thanks: 813
Thanked 5,216 Times in 4,089 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 29th March 2012, 20:50
aberrio aberrio is offline
Senior Member
 
Join Date: Sep 2007
Posts: 150
Thanks: 13
Thanked 3 Times in 3 Posts
Default

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

Regards,

Al
Reply With Quote
  #4  
Old 30th March 2012, 08:44
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,446
Thanks: 813
Thanked 5,216 Times in 4,089 Posts
Default

enable verbose logging in pure-ftpd to see the details why the authentication fails.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 30th March 2012, 14:55
aberrio aberrio is offline
Senior Member
 
Join Date: Sep 2007
Posts: 150
Thanks: 13
Thanked 3 Times in 3 Posts
Default

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 by aberrio; 31st March 2012 at 03:15.
Reply With Quote
  #6  
Old 31st March 2012, 03:31
aberrio aberrio is offline
Senior Member
 
Join Date: Sep 2007
Posts: 150
Thanks: 13
Thanked 3 Times in 3 Posts
 
Exclamation Solved

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

Regards,

Al
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig 3.0.3.2 reporting FTP server offline. CSsab Installation/Configuration 2 14th January 2011 08:15
Debian 5 Ajax error + network interface always shutting down ev0css Installation/Configuration 3 5th June 2010 12:58
Webmail problems with only one domain? compner Installation/Configuration 14 16th February 2010 16:59
proFTPd passive mode problems bisbell Server Operation 8 6th August 2008 21:12
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 02:30


All times are GMT +2. The time now is 02:57.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.