Download & Extend
PHPlist Integration Module » Issues

New install sources local host name instead of remote DB server

Posted by captain_blie on April 10, 2009 at 7:17am
Project:PHPlist Integration Module
Version:6.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

Hi,

I installed the phplist module today and it seems to be getting the wrong host name for the DB server.

My DB server is at host name ldmysqlX and my web servers are at ldphpXXX

After trying to configure the module I get the following error.

------------------------------
Site off-line

The mysqli error was: Access denied for user 'phplist'@'ldphp001' (using password: YES).
------------------------------

I checked the drupal variable table and it has the correct DB host name, so I think the code is sourcing the local system name somehow instead of the remote DB.

Any ideas?

Thanks,

Christian

Login or register to post comments

Comments

#1

Posted by paulbeaney on April 11, 2009 at 8:05am

Hi,

Please check your MySQL permissions. You have to explicitly allow your phplist'@'ldphp001 user access to the MySQL host, which needs particular attention if your PHPlist database is not on the same host as your Drupal server. The fact that you get the "Acces denied" message indicates that the module *is* attempting to access the right database.

This kind of problem is always down to something in the MySQL permissions.

Regards,

- Paul

#2

Posted by captain_blie on April 19, 2009 at 6:49am

Tried, as you said. I even went so far as to recreat the user and give it access to both drupal and phplist DBs, but I still get the same error.

Please also bear in mind that the DB is remote to the webserver, and the address the error message says its trying to connect to is that of the webserver and not the one I entered into the DB server field.

Thanks,

Christian

#3

Posted by paulbeaney on May 1, 2009 at 10:03am

Hi Christian,

The fact the the error message relates to the webserver is simply a by-product of Drupal's primitive handling of external databases. I still believe the problem is to do with MySQL access on port 3306 between your Drupal server and the PHPlist server.

If you wish me to take a look at your system, please contact me via email to discuss how we could arrange this.

Regards,

- Paul

#4

Posted by paulbeaney on October 29, 2009 at 10:09am
Status:active» closed (fixed)