UTM5 Создание индексов

maxijon

при создании индексов даю такую команду
mysql -f UTM5 < /netup/utm5/UTM5_indexes.sql
а выдает такую ошибку::
ERROR 1091 (42000) at line 1: Can't DROP 'charges_index_first'; check that column/key exists
ERROR 1091 (42000) at line 2: Can't DROP 'ip_charges_index_first'; check that column/key exists
ERROR 1091 (42000) at line 3: Can't DROP 'charges_index_second'; check that column/key exists
ERROR 1091 (42000) at line 4: Can't DROP 'services_index_first'; check that column/key exists
ERROR 1091 (42000) at line 5: Can't DROP 'first'; check that column/key exists
ERROR 1091 (42000) at line 6: Can't DROP 'first_set'; check that column/key exists
ERROR 1091 (42000) at line 7: Can't DROP 'first_block'; check that column/key exists
ERROR 1091 (42000) at line 8: Can't DROP 'first_dow'; check that column/key exists
ERROR 1091 (42000) at line 9: Can't DROP 'first_car'; check that column/key exists
ERROR 1091 (42000) at line 10: Can't DROP 'first_disc'; check that column/key exists
ERROR 1091 (42000) at line 11: Can't DROP 'first_disc1'; check that column/key exists
ERROR 1091 (42000) at line 12: Can't DROP 'first_dtr'; check that column/key exists
ERROR 1091 (42000) at line 13: Can't DROP 'first_ptr'; check that column/key exists
ERROR 1091 (42000) at line 14: Can't DROP 'first_ptr_hash'; check that column/key exists
ERROR 1091 (42000) at line 15: Can't DROP 'first_mes'; check that column/key exists
ERROR 1091 (42000) at line 16: Can't DROP 'first_ba'; check that column/key exists
ERROR 1091 (42000) at line 17: Can't DROP 'first_inv'; check that column/key exists
ERROR 1091 (42000) at line 18: Can't DROP 'first_inve'; check that column/key exists
ERROR 1091 (42000) at line 19: Can't DROP 'first_sess_tel'; check that column/key exists
ERROR 1091 (42000) at line 20: Can't DROP 'first_sess_dhs'; check that column/key exists
ERROR 1091 (42000) at line 21: Can't DROP 'first_access'; check that column/key exists
ERROR 1091 (42000) at line 22: Can't DROP 'first_dtagg'; check that column/key exists
ERROR 1091 (42000) at line 23: Can't DROP 'tel_session_date_idx'; check that column/key exists
ERROR 1091 (42000) at line 24: Can't DROP 'dhs_sess_id_idx'; check that column/key exists
ERROR 1091 (42000) at line 25: Can't DROP 'tel_last_update_date_status_idx'; check that column/key exists
ERROR 1091 (42000) at line 26: Can't DROP 'dhs_last_update_date_status_idx'; check that column/key exists
ERROR 1064 (42000) at line 27: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '82e61c4e8130890872ca7d5d2eedcce7 ON discount_transactions_all' at line 1
ERROR 1091 (42000) at line 28: Can't DROP 'b3e12acadb1bbd7f8eb9b8a9ac479e6c'; check that column/key exists
ERROR 1064 (42000) at line 29: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '92e08f5e788b4bcd2bd08d642d1f16f2 ON discount_transactions_all' at line 1
ERROR 1091 (42000) at line 30: Can't DROP '71be80c932a1d596a863a4f87ba05a03'; check that column/key exists
ERROR 1091 (42000) at line 31: Can't DROP 'a7d0ead92d1cf4a8163d3a14bd1d46f6'; check that column/key exists
ERROR 1091 (42000) at line 32: Can't DROP '8f8204600604c1b15a5072c16ae06092'; check that column/key exists
ERROR 1064 (42000) at line 33: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '568e4c2b879c970a554a72b09510a746 ON discount_transactions_all' at line 1
ERROR 1091 (42000) at line 34: Can't DROP '65de76c206634875d1728c8993f84885'; check that column/key exists
ERROR 1091 (42000) at line 35: Can't DROP '4b6c17c0fd9f68e3e613d3882ff322a7'; check that column/key exists
ERROR 1091 (42000) at line 36: Can't DROP 'ef21d08012d675959006724ce0a1ecac'; check that column/key exists
ERROR 1091 (42000) at line 37: Can't DROP '204db493907b7f4ddf2336ae78db201d'; check that column/key exists
ERROR 1091 (42000) at line 38: Can't DROP 'b37e82d403f2755b32e4baece65863a7'; check that column/key exists
ERROR 1091 (42000) at line 39: Can't DROP 'dc6f19ab68504e59c9e28ca44c643bdb'; check that column/key exists
ERROR 1091 (42000) at line 40: Can't DROP 'd875d2e79b84e0165fb2e50bc53ce02d'; check that column/key exists
ERROR 1091 (42000) at line 41: Can't DROP 'f5c13400f6c8eb3689044226d5b9a265'; check that column/key exists
ERROR 1091 (42000) at line 42: Can't DROP '045fce234c7df2742ece9efe8864b83f'; check that column/key exists
ERROR 1091 (42000) at line 43: Can't DROP '595a200705c6daa334d1e96e32583ea3'; check that column/key exists
ERROR 1091 (42000) at line 44: Can't DROP 'c35611f93e1dcb1ab505cb1715d5941b'; check that column/key exists
ERROR 1091 (42000) at line 45: Can't DROP '0a6b597fd01af47968faa8fa4d5c3f19'; check that column/key exists
ERROR 1091 (42000) at line 46: Can't DROP '64791de5ab4ea85459319893269706ea'; check that column/key exists
ERROR 1091 (42000) at line 47: Can't DROP 'index_b3e12acadb1bbd7f8eb9b8a9ac479e6c'; check that column/key exists
ERROR 1061 (42000) at line 49: Duplicate key name 'index_9d1685cdf3e0a9d70f4fec0aba516c96'
ERROR 1061 (42000) at line 50: Duplicate key name 'index_92e08f5e788b4bcd2bd08d642d1f16f2'
ERROR 1061 (42000) at line 51: Duplicate key name 'index_71be80c932a1d596a863a4f87ba05a03'
ERROR 1061 (42000) at line 52: Duplicate key name 'index_a7d0ead92d1cf4a8163d3a14bd1d46f6'
ERROR 1061 (42000) at line 54: Duplicate key name 'index_8f8204600604c1b15a5072c16ae06092'
ERROR 1061 (42000) at line 55: Duplicate key name 'index_568e4c2b879c970a554a72b09510a746'
ERROR 1061 (42000) at line 56: Duplicate key name 'index_65de76c206634875d1728c8993f84885'
ERROR 1061 (42000) at line 57: Duplicate key name 'index_4bc74b2ad5da849947708592ddfde8b0'
ERROR 1061 (42000) at line 58: Duplicate key name 'index_4b6c17c0fd9f68e3e613d3882ff322a7'
ERROR 1061 (42000) at line 59: Duplicate key name 'index_ef21d08012d675959006724ce0a1ecac'
ERROR 1061 (42000) at line 60: Duplicate key name 'index_204db493907b7f4ddf2336ae78db201d'
ERROR 1061 (42000) at line 61: Duplicate key name 'index_b37e82d403f2755b32e4baece65863a7'
ERROR 1061 (42000) at line 62: Duplicate key name 'index_dc6f19ab68504e59c9e28ca44c643bdb'
ERROR 1061 (42000) at line 63: Duplicate key name 'index_d875d2e79b84e0165fb2e50bc53ce02d'
ERROR 1061 (42000) at line 64: Duplicate key name 'index_f5c13400f6c8eb3689044226d5b9a265'
ERROR 1061 (42000) at line 65: Duplicate key name 'index_045fce234c7df2742ece9efe8864b83f'
ERROR 1061 (42000) at line 66: Duplicate key name 'index_10b5aec9e443da3b7f979447c17b91f0'
ERROR 1061 (42000) at line 67: Duplicate key name 'index_595a200705c6daa334d1e96e32583ea3'
ERROR 1061 (42000) at line 68: Duplicate key name 'index_c35611f93e1dcb1ab505cb1715d5941b'
ERROR 1061 (42000) at line 69: Duplicate key name 'index_0a6b597fd01af47968faa8fa4d5c3f19'
ERROR 1061 (42000) at line 70: Duplicate key name 'index_64791de5ab4ea85459319893269706ea'
ERROR 1061 (42000) at line 72: Duplicate key name 'index_33a254f7035d715e438372133be258b5'
ERROR 1061 (42000) at line 73: Duplicate key name 'index_55232d39c6b30c255118489783ed36e2'
ERROR 1061 (42000) at line 74: Duplicate key name 'index_4ac9ffe9ebe0322b6fb7d34f3e346a6b'
ERROR 1061 (42000) at line 75: Duplicate key name 'index_111a93e73d06cecc3151de62f6b8718a'
ERROR 1061 (42000) at line 76: Duplicate key name 'index_bbf43ea959eabadc856f5d9cb702d771'
ERROR 1061 (42000) at line 77: Duplicate key name 'index_264d0ebccce540730e5da3d221dfa3d9'
ERROR 1061 (42000) at line 78: Duplicate key name 'index_8386110d26da71c23ceb41e7c899588b'
ERROR 1061 (42000) at line 79: Duplicate key name 'index_597ea1b57b352ba4d3d45cf58ff2dfd4'
ERROR 1061 (42000) at line 81: Duplicate key name 'index_7f025766d1e19f86998a178fe5101326'
ERROR 1061 (42000) at line 83: Duplicate key name 'uniq_be4e0774e33beb054ed4067acc739e1a'
ERROR 1061 (42000) at line 84: Duplicate key name 'index_3d6b2a6e07480a9813b62ee3ab43cc98'
ERROR 1061 (42000) at line 85: Duplicate key name 'index_64379dea8f50ad04eb589c0c25d7f562'
ERROR 1061 (42000) at line 86: Duplicate key name 'index_1486e99935dc70297a21ec7e992d80e5'
ERROR 1061 (42000) at line 87: Duplicate key name 'index_f7a9f33a526682c6a9a52548843d600a'
как быть ???
спасибо заранее.

