My production site isn't seeing my phplist database. I installed it locally on a test server and everything went fine. However, when I installed phplist on my production server, drupal can't find the phplist database.

I'm running drupal 5.5 on a dedicated hostgator server. I installed the phplist module, and checked to make sure the configuration was correct. Everything looked fine, so I tried to synchronize the users and I get this message:

"The MySQL error was: .

Currently, the username is listuser and the database server is localhost.

* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?"

It's a drupal message, looking like the install pages. I have the correct database name, username, and password. The host is correct, too. I don't know what's going on here. I installed it locally and worked just fine, so there may be something set up differently on my production server.

Any ideas?

Thanks,

Caleb

Comments

thecalebrogers’s picture

thecalebrogers commented

Um, nevermind. It turns out that there were some characters in my ultra-secure database password that drupal did not like. PHPList had no problems with these characters (I don't know which one in particular, but it contained ")" and "#").

So, I created a new user with a different password (a new mysql database user), and then changed those values in PHPList and the drupal phplist module. Now it all works just fine.

Thank you for your support!

I'm chaoscube, and I approve this message.

paulbeaney’s picture

paulbeaney commented
Status: Active » Closed (fixed)

Hi,

Glad you got it sorted. It's often something so simple it's difficult to spot! I'll close this issue now.

Regards,

- Paul

jessmagz’s picture

jessmagz commented

Sir:

I'm using Drupal 6 and once my site was live with PHPList working well. Now, I backed up my live site using CPanel and did not renew my hosting plan. Now I'm trying to get back to my site locally using a Windows PC with XAMPP. After all the needed configuration to get back my site locally, Drupal failed to start and gave an error message like:

The mysqli error was: Access denied for user 'jessmagz_plst1'@'localhost' (using password: YES).

This was the PHPList database and access settings I had before when I hosted my site. Now, using phpMyadmin, I loaded the PHPList database and added the right user and privileges, still the problem persists.

1) How can I just get back my Drupal site bypassing this PHPList error?
2) Do I need to install PHPList locally just to bring back my site?

Please help. Thanks.

Jess

paulbeaney’s picture

paulbeaney commented

Hi Jess,

Taking your questions in order:

1. Go into your System table in Drupal, search for the record where filename contains 'phplist', and set the 'status' field to 0 (zero). This will deactivate the module.

2. No, you don't need to install PHPlist locally. Sounds to me like you have granted permissions on your PHPlist database to alow your user jessmagz_plst1 to access it from the IP address of your local Drupal server (you need to add your local Drupal IP as a new 'host' on the PHPlist box).

Regards,

- Paul

jessmagz’s picture

jessmagz commented

Thanks! I followed your advice and now I got my site back. A big thanks!

Jess