После заливки базы MySQL перестала загружаться UTM5

[Munsera]

Здравствуйте!
На одной машине: Centos+Utm5+Mysql 5.0.77
Все развернул с нуля. Все работает.

Код: Выделить всё

mysqdumb -u root -p UTM5 > ~/UTM5.sql 
mysql -D UTM5 < ~/UTM5.sql 

После того как выгрузил дамп с аналогичной машины с аналогичным набором программ и загрузил сюда, перестала запускаться UTM5:

Код: Выделить всё

?Debug &#58; Aug 07 03&#58;31&#58;41 ModMap&#58; Module <rehash> exist
 Notice&#58; Aug 07 03&#58;31&#58;41 ModMap&#58; Sub-Module 'config' inserted...
?Debug &#58; Aug 07 03&#58;31&#58;41 ModMap&#58; Module <config> exist
?Debug &#58; Aug 07 03&#58;31&#58;41 ModMap&#58; Module <rehash> exist
 Notice&#58; Aug 07 03&#58;31&#58;41 ModMap&#58; Sub-Module 'logger' inserted...
*ALERT &#58; Aug 07 03&#58;32&#58;01 UTM5 DBA&#58; Exception caught on startup. See debug log for detail
*CRIT  &#58; Aug 07 03&#58;32&#58;01 UTM5 Core&#58; ModMap fatal init exception. Aborting
utm5_core process exited ... mail to admin sent. Sleeping 5 sec!

Код: Выделить всё

File: /netup/utm5/log/main.log  

 ERRORore process3&#58;32&#58;18 DBCtx&#58; <165241400> MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;18 DBASQLError&#58; MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;18 DBCtx&#58; Exception while doing SQL select !
 ERROR &#58; Aug 07 03&#58;32&#58;19 DBCtx&#58; <145388088> MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;19 DBASQLError&#58; MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;19 DBCtx&#58; Exception while doing SQL select !
 ERROR &#58; Aug 07 03&#58;32&#58;28 DBCtx&#58; <165241400> MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;28 DBASQLError&#58; MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;28 DBCtx&#58; Exception while doing SQL select !
 ERROR &#58; Aug 07 03&#58;32&#58;28 DBAExistingError&#58; trying to get not existing ip traffic service 46
*ALERT &#58; Aug 07 03&#58;32&#58;28 UTM5 DBA&#58; Exception caught on startup. See debug log for detail
*CRIT  &#58; Aug 07 03&#58;32&#58;28 UTM5 Core&#58; ModMap fatal init exception. Aborting
 ERROR &#58; Aug 07 03&#58;32&#58;29 DBCtx&#58; <145388088> MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;29 DBASQLError&#58; MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;29 DBCtx&#58; Exception while doing SQL select !
 ERROR &#58; Aug 07 03&#58;32&#58;30 DBAExistingError&#58; trying to get not existing ip traffic service 46
*ALERT &#58; Aug 07 03&#58;32&#58;30 UTM5 DBA&#58; Exception caught on startup. See debug log for detail
*CRIT  &#58; Aug 07 03&#58;32&#58;30 UTM5 Core&#58; ModMap fatal init exception. Aborting
 ERROR &#58; Aug 07 03&#58;32&#58;41 DBCtx&#58; <171557432> MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;41 DBASQLError&#58; MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;41 DBCtx&#58; Exception while doing SQL select !
 ERROR &#58; Aug 07 03&#58;32&#58;51 DBCtx&#58; <171557432> MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;51 DBASQLError&#58; MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;32&#58;51 DBCtx&#58; Exception while doing SQL select !
 ERROR &#58; Aug 07 03&#58;32&#58;52 DBAExistingError&#58; trying to get not existing ip traffic service 46
*ALERT &#58; Aug 07 03&#58;32&#58;52 UTM5 DBA&#58; Exception caught on startup. See debug log for detail
*CRIT  &#58; Aug 07 03&#58;32&#58;52 UTM5 Core&#58; ModMap fatal init exception. Aborting
 ERROR &#58; Aug 07 03&#58;33&#58;08 DBCtx&#58; <161923640> MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;33&#58;08 DBASQLError&#58; MySQL query failed&#58;
 ERROR &#58; Aug 07 03&#58;33&#58;08 DBCtx&#58; Exception while doing SQL select !

Код: Выделить всё

