The mailing list for listmasters using Sympa

[DSI Gestionnaire de Listes <address@concealed>]

Ok thank you for this answer.

Jean

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

Hi Jean,

> (...) Sympa::DataSource::RemoteFile::_open#100 Unable to fetch data 
> source Sympa::DataSource::RemoteFile <...>: only SSL_ca_path or 
> SSL_ca_file should be given

This is a bug of IO::Socket::SSL introduced on 1.87 and fixed on 1.973:
  https://metacpan.org/changes/distribution/IO-Socket-SSL#L525-526

Workaround on your Sympa is:

- Not to define both "cafile" and "capath" parameters, i.e. to define
  only one of them, in sympa.conf.

Or, update IO::Socket::SSL to recent version.

Regards,
-- Soji

On Fri, 20 Sep 2019 06:39:37 +0000
THOMAS Jean <address@concealed> wrote:

> 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;na
> me=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;na
> me=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;na
> me=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<mailto:address@concealed>>
> Envoyé : vendredi 20 septembre 2019 04:24 À : DSI Gestionnaire de 
> Listes <address@concealed<mailto:address@concealed>>
> Cc : 
> address@concealed<mailto: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<mailto: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<mailto:--sy
> > 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<mailto:address@concealed>
> 
> >
> 
> 
> 
> 
> 
> --
> 
> 株式会社 コンバージョン
> 
> ITソリューション部 システムソリューション1グループ 池田荘児
> 
> 〒140-0014 東京都品川区大井1-49-15 アクセス大井町ビル4F
> 
> e-mail address@concealed<mailto:address@concealed>  TEL 
> 03-6429-2880 https://www.conversion.co.jp/


--
株式会社 コンバージョン
ITソリューション部 システムソリューション1グループ 池田荘児
〒140-0014 東京都品川区大井1-49-15 アクセス大井町ビル4F
e-mail address@concealed  TEL 03-6429-2880 
https://www.conversion.co.jp/