The mailing list for listmasters using Sympa

[samer khalil <address@concealed>]

still not working.

The weird part is that it's asking to install DBD::Oracle although it is there:

root@SYMPA:~# cpan -l | grep -i oracle
DBD::Oracle 1.80
DBD::Oracle::GetInfo 1.80
DBD::Oracle::Object 1.80
auto::DBD::Oracle::mk undef

and i only have one instance of perl.

May  5 22:26:35 SYMPA wwsympa[342430]: 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#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
May  5 22:26:35 SYMPA wwsympa[342430]: 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#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
May  5 22:26:35 SYMPA wwsympa[342430]: 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#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
May  5 22:26:35 SYMPA wwsympa[342430]: notice Sympa::Spindle::ProcessTemplate::_twist() Processing Sympa::Message::Template <address@concealed,9028>; envelope_sender=address@concealed; message_id=address@concealed; recipients=ARRAY; sender=address@concealed; template=listmaster_notification; type=missing_dbd
May  5 22:26:35 SYMPA wwsympa[342430]: notice Sympa::Spindle::ProcessTemplate::_twist() Processing Sympa::Message::Template <address@concealed,9028>; envelope_sender=address@concealed; message_id=address@concealed; recipients=ARRAY; sender=address@concealed; template=listmaster_notification; type=missing_dbd
May  5 22:26:35 SYMPA wwsympa[342430]: notice Sympa::Spindle::ProcessTemplate::_twist() Processing Sympa::Message::Template <address@concealed,9028>; envelope_sender=address@concealed; message_id=address@concealed; recipients=ARRAY; sender=address@concealed; template=listmaster_notification; type=missing_dbd
May  5 22:26:35 SYMPA wwsympa[342430]: notice Sympa::Bulk::store() Message Sympa::Message::Template <address@concealed,9028> is stored into bulk spool as <address@concealed,342430,4108>
May  5 22:26:35 SYMPA wwsympa[342430]: notice Sympa::Bulk::store() Message Sympa::Message::Template <address@concealed,9028> is stored into bulk spool as <address@concealed,342430,4108>
May  5 22:26:35 SYMPA wwsympa[342430]: notice Sympa::Bulk::store() Message Sympa::Message::Template <address@concealed,9028> is stored into bulk spool as <address@concealed,342430,4108>
May  5 22:26:35 SYMPA wwsympa[342430]: 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 22:26:35 SYMPA wwsympa[342430]: 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 22:26:35 SYMPA wwsympa[342430]: 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

thank you,

Sam

On Tue, May 5, 2020 at 11:27 AM Stefan Hornburg (Racke) <address@concealed> wrote:

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.