主页 / user-131233

Valentin Bajrami's questions

Martin Hope
Valentin Bajrami
Asked: 2012-09-06 23:31:28 +0800 CST
  • 0

今天我开始将 OTRS 从 2.3 版升级到 2.4 版，从 2.4 版升级到 3.0 版，从 3.0 版升级到 3.1 版。除了从 3.0 升级到 3.1 之外，一切都很顺利，OTRS 提供了一些使升级更容易的 perl 脚本。我在每个升级步骤中都使用了这些脚本。使用升级脚本后，从3.0升级到3.1在以下失败。

scripts/DBUpdate-to-3.1.pl

错误是：

root@tickets:/opt/otrs# su - otrs
$ scripts/DBUpdate-to-3.1.pl

Migration started...

Step 1 of 24: Refresh configuration cache... 
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 5.
Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAuto.pm line 4.
done.

Step 2 of 24: Check framework version... done.

Step 3 of 24: Creating DynamicField tables (if necessary)... done.

DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`pp_otrs`.`dynamic_field`, CONSTRAINT `FK_dynamic_field_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)) at /opt/otrs-3.1.10/Kernel/System/DB.pm line 478.
ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.14.2 OS: linux Time: Wed Sep  5 15:36:20 2012

 Message: Cannot add or update a child row: a foreign key constraint fails (`pp_otrs`.`dynamic_field`, CONSTRAINT `FK_dynamic_field_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)), SQL: 'INSERT INTO dynamic_field (name, label, field_order, field_type, object_type, config,
                            valid_id, create_time, create_by, change_time, change_by)
                        VALUES (?, ?, ?, 'Text', 'Ticket', '--- {}
', 1, 
        '2012-09-05 15:36:20'
    , 1, 
        '2012-09-05 15:36:20'
    , 1)'

 Traceback (20405): 
   Module: main::_DynamicFieldCreation (v1.85) Line: 466
   Module: scripts/DBUpdate-to-3.1.pl (v1.85) Line: 95

Could not create new DynamicField TicketFreeKey1 at scripts/DBUpdate-to-3.1.pl line 477.
Step 4 of 24: Create new dynamic fields for free fields (text, key, date)... $

还有其他人遇到同样的问题吗？提前致谢

linux
Martin Hope
Valentin Bajrami
Asked: 2012-09-05 12:32:11 +0800 CST
  • 0

有人能告诉我这个重定向如何/为什么不起作用吗？

$HTTP["host"] =~ ".*\\.mydomain\\.com" { 
    url.redirect = ( 
        "/index\.php\?pg=mysql" => "http://mydomain.com/lean-webhosting/mysql-clustering/",
        "/index\.php\?pg=cloud_uitleg" => "http://mydomain.com/lean-webhosting/cloud-uitleg/" 
    )    
}

有人有什么想法吗？谢谢！

linux
Martin Hope
Valentin Bajrami
Asked: 2012-08-25 04:31:07 +0800 CST
  • 1

我在配置 nagios 上的升级时遇到问题。我收到以下错误：

Error: Could not expand hostgroups and/or hosts specified in host escalation (config file '/usr/local/nagios/etc/objects/escalations.cfg', starting on line 11)
   Error processing object config files!

escalations.cfg 文件如下所示：

define hostescalation{
  host_name    *
  contact_groups    admins
  first_notification  1
  last_notification  3
  notification_interval  30
  escalation_period  24x7
  escalation_options  d,u
  }

define hostescalation{
  host_name    *
  contact_groups    suppliers
  first_notification  4
  last_notification  6
  notification_interval  60
  escalation_period  24x7
  escalation_options  d,u
  }

define serviceescalation{
  host_name    script.myprojects
  service_description  HTTP
  first_notification  1
  last_notification  3
  notification_interval  30
  contact_groups    admins
  }

define serviceescalation{
  host_name    script.myprojects
  service_description  HTTP
  first_notification  4
  last_notification  6
  notification_interval  60
  contact_groups    suppliers
  }

我想要的是，使用通配符 (*) 获取所有主机组及其成员。这是行不通的。任何人都可以提供任何解决方案吗？我是否遗漏了任何定义，如果是，在哪里/如何放置这个定义？

谢谢！

linux