Accounting Errors в 0.54

Ответить
mr.Scamp
Сообщения: 55
Зарегистрирован: Вт дек 01, 2009 8:39 am

Accounting Errors в 0.54

Сообщение mr.Scamp »

Стоит 0.54 stable, из архива с sourceforge, freeradius 2, без rlm_perl.
NAS - mikrotik 5.x

в логи ошибок сыпется такое вот
2012-07-16 23:57:33 LOG_ERR ACCT - ACCT Accounting-On SQL Error UNKNOWN
2012-07-16 23:57:33 LOG_WARNING ACCT - [1] ACCT Accounting-On SQL Error NAS Server
в выводе freeradius

Код: Выделить всё

# Executing section preacct from file /etc/freeradius/sites-enabled/abills
+- entering group preacct {...}
++[preprocess] returns ok
Use of uninitialized value in numeric gt (>) at /usr/abills/libexec/../Abills/mysql/Acct.pm line 60.
Use of uninitialized value in pattern match (m//) at /usr/abills/libexec/../Abills/mysql/Acct.pm line 82.
Use of uninitialized value in concatenation (.) or string at /usr/abills/libexec/../Abills/mysql/Acct.pm line 418.
Use of uninitialized value in concatenation (.) or string at /usr/abills/libexec/../Abills/mysql/Acct.pm line 418.
Use of uninitialized value in string at /usr/abills/libexec/racct.pl line 378.
Exec-Program output:
Exec-Program: returned: 0
Вернуться к началу
~AsmodeuS~
Site Admin
Сообщения: 5749
Зарегистрирован: Пт янв 28, 2005 3:11 pm
Контактная информация:
Контактная информация пользователя ~AsmodeuS~

Re: Accounting Errors в 0.54

Сообщение ~AsmodeuS~ »

просьба показать запрос

и данные

/tmp/sql_errors
Вернуться к началу
mr.Scamp
Сообщения: 55
Зарегистрирован: Вт дек 01, 2009 8:39 am

Re: Accounting Errors в 0.54

Сообщение mr.Scamp »

/tmp/sql_errors

Код: Выделить всё

2012-07-17 11:19:36 LOG_ERR:  []
INSERT INTO web_online (admin, ip, logtime, aid, sid)
     values ('admin', '192.168.147.254', UNIX_TIMESTAMP(), '4', '');
 --1054
 --Unknown column 'aid' in 'field list'
radius debug log

Код: Выделить всё

11:21:02 system,info log rule changed by sasha
11:21:07 pppoe,info PPPoE connection established from 00:1D:92:F6:B8:9E
11:21:07 pppoe,ppp,info <pppoe-0>: waiting for call...
11:21:07 radius,debug debug: new request 1b:191 code=Access-Request service=ppp called-id=*
11:21:07 radius,debug debug: sending 1b:191 to 192.168.147.213:1812
11:21:07 radius,debug,packet debug: sending Access-Request with id 15 to 192.168.147.213:1812
11:21:07 radius,debug,packet debug:     Signature = 0x46c5b3cd36ef861b80c6f9e640d9c475
11:21:07 radius,debug,packet debug:     Service-Type = 2
11:21:07 radius,debug,packet debug:     Framed-Protocol = 1
11:21:07 radius,debug,packet debug:     NAS-Port = 80
11:21:07 radius,debug,packet debug:     NAS-Port-Type = 15
11:21:07 radius,debug,packet debug:     User-Name = "test"
11:21:07 radius,debug,packet debug:     Calling-Station-Id = "00:1D:92:F6:B8:9E"
11:21:07 radius,debug,packet debug:     Called-Station-Id = "*"
11:21:07 radius,debug,packet debug:     NAS-Port-Id = "bridge1"
11:21:07 radius,debug,packet debug:     MS-CHAP-Challenge = 0x9605cdad0bfe3a33e5ce4b64e8da236a
11:21:07 radius,debug,packet debug:     MS-CHAP2-Response = 0x010091841fade9bc29507485dd412475
11:21:07 radius,debug,packet debug:       408700000000000000004acd03404300
11:21:07 radius,debug,packet debug:       637a73ec2bc42179f60d2935f1fb7a24
11:21:07 radius,debug,packet debug:       9a93
11:21:07 radius,debug,packet debug:     NAS-Identifier = "scamp-home"
11:21:07 radius,debug,packet debug:     NAS-IP-Address = 192.168.147.1
11:21:08 radius,debug,packet debug: received Access-Accept with id 15 from 192.168.147.213:1812
11:21:08 radius,debug,packet debug:     Signature = 0x325aa1250e7ccdba9ec616377dcc6548
11:21:08 radius,debug,packet debug:     Framed-Protocol = 1
11:21:08 radius,debug,packet debug:     Framed-Compression = 1
11:21:08 radius,debug,packet debug:     Acct-Interim-Interval = 300
11:21:08 radius,debug,packet debug:     Session-Timeout = 1255132
11:21:08 radius,debug,packet debug:     Framed-IP-Address = 10.0.0.22
11:21:08 radius,debug,packet debug:     Framed-IP-Netmask = 255.255.255.255
11:21:08 radius,debug,packet debug:     MT-Rate-Limit = "64k"
11:21:08 radius,debug,packet debug:     MS-CHAP2-Success = 0x01533d30463031394544323738434243
11:21:08 radius,debug,packet debug:       45334245454644313534444636394138
11:21:08 radius,debug,packet debug:       4346433236364536373346
11:21:08 radius,debug debug: received reply for 1b:191
11:21:08 pppoe,ppp,info <pppoe-0>: authenticated
11:21:08 radius,debug debug: new request 1b:00 code=Accounting-Request service=ppp called-id=*
11:21:08 radius,debug debug: sending 05:00 to 192.168.147.213:1813
11:21:08 radius,debug,packet debug: sending Accounting-Request with id 16 to 192.168.147.213:1813
11:21:08 radius,debug,packet debug:     Signature = 0x21f2bd4b66995469733c46cc4d2b6c8d
11:21:08 radius,debug,packet debug:     Acct-Status-Type = 7
11:21:08 radius,debug,packet debug:     NAS-Identifier = "scamp-home"
11:21:08 radius,debug,packet debug:     Acct-Delay-Time = 0
11:21:08 radius,debug,packet debug:     NAS-IP-Address = 192.168.147.1
11:21:08 radius,debug debug: sending 1b:00 to 192.168.147.213:1813
11:21:08 radius,debug,packet debug: sending Accounting-Request with id 17 to 192.168.147.213:1813
11:21:08 radius,debug,packet debug:     Signature = 0x1fe32918d653277ced59fe505e1d1d55
11:21:08 radius,debug,packet debug:     Service-Type = 2
11:21:08 radius,debug,packet debug:     Framed-Protocol = 1
11:21:08 radius,debug,packet debug:     NAS-Port = 80
11:21:08 radius,debug,packet debug:     NAS-Port-Type = 15
11:21:08 radius,debug,packet debug:     User-Name = "test"
11:21:08 radius,debug,packet debug:     Calling-Station-Id = "00:1D:92:F6:B8:9E"
11:21:08 radius,debug,packet debug:     Called-Station-Id = "*"
11:21:08 radius,debug,packet debug:     NAS-Port-Id = "bridge1"
11:21:08 radius,debug,packet debug:     Acct-Session-Id = "81d0003e"
11:21:08 radius,debug,packet debug:     Framed-IP-Address = 10.0.0.22
11:21:08 radius,debug,packet debug:     Acct-Authentic = 1
11:21:08 radius,debug,packet debug:     Event-Timestamp = 1342513268
11:21:08 radius,debug,packet debug:     Acct-Status-Type = 1
11:21:08 radius,debug,packet debug:     NAS-Identifier = "scamp-home"
11:21:08 radius,debug,packet debug:     Acct-Delay-Time = 0
11:21:08 radius,debug,packet debug:     NAS-IP-Address = 192.168.147.1
11:21:09 pppoe,ppp,info <pppoe-0>: connected
11:21:09 pppoe,ppp,info,account test logged in, 10.0.0.22
11:21:10 radius,debug debug: resending 1b:00
11:21:10 radius,debug,packet debug: sending Accounting-Request with id 17 to 192.168.147.213:1813
11:21:10 radius,debug,packet debug:     Signature = 0xb9280044f120dd45dda69205d4503b1d
11:21:10 radius,debug,packet debug:     Service-Type = 2
11:21:10 radius,debug,packet debug:     Framed-Protocol = 1
11:21:10 radius,debug,packet debug:     NAS-Port = 80
11:21:10 radius,debug,packet debug:     NAS-Port-Type = 15
11:21:10 radius,debug,packet debug:     User-Name = "test"
11:21:10 radius,debug,packet debug:     Calling-Station-Id = "00:1D:92:F6:B8:9E"
11:21:10 radius,debug,packet debug:     Called-Station-Id = "*"
11:21:10 radius,debug,packet debug:     NAS-Port-Id = "bridge1"
11:21:10 radius,debug,packet debug:     Acct-Session-Id = "81d0003e"
11:21:10 radius,debug,packet debug:     Framed-IP-Address = 10.0.0.22
11:21:10 radius,debug,packet debug:     Acct-Authentic = 1
11:21:10 radius,debug,packet debug:     Event-Timestamp = 1342513268
11:21:10 radius,debug,packet debug:     Acct-Status-Type = 1
11:21:10 radius,debug,packet debug:     NAS-Identifier = "scamp-home"
11:21:10 radius,debug,packet debug:     Acct-Delay-Time = 2
11:21:10 radius,debug,packet debug:     NAS-IP-Address = 192.168.147.1
11:21:12 radius,debug debug: resending 1b:00
11:21:12 radius,debug,packet debug: sending Accounting-Request with id 17 to 192.168.147.213:1813
11:21:12 radius,debug,packet debug:     Signature = 0x727a0ea94d73b74a825bdba8dbf2c398
11:21:12 radius,debug,packet debug:     Service-Type = 2
11:21:12 radius,debug,packet debug:     Framed-Protocol = 1
11:21:12 radius,debug,packet debug:     NAS-Port = 80
11:21:12 radius,debug,packet debug:     NAS-Port-Type = 15
11:21:12 radius,debug,packet debug:     User-Name = "test"
11:21:12 radius,debug,packet debug:     Calling-Station-Id = "00:1D:92:F6:B8:9E"
11:21:12 radius,debug,packet debug:     Called-Station-Id = "*"
11:21:12 radius,debug,packet debug:     NAS-Port-Id = "bridge1"
11:21:12 radius,debug,packet debug:     Acct-Session-Id = "81d0003e"
11:21:12 radius,debug,packet debug:     Framed-IP-Address = 10.0.0.22
11:21:12 radius,debug,packet debug:     Acct-Authentic = 1
11:21:12 radius,debug,packet debug:     Event-Timestamp = 1342513268
11:21:12 radius,debug,packet debug:     Acct-Status-Type = 1
11:21:12 radius,debug,packet debug:     NAS-Identifier = "scamp-home"
11:21:12 radius,debug,packet debug:     Acct-Delay-Time = 4
11:21:12 radius,debug,packet debug:     NAS-IP-Address = 192.168.147.1
11:21:14 radius,debug debug: timeout for 1b:00
Вернуться к началу
mr.Scamp
Сообщения: 55
Зарегистрирован: Вт дек 01, 2009 8:39 am

Re: Accounting Errors в 0.54

Сообщение mr.Scamp »

up!
Вернуться к началу
~AsmodeuS~
Site Admin
Сообщения: 5749
Зарегистрирован: Пт янв 28, 2005 3:11 pm
Контактная информация:
Контактная информация пользователя ~AsmodeuS~

Re: Accounting Errors в 0.54

Сообщение ~AsmodeuS~ »

просьба не апать сообщения рассматриваются мере свободного времени

1 обновитесь корректный а то не все поля внесли в базу
2 скорее всего какого то значения словаря не хватает и некоторые пары билинг не видит
Вернуться к началу
mr.Scamp
Сообщения: 55
Зарегистрирован: Вт дек 01, 2009 8:39 am

Re: Accounting Errors в 0.54

Сообщение mr.Scamp »

Простите, привычка :)

По поводу полей - база инициализировалась из abills.sql, который был в архиве c 0.54, прошу исправить.

Словарь атрибутов брал с http://wiki.mikrotik.com/wiki/Manual:RA ... dictionary.
Как определить, на чем именно спотыкается скрипт аккаунтинга?
Вернуться к началу
Ответить

Вернуться в «Сообщения об ошибках и поддержка»