Служба "UTM5 Core Service" завершена из-за внутренней ошибки %%-1.
Логи:
debug.log:
Info : Aug 31 11:18:42 UTM5 Logger: New `?Debug : ' stream: log\debug.log
Info : Aug 31 11:18:42 UTM5 Logger: New ` Info : ' stream: log\main.log
Info : Aug 31 11:18:42 UTMCtx: ctx_init_file not specified. Database encription not enabled ...
?Debug : Aug 31 11:18:42 ModMap: Module <config> exist
?Debug : Aug 31 11:18:42 ModMap: Module <logger> exist
?Debug : Aug 31 11:18:42 ModMap: Module <rehash> exist
?Debug : Aug 31 11:18:42 UTMCtx: Initialization started...
Notice: Aug 31 11:18:42 ModMap: Sub-Module 'utmctx' inserted...
?Debug : Aug 31 11:18:42 ModMap: Module <config> exist
?Debug : Aug 31 11:18:42 ModMap: Module <logger> exist
?Debug : Aug 31 11:18:42 ModMap: Module <rehash> exist
?Debug : Aug 31 11:18:42 ModMap: Module <utmctx> exist
Info : Aug 31 11:18:42 DBA:Ctx: Creating 8 DB connections
Info : Aug 31 11:18:42 DBA:Ctx: DB Transactions are disabled
?Debug : Aug 31 11:18:42 DBCtx: Connecting to MySQL database
?Debug : Aug 31 11:18:42 DBCtx: Connection parameters username: root; dbname: UTM5 host: localhost
?Debug : Aug 31 11:18:42 DBCtx: MySQL connection opened
?Debug : Aug 31 11:18:42 DBCtx: Connecting to MySQL database
?Debug : Aug 31 11:18:42 DBCtx: Connection parameters username: root; dbname: UTM5 host: localhost
?Debug : Aug 31 11:18:43 DBCtx: MySQL connection opened
?Debug : Aug 31 11:18:43 DBCtx: Connecting to MySQL database
?Debug : Aug 31 11:18:43 DBCtx: Connection parameters username: root; dbname: UTM5 host: localhost
?Debug : Aug 31 11:18:43 DBCtx: MySQL connection opened
?Debug : Aug 31 11:18:43 DBCtx: Connecting to MySQL database
?Debug : Aug 31 11:18:43 DBCtx: Connection parameters username: root; dbname: UTM5 host: localhost
?Debug : Aug 31 11:18:44 DBCtx: MySQL connection opened
?Debug : Aug 31 11:18:44 DBCtx: Connecting to MySQL database
?Debug : Aug 31 11:18:44 DBCtx: Connection parameters username: root; dbname: UTM5 host: localhost
?Debug : Aug 31 11:18:44 DBCtx: MySQL connection opened
?Debug : Aug 31 11:18:44 DBCtx: Connecting to MySQL database
?Debug : Aug 31 11:18:44 DBCtx: Connection parameters username: root; dbname: UTM5 host: localhost
?Debug : Aug 31 11:18:45 DBCtx: MySQL connection opened
?Debug : Aug 31 11:18:45 DBCtx: Connecting to MySQL database
?Debug : Aug 31 11:18:45 DBCtx: Connection parameters username: root; dbname: UTM5 host: localhost
?Debug : Aug 31 11:18:45 DBCtx: MySQL connection opened
?Debug : Aug 31 11:18:45 DBCtx: Connecting to MySQL database
?Debug : Aug 31 11:18:45 DBCtx: Connection parameters username: root; dbname: UTM5 host: localhost
?Debug : Aug 31 11:18:46 DBCtx: MySQL connection opened
Notice: Aug 31 11:18:46 ModMap: Sub-Module 'dba:ctx' inserted...
?Debug : Aug 31 11:18:46 UTM5 DBA: DBAccess instance created
?Debug : Aug 31 11:18:46 ModMap: Module <config> exist
?Debug : Aug 31 11:18:46 ModMap: Module <dba:ctx> exist
?Debug : Aug 31 11:18:46 ModMap: Module <logger> exist
?Debug : Aug 31 11:18:46 ModMap: Module <rehash> exist
?Debug : Aug 31 11:18:46 ModMap: Module <utmctx> exist
?Debug : Aug 31 11:18:46 DBCtx: SQL SELECT query: SELECT name,country,region,city,address,email,tel,web FROM registration_info
?Debug : Aug 31 11:18:46 DBCtx: MySQL query failed:<Table 'utm5.registration_info' doesn't exist> Trying to reconnect: 0
?Debug : Aug 31 11:18:48 DBCtx: MySQL query failed:<Table 'utm5.registration_info' doesn't exist> Trying to reconnect: 1
?Debug : Aug 31 11:18:50 DBCtx: MySQL query failed:<Table 'utm5.registration_info' doesn't exist> Trying to reconnect: 2
?Debug : Aug 31 11:18:52 DBCtx: MySQL query failed:<Table 'utm5.registration_info' doesn't exist> Trying to reconnect: 3
?Debug : Aug 31 11:18:54 DBCtx: MySQL query failed:<Table 'utm5.registration_info' doesn't exist> Trying to reconnect: 4
ERROR : Aug 31 11:18:56 DBCtx: MySQL query failed:
ERROR : Aug 31 11:18:56 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:18:56 DBCtx: Exception while doing SQL select !
?Debug : Aug 31 11:18:56 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='certificate'
Info : Aug 31 11:18:56 UTM5 DBA: X509 sign verification succeded
?Debug : Aug 31 11:18:56 DBCtx: SQL SELECT query: SELECT id,login,password,ip,mask FROM system_accounts WHERE is_deleted=0
Info : Aug 31 11:18:56 UTMCtx: Decrypt: No ctx found
?Debug : Aug 31 11:18:56 UTMCtx: Unencrypted message passed!
Info : Aug 31 11:18:56 UTMCtx: Decrypt: No ctx found
?Debug : Aug 31 11:18:56 UTMCtx: Unencrypted message passed!
Info : Aug 31 11:18:56 UTMCtx: Decrypt: No ctx found
?Debug : Aug 31 11:18:56 UTMCtx: Unencrypted message passed!
Notice: Aug 31 11:18:56 UTM5 DBA: Summary sys users fetched: 3
?Debug : Aug 31 11:18:56 DBCtx: SQL SELECT query: SELECT id,name,info FROM system_group_info
?Debug : Aug 31 11:18:56 DBCtx: SQL SELECT query: SELECT user_id FROM system_groups WHERE group_id='1'
?Debug : Aug 31 11:18:56 DBCtx: SQL SELECT query: SELECT fid FROM system_rights WHERE group_id='1'
?Debug : Aug 31 11:18:56 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 0
?Debug : Aug 31 11:18:58 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 1
?Debug : Aug 31 11:19:00 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 2
?Debug : Aug 31 11:19:02 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 3
?Debug : Aug 31 11:19:04 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 4
ERROR : Aug 31 11:19:06 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:06 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:06 DBCtx: Exception while doing SQL select !
?Debug : Aug 31 11:19:06 DBCtx: SQL SELECT query: SELECT user_id FROM system_groups WHERE group_id='2'
?Debug : Aug 31 11:19:06 DBCtx: SQL SELECT query: SELECT fid FROM system_rights WHERE group_id='2'
?Debug : Aug 31 11:19:06 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 0
?Debug : Aug 31 11:19:08 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 1
?Debug : Aug 31 11:19:10 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 2
?Debug : Aug 31 11:19:12 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 3
?Debug : Aug 31 11:19:14 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 4
ERROR : Aug 31 11:19:16 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:16 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:16 DBCtx: Exception while doing SQL select !
-Stats : Aug 31 11:19:16 DBA Groups: Stats: Uptime: 00:00:20. Events: 0; Errors: 0
?Debug : Aug 31 11:19:16 UTM5 DBA: DBA fill mega storages called
?Debug : Aug 31 11:19:16 DBCtx: SQL SELECT query: SELECT id,login,password,ip,mask FROM system_accounts WHERE is_deleted=0
Info : Aug 31 11:19:16 UTMCtx: Decrypt: No ctx found
?Debug : Aug 31 11:19:16 UTMCtx: Unencrypted message passed!
Info : Aug 31 11:19:16 UTMCtx: Decrypt: No ctx found
?Debug : Aug 31 11:19:16 UTMCtx: Unencrypted message passed!
Info : Aug 31 11:19:16 UTMCtx: Decrypt: No ctx found
?Debug : Aug 31 11:19:16 UTMCtx: Unencrypted message passed!
Notice: Aug 31 11:19:16 UTM5 DBA: Summary sys users fetched: 3
?Debug : Aug 31 11:19:16 DBCtx: SQL SELECT query: SELECT id,name,info FROM system_group_info
?Debug : Aug 31 11:19:16 DBCtx: SQL SELECT query: SELECT user_id FROM system_groups WHERE group_id='1'
?Debug : Aug 31 11:19:16 DBCtx: SQL SELECT query: SELECT fid FROM system_rights WHERE group_id='1'
?Debug : Aug 31 11:19:16 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 0
?Debug : Aug 31 11:19:18 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 1
?Debug : Aug 31 11:19:20 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 2
?Debug : Aug 31 11:19:22 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 3
?Debug : Aug 31 11:19:24 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 4
ERROR : Aug 31 11:19:26 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:26 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:26 DBCtx: Exception while doing SQL select !
?Debug : Aug 31 11:19:26 DBCtx: SQL SELECT query: SELECT user_id FROM system_groups WHERE group_id='2'
?Debug : Aug 31 11:19:26 DBCtx: SQL SELECT query: SELECT fid FROM system_rights WHERE group_id='2'
?Debug : Aug 31 11:19:26 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 0
?Debug : Aug 31 11:19:28 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 1
?Debug : Aug 31 11:19:30 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 2
?Debug : Aug 31 11:19:32 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 3
?Debug : Aug 31 11:19:34 DBCtx: MySQL query failed:<Table 'utm5.system_rights' doesn't exist> Trying to reconnect: 4
ERROR : Aug 31 11:19:36 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:36 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:36 DBCtx: Exception while doing SQL select !
?Debug : Aug 31 11:19:36 DBCtx: SQL SELECT query: SELECT id, time_range_name FROM time_range
?Debug : Aug 31 11:19:36 DBCtx: SQL SELECT query: SELECT id, time_range_id, sec_start, sec_stop, min_start, min_stop, hour_start, hour_stop, wday_start, wday_stop FROM time_range_detail
?Debug : Aug 31 11:19:36 DBCtx: SQL SELECT query: SELECT id,time_range_id,mday,month FROM time_range_days WHERE is_deleted=0
?Debug : Aug 31 11:19:36 DBCtx: SQL SELECT query: SELECT id,start_date,end_date,periodic_type,next_discount_period_id,canonical_len, custom_duration, discount_interval, static_id FROM discount_periods WHERE is_expired=0
Notice: Aug 31 11:19:36 UTM5 DBA: Summary discount periods fetched:1
?Debug : Aug 31 11:19:36 DBCtx: SQL SELECT query: SELECT id,name,create_date,who_create,change_date,who_change,expire_date,is_blocked,balance_rollover FROM tariffs WHERE is_deleted=0
?Debug : Aug 31 11:19:36 DBCtx: MySQL query failed:<Table 'utm5.tariffs' doesn't exist> Trying to reconnect: 0
?Debug : Aug 31 11:19:38 DBCtx: MySQL query failed:<Table 'utm5.tariffs' doesn't exist> Trying to reconnect: 1
?Debug : Aug 31 11:19:40 DBCtx: MySQL query failed:<Table 'utm5.tariffs' doesn't exist> Trying to reconnect: 2
?Debug : Aug 31 11:19:42 DBCtx: MySQL query failed:<Table 'utm5.tariffs' doesn't exist> Trying to reconnect: 3
?Debug : Aug 31 11:19:44 DBCtx: MySQL query failed:<Table 'utm5.tariffs' doesn't exist> Trying to reconnect: 4
ERROR : Aug 31 11:19:46 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:46 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:46 DBCtx: Exception while doing SQL select !
?Debug : Aug 31 11:19:46 DBCtx: SQL SELECT query: SELECT id,balance,account_name,credit,discount_period_id,is_blocked,dealer_account_id,comission_coef,default_comission_value,is_dealer,vat_rate,sale_tax_rate, flags, int_status, block_recalc_abon, block_recalc_prepaid, unlimited FROM accounts WHERE is_deleted=0
?Debug : Aug 31 11:19:46 DBCtx: SQL SELECT query: SELECT id, account_id, tariff_id, next_tariff_id, discount_period_id FROM account_tariff_link WHERE is_deleted=0
?Debug : Aug 31 11:19:46 DBCtx: SQL SELECT query: SELECT user_id,group_id FROM users_groups_link
?Debug : Aug 31 11:19:46 DBCtx: SQL SELECT query: SELECT id,login,password,basic_account,is_blocked,discount_period_id,full_name,email,advance_payment FROM users WHERE is_deleted='0'
?Debug : Aug 31 11:19:46 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='card_user_prefix'
Notice: Aug 31 11:19:46 UTM5 DBA: Summary users fetched: 0
?Debug : Aug 31 11:19:46 DBCtx: SQL SELECT query: SELECT uid,account_id FROM users_accounts WHERE is_deleted=0
?Debug : Aug 31 11:19:46 DBCtx: SQL SELECT query: SELECT id,router_type,router_ip,login,password,router_comments,router_bin_ip FROM routers_info WHERE is_deleted='0'
?Debug : Aug 31 11:19:46 DBCtx: SQL SELECT query: SELECT ip_group_id,ip,mask,uname,upass,mac,ip_groups.id,allowed_cid,ip_type,router_id FROM ip_groups WHERE ip_groups.is_deleted=0
?Debug : Aug 31 11:19:46 DBCtx: SQL SELECT query: SELECT id, ip_group_id FROM iptraffic_service_links WHERE is_deleted=0
?Debug : Aug 31 11:19:46 DBCtx: SQL SELECT query: SELECT id, time_range_id, dont_save, local_traf_policy FROM t_class WHERE is_deleted='0'
?Debug : Aug 31 11:19:46 DBCtx: MySQL query failed:<Table 'utm5.t_class' doesn't exist> Trying to reconnect: 0
?Debug : Aug 31 11:19:48 DBCtx: MySQL query failed:<Table 'utm5.t_class' doesn't exist> Trying to reconnect: 1
?Debug : Aug 31 11:19:50 DBCtx: MySQL query failed:<Table 'utm5.t_class' doesn't exist> Trying to reconnect: 2
?Debug : Aug 31 11:19:52 DBCtx: MySQL query failed:<Table 'utm5.t_class' doesn't exist> Trying to reconnect: 3
?Debug : Aug 31 11:19:54 DBCtx: MySQL query failed:<Table 'utm5.t_class' doesn't exist> Trying to reconnect: 4
ERROR : Aug 31 11:19:56 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:56 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:56 DBCtx: Exception while doing SQL select !
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT t_class_id,saddr,saddr_mask,daddr,daddr_mask,sport,dport,input,output,src_as,dst_as,nexthop,tcp_flags,proto,tos,use_sport,use_dport,use_input,use_output,use_src_as,use_dst_as,use_nexthop,use_tcp_flags,use_proto,use_tos,skip, id, ip_from FROM t_class_detail WHERE is_deleted=0 ORDER BY t_class_id
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='system_currency'
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,currency_brief_name,currency_full_name,percent FROM currency_list where is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT currency_id,date,currency_rate FROM currency_rates
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,user_id,account_id,slink_id,what_blocked,block_type,start_date,expire_date,is_planning,service_id,unabon,unprepay FROM blocks_info WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,service_type,service_name,comment,comission_value,tariff_id,parent_service_id,link_by_default, default_dp_type, is_dynamic FROM services_data WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,cost,discount_method,start_date,expire_date,radius_sessions_limit FROM periodic_services_data WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,tst_id,null_service_prepaid FROM iptraffic_services_data WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,hotspot_cost_info_id,null_service_prepaid,recv_cost,rate_limit FROM hotspot_services_data WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,dialup_cost_info_id,null_service_prepaid,pool_name,max_timeout,login_prefix FROM dialup_services_data WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,user_id,account_id,service_id,tariff_link_id FROM service_links WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,is_blocked,discount_period_id,discounted_in_curr_period,start_date,is_planned,expire_date,need_del,unprepay_period,unabon_period,start_block_unabon,start_block_unprepay,is_invoice_set FROM periodic_service_links WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,time_in_curr_disc_period,old_time,login,password,recv_bytes FROM hotspot_service_links WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,time_in_curr_disc_period,old_time,login,password,allowed_cid,allowed_csid,callback_enabled FROM dialup_service_links WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT downloaded_id,tclass_id,qnt,old_prepay,custom_prepay,discounted,downed_as_prepaid,traffic_quota FROM downloaded
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,ip_group_id,downloaded_id,recalc_type,flags FROM iptraffic_service_links WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,cost,drop_from_group FROM once_service_data WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,discount_date,quantity,invoice_id FROM once_service_links WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,max_timeout,first_interval,incremental_interval,free_time,fixed_call_cost,unit_size,first_interval_around FROM tel_services_data WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT tel_service_id,tarif_key,border,cost FROM tel_services_borders WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT tel_service_id,tarif_key,prepaid FROM tel_services_prepaid WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT tel_service_id,tarif_key,time_range_id,mult FROM tel_services_tr_mult WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id FROM tel_service_links WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT slink_id,zone_id,duration FROM dtagg_telephony WHERE is_closed=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT slink_id, tarif_key, downed_as_prepaid, old_prepaid, custom_prepaid FROM tel_service_links_prepaid WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id,slink_id,tel_number,login,password,allowed_cid FROM tel_numbers WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT tariff_id, service_id, q FROM tariffs_services_link WHERE is_deleted=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id, payment_trans_id, expire_date, pay_date, account_id,payment_value, custagg_id, last_pay_date FROM payments_timed WHERE is_passed=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id, payment_trans_id, expire_date, start_date, account_id,value, status FROM credits WHERE is_passed=0
?Debug : Aug 31 11:19:56 DBCtx: SQL SELECT query: SELECT id, type_id, param, reg_date, passwd, slink_id FROM slink_tech_param ORDER BY slink_id
?Debug : Aug 31 11:19:56 DBCtx: MySQL query failed:<Table 'utm5.slink_tech_param' doesn't exist> Trying to reconnect: 0
?Debug : Aug 31 11:19:58 DBCtx: MySQL query failed:<Table 'utm5.slink_tech_param' doesn't exist> Trying to reconnect: 1
?Debug : Aug 31 11:20:00 DBCtx: MySQL query failed:<Table 'utm5.slink_tech_param' doesn't exist> Trying to reconnect: 2
?Debug : Aug 31 11:20:02 DBCtx: MySQL query failed:<Table 'utm5.slink_tech_param' doesn't exist> Trying to reconnect: 3
?Debug : Aug 31 11:20:04 DBCtx: MySQL query failed:<Table 'utm5.slink_tech_param' doesn't exist> Trying to reconnect: 4
ERROR : Aug 31 11:20:06 DBCtx: MySQL query failed:
ERROR : Aug 31 11:20:06 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:20:06 DBCtx: Exception while doing SQL select !
?Debug : Aug 31 11:20:06 DBCtx: SQL SELECT query: SELECT id,prefix,name,create_date FROM tel_directions WHERE is_deleted='0'
?Debug : Aug 31 11:20:06 DBCtx: MySQL query failed:<Table 'utm5.tel_directions' doesn't exist> Trying to reconnect: 0
?Debug : Aug 31 11:20:08 DBCtx: MySQL query failed:<Table 'utm5.tel_directions' doesn't exist> Trying to reconnect: 1
?Debug : Aug 31 11:20:10 DBCtx: MySQL query failed:<Table 'utm5.tel_directions' doesn't exist> Trying to reconnect: 2
?Debug : Aug 31 11:20:12 DBCtx: MySQL query failed:<Table 'utm5.tel_directions' doesn't exist> Trying to reconnect: 3
?Debug : Aug 31 11:20:14 DBCtx: MySQL query failed:<Table 'utm5.tel_directions' doesn't exist> Trying to reconnect: 4
ERROR : Aug 31 11:20:16 DBCtx: MySQL query failed:
ERROR : Aug 31 11:20:16 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:20:16 DBCtx: Exception while doing SQL select !
?Debug : Aug 31 11:20:16 UTM5 DBA: <0> tel directions inserted into storage
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT id,name,create_date FROM tel_zones
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT zone_id, dir_id FROM dir_zones
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='notification_borders'
Info : Aug 31 11:20:16 UTM5 DBA: parsed 1.000000 notification border
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='discount_barrier'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='bytes_in_kbyte'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='flow_discounts_per_period'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='flow_discount_random_coef'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='traffic_agregation_interval'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='traffic_mult_coef'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='aggregation_todisc_barrier'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='system_currency'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='block_recalc_abon'
Info : Aug 31 11:20:16 UTM5 DBA: block_recalc_abon = 0
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='block_recalc_prepaid'
Info : Aug 31 11:20:16 UTM5 DBA: block_recalc_prepaid = 0
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='discount_traffic_comission'
Info : Aug 31 11:20:16 UTM5 DBA: discount_traffic_comission = 0
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='default_vat_rate'
Info : Aug 31 11:20:16 UTM5 DBA: default_vat_rate = 0.000000
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='fw_rule_offset'
Info : Aug 31 11:20:16 UTM5 DBA: fw_rule_offset = 5000
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='check_abon_on_payment'
Info : Aug 31 11:20:16 UTM5 DBA: check_abon_on_payment = 0
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='login_prefix_separator'
Info : Aug 31 11:20:16 UTM5 DBA: login_prefix_separator = :
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='null_prepaid_traffic_if_tarif_change'
Info : Aug 31 11:20:16 UTM5 DBA: null_prepaid_traffic_if_tarif_change = 0
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='www_prefix'
Info : Aug 31 11:20:16 UTM5 DBA: www_prefix </var/www/>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='hosting_ip'
Info : Aug 31 11:20:16 UTM5 DBA: hosting_ip <127.0.0.1>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='hosting_uid_number'
Info : Aug 31 11:20:16 UTM5 DBA: hosting_uid_number <10001>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='hosting_gid_number'
Info : Aug 31 11:20:16 UTM5 DBA: hosting_gid_number <10001>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='mail_server_ip'
Info : Aug 31 11:20:16 UTM5 DBA: mail_server_ip <127.0.0.1>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='force_prepaid_change'
Info : Aug 31 11:20:16 UTM5 DBA: force_prepaid_change <0>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='email_exec_register'
Info : Aug 31 11:20:16 UTM5 DBA: email_exec_register <>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='email_exec_unregister'
Info : Aug 31 11:20:16 UTM5 DBA: email_exec_unregister <>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='special_write'
Info : Aug 31 11:20:16 UTM5 DBA: special_write <0>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='tel_attrs_write'
Info : Aug 31 11:20:16 UTM5 DBA: tel_attrs_write <0>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='dialup_attrs_write'
Info : Aug 31 11:20:16 UTM5 DBA: dialup_attrs_write <0>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='access_attrs_write'
Info : Aug 31 11:20:16 UTM5 DBA: access_attrs_write <0>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='disable_utm_tolower'
Info : Aug 31 11:20:16 UTM5 DBA: use_utm_towlower <1>
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT account_id,discounted,discounted_without_tax,id FROM dtagg_once WHERE is_closed='0'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT slink_id,discounted,discounted_without_tax,id FROM dtagg_periodic WHERE is_closed='0'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT slink_id,base_cost,discounted,discounted_without_tax,session_time,recv_bytes,id FROM dtagg_hotspot WHERE is_closed='0'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT slink_id,base_cost,discounted,discounted_without_tax,duration,id,zone_id FROM dtagg_telephony WHERE is_closed='0'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT slink_id,base_cost,tclass,ipid,discounted,discounted_without_tax,bytes,id FROM dtagg_iptraffic WHERE tclass != '0' AND is_closed='0'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT id,account_id,discounted,discounted_without_tax,exp_date FROM dtagg_cust WHERE is_deleted='0'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT id,account_id,payment_incurrency,currency_id,currency_rate,payment_absolute,actual_date,payment_enter_date,method,who_receive,comments_for_user,comments_for_admins,discount_transaction_id,dealer_transaction_id,payment_ext_number,burn_time,dealer_client_account_id FROM payment_transactions WHERE dealer_client_account_id<>0
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT dealer_account_id, service_id, comission_value FROM dealer_comissions WHERE is_deleted=0
?Debug : Aug 31 11:20:16 UTM5 DBA: Verifying DBACache consistency
?Debug : Aug 31 11:20:16 UTM5 DBA: Checking accounts..
?Debug : Aug 31 11:20:16 UTM5 DBA: Checking users..
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: select id, user_id, group_id from users_groups_link
?Debug : Aug 31 11:20:16 UTM5 DBA: Checking traffic classes..
?Debug : Aug 31 11:20:16 UTM5 DBA: Checking blocks..
?Debug : Aug 31 11:20:16 UTM5 DBA: Checking services..
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT id, start_date, end_date, canonical_len, periodic_type,is_expired FROM discount_periods WHERE id='1'
?Debug : Aug 31 11:20:16 UTM5 DBA: Checking service links..
*CRIT : Aug 31 11:20:16 UTM5 DBA: db verificator find critical error(s), see log\verificator.log for details
-Stats : Aug 31 11:20:16 DBA Groups: Stats: Uptime: 00:01:00. Events: 0; Errors: 0
?Debug : Aug 31 11:20:16 UTM5 DBA: Checking for accounts with negative balance..
Notice: Aug 31 11:20:16 ModMap: Sub-Module 'dba' inserted...
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='smtp_relay'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='smtp_fqdn'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='smtp_recipient'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='smtp_sender'
?Debug : Aug 31 11:20:16 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='sm_license'
*ALERT : Aug 31 11:20:16 UTM5 Core: Sign verification failed...
main.log:
Info : Aug 31 11:18:42 UTM5 Logger: New ` Info : ' stream: log\main.log
Info : Aug 31 11:18:42 UTMCtx: ctx_init_file not specified. Database encription not enabled ...
Notice: Aug 31 11:18:42 ModMap: Sub-Module 'utmctx' inserted...
Info : Aug 31 11:18:42 DBA:Ctx: Creating 8 DB connections
Info : Aug 31 11:18:42 DBA:Ctx: DB Transactions are disabled
Notice: Aug 31 11:18:46 ModMap: Sub-Module 'dba:ctx' inserted...
ERROR : Aug 31 11:18:56 DBCtx: MySQL query failed:
ERROR : Aug 31 11:18:56 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:18:56 DBCtx: Exception while doing SQL select !
Info : Aug 31 11:18:56 UTM5 DBA: X509 sign verification succeded
Info : Aug 31 11:18:56 UTMCtx: Decrypt: No ctx found
Info : Aug 31 11:18:56 UTMCtx: Decrypt: No ctx found
Info : Aug 31 11:18:56 UTMCtx: Decrypt: No ctx found
Notice: Aug 31 11:18:56 UTM5 DBA: Summary sys users fetched: 3
ERROR : Aug 31 11:19:06 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:06 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:06 DBCtx: Exception while doing SQL select !
ERROR : Aug 31 11:19:16 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:16 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:16 DBCtx: Exception while doing SQL select !
Info : Aug 31 11:19:16 UTMCtx: Decrypt: No ctx found
Info : Aug 31 11:19:16 UTMCtx: Decrypt: No ctx found
Info : Aug 31 11:19:16 UTMCtx: Decrypt: No ctx found
Notice: Aug 31 11:19:16 UTM5 DBA: Summary sys users fetched: 3
ERROR : Aug 31 11:19:26 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:26 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:26 DBCtx: Exception while doing SQL select !
ERROR : Aug 31 11:19:36 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:36 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:36 DBCtx: Exception while doing SQL select !
Notice: Aug 31 11:19:36 UTM5 DBA: Summary discount periods fetched:1
ERROR : Aug 31 11:19:46 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:46 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:46 DBCtx: Exception while doing SQL select !
Notice: Aug 31 11:19:46 UTM5 DBA: Summary users fetched: 0
ERROR : Aug 31 11:19:56 DBCtx: MySQL query failed:
ERROR : Aug 31 11:19:56 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:19:56 DBCtx: Exception while doing SQL select !
ERROR : Aug 31 11:20:06 DBCtx: MySQL query failed:
ERROR : Aug 31 11:20:06 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:20:06 DBCtx: Exception while doing SQL select !
ERROR : Aug 31 11:20:16 DBCtx: MySQL query failed:
ERROR : Aug 31 11:20:16 DBASQLError: MySQL query failed:
ERROR : Aug 31 11:20:16 DBCtx: Exception while doing SQL select !
Info : Aug 31 11:20:16 UTM5 DBA: parsed 1.000000 notification border
Info : Aug 31 11:20:16 UTM5 DBA: block_recalc_abon = 0
Info : Aug 31 11:20:16 UTM5 DBA: block_recalc_prepaid = 0
Info : Aug 31 11:20:16 UTM5 DBA: discount_traffic_comission = 0
Info : Aug 31 11:20:16 UTM5 DBA: default_vat_rate = 0.000000
Info : Aug 31 11:20:16 UTM5 DBA: fw_rule_offset = 5000
Info : Aug 31 11:20:16 UTM5 DBA: check_abon_on_payment = 0
Info : Aug 31 11:20:16 UTM5 DBA: login_prefix_separator = :
Info : Aug 31 11:20:16 UTM5 DBA: null_prepaid_traffic_if_tarif_change = 0
Info : Aug 31 11:20:16 UTM5 DBA: www_prefix </var/www/>
Info : Aug 31 11:20:16 UTM5 DBA: hosting_ip <127.0.0.1>
Info : Aug 31 11:20:16 UTM5 DBA: hosting_uid_number <10001>
Info : Aug 31 11:20:16 UTM5 DBA: hosting_gid_number <10001>
Info : Aug 31 11:20:16 UTM5 DBA: mail_server_ip <127.0.0.1>
Info : Aug 31 11:20:16 UTM5 DBA: force_prepaid_change <0>
Info : Aug 31 11:20:16 UTM5 DBA: email_exec_register <>
Info : Aug 31 11:20:16 UTM5 DBA: email_exec_unregister <>
Info : Aug 31 11:20:16 UTM5 DBA: special_write <0>
Info : Aug 31 11:20:16 UTM5 DBA: tel_attrs_write <0>
Info : Aug 31 11:20:16 UTM5 DBA: dialup_attrs_write <0>
Info : Aug 31 11:20:16 UTM5 DBA: access_attrs_write <0>
Info : Aug 31 11:20:16 UTM5 DBA: use_utm_towlower <1>
*CRIT : Aug 31 11:20:16 UTM5 DBA: db verificator find critical error(s), see log\verificator.log for details
Notice: Aug 31 11:20:16 ModMap: Sub-Module 'dba' inserted...
*ALERT : Aug 31 11:20:16 UTM5 Core: Sign verification failed...
verificator.log:
-- Verificator
-- You have to backup UTM5 database!
-- Affected tables list at the end of file
-- ERROR Found lost rows in t_class_detail. Tclass id:10
-- SQL DESC delete lost rows
UPDATE t_class_detail SET is_deleted=1 WHERE t_class_id=10;
-- ERROR Found lost rows in t_class_detail. Tclass id:20
-- SQL DESC delete lost rows
UPDATE t_class_detail SET is_deleted=1 WHERE t_class_id=20;
-- 2 errors
-- 0 warnings
-- affected tables: t_class_detail
