<div dir="ltr">i also face this problem for more then one month.<br> because the problem is with module configuration<br>like in radius 1.6 version<br>in raddb/radiusd.conf file<br><br>..................<br>.............<br>
module authorize<br>{<br>#pap ...<br> ........................<br>#chap...<br> .................<br><br>there is also a <br>sql configuration <br>which is comment out like #sql<br>you have to uncomment it. #sql ----->sql<br>
<font size="4"><b>sql ......</b></font><br> ....................<br>}<br><br>then sql configuration added to the radius....<br><br>but the problem is in radius 2.0.5 nothing like this in radiusd.conf.<br>they have move these configuration files to some else place.<br>
<br>my suggetions is to move to version radius 1.6<br>because more people work on it and it is more stable then radius 2.0.5<br>hope it will help you<br><br><br>BEST REGARDS<br><br>Yawar Hadi Noshahi<br><br>QAU Islamabad (+92-0300-5504798)
<br><br><br><br><div class="gmail_quote">On Thu, Jul 24, 2008 at 12:41 PM, Leander S. <<a href="mailto:leander.schaefer@gmx.net">leander.schaefer@gmx.net</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br>
<br>
continueing: <a href="http://lists.freeradius.org/pipermail/freeradius-users/2008-June/msg00677.html" target="_blank">http://lists.freeradius.org/pipermail/freeradius-users/2008-June/msg00677.html</a><br>
<br>
@Alan de Kok<br>
<br>
;) 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!<br>
<br>
about my SQL configuration:<br>
###############################################<br>
cat sql.conf<br>
[...]<br>
database = "postgresql"<br>
server = "localhost"<br>
login = "radius"<br>
password = "My_OwN_PaSsWoRd"<br>
radius_db = "radius"<br>
#and also:<br>
sqltrace = yes<br>
[...]<br>
###############################################<br>
<br>
<br>
AND<br>
<br>
<br>
###############################################<br>
cat radiusd.conf<br>
[...]<br>
$INCLUDE sql.conf<br>
<br>
#$INCLUDE sql/mysql/counter.conf<br>
$INCLUDE sql/postgresql/counter.conf<br>
<br>
$INCLUDE sqlippool.conf<br>
[...]<br>
###############################################<br>
^^ 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.<br>
<br>
BTW.: radiusd -X says *nothing* about sql or anything which sounds quite similar like "sql" or postgres except the config it loads ;/<br>
<br>
[...]<br>
including configuration file /usr/local/etc/raddb/modules/sql_log<br>
[...]<br>
including configuration file /usr/local/etc/raddb/sql.conf<br>
including configuration file /usr/local/etc/raddb/sql/postgresql/dialup.conf<br>
including configuration file /usr/local/etc/raddb/sql/postgresql/counter.conf<br>
including configuration file /usr/local/etc/raddb/sqlippool.conf<br>
including configuration file /usr/local/etc/raddb/sql/postgresql/ippool.conf<br>
[...]<br>
<br>
sadly no querry verboses ...<br>
<br>
Thanks<br>
<br>
<br>
<br>
<br>
############################################################################################<br>
############################################################################################<br>
############################################################################################<br>
<br>
Continueing: <a href="http://lists.freeradius.org/pipermail/freeradius-users/2008-June/msg00715.html" target="_blank">http://lists.freeradius.org/pipermail/freeradius-users/2008-June/msg00715.html</a><br>
<br>
<br>
@David<br>
<br>
Thank you very much for your efforts!!<br>
<br>
<br>
Quote:<br>
###<br>
"<br>
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:<br>
<br>
LDFLAGS="-L/usr/local/lib -pthread" ; \<br>
CFLAGS+="-I/usr/local/include -L/usr/local/lib" ; \<br>
./configure --prefix=/usr/local --libdir=/usr/local/lib \<br>
--localstatedir=/var --with-docdir=/usr/local/share/doc/freeradius \<br>
--with-logdir=/var/log \<br>
--with-openssl-includes=/usr/local/include/openssl \<br>
--with-openssl-libraries=/usr/local/lib<br>
<br>
gmake install<br>
<br>
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.<br>
"<br>
<br>
###<br>
<br>
<br>
<br>
Even if you suggest to rather use ports to install freeRADIUS on FreeBSD System then compiling I rather compile because of various reasons.<br>
<br>
But I might not understood you right in the way how to use those commands.<br>
<br>
are those shell commands? Or might I have to add those 2 lines to an config?<br>
<br>
bash$ LDFLAGS="-L/usr/local/lib -pthread"<br>
bash$ CFLAGS+="-I/usr/local/include -L/usr/local/lib"<br>
<br>
<br>
<br>
well the next one is clear:<br>
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<br>
<br>
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:<br>
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<br>
<br>
^^ 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.<br>
<br>
<br>
#################################################################<br>
<br>
BTW - here is a printout of WARNINGS what's not being there when I used the "./configure --prefix=........" command given from you above:<br>
<br>
config.status: WARNING: ./<a href="http://Make.inc.in" target="_blank">Make.inc.in</a> seems to ignore the --datarootdir setting<br>
config.status: WARNING: ./src/include/<a href="http://build-radpaths-h.in" target="_blank">build-radpaths-h.in</a> seems to ignore the --datarootdir setting<br>
chmod: check-radiusd-config: No such file or directory<br>
configure: WARNING: silently not building rlm_eap_ikev2.<br>
configure: WARNING: FAILURE: rlm_eap_ikev2 requires: libeap-ikev2 EAPIKEv2/connector.h.<br>
configure: WARNING: the TNCS library isn't found!<br>
configure: WARNING: silently not building rlm_eap_tnc.<br>
configure: WARNING: FAILURE: rlm_eap_tnc requires: -lTNCS.<br>
configure: WARNING: silently not building rlm_krb5.<br>
configure: WARNING: FAILURE: rlm_krb5 requires: krb5.<br>
configure: WARNING: silently not building rlm_ldap.<br>
configure: WARNING: FAILURE: rlm_ldap requires: libldap_r ldap.h.<br>
configure: WARNING: silently not building rlm_python.<br>
configure: WARNING: FAILURE: rlm_python requires: python-binary.<br>
configure: WARNING: oracle headers not found. Use --with-oracle-home-dir=<path>.<br>
configure: WARNING: silently not building rlm_sql_oracle.<br>
configure: WARNING: FAILURE: rlm_sql_oracle requires: oci.h.<br>
<br>
[...]<br>
config.status: config.h is unchanged<br>
=== configuring in ./drivers/rlm_sql_postgresql (/usr/src/freeradius-server-2.0.5/src/modules/rlm_sql/./drivers/rlm_sql_postgresq<br>
l)<br>
configure: running /usr/local/bin/bash ./configure '--prefix=/usr/local' '--libdir=/usr/local/lib' '--localstatedir=/var' '--wit<br>
h-docdir=/usr/local/share/doc/freeradius' '--with-logdir=/var/log' '--with-openssl-includes=/usr/local/include/openssl' '--with-o<br>
penssl-libraries=/usr/local/lib' '--with-pic' '--enable-ltdl-install' --cache-file=/dev/null --srcdir=.<br>
checking for gcc... gcc<br>
[...]<br>
<br>
#################################################################<br>
<br>
AND<br>
<br>
#################################################################<br>
"gmake install" also tells me that postgresql stuff is going to be installed ...<br>
<br>
libtool: install: warning: relinking `<a href="http://rlm_realm.la" target="_blank">rlm_realm.la</a>'<br>
Making install in rlm_sql_postgresql...<br>
gmake[11]: Entering directory `/usr/src/freeradius-server-2.0.5/src/modules/rlm_sql/drivers/rlm_sql_postgresql'<br>
if [ "xrlm_sql_postgresql" != "x" ]; then \<br>
<a href="http://rlm_sql_postgresql.la" target="_blank">rlm_sql_postgresql.la</a> /usr/local/lib/<a href="http://rlm_sql_postgresql.la" target="_blank">rlm_sql_postgresql.la</a> || exit $?; \<br>
rm -f /usr/local/lib/<a href="http://rlm_sql_postgresql-2.0.5.la" target="_blank">rlm_sql_postgresql-2.0.5.la</a>; \<br>
ln -s <a href="http://rlm_sql_postgresql.la" target="_blank">rlm_sql_postgresql.la</a> /usr/local/lib/<a href="http://rlm_sql_postgresql-2.0.5.la" target="_blank">rlm_sql_postgresql-2.0.5.la</a> || exit $?; \<br>
/usr/src/freeradius-server-2.0.5/install-sh -c -c .libs/<a href="http://rlm_sql_postgresql-2.0.5.so" target="_blank">rlm_sql_postgresql-2.0.5.so</a> /usr/local/lib/<a href="http://rlm_sql_postgresql-2.0.5.so" target="_blank">rlm_sql_postgresql-2.0.5.so</a><br>
(cd /usr/local/lib && { ln -s -f <a href="http://rlm_sql_postgresql-2.0.5.so" target="_blank">rlm_sql_postgresql-2.0.5.so</a> rlm_sql_postgresql.so || { rm -f rlm_sql_postgresql.so && ln -s <a href="http://rlm_sql_postgresql-2.0.5.so" target="_blank">rlm_sql_postgresql-2.0.5.so</a> rlm_sql_postgresql.so; }; })<br>
/usr/src/freeradius-server-2.0.5/install-sh -c -c .libs/rlm_sql_postgresql.lai /usr/local/lib/<a href="http://rlm_sql_postgresql.la" target="_blank">rlm_sql_postgresql.la</a><br>
/usr/src/freeradius-server-2.0.5/install-sh -c -c .libs/rlm_sql_postgresql.a /usr/local/lib/rlm_sql_postgresql.a<br>
chmod 644 /usr/local/lib/rlm_sql_postgresql.a<br>
ranlib /usr/local/lib/rlm_sql_postgresql.a<br>
gmake[11]: Leaving directory `/usr/src/freeradius-server-2.0.5/src/modules/rlm_sql/drivers/rlm_sql_postgresql'<br>
libtool: install: warning: relinking `<a href="http://rlm_sql.la" target="_blank">rlm_sql.la</a>'<br>
#################################################################<br>
<br>
^^ So if I understood the verbose logging printout right - it's actually supposed to work?!<br>
<br>
<br>
Thanks<br>
<br>
<br>
Regards,<br>
<br>
Leander<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Yawar Hadi Noshahi<br><br>QAU Islamabad (+92-0300-5504798)
</div>