i also face this problem for more then one month.
because the problem is with module configuration
like in radius 1.6 version
in raddb/radiusd.conf file
..................
.............
module authorize
{
#pap ...
........................
#chap...
.................
there is also a
sql configuration
which is comment out like #sql
you have to uncomment it. #sql ----->sql
sql ...... ....................
}
then sql configuration added to the radius....
but the problem is in radius 2.0.5 nothing like this in radiusd.conf.
they have move these configuration files to some else place.
my suggetions is to move to version radius 1.6
because more people work on it and it is more stable then radius 2.0.5
hope it will help you
BEST REGARDS
Yawar Hadi Noshahi
QAU Islamabad (+92-0300-5504798)
On Thu, Jul 24, 2008 at 12:41 PM, Leander S. <
leander.schaefer@gmx.net> wrote:
Hi,
continueing: http://lists.freeradius.org/pipermail/freeradius-users/2008-June/msg00677.html
@Alan de Kok
;) Thanks for keeping me so stupid even if I already said that I already got it working a couple of setups on 1.1.7 - but I won't complain because I seriously realy appreciate your help!
about my SQL configuration:
###############################################
cat sql.conf
[...]
database = "postgresql"
server = "localhost"
login = "radius"
password = "My_OwN_PaSsWoRd"
radius_db = "radius"
#and also:
sqltrace = yes
[...]
###############################################
AND
###############################################
cat radiusd.conf
[...]
$INCLUDE sql.conf
#$INCLUDE sql/mysql/counter.conf
$INCLUDE sql/postgresql/counter.conf
$INCLUDE sqlippool.conf
[...]
###############################################
^^ There is nothing mor useful to find about SQL in the radiusd.conf - except the sql querrie samples provided in the [...]/raddb/sql/* folder which I just left like they are - So I guess I configured right - the modules are just still missed I think so. Correct me if you guess something different.
BTW.: radiusd -X says *nothing* about sql or anything which sounds quite similar like "sql" or postgres except the config it loads ;/
[...]
including configuration file /usr/local/etc/raddb/modules/sql_log
[...]
including configuration file /usr/local/etc/raddb/sql.conf
including configuration file /usr/local/etc/raddb/sql/postgresql/dialup.conf
including configuration file /usr/local/etc/raddb/sql/postgresql/counter.conf
including configuration file /usr/local/etc/raddb/sqlippool.conf
including configuration file /usr/local/etc/raddb/sql/postgresql/ippool.conf
[...]
sadly no querry verboses ...
Thanks
############################################################################################
############################################################################################
############################################################################################
Continueing: http://lists.freeradius.org/pipermail/freeradius-users/2008-June/msg00715.html
@David
Thank you very much for your efforts!!
Quote:
###
"
After untarring the FreeRADIUS 2.0.5 tarball and changing directory to the root of the untarred tarball, these steps are roughly what you need:
LDFLAGS="-L/usr/local/lib -pthread" ; \
CFLAGS+="-I/usr/local/include -L/usr/local/lib" ; \
./configure --prefix=/usr/local --libdir=/usr/local/lib \
--localstatedir=/var --with-docdir=/usr/local/share/doc/freeradius \
--with-logdir=/var/log \
--with-openssl-includes=/usr/local/include/openssl \
--with-openssl-libraries=/usr/local/lib
gmake install
You must add --with-pic to the first command if using FreeBSD amd64. You should omit the two openssl lines if you don't have the OpenSSL port included. I don't recommend this - I really do believe it's better to use the port.
"
###
Even if you suggest to rather use ports to install freeRADIUS on FreeBSD System then compiling I rather compile because of various reasons.
But I might not understood you right in the way how to use those commands.
are those shell commands? Or might I have to add those 2 lines to an config?
bash$ LDFLAGS="-L/usr/local/lib -pthread"
bash$ CFLAGS+="-I/usr/local/include -L/usr/local/lib"
well the next one is clear:
bash$ ./configure --prefix=/usr/local --libdir=/usr/local/lib --localstatedir=/var --with-docdir=/usr/local/share/doc/freeradius --with-logdir=/var/log --with-openssl-includes=/usr/local/include/openssl --with-openssl-libraries=/usr/local/lib
and I do have amd64 so I'm guessing if I read right in the ./configure --help that the ./configure command is supposed to look like:
bash$ ./configure --prefix=/usr/local --libdir=/usr/local/lib --localstatedir=/var --with-docdir=/usr/local/share/doc/freeradius --with-logdir=/var/log --with-openssl-includes=/usr/local/include/openssl --with-openssl-libraries=/usr/local/lib --with-pic
^^ because you mentioned to add --with-pic in the first command which would be LDFLAGS="-L/usr/local/lib -pthread" --> which didn't make sense for me to add it there?! correct me if I'm wrong.
#################################################################
BTW - here is a printout of WARNINGS what's not being there when I used the "./configure --prefix=........" command given from you above:
config.status: WARNING: ./Make.inc.in seems to ignore the --datarootdir setting
config.status: WARNING: ./src/include/build-radpaths-h.in seems to ignore the --datarootdir setting
chmod: check-radiusd-config: No such file or directory
configure: WARNING: silently not building rlm_eap_ikev2.
configure: WARNING: FAILURE: rlm_eap_ikev2 requires: libeap-ikev2 EAPIKEv2/connector.h.
configure: WARNING: the TNCS library isn't found!
configure: WARNING: silently not building rlm_eap_tnc.
configure: WARNING: FAILURE: rlm_eap_tnc requires: -lTNCS.
configure: WARNING: silently not building rlm_krb5.
configure: WARNING: FAILURE: rlm_krb5 requires: krb5.
configure: WARNING: silently not building rlm_ldap.
configure: WARNING: FAILURE: rlm_ldap requires: libldap_r ldap.h.
configure: WARNING: silently not building rlm_python.
configure: WARNING: FAILURE: rlm_python requires: python-binary.
configure: WARNING: oracle headers not found. Use --with-oracle-home-dir=<path>.
configure: WARNING: silently not building rlm_sql_oracle.
configure: WARNING: FAILURE: rlm_sql_oracle requires: oci.h.
[...]
config.status: config.h is unchanged
=== configuring in ./drivers/rlm_sql_postgresql (/usr/src/freeradius-server-2.0.5/src/modules/rlm_sql/./drivers/rlm_sql_postgresq
l)
configure: running /usr/local/bin/bash ./configure '--prefix=/usr/local' '--libdir=/usr/local/lib' '--localstatedir=/var' '--wit
h-docdir=/usr/local/share/doc/freeradius' '--with-logdir=/var/log' '--with-openssl-includes=/usr/local/include/openssl' '--with-o
penssl-libraries=/usr/local/lib' '--with-pic' '--enable-ltdl-install' --cache-file=/dev/null --srcdir=.
checking for gcc... gcc
[...]
#################################################################
AND
#################################################################
"gmake install" also tells me that postgresql stuff is going to be installed ...
libtool: install: warning: relinking `rlm_realm.la'
Making install in rlm_sql_postgresql...
gmake[11]: Entering directory `/usr/src/freeradius-server-2.0.5/src/modules/rlm_sql/drivers/rlm_sql_postgresql'
if [ "xrlm_sql_postgresql" != "x" ]; then \
rlm_sql_postgresql.la /usr/local/lib/rlm_sql_postgresql.la || exit $?; \
rm -f /usr/local/lib/rlm_sql_postgresql-2.0.5.la; \
ln -s rlm_sql_postgresql.la /usr/local/lib/rlm_sql_postgresql-2.0.5.la || exit $?; \
/usr/src/freeradius-server-2.0.5/install-sh -c -c .libs/rlm_sql_postgresql-2.0.5.so /usr/local/lib/rlm_sql_postgresql-2.0.5.so
(cd /usr/local/lib && { ln -s -f rlm_sql_postgresql-2.0.5.so rlm_sql_postgresql.so || { rm -f rlm_sql_postgresql.so && ln -s rlm_sql_postgresql-2.0.5.so rlm_sql_postgresql.so; }; })
/usr/src/freeradius-server-2.0.5/install-sh -c -c .libs/rlm_sql_postgresql.lai /usr/local/lib/rlm_sql_postgresql.la
/usr/src/freeradius-server-2.0.5/install-sh -c -c .libs/rlm_sql_postgresql.a /usr/local/lib/rlm_sql_postgresql.a
chmod 644 /usr/local/lib/rlm_sql_postgresql.a
ranlib /usr/local/lib/rlm_sql_postgresql.a
gmake[11]: Leaving directory `/usr/src/freeradius-server-2.0.5/src/modules/rlm_sql/drivers/rlm_sql_postgresql'
libtool: install: warning: relinking `rlm_sql.la'
#################################################################
^^ So if I understood the verbose logging printout right - it's actually supposed to work?!
Thanks
Regards,
Leander
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
--
Yawar Hadi Noshahi
QAU Islamabad (+92-0300-5504798)