forum.bitel.ru :: Просмотр темы - Переобсчет Netflow

10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [77.88.0.0-77.88.63.255; 0-65535] => 11
10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [77.88.0.0-77.88.63.255; 0-65535] => 12
10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [93.158.128.0-93.158.191.255; 0-65535] => 11
10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [93.158.128.0-93.158.191.255; 0-65535] => 12
10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [92.246.133.0-92.246.133.255; 0-65535] => 11
10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [92.246.133.0-92.246.133.255; 0-65535] => 12
10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [0.0.0.0-255.255.255.255; 0-65535] => 7
10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [0.0.0.0-255.255.255.255; 0-65535] => 8
10-27/14:09:43 INFO [pool-1-thread-1] scheduler - DialUp traffic processing session selected for nas 1, start process..
10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 00
10-27/14:09:56 INFO [pool-1-thread-1] scheduler - OK
10-27/14:09:56 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 01
10-27/14:10:09 INFO [pool-1-thread-1] scheduler - OK
10-27/14:10:09 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 02
10-27/14:10:21 INFO [pool-1-thread-1] scheduler - OK
10-27/14:10:21 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 03
10-27/14:10:33 INFO [pool-1-thread-1] scheduler - OK
10-27/14:10:33 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 04
10-27/14:10:48 INFO [pool-1-thread-1] scheduler - OK
10-27/14:10:48 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 05
10-27/14:11:00 INFO [pool-1-thread-1] scheduler - OK
10-27/14:11:00 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 06
10-27/14:11:12 INFO [pool-1-thread-1] scheduler - OK
10-27/14:11:12 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 07
10-27/14:11:24 INFO [pool-1-thread-1] scheduler - OK
10-27/14:11:24 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 08
10-27/14:11:40 INFO [pool-1-thread-1] scheduler - OK
10-27/14:11:40 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 09
10-27/14:12:00 INFO [pool-1-thread-1] scheduler - OK
10-27/14:12:00 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 10
10-27/14:12:22 INFO [pool-1-thread-1] scheduler - OK
10-27/14:12:22 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 11
10-27/14:12:46 INFO [pool-1-thread-1] scheduler - OK
10-27/14:12:46 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 12
10-27/14:13:10 INFO [pool-1-thread-1] scheduler - OK
10-27/14:13:10 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 13
10-27/14:13:38 INFO [pool-1-thread-1] scheduler - OK
10-27/14:13:38 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 14
10-27/14:14:07 INFO [pool-1-thread-1] scheduler - OK
10-27/14:14:07 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 15
10-27/14:14:34 INFO [pool-1-thread-1] scheduler - OK
10-27/14:14:34 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 16
10-27/14:14:59 INFO [pool-1-thread-1] scheduler - OK
10-27/14:14:59 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 17
10-27/14:15:19 INFO [pool-1-thread-1] scheduler - OK
10-27/14:15:19 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 18
10-27/14:15:37 INFO [pool-1-thread-1] scheduler - OK
10-27/14:15:37 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 19
10-27/14:15:53 INFO [pool-1-thread-1] scheduler - OK
10-27/14:15:53 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 20
10-27/14:16:07 INFO [pool-1-thread-1] scheduler - OK
10-27/14:16:07 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 21
10-27/14:16:21 INFO [pool-1-thread-1] scheduler - OK
10-27/14:16:21 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 22
10-27/14:16:34 INFO [pool-1-thread-1] scheduler - OK
10-27/14:16:34 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 23
10-27/14:16:47 INFO [pool-1-thread-1] scheduler - OK
10-27/14:16:47 ERROR [pool-1-thread-1] scheduler - Communications link failure

Last packet sent to the server was 0 ms ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at bitel.billing.server.dialup.TrafficProcessor.run(TrafficProcessor.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2455)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906)
... 12 more

