The mailing list for listmasters using Sympa

[IKEDA Soji <address@concealed>]

Hi Jean,

On Fri, 20 Sep 2019 06:12:47 +0000
DSI Gestionnaire de Listes <address@concealed> wrote:

> Hello Ikeda,
> 
> 
> 
> It's seems to work fine now.
> 
> 
> 
> I have some other errors " Data too long for column 
> 'inclusion_label_subscriber'" :

I think you sets a long name for your data source.

Could you please check this patch?

diff --git a/src/lib/Sympa/DataSource.pm b/src/lib/Sympa/DataSource.pm
index 7d109d2..92b01d3 100644
--- a/src/lib/Sympa/DataSource.pm
+++ b/src/lib/Sympa/DataSource.pm
@@ -94,6 +94,9 @@ sub new {
     my @defkeys = sort keys %{$defopts || {}};
     my @defvals = @{$defopts || {}}{@defkeys} if @defkeys;

+    $options{name} = substr $options{name}, 0, 15
+        if $options{name} and 15 < length $options{name};
+
     return $type->_new(
         %options,
         _role    => $role,


Regards,
-- Soji

> 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<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:--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/