The mailing list for listmasters using Sympa

[Jérôme Zittoun <address@concealed>]

Hi Nick,

 

Presuming you're trying to connect to Oracle for the first time from this server, and sorry if you are a Guru in Oracle.

 

Can you reach your Oracle DB using TNSPing?

See http://docs.oracle.com/cd/E11882_01/network.112/e41945/connect.htm

 

Can you reach the DB using the connection string generated by Sympa?

 

If you can, Sympa (or one of its components) is guilty, but you should first try a connection from outside of Sympa.

 

Hope this helps

--
Jérôme Zittoun
Erigne Informatique / DZ2
http://www.erigne.com
http://www.aidoveto.com

 

---

De : address@concealed [mailto:address@concealed] De la part de Nick Donaldson
Envoyé : vendredi 15 novembre 2013 19:03
À : address@concealed
Objet : [sympa-users] Sympa and Oracle

Hello everyone.

 

I managed to solve my problem of Sympa not seeing the DBI::Oracle driver. It turned out I needed to specify the database type as Oracle (uppercase ‘O’) in the db_type option for the data source I was defining.

 

Now, I have a new problem. I cannot get sympa to connect to the Oracle database I want to access. At our site, we refer to the Oracle databases via TNSNames. However, it seems that the connect_string sympa generates doesn’t work, no matter whether I specify the host as the TNSName or the full host name.

 

Also, where would I find any error messages that come from perl itself, when sympa runs into problems like this?

 

Nick Donaldson

Help & Solutions Centre Consultant

IST Help & Solutions Centre

Client Services

Information Services and Technology

010 Elizabeth Dafoe Library

University of Manitoba

Winnipeg, MB.  R3T 2N2

E-mail: address@concealed

Phone:   (204) 474-8649

Fax:     (204) 474-7598