BiTel

load=1

[root@bg log]# tail -n200 collector.log
05-26/11:39:28  INFO [main] DefaultServerSetup - Init DB connection pools
05-26/11:39:28  INFO [main] DefaultServerSetup - Init trash pools..
05-26/11:39:28  INFO [main] Collector - Starting flow collector for IPN...
05-26/11:39:28  INFO [main] Collector - Load => true; process => true
05-26/11:39:28  INFO [main] collector - Reload source list [types: netflow,sflow; sourceIds: 1]
05-26/11:39:28  INFO [main] collector - IP: 192.168.122.65 => 1
05-26/11:39:28  INFO [main] Collector - Starting FlowListener on port 2004 [recv_buf_size=8388608]
05-26/11:39:28  INFO [main] collector - Reload source list [types: netflow; sourceIds: ]
05-26/11:39:28 ERROR [main] LoggingPrintStream - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at java.lang.reflect.Constructor.newInstance(Unknown Source)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.Util.getInstance(Util.java:381)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at bitel.billing.server.load.bean.SourceManager.getSourceList(SourceManager.java:186)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at bitel.billing.server.netflow.ipn.SourceSelector.loadSources(SourceSelector.java:78)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at bitel.billing.server.netflow.ipn.SourceSelector.<init>(SourceSelector.java:43)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at bitel.billing.server.netflow.ipn.Collector.addFlowListener(Collector.java:211)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at bitel.billing.server.netflow.ipn.Collector.<init>(Collector.java:124)
05-26/11:39:28 ERROR [main] LoggingPrintStream -        at bitel.billing.server.netflow.ipn.Collector.main(Collector.java:236)
05-26/11:39:28  INFO [main] DatagramChannelListener - Open socket [0.0.0.0/0.0.0.0:2004]
05-26/11:39:28  INFO [main] DatagramChannelListener - ru.bitel.bgbilling.modules.ipn.collector.IPNFlowListener$3 socket init ok.
05-26/11:39:28  INFO [main] DetailMaker - Starting detail maker...
[root@bg log]#

port.admin=2003

#код модуля IPN
collector.mid=1

#опции подключения к БД
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false
db.user=myuser
db.pswd=mypassword
db.maxActive=300
db.maxIdle=100

#директория логов
log.dir=/usr/local/BGIPNNetflowCollector/log
load=1

process=1
sources=1

#порт
collector.capture.flow.port.1=2004
#тип слушателя
collector.capture.flow.port.1.type=netflow
#обслуживаемые на порту источники (указанного типа)
collector.capture.flow.port.1.sources=
#количество потоков
collector.capture.flow.port.1.thread.count=10
#
#collector.capture.flow.port.2=2005
#collector.capture.flow.port.2.type=sflow
#collector.capture.flow.port.2.sources=
#collector.capture.flow.port.2.thread.count=10

#опрашиватель snmp
#collector.capture.snmp=1
#collector.capture.snmp.sources=1

#размер блока
datalog.chunk.size=393216
#сжатие логов
#datalog.flow.compression.type=1