Re: [sympa-fr] Sympa et Oracle

["FLORENT " <adresse@cachée>]

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
<adresse@cachée,5369>; envelope_sender=sympa-
adresse@cachée; message_id=sympa.
adresse@cachée; recipients=ARRAY;
adresse@cachée; template=listmaster_notification;
type=missing_dbd
Nov 21 11:58:40 listes2 wwsympa[21590]: notice
Sympa::Spindle::ProcessTemplate::_twist() Processing Sympa::Message::Template
<adresse@cachée,5369>; envelope_sender=sympa-
adresse@cachée; message_id=sympa.
adresse@cachée; recipients=ARRAY;
adresse@cachée; 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 <adresse@cachée>
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 <adresse@cachée-
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 <adresse@cachée>
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 <adresse@cachée-
cvl.fr>