November 2007 - Freeradius-Users - lists.freeradius.org

Grouping account stats with a LIKE statement
by Steve Bertrand 21 Nov '07

21 Nov '07

This is more a MySQL question rather than a RADIUS one, but I thought I'd ask here first. For some reason I can't put my head around this issue. I have NAS's in several different PoP's. Each PoP has it's own (different) IP block. What I want to do is modify dialupadmin's tot_stats script. Instead of having the stats displayed each day for each user on each NAS, I'd like it to aggregate user stats per NAS *site*. In essence, in the GROUP BY statement, I'd like a way to have it combine by for instance NASGroup as opposed to NASIPAddress. Is there a way that I can do this type of aggregation with a LIKE statement on the first pull from radacct within the statement below, or will I have to perform several SELECT's to do this task? SELECT UserName,'2007-11-08',COUNT(*),SUM(AcctSessionTime), MAX(AcctSessionTime),MIN(AcctSessionTime),SUM(AcctInputOctets), SUM(AcctOutputOctets),NASIPAddress FROM radacct WHERE AcctStopTime >= '2007-11-08 00:00:00' AND AcctStopTime < '2007-11-09 00:00:00' GROUP BY UserName,NASIPAddress;

1 0

multiple "user" files
by Stieven.Struyf＠komatsu.eu 21 Nov '07

21 Nov '07

Is it possible to have multiple user files. To make it more readable i want to split up my userfile into different files depending on the usertype (scanners, pc's, ... ) Is this possible by just adding multiple userfile entries? Stieven Struyf M.I.S. Division - System Operations Komatsu Europe International NV Mechelsesteenweg 586 B-1800 Vilvoorde Stieven.Struyf(a)komatsu.eu Tel. +32 (0)2 2552551 "The question of whether a computer can think is no more interesting than the question of whether a submarine can swim." -- E. W. Dijkstra "This e-mail is property of the company and is supposed to contain only professional content. The company can at all times consult the content of this e-mail and the reply to this e-mail. By replying to this e-mail, you confirm your explicit agreement with the preceding." "Deze e-mail is het eigendom van de Vennootschap en wordt verondersteld enkel beroepsmatige informatie te bevatten. De Vennootschap kan ten allen tijden de inhoud van deze e-mail en van het antwoord daarop raadplegen. Door het beantwoorden van deze e-mail bevestigt U uitdrukkelijk uw akkoord met het voorafgaande."

2 1

R: WPA HOWTO
by Francesco Cristofori 21 Nov '07

21 Nov '07

Hi, > and I have no bloody idea what to do. > or have I tested your patience to it's limit? You should read the Debian Policy (at least the section about building packages from src) in order to understand how building from source works "the Debian Way". :-) Briefly: 0) configure a deb-src for testing since 1.1.7 isn't available in stable (see apt howto for details) 1) apt-get source freeradius 2) apt-get build-dep freeradius (run this command as root) 3) dpkg-buildpackage -rfakeroot -uc -b (run this as normal user) 4) complain for bugs against debian bts ;-) > Thanks in anticipation, > build HTH, Francesco.

1 0

Compile Blues
by Willem Gerber 21 Nov '07

21 Nov '07

