The mailing list for listmasters using Sympa

[samer khalil <address@concealed>]

Hi,

I'm running Sympa 6.2.40 on Debian Bullseye/Sid with mysql.

for some of the lists, i would like to retrieve the members from a remote Oracle database.  

I have installed an oracle client on the machine and installed DBD::Oracle through sympa_wizard.pl and configured the SQL query inclusion (include_sql_query) with the right parameters

Yet when i click on Subscribers i get error INTERNAL SERVER ERROR (review) - Failed to include members

and the following error in sympa.log:

May  5 10:41:40 SYMPA wwsympa[280034]: err main::#1566 > main::do_review#4654 > main::_review_member#4890 > Sympa::List::on_the_fly_sync_include#7031 > Sympa::List::sync_include#6691 > Sympa::List::_load_list_members_from_include#5871 > Sympa::Database::new#65 Unable to use Sympa::DatabaseDriver::oracle module: Not a Sympa::DatabaseDriver class
May  5 10:41:40 SYMPA wwsympa[280034]: err main::#1566 > main::do_review#4654 > main::_review_member#4890 > Sympa::List::on_the_fly_sync_include#7031 > Sympa::List::sync_include#6691 > Sympa::List::_load_list_members_from_include#5887 > Sympa::List::_include_users_sql#5685 Unable to connect to SQL datasource with parameters host: 193.188.130.160, database: WEB
May  5 10:41:40 SYMPA wwsympa[280034]: err main::#1566 > main::do_review#4654 > main::_review_member#4890 > Sympa::List::on_the_fly_sync_include#7031 > Sympa::List::sync_include#6691 > Sympa::List::_load_list_members_from_include#6012 Inclusion include_sql_query failed in list Sympa::List <address@concealed>

tnsping SID works fine and i'm able to connect to the DB with sqlplus.

Am using: 

db_type: oracle

connect_option: tns

dbname:WEB (from the tnsnames..)

db_env: ORACLE_TERM=vt100;ORACLE_HOME=/oracle/product/11.2.0/dbhome_1

the correct user and passwd and the sql query on oracle.

Am i still mising something? do i need to add something to apache? 

thank you,

Sam