Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

About the automatic start of Sympa #981

Closed
riku22 opened this issue Aug 17, 2020 · 9 comments
Closed

About the automatic start of Sympa #981

riku22 opened this issue Aug 17, 2020 · 9 comments

Comments

@riku22
Copy link

riku22 commented Aug 17, 2020

Hello.

I have installed Sympa 6.2.56 on Ubuntu 20.04.
After that, the following contents were described in "/etc/systemd/system/sympa.service.d/dependencies.conf" and saved.

[Unit]
Requires=mariadb.service
After=mariadb.service

I then enabled the service with "systemctl enable sympa", created one list, and restarted the server.
However, when I start the server, I receive the following email.

Subject: Status of test mailing list: incorrect settings

The test mailing list has no owner.
Made the list "misconfigured" (error_config).
Check the Sympa log file for more detailed information.

The following contents were output to the log file.

Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#407 > Sympa::List::sync_include#4768 > Sympa::List::has_included_users#6629 > Sympa::DatabaseManager::instance#54 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#157 Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhost;db_name=riku_sympa;db_user=riku>: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#408 > Sympa::List::sync_include#4768 > Sympa::List::has_included_users#6629 > Sympa::DatabaseManager::instance#54 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#157 Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhost;db_name=riku_sympa;db_user=riku>: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#410 > Sympa::List::get_admins#2944 > Sympa::List::get_current_admins#3011 > Sympa::DatabaseManager::instance#54 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#157 Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhost;db_name=riku_sympa;db_user=riku>: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#410 > Sympa::List::get_admins#2944 > Sympa::List::get_current_admins#3027 Unable to get admins for list Sympa::List <test@example.com>
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#413 The list "test" has got no owner defined
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#414 > Sympa::List::set_status_error_config#456 The list Sympa::List <test@example.com> is set in status error_config: no_owner_defined()
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#414 > Sympa::List::set_status_error_config#460 > Sympa::send_notify_to_listmaster#443 > Sympa::Spindle::new#42 > Sympa::Message::Template::new#170 > Sympa::List::get_admins#2944 > Sympa::List::get_current_admins#3011 > Sympa::DatabaseManager::instance#54 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#157 Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhost;db_name=riku_sympa;db_user=riku>: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#414 > Sympa::List::set_status_error_config#460 > Sympa::send_notify_to_listmaster#443 > Sympa::Spindle::new#42 > Sympa::Message::Template::new#170 > Sympa::List::get_admins#2944 > Sympa::List::get_current_admins#3027 Unable to get admins for list Sympa::List <test@example.com>
Aug 17 22:39:07 task_manager[902]: notice Sympa::Spindle::ProcessTemplate::_twist() Processing Sympa::Message::Template <test@example.com.1597671547.978,1925>; envelope_sender=test-owner@example.com; message_id=sympa.1597671547.978.733@example.com; recipients=ARRAY; sender=sympa@example.com; template=listmaster_notification; type=no_owner_defined
Aug 17 22:39:07 task_manager[902]: notice Sympa::Mailer::store() Done sending message Sympa::Message::Template <test@example.com.1597671547.978,1925> for Sympa::List <test@example.com> (priority 1) in 0 seconds since scheduled expedition date

The database uses MariaDB, and the service is already enabled.
Also, once it starts up, there seems to be no problem, and you can send and receive mailing lists normally.
Is there something wrong with the settings?
I would appreciate it if you could find a solution.

Best regards.

こんにちは。

Ubuntu20.04にSympa 6.2.56をインストールしました。
その後、「/etc/systemd/system/sympa.service.d/dependencies.conf」に下記の内容を記述して保存しました。

[Unit]
Requires=mariadb.service
After=mariadb.service

その後「systemctl enable sympa」でサービスを有効化して、リストを1つ作成した上で、サーバーを再起動しました。
しかし、サーバー起動時に下記の内容のメールが届いてしまいます。

Subject: test メーリングリストの状況: 設定に間違いあり

test メーリングリストはオーナーが決まっていません。
リストを「設定に間違いあり」 (error_config) にしました。
より詳細な情報については Sympa のログファイルをご確認ください。

ログファイルには下記の内容が出力されていました。

Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#407 > Sympa::List::sync_include#4768 > Sympa::List::has_included_users#6629 > Sympa::DatabaseManager::instance#54 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#157 Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhost;db_name=riku_sympa;db_user=riku>: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#408 > Sympa::List::sync_include#4768 > Sympa::List::has_included_users#6629 > Sympa::DatabaseManager::instance#54 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#157 Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhost;db_name=riku_sympa;db_user=riku>: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#410 > Sympa::List::get_admins#2944 > Sympa::List::get_current_admins#3011 > Sympa::DatabaseManager::instance#54 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#157 Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhost;db_name=riku_sympa;db_user=riku>: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#410 > Sympa::List::get_admins#2944 > Sympa::List::get_current_admins#3027 Unable to get admins for list Sympa::List <test@example.com>
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#413 The list "test" has got no owner defined
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#414 > Sympa::List::set_status_error_config#456 The list Sympa::List <test@example.com> is set in status error_config: no_owner_defined()
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#414 > Sympa::List::set_status_error_config#460 > Sympa::send_notify_to_listmaster#443 > Sympa::Spindle::new#42 > Sympa::Message::Template::new#170 > Sympa::List::get_admins#2944 > Sympa::List::get_current_admins#3011 > Sympa::DatabaseManager::instance#54 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#157 Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhost;db_name=riku_sympa;db_user=riku>: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 17 22:39:07 task_manager[902]: err main::#148 > Sympa::Spindle::spin#78 > Sympa::Spool::next#125 > Sympa::Spool::Task::_load#57 > Sympa::Spool::Task::_create_all_tasks#93 > Sympa::List::get_lists#5403 > Sympa::List::new#414 > Sympa::List::set_status_error_config#460 > Sympa::send_notify_to_listmaster#443 > Sympa::Spindle::new#42 > Sympa::Message::Template::new#170 > Sympa::List::get_admins#2944 > Sympa::List::get_current_admins#3027 Unable to get admins for list Sympa::List <test@example.com>
Aug 17 22:39:07 task_manager[902]: notice Sympa::Spindle::ProcessTemplate::_twist() Processing Sympa::Message::Template <test@example.com.1597671547.978,1925>; envelope_sender=test-owner@example.com; message_id=sympa.1597671547.978.733@example.com; recipients=ARRAY; sender=sympa@example.com; template=listmaster_notification; type=no_owner_defined
Aug 17 22:39:07 task_manager[902]: notice Sympa::Mailer::store() Done sending message Sympa::Message::Template <test@example.com.1597671547.978,1925> for Sympa::List <test@example.com> (priority 1) in 0 seconds since scheduled expedition date

