Sky Network Services has contributed a preliminary implementation of SNMP in the server. It's a Perl script that communicated with net-snmpd via the AgentX protocol. and with FreeRADIUS via the new Status-Server statistics functionality. The result is that you can now obtain FreeRADIUS statistics via SNMP. The code is alpha, but has been tested to work. Please test, and submit patches, suggestions, fixes, etc. back to the list, or to bugs.freeradius.org. See http://git.freeradius.org for the latest source. The new SNMP is in scripts/snmp-proxy/ Alan DeKok.
Hello, Seems to work for me, portable-bsd# snmpbulkwalk -On -v2c -cpublic localhost .1.3.6.1.2.1.67 .1.3.6.1.2.1.67.1.1.1.1.1 = STRING: "snmp(over)radius" .1.3.6.1.2.1.67.1.1.1.1.2 = Timeticks: (5369900) 14:54:59.00 .1.3.6.1.2.1.67.1.1.1.1.3 = Timeticks: (5369900) 14:54:59.00 .1.3.6.1.2.1.67.1.1.1.1.4 = INTEGER: 0 .1.3.6.1.2.1.67.1.1.1.1.5 = Counter32: 0 .1.3.6.1.2.1.67.1.1.1.1.6 = Counter32: 0 .1.3.6.1.2.1.67.1.1.1.1.7 = Counter32: 0 .1.3.6.1.2.1.67.1.1.1.1.8 = Counter32: 40 .1.3.6.1.2.1.67.1.1.1.1.9 = Counter32: 0 .1.3.6.1.2.1.67.1.1.1.1.10 = Counter32: 0 .1.3.6.1.2.1.67.1.1.1.1.11 = Counter32: 0 .1.3.6.1.2.1.67.1.1.1.1.12 = Counter32: 0 .1.3.6.1.2.1.67.1.1.1.1.13 = Counter32: 0 .1.3.6.1.2.1.67.1.1.1.1.14 = Counter32: 0 .1.3.6.1.2.1.67.2.1.1.1.1 = STRING: "snmp(over)radius" .1.3.6.1.2.1.67.2.1.1.1.2 = Timeticks: (5369900) 14:54:59.00 .1.3.6.1.2.1.67.2.1.1.1.3 = Timeticks: (5369900) 14:54:59.00 .1.3.6.1.2.1.67.2.1.1.1.4 = INTEGER: 0 .1.3.6.1.2.1.67.2.1.1.1.5 = Counter32: 0 .1.3.6.1.2.1.67.2.1.1.1.6 = Counter32: 0 .1.3.6.1.2.1.67.2.1.1.1.7 = Counter32: 0 .1.3.6.1.2.1.67.2.1.1.1.8 = Counter32: 0 .1.3.6.1.2.1.67.2.1.1.1.9 = Counter32: 0 .1.3.6.1.2.1.67.2.1.1.1.10 = Counter32: 0 .1.3.6.1.2.1.67.2.1.1.1.11 = Counter32: 0 .1.3.6.1.2.1.67.2.1.1.1.12 = Counter32: 0 .1.3.6.1.2.1.67.2.1.1.1.13 = Counter32: 0 I'll test that on 64 bits OS, and then we'll be very impatient for the 2.0.6 to come out. Thanks a lot to sky networks services. Thomas On Sun, 20 Jul 2008 12:01:48 +0200, Alan DeKok <aland@deployingradius.com> wrote:
Sky Network Services has contributed a preliminary implementation of SNMP in the server. It's a Perl script that communicated with net-snmpd via the AgentX protocol. and with FreeRADIUS via the new Status-Server statistics functionality.
The result is that you can now obtain FreeRADIUS statistics via SNMP.
The code is alpha, but has been tested to work. Please test, and submit patches, suggestions, fixes, etc. back to the list, or to bugs.freeradius.org.
See http://git.freeradius.org for the latest source. The new SNMP is in scripts/snmp-proxy/
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thomas Fagart wrote:
Seems to work for me,
That's good to hear.
I'll test that on 64 bits OS, and then we'll be very impatient for the 2.0.6 to come out.
Adding a little more "productization" wouldn't hurt. i.e. daemonising the script, and/or forking it from the server and having the server re-start it if it dies.
Thanks a lot to sky networks services.
It's a short script, but a valuable one. And a *heck* of a lot easier than adding AgentX code to the server in C. Alan DeKok.
On Mon, 21 Jul 2008 14:29:42 +0200, Alan DeKok <aland@deployingradius.com> wrote:
Thomas Fagart wrote:
Seems to work for me,
That's good to hear.
Yes it also work on 64 bit OSes
I'll test that on 64 bits OS, and then we'll be very impatient for the 2.0.6 to come out.
Adding a little more "productization" wouldn't hurt. i.e. daemonising the script, and/or forking it from the server and having the server re-start it if it dies.
Of course but this is working properly like that, which is a great improvement.
Thanks a lot to sky networks services.
It's a short script, but a valuable one. And a *heck* of a lot easier than adding AgentX code to the server in C.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Still got questions about status server implementation. When I have a look at http://www.oidview.com/mibs/0/RADIUS-AUTH-SERVER-MIB.html And when I compare it with my snmpwalk output, I still got OIDs missing. www# snmpwalk -m /usr/local/share/snmp/mibs/RADIUS-AUTH-SERVER-MIB.txt -cpublic -v1 localhost 1.3.6.1.2.1.67 RADIUS-AUTH-SERVER-MIB::radiusAuthServIdent = STRING: snmp(over)radius RADIUS-AUTH-SERVER-MIB::radiusAuthServUpTime = Timeticks: (92800) 0:15:28.00 RADIUS-AUTH-SERVER-MIB::radiusAuthServResetTime = Timeticks: (92800) 0:15:28.00 RADIUS-AUTH-SERVER-MIB::radiusAuthServConfigReset = INTEGER: 0 RADIUS-AUTH-SERVER-MIB::radiusAuthServTotalAccessRequests = Counter32: 1 RADIUS-AUTH-SERVER-MIB::radiusAuthServTotalInvalidRequests = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusAuthServTotalDupAccessRequests = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusAuthServTotalAccessAccepts = Counter32: 47 RADIUS-AUTH-SERVER-MIB::radiusAuthServTotalAccessRejects = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusAuthServTotalAccessChallenges = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusAuthServTotalMalformedAccessRequests = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusAuthServTotalBadAuthenticators = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusAuthServTotalPacketsDropped = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusAuthServTotalUnknownTypes = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.1 = STRING: "snmp(over)radius" RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.2 = Timeticks: (92800) 0:15:28.00 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.3 = Timeticks: (92800) 0:15:28.00 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.4 = INTEGER: 0 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.5 = Counter32: 2 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.6 = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.7 = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.8 = Counter32: 2 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.9 = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.10 = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.11 = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.12 = Counter32: 0 RADIUS-AUTH-SERVER-MIB::radiusMIB.2.1.1.1.13 = Counter32: 0 In the other hand, in the status virtual server, I've the feeling that this could be configurable with FreeRADIUS-Statistics-Type parameters. So I've played with that, but it does not seems to change anything. For sample, I would like to be able to differentiate proxy packets from TotalAccessRequests packets. Thomas
Thomas Fagart wrote:
Still got questions about status server implementation.
When I have a look at http://www.oidview.com/mibs/0/RADIUS-AUTH-SERVER-MIB.html
And when I compare it with my snmpwalk output, I still got OIDs missing.
Feel free to submit patches... The client table *could* be added with a little more work. The status-server stats functions allow lookups of clients by number, which could be used by the SNMP functions.
So I've played with that, but it does not seems to change anything. For sample, I would like to be able to differentiate proxy packets from TotalAccessRequests packets.
The Perl code seems to be hard-coded to ask for proxy packets *and* received packets. That can be changed relatively easily, I think. Alan DeKok.
Hi, continueing: http://lists.freeradius.org/pipermail/freeradius-users/2008-June/msg00677.ht... @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.ht... @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
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.ht...
@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.ht...
@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.sorlm_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)
i have setup radius 1.6 with mysql databse and also add the functionlaity of procedure calling.. i you need any help feel free to contact me i am available 10am to 8 pm mon to fri... thanks On Thu, Jul 24, 2008 at 1:00 PM, Yawar Hadi <yawarhadi@gmail.com> wrote:
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.ht...
@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.ht...
@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.sorlm_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)
-- Yawar Hadi Noshahi QAU Islamabad (+92-0300-5504798)
@Yawar Hadi Thanks. I need the version 2.0.5 because of various reasons. if you talk about this part in radius.conf: ############################################################################################### authorise { preprocess chap mschap suffix eap # We leave "files" enabled to allow creation of test users in /etc/raddb/users files sql pap } accounting { # We leave "detail" enabled to _additionally_ log accounting to /var/log/radius/radacct detail sql } ############################################################################################### ^^ it's not there anymore in 2.0.5 radius.conf - I also looked for that without success ;) Quote: there is also a sql configuration which is comment out like #sql you have to uncomment it. #sql ----->sql *sql ...... *^^ what config are you talking about? The only useful "sql" hint I was able to find in radius.conf was "$INCLUDE sql.conf" which is already uncommented .. Thank you Yawar Hadi schrieb:
i have setup radius 1.6 with mysql databse and also add the functionlaity of procedure calling.. i you need any help feel free to contact me i am available 10am to 8 pm mon to fri... thanks
On Thu, Jul 24, 2008 at 1:00 PM, Yawar Hadi <yawarhadi@gmail.com <mailto:yawarhadi@gmail.com>> wrote:
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 <mailto:leander.schaefer@gmx.net>> wrote:
Hi,
continueing: http://lists.freeradius.org/pipermail/freeradius-users/2008-June/msg00677.ht...
@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.ht...
@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 <http://Make.inc.in> seems to ignore the --datarootdir setting config.status: WARNING: ./src/include/build-radpaths-h.in <http://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 <http://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 <http://rlm_sql_postgresql.la> /usr/local/lib/rlm_sql_postgresql.la <http://rlm_sql_postgresql.la> || exit $?; \ rm -f /usr/local/lib/rlm_sql_postgresql-2.0.5.la <http://rlm_sql_postgresql-2.0.5.la>; \ ln -s rlm_sql_postgresql.la <http://rlm_sql_postgresql.la> /usr/local/lib/rlm_sql_postgresql-2.0.5.la <http://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 <http://rlm_sql_postgresql-2.0.5.so> /usr/local/lib/rlm_sql_postgresql-2.0.5.so <http://rlm_sql_postgresql-2.0.5.so> (cd /usr/local/lib && { ln -s -f rlm_sql_postgresql-2.0.5.so <http://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 <http://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 <http://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 <http://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)
-- Yawar Hadi Noshahi
QAU Islamabad (+92-0300-5504798) ------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Yawar Hadi wrote:
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.
raddb/sites-available/default This is documented in "radiusd.conf", if you had read it. It's also mentioned nearly daily on this list, if you read posts on this list.
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
(1) There is no version 1.6 (2) 2.0.5 is more stable than 1.x (3) 2.0.5 has more documentation than 1.x Alan DeKok.
AAAAAHHHHHHHH *bing* *raddb/sites-available/default* There we go ... let me check this out before continueing ... I guess that's what I was looking for wothout success yet ... Thanks Alan DeKok schrieb:
Yawar Hadi wrote:
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.
raddb/sites-available/default
This is documented in "radiusd.conf", if you had read it. It's also mentioned nearly daily on this list, if you read posts on this list.
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
(1) There is no version 1.6 (2) 2.0.5 is more stable than 1.x (3) 2.0.5 has more documentation than 1.x
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
thanks alan dekok for more information you provided. i worked out on 2.0.5 for morethen a month but with out success. then i switch to radius 1.1.6. 1: setup with mysql database 2: now i want to use storeprocedure to interact with databse... 3: guid me in this scenario. like rlm_sql module two files of interest rlm_sql.c and sql.c rlm_sql (module) -->drivers -->rlm_sql_mysql --> sql_mysql.c (file) { .................................................. here is the interaction with database i have wrote a function sql_authen() { ;;;;;;;;;; } } sql.c call this sql_authen() function........ rlm_sql.c call a function which is in sql.c file [function authenticatcall() ] so i get the result back. is this approch is good to interact with database or more secure and reliable way is there ...........? hope you got my point Yawar Hadi Noshahi QAU Islamabad On Thu, Jul 24, 2008 at 1:08 PM, Alan DeKok <aland@deployingradius.com> wrote:
Yawar Hadi wrote:
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.
raddb/sites-available/default
This is documented in "radiusd.conf", if you had read it. It's also mentioned nearly daily on this list, if you read posts on this list.
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
(1) There is no version 1.6 (2) 2.0.5 is more stable than 1.x (3) 2.0.5 has more documentation than 1.x
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Yawar Hadi Noshahi QAU Islamabad (+92-0300-5504798)
Yawar Hadi wrote:
i worked out on 2.0.5 for morethen a month but with out success.
That's what this list is for. If takes too long, ask questions. And I just don't understand why it's so difficult to find the "authorize" and "authenticate" sections in 2.0. Yes, they have been removed from radiusd.conf. But this is CLEARLY STATED in radiusd.conf... if you read it.
then i switch to radius 1.1.6. <http://1.1.6.> 1: setup with mysql database 2: now i want to use storeprocedure to interact with databse...
The MySQL module in 2.0 supports stored procedures. You don't need to edit anything. Alan DeKok.
thanks alan i will work in this direction. so nice of you . On Thu, Jul 24, 2008 at 3:28 PM, Alan DeKok <aland@deployingradius.com> wrote:
Yawar Hadi wrote:
i worked out on 2.0.5 for morethen a month but with out success.
That's what this list is for. If takes too long, ask questions.
And I just don't understand why it's so difficult to find the "authorize" and "authenticate" sections in 2.0. Yes, they have been removed from radiusd.conf. But this is CLEARLY STATED in radiusd.conf... if you read it.
then i switch to radius 1.1.6. <http://1.1.6.> 1: setup with mysql database 2: now i want to use storeprocedure to interact with databse...
The MySQL module in 2.0 supports stored procedures. You don't need to edit anything.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Yawar Hadi Noshahi QAU Islamabad (+92-0300-5504798)
Leander S. wrote:
############################################### ^^ There is nothing mor useful to find about SQL in the radiusd.conf -
READ radiusd.conf. The last 20-30 lines tell you what's changed, why, and where the new configurations are located.
BTW.: radiusd -X says *nothing* about sql or anything which sounds quite similar like "sql" or postgres except the config it loads ;/
Because... you didn't read radiusd.conf, and you didn't enable "sql" in the authorize/accounting sections. You are putting a LOT of work into reading the output of "configure", trying various things... and NOT reading the documentation in the configuration files. Go read radiusd.conf. The last 30 lines or so tell you what's going on. Alan DeKok.
Thanks - *raddb/sites-available/default* - was what I was searching for ;) now I do get the SQL queries when I turn on radus -X BUT, there still seems something wrong or better said missed. rlm_sql (sql): Could not link driver rlm_sql_postgresql: Shared object "libpq.so.5" not found, required by "rlm_sql_postgresql-2.0.5.so" rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /usr/local/etc/raddb/sites-enabled/default[152]: Failed to find module "sql". /usr/local/etc/raddb/sites-enabled/default[62]: Errors parsing authorize section. } } Errors initializing modules I still just have to figure out how to fix that Thanks, Leander Alan DeKok schrieb:
Leander S. wrote:
############################################### ^^ There is nothing mor useful to find about SQL in the radiusd.conf -
READ radiusd.conf. The last 20-30 lines tell you what's changed, why, and where the new configurations are located.
BTW.: radiusd -X says *nothing* about sql or anything which sounds quite similar like "sql" or postgres except the config it loads ;/
Because... you didn't read radiusd.conf, and you didn't enable "sql" in the authorize/accounting sections.
You are putting a LOT of work into reading the output of "configure", trying various things... and NOT reading the documentation in the configuration files.
Go read radiusd.conf. The last 30 lines or so tell you what's going on.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Leander S. wrote:
Thanks - *raddb/sites-available/default* - was what I was searching for ;)
Again, why search when you can read the documentation?
rlm_sql (sql): Could not link driver rlm_sql_postgresql: Shared object "libpq.so.5" not found, required by "rlm_sql_postgresql-2.0.5.so" rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld.
This is in the FAQ. Read it. Look for "Could not link".
I still just have to figure out how to fix that
Read the documentation? Alan DeKok.
I read the FAQ. But I think I might be able to fix this with those to commands told by David before I start compiling: LDFLAGS="-L/usr/local/lib -pthread" CFLAGS+="-I/usr/local/include -L/usr/local/lib" ^^ BUT I don't know how and where to use them ?! Alan DeKok schrieb:
Leander S. wrote:
Thanks - *raddb/sites-available/default* - was what I was searching for ;)
Again, why search when you can read the documentation?
rlm_sql (sql): Could not link driver rlm_sql_postgresql: Shared object "libpq.so.5" not found, required by "rlm_sql_postgresql-2.0.5.so" rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld.
This is in the FAQ. Read it. Look for "Could not link".
I still just have to figure out how to fix that
Read the documentation?
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Leander S. wrote:
I read the FAQ. But I think I might be able to fix this with those to commands told by David before I start compiling:
LDFLAGS="-L/usr/local/lib -pthread" CFLAGS+="-I/usr/local/include -L/usr/local/lib"
^^ BUT I don't know how and where to use them ?!
I'm sorry, but this is Unix sysadmin 101. You can try editing the top-level "Make.inc". Look for similar text. *Learn*. Stop trying to get detailed instructions for every little thing. You *can* figure it out for yourself. It's what most people do. Alan DeKok.
participants (4)
-
Alan DeKok -
Leander S. -
Thomas Fagart -
Yawar Hadi