Oct 24, 2008 10:22:27 AM org.apache.catalina.startup.Embedded start
INFO: Starting tomcat server
Oct 24, 2008 10:22:28 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Oct 24, 2008 10:22:28 AM org.apache.catalina.startup.ContextConfig defaultWebConfig
INFO: No default web.xml
Oct 24, 2008 10:22:28 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Oct 24, 2008 10:22:28 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
24.10.2008 10:22:55 com.mysql.jdbc.exceptions.MySQLDataException: '2886991873' in column '5' is outside valid range for the datatype INTEGER.
24.10.2008 10:22:55    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:893)
24.10.2008 10:22:55    at com.mysql.jdbc.ResultSet.throwRangeException(ResultSet.java:7402)
24.10.2008 10:22:55    at com.mysql.jdbc.ResultSet.getNativeInt(ResultSet.java:3978)
24.10.2008 10:22:55    at com.mysql.jdbc.ResultSet.getNativeInt(ResultSet.java:3903)
24.10.2008 10:22:55    at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2499)
24.10.2008 10:22:55    at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2514)
24.10.2008 10:22:55    at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:220)
24.10.2008 10:22:55    at bitel.billing.server.admin.resource.bean.ip.IPResourceRangeManager.getResourceFromRs(IPResourceRangeManager.java:98)
24.10.2008 10:22:55    at bitel.billing.server.admin.resource.bean.ip.IPResourceRangeManager$1.getFromRS(IPResourceRangeManager.java:232)
24.10.2008 10:22:55    at bitel.billing.server.admin.resource.bean.ip.IPResourceRangeManager$1.getFromRS(IPResourceRangeManager.java:1)
24.10.2008 10:22:55    at bitel.billing.server.util.Iter$ResultSetIterator.next(Iter.java:90)
24.10.2008 10:22:55    at bitel.billing.server.admin.resource.ActionIPResourceTable.doAction(ActionIPResourceTable.java:90)
24.10.2008 10:22:55    at bitel.billing.server.Executer.doModule(Executer.java:693)
24.10.2008 10:22:55    at bitel.billing.server.Executer.doPost(Executer.java:177)
24.10.2008 10:22:55    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
24.10.2008 10:22:55    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
24.10.2008 10:22:55    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
24.10.2008 10:22:55    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
24.10.2008 10:22:55    at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:37)
24.10.2008 10:22:55    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
24.10.2008 10:22:55    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
24.10.2008 10:22:55    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
24.10.2008 10:22:55    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
24.10.2008 10:22:55    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
24.10.2008 10:22:55    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
24.10.2008 10:22:55    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
24.10.2008 10:22:55    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
24.10.2008 10:22:55    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
24.10.2008 10:22:55    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
24.10.2008 10:22:55    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
24.10.2008 10:22:55    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
24.10.2008 10:22:55    at java.lang.Thread.run(Thread.java:619)
24.10.2008 10:22:55 java.lang.NullPointerException
24.10.2008 10:22:55    at bitel.billing.server.admin.resource.ActionIPResourceTable.doAction(ActionIPResourceTable.java:93)
24.10.2008 10:22:55    at bitel.billing.server.Executer.doModule(Executer.java:693)
24.10.2008 10:22:55    at bitel.billing.server.Executer.doPost(Executer.java:177)
24.10.2008 10:22:55    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
24.10.2008 10:22:55    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
24.10.2008 10:22:55    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
24.10.2008 10:22:55    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
24.10.2008 10:22:55    at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:37)
24.10.2008 10:22:55    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
24.10.2008 10:22:55    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
24.10.2008 10:22:55    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
24.10.2008 10:22:55    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
24.10.2008 10:22:55    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
24.10.2008 10:22:55    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
24.10.2008 10:22:55    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
24.10.2008 10:22:55    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
24.10.2008 10:22:55    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
24.10.2008 10:22:55    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
24.10.2008 10:22:55    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
24.10.2008 10:22:55    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
24.10.2008 10:22:55    at java.lang.Thread.run(Thread.java:619)

