OTRS HOW TO

Restoring or Migrating OTRS to a New System

https://bluehatrecord.wordpress.com/2015/05/14/restoring-or-migrating-otrs-to-a-new-system/

backup & restoring

https://otrs.github.io/doc/manual/admin/stable/en/html/backup-and-restore.html

Using OTRS with Active Directory as a source for agents

http://wiki.otterhub.org/index.php?title=Using_OTRS_with_Active_Directory_as_a_source_for_agents

install

emerge -av otrs yaml dev-perl/Crypt-SSLeay dev-perl/GD dev-perl/GDGraph dev-perl/Archive-Zip

dev-perl/Net-DNS

$ pwd
/var/lib/otrs/bin
$ perl otrs.CheckModules.pl  | less
cpan DBD::Pg
cpan Net:SSL
cpan YAML:XS
cpan Encode:HanExtra
cpan GD::Text
cpan JSON::XS
cpan Mail::IMAPClient
cpan PDF::API2
cpan Template
cpan Net::LDAP
cpan Template
cpan Crypt::Eksblowfish::Bcrypt

perl -e shell -MCPAN
OR:
# install needed modules!

cd /opt/otrs/
cp Kernel/Config.pm.dist Kernel/Config.pm
cp Kernel/Config/GenericAgent.pm.dist Kernel/Config/GenericAgent.pm

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

$ perl -cw bin/cgi-bin/index.pl
bin/cgi-bin/index.pl syntax OK
$ pwd
/var/lib/otrs
$ perl -cw bin/cgi-bin/customer.pl
bin/cgi-bin/customer.pl syntax OK
$  perl -cw bin/otrs.PostMaster.pl
bin/otrs.PostMaster.pl syntax OK

connect with PostgreSQL OR http://127.0.0.1:802/otrs/installer.pl

http://itsm-demo.otrs.com/otrs/public.pl?Action=PublicFAQZoom;ItemID=53

postgres=# create user otrs password 'otrs' nosuperuser;
CREATE ROLE
postgres=# create database otrs owner otrs;
CREATE DATABASE

psql otrs < /opt/otrs/scripts/database/otrs-schema.postgresql.sql
psql otrs <  /opt/otrs/scripts/database/otrs-initial_insert.postgresql.sql 
psql otrs < /opt/otrs/scripts/database/otrs-schema-post.postgresql.sql

postgres=# \conninfo 
You are connected to database ``postgres'' as user ``postgres'' via socket in ``/run/postgresql'' at port ``5432''.
postgres=# \connect otrs
You are now connected to database ``otrs'' as user ``postgres''.

Allow access to the db

vi /etc/postgresql-9.3/pg_hba.conf

put the following at the top of the file

local   otrs    otrs    password
host    otrs    otrs    127.0.0.1/32    password

psql -U otrs -W -f scripts/database/otrs-schema.postgresql.sql otrs
psql -U otrs -W -f scripts/database/otrs-initial_insert.postgresql.sql otrs
psql -U otrs -W -f scripts/database/otrs-schema-post.postgresql.sql otrs

brightmoon ~ # sed '/^.*#/d;/^$/d' /opt/otrs/Kernel/Config.pm
package Kernel::Config;
use strict;
use warnings;
use utf8;
sub Load {
    my $Self = shift;
    $Self->{DatabaseHost} = '127.0.0.1';
    $Self->{Database} = 'otrs';
    $Self->{DatabaseUser} = 'otrs';
    $Self->{DatabasePw} = 'otrs';
    $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};";
    $Self->{Home} = '/opt/otrs';
}
use base qw(Kernel::Config::Defaults);
1;

nginx

otrs.conf

server {
        listen 802;
        server_name localhost;
        index index.html index.htm index.php index.pl;
        root /opt/otrs/bin/fcgi-bin;
        error_log /tmp/xxxx.log;

location /otrs-web {
        gzip on;
        alias /opt/otrs/var/httpd/htdocs;
}

location ~ ^/otrs/(.*\.pl)(/.*)?$ {
        fastcgi_pass 127.0.0.1:8999;
        fastcgi_index index.pl;
        fastcgi_param SCRIPT_FILENAME /opt/otrs/bin/fcgi-bin/$1;
        fastcgi_param QUERY_STRING $query_string;
        fastcgi_param REQUEST_METHOD $request_method;
        fastcgi_param CONTENT_TYPE $content_type;
        fastcgi_param CONTENT_LENGTH $content_length;
        fastcgi_param GATEWAY_INTERFACE CGI/1.1;
        fastcgi_param SERVER_SOFTWARE nginx;
        fastcgi_param SCRIPT_NAME $fastcgi_script_name;
        fastcgi_param REQUEST_URI $request_uri;
        fastcgi_param DOCUMENT_URI $document_uri;
        fastcgi_param DOCUMENT_ROOT $document_root;
        fastcgi_param SERVER_PROTOCOL $server_protocol;
        fastcgi_param REMOTE_ADDR $remote_addr;
        fastcgi_param REMOTE_PORT $remote_port;
        fastcgi_param SERVER_ADDR $server_addr;
        fastcgi_param SERVER_PORT $server_port;
        fastcgi_param SERVER_NAME $server_name;
  }
}

