Hi Alan It seems you dont belive me. No I havent edited. This is an untouched input from console. # #radclient -f /tmp/auth.packet 127.0.0.1:2813 acct testing123 rad_recv: Accounting-Request packet from host 127.0.0.1 port 14803, id=236, length=142 Acct-Status-Type = Start Calling-Station-Id = "12312312312" Framed-IP-Address = 10.0.0.1 Acct-Session-Id = "d43363551081e4a8" NAS-IP-Address = 10.11.11.77 Framed-Protocol = GPRS-PDP-Context Called-Station-Id = "test-gprs" NAS-Identifier = "test-gprs" User-Name = "testuser" NAS-Port-Type = Virtual Service-Type = Framed-User 3GPP-IMSI = "123123123123123" Mon Jan 13 20:45:52 2014 : Info: # Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default Mon Jan 13 20:45:52 2014 : Info: +- entering group preacct {...} Mon Jan 13 20:45:52 2014 : Info: ++[preprocess] returns ok Mon Jan 13 20:45:52 2014 : Info: [acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent Mon Jan 13 20:45:52 2014 : Info: [acct_unique] Hashing ',NAS-Identifier = "test-gprs",NAS-IP-Address = 10.11.11.77,Acct-Session-Id = "d43363551081e4a8",User-Name = "testuser"' Mon Jan 13 20:45:52 2014 : Info: [acct_unique] Acct-Unique-Session-ID = "6ce7054b4a610197". Mon Jan 13 20:45:52 2014 : Info: ++[acct_unique] returns ok Mon Jan 13 20:45:52 2014 : Info: [suffix] No '@' in User-Name = "testuser", looking up realm NULL Mon Jan 13 20:45:52 2014 : Info: [suffix] No such realm "NULL" Mon Jan 13 20:45:52 2014 : Info: ++[suffix] returns noop Mon Jan 13 20:45:52 2014 : Info: # Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default Mon Jan 13 20:45:52 2014 : Info: +- entering group accounting {...} Mon Jan 13 20:45:52 2014 : Info: [detail] expand: %{Packet-Src-IP-Address} -> 127.0.0.1 Mon Jan 13 20:45:52 2014 : Info: [detail] expand: /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d -> /var/log/radacct/127.0.0.1/detail-20140113 Mon Jan 13 20:45:52 2014 : Info: [detail] /var/log/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radacct/127.0.0.1/detail-20140113 Mon Jan 13 20:45:52 2014 : Info: [detail] expand: %t -> Mon Jan 13 20:45:52 2014 Mon Jan 13 20:45:52 2014 : Info: ++[detail] returns ok Mon Jan 13 20:45:52 2014 : Info: [sql] expand: %{User-Name} -> testuser Mon Jan 13 20:45:52 2014 : Info: [sql] sql_set_user escaped user --> 'testuser' Mon Jan 13 20:45:52 2014 : Info: [sql] expand: %{Acct-Delay-Time} -> Mon Jan 13 20:45:52 2014 : Info: [sql] ... expanding second conditional Mon Jan 13 20:45:52 2014 : Info: [sql] expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, xascendsessionsvrkey, test,fullpacket) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP Mon Jan 13 20:45:52 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 3 Mon Jan 13 20:45:52 2014 : Debug: rlm_sql (sql): Released sql socket id: 3 Mon Jan 13 20:45:52 2014 : Info: ++[sql] returns ok Mon Jan 13 20:45:52 2014 : Info: ++[exec] returns noop Mon Jan 13 20:45:52 2014 : Info: [attr_filter.accounting_response] expand: %{User-Name} -> testuser Mon Jan 13 20:45:52 2014 : Debug: attr_filter: Matched entry DEFAULT at line 12 Mon Jan 13 20:45:52 2014 : Info: ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 236 to 127.0.0.1 port 14803 Mon Jan 13 20:45:52 2014 : Info: Finished request 0. Received response ID 236, code 5, length = 20 Mon Jan 13 20:45:52 2014 : Info: Cleaning up request 0 ID 236 with timestamp +8 Mon Jan 13 20:45:52 2014 : Debug: Going to the next request Mon Jan 13 20:45:52 2014 : Info: Ready to process requests. # # I can attach the whole console log from the init script (with unprintable characters as well) if it helps. Regards Dohány Tibor mailto:bit1@freemail.hu Alan DeKok <aland@deployingradius.com> írta:
bit1 wrote:
Hi Sorry for the less info.
This is the test method.
I didn't ask for that.
#cat /tmp/auth.packet
I didn't ask for that.
#mysql -e "select * from radacct\G" radius
I didn't ask for that.
Here is the debug output. Mon Jan 13 16:34:14 2014 : Info: # Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default
No. You've edited it, and remove most of the useful information.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html