From LB0074453@TechMahindra.com Fri Apr 19 16:15:23 2013
From: Lakshmi Narayana Baliah <LB0074453@TechMahindra.com>
To: freeradius-users@lists.freeradius.org
Subject: Couldn't init oracle OCI environment
Date: Fri, 19 Apr 2013 19:44:45 +0530
Message-ID:
 <1B91A6A3C38A4F4B9E3B1AE4D3746E1806D2B36A@SINBNGEX001.TechMahindra.com>
In-Reply-To:
 <mailman.3.1366365609.21360.freeradius-users@lists.freeradius.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2486259121040775244=="

--===============2486259121040775244==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi All,

I want to configure the  free radius to connect remote machine(where
database installed).
Getting below error.

rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_oracle #0
rlm_sql_oracle: Couldn't init Oracle OCI environment (OCIEnvCreate())
rlm_sql (sql): Failed to connect DB handle #0
rlm_sql (sql): starting 1
rlm_sql (sql): starting 2
rlm_sql (sql): starting 3
rlm_sql (sql): starting 4
rlm_sql (sql): Failed to connect to any SQL server.

How do i do that ??? please help....

Thanks,
Lakshmi narayana

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Disclaimer:  This message and the information contained herein is proprietary=
 and confidential and subject to the
 Tech Mahindra policy statement, you may review the policy at <a href=3D"http=
://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaim=
er.html</a>=20
externally and <a href=3D"http://tim.techmahindra.com/tim/disclaimer.html">ht=
tp://tim.techmahindra.com/tim/disclaimer.html</a> internally within Tech Mahi=
ndra.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

--===============2486259121040775244==--


From a.cudbardb@freeradius.org Fri Apr 19 17:13:09 2013
From: Arran Cudbard-Bell <a.cudbardb@freeradius.org>
To: freeradius-users@lists.freeradius.org
Subject: Re: Couldn't init oracle OCI environment
Date: Fri, 19 Apr 2013 11:12:34 -0400
Message-ID: <880F33A1-2694-4E9D-85F2-385091AEED49@freeradius.org>
In-Reply-To:
 <1B91A6A3C38A4F4B9E3B1AE4D3746E1806D2B36A@SINBNGEX001.TechMahindra.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============4037165727303228446=="

--===============4037165727303228446==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable


On 19 Apr 2013, at 10:14, "Lakshmi Narayana Baliah" <LB0074453@TechMahindra.c=
om> wrote:

> Hi All,
>=20
> I want to configure the  free radius to connect remote machine(where
> database installed).
> Getting below error.
>=20
> rlm_sql (sql): starting 0
> rlm_sql (sql): Attempting to connect rlm_sql_oracle #0
> rlm_sql_oracle: Couldn't init Oracle OCI environment (OCIEnvCreate())
> rlm_sql (sql): Failed to connect DB handle #0
> rlm_sql (sql): starting 1
> rlm_sql (sql): starting 2
> rlm_sql (sql): starting 3
> rlm_sql (sql): starting 4
> rlm_sql (sql): Failed to connect to any SQL server.
>=20
> How do i do that ??? please help....
>=20

You try the new code in FreeRADIUS master branch and see if it fixes the issu=
e or at least provides sane debug output.

-Arran

Arran Cudbard-Bell <a.cudbardb@freeradius.org>
FreeRADIUS Development Team


--===============4037165727303228446==--


From iperegudov@cboss.ru Mon Apr 22 11:15:24 2013
From: Iliya Peregoudov <iperegudov@cboss.ru>
To: freeradius-users@lists.freeradius.org
Subject: Re: Couldn't init oracle OCI environment
Date: Mon, 22 Apr 2013 13:15:19 +0400
Message-ID: <5174FFA7.8070206@cboss.ru>
In-Reply-To:
 <1B91A6A3C38A4F4B9E3B1AE4D3746E1806D2B36A@SINBNGEX001.TechMahindra.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2389161536757124086=="

--===============2389161536757124086==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

OCIEnvCreate() failure usually means that you have no ORACLE_HOME 
environment variable set in the radiusd process environment. Under Linux 
you can look into process environment using

cat /proc/<PID>/environ |tr "\0" "\n"

Either use Oracle Instant Client or set ORACLE_HOME environment variable 
in radisd process environment.


On 19.04.2013 18:14, Lakshmi Narayana Baliah wrote:
> Hi All,
>
> I want to configure the  free radius to connect remote machine(where
> database installed).
> Getting below error.
>
> rlm_sql (sql): starting 0
> rlm_sql (sql): Attempting to connect rlm_sql_oracle #0
> rlm_sql_oracle: Couldn't init Oracle OCI environment (OCIEnvCreate())
> rlm_sql (sql): Failed to connect DB handle #0
> rlm_sql (sql): starting 1
> rlm_sql (sql): starting 2
> rlm_sql (sql): starting 3
> rlm_sql (sql): starting 4
> rlm_sql (sql): Failed to connect to any SQL server.
>
> How do i do that ??? please help....

--===============2389161536757124086==--