duzer · Сообщение **duzer** » Ср дек 07, 2011 13:31

Не критично. Вообще для discount_transactions_all оставили индексы:
KEY `first_disc` (`discount_date`), KEY `first_disc1` (`account_id`),
для discount_transactions_iptraffic_all
KEY `first_dtr` (`discount_date`,`account_id`,`slink_id`), KEY `t_class` (`t_class`), KEY `account_id` (`account_id`).
В купе с сортировкой данных в архивных таблицах по account_id отчеты на сервере с 6Гб памяти выполняются влет (порядка ~40М записей на табличку).

JAO · Сообщение **JAO** » Ср дек 07, 2011 18:40

Я сортировал по account_id только старые годовые таблицы, изготовленные руками при переходе с версии 5.2.1-005. Теперь архивные таблицы делаются скриптом раз в месяц. Отрезаются, как есть, и делу конец. Скорость на отчетах приемлемая.

multics

У тебя же написано - по английски - ошибка синтаксиса мускула
или делай безпарольный вход в мускул и давай ту команду что ты написал
или делай наподобие -
mysql --user root -p UTM5 < /root/reg.sql
потом вводишь логин и пароль для мускула(root у мускула свой - а не тот что
в юниксах, но лучше сделать отдельного администратора для мускула )
таким макаром можешь и перенаправить мускулу другой файл - например с индексами