Downloading ipn_4.5_109.zip OK!
Downloading dialup_4.5_92.zip OK!
Downloading npay_4.5_90.zip OK!
Downloading reports_4.5_89.zip OK!
Downloading update_4.5.zip OK!
Start installing..
Module: ipn already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 1
Duplicate column name 'type'
Duplicate column name 'config'
Duplicate column name 'rtid'
Table 'ipn_gate_type_1' already exists
Table 'ipn_rule_type_1' already exists
Duplicate column name 'object_id'
Duplicate key name 'object_id'
Table 'ipn_iface_1' already exists
Table 'ipn_zone_1' already exists
Duplicate column name 'iface'
Duplicate column name 'iface'
Duplicate column name 'parent_id'
Duplicate column name 'plan_id'
Table 'ipn_service_link_plan_1' already exists
Duplicate column name 'plan_id'
Duplicate column name 'pers_plan_id'
Table 'detail_create_task_1' already exists
Table 'ip_resource_1' already exists
Table 'ip_resource_category_1' already exists
Duplicate column name 'rule'
Duplicate column name 'script'
Table 'ipn_gate_rule_1' already exists
Table 'ipn_gate_vlan_1' already exists
Table 'ip_resource_range_1' already exists
Can't DROP 'cid'; check that column/key exists
Module Instance init => OK
Executing call ExecuteSQL; param: atc.sql
Executing database update...OK
Result => true
Executing call AddSchedulerTasks; param: ipn.sc
Scheduled class bitel.billing.server.ipn.LogCalculator already exists!
Scheduled class bitel.billing.server.ipn.IPNTestGates already exists!
Scheduled class bitel.billing.server.ipn.MaxCalculator already exists!
Result => true
Executing call PutFile; param: ipn.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module ipn was successfull installed!
Please, restart BGBilling server.
Module: dialup already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 2
Table 'calculate_period_2' already exists
Duplicate column name 'script'
Duplicate column name 'object_id'
Duplicate key name 'object_id'
Table 'radius_pair_set_2' already exists
Table 'radius_pair_ip_2' already exists
Duplicate key name 'login_id'
Duplicate column name 'date1'
Duplicate column name 'date2'
Table 'login_parameter_2' already exists
Table 'login_parameter_log_2' already exists
Duplicate key name 'login_not_u'
Module Instance init => OK
Executing call ExecuteSQL; param: atc.sql
Executing database update...OK
Result => true
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
Module dialup was successfull installed!
Please, restart BGBilling server.
Module: npay already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 3
Duplicate column name 'col'
Module Instance init => OK
Executing call AddSchedulerTasks; param: pay.sc
Scheduled class bitel.billing.server.npay.Calculator already exists!
Result => true
Executing call ExecuteSQL; param: atc.sql
Executing database update...OK
Result => true
Executing call PutFile; param: npay.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module npay was successfull installed!
Please, restart BGBilling server.
Module: reports already installed.
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 ExecuteSQL; param: reports.sql
Executing database update...OK
Result => true
Executing call PutFile; param: reports:.
Result => true
Executing call PutFile; param: reports.xml:actions
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module reports was successfull installed!
Please, restart BGBilling server.
Installing module: update...
Data extract finished...
Extract data => OK
Error of updating database.
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1938657 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2584)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299)
        at bitel.billing.server.installer.InstallerModule.updateBase(InstallerModule.java:272)
        at bitel.billing.server.installer.InstallerModule.<init>(InstallerModule.java:31)
        at bitel.billing.server.installer.Update.update(Update.java:237)
        at bitel.billing.server.installer.Update.<init>(Update.java:38)
        at bitel.billing.server.installer.ModuleInstaller.main(ModuleInstaller.java:17)
Base update => ERROR
Module was not installed.