[SOLVED] OTRS and database on separated servers

Moderator: crythias

Post Reply
HervE
Znuny wizard
Posts: 391
Joined: 03 Jan 2011, 17:15
Znuny Version: 3.3.8
Location: France

[SOLVED] OTRS and database on separated servers

Post by HervE »

Hello forum,

What could you tell me about OTRS application and OTRS database installation on 2 separated servers?
Is it easy to implement?
Do I only have to set a hostname different from "localhost" while installing OTRS application (at database step)?

Best regards,
HervE
Last edited by HervE on 10 Dec 2014, 11:10, edited 1 time in total.
OTRS 3.3.8 - Windows 7 - IIS7 - SQL Server - Firefox 30
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: OTRS and database on separated servers

Post by crythias »

That's more or less it, but the MySQL server needs to be configured to allow remote connections. At least specifically from OTRS server.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
HervE
Znuny wizard
Posts: 391
Joined: 03 Jan 2011, 17:15
Znuny Version: 3.3.8
Location: France

Re: OTRS and database on separated servers

Post by HervE »

Yes, that makes sense.

By the way (I've edited my signature), we're using SQL Server instead of MySQL.

Regards,
HervE
OTRS 3.3.8 - Windows 7 - IIS7 - SQL Server - Firefox 30
HervE
Znuny wizard
Posts: 391
Joined: 03 Jan 2011, 17:15
Znuny Version: 3.3.8
Location: France

Re: OTRS and database on separated servers

Post by HervE »

As experienced with SQL Server:

During the OTRS web installation, the syntax of distant hostname must follow this model:
DBServerName\DBInstanceName

Works fine.

HervE
OTRS 3.3.8 - Windows 7 - IIS7 - SQL Server - Firefox 30
Post Reply