Обновление фреймврока 3.3.1

[SKotov]

Здравствуйте! Я только недавно столкнулся с данной системой otrs, сам ее ставил на ubuntu. Версия otrs3.3.1. Сейчас столкнулся с проблемой, что надо обновить фреймворк до последней версии, но с этим как то очень сложно, в мануале написанно все как то более для продвинутых пользователей linux, что мне удалось сделать, это:

1) Остановить системы
root@****:/etc/init.d# service cron stop
cron stop/waiting
root@****:/etc/init.d# /etc/init.d/apache2 stop

 * Stopping web server apache2                                                   * 

root@****:/opt/otrs# bin/Cron.sh stop otrs
/opt/otrs
Cron.sh - start/stop OTRS cronjobs
Copyright (C) 2001-2012 OTRS AG, http://otrs.org/

done

2)  Далее сделал бэкап
root@****:/opt/otrs/scripts# /opt/otrs/scripts/backup.pl -d /opt/OtrsB
Backup /opt/OtrsB/2014-04-30_10-27/Config.tar.gz ... done
Backup /opt/OtrsB/2014-04-30_10-27/Application.tar.gz ... done
Dump MySQL rdbms ... done

Compress SQL-file… done

3) Переименовал папку с прежней версией otrs 

root@****:/opt# mv otrs otrs-old

4) Скачал, распаковал и закинул в каталог otrs новую версию фреймворка

root@****:/tmp# wget http://ftp.otrs.org/pub/otrs/otrs-3.3.6.tar.gz

--2014-04-30 10:57:46--  http://ftp.otrs.org/pub/otrs/otrs-3.3.6.tar.gz

Resolving ftp.otrs.org (ftp.otrs.org)... 178.63.12.4

Connecting to ftp.otrs.org (ftp.otrs.org)|178.63.12.4|:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: 23273464 (22M) [application/x-gzip]

Saving to: ‘otrs-3.3.6.tar.gz’
root@****:/tmp# tar zxfv otrs-3.3.6.tar.gz
root@****:/opt# mkdir otrs

root@****:/tmp# cp -R /tmp/otrs/* /opt/otrs/
Дальше не понимаю как делать, по мануалу надо востановить старые конфигурационные файлы, и далее, пожалуйста, помогите на пальцах как дальше все это делать. Видел у вас а форуме похожие темы но на убунту удачного обновления пока не увидел ни у кого

otrs3.3.1 Ubuntu 13.10 (GNU/Linux 3.11.0-19-generic x86_64)

[alexus]

Заменяете конфиги, которые указаны, своими (или просто из проверяете, если деалали через RPM), далее операции по списку. Там всё более чем прозрачно написано. П. 6 можно опустить, SCHEMA UPDATE тоже.

[SKotov]

Выполнил востановление, назначение прав доступа

а вот 9 пункт
Проверка базы данных

root@****:/opt/otrs# bin/otrs.CheckDB.pl
Trying to connect to database
DSN: DBI:mysql:database=otrs;host=127.0.0.1
DatabaseUser: otrs

Connected.

root@****:/opt/otrs# cat scripts/DBUpdate-to-3.3.mysql.sql | mysql -p -f -u root otrs
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
root@****:/opt/otrs# cat scripts/DBUpdate-to-3.3.mysql.sql | mysql -p -f -u root otrs
Enter password:
ERROR 1062 (23000) at line 7: Duplicate entry 'TitleUpdate' for key 'ticket_history_type_name'
ERROR 1091 (42000) at line 10: Can't DROP 'index_search_date'; check that column/key exists
ERROR 1061 (42000) at line 11: Duplicate key name 'dynamic_field_value_search_date'
ERROR 1091 (42000) at line 12: Can't DROP 'index_search_int'; check that column/key exists
ERROR 1061 (42000) at line 13: Duplicate key name 'dynamic_field_value_search_int'
ERROR 1091 (42000) at line 14: Can't DROP 'index_field_values'; check that column/key exists
ERROR 1061 (42000) at line 15: Duplicate key name 'dynamic_field_value_field_values'
ERROR 1091 (42000) at line 16: Can't DROP 'article_message_id'; check that column/key exists
ERROR 1060 (42S21) at line 20: Duplicate column name 'a_message_id_md5'
ERROR 1061 (42000) at line 21: Duplicate key name 'article_message_id_md5'
ERROR 1091 (42000) at line 22: Can't DROP 'article_search_message_id'; check that column/key exists
ERROR 1091 (42000) at line 26: Can't DROP 'a_message_id'; check that column/key exists
ERROR 1050 (42S01) at line 30: Table 'system_data' already exists
INFO: Foreign key constraint FK_standard_response_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_queue_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_queue_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_attachment_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_attachment_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_change_by_id does not exist, skipping.
ERROR 1146 (42S02) at line 109: Table 'otrs.standard_response' doesn't exist
ERROR 1146 (42S02) at line 113: Table 'otrs.standard_response' doesn't exist
ERROR 1146 (42S02) at line 117: Table 'otrs.queue_standard_response' doesn't exist
ERROR 1146 (42S02) at line 121: Table 'otrs.standard_response_attachment' doesn't exist
ERROR 1061 (42000) at line 122: Duplicate key name 'standard_template_name'
ERROR 1005 (HY000) at line 123: Can't create table 'otrs.#sql-365_fd' (errno: 121)
ERROR 1005 (HY000) at line 124: Can't create table 'otrs.#sql-365_fd' (errno: 121)
ERROR 1005 (HY000) at line 125: Can't create table 'otrs.#sql-365_fd' (errno: 121)
ERROR 1054 (42S22) at line 129: Unknown column 'standard_response_id' in 'queue_standard_template'
ERROR 1054 (42S22) at line 136: Unknown column 'standard_response_id' in 'standard_template_attachment'
ERROR 1005 (HY000) at line 140: Can't create table 'otrs.#sql-365_fd' (errno: 121)
ERROR 1005 (HY000) at line 141: Can't create table 'otrs.#sql-365_fd' (errno: 121)
ERROR 1005 (HY000) at line 142: Can't create table 'otrs.#sql-365_fd' (errno: 121)
ERROR 1005 (HY000) at line 143: Can't create table 'otrs.#sql-365_fd' (errno: 121)
ERROR 1060 (42S21) at line 147: Duplicate column name 'f_not'
ERROR 1005 (HY000) at line 152: Can't create table 'otrs.#sql-365_fd' (errno: 121)
ERROR 1005 (HY000) at line 153: Can't create table 'otrs.#sql-365_fd' (errno: 121)
root@****:/opt/otrs# cat scripts/DBUpdate-to-3.3.postgresql.sql | p
Display all 123 possibilities? (y or n)
root@****:/opt/otrs# cat scripts/DBUpdate-to-3.3.postgresql.sql | psql otrs
The program 'psql' can be found in the following packages:
* postgresql-client-common
* postgres-xc-client
Try: apt-get install <selected package>

Не подскжите, что тут не так делаю

[alexus]

DBUpdate делать не надо. В рамках версии схема данных не меняется.