Greetings, I have set up the buffered-sql server to handle importing accounting packets from my backup radius once a day. I transfer the detail file (via ftp) from the backup server to the newer server and put it in place for the buffered-sql to use it, but it doesn't seem to read the file. I though, from the description in the documentation, it would run ever X seconds. I've set mine to 60 seconds for testing. Am I doing something wrong? wm
William wrote:
Greetings, I have set up the buffered-sql server to handle importing accounting packets from my backup radius once a day. I transfer the detail file (via ftp) from the backup server to the newer server and put it in place for the buffered-sql to use it, but it doesn't seem to read the file.
I though, from the description in the documentation, it would run ever X seconds. I've set mine to 60 seconds for testing.
Am I doing something wrong?
What does debug mode say? Alan DeKok.
On Wednesday, December 29, 2010 12:51:06 pm Alan DeKok wrote:
William wrote:
Greetings,
I have set up the buffered-sql server to handle importing accounting
packets from my backup radius once a day. I transfer the detail file (via ftp) from the backup server to the newer server and put it in place for the buffered-sql to use it, but it doesn't seem to read the file.
I though, from the description in the documentation, it would run ever X seconds. I've set mine to 60 seconds for testing.
Am I doing something wrong?
What does debug mode say?
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
It claims that there is an accounting packet without an acctsessiontime... I found the offending entries and now it works. I guess I'll have to edit those out each time. They are being created by a web-accelerator program we use. : Info: [sql] stop packet with zero session length. [user '', nas '69.54.220.130'] Once I edit those records out, it works fine. :( offending record looks like: Wed Dec 29 00:08:22 2010 Event-Timestamp = "Dec 29 2010 00:08:22 EST" User-Name = "<username>" NAS-IP-Address = 69.54.220.130 NAS-Identifier = "TN_GrandRapidsAPX.1dial.com" NAS-Port = 1838 NAS-Port-Type = Async Service-Type = Framed-User Acct-Status-Type = Stop Acct-Delay-Time = 0 Acct-Session-Id = "617355318" Acct-Authentic = RADIUS Acct-Session-Time = 1087 Acct-Input-Octets = 45488 Acct-Output-Octets = 68727 Acct-Input-Packets = 169 Acct-Output-Packets = 155 Acct-Terminate-Cause = Session-Timeout Ascend-Disconnect-Cause = Session-Timeout Ascend-Connect-Progress = LAN-Session-Up Ascend-PreSession-Time = 32 Ascend-Pre-Input-Octets = 347 Ascend-Pre-Output-Octets = 251 Ascend-Pre-Input-Packets = 12 Ascend-Pre-Output-Packets = 12 Ascend-First-Dest = 255.255.255.255 Ascend-Data-Rate = 24000 Ascend-Xmit-Rate = 26400 Ascend-Modem-PortNo = 89 Ascend-Modem-SlotNo = 10 Ascend-Modem-ShelfNo = 1 Calling-Station-Id = "<phone>" Called-Station-Id = "<dialup>" Ascend-Data-Svc = Switched-Voice-Bearer Framed-Protocol = PPP Framed-IP-Address = <ip address> Attr-103 = 0x4d1ac245 Client-IP-Address = <ip address> Acct-Unique-Session-Id = "bcac314c121c56b5" Stripped-User-Name = "<username>" Realm = "<realm>" Timestamp = 1293599302 Any ideas besides dumping these packets? Wm
It claims that there is an accounting packet without an acctsessiontime... I found the offending entries and now it works. I guess I'll have to edit those out each time. They are being created by a web-accelerator program we use.
: Info: [sql] stop packet with zero session length. [user '', nas '69.54.220.130']
This is just an informational message, not an error message, and can be ignored. However, the username for that packet is empty which is probably not what you want.
Once I edit those records out, it works fine. :( offending record looks like:
Wed Dec 29 00:08:22 2010 Event-Timestamp = "Dec 29 2010 00:08:22 EST" User-Name = "<username>" NAS-IP-Address = 69.54.220.130 NAS-Identifier = "TN_GrandRapidsAPX.1dial.com" NAS-Port = 1838 NAS-Port-Type = Async Service-Type = Framed-User Acct-Status-Type = Stop Acct-Delay-Time = 0 Acct-Session-Id = "617355318" Acct-Authentic = RADIUS Acct-Session-Time = 1087 Acct-Input-Octets = 45488 Acct-Output-Octets = 68727 Acct-Input-Packets = 169 Acct-Output-Packets = 155 Acct-Terminate-Cause = Session-Timeout Ascend-Disconnect-Cause = Session-Timeout Ascend-Connect-Progress = LAN-Session-Up Ascend-PreSession-Time = 32 Ascend-Pre-Input-Octets = 347 Ascend-Pre-Output-Octets = 251 Ascend-Pre-Input-Packets = 12 Ascend-Pre-Output-Packets = 12 Ascend-First-Dest = 255.255.255.255 Ascend-Data-Rate = 24000 Ascend-Xmit-Rate = 26400 Ascend-Modem-PortNo = 89 Ascend-Modem-SlotNo = 10 Ascend-Modem-ShelfNo = 1 Calling-Station-Id = "<phone>" Called-Station-Id = "<dialup>" Ascend-Data-Svc = Switched-Voice-Bearer Framed-Protocol = PPP Framed-IP-Address = <ip address> Attr-103 = 0x4d1ac245 Client-IP-Address = <ip address> Acct-Unique-Session-Id = "bcac314c121c56b5" Stripped-User-Name = "<username>" Realm = "<realm>" Timestamp = 1293599302
There's nothing wrong with this packet. It includes the User-Name attribute with a value of "<username>" and the Acct-Session-Time attribute with a value of 1087 seconds. The " Info: [sql] stop packet with zero session length." message would not be generated by this packet. When you leave in the "offending" packets, what happens? Do you just get the "stop packet with zero session length" message? If that's the only "problem", just ignore it or fix the device that is sending that packet. Tim
On Wednesday, December 29, 2010 03:59:35 pm Tim Sylvester wrote:
It claims that there is an accounting packet without an acctsessiontime... I found the offending entries and now it works. I
guess I'll have to
edit those out each time. They are being created by a web-accelerator
program we
use.
: Info: [sql] stop packet with zero session length. [user '', nas
'69.54.220.130']
This is just an informational message, not an error message, and can be ignored. However, the username for that packet is empty which is probably not what you want.
Once I edit those records out, it works fine. :(
offending record looks like: Wed Dec 29 00:08:22 2010
Event-Timestamp = "Dec 29 2010 00:08:22 EST" User-Name = "<username>" NAS-IP-Address = 69.54.220.130 NAS-Identifier = "TN_GrandRapidsAPX.1dial.com" NAS-Port = 1838 NAS-Port-Type = Async Service-Type = Framed-User Acct-Status-Type = Stop Acct-Delay-Time = 0 Acct-Session-Id = "617355318" Acct-Authentic = RADIUS Acct-Session-Time = 1087 Acct-Input-Octets = 45488 Acct-Output-Octets = 68727 Acct-Input-Packets = 169 Acct-Output-Packets = 155 Acct-Terminate-Cause = Session-Timeout Ascend-Disconnect-Cause = Session-Timeout Ascend-Connect-Progress = LAN-Session-Up Ascend-PreSession-Time = 32 Ascend-Pre-Input-Octets = 347 Ascend-Pre-Output-Octets = 251 Ascend-Pre-Input-Packets = 12 Ascend-Pre-Output-Packets = 12 Ascend-First-Dest = 255.255.255.255 Ascend-Data-Rate = 24000 Ascend-Xmit-Rate = 26400 Ascend-Modem-PortNo = 89 Ascend-Modem-SlotNo = 10 Ascend-Modem-ShelfNo = 1 Calling-Station-Id = "<phone>" Called-Station-Id = "<dialup>" Ascend-Data-Svc = Switched-Voice-Bearer Framed-Protocol = PPP Framed-IP-Address = <ip address> Attr-103 = 0x4d1ac245 Client-IP-Address = <ip address> Acct-Unique-Session-Id = "bcac314c121c56b5" Stripped-User-Name = "<username>" Realm = "<realm>" Timestamp = 1293599302
There's nothing wrong with this packet. It includes the User-Name attribute with a value of "<username>" and the Acct-Session-Time attribute with a value of 1087 seconds. The " Info: [sql] stop packet with zero session length." message would not be generated by this packet.
When you leave in the "offending" packets, what happens? Do you just get the "stop packet with zero session length" message? If that's the only "problem", just ignore it or fix the device that is sending that packet.
Tim
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
It doesn't import any additional records after that. It just stops, and keeps generating the error.
William wrote:
It claims that there is an accounting packet without an acctsessiontime... I found the offending entries and now it works. I guess I'll have to edit those out each time.
Read raddb/sites-enabled/default. Look for "sql" in the "accounting" section. The solution is documented there. Alan DeKok.
participants (3)
-
Alan DeKok -
Tim Sylvester -
William