Re: Connecting to Oracle

2002-10-10 Thread Andrea Gabellini 

from my sql.conf:

driver = rlm_sql_oracle
server = 10.10.10.10
login = user_name
password = password
radius_db = 
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.10)(PORT=1521))(CONNECT_DATA=(SID=your_sid)))

At 19.24 09/10/02, you wrote:
Hi

I have FreeRadius 0.71 on Solaris 8.
My database is Oracle 8.1.7
After starting ./radiusd -X,  I receive the following message:

rlm_sql: Driver rlm_sql_oracle loaded and linked
rlm_sql: Attempting to connect to [EMAIL PROTECTED]:1521/pmt
rlm_sql: starting 0
rlm_sql:  Attempting to connect #0
Init: Oracle logon failed: 'Error while trying to retrieve text for error 
ORA-12154 '
rlm_sql:  Failed to connect DB handle #0
rlm_sql: starting 1
rlm_sql: starting 2
rlm_sql: starting 3
rlm_sql: starting 4

The database (pmt) is running, the listener also. Oracle client is installed.
I try to connect as user pmt locally.
Could someone help

Thanks
Robert


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


---
Always remember you're unique, just like everyone else.
---
Ing. Andrea Gabellini
Email: [EMAIL PROTECTED]
Tel: 0549 886111 (Italy)
Tel. +378 0549 886111 (International)

Intelcom San Marino S.p.A.
Strada degli Angariari, 3
47891 Rovereta
Repubblic of San Marino

http://www.omniway.sm  http://www.intelcom.sm


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Connecting to Oracle

2002-10-10 Thread Tim McCracken 

On Wed, 9 Oct 2002 19:24:27 +0200
  Mieczyslaw Maciejewski (EPO) 
[EMAIL PROTECTED] wrote:
Hi 

I have FreeRadius 0.71 on Solaris 8.
My database is Oracle 8.1.7
After starting ./radiusd -X,  I receive the following 
message:

rlm_sql: Driver rlm_sql_oracle loaded and linked
rlm_sql: Attempting to connect to [EMAIL PROTECTED]:1521/pmt
rlm_sql: starting 0
rlm_sql:  Attempting to connect #0
Init: Oracle logon failed: 'Error while trying to 
retrieve text for error ORA-12154 '
rlm_sql:  Failed to connect DB handle #0
rlm_sql: starting 1
rlm_sql: starting 2
rlm_sql: starting 3
rlm_sql: starting 4

The database (pmt) is running, the listener also. Oracle 
client is installed.
I try to connect as user pmt locally. 
Could someone help

Thanks
Robert


- 
List info/subscribe/unsubscribe? See 
http://www.freeradius.org/list/users.html

You have the connect string wrong (atleast per normal 
Oracle syntax) it should be:

username/password@database

If I read your message correctly you named the database 
pmt, created a user pmt with a password of pmt?

(I think that will work, but it will be confusing!)

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Connecting to Oracle

2002-10-09 Thread Mieczyslaw Maciejewski (EPO) 

Hi 

I have FreeRadius 0.71 on Solaris 8.
My database is Oracle 8.1.7
After starting ./radiusd -X,  I receive the following message:

rlm_sql: Driver rlm_sql_oracle loaded and linked
rlm_sql: Attempting to connect to [EMAIL PROTECTED]:1521/pmt
rlm_sql: starting 0
rlm_sql:  Attempting to connect #0
Init: Oracle logon failed: 'Error while trying to retrieve text for error ORA-12154 '
rlm_sql:  Failed to connect DB handle #0
rlm_sql: starting 1
rlm_sql: starting 2
rlm_sql: starting 3
rlm_sql: starting 4

The database (pmt) is running, the listener also. Oracle client is installed.
I try to connect as user pmt locally. 
Could someone help

Thanks
Robert


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Connecting to Oracle

2002-10-09 Thread Daryl Tester 

Mieczyslaw Maciejewski (EPO)  wrote:

 Init: Oracle logon failed: 'Error while trying to retrieve text for error
ORA-12154 '

2nd hit from Google: ORA-12154:TNS:Could not resolve service name.

Regards,
  Daryl Tester
  IOCANE Pty. Ltd.


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html