- Freeradius-Devel - lists.freeradius.org

SQLite driver
by Brad Robel-Forrest 27 Jul '07

27 Jul '07

I've written and am in the process of testing a SQLite3 driver for FreeRADIUS. I found a previous post (http://lists.freeradius.org/ mailman/htdig/freeradius-devel/2007-March/010852.html) but the link provided is dead. Is there a current effort to provide such a driver already? If not, I'll post the one I have after cleaning it up a bit. -brad

3 3

Automatic report from sources (radiusd) between 26.07.2007 - 27.07.2007 GMT
by Automatic cvs log generator 27 Jul '07

27 Jul '07

CVS log entries from 26.07.2007 (Thu) 08:00:00 - 27.07.2007 (Fri) 08:00:01 GMT ===================================================== Summary by authors ===================================================== Author: aland File: radiusd/doc/rlm_sql; Revisions: 1.8, 1.3.4.2.2.1 ===================================================== Combined list of identical log entries ===================================================== Description: Removed link to outdated documentation Modified files: File: radiusd/doc/rlm_sql; Revision: 1.8; Date: 2007/07/26 20:58:49; Author: aland; Lines: (+0 -7) File: radiusd/doc/rlm_sql; Revision: 1.3.4.2.2.1; Date: 2007/07/26 20:58:20; Author: aland; Lines: (+0 -7) ===================================================== Log entries ===================================================== ===================================================== Summary of modified files ===================================================== File: radiusd/doc/rlm_sql Revisions: 1.8, 1.3.4.2.2.1 Authors: aland (+0 -7), aland (+0 -7) -- Automatic cron job from /web/pages/us.freeradius.org/bin/new_makelog.pl

1 0

Ulang debug issue with CVS Head
by Stephan Jaeger 26 Jul '07

26 Jul '07

Hi, i have an issue with unlang. radiusd.conf, authorize section: update request { User-Name = "xyz" } Gives the following debug output: +++[request] returns notfound But in modcall.c line 401: rcode = radius_update_attrlist(request, g->cs, g->vps, child->name); rcode is really RLM_MODULE_UPDATED. its just that (modcall.c line 403): if (rcode != RLM_MODULE_UPDATED) { myresult = rcode; } is not altering the result in this case, which lets it on its default value for the Autz section: RLM_MODULE_NOTFOUND. Is this behavior intended? Regards Stephan -- Stephan Jaeger <stephan.jaeger(a)ewetel.de> EWE TEL GmbH

2 1

Automatic report from sources (radiusd) between 25.07.2007 - 26.07.2007 GMT
by Automatic cvs log generator 26 Jul '07

26 Jul '07

CVS log entries from 25.07.2007 (Wed) 08:00:01 - 26.07.2007 (Thu) 08:00:00 GMT ===================================================== Summary by authors ===================================================== Author: pnixon File: radiusd/raddb/sql/postgresql/ippool.conf; Revisions: 1.4, 1.3, 1.2 File: radiusd/raddb/sql/postgresql/ippool.sql; Revisions: 1.2 ===================================================== Log entries ===================================================== Description: Re-order query. Makes no real difference, but makes it easier to understand, and may possibly help out th Postgres query planner a little Modified files: File: radiusd/raddb/sql/postgresql/ippool.conf; Revision: 1.4; Date: 2007/07/26 06:48:36; Author: pnixon; Lines: (+3 -3) ------------------------------- Description: Remove needless spaces in the queries Modified files: File: radiusd/raddb/sql/postgresql/ippool.conf; Revision: 1.3; Date: 2007/07/25 23:39:45; Author: pnixon; Lines: (+3 -3) ------------------------------- Description: Switch nasipaddress and pool_key to match other queries (and hopefully give the postgresql index optimizser less work) Modified files: File: radiusd/raddb/sql/postgresql/ippool.conf; Revision: 1.2; Date: 2007/07/25 23:32:12; Author: pnixon; Lines: (+3 -3) ------------------------------- Description: More performant indexes Modified files: File: radiusd/raddb/sql/postgresql/ippool.sql; Revision: 1.2; Date: 2007/07/26 06:49:52; Author: pnixon; Lines: (+2 -4) ===================================================== Summary of modified files ===================================================== File: radiusd/raddb/sql/postgresql/ippool.conf Revisions: 1.4, 1.3, 1.2 Authors: pnixon (+3 -3), pnixon (+3 -3), pnixon (+3 -3) ------------------------------- File: radiusd/raddb/sql/postgresql/ippool.sql Revisions: 1.2 Authors: pnixon (+2 -4) -- Automatic cron job from /web/pages/us.freeradius.org/bin/new_makelog.pl

1 0

Releasing 1.1.7
by Alan DeKok 24 Jul '07

24 Jul '07

The MS-CHAP bug has been fixed. The "use_tunneled_reply" bug has been fixed. SQL procedures in MySQL now work. Any objection to releasing 1.1.7? Alan DeKok.

7 25

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