Update OTRS from v5.x.x+ to v6.x.x+ on centos7
Hi Tech Guys,
Sometimes OTRS need some care to be up-to-date and secure, than here you can find a right and easy way to update OTRS from v5 to v6 (IMPORTANT: only from any v5.x.x to any v6.x.x)
We recommend to test in a clone or test machine before to move and do any edit in a production environment (avoid disaster please).
The database migration from OTRS 5 to 6 performs significant changes to database tables and data. Be sure that there is enough storage space available to complete the migration. You cannot update from any OTRS version directly to OTRS 6. For example, if you come from OTRS 3.0, you first have to full update to OTRS 3.1, then to 3.2, 3.3, 4, 5 and finally to OTRS 6. If you have any custom Perl or XML configuration files in Kernel/Config/Files, these need to be converted to the new formats supported by OTRS 6 before running the migration script.
Requirements:
-Centos 7.3 server with minimal hardware configuration (depends of your needs).
-ROOT permission on server.
-Internet connection to download all needed packages.
-Good IT basic knowledge and a bit of patience…
Let’s Start!
Stop all services used by the ticketing system before proceding
systemctl stop crond systemctl stop postfix systemctl stop httpd
Move in the main path and stop daemon as otrs user
cd /opt/otrs/ su -c "/opt/otrs/bin/otrs.Daemon.pl stop" -s /bin/bash otrs su -c "/opt/otrs/bin/Cron.sh stop" -s /bin/bash otrs
Backup otrs database and /opt/otrs/ folder, i prefer to keep safe everything on other location than the working server
mysqldump -p otrs > otrsdbbackup.sql scp root@otrs.yobicloud.local:/root/otrsdbbackup.sql (your local path for backup) scp -r root@otrs.yobicloud.local:/opt/otrs (your local path for backup)
Rename the old folder because you will need some files of your previous configuration, download the packages of the newer version (in this case the v5.0.21) decompress and rename the folder as the oldest, without the version number
yum update -y cd /opt/ mv otrs otrs-old wget http://ftp.otrs.org/pub/otrs/otrs-6.0.14.tar.gz tar -xzf otrs-6.0.14.tar.gz mv otrs-6.0.14 otrs
Move your olds config and ticket numbers files, from the backup folder to the new
cp /opt/otrs-old/Kernel/Config.pm /opt/otrs/Kernel/ cp /opt/otrs-old/Kernel/Config/Files/ZZZAuto.pm /opt/otrs/Kernel/Config/Files/
(Optional) If you store article data in the filesystem you have to restore the article folder, or the specified folder in the SysConfig if is tuned
(Optional) cp -rf /opt/otrs-old/var/article/ /opt/otrs/var/.
(Optional) Restore already installed default statistics. If you have additional packages with default statistics you have to restore the stats xml files with the suffix *.installed to /opt/otrs/var/stats.
(Optional) cd OTRS-BACKUP/var/stats cp *.installed /opt/otrs/var/stats
Set the permission as root user, will detect the correct user and group settings needed for your setup
cd /opt/otrs/ bin/otrs.SetPermissions.pl
Check if some PERL modules are missing, and install any modules that might be needed for your configuration
/opt/otrs/bin/otrs.CheckModules.pl
The output will be something like this:
o Apache::DBI................................ok (v1.12) o Apache2::Reload............................ok (v0.13) o Archive::Tar...............................ok (v1.92) o Archive::Zip...............................ok (v1.30) o Crypt::Eksblowfish::Bcrypt.................ok (v0.009) o Crypt::SSLeay..............................ok (v0.64) o Date::Format...............................ok (v2.24) o DateTime...................................Not installed! Use: 'yum install "perl(DateTime)"' (required) o DBI........................................ok (v1.627) o DBD::mysql.................................ok (v4.023) o DBD::ODBC..................................Not installed! (optional - Required to connect to a MS-SQL database.) o DBD::Oracle................................Not installed! (optional - Required to connect to a Oracle database.) o DBD::Pg....................................Not installed! Use: 'yum install "perl(DBD::Pg)"' (optional - Required to connect to a PostgreSQL database.) o Digest::SHA................................ok (v5.85) o Encode::HanExtra...........................Not installed! Use: 'yum install "perl(Encode::HanExtra)"' (optional - Required to handle mails with several Chinese character sets.) o IO::Socket::SSL............................ok (v1.94) o JSON::XS...................................ok (v3.01) o List::Util::XS.............................ok (v1.27) o LWP::UserAgent.............................FAILED! Not all prerequisites for this module correctly installed. o Mail::IMAPClient...........................ok (v3.37) o IO::Socket::SSL............................ok (v1.94) o Authen::SASL...............................ok (v2.15) o Authen::NTLM...............................ok (v1.09) o ModPerl::Util..............................ok (v2.000010) o Net::DNS...................................ok (v0.72) o Net::LDAP..................................ok (v0.56) o Template...................................ok (v2.24) o Template::Stash::XS........................ok (undef) o Text::CSV_XS...............................ok (v1.00) o Time::HiRes................................ok (v1.9725) o XML::LibXML................................ok (v2.0018) o XML::LibXSLT...............................ok (v1.80) o XML::Parser................................ok (v2.41) o YAML::XS...................................ok (v0.54)
This is an update, than the installation of other modules are not necessary except for “perl(DateTime)”, because all you need was already installed, until you need to change DB.
The module “perl(DateTime)” is required from version 6 of otrs for the new features, otherwise the installation cannot proceed.
In my case i will not install any DB modules but only the required (note that LWP::UserAgent will be automagically installed after DateTime)
yum install "perl(DateTime)"
You can re-check the modules with the script
/opt/otrs/bin/otrs.CheckModules.pl
and if the missing will be only the DB packages other than your, you can proceed with the migration.
Is time to migrate…
This is required only If you have any custom Perl or XML configuration files in Kernel/Config/Files from previus version and need to be converted to the new formats supported by OTRS 6 before running the migration script more information here.
Important: Kernel/Config/Files/ZZZAuto.pm has been merged into Kernel/Config/Files/ZZZAAuto.pm.
If Between the folder /opt/otrs/Kernel/Config/Files/ and /opt/otrs-old/Kernel/Config/Files/ there are differents files .pm, copy the missing files from /opt/otrs-old/Kernel/Config/Files/ to /opt/otrs/Kernel/Config/Files/ except ZZZAuto.pm, if there are different .XML files, copy them in /opt/otrs/Kernel/Config/Files/
In my case, as you can see in the video i moved the files from my production envirorment to test the migration, you can move it from otrs-old folder if there are.
scp (your local path for backup)xmlotrs/* root@otrs.yobicloud.local:/opt/otrs/Kernel/Config/Files/
OTRS 6 uses a new XML configuration file format and the location of configuration files moved from Kernel/Config/Files to Kernel/Config/Files/XML. To convert existing XML configuration files to the new format and location, you can use the following tool that is part of the OTRS framework:
cd /opt/otrs/ su -c "bin/otrs.Console.pl Dev::Tools::Migrate::ConfigXMLStructure --source-directory Kernel/Config/Files/" -s /bin/bash otrs
Now is time to apply the database changes and update schema as otrs user NOT as root.
cd /opt/otrs su -c "scripts/DBUpdate-to-6.pl" -s /bin/bash otrs
Last step is to update the installed packages because from OTRS 5 are not compatible with OTRS 6 and have to be updated.
You can use the command below to update all installed packages. This works for all packages that are available from online repositories. You can update other packages later via the package manager from GUI.
cd /opt/otrs/ su -c "bin/otrs.Console.pl Admin::Package::UpgradeAll" -s /bin/bash otrs
Restart your services
systemctl start httpd systemctl start postfix systemctl start crond
Start the daemon as otrs user.
su -c "/opt/otrs/bin/otrs.Daemon.pl start" -s /bin/bash otrs su -c "/opt/otrs/bin/Cron.sh start" -s /bin/bash otrs
delete install packages, my sql backup, and otrs-old folder locate in /opt for the production server, to clean the machine or leave more space.
here the link for the official docs
—>>> ENJOY!!! <<<—
Install OTRS v5.x.x on centos 7 with SSL
OTRS is an Open source Ticket Request System, the best, flexible ticket and process management system that allows service management professionals in any company to support, managing, ordering and track back the solutions, based on IT department cooperation, will become an indispensable tool in everyday life of IT troubleshooters.
Requirements:
-Centos 7.3 server with Minimum 1 CPU, 2 GB of RAM for normal working ( if you have a massive email flow, we suggest to upgrade the hardware )
-ROOT permission on server.
-E-mail account and mail-server settings
-Internet connection to download all needed packages.
-Good IT knowledge and a bit of patience…
Let’s Start!
Setup network with static IP and set DNS
First of all, update your server
yum update -y
Change hostname at your server if needed
hostnamectl set-hostname otrs.yobicloud.local
Install some useful packages, wget to download, network tools (always useful to troubleshoot network), htop to monitor the hardware and processes with a helpful graphics and mod_ssl to configure Secure connection SSL/TLS over HTTP on Apache2.
yum install wget net-tools htop mod_ssl
Enable the EPEL repository
yum install epel-release
Disable selinux in /etc/selinux/config file to avoid problems until you know what are doing…
Then open the file and change the line SELINUX=enforcing to SELINUX=disabled, save and reboot server
reboot
Then re-update your system.
yum update -y
I will use MySQL opensource for database, then install MariaDB, but there are different alternatives like Postgres, Oracle or MS-SQL, and if you are comfortable with them, use it. you just need to install differents otrs modules for make it working properly. I will continue with a standard MariaDB database
yum install mariadb-server mariadb
You will need to change the default MySQL settings in order to make it suitable for OTRS. Open its configuration file using vi or your favorite text editor
vi /etc/my.cnf
Add the following lines under the [mysqld] section, which specify the sizes of a few files.
[mysqld]
max_allowed_packet=64M
query_cache_size=32M
innodb_log_file_size=256M
datadir=/var/lib/mysql
Then save and close the file. Make sure you do this before you start MySQL for the first time.
Now, start MariaDB.
systemctl start mariadb
Next, secure the MySQL database.
/usr/bin/mysql_secure_installation
You will be asked a few questions. You can accept the default values for all of the questions by just pressing ENTER for each, except for setting the new root password. Make a note of your root user password because you will need it later in this tutorial.
Now that we have everything, we need to install the OTRS application
We will install OTRS using the pre-built RPM package for CentOS. First, we need to download the latest RPM from their official repository. You can browse the repository directory to determine the latest version.
wget http://ftp.otrs.org/pub/otrs/RPMS/rhel/7/otrs-5.0.21-02.noarch.rpm
Next, install OTRS (note that sometimes you have to install twice).
yum install --nogpgcheck otrs-5.0.21-02.noarch.rpm
OTRS is written in Perl and uses a number of Perl modules. We can check for missing modules by using the CheckModules.pl script included with OTRS.
If some PERL modules are missing, install which might be needed for your configuration
/opt/otrs/bin/otrs.CheckModules.pl
The output will be something like this:
o Apache::DBI......................ok (v1.12) o Apache2::Reload..................ok (v0.13) o Archive::Tar.....................ok (v1.92) o Archive::Zip.....................ok (v1.30) o Crypt::Eksblowfish::Bcrypt.......Not installed! Use: 'yum install "perl(Crypt::Eksblowfish::Bcrypt)"' (optional - For strong password hashing.) o Crypt::SSLeay....................ok (v0.64) o Date::Format.....................ok (v2.24) o DBI..............................ok (v1.627) o DBD::mysql.......................ok (v4.023 o DBD::ODBC........................Not installed! (optional - Required to connect to a MS-SQL database.) o DBD::Oracle......................Not installed! (optional - Required to connect to a Oracle database.) o DBD::Pg..........................Not installed! Use: 'yum install "perl(DBD::Pg)"' (optional - Required to connect to a PostgreSQL database.) o Digest::SHA......................ok (v5.85) o Encode::HanExtra.................Not installed! Use: 'yum install "perl(Encode::HanExtra)"' (optional - Required to handle mails with several Chinese character sets.) o IO::Socket::SSL..................ok (v1.94) o JSON::XS.........................Not installed! Use: 'yum install "perl(JSON::XS)"' (optional - Recommended for faster AJAX/JavaScript handling.) o List::Util::XS...................ok (v1.27) o LWP::UserAgent...................ok (v6.13) o Mail::IMAPClient.................Not installed! Use: 'yum install "perl(Mail::IMAPClient)"' (optional - Required for IMAP TLS connections.) o IO::Socket::SSL..................ok (v1.94) o Authen::SASL.....................ok (v2.15) o Authen::NTLM.....................Not installed! Use: 'yum install "perl(Authen::NTLM)"' (optional - Required for NTLM authentication mechanism in IMAP connections.) o ModPerl::Util....................Not installed! Use: 'yum install "perl(ModPerl::Util)"' (optional - Improves Performance on Apache webservers dramatically.) o Net::DNS.........................ok (v0.72) o Net::LDAP........................ok (v0.56) o Template.........................ok (v2.24) o Template::Stash::XS..............ok (undef) o Text::CSV_XS.....................Not installed! Use: 'yum install "perl(Text::CSV_XS)"' (optional - Recommended for faster CSV handling.) o Time::HiRes......................ok (v1.9725) o Time::Piece......................ok (v1.20_01) o XML::LibXML......................ok (v2.0018) o XML::LibXSLT.....................ok (v1.80) o XML::Parser......................ok (v2.41) o YAML::XS.........................Not installed! Use: 'yum install "perl(YAML::XS)"' (required - Very important)
As you can see, all checked modules are followed by a comment that will help you in the installation. Not all modules are necessary to you, for example if you have a my-sql DB (DBD::mysql module already install), the “perl(DBD::Pg)” or “perl(DBD::ODBC)” or “perl(DBD::Oracle)” are not required to OTRS, instead if you have a PG DB than follow the comments and install with the command shown below, an so on…
example: yum install "perl(DBD::Pg)"
In my case i will not install any DB modules other than my-sql, but I’ll proceed with the missing tagged like required, optional and recommended needed to me (so analyze your needs before continue and install your needs )
yum install "perl(XML::LibXSLT)"
yum install "perl(Authen::NTLM)"
yum install "perl(YAML::XS)"
yum install "perl(Text::CSV_XS)"
yum install "perl(ModPerl::Util)"
yum install "perl(Mail::IMAPClient)"
yum install "perl(JSON::XS)"
yum install "perl(Crypt::Eksblowfish::Bcrypt)"
You can re-check the modules with the script:
/opt/otrs/bin/otrs.CheckModules.pl
Add firewall exceptions for port 80-443 and reload firewalld conf
firewall-cmd --permanent --add-service=http firewall-cmd --permanent --add-service=https firewall-cmd --reload
Restart Apache2 service.
systemctl restart httpd
Start the OTRS daemon, activate cronjob as otrs user, and as root enable webserver and database at boot, now reboot to check that everything is starting alone.
sudo su - otrs -c "bin/otrs.Daemon.pl start"
sudo su - otrs -c "/opt/otrs/bin/Cron.sh start"
systemctl enable httpd
systemctl enable mariadb
reboot
Configure from the front-end, once all previous step went done.
Open in browser https://otrs.yobicloud.local/otrs/installer.pl use your own ip or hostname instead of “otrs.yobicloud.local”, note that if you installed mod_ssl, the apache package for SSL, you will have https already activated with basic configuration and certificate, later you will need just to make default, and tune otrs sysconfig and the apache conf files, to generate new certificate follow our apache tutorial.
will show world offices info, click next, and after reading you have to accept the license terms and conditions.
Is time to choose the DB, our installation is with MariaDB, so select MYSQL and ‘Create new DB for OTRS’ if you don’t want to use an existing one.
Fill in password, DB address if is different than local and press check DB settings, if everything is green like the photo below you can continue, Write down the password generated or change it (this is needed to log-in OTRS)
NEXT
In the STEP 3 fill in a fully qualified domain name(FQDN), or you can just use your server’s IP address, the Administrator email to get notify about errors or warning, the organization name, select logging type, main language and if you prefer to check MX record select YES.
To receive e-mails from customers configure an incoming account with type of mail ‘IMAP preferred’ mail address, user and password.
For outbound you can leave it so, if you not have particular configuration, you can check if will work pressing button ‘check mail configuration’ or ‘Skip this step’ to continue and check later.
Congratulation!!! Installation Completed, write down the Admin login credential
Now login using the credentials of the previus page at the link https://otrs.yobicloud.local/otrs/index.pl (use your own ip or hostname instead of “otrs.yobicloud.local”), after login you will receive two advice, one to create a new user for working with otrs, clicking on this link will redirect to the operators management page so create the new user here, and the other are relative at otrs daemon, to check if the daemon is up, use:
sudo su - otrs -c "bin/otrs.Daemon.pl status"
Note that the cron call the daemon every 5 minutes, than wait minimum 5 minutes and if the Daemon still is not running, follow the suggestion in the pop-up.
SSL/TLS connection over http is essential today in the scary web, consider activate the HTTPS on your web server.
(OPTIONAL)
If you have no possibility to activate it from the server click in the header menu on admin and select SysConfig, search for HTTPS, in the result click on core, scroll untill the configuration option HttpType and change to HTTPS.
Good practice is to also redirect all HTTP traffic to HTTPS, in case someone tries to access via an insecure link. This should be done on web server configuration level for maximum effect. However, in case this is not possible, you can set HTTPSForceRedirect to Yes in SysConfig if available.
(BEST WAY)
The best way is edit apache2 configuration, than if can be possible, chose this method instead previus (optional method), by creating a new file that will redirect all http request to otrs main page in https.
cd /etc/httpd/conf.d
vi ssl.conf
And add the following text (remember to edit with your own settings):
<VirtualHost *:80>
ServerName otrs.yobicloud.local
ServerName 192.168.24.101
Redirect permanent / https://otrs.yobicloud.local/otrs/index.pl
</VirtualHost>
Edit the main SSL config file for all HTTPS connection with some hardening tips
vi /etc/httpd/conf.d/ssl.conf
Uncomment and edit (always with your data) as:
DocumentRoot "/var/www/html"
ServerName 192.168.24.101:443
Some where in the file comment this line:
SSLCipherSuite HIGH:MEDIUM:!aNULL:!MD5:!SEED:!IDEA
and add the following lines to hardening a bit apache2
SSLCipherSuite EECDH+AESGCM:EDH+AESGCM:AES256+EECDH:AES256+EDH
SSLHonorCipherOrder On
Header always set Strict-Transport-Security "max-age=63072000; includeSubdomains"
Header always set X-Frame-Options DENY
Header always set X-Content-Type-Options nosniff
until you leave untouched the default certificates, paths and names, you don’t need further changes, than restart apache2 to apply configuration.
systemctl restart httpd
Here the official documentation about OTRS.
—>>> ENJOY!!! <<<—
Update OTRS from v4.x.x+ to v5.x.x+ on centos7
Hi Tech Guys,
Sometimes OTRS need some care to be up-to-date and secure, than here you can find a right and easy way to update OTRS from v4 to v5 (IMPORTANT: only from any v4.x.x to any v5.x.x)
We recommend to test in a clone or test machine before to move and do any edit in a production environment (avoid disaster please).
Requirements:
-Centos 7.3 server with minimal hardware configuration (depends of your needs).
-ROOT permission on server.
-Internet connection to download all needed packages.
-Small IT basic knowledge and a bit of patience…
Let’s Start!
Stop all services used by the ticketing system before proceding
systemctl stop crond systemctl stop postfix systemctl stop httpd
Move in the main path and stop daemon
cd /opt/otrs su -c "bin/Cron.sh stop" -s /bin/bash otrs su -c "bin/otrs.Scheduler.pl -a stop" -s /bin/bash otrs
Backup otrs database and /opt/otrs/ folder, i prefer to keep safe everything on other location than the working server
mysqldump -p otrs > otrsdbbackup.sql scp root@10.0.0.58:/root/otrsdbbackup.sql /home/user/otrs/. scp -r root@10.0.0.58:/opt/otrs /home/user/otrs
Rename the old folder because you will need some files of your previous configuration, download the packages of the newer version (in this case the v5.0.21) decompress and rename the folder as the oldest, without the version number
cd /opt/
mv otrs otrs-old
wget ftp://ftp.otrs.org/pub/otrs/otrs-5.0.21.tar.gz
tar -xzf otrs-5.0.21.tar.gz
mv otrs-5.0.21 otrs
Move your olds config and ticket numbers files, from the backup folder to the new
cp /opt/otrs-old/Kernel/Config.pm /opt/otrs/Kernel/ cp /opt/otrs-old/Kernel/Config/GenericAgent.pm /opt/otrs/Kernel/Config/ cp /opt/otrs-old/Kernel/Config/Files/ZZZAuto.pm /opt/otrs/Kernel/Config/Files/ cp /opt/otrs-old/var/log/TicketCounter.log /opt/otrs/var/log/
(Optional) If you store article data in the filesystem you have to restore the article folder, or the specified folder in the SysConfig if is tuned
(Optional) cp -rf /opt/otrs-old/var/article/ /opt/otrs/var/.
Set the permission for Centos or Red Hat (Webserver with apache user)
cd /opt/otrs bin/otrs.SetPermissions.pl --web-group=apache
Check if some PERL modules are missing, and install any modules that might be needed for your configuration
/opt/otrs/bin/otrs.CheckModules.pl
The output will be something like this:
o Apache::DBI......................ok (v1.12) o Apache2::Reload..................ok (v0.13) o Archive::Tar.....................ok (v1.92) o Archive::Zip.....................ok (v1.30) o Crypt::Eksblowfish::Bcrypt.......Not installed! Use: 'yum install "perl(Crypt::Eksblowfish::Bcrypt)"' (optional - For strong password hashing.) o Crypt::SSLeay....................ok (v0.64) o Date::Format.....................ok (v2.24) o DBI..............................ok (v1.627) o DBD::mysql.......................ok (v4.023 o DBD::ODBC........................Not installed! (optional - Required to connect to a MS-SQL database.) o DBD::Oracle......................Not installed! (optional - Required to connect to a Oracle database.) o DBD::Pg..........................Not installed! Use: 'yum install "perl(DBD::Pg)"' (optional - Required to connect to a PostgreSQL database.) o Digest::SHA......................ok (v5.85) o Encode::HanExtra.................Not installed! Use: 'yum install "perl(Encode::HanExtra)"' (optional - Required to handle mails with several Chinese character sets.) o IO::Socket::SSL..................ok (v1.94) o JSON::XS.........................Not installed! Use: 'yum install "perl(JSON::XS)"' (optional - Recommended for faster AJAX/JavaScript handling.) o List::Util::XS...................ok (v1.27) o LWP::UserAgent...................ok (v6.13) o Mail::IMAPClient.................Not installed! Use: 'yum install "perl(Mail::IMAPClient)"' (optional - Required for IMAP TLS connections.) o IO::Socket::SSL................ok (v1.94) o Authen::SASL...................ok (v2.15) o Authen::NTLM...................Not installed! Use: 'yum install "perl(Authen::NTLM)"' (optional - Required for NTLM authentication mechanism in IMAP connections.) o ModPerl::Util....................Not installed! Use: 'yum install "perl(ModPerl::Util)"' (optional - Improves Performance on Apache webservers dramatically.) o Net::DNS.........................ok (v0.72) o Net::LDAP........................ok (v0.56) o Template.........................ok (v2.24) o Template::Stash::XS..............ok (undef) o Text::CSV_XS.....................Not installed! Use: 'yum install "perl(Text::CSV_XS)"' (optional - Recommended for faster CSV handling.) o Time::HiRes......................ok (v1.9725) o Time::Piece......................ok (v1.20_01) o XML::LibXML......................ok (v2.0018) o XML::LibXSLT.....................ok (v1.80) o XML::Parser......................ok (v2.41) o YAML::XS.........................Not installed! Use: 'yum install "perl(YAML::XS)"' (required - Very important)
As you can see, all checked modules are followed by a comment that will help you in the installation. Not all modules are necessary to you, for example if you have a my-sql DB (DBD::mysql module already install), the “perl(DBD::Pg)” or “perl(DBD::ODBC)” or “perl(DBD::Oracle)” are not required to OTRS, instead if you have a PG DB than follow the comments and install with the command shown below, an so on…
example: yum install "perl(DBD::Pg)"
In my case i will not install any DB modules other than my-sql, but i’ll proceed with the missing tagged like required, optional and recommended needed to me (so analyze your needs before continue and install your needs )
yum install "perl(XML::LibXSLT)" yum install "perl(Authen::NTLM)" yum install "perl(YAML::XS)" yum install "perl(Text::CSV_XS)" yum install "perl(ModPerl::Util)" yum install "perl(Mail::IMAPClient) yum install "perl(JSON::XS)" yum install "perl(Crypt::Eksblowfish::Bcrypt)"
You can re-check the modules with the script:
/opt/otrs/bin/otrs.CheckModules.pl
Now is time to apply the database changes and update schema as otrs user NOT as root.
cd /opt/otrs cat scripts/DBUpdate-to-5.mysql.sql | mysql -p -f -u root otrs su -c "bin/otrs.Console.pl Maint::Database::Check" -s /bin/bash otrs su -c "scripts/DBUpdate-to-5.pl" -s /bin/bash otrs
Always as otrs user delete caches and refresh the configuration
su -c "bin/otrs.Console.pl Maint::Config::Rebuild" -s /bin/bash otrs su -c "bin/otrs.Console.pl Maint::Cache::Delete" -s /bin/bash otrs
Restart your services
systemctl start httpd systemctl start postfix systemctl start crond
Start the daemon as otrs user.
su -c "/opt/otrs/bin/otrs.Daemon.pl start" -s /bin/bash otrs
The defaults OTRS cron files are located in /opt/otrs/var/cron/*.dist, they assicuring that the OTRS Daemon is running. They need to be activated by copying them without the “.dist” filename extension, and than use the script Cron.sh as OTRS user to schedule these jobs.
cd /opt/otrs/var/cron for foo in *.dist; do cp $foo `basename $foo .dist`; done su -c "/opt/otrs/bin/Cron.sh start" -s /bin/bash otrs
delete the install packages, my sql backup, and otrs-old folder locate in /opt for the production server
here the link for the official docs
—>>> ENJOY!!! <<<—
Computer Acronyms with T letter
Click on a letter to dive in the YobiTech Dictionary.
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
| TAC | Technical Assistance Center |
| TAO | Track At Once |
| TAPI | Telephony Application Programming Interface |
| TAS | Technology Application Support |
| TAXII | Trusted Automated Exchange of Indicator Info |
| TB | TeraByte |
| TBC | Technical Briefing Center |
| TBD | To Be Determined |
| TBI | Ten Bit Interface |
| TCAM | Ternary content addressable memory |
| Tcl | Tool Command Language |
| TCP | Transmission Control Protocol |
| TCP/IP | Transmission Control Protocol/Internet Protocol |
| TCU | Telecommunication Control Unit |
| TDMA | Time Division Multiple Access |
| TECHINT | Technical Intelligence |
| TFIB | Tag Forwarding Information Base |
| TFT | Thin-Film Transistor |
| TG | Technology Group |
| TIFF | Tagged Image File Format |
| TFTP | Trivial File Transfer Protocol |
| TI | Texas Instruments |
| TLA | Three-Letter Acronym |
| TLD | Top-Level Domain |
| TLS | Thread-Local Storage |
| TLS | Transport Layer Security |
| TLV | Type-length-value |
| tmp | Temporary |
| TNC | Terminal Node Controller |
| TNC | Threaded Neill Concelman connector |
| ToS | Type of Service |
| TOR | The Onion Router |
| TPF | Transaction Processing Facility |
| TPM | Trusted Platform Module |
| TRC | Technical Response Center |
| TROFF | Trace Off |
| TRON | Trace ON |
| TRSDOS | Tandy Radio Shack Disk Operating System |
| TSS | Technical Support Services |
| TSO | Time Sharing Option |
| TSP | Traveling Salesman Problem |
| TSR | Terminate and Stay Resident |
| TTA | True Tap Audio |
| TTA | Types of Threat Actors |
| TTF | TrueType Font |
| TTI | Typical Threat Indicators |
| TTL | Transistor Transistor Logic |
| TTL | Time To Live |
| TTPs | Tools Techniques and Processes |
| TTS | Text-to-Speech |
| TTY | Teletype |
| TUCOWS | The Ultimate Collection of Winsock Software |
| TUG | TeX Users Group |
| TWAIN | Technology Without An Interesting Name |
Computer Acronyms with S letter
Click on a letter to dive in the YobiTech Dictionary.
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
| SaaS | Software as a Service |
| SALT | Service Agreement Look up Too |
| SAM | Security Account Manager |
| SAMBA | Session Message Block |
| SAN | Storage Area Network |
| SAS | Serial attached SCSI |
| SATA | Serial ATA |
| SAX | Simple API for XML |
| SBOD | Spinning Beachball of Death |
| SBP2 | Serial Bus Protocol 2 |
| sbin | superuser binary |
| sbs | Small Business Server |
| SBU | Standard Build Unit |
| SCADA | Supervisory Control And Data Acquisition |
| SCID | Source Code in Database |
| SCM | Software Configuration Management |
| SCM | Source Code Management |
| SCP | Secure Copy |
| SCP | Switch Module Configuration Protocol |
| SCPC | Single Channel Per Carrier |
| SCPI | Standard Commands for Programmable Instrumentation |
| SCSA | Secure Content Storage Association |
| SCSI | Small Computer System Interface |
| SCTP | Stream Control Transmission Protocol |
| SD | Secure Digital |
| SDDL | Security Descriptor Definition Language |
| SDH | Synchronous Digital Hierarchy |
| SDI | Single Document Interface |
| SEC | Single Edge Contact |
| SDIO | Secure Digital Input Output |
| SDK | Software Development Kit |
| SDL | Simple DirectMedia Layer |
| SDN | Service Delivery Network |
| SDP | Session Description Protocol |
| SDR | Software Defined Radio |
| SDRAM | Synchronous Dynamic Random Access Memory |
| SDSL | Symmetric DSL |
| SE | Single Ended |
| SEG | Secure Email Gateway |
| SEI | Software Engineering Institute |
| SEO | Search Engine Optimization |
| SFTP | Secure FTP |
| SFTP | Simple File Transfer Protocol |
| SFTP | SSH File Transfer Protocol |
| SGI | Silicon Graphics Incorporated |
| SGML | Standard Generalized Markup Language |
| SGR | Select Graphic Rendition |
| SHA | Secure Hash Algorithm |
| SHDSL | Single pair High speed Digital Subscriber Line |
| SIEM | Security Information and Event Management |
| SIGCAT | Special Interest Group on CD-ROM Applications and Technology |
| SIGGRAPH | Special Interest Group on Graphics |
| SIGINT | Signals Intelligence |
| SIMD | Single Instruction Multiple Data |
| SIMM | Single Inline Memory Module |
| SIP | Session Initiation Protocol |
| SIP | Supplementary Ideographic Plane |
| SIP | SPA Interface Processor |
| SISD | Single Instruction, Single Data |
| SISO | Single-Input and Single-Output |
| SISU | Security Internet Services Unit |
| SLA | Service L evel A g reement |
| SLED | SUSE Linux Enterprise Desktop |
| SLES | SUSE Linux Enterprise Server |
| SLI | Scalable Link Interface |
| SLIP | Serial Line Internet Protocol |
| SLM | Service Level Management |
| SLOC | Source Lines of Code |
| SMB | Small Medium Business |
| SMB | Session Message Block |
| SME | Subject Matter Expert |
| SMF | Single-Mode (optical) Fiber |
| SPM | Software project management |
| SPMD | Single Program, Multiple Data |
| SMA | SubMiniature version A |
| SMB | Server Message Block |
| SMBIOS | System Management BIOS |
| SMbus | System Management bus |
| SMIL | Synchronized Multimedia Integration Language |
| S/MIME | Secure/Multipurpose Internet Mail Extensions |
| SMP | Supplementary Multilingual Plane |
| SMP | Symmetric Multi-Processing |
| SMPS | Switch Mode Power Supply |
| SMS | Short Message Service |
| SMS | System Management Server |
| SMSC | Short Message Service Center |
| SMT | Simultaneous Multithreading |
| SMTP | Simple Mail Transfer Protocol |
| SN | Serial Number |
| SNA | Systems Network Architecture |
| SNMP | Simple Network Management Protocol |
| SNTP | Simple Network Time Protocol |
| SOA | Service-Oriented Architecture |
| SOAP | Simple Object Access Protocol |
| SOAP | Symbolic Optimal Assembly Program |
| SOC | Security Operations Center |
| SoC | System-on-a-Chip |
| SO-DIMM | Small Outline DIMM |
| SOE | Standard Operating Environment |
| SOHO | Small Office/Home Office |
| SOI | Silicon On Insulator |
| SONA | Service Oriented Network Architecture |
| SONET | Synchronous Optical Network |
| SOPA | Stop Online Piracy Act |
| SP | Service Pack |
| SPA | Single Page Application |
| SPF | Sender Policy Framework |
| SPI | Serial Peripheral Interface |
| SPI | Stateful Packet Inspection |
| SPARC | Scalable Processor Architecture |
| SQL | Structured Query Language |
| SRAM | Static Random Access Memory |
| SRP | Spatial Reuse Protocol |
| SSA | Static Single Assignment |
| SSD | Software Specification Document |
| SSD | Solid-State Drive |
| SSDP | Simple Service Discovery Protocol |
| SSE | Streaming SIMD Extensions |
| SSH | Secure Shell |
| SSI | Server Side Includes |
| SSI | Single-System Image |
| SSI | Small-Scale Integration |
| SSID | Service Set Identifier |
| SSL | Secure Socket Layer |
| SSO | Single Sign On |
| SSP | Supplementary Special-purpose Plane |
| SSRAM | Synchronous Static RAM |
| SSSE | Supplementary Streaming SIMD Extensions |
| SSSP | Single Source Shortest Path |
| SSTP | Secure Socket Tunneling Protocol |
| STAPL | Standard Test and Programming Language |
| SU | Superuser |
| SUDO | Superuser Do |
| SUS | Single UNIX Specification |
| SUSE | Software und System-Entwicklung |
| SVC | Scalable Video Coding |
| SVG | Scalable Vector Graphics |
| SVGA | Super Video Graphics Array |
| SVI | Switched Virtual Interface |
| SVD | Structured VLSI Design |
| SW | Software |
| SWF | Shock Wave Flash |
| SWG | Secure Web Gateway |
| SWT | Standard Widget Toolkit |
| Sysop | System operator |
Computer Acronyms with V letter
Click on a letter to dive in the YobiTech Dictionary.
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
| VA | Vulnerability Assessment |
| VAX | Virtual Address eXtension |
| VCDB | Veris Catalog Data Base |
| VCPI | Virtual Control Program Interface |
| VERIS | Vocabulary for Event Recording and Incident Sharing |
| VR | Virtual Reality |
| VRML | Virtual Reality Modeling Language |
| VB | Visual Basic |
| VBA | Visual Basic for Applications |
| VBS | Visual Basic Script |
| VDI | Virtual Desktop Infrastructure |
| VDM | Virtual DOS machine |
| VDSL | Very High Bitrate Digital Subscriber Line |
| VESA | Video Electronics Standards Association |
| VFAT | Virtual FAT |
| VFS | Virtual File System |
| VG | Volume Group |
| VGA | Video Graphics Array |
| VHD | Virtual Hard Disk |
| VHF | Very High Frequency |
| VISU | Video Internet Services Unit |
| VLAN | Virtual Local Area Network |
| VLSM | Variable Length Subnet Mask |
| VLB | Vesa Local Bus |
| VLF | Very Low Frequency |
| VLIW | Very Long Instruction Word |
| VLSI | Very-Large-Scale Integration |
| VM | Virtual Machine |
| VM | Virtual Memory |
| VMM | Virtual Machine Monitor |
| VNC | Virtual Network Computing |
| VOD | Video On Demand |
| VoIP | Voice over Internet Protocol |
| VPN | Virtual Private Network |
| VPU | Visual Processing Unit |
| VSAM | Virtual Storage Access Method |
| VSAT | Very Small Aperture Terminal |
| VTL | Virtual Tape Library |
| VTAM | Virtual Telecommunications Access Method |
| VRAM | Video Random Access Memory |
Computer Acronyms with Z letter
Click on a letter to dive in the YobiTech Dictionary.
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
| ZCAV | Zone Constant Angular Velocity |
| ZCS | Zero Code Suppression |
| ZIF | Zero Insertion Force |
| ZIL | ZFS Intent Log |
| ZIFS | Zero Insertion Force Socket |
| ZIP | ZIP file archive |
| ZISC | Zero Instruction Set Computer |
| ZFS | Zettabyte File System |
| ZOI | Zero One Infinity |
| ZOPE | Z Object Publishing Environment |
| ZMA | Zone Multicast Address |
| ZPL | Z-level Programming Language |
Computer Acronyms with Y letter
Click on a letter to dive in the YobiTech Dictionary.
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
| YAAF | Yet Another Application Framework |
| YACC | Yet Another Compiler Compiler |
| YAML | YAML Ain’t Markup Language |
| YARA | Yet Another Ridiculous Acronym |
| YaST | Yet another Setup Tool |
| Y2K | Year Two Thousand |
Computer Acronyms with X letter
Click on a letter to dive in the YobiTech Dictionary.
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
| XAG | XML Accessibility Guidelines |
| XAML | eXtensible Application Markup Language |
| XDM | X Window Display Manager |
| XDMCP | X Display Manager Control Protocol |
| XCBL | XML Common Business Library |
| XHTML | eXtensible Hypertext Markup Language |
| XILP | X Interactive ListProc |
| XML | eXtensible Markup Language |
| XMMS | X Multimedia System |
| XMPP | eXtensible Messaging and Presence Protocol |
| XMS | Extended Memory Specification |
| XNS | Xerox Network Systems |
| XP | Cross-Platform |
| XP | Extreme Programming |
| XPCOM | Cross Platform Component Object Model |
| XPI | XPInstall |
| XPIDL | Cross-Platform IDL |
| XPS | XML Paper Specification |
| XSD | XML Schema Definition |
| XSL | eXtensible Stylesheet Language |
| XSL-FO | eXtensible Stylesheet Language Formatting Objects |
| XSLT | eXtensible Stylesheet Language Transformations |
| XSS | Cross-Site Scripting |
| XTF | eXtensible Tag Framework |
| XTF | eXtended Triton Format |
| XUL | XML User Interface Language |
| XVGA | Extended Video Graphics Adapter |
Computer Acronyms with W letter
Click on a letter to dive in the YobiTech Dictionary.
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
| WAF | Web Application Firewall |
| WAFS | Wide Area File Services |
| WAI | Web Accessibility Initiative |
| WAIS | Wide Area Information Server |
| WAN | Wide Area Network |
| WAP | Wireless Access Point |
| WAP | Wireless Application Protocol |
| WBEM | Web Based Enterprise Management |
| WCAG | Web Content Accessibility Guidelines |
| WCCP | Web Cache Communication Protocol |
| WCF | Windows Communication Foundation |
| WDM | Wavelength Division Multiplexing |
| WebDAV | WWW Distributed Authoring and Versioning |
| WEP | Wired Equivalent Privacy |
| WFI | Wait For Interrupt |
| WIFI | Wireless Fidelity |
| WiMAX | Worldwide Interoperability for Microwave Access |
| WinFS | Windows Future Storage |
| WinRT | Windows RunTime |
| WINS | Windows Internet Name Service |
| WiSM | Wireless Service Module |
| WLAN | Wireless Local Area Network |
| WMA | Windows Media Audio |
| WMI | Windows Management Instrumentation |
| WMO | Worldwide Marketing Organization |
| WMV | Windows Media Video |
| WNS | Windows Push Notification Service |
| WOL | Wake on LAN |
| WOR | Wake on Ring |
| WORA | Write once run anywhere |
| WORE | Write once run everywhere |
| WPA | Wi-Fi Protected Access |
| WPAD | Web Proxy Autodiscovery Protocol |
| WPAN | Wireless Personal Area Network |
| WPF | Windows Presentation Foundation |
| WS | Web Service |
| WSD | Web Services Discovery |
| WSDL | Web Services Description Language |
| WSFL | Web Services Flow Language |
| WUSB | Wireless Universal Serial Bus |
| WWAN | Wireless Wide Area Network |
| WWID | World Wide Identifier |
| WWN | World Wide Name |
| WRL | Worldwide Reverse Logistics |
| WWW | World Wide Web |
| WYSIWYG | What You See Is What You Get |
| WZC | Wireless Zero Configuration |
| W3C | World Wide Web Consortium |