Hi guys/gals Any ideas why i would be getting the error below ?? Here are the sql packages i have installed mysql++-2.2.3-1.fc5 mysql-5.0.27-1.fc5 mysql-devel-5.0.27-1.fc5 mysql-server-5.0.27-1.fc5 Regards Willem Gerber make[6]: Entering directory `/home/willem/freeradius-1.1.7/src/modules/rlm_sqlippool' /home/willem/freeradius-1.1.7/libtool --mode=compile gcc -g -O2 -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -Wall -D_GNU_SOURCE -DNDEBUG -I/home/willem/freeradius-1.1.7/src/include -I/home/willem/freeradius-1.1.7/src/modules/rlm_sql -c rlm_sqlippool.c gcc -g -O2 -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -Wall -D_GNU_SOURCE -DNDEBUG -I/home/willem/freeradius-1.1.7/src/include -I/home/willem/freeradius-1.1.7/src/modules/rlm_sql -c rlm_sqlippool.c -fPIC -DPIC -o .libs/rlm_sqlippool.o In file included from rlm_sqlippool.c:37: /home/willem/freeradius-1.1.7/src/include/modpriv.h:7:18: error: ltdl.h: No such file or directory In file included from rlm_sqlippool.c:37: /home/willem/freeradius-1.1.7/src/include/modpriv.h:16: error: expected specifier-qualifier-list before 'lt_dlhandle' In file included from rlm_sqlippool.c:39: /home/willem/freeradius-1.1.7/src/modules/rlm_sql/rlm_sql.h:15:18: error: ltdl.h: No such file or directory In file included from rlm_sqlippool.c:39: /home/willem/freeradius-1.1.7/src/modules/rlm_sql/rlm_sql.h:68: error: expected specifier-qualifier-list before 'lt_dlhandle' rlm_sqlippool.c: In function 'sqlippool_command': rlm_sqlippool.c:311: error: 'SQL_INST' has no member named 'module' rlm_sqlippool.c: In function 'sqlippool_query1': rlm_sqlippool.c:358: error: 'SQL_INST' has no member named 'module' rlm_sqlippool.c: In function 'sqlippool_postauth': rlm_sqlippool.c:539: warning: pointer targets in passing argument 2 of 'strNcpy' differ in signedness rlm_sqlippool.c:526: warning: unused variable 'self' gmake[6]: *** [rlm_sqlippool.lo] Error 1 gmake[6]: Leaving directory `/home/willem/freeradius-1.1.7/src/modules/rlm_sqlippool' gmake[5]: *** [common] Error 2 gmake[5]: Leaving directory `/home/willem/freeradius-1.1.7/src/modules' gmake[4]: *** [all] Error 2 gmake[4]: Leaving directory `/home/willem/freeradius-1.1.7/src/modules' gmake[3]: *** [common] Error 2 gmake[3]: Leaving directory `/home/willem/freeradius-1.1.7/src' gmake[2]: *** [all] Error 2 gmake[2]: Leaving directory `/home/willem/freeradius-1.1.7/src' gmake[1]: *** [common] Error 2 gmake[1]: Leaving directory `/home/willem/freeradius-1.1.7' make: *** [all] Error 2 -- "The casing said 'Windows XP or better'... so I installed Linux" -- Anonymous

3 3

rlm_sqlippool needs $(INCLTDL) added to RLM_CFLAGS
by Tommy McNeely 21 Nov '07

21 Nov '07

I was building freeradius-1.1.7 on Solaris 10 sparc, and ran into an issue with rlm_sqlippool. I seriously doubt I even need that module, but the problem was fairly easy to work around. It is including modpriv.h which uses ldtl.h. The simple work around is to add $(INCLDTL) to the end of the RLM_CFLAGS line in Makefile.in (or just Makefile). I was not able to see any similar bug reports, but I suck at searching bugster. Has this problem already been reported/fixed or should I file a bug report? Thanks, Tommy

2 1

2.0.0-pre2 missing radrelay functionality?
by Brian De Wolf 21 Nov '07

21 Nov '07

While looking into fixes for my previous post, I began poking at 2.0.0-pre2. I see that radrelay's functionality is supposed to have been merged into the main server, but I do not see where it has the same capability of relaying accounting packets to other RADIUS servers. Has this functionality been removed? There is no mention of it in the man page or the example configuration, but I would hope it's in there somewhere, otherwise radrelay should probably still exist.

2 1

With passwords only
by build 20 Nov '07

20 Nov '07

G'day All, This is my first post so I'd like to thank those who make this list possible. I see this has been asked before but I could not find a complete answer in the archive or google. I want to setup a freeRADIUS server on a debian etch system to authenticate for a WRT54G AP using username/passwords only (no certificates). I've tried to use a few howtos and just ignore the certificates bit but no success yet. Does anyone know of a HowTo that I can use to get started? Thanking you in anticipation, build

4 8

log radius users
by stefek143 20 Nov '07

20 Nov '07

yes >Are you running server in debug mode (radiusd -X)? >Ivan Kalik >Kalik Informatika ISP >Dana 20/11/2007, "stefek143" <stefek143 at wp.pl> piše: >>ok, i set log_auth = yes and also i've uncomented detail_log and detail reply_log and everything what i have in file radius.log is "Tue Nov 20 20:38:14 2007 : Info: Using deprecated naslist file. Support for this will go away soon." and in another files " /radacct, radutmp , radwatch.log, radwtmp" i have nothing :/, what's wrong ? >> >> >>

2 1

log radius users
by stefek143 20 Nov '07

20 Nov '07

ok, i set log_auth = yes and also i've uncomented detail_log and detail reply_log and everything what i have in file radius.log is "Tue Nov 20 20:38:14 2007 : Info: Using deprecated naslist file. Support for this will go away soon." and in another files " /radacct, radutmp , radwatch.log, radwtmp" i have nothing :/, what's wrong ?

2 1

please help not allow the many connections from single user
by ann kok 20 Nov '07

20 Nov '07

Hi We has big problem to have many connections from single user in DSL clients A single user can authenticate on the different LNS server to use the internet connection. how can we prevent it? As our users are using the dynamic ip, the ip address is assigned by the LNS not the radius in this case, the ip pool can't be defined in the radius setting. Right? Can you help to give us detail info? thank you so much ____________________________________________________________________________________ Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/

4 12