Password is set - no connection... again

Hi stanley78,

When you say "again", do you mean that your installation has worked fully at some point? If so, the question to be asking is "what has changed since?" Have you updated the PHPlist module, has your provider maybe done some server upgrades... etc. ? What is your PHPlist database prefix ?

Regards,

- Paul

hi Paul!

"again" means this issue was already discussed here...

I've installed the module first time and got "no connection" message. phplist itself works fine from web interface and I'm sure all connection settings are set properly. I can connect to db via phpMyAdmin . I don't know how to detect what's wrong... prefixes remain default - 'phplist_', 'phplist_user_'.

by the way, as already reported here, 6.x release doesn't show its settings at administration page.

Sorry, I've taken you through all the hoops that I know of in getting this module working. Short of you giving me temporary access to your web and MySQL servers, I'm afraid I am out of suggestions.

As for the missing admin menu page, if you're referring to the D6 release rather than D6-DEV, then that is normal. The D6 release was an initial, highly flawed attempt which hasn't been updated for months, hence why the project page recommends only using the D6-DEV for now.

Regards,

- Paul

I found an issue when I installed, and was able to fix the problem. In my case I too was getting the "Password set - no connection". I found that it had to do with the issue that I installed phplist (not the module) without table prefixes. This installed fine, but created a table called "user". IF you install phplist with a table prefix, it creates not [prefix]_user as you might expect but [prefix]user_user. The drupal module looks for the table either [prefix]user_user or user_user. I went through and changed it to just user and everything works fine. There's about half a dozen places I needed to change it.

Hi mstedudel,

You need to watch out for these prefixes - I don't understand why, but PHPlist allows you to specify a separate prefix for the user table.

# if you want a prefix to all your tables, specify it here,
$table_prefix = "phplist_";

# if you want to use a different prefix to user tables, specify it here.
# read README.usertables for more information
$usertable_prefix = "phplist_user_";

In my module I have made it a requirement that :

the value for $usertable_prefix must be set the same as $table_prefix WITH AN ADDED "user_"

Could it be that be what caught you out?

Regards,

- Paul

Yeah I think so ... though I think the problem really lies with phplist, their database tables aren't consistent with and without the prefix.

e.g. you install it with prefixes it;s

[prefix]_user_user

if you install without prefix it's

user

I guess I should post it on their site ...

mS

sorry for late answer...

it seems I found the origin of the problem. as I spoke earlier there was no connection using credentials of user having all the permissions. well, I thought. because phplist was installed at the provider side by script, I downloaded configuration and looked about credentials used during installation and creating database schema. of course, there was auto-generated username and password and this user is the schema owner.
if I use these credentials (the ONLY!) I get the connection.

I would be very appreciate if someone explain me this behavior...

I think this is a great module, but just to throw my tuppance in to the debate I only worked out after a couple of hours of fiddling about that the user tables in phplist (the seperate app) should have been installed with a prefix of user: [prefix]_user_user. Now that I'm looking around this is becoming clearer. So my fault obviously, but I can't help wondering why "user_user" is hard coded into the module?

Hi mightyulysses,

Fair point about the prefixes, I guess. To be honest, it is like that because when I first started this module a couple of years ago, I was confused as everyone else about the PHPlist table prefixes and I just looked at the PHPlist defaults in config.inc.php and saw that I could use just one prefix in my module if I hard-coded "user_user".

I guess in the long run it would be better for these both to be configurable in the Drupal module, although this will require some fairly drastic changes as the fact of having a single prefix is kind of central to a lot of the code. Thanks for flagging it up though.

Regards,

- Paul

hey,

I am also receiving the "Password is set - no connection" message. I am able to subscribe/unsubscribe in the Newsletters tab in the account page, but I don't have the synchronize now because I guess $connection_ok is not set.

I am using the same database for both drupal and phplist (is this a bad thing?), but I have manually set the prefixes to be different for each.

I have checked the settings over and over again. Any suggestions...?

thanks,
Harold

Hi Harold,

