Thanks a lot for your kind support.
As per your instruction i did but Still i have the same issue,
# env
HZ=100
TERM=vt100
SHELL=/sbin/sh
LD_LIBRARY_PATH=/opt/app/oracle/oracle/product/10.2.0/db_3/lib32
ORACLE_SID=orcl
ORACLE_BASE=/opt/app/oracle
TNS_ADMIN=/opt/app/oracle/oracle/product/10.2.0/db_3/network/admin
PATH=/usr/sbin:/usr/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/sfw/bin:/usr/local/lib:/opt/app/oracle/oracle/product/10.2.0/db_3/bin:/usr/ccs/bin
MAIL=/var/mail/root
PWD=/
LANG=C
TZ=<GMT+3>+3
SHLVL=1
HOME=/
LOGNAME=root
ORACLE_HOME=/opt/app/oracle/oracle/product/10.2.0/db_3
_=/usr/bin/en
Here are the logs,
Tue Jul 15 14:57:02 2008: ERR: Could not connect to SQL database with
DBI->connect dbi:Oracle:sunb, cybrad, cybrad: ORA-12154: TNS:could not resolve
the connect identifier specified (DBD ERROR: OCIServerAttach)
Tue Jul 15 14:57:02 2008: ERR: Could not connect to any SQL database. Request
is ignored. Backing off for 600 seconds
My radius profile is.
SessionDatabases
<SessionDatabase SQL>
DBSource dbi:xxx:xxx
DBUsername xxx
DBAuth xxxx
# An entry for each user _currently_ on line
AddQuery insert into RADONLINE (USERNAME,NASIDENTIFIER,NASPORT,\
ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NASPORTTYPE,\
SERVICETYPE,CALLERID) values \
(%0,'%{NAS-IP-Address}',%{NAS-Port},'%{Acct-Session-Id}',\
to_date('%G','Mon dd, yyyy
hh24:mi:ss'),'%{Framed-IP-Address}','%{NAS-Port-Type}',\
'%{Framed-Protocol}','%{Calling-Station-Id}')
DeleteQuery delete from RADONLINE where USERNAME=%0 and \
NASIDENTIFIER='%N' and NASPORT=%{NAS-Port}
# ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
# CountQuery select NASIDENTIFIER, NASPORT,
ACCTSESSIONID from \
# RADONLINE where USERNAME=%0
</SessionDatabase
Ejaz
----- Original Message -----
From: "John Scoles" <[EMAIL PROTECTED]>
To: "Ejaz" <[EMAIL PROTECTED]>
Cc: "John Scoles" <[EMAIL PROTECTED]>; "Ej" <[EMAIL PROTECTED]>;
<[email protected]>
Sent: Tuesday, July 15, 2008 2:10 PM
Subject: Re: DBD-Oracle-1.21 installation issue
> Looks from that one it cannot find you listener.
>
> Set the TNS_ADMIN value to the directory that has your TNASNAMES.ORA file
>
> cheers
>
> Ejaz wrote:
>> Dear John,
>>
>> Many thanks for your reply,
>>
>>
>> But I cannot insert the values in the database, when ever I am trying
>> through my radius profiile which we are using for authentications,
>>
>> When i tried to connect manually its ok,
>>
>> # sqllus xxxx/[EMAIL PROTECTED]
>>
>> SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 15 09:51:53 2008
>>
>> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>>
>>
>> Connected to:
>> Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
>> With the Partitioning, OLAP and Oracle Data Mining options
>> JServer Release 9.2.0.1.0 - Production
>>
>> SQL> quit
>>
>> Here is the message in my radius logs, when i tried to connect from radius,
>>
>> , 212.119.67.21, 4475130
>> Mon Jul 14 17:08:06 2008: ERR: Could not connect to SQL database with
>> DBI->connect dbi:Oracle:sunb, cybrad, cybrad: ORA-12154: TNS:could not
>> resolve the connect identifier specified (DBD ERROR: OCIServerAttach)
>> Mon Jul 14 17:08:06 2008: ERR: Could not connect to any SQL database.
>> Request is ignored. Backing off for 600 seconds
>> Mon Jul 14 17:08
>>
>>
>> Regards
>> Ejaz
>> ----- Original Message -----
>> From: "John Scoles" <[EMAIL PROTECTED]>
>> To: "Ej" <[EMAIL PROTECTED]>; <[email protected]>
>> Sent: Saturday, July 12, 2008 10:24 PM
>> Subject: RE: DBD-Oracle-1.21 installation issue
>>
>>
>>
>> Looks like it installed just fine your need to set the 'ORACLE_USERID' to a
>> valid user on your DB for the test to work or create a use called Scott with
>> a pw tiger on your DB (This I would not do as every hacker knows this PW ad
>> USer id)
>>
>>
>>> To: [email protected]
>>> From: [EMAIL PROTECTED]
>>> Subject: DBD-Oracle-1.21 installation issue
>>> Date: Sat, 12 Jul 2008 04:22:57 -0700
>>> CC: [EMAIL PROTECTED]
>>>
>>> HI all.
>>>
>>> Iam trying to install DBD-Oracle-5.1 on soalris 10_x86 and Oracle
>>> 10g,
>>> I got the following error message while running " make test" Please
>>> any suggestion would highly appreciated,
>>>
>>>
>>> t/31lob.................DBI connect('','scott/tiger',...) failed:
>>> ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/
>>> nchar_test_lib.pl line 156
>>> You tried to plan twice! Second plan at t/31lob.t line 16
>>> # Looks like your test died before it could output anything.
>>> t/
>>> 31lob.................dubious
>>> Test returned status 255 (wstat 65280, 0xff00)
>>> DIED. FAILED tests 1-9
>>> Failed 9/9 tests, 0.00% okay
>>> t/32xmltype.............ok 1/4DBI connect('','scott/tiger',...)
>>> failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach)
>>> at t/32xmltype.t line 26
>>> # Looks like you planned 4 tests but only ran 1.
>>> # Looks like your test died just after 1.
>>> t/
>>> 32xmltype.............dubious
>>> Test returned status 255 (wstat 65280, 0xff00)
>>> DIED. FAILED tests 2-4
>>> Failed 3/4 tests, 25.00% okay
>>> t/34pres_lobs...........DBI connect('','scott/tiger',...) failed:
>>> ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/
>>> 34pres_lobs.t line 31
>>> # Looks like your test died before it could output anything.
>>> t/
>>> 34pres_lobs...........dubious
>>> Test returned status 255 (wstat 65280, 0xff00)
>>> DIED. FAILED tests 1-11
>>> Failed 11/11 tests, 0.00% okay
>>> t/40ph_type.............DBI connect('','scott/tiger',...) failed:
>>> ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/
>>> 40ph_type.t line 29
>>> Unable to connect to Oracle (ORA-12546: TNS:permission denied (DBD
>>> ERROR: OCIServerAttach))
>>> Tests skipped.
>>> skipped
>>> all skipped: no reason given
>>> t/50cursor..............Unable to connect to Oracle as scott/tiger
>>> (ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
>>> Tests skipped.
>>> skipped
>>> all skipped: no reason given
>>> t/51scroll..............ok 1/33DBI connect('','scott/tiger',...)
>>> failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach)
>>> at t/51scroll.t line 26
>>> # Looks like you planned 33 tests but only ran 1.
>>> # Looks like your test died just after 1.
>>> t/
>>> 51scroll..............dubious
>>> Test returned status 255 (wstat 65280, 0xff00)
>>> DIED. FAILED tests 2-33
>>> Failed 32/33 tests, 3.03% okay
>>> t/55nested..............Unable to connect to Oracle as scott/tiger
>>> (ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
>>> Tests skipped.
>>> skipped
>>> all skipped: no reason given
>>> t/56embbeded............ok 1/5DBI connect('','scott/tiger',...)
>>> failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach)
>>> at t/56embbeded.t line 28
>>> # Looks like you planned 5 tests but only ran 1.
>>> # Looks like your test died just after 1.
>>> t/
>>> 56embbeded............dubious
>>> Test returned status 255 (wstat 65280, 0xff00)
>>> DIED. FAILED tests 2-5
>>> Failed 4/5 tests, 20.00% okay
>>> t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
>>> skipped
>>> all skipped: no reason given
>>> t/70meta................Unable to connect to Oracle as scott/tiger
>>> (ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
>>> Tests skipped.
>>> skipped
>>> all skipped: no reason given
>>> t/80ora_charset.........DBI connect('','scott/tiger',...) failed:
>>> ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/
>>> 80ora_charset.t line 118
>>> skipped
>>> all skipped: Not connected to oracle
>>> Failed Test Stat Wstat Total Fail Failed List of Failed
>>> -------------------------------------------------------------------------------
>>> t/10general.t 255 65280 33 66 200.00% 1-33
>>> t/26exe_array.t 255 65280 14 26 185.71% 2-14
>>> t/28array_bind.t 255 65280 15 30 200.00% 1-15
>>> t/30long.t 255 65280 470 940 200.00% 1-470
>>> t/31lob.t 255 65280 9 18 200.00% 1-9
>>> t/32xmltype.t 255 65280 4 6 150.00% 2-4
>>> t/34pres_lobs.t 255 65280 11 22 200.00% 1-11
>>> t/51scroll.t 255 65280 33 64 193.94% 2-33
>>> t/56embbeded.t 255 65280 5 8 160.00% 2-5
>>> 17 tests and 9 subtests skipped.
>>> Failed 9/28 test scripts, 67.86% okay. 590/608 subtests failed, 2.96%
>>> okay.
>>> make: *** [test_dynamic] Error 29
>>>
>>>
>>
>> _________________________________________________________________
>>
>>
>>