Artik · Сообщение **Artik** » Вт мар 13, 2012 06:17

У меня аналогичная проблема. ОС Debian.

root@billing:/home/bill# mysql -u root -p -f UTM5 < /netup/utm5/UTM5_indexes.sql

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

Enter password&#58; 

ERROR 1091 &#40;42000&#41; at line 1&#58; Can't DROP 'charges_index_first'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 2&#58; Can't DROP 'ip_charges_index_first'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 3&#58; Can't DROP 'charges_index_second'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 4&#58; Can't DROP 'services_index_first'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 5&#58; Can't DROP 'first'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 6&#58; Can't DROP 'first_set'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 7&#58; Can't DROP 'first_block'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 8&#58; Can't DROP 'first_dow'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 9&#58; Can't DROP 'first_car'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 10&#58; Can't DROP 'first_disc'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 11&#58; Can't DROP 'first_disc1'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 12&#58; Can't DROP 'first_dtr'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 13&#58; Can't DROP 'first_ptr'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 14&#58; Can't DROP 'first_ptr_hash'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 15&#58; Can't DROP 'first_mes'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 16&#58; Can't DROP 'first_ba'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 17&#58; Can't DROP 'first_inv'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 18&#58; Can't DROP 'first_inve'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 19&#58; Can't DROP 'first_sess_tel'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 20&#58; Can't DROP 'first_sess_dhs'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 21&#58; Can't DROP 'first_access'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 22&#58; Can't DROP 'first_dtagg'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 23&#58; Can't DROP 'tel_session_date_idx'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 24&#58; Can't DROP 'dhs_sess_id_idx'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 25&#58; Can't DROP 'tel_last_update_date_status_idx'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 26&#58; Can't DROP 'dhs_last_update_date_status_idx'; check that column/key exists
ERROR 1064 &#40;42000&#41; at line 27&#58; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '82e61c4e8130890872ca7d5d2eedcce7 ON discount_transactions_all' at line 1
ERROR 1091 &#40;42000&#41; at line 28&#58; Can't DROP 'b3e12acadb1bbd7f8eb9b8a9ac479e6c'; check that column/key exists
ERROR 1064 &#40;42000&#41; at line 29&#58; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '92e08f5e788b4bcd2bd08d642d1f16f2 ON discount_transactions_all' at line 1
ERROR 1091 &#40;42000&#41; at line 30&#58; Can't DROP '71be80c932a1d596a863a4f87ba05a03'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 31&#58; Can't DROP 'a7d0ead92d1cf4a8163d3a14bd1d46f6'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 32&#58; Can't DROP '8f8204600604c1b15a5072c16ae06092'; check that column/key exists
ERROR 1064 &#40;42000&#41; at line 33&#58; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '568e4c2b879c970a554a72b09510a746 ON discount_transactions_all' at line 1
ERROR 1091 &#40;42000&#41; at line 34&#58; Can't DROP '65de76c206634875d1728c8993f84885'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 35&#58; Can't DROP '4b6c17c0fd9f68e3e613d3882ff322a7'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 36&#58; Can't DROP 'ef21d08012d675959006724ce0a1ecac'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 37&#58; Can't DROP '204db493907b7f4ddf2336ae78db201d'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 38&#58; Can't DROP 'b37e82d403f2755b32e4baece65863a7'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 39&#58; Can't DROP 'dc6f19ab68504e59c9e28ca44c643bdb'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 40&#58; Can't DROP 'd875d2e79b84e0165fb2e50bc53ce02d'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 41&#58; Can't DROP 'f5c13400f6c8eb3689044226d5b9a265'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 42&#58; Can't DROP '045fce234c7df2742ece9efe8864b83f'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 43&#58; Can't DROP '595a200705c6daa334d1e96e32583ea3'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 44&#58; Can't DROP 'c35611f93e1dcb1ab505cb1715d5941b'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 45&#58; Can't DROP '0a6b597fd01af47968faa8fa4d5c3f19'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 46&#58; Can't DROP '64791de5ab4ea85459319893269706ea'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 47&#58; Can't DROP 'index_b3e12acadb1bbd7f8eb9b8a9ac479e6c'; check that column/key exists
ERROR 1061 &#40;42000&#41; at line 49&#58; Duplicate key name 'index_9d1685cdf3e0a9d70f4fec0aba516c96'
ERROR 1061 &#40;42000&#41; at line 50&#58; Duplicate key name 'index_92e08f5e788b4bcd2bd08d642d1f16f2'
ERROR 1061 &#40;42000&#41; at line 51&#58; Duplicate key name 'index_71be80c932a1d596a863a4f87ba05a03'
ERROR 1061 &#40;42000&#41; at line 52&#58; Duplicate key name 'index_a7d0ead92d1cf4a8163d3a14bd1d46f6'
ERROR 1061 &#40;42000&#41; at line 54&#58; Duplicate key name 'index_8f8204600604c1b15a5072c16ae06092'
ERROR 1061 &#40;42000&#41; at line 55&#58; Duplicate key name 'index_568e4c2b879c970a554a72b09510a746'
ERROR 1061 &#40;42000&#41; at line 56&#58; Duplicate key name 'index_65de76c206634875d1728c8993f84885'
ERROR 1061 &#40;42000&#41; at line 57&#58; Duplicate key name 'index_4bc74b2ad5da849947708592ddfde8b0'
ERROR 1061 &#40;42000&#41; at line 58&#58; Duplicate key name 'index_4b6c17c0fd9f68e3e613d3882ff322a7'
ERROR 1061 &#40;42000&#41; at line 59&#58; Duplicate key name 'index_ef21d08012d675959006724ce0a1ecac'
ERROR 1061 &#40;42000&#41; at line 60&#58; Duplicate key name 'index_204db493907b7f4ddf2336ae78db201d'
ERROR 1061 &#40;42000&#41; at line 61&#58; Duplicate key name 'index_b37e82d403f2755b32e4baece65863a7'
ERROR 1061 &#40;42000&#41; at line 62&#58; Duplicate key name 'index_dc6f19ab68504e59c9e28ca44c643bdb'
ERROR 1061 &#40;42000&#41; at line 63&#58; Duplicate key name 'index_d875d2e79b84e0165fb2e50bc53ce02d'
ERROR 1061 &#40;42000&#41; at line 64&#58; Duplicate key name 'index_f5c13400f6c8eb3689044226d5b9a265'
ERROR 1061 &#40;42000&#41; at line 65&#58; Duplicate key name 'index_045fce234c7df2742ece9efe8864b83f'
ERROR 1061 &#40;42000&#41; at line 66&#58; Duplicate key name 'index_10b5aec9e443da3b7f979447c17b91f0'
ERROR 1061 &#40;42000&#41; at line 67&#58; Duplicate key name 'index_595a200705c6daa334d1e96e32583ea3'
ERROR 1061 &#40;42000&#41; at line 68&#58; Duplicate key name 'index_c35611f93e1dcb1ab505cb1715d5941b'
ERROR 1061 &#40;42000&#41; at line 69&#58; Duplicate key name 'index_0a6b597fd01af47968faa8fa4d5c3f19'
ERROR 1061 &#40;42000&#41; at line 70&#58; Duplicate key name 'index_64791de5ab4ea85459319893269706ea'
ERROR 1061 &#40;42000&#41; at line 72&#58; Duplicate key name 'index_33a254f7035d715e438372133be258b5'
ERROR 1061 &#40;42000&#41; at line 73&#58; Duplicate key name 'index_55232d39c6b30c255118489783ed36e2'
ERROR 1061 &#40;42000&#41; at line 74&#58; Duplicate key name 'index_4ac9ffe9ebe0322b6fb7d34f3e346a6b'
ERROR 1061 &#40;42000&#41; at line 75&#58; Duplicate key name 'index_111a93e73d06cecc3151de62f6b8718a'
ERROR 1061 &#40;42000&#41; at line 76&#58; Duplicate key name 'index_bbf43ea959eabadc856f5d9cb702d771'
ERROR 1061 &#40;42000&#41; at line 77&#58; Duplicate key name 'index_264d0ebccce540730e5da3d221dfa3d9'
ERROR 1061 &#40;42000&#41; at line 78&#58; Duplicate key name 'index_8386110d26da71c23ceb41e7c899588b'
ERROR 1061 &#40;42000&#41; at line 79&#58; Duplicate key name 'index_597ea1b57b352ba4d3d45cf58ff2dfd4'
ERROR 1061 &#40;42000&#41; at line 81&#58; Duplicate key name 'index_7f025766d1e19f86998a178fe5101326'
ERROR 1061 &#40;42000&#41; at line 83&#58; Duplicate key name 'uniq_be4e0774e33beb054ed4067acc739e1a'
ERROR 1061 &#40;42000&#41; at line 84&#58; Duplicate key name 'index_3d6b2a6e07480a9813b62ee3ab43cc98'
ERROR 1061 &#40;42000&#41; at line 85&#58; Duplicate key name 'index_64379dea8f50ad04eb589c0c25d7f562'
ERROR 1061 &#40;42000&#41; at line 86&#58; Duplicate key name 'index_1486e99935dc70297a21ec7e992d80e5'
ERROR 1061 &#40;42000&#41; at line 87&#58; Duplicate key name 'index_f7a9f33a526682c6a9a52548843d600a'

