Re: Acct-Type and MySQL
Luca Corti wrote:
On Tue, 2006-04-11 at 18:46 +0200, Nicolas Baradakis wrote:
You need to specify Acct-Type during preacct. It's doable if you
can write an acct_users file to set the Acct-Type.
Did you try to write an acct_users file? Try to distinguish your
group with the value of one or several attributes present in the
Accounting-Request.
Here is an example:
DEFAULT Some-Attribute == some value, Acct-Type := DIALUP
Here is the documentation:
http://freeradius.org/radiusd/doc/Acct-Type
If you need to do it with MySQL, I've seen a patch on the bugzilla.
http://bugs.freeradius.org/show_bug.cgi?id=264
Thanks a lot for the pointer. I've patched and installed FR 1.1.1.
Please try the first method. The second one is a last ressort
solution, since this patch is not part of FreeRADIUS.
Now I have set preaccounting query in my sql.conf file to
sql sql_generic {
...
preaccounting_query = SELECT Value FROM ${groupcheck_table} WHERE
Attribute = 'Acct-Type' LIMIT 1
}
I think the select statement should return 5 columns like the
authorize queries.
is this supposed to be correct? Unfortunately I get a segfault.
modcall[preacct]: module acct_unique returns ok for request 0
rlm_realm: No '@' in User-Name = gi-na-napoli-a, looking up realm
NULL
rlm_realm: No such realm NULL
modcall[preacct]: module suffix returns noop for request 0
radius_xlat: 'SELECT Value FROM radgroupcheck WHERE Attribute =
'Acct-Type' LIMIT 1'
rlm_sql (sql_generic): Reserving sql socket id: 3
Segmentation fault
I'd suggest to post your problems at the end of bug #224. You're using a
patch which isn't part of FreeRADIUS, so I can't help much.
--
Nicolas Baradakis
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
openldap version
Yes I think you can do USE_OPENLDAP_VER=2.0 (I think) in /etc/make.conf or TRY_OPENLDAP_VER,I don't know for sure.. oh are you using eap? My eap is failling.Were you able to create the ssl certificates in freeBSD?I couldn't.probably because of xpextensions. can you help me? Tried to upgrade current machine with: FreeBSB 4.11 OpenLDAP 2.0.X Freeradius 1.0.4 To Freeradius 1.1.1 using ports But it tried to install openldap 2.2.X as well... I want to used existing openldap (2.0.X) It is possible to force freeradius ports installation to use existing openldap client? TQ --haizam - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: openldap version
Look in /usr/ports/Mk/bsd.ports.mk the valid values for the WANT_OPENLDAP_VER variable; if 20 is a valid value then valorize the variable and export it before installing the port From: [EMAIL PROTECTED] Reply-To: FreeRadius users mailing list freeradius-users@lists.freeradius.org To: freeradius-users@lists.freeradius.org, [EMAIL PROTECTED] Subject: openldap version Date: Fri, 14 Apr 2006 15:18:37 +0100 Yes I think you can do USE_OPENLDAP_VER=2.0 (I think) in /etc/make.conf or TRY_OPENLDAP_VER,I don't know for sure.. oh are you using eap? My eap is failling.Were you able to create the ssl certificates in freeBSD?I couldn't.probably because of xpextensions. can you help me? Tried to upgrade current machine with: FreeBSB 4.11 OpenLDAP 2.0.X Freeradius 1.0.4 To Freeradius 1.1.1 using ports But it tried to install openldap 2.2.X as well... I want to used existing openldap (2.0.X) It is possible to force freeradius ports installation to use existing openldap client? TQ --haizam - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
