OTRS — различия между версиями
Материал из m6a
(→Установка) |
|||
| Строка 1: | Строка 1: | ||
==Установка== | ==Установка== | ||
| − | apt-get -y update | + | apt-get -y update |
| − | + | apt-get -y upgrade | |
| − | + | wget http://ftp.otrs.org/pub/otrs//otrs-5.0.2.tar.gz | |
| − | + | tar xf otrs-5.0.2.tar.gz | |
| − | + | mv otrs-5.0.2 /opt/otrs | |
| − | + | apt-get -y install apache2 fetchmail libapache2-mod-perl2 libdbd-mysql-perl / | |
| − | + | libnet-dns-perl libnet-ldap-perl libio-socket-ssl-perl libpdf-api2-perl libsoap-lite-perl / | |
| − | + | libgd-text-perl libgd-graph-perl libapache-dbi-perl libyaml-libyaml-perl libtemplate-perl / | |
| − | + | libarchive-zip-perl liblwp-useragent-determined-perl libapache2-reload-perl libnet-smtp-ssl-perl / | |
| − | + | libnet-smtp-tls-butmaintained-perl libgd-gd2-perl libjson-xs-perl libpdf-api2-simple-perl / | |
| − | + | libtext-csv-xs-perl libxml-parser-perl libmail-imapclient-perl mysql-server | |
| − | + | usermod -g www-data otrs | |
| − | + | cd /opt/otrs/Kernel | |
| − | + | cp Config.pm.dist Config.pm | |
| − | + | ||
| − | + | ||
17 cp Config/GenericAgent.pm.dist Config/GenericAgent.pm | 17 cp Config/GenericAgent.pm.dist Config/GenericAgent.pm | ||
| − | + | cd /opt/otrs | |
| − | + | bin/otrs.SetPermissions.pl --otrs-user=otrs --otrs-group=otrs --web-user=www-data --web-group=www-data /opt/otrs | |
| − | + | perl -MCPAN -e shell; | |
| − | + | q | |
| − | + | perl -cw /opt/otrs/bin/cgi-bin/index.pl | |
| − | + | perl -cw /opt/otrs/bin/cgi-bin/customer.pl | |
| − | + | perl -cw /opt/otrs/bin/otrs.PostMaster.pl | |
| − | + | cp /opt/otrs/scripts/apache2-httpd.include.conf /etc/apache2/sites-available/otrs.conf | |
| − | + | cd /etc/apache2/sites-available/ | |
| − | + | chown root:root otrs.conf | |
| − | + | a2ensite otrs | |
| − | + | service apache2 reload | |
| − | + | cd /opt/otrs/var/cron | |
| − | + | for foo in *.dist; do cp $foo `basename $foo .dist`; done | |
| − | + | cd /opt/otrs | |
| − | + | bin/Cron.sh start otrs | |
| − | + | vi /etc/mysql/my.cnf | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
48 sudo service mysql stop | 48 sudo service mysql stop | ||
49 cd /var/lib/mysql | 49 cd /var/lib/mysql | ||
| − | |||
51 rm ib_logfile* | 51 rm ib_logfile* | ||
| − | |||
| − | |||
54 vi /etc/mysql/my.cnf | 54 vi /etc/mysql/my.cnf | ||
55 service mysql start | 55 service mysql start | ||
| Строка 90: | Строка 72: | ||
89 cd /opt/otrs | 89 cd /opt/otrs | ||
90 bin/Cron.sh start otrs | 90 bin/Cron.sh start otrs | ||
| − | 91 history | + | 91 history |
| + | |||
==Восстановление из бекапа== | ==Восстановление из бекапа== | ||
Чистим базу данных | Чистим базу данных | ||
Версия 19:57, 9 ноября 2015
Установка
apt-get -y update apt-get -y upgrade wget http://ftp.otrs.org/pub/otrs//otrs-5.0.2.tar.gz tar xf otrs-5.0.2.tar.gz mv otrs-5.0.2 /opt/otrs apt-get -y install apache2 fetchmail libapache2-mod-perl2 libdbd-mysql-perl / libnet-dns-perl libnet-ldap-perl libio-socket-ssl-perl libpdf-api2-perl libsoap-lite-perl / libgd-text-perl libgd-graph-perl libapache-dbi-perl libyaml-libyaml-perl libtemplate-perl / libarchive-zip-perl liblwp-useragent-determined-perl libapache2-reload-perl libnet-smtp-ssl-perl / libnet-smtp-tls-butmaintained-perl libgd-gd2-perl libjson-xs-perl libpdf-api2-simple-perl / libtext-csv-xs-perl libxml-parser-perl libmail-imapclient-perl mysql-server usermod -g www-data otrs cd /opt/otrs/Kernel cp Config.pm.dist Config.pm 17 cp Config/GenericAgent.pm.dist Config/GenericAgent.pm cd /opt/otrs bin/otrs.SetPermissions.pl --otrs-user=otrs --otrs-group=otrs --web-user=www-data --web-group=www-data /opt/otrs perl -MCPAN -e shell; q perl -cw /opt/otrs/bin/cgi-bin/index.pl perl -cw /opt/otrs/bin/cgi-bin/customer.pl perl -cw /opt/otrs/bin/otrs.PostMaster.pl cp /opt/otrs/scripts/apache2-httpd.include.conf /etc/apache2/sites-available/otrs.conf cd /etc/apache2/sites-available/ chown root:root otrs.conf a2ensite otrs service apache2 reload cd /opt/otrs/var/cron for foo in *.dist; do cp $foo `basename $foo .dist`; done cd /opt/otrs bin/Cron.sh start otrs vi /etc/mysql/my.cnf 48 sudo service mysql stop 49 cd /var/lib/mysql 51 rm ib_logfile* 54 vi /etc/mysql/my.cnf 55 service mysql start 56 cd /opt/otrs/scripts 57 ./restore.pl -b /home/otrs/ -d /opt/otrs/ 58 mysql -uroot -pqweszxc77 59 ./restore.pl -b /home/otrs/ -d /opt/otrs/ 60 mysql -uroot -pqweszxc77 61 mysqladmin -u root -p create otrs 62 ./restore.pl -b /home/otrs/ -d /opt/otrs/ 63 mysqladmin -u root -p drop otrs 64 mysqladmin -u root -p create otrs 65 mysqladmin -u root -p qweszxc77 qweszxc 66 mysqladmin -u root password 67 mysql -u root -p 68 ./restore.pl -b /home/otrs/ -d /opt/otrs/ 69 vi restore.pl 70 mysql -u root -p 71 ./restore.pl -b /home/otrs/ -d /opt/otrs/ 72 vi /opt/otrs/Kernel/System/DB.pm 73 vi /opt/otrs/Kernel/System/SysConfig.pm 74 vi /opt/otrs/Kernel/Config/Files/ZZZAuto.pm 75 vi /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm 76 vi /opt/otrs/Kernel/Config.pm 77 ./restore.pl -b /home/otrs/ -d /opt/otrs/ 78 mysql -u root -p 79 vi /opt/otrs/Kernel/Config.pm 80 ./restore.pl -b /home/otrs/ -d /opt/otrs/ 81 vi /opt/otrs/Kernel/Config.pm 82 mysql -u root -p 83* ./restore.pl -b /home/otrs/ -d /opt/otrs 84 ршы 85 history 86 vi /opt/otrs/Kernel/Config.pm 87 mysql -u root -p 88 history 89 cd /opt/otrs 90 bin/Cron.sh start otrs 91 history
Восстановление из бекапа
Чистим базу данных
mysqladmin -u root -p drop otrs mysqladmin -u root -p create otrs
Если пароли в резервной копии и новой установке не совпадают
cd /opt/otrs/scripts ./restore.pl -b /home/otrs/ -d /opt/otrs/
Будет выдано сообщение об ошибке, но конфигурационные файлы уже восстановяться, смотрим какой был пароль
vi /opt/otrs/Kernel/Config.pm
Копируем значение из строки
$Self->{'DatabasePw'} =
Устанавливает этот пароль для пользователя otrs
mysql -u root -p
use mysql;
update user set password=PASSWORD("kZvauooPZpJ3AgFf") where User='otrs';
flush privileges;
quit
Восстанавливаем
./restore.pl -b /home/otrs/ -d /opt/otrs
