OTRS and DB on different servers

Moderator: crythias

Post Reply
ronaldjerardmedina
Znuny advanced
Posts: 102
Joined: 24 Jun 2016, 11:36
Znuny Version: 5.0.3-01
Real Name: Ronald Jerard
Company: Medina

OTRS and DB on different servers

Post by ronaldjerardmedina »

Hi all,

How can I install OTRS on Server1 and its Database is on different server (Server2). Noob here. I done some research but I still cant figure out how to do it. My otrs will be installed in server1 ip add 192.168.x.1 and otrsdb will be on 192.168.x.2.

Thanks in advance!
OTRS 5.0.3-01 - MySql - SLES -
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: OTRS and DB on different servers

Post by reneeb »

When you install your OTRS via browser (installer.pl) you can set the host when it comes to database connection... If you've already installed and configured OTRS and you want to move the database, open Kernel/Config.pm and change the DatabaseHost setting.
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
ronaldjerardmedina
Znuny advanced
Posts: 102
Joined: 24 Jun 2016, 11:36
Znuny Version: 5.0.3-01
Real Name: Ronald Jerard
Company: Medina

Re: OTRS and DB on different servers

Post by ronaldjerardmedina »

Hi reneeb,

Thanks for the answer!
OTRS 5.0.3-01 - MySql - SLES -
ronaldjerardmedina
Znuny advanced
Posts: 102
Joined: 24 Jun 2016, 11:36
Znuny Version: 5.0.3-01
Real Name: Ronald Jerard
Company: Medina

Re: OTRS and DB on different servers

Post by ronaldjerardmedina »

I got an error when i install otrs via web installer it says

Code: Select all

unknown mysql server host 'otrsdb' (1)
otrsdb is the hostname.
OTRS 5.0.3-01 - MySql - SLES -
wurzel
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: OTRS and DB on different servers

Post by wurzel »

Hi,

seems your DNS is not working. Try the IP Address.

Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
ronaldjerardmedina
Znuny advanced
Posts: 102
Joined: 24 Jun 2016, 11:36
Znuny Version: 5.0.3-01
Real Name: Ronald Jerard
Company: Medina

Re: OTRS and DB on different servers

Post by ronaldjerardmedina »

Hi wurzel,

It works using the IP Address. Thanks, But, I also want to know how to work with hostnames? how can i make the DNS to work? this is for future reference, Thanks!
OTRS 5.0.3-01 - MySql - SLES -
wurzel
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: OTRS and DB on different servers

Post by wurzel »

Hi,

one way to start is

https://en.wikipedia.org/wiki/Domain_Name_System

Depending on your environment you have to set up a DNS Server.


Florian
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
ronaldjerardmedina
Znuny advanced
Posts: 102
Joined: 24 Jun 2016, 11:36
Znuny Version: 5.0.3-01
Real Name: Ronald Jerard
Company: Medina

Re: OTRS and DB on different servers

Post by ronaldjerardmedina »

Hello,

Thanks for the response! This information will help me alot.
OTRS 5.0.3-01 - MySql - SLES -
Post Reply