Having trouble configuring this module...

php list is installed and working and i'm 99% sure I'm using the right db info (user, pass,prefix) but i keep getting the message "Password is set - no connection".

I have a feeling it might be down to the Database host... I've entered... "external-db.s#####.gridserver.com" which was the exact same as I entered when setting up phplist.

any ideas?

Comments

jackread’s picture

jackread commented
Component: User interface » Miscellaneous

I forgot to mention... I tried changing the DB host to values that were blatently wrong and it sent me to the website is offline page.

paulbeaney’s picture

paulbeaney
Primary language English
commented

Hi jackread,

Can you confirm - you can sync users ok, users have the Newsletters tab in their account pages, they can (un)subscribe at will with no problems?

Regards,

- Paul

jackread’s picture

jackread commented
Priority: Normal » Minor

there's no sync button there... but everything else actually seems to work with no problems.

paulbeaney’s picture

paulbeaney
Primary language English
commented

Hi,

I'm afraid I'm stumped here. I can't think how you could possibly have a working system but not have the sync link - the code that checks whether or not to show it would break the whole thing if there was a genuine problem. Can you try tonight's D6-DEV code and see if that changes anything. I know it's clutching at straws, but you never know...

Regards,

- Paul

johnmullin2003’s picture

johnmullin2003 commented
Priority: Minor » Normal

same error here...but seems the module doesn't work...

paulbeaney’s picture

paulbeaney
Primary language English
commented

Hi johnmullin2003,

If the module isn't working at all, then the connection to the PHPlist database is suspect. Please re-check everything:

1. Database host, database name, database user and password
2. That there s no firewall blocking access from your Drupal server to the PHPlist database server
3. That you have granted permissions for your database user from your Drupal server to the PHPlist database

The odds are that it is one of these things which is causing your problems.

Regards,

- Paul

johnmullin2003’s picture

johnmullin2003 commented

Hi Paul, thanks for you help.

I checked at least 10 times everything.

The fact is that my free hoster has not set a database password ( I've got only: db (localhost), db name and user )...

Could this be the problem?

Thanks
Regards
jM

paulbeaney’s picture

paulbeaney
Primary language English
commented
Status: Active » Closed (fixed)

Hi John,

Yes, that will be the problem - if the password is emtpy, the module doesn't even attempt to see if the database connection works and simply assumes that it has not yet been configured. You *really* don't want to be running a database without a password !

Regards,

- Paul