Re: FreeRadius with Oracle backend

[Rodrigo Gonzalez]

The problem is still there, but I notice something, the user I tested has an
empty password, I tested with a non empty password user and everything is
ok.

I uncommented two DEBUG lines in rlm_sql and get this running radiusd -xx

rlm_sql:  check items
 Password == "[EMAIL PROTECTED]@\001"

and running radiusd -xxs

rlm_sql:  check items
 Password == ""

Maybe this can help someone with this

Regards,

Rodrigo Gonzalez.

- Original Message - 
From: "Alan DeKok" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 28, 2003 1:05 PM
Subject: Re: FreeRadius with Oracle backend


> "Rodrigo Gonzalez" <[EMAIL PROTECTED]> wrote:
> > Every auth request (made with radclient) is rejected with this error: No
> > matching entry in the database for request from user []
> > The user  exists.
> > If I run freeradius with -s the problem does not existsis there any
> > problem with threads and Oracle?
>
>   Grab the latest CVS snapshot.  It has at least one fix to the Oracle
> code.
>
>   Alan DeKok.
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>


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

Re: FreeRadius with Oracle backend

[Alan DeKok]

"Rodrigo Gonzalez" <[EMAIL PROTECTED]> wrote:
> Every auth request (made with radclient) is rejected with this error: No 
> matching entry in the database for request from user []
> The user  exists.
> If I run freeradius with -s the problem does not existsis there any 
> problem with threads and Oracle?

  Grab the latest CVS snapshot.  It has at least one fix to the Oracle
code.

  Alan DeKok.

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

FreeRadius with Oracle backend

[Rodrigo Gonzalez]

I am testing freeradius using Oracle and I have 
this problem.
 
Every auth request (made with radclient) is 
rejected with this error: No matching entry in the database for request from 
user []
The user  exists.
If I run freeradius with -s the problem does not 
existsis there any problem with threads and Oracle?
 
Best regards,
 
Rodrigo.

Re: Freeradius with Oracle backend

[Alan DeKok]

Tom Mulder <[EMAIL PROTECTED]> wrote:
> I am getting some problems during compilation of freeradius with the 
> Oracle Backend.

  You can try deleting the problem line, or using the snapshot from
tomorrow, I think I added a correct fix.

  Alan DeKok.

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

Freeradius with Oracle backend

[Tom Mulder]

Hi,

I am getting some problems during compilation of freeradius with the 
Oracle Backend.

Oracle and it's dev files are installed in /usr/local/oracle, /usr/lib, 
/usr/include
The used version of freeradius is the latest snapshot, the oracle libs 
are version 8i, the system is running debian testing/unstable, with gcc 
version 2.95.4 20011002 (Debian prerelease).

During compilation the following errors keep comming up:

Making static in rlm_sql_oracle...
make[11]: Entering directory 
`/root/freeradius-snapshot-20021202/src/modules/rlm_sql/drivers/rlm_sql_oracle'
gcc  -g -O2 -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -Wall -D_GNU_SOURCE 
-g -Wshadow -Wpointer-arith -Wcast-qual -Wcast-align -Wwrite-strings 
-Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations 
-Wnested-externs -I../.. -I../../../../include  -c sql_oracle.c -o 
sql_oracle.o
In file included from /usr/include/ori.h:495,
 from /usr/include/oci.h:1656,
 from sql_oracle.c:15:
/usr/include/ort.h:2647: warning: declaration of `version' shadows 
global declaration
In file included from /usr/include/oci.h:1660,
 from sql_oracle.c:15:
/usr/include/orl.h:3232: warning: declaration of `index' shadows global 
declaration
/usr/include/orl.h:3315: warning: declaration of `index' shadows global 
declaration
/usr/include/orl.h:3776: warning: declaration of `index' shadows global 
declaration
/usr/include/orl.h:3806: warning: declaration of `index' shadows global 
declaration
/usr/include/orl.h:3841: warning: declaration of `index' shadows global 
declaration
/usr/include/orl.h:3871: warning: declaration of `index' shadows global 
declaration
/usr/include/orl.h:3901: warning: declaration of `index' shadows global 
declaration
/usr/include/orl.h:3936: warning: declaration of `index' shadows global 
declaration
In file included from /usr/include/oci.h:1673,
 from sql_oracle.c:15:
/usr/include/ociap.h:5561: warning: declaration of `index' shadows 
global declaration
/usr/include/ociap.h:5565: warning: declaration of `index' shadows 
global declaration
/usr/include/ociap.h:5913: warning: declaration of `version' shadows 
global declaration
/usr/include/ociap.h:6307: warning: declaration of `index' shadows 
global declaration
/usr/include/ociap.h:8855: warning: declaration of `timezone' shadows 
global declaration
sql_oracle.c: In function `sql_select_query':
sql_oracle.c:301: `SQLT_AFV' undeclared (first use in this function)
sql_oracle.c:301: (Each undeclared identifier is reported only once
sql_oracle.c:301: for each function it appears in.)
make[11]: *** [sql_oracle.o] Error 1make[11]: Leaving directory 
`/root/freeradius-snapshot-20021202/src/modules/rlm_sql/drivers/rlm_sql_oracle'
make[10]: *** [common] Error 1
make[10]: Leaving directory 
`/root/freeradius-snapshot-20021202/src/modules/rlm_sql/drivers'
make[9]: *** [static] Error 2
make[9]: Leaving directory 
`/root/freeradius-snapshot-20021202/src/modules/rlm_sql/drivers'
make[8]: *** [common] Error 1
make[8]: Leaving directory 
`/root/freeradius-snapshot-20021202/src/modules/rlm_sql'
make[7]: *** [static] Error 2
make[7]: Leaving directory 
`/root/freeradius-snapshot-20021202/src/modules/rlm_sql'
make[6]: *** [common] Error 1
make[6]: Leaving directory `/root/freeradius-snapshot-20021202/src/modules'
make[5]: *** [all] Error 2
make[5]: Leaving directory `/root/freeradius-snapshot-20021202/src/modules'
make[4]: *** [common] Error 1
make[4]: Leaving directory `/root/freeradius-snapshot-20021202/src'
make[3]: *** [all] Error 2
make[3]: Leaving directory `/root/freeradius-snapshot-20021202/src'
make[2]: *** [common] Error 1
make[2]: Leaving directory `/root/freeradius-snapshot-20021202'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/root/freeradius-snapshot-20021202'
make: *** [build] Error 2
radius-harvester:~/freeradius-snapshot-20021202#



With Regards,
Tom Mulder


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