Re: Freeradius-Users Digest, Vol 46, Issue 102 Why is groupname field blank in radacct
Hallo all, First of all thanks Kalik for your responses. I checked the link you you sent but I couldn't get the info I am looking for. Let me expand further on the problem:- I have MySQL 5.0.67 and PostgreSQL 8.3.6 and freeRADIUS 2.17 installed on GNU/Linux Fedora 10 distribution. I have identical radius databases on both MySQL and PostgreSQL. When I use the PostgreSQL, the groupname field in the radacct table gets filled in but when I change the database to MySQL, the groupname filled is blank. I checked the queries in mysql/diaup.conf and postgresql/dialup.conf and found out that they are the same. Why is it working with PostgreSQL and not working with MySQL? The groupnames are defined in radusergroup table. May you help me on a step by step basis on how to solve this problem. THank you 2009/2/25 <freeradius-users-request@lists.freeradius.org>
Send Freeradius-Users mailing list submissions to freeradius-users@lists.freeradius.org
To subscribe or unsubscribe via the World Wide Web, visit http://lists.freeradius.org/mailman/listinfo/freeradius-users or, via email, send a message with subject or body 'help' to freeradius-users-request@lists.freeradius.org
You can reach the person managing the list at freeradius-users-owner@lists.freeradius.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of Freeradius-Users digest..."
Today's Topics:
1. Re: Freeradius-Users Digest, Vol 46, Issue 98 : Why is groupnamefield blank in radacct (tnt@kalik.net) 2. Re: Error: WARNING: Unresponsive child for request in module sqlcomponent accounting (magicboiz) 3. Rlm_sqlcounter log problem (Devrim Seral) 4. Re: Error: WARNING: Unresponsive child for request in modulesqlcomponent accounting (tnt@kalik.net) 5. Re: Rlm_sqlcounter log problem (Juan Pablo Botero) 6. Re: Freeradius dies with Postgresql error (Alan DeKok) 7. Re: FR 2.1.3 and ASSERT FAILED event.c (Alan DeKok) 8. Re: Rlm_sqlcounter log problem (tnt@kalik.net) 9. Re: Wired 802.1x auth - Getting the IP address of the authed machine (Alexander Clouter)
----------------------------------------------------------------------
Message: 1 Date: Wed, 25 Feb 2009 15:21:20 +0100 From: <tnt@kalik.net> Subject: Re: Freeradius-Users Digest, Vol 46, Issue 98 : Why is groupnamefield blank in radacct To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Message-ID: <gS8vCrCQ.1235571680.7009450.tnt@kalik.net> Content-Type: text/plain; charset=ISO-8859-2
I tried editing the dialup.conf and added groupname with a value of '%{SQL-Group}' but still it writes nothing for the groupname in the radacct table. Can you help me as to how exactly I have to edit the dialup.conf ?
That is fine, only the attribute is wrong. ASFAIK Class is the only attribute that you can custom set during authentication that NAS will have to send back in accounting packet.
http://freeradius.org/rfc/rfc2865.html#Class
Ivan Kalik Kalik Informatika ISP
------------------------------
Message: 2 Date: Wed, 25 Feb 2009 15:40:04 +0100 From: magicboiz <magicboiz@gmail.com> Subject: Re: Error: WARNING: Unresponsive child for request in module sqlcomponent accounting To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Message-ID: <200902251540.04783.magicboiz@gmail.com> Content-Type: text/plain; charset="iso-8859-1"
Thx Ivan,
and do you know if the accouting registers is lost? or another child retries the insert into the database?
thx Regards
On Mi?rcoles 25 Febrero 2009 14:09:44 tnt@kalik.net wrote:
I facing this problem with my Freeradius 2.1.3, and I don't know how to solve it :(
My NAS is sending only accounting registers to my freeradius server. My freeradius server, is configured to store these registers into a MySQL server. I have configured "max_request_time = 120", in the case of MySQL slow performance, but the problem perssits.
No, you don't have a problem with radius server but with sql one. Perhaps you should look into the server that does have a problem (sql) and not the one that doesn't (radius). There is nothing radius server can tell you about why are sql queries running slow.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------
Message: 3 Date: Wed, 25 Feb 2009 16:51:46 +0200 From: Devrim Seral <dseral@gmail.com> Subject: Rlm_sqlcounter log problem To: freeradius-users@lists.freeradius.org Message-ID: <416697d80902250651s7ed9e1earb3cd4ca611c27748@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
Hi all, I have a little problem with freeradius. And i can't find any solution for it.. We have logged failed login attempt following statement: (Its taken from Freeradius Wiki) Post-Auth-Type REJECT { # Login failed: log to SQL database. sql }
However when we use rlm_sqlcounter this modle can't handled with above statement.
So how its possible to log users that Rejected by rlm_sqlcounter module? Regards.. devrim
------------------------------
Message: 4 Date: Wed, 25 Feb 2009 15:53:36 +0100 From: <tnt@kalik.net> Subject: Re: Error: WARNING: Unresponsive child for request in modulesqlcomponent accounting To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Message-ID: <WfvWLTm6.1235573616.3312510.tnt@kalik.net> Content-Type: text/plain; charset=ISO-8859-2
and do you know if the accouting registers is lost? or another child retries the insert into the database?
They usually are - there are no handles to write to the database as the whole server gets blocked. I haven't seen tha case where single handle would dia and the rest of them would continue working. This is usually terminal state of radius-sql server connection problem.
Ivan Kalik Kalik Informatika ISP
------------------------------
Message: 5 Date: Wed, 25 Feb 2009 09:54:35 -0500 From: Juan Pablo Botero <juanpabloboterolopez@gmail.com> Subject: Re: Rlm_sqlcounter log problem To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Message-ID: <aaa6fffc0902250654t7355ae6bt315ff0cd3f706324@mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1"
In My case, that it's not necesary, you can comment out that lines; and probe with 'freeradius -X'
On Wed, Feb 25, 2009 at 9:51 AM, Devrim Seral <dseral@gmail.com> wrote:
Hi all, I have a little problem with freeradius. And i can't find any solution for it.. We have logged failed login attempt following statement: (Its taken from Freeradius Wiki) Post-Auth-Type REJECT { # Login failed: log to SQL database. sql }
However when we use rlm_sqlcounter this modle can't handled with above statement.
So how its possible to log users that Rejected by rlm_sqlcounter module? Regards.. devrim - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Juan Pablo Botero Administrador de Sistemas inform?ticos http://jpill.wordpress.com eSSuX: http://slcolombia.org/eSSuX Linux Registered user #435293
I have MySQL 5.0.67 and PostgreSQL 8.3.6 and freeRADIUS 2.17 installed on GNU/Linux Fedora 10 distribution. I have identical radius databases on both MySQL and PostgreSQL. When I use the PostgreSQL, the groupname field in the radacct table gets filled in but when I change the database to MySQL, the groupname filled is blank. I checked the queries in mysql/diaup.conf and postgresql/dialup.conf and found out that they are the same. Why is it working with PostgreSQL and not working with MySQL? The groupnames are defined in radusergroup table.
Default queries that come with the source don't write to groupname field. MySQL or PostgreSQL. You can place Class in radgroupreply and give it the value of the group name. Then put %{Class} into groupname field in accounting queries. Ivan Kalik Kalik Informatika ISP
participants (2)
-
ngwarai zed -
tnt＠kalik.net