なお、データベースはMariaDBを利用しており、すでにサービスは有効になっています。
また、1度起動した後は問題ないようで、正常にメーリングリストの送受信は実行可能です。
何か設定にミスがありますでしょうか。
解決法がわかれば、教えていただけますと幸いです。

敬具。
@ikedas
Copy link
Member

ikedas commented Aug 18, 2020 •
edited
Loading

Hi @riku22 ,

Subject: Status of test mailing list: incorrect settings

The test mailing list has no owner.
Made the list "misconfigured" (error_config).
Check the Sympa log file for more detailed information.

I think this is the only message that matters. A mailing list named test has no owners and it may not work.

Please check the setting of owner_include parameter of test mailing list.

@racke
Copy link
Contributor

racke commented Aug 18, 2020

This happens also if a list is created from XML on the commandline. In that case it would make sense to create the user in the database.

@riku22
Copy link
Author

riku22 commented Aug 18, 2020

Hello.
The owner has already been decided, and if I send a test email to "test-request@example.com" from an email address that is not the owner, the email will be delivered to the owner's email address normally.
However, when I checked again, it was displayed as "privileged owner" instead of "owner".
Is this a problem?
Best regards.

こんにちは。
オーナーはすでに決まっており、その証拠にオーナーではないメールアドレスから「test-request@example.com」にテストメールを送信すると、正常にオーナーのメールアドレスにメールが届きます。
ただ、もう1度確認してみたところ、「オーナー」ではなく、「特権オーナー」と表示されています。
これが問題なのでしょうか。
敬具。

@ikedas
Copy link
Member

ikedas commented Aug 18, 2020 

Can't connect to Database Sympa::DatabaseDriver::MySQL <db_host=localhost;db_name=riku_sympa;db_user=riku>: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Unable** to get admins for list Sympa::List <test@example.com>

Do these messages appear only immediately after startup? If they do, mariadb service may be slow to start. As a workaround, please make sure that the mariadb service is started and then start the sympa service.
上のメッセージが起動直後だけ出ているのなら、mariadbの起動が遅れているのだと思われるので、mediadbサービスが起動したことを確認してからsympaサービスを起動するようにしてみてはどうでしょうか。

@riku22
Copy link
Author

riku22 commented Aug 18, 2020

Hello.
Yes, to achieve that, I wrote the following content in "/etc/systemd/system/sympa.service.d/dependencies.conf", but it doesn't seem to work.

[Unit]
Requires=mariadb.service
After=mariadb.service

Is this still not enough?
Best regards.

こんにちは。
はい、それを実現するために、「/etc/systemd/system/sympa.service.d/dependencies.conf」に下記内容を記述しましたが、うまく動いていないようです。

[Unit]
Requires=mariadb.service
After=mariadb.service

これでもまだ不十分なのでしょうか。
敬具。

@racke
Copy link
Contributor

racke commented Aug 18, 2020

@riku22 can you post the complete settings for the Sympa service, e.g. the output from systemctl cat sympa.service.

@riku22
Copy link
Author

riku22 commented Aug 18, 2020 •
edited
Loading

@racke
Hello.

Here.

# /lib/systemd/system/sympa.service
[Unit]
Description=SYMPA mailing list manager
Wants=sympa-bulk.service sympa-archived.service sympa-bounced.service sympa-task_manager.service
Documentation=man:sympa_msg(8)

[Service]
User=sympa
Group=sympa

PermissionsStartOnly=true
ExecStartPre=-/bin/mkdir -p /run/sympa
ExecStartPre=-/bin/chown sympa:sympa /run/sympa

Type=forking
ExecStart=/usr/lib/sympa/bin/sympa_msg.pl
PIDFile=/run/sympa/sympa_msg.pid

Restart=always
RestartSec=15

PrivateTmp=true

[Install]
WantedBy=multi-user.target

# /etc/systemd/system/sympa.service.d/dependencies.conf
[Unit]
Requires=mariadb.service
After=mariadb.service

Best regards.

@racke
Copy link
Contributor

racke commented Aug 18, 2020

The sympa unit ensures that it starts after the mariadb service, but the same is not true for the other sympa services. Thus you need in addition to

Wants=sympa-bulk.service sympa-archived.service sympa-bounced.service sympa-task_manager.service

the following line

Before=sympa-bulk.service sympa-archived.service sympa-bounced.service sympa-task_manager.service

This should prevent the task manager errors.

@riku22
Copy link
Author

riku22 commented Aug 19, 2020

@racke
Hello.
When I added it as advised, it became the behavior I expected.
Thank you very much.
Best regards.

@racke racke closed this as completed Aug 20, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@racke @ikedas @riku22