The mailing list for listmasters using Sympa

[Ellie Cartman <address@concealed>]

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