The mailing list for listmasters using Sympa

[THOMAS Jean <address@concealed>]

And I can see some other errors :

Sep 20 08:00:53 tcgesympa2 task_manager[38145]: err main::#148 > Sympa::Spindle::spin#83 > Sympa::Spindle::ProcessTask::_twist#74 > Sympa::Spindle::ProcessTask::_execute#140 > Sympa::Spindle::ProcessTask::_cmd_process#174 > Sympa::Spindle::ProcessTask::do_sync_include#1349 > Sympa::List::sync_include#4827 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::include::_twist#182 > Sympa::Request::Handler::include::_update_users#295 > Sympa::Request::Handler::include::__update_user#403 > Sympa::Database::do_prepared_query#382 Unable to execute SQL statement "UPDATE subscriber_table SET inclusion_subscriber = ?, inclusion_label_subscriber = ? WHERE user_subscriber = ? AND list_subscriber = ? AND robot_subscriber = ?": (22001) Data too long for column 'inclusion_label_subscriber' at row 1

Sep 20 08:00:53 tcgesympa2 task_manager[38145]: err main::#148 > Sympa::Spindle::spin#83 > Sympa::Spindle::ProcessTask::_twist#74 > Sympa::Spindle::ProcessTask::_execute#140 > Sympa::Spindle::ProcessTask::_cmd_process#174 > Sympa::Spindle::ProcessTask::do_sync_include#1349 > Sympa::List::sync_include#4827 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::include::_twist#182 > Sympa::Request::Handler::include::_update_users#290 > Sympa::DataSource::open#130 > Sympa::DataSource::RemoteFile::_open#100 Unable to fetch data source Sympa::DataSource::RemoteFile <address@concealed;id=9a9e4513;role=member;name=CSSI et Adjoints>: only SSL_ca_path or SSL_ca_file should be given

Sep 20 08:00:53 tcgesympa2 task_manager[38145]: err main::#148 > Sympa::Spindle::spin#83 > Sympa::Spindle::ProcessTask::_twist#74 > Sympa::Spindle::ProcessTask::_execute#140 > Sympa::Spindle::ProcessTask::_cmd_process#174 > Sympa::Spindle::ProcessTask::do_sync_include#1349 > Sympa::List::sync_include#4827 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::include::_twist#182 > Sympa::Request::Handler::include::_update_users#290 > Sympa::DataSource::open#130 > Sympa::DataSource::RemoteFile::_open#100 Unable to fetch data source Sympa::DataSource::RemoteFile <address@concealed;id=dd6af4b4;role=member;name=CRSSI>: only SSL_ca_path or SSL_ca_file should be given

Sep 20 08:00:53 tcgesympa2 task_manager[38145]: err main::#148 > Sympa::Spindle::spin#83 > Sympa::Spindle::ProcessTask::_twist#74 > Sympa::Spindle::ProcessTask::_execute#140 > Sympa::Spindle::ProcessTask::_cmd_process#174 > Sympa::Spindle::ProcessTask::do_sync_include#1349 > Sympa::List::sync_include#4827 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::include::_twist#182 > Sympa::Request::Handler::include::_update_users#290 > Sympa::DataSource::open#130 > Sympa::DataSource::RemoteFile::_open#100 Unable to fetch data source Sympa::DataSource::RemoteFile <address@concealed;id=ecad19d2;role=member;name=RSSI et Adjoints>: only SSL_ca_path or SSL_ca_file should be given

 

Jean

De : DSI Gestionnaire de Listes
Envoyé : vendredi 20 septembre 2019 08:13
À : 'IKEDA Soji' <address@concealed>
Cc : address@concealed; DSI Gestionnaire de Listes <address@concealed>
Objet : RE: [sympa-users] HTTPS Datasource synchronisation after upgrade in 6.2.45b2

 

Hello Ikeda,

 

It's seems to work fine now.

 

I have some other errors " Data too long for column 'inclusion_label_subscriber'" :

Sep 20 08:04:12 tcgesympa2 task_manager[38145]: err main::#148 > Sympa::Spindle::spin#83 > Sympa::Spindle::ProcessTask::_twist#74 > Sympa::Spindle::ProcessTask::_execute#140 > Sympa::Spindle::ProcessTask::_cmd_process#174 > Sympa::Spindle::ProcessTask::do_sync_include#1349 > Sympa::List::sync_include#4827 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::include::_twist#182 > Sympa::Request::Handler::include::_update_users#295 > Sympa::Request::Handler::include::__update_user#403 > Sympa::Database::do_prepared_query#382 Unable to execute SQL statement "UPDATE subscriber_table SET inclusion_subscriber = ?, inclusion_label_subscriber = ? WHERE user_subscriber = ? AND list_subscriber = ? AND robot_subscriber = ?": (22001) Data too long for column 'inclusion_label_subscriber' at row 1

Sep 20 08:04:12 tcgesympa2 task_manager[38145]: err main::#148 > Sympa::Spindle::spin#83 > Sympa::Spindle::ProcessTask::_twist#74 > Sympa::Spindle::ProcessTask::_execute#140 > Sympa::Spindle::ProcessTask::_cmd_process#174 > Sympa::Spindle::ProcessTask::do_sync_include#1349 > Sympa::List::sync_include#4827 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::include::_twist#182 > Sympa::Request::Handler::include::_update_users#295 > Sympa::Request::Handler::include::__update_user#403 > Sympa::Database::do_prepared_query#382 Unable to execute SQL statement "UPDATE subscriber_table SET inclusion_subscriber = ?, inclusion_label_subscriber = ? WHERE user_subscriber = ? AND list_subscriber = ? AND robot_subscriber = ?": (22001) Data too long for column 'inclusion_label_subscriber' at row 1

