July 2007 - Freeradius-Devel - lists.freeradius.org

State machine implementation
by Diana Robert 24 Jul '07

24 Jul '07

Hi, Is there any state machine implementation of freeradius. Thanks Regards, Diana Robert --------------------------------- Download prohibited? No problem. CHAT from any browser, without download.

2 1

Automatic report from sources (radiusd) between 23.07.2007 - 24.07.2007 GMT
by Automatic cvs log generator 24 Jul '07

24 Jul '07

CVS log entries from 23.07.2007 (Mon) 08:00:01 - 24.07.2007 (Tue) 08:00:01 GMT ===================================================== Summary by authors ===================================================== Author: pnixon File: radiusd/raddb/sql/mysql/schema.sql; Revisions: 1.5 File: radiusd/raddb/sql/mysql/ippool.conf; Revisions: 1.3, 1.2 File: radiusd/raddb/sql/mysql/ippool.sql; Revisions: 1.3, 1.2 File: radiusd/raddb/sql/mysql/dialup.conf; Revisions: 1.2 File: radiusd/raddb/sql/mysql/counter.conf; Revisions: 1.2 ===================================================== Combined list of identical log entries ===================================================== Description: Lowercase everything to avoid incompatibility issues with MySQL on Windows Modified files: File: radiusd/raddb/sql/mysql/counter.conf; Revision: 1.2; Date: 2007/07/23 14:34:26; Author: pnixon; Lines: (+17 -17) File: radiusd/raddb/sql/mysql/dialup.conf; Revision: 1.2; Date: 2007/07/23 14:34:27; Author: pnixon; Lines: (+80 -80) File: radiusd/raddb/sql/mysql/ippool.conf; Revision: 1.3; Date: 2007/07/23 14:34:27; Author: pnixon; Lines: (+24 -24) File: radiusd/raddb/sql/mysql/ippool.sql; Revision: 1.3; Date: 2007/07/23 14:34:27; Author: pnixon; Lines: (+4 -4) File: radiusd/raddb/sql/mysql/schema.sql; Revision: 1.5; Date: 2007/07/23 14:34:27; Author: pnixon; Lines: (+54 -54) ===================================================== Log entries ===================================================== Description: Fix capitalisation of NASIPAddress so that MySQL on windows works Modified files: File: radiusd/raddb/sql/mysql/ippool.conf; Revision: 1.2; Date: 2007/07/23 10:17:30; Author: pnixon; Lines: (+2 -2) ------------------------------- Description: Add defaults Modified files: File: radiusd/raddb/sql/mysql/ippool.sql; Revision: 1.2; Date: 2007/07/23 10:19:48; Author: pnixon; Lines: (+3 -3) ===================================================== Summary of modified files ===================================================== File: radiusd/raddb/sql/mysql/counter.conf Revisions: 1.2 Authors: pnixon (+17 -17) ------------------------------- File: radiusd/raddb/sql/mysql/dialup.conf Revisions: 1.2 Authors: pnixon (+80 -80) ------------------------------- File: radiusd/raddb/sql/mysql/ippool.conf Revisions: 1.3, 1.2 Authors: pnixon (+24 -24), pnixon (+2 -2) ------------------------------- File: radiusd/raddb/sql/mysql/ippool.sql Revisions: 1.3, 1.2 Authors: pnixon (+4 -4), pnixon (+3 -3) ------------------------------- File: radiusd/raddb/sql/mysql/schema.sql Revisions: 1.5 Authors: pnixon (+54 -54) -- Automatic cron job from /web/pages/us.freeradius.org/bin/new_makelog.pl

1 0

SQL config file names
by Peter Nixon 23 Jul '07

23 Jul '07

