Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I asked this question on here late last night about how I can get the latest PHP, MySQL, and phpmyadmin on my 32bit installation of CentOS 5.8.

I was able to get PHP and MySQL back up and running successfully. I was unable to get phpmyadmin3 working, but phpmyadmin2 is still running like a champ. That's another can of worms.

However, during the process, my pure-ftpd was removed. I reinstalled it after the new PHP and MySQL were installed by running:

yum install pure-ftpd 

chkconfig --levels 235 pure-ftpd on
/etc/init.d/pure-ftpd start

However, now I am getting authentication errors. My ispconfig3 database still exists and my ftp users are still in the proper db table for ispconfig3.

Status: Connection established, waiting for welcome message...
Response:   220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------
Response:   220-You are user number 1 of 50 allowed.
Response:   220-Local time is now 12:29. Server port: 21.
Response:   220-This is a private system - No anonymous login
Response:   220-IPv6 connections are also welcome on this server.
Response:   220 You will be disconnected after 15 minutes of inactivity.
Command:    USER test_ftp
Response:   331 User test_ftp OK. Password required
Command:    PASS ********
Response:   530 Login authentication failed
Error:  Critical error
Error:  Could not connect to server

Log file shows this message:

[ERROR] The SQL server seems to be down [Host '127.0.0.1' is not allowed to connect to this MySQL server]

To actually formulate a question, How can I fix this authentication issue?

share|improve this question
add comment

1 Answer 1

up vote 0 down vote accepted

To anyone who may encounter this same situation, I have found a solution. Not exactly sure WHY this simple small change would solve my problem. Don't 127.0.0.1 and localhost mean the same thing? If anyone could provide a better solution, allowing for both 127.0.0.1 AND localhost, that would be greatly appreciated. I'm just glad my ftp server works again.

Edit the pureftpd-mysql.conf file

vi /etc/pure-ftpd/pureftpd-mysql.conf

Changed this:

MYSQLServer     127.0.0.1

To this:

MYSQLServer     localhost
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.