I'd suspect confusion in the table prefixes on your PHPlist installation. I have just added the facility to have separate prefixes for the user tables in the latest D6-DEV module. You might want to give that a whirl as it might be just what you need.

Regards,

- Paul

Many thanks to all contributors for this very useful module.

I am always stuck with a 'no connection' message. I am using v6.x-1.x-dev published on march 20th.

I have changed the table prefixes and have tested all possible scenarios... but still not luck! I am always stuck with the 'no connection' message.

I am wondering if this wouldn't have anything to do with mysql permissions on the server side. My phplist db user has ALL PRIVILEGES possibly listed in phpmyadmin... And I have been able to process select queries on the phplist db using db_set_active in a custom script..

Could you guys provide a better way of troubleshooting this?

Many thanks
Vince

hello

despite of my own suggestion of using the special account I've got this message... again. I don't now what else I can do with that. Is there any opportunity to turn logging/tracing on to check the issue?

I am using Drupal 6.12 and PHPlists 2.10.10 both run great as stand alone apps. Using the phplist Integration Module
Version: 6.x-1.x-dev, I am having trouble configuring it. I have installed the module and it brings up the 'settings' page. When I place my database information (db name, user, password) in the form and submit I get the following:

The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.

If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.

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

[stand alone Drupal 6.12 and PHPlist 2.10.10 are still running fine after this error is thrown]

After fiddling around with disabling, uninstalling, reinstalling enabling and checking for typos, I did notice that my database password uses characters like "x()X/xx" no quotes. I see that Drupal encodes these characters in settings.php and that PHPlist does not in config.php. As per my example, password x()X/xx in Drupal settings.php would be x%28%29X%2Fxx , while in PHPlist config.php password is just x()X/xx . Could this be causing a problem? I found when I changed the Drupal password by editing the password in settings.php to remove the encoding (changed x%28%29X%2Fxx to x()X/xx ) and then submit the phplist Integration Module settings, I do not get redirected to the above error message - but get redirected to a drupal page that states the password returns YES. However then Drupal throws a site under maintenance screen as it no longer likes the password.

Could the password be creating problems for me? I will try some simple passwords and report back.

OK, regarding my post above #14

I created a new database user with a password that did not contain any "extended" ASCII characters such as /.() etc. ( I know this might not be the correct terminology) and used that user/password in the phplist Integration Module Version: 6.x-1.x-dev Settings. It seemed to fix my problem as the error page cited above in post #14 no longer occurs. My hosting service has password generators that create these highly cryptic password that will use the "extended" ASCII characters in the passwords. Just wanted to mention this in case anyone else has had similar issues.

I found that I needed to have my phplist tables in the same database as my drupal tables or I was getting errors but others have apparently not had that particular issue.

Right now I can get to my settings page for the phplist Integration Module Version: 6.x-1.x-dev, and also the List Access link is available, but I haven't finished setting up the module yet. I have the message "Password is set - connection not checked" on my settings page. Is this normal? Or does this indicate a problem? I will be checking my table prefixes now to make sure everything is set up right.

Can you provide a link to the "required "user_profile" module (referenced under "Attribute mapping"). When I search a lot of modules come up and I am not sure which one to use.

Hi druupydog,

With regards to your issues:

1. Passwords with special characters: this is a known problem mentioned in the Readme.txt, although a quick test of my local installation with version 1.12.2.21 of the D6-DEV module confirms that some special characters (e.g. semi-colon) no longer pose a problem.

2. Remote PHPlist server: you need to get your MySQL permisisons right in order to be able to connect from a server which isn't localhost. You can't just create a database user and connect from any host you like. Please refere to mysql.com and your host provider's documentation for details on what/how to do it.

3. "Connection not checked": means just that. All the necessary database information has been entered, but no verification is carried out, in order to avoid problems in certain scenarios. See #414206 for more details.

4. user_profile: the presence of this module is complately optional. It is the "Profile" module in "Core Modules".

Regards,

- Paul

Thanks Paul, I should have read the README.txt file thoroughly. I may get a tattoo that says RTFM so I remember next time that reading the support documentation is a real time saver.