MySQL accounting issue

[Andy Smith]

Anyone any ideas? I repost this as the posts are in a messed up order on the 
forum page...

As per my previous mail, my current issue is that with accounting set to sql 
in radiusd.conf
the SQL statements are being written just to 
/usr/local/var/log/radius/sqltrace.sql
and nothing is actually put in the database... What have I done wrong?

thank u!

----- Original Message ----- 
From: "Andy Smith" <a.smith at ukgrid.net>
To: "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>
Sent: Monday, January 21, 2008 4:40 PM
Subject: Re: MySQL accounting issue


> Ok, Im seeing this from radiusd:
>
> rad_recv: Accounting-Request packet from host 89.107.16.10:35563, id=252, 
> length=145
>        Acct-Status-Type = Failed
>        Service-Type = IAPP-Register
>        Attr-102 = 0x00000194
>        Error-Cause = 32
>        Event-Timestamp = "Jan 21 2008 15:53:44 GMT"
>        Attr-105 = 0x61733264636462613764
>        Acct-Session-Id = "4c0392bd719422d06c5da35312950949 at 89.107.16.9"
>        Attr-108 = 0x38392e3130372e31362e39
>        Attr-109 = 0x35303630
>        NAS-Port = 5060
>        Acct-Delay-Time = 0
>        NAS-IP-Address = 89.107.16.10
>  Processing the preacct section of radiusd.conf
> modcall: entering group preacct for request 0
>  modcall[preacct]: module "preprocess" returns noop for request 0
> rlm_acct_unique: WARNING: Attribute User-Name was not found in request, 
> unique ID MAY be inconsistent
> rlm_acct_unique: Hashing 'NAS-Port = 5060,Client-IP-Address = 
> 89.107.16.10,NAS-IP-Address = 89.107.16.10,Acct-Session-Id = 
> "4c0392bd719422d06c5da35312950949 at 89.107.16.9",'
> rlm_acct_unique: Acct-Unique-Session-ID = "df36632bb92d5086".
>  modcall[preacct]: module "acct_unique" returns ok for request 0
>    rlm_realm: Proxy reply, or no User-Name.  Ignoring.
>  modcall[preacct]: module "suffix" returns noop for request 0
>  modcall[preacct]: module "files" returns noop for request 0
> modcall: leaving group preacct (returns ok) for request 0
>  Processing the accounting section of radiusd.conf
> modcall: entering group accounting for request 0
>  modcall[accounting]: module "unix" returns noop for request 0
> radius_xlat:  '/usr/local/var/log/radius/radutmp'
> rlm_radutmp: NAS OpenSER port 5060 unknown packet type 15)
>  modcall[accounting]: module "radutmp" returns noop for request 0
> radius_xlat:  ''
> radius_xlat:  ''
> radius_xlat:  '/usr/local/var/log/radius/sqltrace.sql'
> rlm_sql (sql): Reserving sql socket id: 3
> rlm_sql (sql): Released sql socket id: 3
>  modcall[accounting]: module "sql" returns ok for request 0
> modcall: leaving group accounting (returns ok) for request 0
> Sending Accounting-Response of id 252 to 89.107.16.10 port 35563
> Finished request 0
> Going to the next request
> --- Walking the entire request list ---
> Waking up in 6 seconds...
> --- Walking the entire request list ---
> Cleaning up request 0 ID 252 with timestamp 4794be17
> Nothing to do.  Sleeping until we see a request.