При попытке импортировать файл в базу через phpmyadmin таже история

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

SQL-запрос&#58;

DROP INDEX charges_index_firs ON discount_transactions_all;

Ответ MySQL&#58;

#1091 - Can't DROP 'charges_index_first'; check that column/key exists

Всё выполнял по руководству из прилагающейся книги.

hRUst · Сообщение **hRUst** » Вт мар 13, 2012 07:47

Сказали же - это нормально. Обновление индексов идет, удаляются старые/ненужные, если у вас каких-то не было - выдает ошибку соответственно.

Artik · Сообщение **Artik** » Вт мар 13, 2012 08:40

Ясно, спасибо за разъяснение.
Может и не в тему ветки форума, но у меня при старте вот такая вот штука:

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

root@billing&#58;/home/bill# /etc/init.d/utm5_core start
Starting utm5_core
root@billing&#58;/home/bill# Starting utm5_core
?Debug &#58; Mar 13 11&#58;30&#58;11 b70516f0 Rehash&#58; Rehash manager started
 Notice&#58; Mar 13 11&#58;30&#58;11 b70516f0 ModMap&#58; Sub-Module 'rehash' inserted...
 Notice&#58; Mar 13 11&#58;30&#58;11 b70516f0 UTM5 Config&#58; Processing config file&#58; /netup/utm5/utm5.cfg
