The mailing list for listmasters using Sympa

[IKEDA Soji <address@concealed>]

Sorry, I pasted wrong URL.

  https://github.com/sympa-community/sympa/pull/431

is correct.

Regards,
-- Soji

On Thu, 4 Oct 2018 11:03:58 +0900
IKEDA Soji <address@concealed> wrote:

> 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/


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