Hi Guys Over the last few months I have been trying to clean up the SQL config files ready for the 2.0 release. We currently have the following in raddb/sql/ mssql-dialup.conf mysql-dialup.conf mysql-ippool-dialup.conf mysql-sqlcounter.conf oracle-dialup.conf postgresql-dialup.conf postgresql-ippool-dialup.conf postgresql-sqlcounter.conf postgresql-voip-postpaid.conf The question is, is it best to do it this way with the database name first, or should we put the database name last, just before the .conf. For example "raddb/sql/counter-mysql.conf" What do you all think? Cheers -- Peter Nixon http://peternixon.net/

4 18

rlm_sql_mysql - sql_finish_select_query - multiples results sets
by Jean DERAM 23 Jul '07

23 Jul '07

Hi FR-dev, I'm working on FR 1.1.6 and mysql 5.0 I wan't to work with stored procedure in mysql. So as I read on this list there is some tuning of mysql connection flags to do. So I back ported rlm_sql_mysql from today snapshot (19/07/07) to FR 1.1.6 It works well but I have one problem: - In mysql radreply I have an attribute which look like this : AA-NAME = "My value" (this is a sample). - In sql.conf I don't do a SELECT for authorize_reply_query but I call my stored procedure: authorize_reply_query = "CALL p_authorize_reply('%{SQL-User-Name}','%{NAS-IP-Address}','%{Called-Station-Id}')" p_authorize_reply return all attributes in radreply. AA-NAME attribute is not in dictionary so in sql.c in function sql_getvpdata when FR try sql_userparse it failed and says : Error: rlm_sql: Failed to create the pair: Unknown attribute "AA-NAME" Then FR launch: (inst->module->sql_finish_select_query)(sqlsocket, inst->config); But sql_finish_select_query doesn't handle the fact that the statement is perhaps a multiple results set (as sql_finish_query in today snapshot does). So after the sql_finish_select_query the connection throw out of sync (error 2014) on all the next queries. Debug: rlm_sql_mysql: MYSQL check_error: 2014 received => Database query error - Commands out of sync; you can't run this command now The connection never return to a synced state. I've duplicated the code of sql_finish_query in sql_finish_select_query to care of multiple results set and then it works. What do you think about this? Note: I know that this is the bad Attribut that break the mysql state, but I wonder if it's right that sql_finish_select_query should care of multiple results set as sql_finish_query or not. Thanks Jean DERAM

3 5

Automatic report from sources (radiusd) between 19.07.2007 - 20.07.2007 GMT
by Automatic cvs log generator 23 Jul '07

23 Jul '07

