The mailing list for listmasters using Sympa

[IKEDA Soji <address@concealed>]

Hi Ellie,

I proposed a modification to specify connection ID instead of SID.
Can you apply a patch below and check if you can configure Sympa as
you want?
 
  https://patch-diff.githubusercontent.com/raw/sympa-community/sympa/pull/431

Regards,
-- Soji

On Wed, 26 Sep 2018 12:00:54 -0400
Ellie Cartman <address@concealed> wrote:

> I have been trying to get sympa to connect to an Oracle database. I have
> verified that the database is available using sqlcl.
> 
> 
> [ellie] ./sql -L address@concealed:1521/sympadev
> 
> SQL> select USER_ID from ALL_USERS where USERNAME='SYMPA';
>    USER_ID
> ----------
>        106
> 
> 
> 
> Additionally I wrote a short script in perl and was able to attach the
> database.
> 
> [ellie]# ./TestOracle
>                 ID = 106
> 
> so, tnsnames.ora is correct.
> 
> When I run sympa.pl --health_check, however, I get:
> 
> [root]# sympa.pl --health_check
> Database sympadev defined in sympa.conf has not the right structure or is
> unreachable. verify db_xxx parameters in sympa.conf
> 
> from the log:
> 
> Sep 25 15:47:29 davies sympa/health_check[20915]: err main::#212 >
> Sympa::DatabaseManager::probe_db#94 > Sympa::DatabaseManager::instance#54 >
> Sympa::DatabaseDriver::Oracle::connect#71 > Sympa::Database::connect#157
> Can't connect to Database Sympa::DatabaseDriver::Oracle
> <db_env=NLS_LANG=American_America.AL32UTF8;ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1;db_host=oraclebox.uwo.pri;db_name=sympadev;db_port=1521;db_user=sympa>:
> ORA-12505: TNS:listener does not currently know of SID given in connect
> descriptor (DBD ERROR: OCIServerAttach)
> Sep 25 15:47:29 davies sympa/health_check[20915]: err main::#212 >
> Sympa::DatabaseManager::probe_db#96 Could not check the database
> structure.  Make sure that database connection is available
> 
> 
> 
> I have set the following values in /etc/sympa/sympa.conf
> 
> db_type Oracle
> db_host oraclebox.uwo.pri
> db_port 1521
> db_name         sympadev
> db_user         sympa
> db_passwd       ********************
> db_env
> NLS_LANG=American_America.AL32UTF8;ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1
> 
> 
> What am I doing wrong?
> 
> Thanks,
> -ellie


-- 
株式会社 コンバージョン
ITソリューション部 システムソリューション1グループ 池田荘児
〒140-0014 東京都品川区大井1-49-15 アクセス大井町ビル4F
e-mail address@concealed  TEL 03-6429-2880
https://www.conversion.co.jp/