Sep 20 08:06:46 tcgesympa2 task_manager[38145]: err main::#148 > Sympa::Spindle::spin#83 > Sympa::Spindle::ProcessTask::_twist#74 > Sympa::Spindle::ProcessTask::_execute#140 > Sympa::Spindle::ProcessTask::_cmd_process#174 > Sympa::Spindle::ProcessTask::do_sync_include#1349 > Sympa::List::sync_include#4827 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::include::_twist#182 > Sympa::Request::Handler::include::_update_users#295 > Sympa::Request::Handler::include::__update_user#403 > Sympa::Database::do_prepared_query#382 Unable to execute SQL statement "UPDATE subscriber_table SET inclusion_subscriber = ?, inclusion_label_subscriber = ? WHERE user_subscriber = ? AND list_subscriber = ? AND robot_subscriber = ?": (22001) Data too long for column 'inclusion_label_subscriber' at row 1

Sep 20 08:06:46 tcgesympa2 task_manager[38145]: err main::#148 > Sympa::Spindle::spin#83 > Sympa::Spindle::ProcessTask::_twist#74 > Sympa::Spindle::ProcessTask::_execute#140 > Sympa::Spindle::ProcessTask::_cmd_process#174 > Sympa::Spindle::ProcessTask::do_sync_include#1349 > Sympa::List::sync_include#4827 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::include::_twist#182 > Sympa::Request::Handler::include::_update_users#295 > Sympa::Request::Handler::include::__update_user#403 > Sympa::Database::do_prepared_query#382 Unable to execute SQL statement "UPDATE subscriber_table SET inclusion_subscriber = ?, inclusion_label_subscriber = ? WHERE user_subscriber = ? AND list_subscriber = ? AND robot_subscriber = ?": (22001) Data too long for column 'inclusion_label_subscriber' at row 1

 

 

 

Regards,

Jean

 

-----Message d'origine-----
De : IKEDA Soji <address@concealed>
Envoyé : vendredi 20 septembre 2019 04:24
À : DSI Gestionnaire de Listes <address@concealed>
Cc : address@concealed
Objet : Re: [sympa-users] HTTPS Datasource synchronisation after upgrade in 6.2.45b2

 

Hi Jean,

 

Could you please check this patch?

 

diff --git a/src/lib/Sympa/DataSource/RemoteFile.pm b/src/lib/Sympa/DataSource/RemoteFile.pm

index 59a505d..f97cce0 100644

--- a/src/lib/Sympa/DataSource/RemoteFile.pm

+++ b/src/lib/Sympa/DataSource/RemoteFile.pm

@@ -79,8 +79,8 @@ sub _open {

             if $key_passwd;

         $ua->ssl_opts(

             SSL_verify_mode => (

-                {none => 0, optional => 1, required => 3}->$self->{ca_verify}

-                    || 0

+                {none => 0, optional => 1, required => 3}

+                ->{$self->{ca_verify}} || 0

             )

         ) if defined $self->{ca_verify};

         $ua->ssl_opts(SSL_ca_file => $ca_file) if $ca_file;

 

Regards,

 

-- Soji

 

On Thu, 19 Sep 2019 11:55:59 +0000

DSI Gestionnaire de Listes <address@concealed> wrote:

 

> Hello,

>

> I'm working on a server in 6.2.45b2 (upgrade from 6.2.22).

> I have some issue while synchronizing https datasource since the upgrade, taskmanager or wwsymp died while synchronizing :

>

> Aug 30 08:30:49 tcgesympa2 task_manager[58733]: err main::#148 > Sympa::Spindle::spin#83 > Sympa::Spindle::ProcessTask::_twist#74 > Sympa::Spindle::ProcessTask::_execute#140 > Sympa::Spindle::ProcessTask::_cmd_process#174 > Sympa::Spindle::ProcessTask::do_sync_include#1349 > Sympa::List::sync_include#4827 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::include::_twist#182 > Sympa::Request::Handler::include::_update_users#290 > Sympa::DataSource::open#130 > Sympa::DataSource::RemoteFile::_open#80 DIED: Can't call method "Sympa::DataSource::RemoteFile=HASH(0xd74c1d8)" on unblessed reference at /usr/share/sympa/lib/Sympa/DataSource/RemoteFile.pm line 80.

>

> Synchronisation works fine for local datafile or http remote file or ldap datasource.

>

> I have the same error while synchronizing an https list manually :

> #sympa.pl --address@concealed

> Can't call method "Sympa::DataSource::RemoteFile=HASH(0x3f76a80)" on unblessed reference at /usr/share/sympa/lib/Sympa/DataSource/RemoteFile.pm line 80.

>

> Have you encountered the same error ?

>

> Cordialement,

> Jean THOMAS

> Listmaster

> CNRS / DSI

> address@concealed

>

 

 

--

株式会社 コンバージョン

ITソリューション部 システムソリューション1グループ 池田荘児

〒140-0014 東京都品川区大井1-49-15 アクセス大井町ビル4F

e-mail address@concealed  TEL 03-6429-2880 https://www.conversion.co.jp/