CVS log entries from 19.07.2007 (Thu) 08:00:00 - 20.07.2007 (Fri) 08:00:02 GMT ===================================================== Summary by authors ===================================================== Author: nbk File: radiusd/aclocal.m4; Revisions: 1.33 Author: pnixon File: radiusd/raddb/sql/postgresql-sqlcounter.conf; Revisions: 1.2 File: radiusd/raddb/radiusd.conf.in; Revisions: 1.250 File: radiusd/raddb/sql/postgresql/counter.conf; Revisions: 1.1 File: radiusd/raddb/sql/mysql-sqlcounter.conf; Revisions: 1.2 File: radiusd/raddb/Makefile; Revisions: 1.28 File: radiusd/raddb/sql/mysql/counter.conf; Revisions: 1.1 ===================================================== Combined list of identical log entries ===================================================== Description: Move sqlcounter config files into dialect specific subdirs Modified files: File: radiusd/raddb/Makefile; Revision: 1.28; Date: 2007/07/19 23:32:46; Author: pnixon; Lines: (+2 -2) File: radiusd/raddb/radiusd.conf.in; Revision: 1.250; Date: 2007/07/19 23:32:46; Author: pnixon; Lines: (+3 -3) File: radiusd/raddb/sql/mysql-sqlcounter.conf; Revision: 1.2; Date: 2007/07/19 23:32:47; Author: pnixon; Lines: (+1 -1) File: radiusd/raddb/sql/postgresql-sqlcounter.conf; Revision: 1.2; Date: 2007/07/19 23:32:47; Author: pnixon; Lines: (+1 -1) File: radiusd/raddb/sql/mysql/counter.conf; Revision: 1.1; Date: 2007/07/19 23:32:47; Author: pnixon; File: radiusd/raddb/sql/postgresql/counter.conf; Revision: 1.1; Date: 2007/07/19 23:32:47; Author: pnixon; ===================================================== Log entries ===================================================== Description: Regenerate from configure.in using aclocal 1.10 Modified files: File: radiusd/aclocal.m4; Revision: 1.33; Date: 2007/07/19 21:31:03; Author: nbk; Lines: (+6 -8) ===================================================== Summary of modified files ===================================================== File: radiusd/aclocal.m4 Revisions: 1.33 Authors: nbk (+6 -8) ------------------------------- File: radiusd/raddb/Makefile Revisions: 1.28 Authors: pnixon (+2 -2) ------------------------------- File: radiusd/raddb/radiusd.conf.in Revisions: 1.250 Authors: pnixon (+3 -3) ------------------------------- File: radiusd/raddb/sql/mysql-sqlcounter.conf Revisions: 1.2 Authors: pnixon (+1 -1) ------------------------------- File: radiusd/raddb/sql/mysql/counter.conf Revisions: 1.1 Authors: pnixon ------------------------------- File: radiusd/raddb/sql/postgresql-sqlcounter.conf Revisions: 1.2 Authors: pnixon (+1 -1) ------------------------------- File: radiusd/raddb/sql/postgresql/counter.conf Revisions: 1.1 Authors: pnixon -- Automatic cron job from /web/pages/us.freeradius.org/bin/new_makelog.pl

6 6

Automatic report from sources (radiusd) between 21.07.2007 - 22.07.2007 GMT
by Automatic cvs log generator 22 Jul '07

22 Jul '07

CVS log entries from 21.07.2007 (Sat) 08:00:00 - 22.07.2007 (Sun) 08:00:00 GMT ===================================================== Summary by authors ===================================================== Author: aland File: radiusd/share/dictionary.3com; Revisions: 1.7, 1.3.2.1.2.2 Author: nbk File: radiusd/debian/rules; Revisions: 1.54.2.16.2.8 File: radiusd/aclocal.m4; Revisions: 1.24.2.2.2.4 File: radiusd/acinclude.m4; Revisions: 1.11 File: radiusd/configure; Revisions: 1.95.2.12.2.16 ===================================================== Combined list of identical log entries ===================================================== Description: Terrible hack to make "./configure --config-cache" work again. Modified files: File: radiusd/acinclude.m4; Revision: 1.11; Date: 2007/07/21 13:42:39; Author: nbk; Lines: (+10 -0) File: radiusd/aclocal.m4; Revision: 1.24.2.2.2.4; Date: 2007/07/21 13:42:59; Author: nbk; Lines: (+10 -0) ===================================================== Log entries ===================================================== Description: Regenerate from aclocal.m4 Modified files: File: radiusd/configure; Revision: 1.95.2.12.2.16; Date: 2007/07/21 14:01:34; Author: nbk; Lines: (+6 -1) ------------------------------- Description: "./configure --config-cache" is working again. Modified files: File: radiusd/debian/rules; Revision: 1.54.2.16.2.8; Date: 2007/07/21 14:02:52; Author: nbk; Lines: (+1 -0) ------------------------------- Description: As posted to the list Modified files: File: radiusd/share/dictionary.3com; Revision: 1.7; Date: 2007/07/21 10:09:04; Author: aland; Lines: (+9 -1) ------------------------------- Description: Pulled from CVS head Modified files: File: radiusd/share/dictionary.3com; Revision: 1.3.2.1.2.2; Date: 2007/07/21 10:09:32; Author: aland; Lines: (+9 -1) ===================================================== Summary of modified files ===================================================== File: radiusd/acinclude.m4 Revisions: 1.11 Authors: nbk (+10 -0) ------------------------------- File: radiusd/aclocal.m4 Revisions: 1.24.2.2.2.4 Authors: nbk (+10 -0) ------------------------------- File: radiusd/configure Revisions: 1.95.2.12.2.16 Authors: nbk (+6 -1) ------------------------------- File: radiusd/debian/rules Revisions: 1.54.2.16.2.8 Authors: nbk (+1 -0) ------------------------------- File: radiusd/share/dictionary.3com Revisions: 1.7, 1.3.2.1.2.2 Authors: aland (+9 -1), aland (+9 -1) -- Automatic cron job from /web/pages/us.freeradius.org/bin/new_makelog.pl