OTRS installer !!

/etc/init.d/nginx start
/etc/init.d/perl-fcgi
cp /opt/otrs/var/cron/scheduler_watchdog.dist /opt/otrs/var/cron/scheduler_watchdog
/opt/otrs/bin/Cron.sh restart
You can use the OTRS Web Installer, after you installed the OTRS software, to set up and configure the OTRS database. The Web Installer is a web page you can visit in your browser. The URL for the web installer is http://localhost/otrs/installer.pl .

开始页面:

http://127.0.0.1:802/otrs/index.pl

用户:
root@localhost
密码:
6ZsnKwsTFZlFDSLk

20150817
Start page:
http://127.0.0.1:802/otrs/index.pl
User:
root@localhost
Password:
IkJ7KJEmgTXC9iJP

((enjoy))

Your OTRS Team

Troubleshooting

'/var/spool/cron/crontabs' is not a directory, bailing out.

* chmod o+rx /var/spool/cron/

OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerCronTaskManager-

http://forums.otterhub.org/viewtopic.php?t=30820

http://forums.otterhub.org/viewtopic.php?t=30765

https://ask.otrs.org.cn/question/460

你使用的游览器太旧了. OTRS 已确认下列的游览器可正常显示

make error ``Could not set permissions''

http://bytesandbones.wordpress.com/2013/10/18/gentoo-otrs-emerge-error-chown-s-not-allowed/

[Mon Aug 17 22:33:59 2015] otrs.CheckDB.pl: DBD::Pg::st execute failed: ERROR:
    permission denied for relation valid at /opt/otrs/Kernel/System/DB.pm line
    629.
    ERROR: OTRS-otrs.CheckDB.pl-10 Perl: 5.20.2 OS: linux Time: Mon Aug 17
    22:33:59 2015

otrs=# GRANT SELECT on valid TO PUBLIC;
GRANT
otrs=# 

# http://lists.otrs.org/pipermail/otrs/2011-March/035248.html
brightmoon otrs # bin/otrs.CheckDB.pl 
Trying to connect to database
DSN: DBI:Pg:dbname=otrs;
DatabaseUser: otrs

Connected.

Permission denied

https://dev.ib.pl/ib/otrs/commit/5d4ac3825edd45728b7e290986778b635e86ac26 * 2015/02/13 13:09:46 [error] 8880#0: *27 open( "/opt/otrs/var/httpd/htdocs/skins/Agent/default/css-cache/CommonCSS_fb524e3e2db9c03a02c174085257e946.css" failed (13: Permission denied), client: 127.0.0.1, server: localhost, request: "GET /otrs-web/skins/Agent/default/css-cache/CommonCSS_fb524e3e2db9c03a02c174085257e946.css HTTP/1.1", host: "127.0.0.1:802", referrer: "http://127.0.0.1:802/otrs/installer.pl"

./otrs.SetPermissions.pl /opt/otrs --otrs-user=otrs --admin-group=otrs --web-group=otrs

vi /opt/otrs/Kernel/Config/Defaults.pm
vi /opt/otrs/bin/otrs.PostMaster.pl

change "umask 0007" with 002

Reset web login PASSWORD

./bin/otrs.SetPassword.pl root@localhost PASSWORD

install PACKAGES

ITSM

wget ftp://ftp.otrs.org/pub/otrs/itsm/bundle5/ITSM-5.0.8.opm

TEST OTRS Environment

script ~/test.result
time perl otrs.Console.pl Dev::UnitTest::Run

Exchange via Davmail

=> désert/Linux/Davmail

In the sysconfig the setting in Core::Sendmail is set to SMTP.

Optimization

disable OTRSBusinessAvailabilityCheck

add to your Kernel/Config.pm

delete $Self->{"Daemon::SchedulerCronTaskManager::Task"}->{"OTRSBusinessAvailabilityCheck"};
delete $Self->{"Daemon::SchedulerCronTaskManager::Task"}->{"OTRSBusinessEntitlementCheck"};

OTRS welcome

歡迎！

We are glad that you are here. Our OTRS Portal now offers you easy access to the current version and also older releases of OTRS as a faster way to communicate with us and a perfect overview of your requests.

Do you have a question about our products, our services or our company? Or do you want to contact our Service Desk? Please create a ticket and we will attend to your request as soon as possible.

In 'Preferences', you may adjust the current view to suit your needs, update your user details, subscribe or unsubscribe to our OTRS newsletter, or deactivate your account.

The current and other releases of OTRS Free, OTRS Free Features and OTRS Business Solution Features, can be downloaded in the section 'Downloads'.

((enjoy))

Your OTRS Team.

SYSTEC

MSSQL to PostgreSQL

https://github.com/dalibo/sqlserver2pgsql

désert/OTRS