Radius don't write on MySQL radacct

[Felipe Neuwald]

Ivan,

Isn't it. I'm sure that this is the only radius on these server. Take a look:

[root at mercury /usr/local/etc/raddb]# /usr/local/etc/rc.d/./radiusd
stop ; sleep 2 ; mv radiusd.conf radiusd.conf-TEST ;
/usr/local/etc/rc.d/./radiusd start
Stopping radiusd.
Waiting for PIDS: 37257.
/usr/local/etc/rc.d/./radiusd: WARNING:
/usr/local/etc/raddb/radiusd.conf is not readable.
[root at mercury /usr/local/etc/raddb]# mv radiusd.conf-TEST radiusd.conf
; /usr/local/etc/rc.d/./radiusd start
Starting radiusd.
Mon Sep 15 13:31:30 2008 : Info: Starting - reading configuration files ...

Felipe.

2008/9/12  <tnt at kalik.net>:
> I am afraid that you have more than one freeradius server installed. That
> radiusd.conf doesn't belong to the process that produced initiall debug:
>
> rad_recv: Accounting-Request packet from host 201.10.4.34:64765, id=242,
> length=242
>        Acct-Session-Id = "8/0/3/125.144_03938839"
>        Cisco-AVPair = "client-mac-address=0090.d000.e616"
>        Cisco-Attr-37 = 0x424553542d4546464f5254
>        Framed-Protocol = PPP
>        Framed-IP-Address = 201.34.169.60
>        Cisco-AVPair = "connect-progress=LAN Ses Up"
>        Acct-Authentic = RADIUS
>        Acct-Status-Type = Start
>        NAS-Port-Type = Virtual
>        NAS-Port = 2206007440
>        NAS-Port-Id = "8/0/3/125.144"
>        Connect-Info = "PPPoE"
>        Service-Type = Framed-User
>        NAS-IP-Address = 201.14.143.254
>        Event-Timestamp = "Sep 12 2008 11:41:19 BRT"
>        Acct-Delay-Time = 0
>        NAS-Identifier = "BNUT3702"
>        User-Name = "triangulo"
>  Processing the preacct section of radiusd.conf
> modcall: entering group preacct for request 36
>  modcall[preacct]: module "preprocess" returns noop for request 36
> rlm_acct_unique: Hashing 'NAS-Port = 2206007440,Client-IP-Address =
> 201.10.4.34,NAS-IP-Address = 201.14.143.254,Acct-Session-Id =
> "8/0/3/125.144_03938839",User-Name = "triangulo"'
> rlm_acct_unique: Acct-Unique-Session-ID = "90e600da65533734".
>  modcall[preacct]: module "acct_unique" returns ok for request 36
>    rlm_realm: No '@' in User-Name = "triangulo", looking up realm
> NULL
>    rlm_realm: No such realm "NULL"
>  modcall[preacct]: module "suffix" returns noop for request 36
>  modcall[preacct]: module "files" returns noop for request 36
> modcall: leaving group preacct (returns ok) for request 36
>  Processing the accounting section of radiusd.conf
> modcall: entering group accounting for request 36
> radius_xlat:  '/var/log/radacct/201.10.4.34/detail-20080912'
> rlm_detail: /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d expands
> to /var/log/radacct/201.10.4.34/detail-20080912
>  modcall[accounting]: module "detail" returns ok for request 36
>  modcall[accounting]: module "unix" returns fail for request 36
> modcall: leaving group accounting (returns fail) for request 36
> Finished request 36
>
> sql module is never called.
>
> Find where is the installation which belongs to the radiusd.conf that you
> have posted and start that radiusd instance.
>
> Ivan Kalik
> Kalik Informatika ISP
>
>
> Dana 12/9/2008, "Felipe Neuwald" <felipebgn at gmail.com> piše:
>
>>Ivan,
>>
>>I hope sql is listed in accouting section. Take a look:
>>
>>radiusd.conf: http://pastebin.ca/1201150
>>sql.conf: http://pastebin.ca/1201151
>>
>>Felipe.
>>
>>2008/9/12  <tnt at kalik.net>:
>>> sql is not listed in accounting section. Or it's commented out.
>>>
>>> Ivan Kalik
>>> Kalik Informatika ISP
>>>
>>>
>>> Dana 12/9/2008, "Felipe Neuwald" <felipebgn at gmail.com> piše:
>>>
>>>>Hi all,
>>>>
>>>>I have one FreeRADIUS 1.1.7_2 server running on a FreeBSD 6.2-STABLE
>>>>box, and other FreeBSD 6.3-STABLE box running MySQL 5.0.51a.
>>>>
>>>>These RADIUS system, are running at least for one year, and I got no
>>>>problems, but now, since one month ago, I have no write on radacct
>>>>table. Here is the result of radiusd -X: http://pastebin.ca/1201080
>>>>
>>>>Does anybody knows what does it could be?
>>>>
>>>>Thank you very much,
>>>>
>>>>Felipe Neuwald.
>>>>-
>>>>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>>>>
>>>>
>>>
>>> -
>>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>>>
>>
>>-
>>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>>
>>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>