db model

2005-06-09 Thread Thomas Huber 

Hi,

I am building the clients list from the nas table and experienced  
some problems:


1) There is not nas_query prepared int the configuration file. Would  
it be supported?
2) select * from nas; does not return the records in the right order.  
I think the clients list is built from the first four fields, which are:

   ID (ignored) | nasname=IP | shortname=Name | secret=something
   With the current table structure, the fourth field is Port and  
not secret. How should this be solved?


Thomas

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

Re: Oracle module

2005-05-24 Thread Thomas Huber 
  - 
fPIC -DPIC -o .libs/sql_oracle.lo
gcc -g -O2 -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -DOPENSSL_NO_KRB5 - 
Wall -D_GNU_SOURCE -DNDEBUG -I../.. -I../../../../include -I/usr/ 
include/orac

le/10.1.0.3/client -c sql_oracle.c -o sql_oracle.o /dev/null 21
mv -f .libs/sql_oracle.lo sql_oracle.lo
/root/freeradius-1.0.2/libtool --mode=link gcc -release 1.0.2 \
-module -export-dynamic  -g -O2 -D_REENTRANT - 
D_POSIX_PTHREAD_SEMANTICS -DOPENSSL_NO_KRB5   -Wall -D_GNU_SOURCE - 
DNDEBUG  -I../.. -I../../../../inc

lude \
-I/usr/include/oracle/10.1.0.3/client  -o rlm_sql_oracle.la -rpath / 
usr/local/lib sql_oracle.lo -L/usr/lib/oracle/10.1.0.3/client/lib - 
lclntsh -lm
rm -fr .libs/rlm_sql_oracle.la .libs/rlm_sql_oracle.* .libs/ 
rlm_sql_oracle-1.0.2.*
gcc -shared  sql_oracle.lo  -L/usr/lib/oracle/10.1.0.3/client/lib - 
lclntsh -lm  -Wl,-soname -Wl,rlm_sql_oracle-1.0.2.so -o .libs/ 
rlm_sql_oracle-1.0

.2.so
(cd .libs  rm -f rlm_sql_oracle.so  ln -s rlm_sql_oracle-1.0.2.so  
rlm_sql_oracle.so)

ar cru .libs/rlm_sql_oracle.a  sql_oracle.o
ranlib .libs/rlm_sql_oracle.a
creating rlm_sql_oracle.la
(cd .libs  rm -f rlm_sql_oracle.la  ln -s ../rlm_sql_oracle.la  
rlm_sql_oracle.la)
gmake[10]: Leaving directory `/root/freeradius-1.0.2/src/modules/ 
rlm_sql/drivers/rlm_sql_oracle'

Making dynamic in rlm_sql_unixodbc...
gmake[10]: Entering directory `/root/freeradius-1.0.2/src/modules/ 
rlm_sql/drivers/rlm_sql_unixodbc'
/root/freeradius-1.0.2/libtool --mode=compile gcc  -g -O2 - 
D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -DOPENSSL_NO_KRB5   -Wall - 
D_GNU_S


Looks ok to me now, modules are there, so I will do the install and see.

Still don't fully understand why config.log of the module directory  
complains about oci.h ...


Cheers,
Thomas






On 20.05.2005, at 18:13, Alan DeKok wrote:


Thomas Huber [EMAIL PROTECTED] wrote:

So I downloaded the client SDK from oracle (10.1.0.3) and  
installed it.
I then ran ./configure --with-rlm-sql-include-dir=/usr/include/ 
oracle/

10.1.0.3/client

Apparently, this is not the right way of doing it.



  Could you explain why you think that?

  Reading the output of configure and make might help.

  If all else fails, edit the Makefile in rlm_sql_oracle directory by
hand until it builds.

  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

Oracle module

2005-05-20 Thread Thomas Huber 
Dear freeradius users,
I would like to use freeradius with the oracle module. Unfortunately,  
the distribution I use does not include that module in the rpm.
I have downloaded version 1.0.2 to compile the package myself.

The configure log in modules/../rlm_sql_oracle/config.log complained  
about the missing oci.h file.
So I downloaded the client SDK from oracle (10.1.0.3) and installed it.
I then ran ./configure --with-rlm-sql-include-dir=/usr/include/oracle/ 
10.1.0.3/client

Apparently, this is not the right way of doing it. Could anyone help  
please?

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