wurzel wrote: ↑20 Aug 2018, 20:02
Hi,
can you show all your steps you did? This would help.
Florian
1. Install Ubuntu 18.04 LTS - fresh minimal install
2. Install MariaDB:
Code: Select all
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64] http://mirror.zol.co.zw/mariadb/repo/10.3/ubuntu bionic main'
sudo apt update
sudo apt install mariadb-server mariadb-client
3. Configure database settings:
$ sudo vim /etc/mysql/mariadb.cnf
Code: Select all
[mysqld]
max_allowed_packet=64M
query_cache_size=36M
innodb_log_file_size=256M
character_set_server=utf8
4. Creating database
Code: Select all
$ mysql -u root -p
CREATE DATABASE otrs CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON otrs.* TO 'otrs'@'localhost' \
IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
5. Install Apache2 & Perl Module
Code: Select all
sudo apt-get install apache2 libapache2-mod-perl2
Other modules:
Code: Select all
sudo apt-get install libdatetime-perl libcrypt-eksblowfish-perl libcrypt-ssleay-perl libgd-graph-perl libapache-dbi-perl libsoap-lite-perl libarchive-zip-perl libgd-text-perl libnet-dns-perl libpdf-api2-perl libauthen-ntlm-perl libdbd-odbc-perl libjson-xs-perl libyaml-libyaml-perl libxml-libxml-perl libencode-hanextra-perl libxml-libxslt-perl libpdf-api2-simple-perl libmail-imapclient-perl libtemplate-perl libtext-csv-xs-perl libdbd-pg-perl libapache2-mod-perl2 libtemplate-perl libnet-dns-perl libnet-ldap-perl libio-socket-ssl-perl
Load module:
Code: Select all
sudo a2enmod perl
sudo systemctl restart apache2
6. Create otrs user
Code: Select all
useradd -d /opt/otrs -c 'OTRS user' otrs
sudo usermod -aG www-data otrs
7. Stop Apache2 on old server and copy /opt/otrs/ directory -> move to new. (zip tar -> untar)
Code: Select all
sudo systemctl stop apache2
tar -czvf otrs.tar.gz /opt/otrs
###Copy to new server:
tar -zxf otrs.tar.gz
/opt/otrs/bin/otrs.SetPermissions.pl
8. Backup/Restore database using script:
Code: Select all
./backup.pl -d /home/proferis/ -t fullbackup
### move to new server an restore
./restore.pl -b /home/proferis/otrsbak/ -d /opt/otrs/
./otrs.SetPermissions.pl
9. Start Apache2 etc.
Code: Select all
a2enconf otrs
a2ensite http.otrs.conf
a2enmod ssl
a2enmod perl
a2enmod headers
a2enmod filter
a2enmod deflate
a2enmod version
Code: Select all
sudo systemctl start apache2
sudo su - otrs -c "/opt/otrs/bin/otrs.Daemon.pl start"
sudo su - otrs -c "/opt/otrs/bin/Cron.sh start"
10. Start OTRS & Chech Errors
Code: Select all
cd /var/log/apache2/
less error.log
###When I stared Dashboard or ticket Page, nothing is displayed, only log in /var/log/apache2/:
Code: Select all
[Mon Aug 20 15:18:48 2018] -e: Deep recursion on subroutine "Kernel :: System :: DB :: Connect" at /opt/otrs/Kernel/System/DB.pm line 466.
[Mon Aug 20 15:18:48 2018] -e: Deep recursion on subroutine "Kernel :: System :: DB :: Do" at /opt/otrs/Kernel/System/DB.pm line 221.
I could have missed something in the commands above.