Информация о версии:

  Клиент: вер. 5.2 сборка 1005 от 02.07.2012 15:36:02
    os: Windows XP; java: Java HotSpot(TM) Client VM, v.1.6.0_33
  Сервер: вер. 5.2 сборка 1225 от 02.07.2012 15:36:09
    os: Linux; java: Java HotSpot(TM) Server VM, v.1.6.0_33

  dba вер. 5.2 сборка 147 от 13.03.2012 14:03:35
  dialup вер. 5.2 сборка 343 от 19.06.2012 11:17:51
  phone вер. 5.2 сборка 240 от 21.06.2012 19:24:36
  reports вер. 5.2 сборка 178 от 28.06.2012 14:17:45
  voiceip вер. 5.2 сборка 183 от 25.06.2012 12:54:06

server 07-03/01:51:57 ERROR ["http-bio-/0.0.0.0-8080"-exec-8] CommonExecuter - Unknown column 'common_config_id' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'common_config_id' in 'field list'
        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:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at bitel.billing.server.call.action.ActionUpdateNasInfo.doAction(ActionUpdateNasInfo.java:55)
        at bitel.billing.server.Executer.doModule(Unknown Source)
        at bitel.billing.server.Executer$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)
        at bitel.billing.server.Executer.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
        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:662)

./bg_installer.sh killhash mXX

 07-03/09:56:48  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@1a62c31] to java:comp/env/mq/connectionFactory
 07-03/09:56:48  INFO [main] DefaultServerSetup - Init DB connection pools
 07-03/09:56:49  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
 07-03/09:56:49  INFO [main] DefaultServerSetup - Init trash pools..
mq 07-03/09:56:49  INFO [EventProcessor-init] EventProcessor - Init EventProcessor MQ connection factory...
mq 07-03/09:56:49 DEBUG [EventProcessor-init] FailoverTransport - Reconnect was triggered but transport is not started yet. Wait for start to connect the transport.
mq 07-03/09:56:49 DEBUG [EventProcessor-init] FailoverTransport - Started.
mq 07-03/09:56:49 DEBUG [EventProcessor-init] FailoverTransport - Waking up reconnect task
mq 07-03/09:56:49 DEBUG [ActiveMQ Task] FailoverTransport - urlList connectionList:[nio://127.0.0.1:61616?socketBufferSize=1000000]
mq 07-03/09:56:49 DEBUG [ActiveMQ Task] FailoverTransport - Attempting connect to: nio://127.0.0.1:61616?socketBufferSize=1000000
mq 07-03/09:56:49 DEBUG [ActiveMQ Task] WireFormatNegotiator - Sending: WireFormatInfo { version=6, properties={CacheSize=1024, CacheEnabled=true, SizePrefixDisabled=false, MaxInactivityDurationInitalDelay=10000, TcpNoDelayEnabled=true, MaxInactivityDuration=30000, TightEncodingEnabled=true, StackTraceEnabled=true}, magic=[A,c,t,i,v,e,M,Q]}
mq 07-03/09:56:49 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - Received WireFormat: WireFormatInfo { version=6, properties={CacheSize=1024, CacheEnabled=true, SizePrefixDisabled=false, MaxInactivityDurationInitalDelay=10000, TcpNoDelayEnabled=true, MaxInactivityDuration=30000, TightEncodingEnabled=true, StackTraceEnabled=true}, magic=[A,c,t,i,v,e,M,Q]}
mq 07-03/09:56:49 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - tcp:///127.0.0.1:61616 before negotiation: OpenWireFormat{version=6, cacheEnabled=false, stackTraceEnabled=false, tightEncodingEnabled=false, sizePrefixDisabled=false}
mq 07-03/09:56:49 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - tcp:///127.0.0.1:61616 after negotiation: OpenWireFormat{version=6, cacheEnabled=true, stackTraceEnabled=true, tightEncodingEnabled=true, sizePrefixDisabled=false}
mq 07-03/09:56:49 DEBUG [ActiveMQ Task] FailoverTransport - Connection established
mq 07-03/09:56:49  INFO [ActiveMQ Task] FailoverTransport - Successfully connected to nio://127.0.0.1:61616?socketBufferSize=1000000
 07-03/09:56:50 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.server.util.Setup$1@e06703 to BG.Event.ru.bitel.bgbilling.kernel.event.events.system.ModuleConfigModifiedEvent
Module: dialup already installed. Reinstalling....
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 4
Module Instance init => OK
Executing call AddSchedulerTasks; param: dialup.sc
Scheduled class bitel.billing.server.dialup.MaxCalculator already exists!
Result => true
Executing call PutFile; param: dialup.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Remove libs => OK
Module dialup was successfull installed!
Please, restart BGBilling server.

 07-03/09:58:25  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@1a62c31] to java:comp/env/mq/connectionFactory
 07-03/09:58:25  INFO [main] DefaultServerSetup - Init DB connection pools
 07-03/09:58:25  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
 07-03/09:58:26  INFO [main] DefaultServerSetup - Init trash pools..
