forum.bitel.ru http://forum.bitel.ru/ |
|
[5.2]Некорректная установка http://forum.bitel.ru/viewtopic.php?f=5&t=6922 |
Страница 1 из 1 |
Автор: | Andrew [ 03 июл 2012, 04:07 ] |
Заголовок сообщения: | [5.2]Некорректная установка |
Код: Информация о версии: Клиент: вер. 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 Продолжается переход 5.1-->5.2 =) При чистой установке модуля dialup не создается поле 'common_config_id' в таблице 'nas_№_модуля' Переустановка модуля не помогает. Пока я тыкал и искал он при каждой попытке, не создавая nas, создавал для него конфиг. Создание поле в таблице устранило все проблемы =) P.S. кусок лога, если интересно Код: 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) |
Автор: | stark [ 03 июл 2012, 09:41 ] |
Заголовок сообщения: | Re: [5.2]Некорректная установка |
Попробуйте удалить снова поле и запустить установку модуля снова bg_installer.sh dialup_5.2_XXX.zip! Если не поле не появится, то покажите лог этой установки. Еще можете попробовать запустить Код: ./bg_installer.sh killhash mXX Где XX - это код экземпляра модуля Dilaup. И потом снова bg_installer.sh dialup_5.2_XXX.zip! Лог установки тоже сюда . |
Автор: | Andrew [ 03 июл 2012, 12:28 ] |
Заголовок сообщения: | Re: [5.2]Некорректная установка |
При простой перестановке не помогло: Код: 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. |
Автор: | Andrew [ 03 июл 2012, 12:30 ] |
Заголовок сообщения: | Re: [5.2]Некорректная установка |
Делаем killhash Код: 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. И поле появилось |
Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |