Skip to Content.
Sympa Menu

en - [en@sympa] Synchronizing members with remote MySQL fails

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Gadi Vivier <address@concealed>
  • To: En <address@concealed>
  • Subject: [en@sympa] Synchronizing members with remote MySQL fails
  • Date: Fri, 31 Mar 2023 00:14:28 +0000

Hi All

I have a list (on Sympa 6.2.70) configured to get its members from a remote MySQL database, but Sympa is unable to connect to it

From the Sympa server I can connect okay to the remote database via the shell like so:

mysql --ssl -h REMOTE_HOST.COM -u REMOTE_USER -P 20553 -D REMOTE_DATABASE --password='REMOTE_PASSWORD'

So far, so good.

In the list's config file at:

/usr/local/var/lib/sympa/list_data/REMOTE_DOMAIN/MY_LIST/config

The following was written to the config file after I entered and saved the database connection parameters and query in the list's Administration web interface:

...
include_sql_query
db_options --ssl
db_passwd REMOTE_PASSWORD
db_user REMOTE_USER
db_type mysql
db_port 20553
db_name REMOTE_DATABASE
name MY_CONNECTION
sql_query select user_subscriber, comment_subscriber from REMOTE_TABLE where list='MY_LIST'
db_host REMOTE_HOST.COM
...

When I attempt to synchronize the members (using the Admin web interface), the connection to the remote database fails (access denied).

The syslog shows:

Mar 30 22:33:27 MY_HOST wwsympa[4098]: err main::#1557 > main::do_sync_include#16026 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::include::_twist#209 > Sympa::Request::Handler::include::_update_users#377 > Sympa::DataSource::open#113 > Sympa::DataSource::SQL::_open#47 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#157 Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=REMOTE_HOST;db_name=REMOTE_DATABASE;db_options=--ssl;db_port=20553;db_user=REMOTE_USER>: Access denied for user 'REMOTE_USER'@'MY_HOST' (using password: YES)

In that syslog entry, I don't see the db_passwd. Not sure if its meant to be there and if absence is the cause of the problem.

Any clues on getting the list to sync with the remote database would be really appreciated.

Thanks,
Gadi



Archive powered by MHonArc 2.6.19+.

Top of Page