mq 07-03/09:58:26  INFO [EventProcessor-init] EventProcessor - Init EventProcessor MQ connection factory...
mq 07-03/09:58:26 DEBUG [EventProcessor-init] FailoverTransport - Reconnect was triggered but transport is not started yet. Wait for start to connect the transport.
mq 07-03/09:58:26 DEBUG [EventProcessor-init] FailoverTransport - Started.
mq 07-03/09:58:26 DEBUG [EventProcessor-init] FailoverTransport - Waking up reconnect task
mq 07-03/09:58:26 DEBUG [ActiveMQ Task] FailoverTransport - urlList connectionList:[nio://127.0.0.1:61616?socketBufferSize=1000000]
mq 07-03/09:58:26 DEBUG [ActiveMQ Task] FailoverTransport - Attempting connect to: nio://127.0.0.1:61616?socketBufferSize=1000000
mq 07-03/09:58:26 DEBUG [ActiveMQ Task] WireFormatNegotiator - Sending: WireFormatInfo { version=6, properties={CacheSize=1024, CacheEnabled=true, SizePrefixDisabled=false, MaxInactivityDurationInitalDelay=10000, TcpNoDelayEnabled=true, MaxInactivityDuration=30000, TightEncodingEnabled=true, StackTraceEnabled=true}, magic=[A,c,t,i,v,e,M,Q]}
mq 07-03/09:58:26 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - Received WireFormat: WireFormatInfo { version=6, properties={CacheSize=1024, CacheEnabled=true, SizePrefixDisabled=false, MaxInactivityDurationInitalDelay=10000, TcpNoDelayEnabled=true, MaxInactivityDuration=30000, TightEncodingEnabled=true, StackTraceEnabled=true}, magic=[A,c,t,i,v,e,M,Q]}
mq 07-03/09:58:26 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - tcp:///127.0.0.1:61616 before negotiation: OpenWireFormat{version=6, cacheEnabled=false, stackTraceEnabled=false, tightEncodingEnabled=false, sizePrefixDisabled=false}
mq 07-03/09:58:26 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - tcp:///127.0.0.1:61616 after negotiation: OpenWireFormat{version=6, cacheEnabled=true, stackTraceEnabled=true, tightEncodingEnabled=true, sizePrefixDisabled=false}
mq 07-03/09:58:26 DEBUG [ActiveMQ Task] FailoverTransport - Connection established
mq 07-03/09:58:26  INFO [ActiveMQ Task] FailoverTransport - Successfully connected to nio://127.0.0.1:61616?socketBufferSize=1000000
 07-03/09:58:27 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.server.util.Setup$1@26f9e5 to BG.Event.ru.bitel.bgbilling.kernel.event.events.system.ModuleConfigModifiedEvent
Hash killing for m4 finished!

 07-03/09:58:58  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@1a62c31] to java:comp/env/mq/connectionFactory
 07-03/09:58:58  INFO [main] DefaultServerSetup - Init DB connection pools
 07-03/09:58:58  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
 07-03/09:58:58  INFO [main] DefaultServerSetup - Init trash pools..
