Radius don't write on MySQL radacct

[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
>
>