The mailing list for listmasters using Sympa

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

On 5/5/20 9:29 PM, samer khalil wrote:
> 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.

Maybe the Sympa user doesn't see the module in the Perl search path as root 
does?
In which directory is the module installed?

Regards
          Racke

> 
> 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>; 
> address@concealed
> <mailto:address@concealed>; 
> address@concealed
> <mailto:address@concealed>; recipients=ARRAY; 
> address@concealed <mailto: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>; 
> address@concealed
> <mailto:address@concealed>; 
> address@concealed
> <mailto:address@concealed>; recipients=ARRAY; 
> address@concealed <mailto: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>; 
> address@concealed
> <mailto:address@concealed>; 
> address@concealed
> <mailto:address@concealed>; recipients=ARRAY; 
> address@concealed <mailto: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 
> <mailto: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>
>     > <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> 
> <mailto: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.
> 


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

Attachment: signature.asc
Description: OpenPGP digital signature