mq 07-03/09:58:58  INFO [EventProcessor-init] EventProcessor - Init EventProcessor MQ connection factory...
mq 07-03/09:58:58 DEBUG [EventProcessor-init] FailoverTransport - Reconnect was triggered but transport is not started yet. Wait for start to connect the transport.
mq 07-03/09:58:59 DEBUG [EventProcessor-init] FailoverTransport - Started.
mq 07-03/09:58:59 DEBUG [EventProcessor-init] FailoverTransport - Waking up reconnect task
mq 07-03/09:58:59 DEBUG [ActiveMQ Task] FailoverTransport - urlList connectionList:[nio://127.0.0.1:61616?socketBufferSize=1000000]
mq 07-03/09:58:59 DEBUG [ActiveMQ Task] FailoverTransport - Attempting connect to: nio://127.0.0.1:61616?socketBufferSize=1000000
mq 07-03/09:58:59 DEBUG [ActiveMQ Task] WireFormatNegotiator - Sending: WireFormatInfo { version=6, properties={CacheSize=1024, CacheEnabled=true, SizePrefixDisabled=false, MaxInactivityDurationInitalDelay=10000, TcpNoDelayEnabled=true, MaxInactivityDuration=30000, TightEncodingEnabled=true, StackTraceEnabled=true}, magic=[A,c,t,i,v,e,M,Q]}
mq 07-03/09:58:59 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - Received WireFormat: WireFormatInfo { version=6, properties={CacheSize=1024, CacheEnabled=true, SizePrefixDisabled=false, MaxInactivityDurationInitalDelay=10000, TcpNoDelayEnabled=true, MaxInactivityDuration=30000, TightEncodingEnabled=true, StackTraceEnabled=true}, magic=[A,c,t,i,v,e,M,Q]}
mq 07-03/09:58:59 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - tcp:///127.0.0.1:61616 before negotiation: OpenWireFormat{version=6, cacheEnabled=false, stackTraceEnabled=false, tightEncodingEnabled=false, sizePrefixDisabled=false}
mq 07-03/09:58:59 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - tcp:///127.0.0.1:61616 after negotiation: OpenWireFormat{version=6, cacheEnabled=true, stackTraceEnabled=true, tightEncodingEnabled=true, sizePrefixDisabled=false}
mq 07-03/09:58:59 DEBUG [ActiveMQ Task] FailoverTransport - Connection established
mq 07-03/09:58:59  INFO [ActiveMQ Task] FailoverTransport - Successfully connected to nio://127.0.0.1:61616?socketBufferSize=1000000
 07-03/09:58:59 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.server.util.Setup$1@6c5482 to BG.Event.ru.bitel.bgbilling.kernel.event.events.system.ModuleConfigModifiedEvent
Module: dialup already installed. Reinstalling....
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 4
(1050) Table 'radius_pair_set_4' already exists
(1050) Table 'calculate_period_4' already exists
(1050) Table 'calculate_period_4' already exists
(1060) Duplicate column name 'script'
(1060) Duplicate column name 'object_id'
(1061) Duplicate key name 'object_id'
(1050) Table 'radius_pair_set_4' already exists
(1050) Table 'radius_pair_ip_4' already exists
(1061) Duplicate key name 'login_id'
(1060) Duplicate column name 'date1'
(1060) Duplicate column name 'date2'
(1050) Table 'login_parameter_4' already exists
(1050) Table 'login_parameter_log_4' already exists
(1091) Can't DROP 'login_alias'; check that column/key exists
(1061) Duplicate key name 'login_not_u'
(1091) Can't DROP 'alias'; check that column/key exists
(1061) Duplicate key name 'alias_not_u'
Module Instance init => OK
Executing call AddSchedulerTasks; param: dialup.sc
Scheduled class bitel.billing.server.dialup.MaxCalculator already exists!
Result => true
Executing call PutFile; param: dialup.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Remove libs => OK
Module dialup was successfull installed!
Please, restart BGBilling server.