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" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list" <freeradius-users@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 = "[EMAIL PROTECTED]"
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 =
"[EMAIL PROTECTED]",'
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.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html