Pour les administrateurs de serveurs de listes utilisant le logiciel Sympa

["FLORENT " <address@concealed>]

Bonjour,

J'ai effectué une nouvelle installation sur une VM en suivant tes indications.
J'ai le même soucis.

Debian (10)
Sympa (6.2.40)
Oracle (instanclient12 ou 19)

sympa_wizard -check me dit bien que les modules CPAN sont installés (notamment
DBD::Oracle)
un test avec sqlplus me connecte bien à la base oracle sur le serveur distant
il n'y a que la partie définition des sourrces de données sur les listes
(include_sql_query) qui me renvoie l'erreur " ERREUR INTERNE (review) -
Impossible de construire la liste des membres "

extrait du fichier de logs :

Nov 21 11:58:40 listes2 wwsympa[21590]: err main::#1571 >
main::do_sync_include#16592 > Sympa::List::sync_include#6683 >
Sympa::List::_load_list_members_from_include#5887 >
Sympa::List::_include_users_sql#5678 >
Sympa::DatabaseDriver::Oracle::connect#75 > Sympa::Database::connect#124 A
module for Sympa::DatabaseDriver::Oracle is not installed. You should download
and install DBD::Oracle
Nov 21 11:58:40 listes2 wwsympa[21590]: err main::#1571 >
main::do_sync_include#16592 > Sympa::List::sync_include#6683 >
Sympa::List::_load_list_members_from_include#5887 >
Sympa::List::_include_users_sql#5678 >
Sympa::DatabaseDriver::Oracle::connect#75 > Sympa::Database::connect#124 A
module for Sympa::DatabaseDriver::Oracle is not installed. You should download
and install DBD::Oracle
Nov 21 11:58:40 listes2 wwsympa[21590]: notice
Sympa::Spindle::ProcessTemplate::_twist() Processing Sympa::Message::Template
<address@concealed,5369>; envelope_sender=sympa-
address@concealed; message_id=sympa.
address@concealed; recipients=ARRAY;
address@concealed; template=listmaster_notification;
type=missing_dbd
Nov 21 11:58:40 listes2 wwsympa[21590]: notice
Sympa::Spindle::ProcessTemplate::_twist() Processing Sympa::Message::Template
<address@concealed,5369>; envelope_sender=sympa-
address@concealed; message_id=sympa.
address@concealed; recipients=ARRAY;
address@concealed; template=listmaster_notification;
type=missing_dbd
Nov 21 11:58:40 listes2 wwsympa[21590]: err main::#1571 >
main::do_sync_include#16592 > Sympa::List::sync_include#6683 >
Sympa::List::_load_list_members_from_include#5887 >
Sympa::List::_include_users_sql#5685 Unable to connect to SQL datasource with
parameters host: db.cockinsa-cvl.fr, database: cockinsa
Nov 21 11:58:40 listes2 wwsympa[21590]: err main::#1571 >
main::do_sync_include#16592 > Sympa::List::sync_include#6683 >
Sympa::List::_load_list_members_from_include#5887 >
Sympa::List::_include_users_sql#5685 Unable to connect to SQL datasource with
parameters host: db.cockinsa-cvl.fr, database: cockinsa
Nov 21 11:58:40 listes2 wwsympa[21590]: err main::#1571 >
main::do_sync_include#16592 > Sympa::List::sync_include#6683 >
Sympa::List::_load_list_members_from_include#6012 Inclusion include_sql_query
failed in list Sympa::List <address@concealed>
Nov 21 11:58:40 listes2 wwsympa[21590]: err main::#1571 >
main::do_sync_include#16592 > Sympa::List::sync_include#6695 Errors occurred
while synchronizing datasources for list Sympa::List <address@concealed-
cvl.fr>
Nov 21 11:58:40 listes2 wwsympa[21590]: err main::#1571 >
main::do_sync_include#16592 > Sympa::List::sync_include#6683 >
Sympa::List::_load_list_members_from_include#6012 Inclusion include_sql_query
failed in list Sympa::List <address@concealed>
Nov 21 11:58:40 listes2 wwsympa[21590]: err main::#1571 >
main::do_sync_include#16592 > Sympa::List::sync_include#6695 Errors occurred
while synchronizing datasources for list Sympa::List <address@concealed-
cvl.fr>