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
_________________________________________________________________
