BiTel

Форум BiTel
bgbilling.ru     docs.bitel.ru     wiki.bitel.ru     dbinfo.bitel.ru     bgcrm.ru     billing.bitel.ru     bitel.ru    
Текущее время: 28 апр 2024, 12:32

Часовой пояс: UTC + 5 часов [ Летнее время ]




Начать новую тему Ответить на тему  [ Сообщений: 4 ] 
Автор Сообщение
 Заголовок сообщения: [5.2]Некорректная установка
СообщениеДобавлено: 03 июл 2012, 04:07 
Не в сети
Клиент

Зарегистрирован: 19 май 2011, 19:29
Сообщения: 42
Карма: 0
Код:
Информация о версии:

  Клиент: вер. 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)



Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: [5.2]Некорректная установка
СообщениеДобавлено: 03 июл 2012, 09:41 
Не в сети
Разработчик

Зарегистрирован: 08 ноя 2007, 01:05
Сообщения: 8343
Откуда: Уфа
Карма: 238
Попробуйте удалить снова поле и запустить установку модуля снова

bg_installer.sh dialup_5.2_XXX.zip!

Если не поле не появится, то покажите лог этой установки.

Еще можете попробовать запустить
Код:
./bg_installer.sh killhash mXX


Где XX - это код экземпляра модуля Dilaup.
И потом снова
bg_installer.sh dialup_5.2_XXX.zip!

Лог установки тоже сюда .


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: [5.2]Некорректная установка
СообщениеДобавлено: 03 июл 2012, 12:28 
Не в сети
Клиент

Зарегистрирован: 19 май 2011, 19:29
Сообщения: 42
Карма: 0
При простой перестановке не помогло:
Код:
 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.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: [5.2]Некорректная установка
СообщениеДобавлено: 03 июл 2012, 12:30 
Не в сети
Клиент

Зарегистрирован: 19 май 2011, 19:29
Сообщения: 42
Карма: 0
Делаем 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.


И поле появилось


Вернуться к началу
 Профиль  
 
Показать сообщения за:  Поле сортировки  
Начать новую тему Ответить на тему  [ Сообщений: 4 ] 

Часовой пояс: UTC + 5 часов [ Летнее время ]


Кто сейчас на конференции

Сейчас этот форум просматривают: нет зарегистрированных пользователей и гости: 1


Вы не можете начинать темы
Вы не можете отвечать на сообщения
Вы не можете редактировать свои сообщения
Вы не можете удалять свои сообщения
Вы не можете добавлять вложения

Найти:
Перейти:  
POWERED_BY
Русская поддержка phpBB
[ Time : 0.372s | 26 Queries | GZIP : On ]