?Debug &#58; Mar 13 11&#58;30&#58;11 b70516f0 ModMap&#58; Module <rehash> exist
 Notice&#58; Mar 13 11&#58;30&#58;11 b70516f0 ModMap&#58; Sub-Module 'config' inserted...
?Debug &#58; Mar 13 11&#58;30&#58;11 b70516f0 ModMap&#58; Module <config> exist
?Debug &#58; Mar 13 11&#58;30&#58;11 b70516f0 ModMap&#58; Module <rehash> exist
 Notice&#58; Mar 13 11&#58;30&#58;11 b70516f0 ModMap&#58; Sub-Module 'logger' inserted...
*CRIT  &#58; Mar 13 11&#58;30&#58;11 b70516f0 DBA&#58;Ctx&#58; Connection with DB server failed&#58; check whether DB server is running and DB settings in your utm5.cfg file.
*CRIT  &#58; Mar 13 11&#58;30&#58;11 b70516f0 UTM5 Core&#58; ModMap fatal init exception. Aborting
utm5_core process exited ... mail to admin sent. Sleeping 5 sec!

Pei0t · Сообщение **Pei0t** » Вт мар 13, 2012 08:50

что смущает?

Artik · Сообщение **Artik** » Вт мар 13, 2012 09:13

То есть, тут всё так и должно быть? Процесс прерывается и отправляется письмо админу. Подскажите, где можно посмотреть логи или эти письма, что бы разобраться с ситуацией.

Просто, при подключении к серверу через utm_admin.jar нет соединения.

Connection refused: connect

Всё делал по инструкции. Возможно, не запущеные какие нибудь процессы. Подскажите какие варианты могут быть?

maxijon

Artik

Посмотри ка процес UTM-CORE запущен ?

duzer · Сообщение **duzer** » Вт мар 13, 2012 09:38

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

*CRIT  &#58; Mar 13 11&#58;30&#58;11 b70516f0 DBA&#58;Ctx&#58; Connection with DB server failed&#58; check whether DB server is running and DB settings in your utm5.cfg file.

не смущает?

Artik · Сообщение **Artik** » Вт мар 13, 2012 11:28

Извиняюсь за свою невнимательность.
Пока носом не ткнули, не увидел. Поправил файлик utm5.cfg и всё заработало.
Всем спасибо

kairat · Сообщение **kairat** » Пт окт 24, 2014 10:01

Artik писал(а):Извиняюсь за свою невнимательность.
Пока носом не ткнули, не увидел. Поправил файлик utm5.cfg и всё заработало.
Всем спасибо

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

alexus · Сообщение **alexus** » Вт янв 06, 2015 02:37

разобрался