?Debug &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; fill_downloaded&#58; slink_id=<1061> tclass_id=<0> cust_prep=<0>
?Debug &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; fill_downloaded&#58; slink_id=<1061> tclass_id=<10> cust_prep=<0>
?Debug &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; fill_downloaded&#58; slink_id=<1061> tclass_id=<15> cust_prep=<0>
?Debug &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; fill_downloaded&#58; slink_id=<1061> tclass_id=<20> cust_prep=<0>
?Debug &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; fill_downloaded&#58; slink_id=<1063> tclass_id=<0> cust_prep=<0>
?Debug &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; fill_downloaded&#58; slink_id=<1063> tclass_id=<10> cust_prep=<0>
?Debug &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; fill_downloaded&#58; slink_id=<1063> tclass_id=<15> cust_prep=<0>
?Debug &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; fill_downloaded&#58; slink_id=<1063> tclass_id=<20> cust_prep=<0>
?Debug &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; fill_downloaded&#58; slink_id=<1065> tclass_id=<0> cust_prep=<0>
?Debug &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; fill_downloaded&#58; slink_id=<1065> tclass_id=<10> cust_prep=<0>
?Debug &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; fill_downloaded&#58; slink_id=<1065> tclass_id=<20> cust_prep=<0>
?Debug &#58; Aug 07 03&#58;36&#58;21 Rehash&#58; Rehash manager startedquery&#58; SELECT id,cost,drop_from_group FROM once_service_data WHERE is_deleted=0
?Debug &#58; Aug 06 20&#58;41&#58;48 DBCtx&#58; <163619544> SQL SELECT query&#58; SELECT tel_service_id,tarif_key,border,cost FROM tel_services_borders WHERE is_deleted=0
?Debug &#58; Aug 06 20&#58;41&#58;48 DBCtx&#58; <163619544> SQL SELECT query&#58; SELECT tel_service_id,tarif_key,prepaid FROM tel_services_prepaid WHERE is_deleted=0
?Debug &#58; Aug 06 20&#58;41&#58;48 DBCtx&#58; <163619544> SQL SELECT query&#58; SELECT tel_service_id,tarif_key,time_range_id,mult FROM tel_services_tr_mult WHERE is_deleted=0
?Debug &#58; Aug 06 20&#58;41&#58;48 DBCtx&#58; <163619544> SQL SELECT query&#58; SELECT id FROM tel_service_links WHERE is_deleted=0
?Debug &#58; Aug 06 20&#58;41&#58;48 DBCtx&#58; <163619544> SQL SELECT query&#58; SELECT slink_id,zone_id,duration FROM dtagg_telephony WHERE is_closed=0
?Debug &#58; Aug 06 20&#58;41&#58;48 DBCtx&#58; <163619544> SQL SELECT query&#58; SELECT slink_id, tarif_key, downed_as_prepaid, old_prepaid, custom_prepaid FROM tel_service_links_prepaid WHERE is_deleted=0
?Debug &#58; Aug 06 20&#58;41&#58;48 DBCtx&#58; <163619544> SQL SELECT query&#58; SELECT id,slink_id,tel_number,login,password,allowed_cid FROM tel_numbers WHERE is_deleted=0
?Debug &#58; Aug 06 20&#58;41&#58;48 DBCtx&#58; <163619544> SQL SELECT query&#58; SELECT service_id,ip,mask FROM hotspot_network_list WHERE is_deleted='0'
?Debug &#58; Aug 06 20&#58;41&#58;48 DBCtx&#58; <163619544> SQL SELECT query&#58; SELECT tariff_id, service_id FROM tariffs_services_link WHERE is_deleted=0
 ERROR &#58; Aug 06 20&#58;41&#58;48 DBAExistingError&#58; trying to get not existing ip traffic service 46
?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; Obtained 11 stack frames.
?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; /netup/utm5/bin/utm5_core&#40;_Z15print_backtracev+0x22&#41; &#91;0x84ab392&#93;

?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM8DBAErrorC2ERKSsS2_b+0x6b&#41; &#91;0x8246d7b&#93;

?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM16DBAExistingErrorC1ESs+0x4f&#41; &#91;0x8246f9f&#93;

?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM8DBAccess21get_iptraffic_serviceEi+0xb7&#41; &#91;0x8253f77&#93;

?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM8DBAccess24__fill_downed_as_prepaidEv+0xc3&#41; &#91;0x829ad73&#93;

?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM8DBAccess18fill_mega_storagesEv+0x168&#41; &#91;0x82354c8&#93;

?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM8DBAccess11dbamod_initEPNS_6ModTopES2_+0x44&#41; &#91;0x82358e4&#93;

?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM6ModMap7sub_putEPNS_6ModTopE+0x1a8&#41; &#91;0x82497c8&#93;

?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; /netup/utm5/bin/utm5_core&#40;main+0xce7&#41; &#91;0x84132b7&#93;

?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; /lib/libc.so.6&#40;__libc_start_main+0xdc&#41; &#91;0x8e2e9c&#93;

?Trace &#58; Aug 06 20&#58;41&#58;48 trace&#58; /netup/utm5/bin/utm5_core &#91;0x82342d1&#93;

-Stats &#58; Aug 06 20&#58;41&#58;48 DBA Groups&#58;    Stats&#58; Uptime&#58; 00&#58;00&#58;21. Events&#58; 0; Errors&#58; 0
*ALERT &#58; Aug 06 20&#58;41&#58;48 UTM5 DBA&#58; Exception caught on startup. See debug log for detail
*CRIT  &#58; Aug 06 20&#58;41&#58;48 UTM5 Core&#58; ModMap fatal init exception. Aborting

В чем может быть дело?
Спасибо!

[Munsera]

Коллеги, помогите.
Не могу перенести базу на новый сервер...

[rudf]

Коллеги, помогите.
Не могу перенести базу на новый сервер...

У вас точно одинаковые версии УТМки на обоих машинах? update.sql скрипт пробовали прогнать?

[Munsera]

Спасибо за ответ!
UTM'ки обе пятой версии, но отличаются.
Есть мануал по использованию данного скрипта?

[rudf]

Спасибо за ответ!
UTM'ки обе пятой версии, но отличаются.
Есть мануал по использованию данного скрипта?

Ну дык поставьте одинаковой версии, а потом обновитесь при необходимости. По поводу update.sql скрипта смотрите инструкцию по обновлению :

http://www.netup.ru/UTM5/articles.php?n=53

[Munsera]

Спасибо большое за ответ!
Поставил такую же версию программы - все заработало!

[rudf]

Спасибо большое за ответ!
Поставил такую же версию программы - все заработало!

Да пожалуйста