1 0

Automatic report from sources (radiusd) between 20.07.2007 - 21.07.2007 GMT
by Automatic cvs log generator 21 Jul '07

21 Jul '07

CVS log entries from 20.07.2007 (Fri) 08:00:02 - 21.07.2007 (Sat) 08:00:00 GMT ===================================================== Summary by authors ===================================================== Author: aland File: radiusd/doc/examples/postgresql.sql; Revisions: 1.14 File: radiusd/doc/examples/oracle.sql; Revisions: 1.9 File: radiusd/doc/examples/mysql.sql; Revisions: 1.8 File: radiusd/raddb/Makefile; Revisions: 1.29 File: radiusd/raddb/sql/postgresql/nas.sql; Revisions: 1.1 File: radiusd/raddb/sql/postgresql-voip-postpaid.conf; Revisions: 1.3 File: radiusd/raddb/sql/oracle/nas.sql; Revisions: 1.1 File: radiusd/raddb/sql/mysql/nas.sql; Revisions: 1.1 File: radiusd/raddb/sql.conf; Revisions: 1.59, 1.58 File: radiusd/raddb/sql/postgresql/voip-postpaid.conf; Revisions: 1.1 File: radiusd/raddb/radiusd.conf.in; Revisions: 1.251 File: radiusd/raddb/sql/postgresql/ippool.conf; Revisions: 1.1 File: radiusd/raddb/sql/mysql/ippool.conf; Revisions: 1.1 File: radiusd/raddb/sql/mssql/schema.sql; Revisions: 1.1 File: radiusd/raddb/sql/mssql-dialup.conf; Revisions: 1.3 File: radiusd/raddb/sql/postgresql/schema.sql; Revisions: 1.4, 1.3, 1.2, 1.1 File: radiusd/raddb/sql/mssql/dialup.conf; Revisions: 1.1 File: radiusd/raddb/sql/postgresql/update_radacct_group_trigger.sql; Revisions: 1.1 File: radiusd/raddb/sql/postgresql/ippool.sql; Revisions: 1.1 File: radiusd/raddb/sql/oracle/schema.sql; Revisions: 1.4, 1.3, 1.2, 1.1 File: radiusd/raddb/sql/mysql/schema.sql; Revisions: 1.4, 1.3, 1.2, 1.1 File: radiusd/raddb/sql/postgresql-dialup.conf; Revisions: 1.6 File: radiusd/raddb/sql/postgresql-ippool-dialup.conf; Revisions: 1.6 File: radiusd/raddb/sql/postgresql/dialup.conf; Revisions: 1.1 File: radiusd/raddb/sql/oracle/ippool.sql; Revisions: 1.1 File: radiusd/raddb/sql/mysql/ippool.sql; Revisions: 1.1 File: radiusd/doc/examples/mssql.sql; Revisions: 1.7 File: radiusd/raddb/sql/mysql-dialup.conf; Revisions: 1.6 File: radiusd/raddb/sql/mysql-ippool-dialup.conf; Revisions: 1.8 File: radiusd/raddb/sql/oracle-dialup.conf; Revisions: 1.3 File: radiusd/raddb/sql/oracle/dialup.conf; Revisions: 1.1 File: radiusd/raddb/sql/mysql/dialup.conf; Revisions: 1.1 Author: nbk File: radiusd/src/modules/rlm_sql/drivers/rlm_sql_mysql/sql_mysql.c; Revisions: 1.27, 1.18.4.3 Author: pnixon File: radiusd/raddb/sql/postgresql/dialup.conf; Revisions: 1.4, 1.3, 1.2 ===================================================== Combined list of identical log entries ===================================================== Description: Moved more files Modified files: File: radiusd/raddb/sql/mysql-ippool-dialup.conf; Revision: 1.8; Date: 2007/07/20 11:17:33; Author: aland; Lines: (+1 -1) File: radiusd/raddb/sql/postgresql-ippool-dialup.conf; Revision: 1.6; Date: 2007/07/20 11:17:33; Author: aland; Lines: (+1 -1) File: radiusd/raddb/sql/mysql/ippool.conf; Revision: 1.1; Date: 2007/07/20 11:17:34; Author: aland; File: radiusd/raddb/sql/postgresql/ippool.conf; Revision: 1.1; Date: 2007/07/20 11:17:34; Author: aland; ------------------------------- Description: Moved $(db)-dialup.conf to $(db)/dialup.conf. Modified files: File: radiusd/raddb/sql/mssql-dialup.conf; Revision: 1.3; Date: 2007/07/20 11:10:22; Author: aland; Lines: (+1 -1) File: radiusd/raddb/sql/mysql-dialup.conf; Revision: 1.6; Date: 2007/07/20 11:10:23; Author: aland; Lines: (+1 -1) File: radiusd/raddb/sql/oracle-dialup.conf; Revision: 1.3; Date: 2007/07/20 11:10:23; Author: aland; Lines: (+1 -1) File: radiusd/raddb/sql/postgresql-dialup.conf; Revision: 1.6; Date: 2007/07/20 11:10:23; Author: aland; Lines: (+1 -1) File: radiusd/raddb/sql/mssql/dialup.conf; Revision: 1.1; Date: 2007/07/20 11:10:23; Author: aland; File: radiusd/raddb/sql/oracle/dialup.conf; Revision: 1.1; Date: 2007/07/20 11:10:24; Author: aland; File: radiusd/raddb/sql/postgresql/dialup.conf; Revision: 1.1; Date: 2007/07/20 11:10:24; Author: aland; ------------------------------- Description: Move the ippool schema to its own files Modified files: File: radiusd/raddb/sql/mysql/ippool.sql; Revision: 1.1; Date: 2007/07/20 12:51:07; Author: aland; File: radiusd/raddb/sql/mysql/schema.sql; Revision: 1.2; Date: 2007/07/20 12:51:08; Author: aland; Lines: (+1 -17) File: radiusd/raddb/sql/oracle/ippool.sql; Revision: 1.1; Date: 2007/07/20 12:51:08; Author: aland; File: radiusd/raddb/sql/oracle/schema.sql; Revision: 1.2; Date: 2007/07/20 12:51:08; Author: aland; Lines: (+1 -29) File: radiusd/raddb/sql/postgresql/ippool.sql; Revision: 1.1; Date: 2007/07/20 12:51:08; Author: aland; File: radiusd/raddb/sql/postgresql/schema.sql; Revision: 1.2; Date: 2007/07/20 12:51:08; Author: aland; Lines: (+1 -22) ------------------------------- Description: When there is nonsense in the database, we may stop fetching the rows before reaching the last result of a multiple results set. Therefore we need to fetch the possibly pending results from the function sql_finish_select_query(). Problem spotted by Jean Deram <jderam(a)nordnet.fr> Modified files: File: radiusd/src/modules/rlm_sql/drivers/rlm_sql_mysql/sql_mysql.c; Revision: 1.27; Date: 2007/07/20 15:42:56; Author: nbk; Lines: (+18 -3) File: radiusd/src/modules/rlm_sql/drivers/rlm_sql_mysql/sql_mysql.c; Revision: 1.18.4.3; Date: 2007/07/20 15:43:18; Author: nbk; Lines: (+17 -2) ------------------------------- Description: Remove the dictionary tables. They're not used Modified files: File: radiusd/raddb/sql/mysql/schema.sql; Revision: 1.3; Date: 2007/07/20 12:52:45; Author: aland; Lines: (+1 -20) File: radiusd/raddb/sql/oracle/schema.sql; Revision: 1.3; Date: 2007/07/20 12:52:45; Author: aland; Lines: (+1 -14) File: radiusd/raddb/sql/postgresql/schema.sql; Revision: 1.3; Date: 2007/07/20 12:52:45; Author: aland; Lines: (+1 -14) ------------------------------- Description: Moved the NAS table to another schema file Modified files: File: radiusd/raddb/sql/mysql/nas.sql; Revision: 1.1; Date: 2007/07/20 12:54:34; Author: aland; File: radiusd/raddb/sql/mysql/schema.sql; Revision: 1.4; Date: 2007/07/20 12:54:35; Author: aland; Lines: (+1 -17) File: radiusd/raddb/sql/oracle/nas.sql; Revision: 1.1; Date: 2007/07/20 12:54:35; Author: aland; File: radiusd/raddb/sql/oracle/schema.sql; Revision: 1.4; Date: 2007/07/20 12:54:35; Author: aland; Lines: (+1 -17) File: radiusd/raddb/sql/postgresql/nas.sql; Revision: 1.1; Date: 2007/07/20 12:54:35; Author: aland; File: radiusd/raddb/sql/postgresql/schema.sql; Revision: 1.4; Date: 2007/07/20 12:54:35; Author: aland; Lines: (+1 -16) ------------------------------- Description: Moved file Modified files: File: radiusd/raddb/sql/postgresql-voip-postpaid.conf; Revision: 1.3; Date: 2007/07/20 12:56:32; Author: aland; Lines: (+0 -0) File: radiusd/raddb/sql/postgresql/voip-postpaid.conf; Revision: 1.1; Date: 2007/07/20 12:56:33; Author: aland; ------------------------------- Description: Moved schema files to sql/$(db) Modified files: File: radiusd/doc/examples/mssql.sql; Revision: 1.7; Date: 2007/07/20 11:15:21; Author: aland; Lines: (+1 -1) File: radiusd/doc/examples/mysql.sql; Revision: 1.8; Date: 2007/07/20 11:15:21; Author: aland; Lines: (+1 -1) File: radiusd/doc/examples/oracle.sql; Revision: 1.9; Date: 2007/07/20 11:15:22; Author: aland; Lines: (+1 -1) File: radiusd/doc/examples/postgresql.sql; Revision: 1.14; Date: 2007/07/20 11:15:22; Author: aland; Lines: (+1 -1) File: radiusd/raddb/sql/mssql/schema.sql; Revision: 1.1; Date: 2007/07/20 11:15:22; Author: aland; File: radiusd/raddb/sql/mysql/schema.sql; Revision: 1.1; Date: 2007/07/20 11:15:23; Author: aland; File: radiusd/raddb/sql/oracle/schema.sql; Revision: 1.1; Date: 2007/07/20 11:15:23; Author: aland; File: radiusd/raddb/sql/postgresql/schema.sql; Revision: 1.1; Date: 2007/07/20 11:15:23; Author: aland; File: radiusd/raddb/sql/postgresql/update_radacct_group_trigger.sql; Revision: 1.1; Date: 2007/07/20 11:15:23; Author: aland; ===================================================== Log entries ===================================================== Description: Create directories. "cp -R" isn't portable. Modified files: File: radiusd/raddb/Makefile; Revision: 1.29; Date: 2007/07/20 11:29:42; Author: aland; Lines: (+4 -1) ------------------------------- Description: File moved... Modified files: File: radiusd/raddb/radiusd.conf.in; Revision: 1.251; Date: 2007/07/20 12:57:43; Author: aland; Lines: (+2 -2) ------------------------------- Description: More cleanups Modified files: File: radiusd/raddb/sql.conf; Revision: 1.59; Date: 2007/07/20 13:08:03; Author: aland; Lines: (+8 -9) ------------------------------- Description: Use the new method to grab files Modified files: File: radiusd/raddb/sql.conf; Revision: 1.58; Date: 2007/07/20 11:23:00; Author: aland; Lines: (+23 -19) ------------------------------- Description: Didn't add this earlier Modified files: File: radiusd/raddb/sql/mysql/dialup.conf; Revision: 1.1; Date: 2007/07/20 13:28:14; Author: aland; ------------------------------- Description: fix unterminated quoted string Modified files: File: radiusd/raddb/sql/postgresql/dialup.conf; Revision: 1.4; Date: 2007/07/20 16:36:26; Author: pnixon; Lines: (+2 -2) ------------------------------- Description: More variable replacement fixes Modified files: File: radiusd/raddb/sql/postgresql/dialup.conf; Revision: 1.3; Date: 2007/07/20 16:25:43; Author: pnixon; Lines: (+6 -6) ------------------------------- Description: Update to new variable replacement syntax Modified files: File: radiusd/raddb/sql/postgresql/dialup.conf; Revision: 1.2; Date: 2007/07/20 16:23:37; Author: pnixon; Lines: (+18 -18) ===================================================== Summary of modified files ===================================================== File: radiusd/doc/examples/mssql.sql Revisions: 1.7 Authors: aland (+1 -1) ------------------------------- File: radiusd/doc/examples/mysql.sql Revisions: 1.8 Authors: aland (+1 -1) ------------------------------- File: radiusd/doc/examples/oracle.sql Revisions: 1.9 Authors: aland (+1 -1) ------------------------------- File: radiusd/doc/examples/postgresql.sql Revisions: 1.14 Authors: aland (+1 -1) ------------------------------- File: radiusd/raddb/Makefile Revisions: 1.29 Authors: aland (+4 -1) ------------------------------- File: radiusd/raddb/radiusd.conf.in Revisions: 1.251 Authors: aland (+2 -2) ------------------------------- File: radiusd/raddb/sql.conf Revisions: 1.59, 1.58 Authors: aland (+8 -9), aland (+23 -19) ------------------------------- File: radiusd/raddb/sql/mssql-dialup.conf Revisions: 1.3 Authors: aland (+1 -1) ------------------------------- File: radiusd/raddb/sql/mssql/dialup.conf Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/mssql/schema.sql Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/mysql-dialup.conf Revisions: 1.6 Authors: aland (+1 -1) ------------------------------- File: radiusd/raddb/sql/mysql-ippool-dialup.conf Revisions: 1.8 Authors: aland (+1 -1) ------------------------------- File: radiusd/raddb/sql/mysql/dialup.conf Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/mysql/ippool.conf Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/mysql/ippool.sql Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/mysql/nas.sql Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/mysql/schema.sql Revisions: 1.4, 1.3, 1.2, 1.1 Authors: aland (+1 -17), aland (+1 -20), aland (+1 -17), aland ------------------------------- File: radiusd/raddb/sql/oracle-dialup.conf Revisions: 1.3 Authors: aland (+1 -1) ------------------------------- File: radiusd/raddb/sql/oracle/dialup.conf Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/oracle/ippool.sql Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/oracle/nas.sql Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/oracle/schema.sql Revisions: 1.4, 1.3, 1.2, 1.1 Authors: aland (+1 -17), aland (+1 -14), aland (+1 -29), aland ------------------------------- File: radiusd/raddb/sql/postgresql-dialup.conf Revisions: 1.6 Authors: aland (+1 -1) ------------------------------- File: radiusd/raddb/sql/postgresql-ippool-dialup.conf Revisions: 1.6 Authors: aland (+1 -1) ------------------------------- File: radiusd/raddb/sql/postgresql-voip-postpaid.conf Revisions: 1.3 Authors: aland (+0 -0) ------------------------------- File: radiusd/raddb/sql/postgresql/dialup.conf Revisions: 1.4, 1.3, 1.2, 1.1 Authors: pnixon (+2 -2), pnixon (+6 -6), pnixon (+18 -18), aland ------------------------------- File: radiusd/raddb/sql/postgresql/ippool.conf Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/postgresql/ippool.sql Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/postgresql/nas.sql Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/postgresql/schema.sql Revisions: 1.4, 1.3, 1.2, 1.1 Authors: aland (+1 -16), aland (+1 -14), aland (+1 -22), aland ------------------------------- File: radiusd/raddb/sql/postgresql/update_radacct_group_trigger.sql Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/raddb/sql/postgresql/voip-postpaid.conf Revisions: 1.1 Authors: aland ------------------------------- File: radiusd/src/modules/rlm_sql/drivers/rlm_sql_mysql/sql_mysql.c Revisions: 1.27, 1.18.4.3 Authors: nbk (+18 -3), nbk (+17 -2) -- Automatic cron job from /web/pages/us.freeradius.org/bin/new_makelog.pl