Автор:	anred [ 27 окт 2010, 16:24 ]
Заголовок сообщения:	Переобсчет Netflow
При попытки обсчета получаю Код: 10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [77.88.0.0-77.88.63.255; 0-65535] => 11 10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [77.88.0.0-77.88.63.255; 0-65535] => 12 10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [93.158.128.0-93.158.191.255; 0-65535] => 11 10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [93.158.128.0-93.158.191.255; 0-65535] => 12 10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [92.246.133.0-92.246.133.255; 0-65535] => 11 10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [92.246.133.0-92.246.133.255; 0-65535] => 12 10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [0.0.0.0-255.255.255.255; 0-65535] => 7 10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Service link [0.0.0.0-255.255.255.255; 0-65535] => 8 10-27/14:09:43 INFO [pool-1-thread-1] scheduler - DialUp traffic processing session selected for nas 1, start process.. 10-27/14:09:43 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 00 10-27/14:09:56 INFO [pool-1-thread-1] scheduler - OK 10-27/14:09:56 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 01 10-27/14:10:09 INFO [pool-1-thread-1] scheduler - OK 10-27/14:10:09 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 02 10-27/14:10:21 INFO [pool-1-thread-1] scheduler - OK 10-27/14:10:21 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 03 10-27/14:10:33 INFO [pool-1-thread-1] scheduler - OK 10-27/14:10:33 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 04 10-27/14:10:48 INFO [pool-1-thread-1] scheduler - OK 10-27/14:10:48 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 05 10-27/14:11:00 INFO [pool-1-thread-1] scheduler - OK 10-27/14:11:00 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 06 10-27/14:11:12 INFO [pool-1-thread-1] scheduler - OK 10-27/14:11:12 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 07 10-27/14:11:24 INFO [pool-1-thread-1] scheduler - OK 10-27/14:11:24 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 08 10-27/14:11:40 INFO [pool-1-thread-1] scheduler - OK 10-27/14:11:40 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 09 10-27/14:12:00 INFO [pool-1-thread-1] scheduler - OK 10-27/14:12:00 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 10 10-27/14:12:22 INFO [pool-1-thread-1] scheduler - OK 10-27/14:12:22 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 11 10-27/14:12:46 INFO [pool-1-thread-1] scheduler - OK 10-27/14:12:46 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 12 10-27/14:13:10 INFO [pool-1-thread-1] scheduler - OK 10-27/14:13:10 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 13 10-27/14:13:38 INFO [pool-1-thread-1] scheduler - OK 10-27/14:13:38 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 14 10-27/14:14:07 INFO [pool-1-thread-1] scheduler - OK 10-27/14:14:07 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 15 10-27/14:14:34 INFO [pool-1-thread-1] scheduler - OK 10-27/14:14:34 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 16 10-27/14:14:59 INFO [pool-1-thread-1] scheduler - OK 10-27/14:14:59 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 17 10-27/14:15:19 INFO [pool-1-thread-1] scheduler - OK 10-27/14:15:19 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 18 10-27/14:15:37 INFO [pool-1-thread-1] scheduler - OK 10-27/14:15:37 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 19 10-27/14:15:53 INFO [pool-1-thread-1] scheduler - OK 10-27/14:15:53 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 20 10-27/14:16:07 INFO [pool-1-thread-1] scheduler - OK 10-27/14:16:07 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 21 10-27/14:16:21 INFO [pool-1-thread-1] scheduler - OK 10-27/14:16:21 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 22 10-27/14:16:34 INFO [pool-1-thread-1] scheduler - OK 10-27/14:16:34 INFO [pool-1-thread-1] scheduler - Processing NAS 1 hour 01.10.10 23 10-27/14:16:47 INFO [pool-1-thread-1] scheduler - OK 10-27/14:16:47 ERROR [pool-1-thread-1] scheduler - Communications link failure Last packet sent to the server was 0 ms ago. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at bitel.billing.server.dialup.TrafficProcessor.run(TrafficProcessor.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2455) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906) ... 12 more Куда копать ?)

Автор:	anred [ 27 окт 2010, 18:04 ]
Заголовок сообщения:	Re: Переобсчет Netflow
также замечено было что логи не переобсчитываются у клиента в договоре трафика нету а если выгружать лог из IPN и грепнуть его то в нем есть! =(

Автор:	anred [ 27 окт 2010, 18:20 ]
Заголовок сообщения:	Re: Переобсчет Netflow
при запросе дитализации трафик тоже приходит =(

Автор:	anred [ 28 окт 2010, 13:54 ]
Заголовок сообщения:	Re: Переобсчет Netflow
Есть первчиные логи вопрос как их переобсчитать ?)

Автор:	anred [ 28 окт 2010, 14:01 ]
Заголовок сообщения:	Re: Переобсчет Netflow
версия биллинга 4,6 обновлена до последнего! покопавшись увидел что логи первичные немного отличаются от тех что с коллектора PPP Код: 1286690610654 221.192.199.48 0 94.100.x.x 0 92 49 53 1286690536072 94.100.214.206 0 94.100.x.x 0 96 49 53 1286691560743 124.237.121.52 0 94.100.x.x 0 46 49 53 1286691879789 221.192.199.48 0 94.100.x.x 0 92 49 53 1286691882261 193.107.208.192 0 94.100.x.x 0 2084 49 53 1286691881577 74.125.87.101 0 94.100.x.x 0 911 49 53 1286691881753 173.194.19.39 0 94.100.x.x 0 3742 49 53 1286691882077 222.214.236.222 0 94.100.x.x 0 48 49 53 1286692089410 64.161.239.65 0 94.100.x.x 0 826 49 53 1286692069802 64.161.239.65 0 94.100.x.x 0 2230 49 53 1286693334916 221.192.199.48 0 94.100.x.x 0 92 49 53 1286693611908 173.194.19.52 0 94.100.x.x 0 6989 49 53 1286693609208 74.125.87.101 0 94.100.x.x 0 985 49 53 1286693883210 74.125.87.101 0 94.100.x.x 0 46 49 53 1286693885234 173.194.19.52 0 94.100.x.x 0 92 49 53 поля from port to port 0

forum.bitel.ru http://forum.bitel.ru/

Переобсчет Netflow http://forum.bitel.ru/viewtopic.php?f=5&t=4717	Страница 1 из 1

Автор:	anred [ 28 окт 2010, 14:43 ]
Заголовок сообщения:	Re: Переобсчет Netflow
Проблема решилась! =) обработчик почему то критичен к обьему отправки инфы при переносе на тот же сервер где и mysql переобсчет прошел удачно!

Страница 1 из 1	Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/