The mailing list for listmasters using Sympa

["Stefan Hornburg (Racke)" <address@concealed>]

On 5/5/20 10:12 AM, samer khalil wrote:
> 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
> <http://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 <mailto: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? 

Hello Sam,

please try db_type Oracle instead of oracle.

Regards
         Racke

> 
> thank you,
> Sam


-- 
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.

Attachment: signature.asc
Description: OpenPGP digital signature