1 0

2.0 teeny tiny ldap config fix
by Hugh Messenger 20 Jul '07

20 Jul '07

Hey Alan, Just one small change needed in the default ldap modules section of radiusd.conf: filter = "(uid=%{Stripped-User-Name:-%{User-Name}})" . needs to be . filter = "(uid=%{%{Stripped-User-Name}:-%{User-Name}})" Can I also suggest adding this right above/below that line: # If you are using a Windows AD, use 'sAMAccountName' instead of # 'uid' in the filter. You will also need to specify an identity # and password, as AD doesn't allow anonymous binding. Might save future generations a few precious minutes of their lives googling. -- hugh

1 0

CoA integration
by Peter Nixon 19 Jul '07

19 Jul '07

Hi Guys I am doing some work on cleaning up and integrating a CoA script and web interface to share its configuration with FreeRADIUS. Now, in future we are going to need some type of CoA support inside FreeRADIUS, so I want to make sure I do things in a way to works going forward. My initial issue is moving the list of CoA secrets I have from inside my python code into a place where FreeRADIUS can use the info also. Now, to me it makes sense to keep the CoA secret in the NAS table (or clients.conf) as a RADIUS client and a CoA server are almost always going to share information (ie. be the same thing) and in cases where they are not we could either leave out the CoA secret or the RADIUS shared secret.. With that logic I plan to add a "coasecret" field to the NAS table (same can be done for clients.conf). Does anyone have anything against this plan? Cheers -- Peter Nixon http://peternixon.net/

3 8

Automatic report from sources (radiusd) between 18.07.2007 - 19.07.2007 GMT
by Automatic cvs log generator 19 Jul '07

19 Jul '07

CVS log entries from 18.07.2007 (Wed) 08:00:01 - 19.07.2007 (Thu) 08:00:00 GMT ===================================================== Summary by authors ===================================================== Author: pnixon File: radiusd/src/modules/stable; Revisions: 1.9.4.5 ===================================================== Log entries ===================================================== Description: Add rlm_sqlippool to stable modules list Modified files: File: radiusd/src/modules/stable; Revision: 1.9.4.5; Date: 2007/07/18 20:02:18; Author: pnixon; Lines: (+1 -0) ===================================================== Summary of modified files ===================================================== File: radiusd/src/modules/stable Revisions: 1.9.4.5 Authors: pnixon (+1 -0) -- Automatic cron job from /web/pages/us.freeradius.org/bin/new_makelog.pl

1 0