[otrs] OTRS with remote DB

[Holger....@t-systems.com]

Hi,

 

I have problems installing OTRS on a Server using a NON LOKAL mysql installation.

For various reasons we decided to have a “centralized mysql Server”.

 

But,

even IF I enable remote root access (which normaly is a nogo) the web-installation breaks after Installation of the otrs database, as the otrs user is not installed for remote access by the otrs scripts!! (The fact, that I entered something different than

The installation stops, whining that the access is not permitted, and there is no chance of healing (e.g.: local “grant …” on the db by the user), instead the installation stops. So you have to start at the beginning, wich means, you have to drop the database.

 

Why isn’t it possible to have something like a “try again” button, which opens the possibility to heal certain installation-script bugs during installation. ??

 

Has anyone any suggestions or an Installation guide for a remote mysql-Server installation for me?

 

Bye,

Holger

 

--

Holger Patzelt

 

[Holger....@t-systems.com]

Hi,

 

I have problems installing OTRS on a Server using a NON LOKAL mysql installation.

For various reasons we decided to have a “centralized mysql Server”.

 

But,

even IF I enable remote root access (which normaly is a nogo) the web-installation breaks after Installation of the otrs database, as the otrs user is not installed for remote access by the otrs scripts!! (The fact, that I entered something different than the default 127.0.0.1 as db-host seems to be ignored by the installation scripts, when creating the user!!)

 

The installation stops, whining that the access is not permitted, and there is no chance of healing (e.g.: local “grant …” on the db by the user), instead the installation stops. So you have to start at the beginning, wich means, you have to drop the database.

 

Why isn’t it possible to have something like a “try again” button, which opens the possibility to heal certain installation-script bugs during installation. ??

 

Has anyone any suggestions or an Installation guide for a remote mysql-Server installation for me?

 

Bye,

Holger

 

 

PS.: Sorry in the first Post some Text got lost.

--

Holger Patzelt

 

[Rudolf Bargholz]

Hi Holger,

 

Why not create the DB on a local VM, then copy the DDL and execute the DDL of the OTRS database manually via console.

 

Regards

 

Rudolf Bargholz

[Leonardo Certuche]

Hello,

I believe that if you run installer.pl without creating previously the database and entering the root credentials, it will allow you to create the user, the database and its structure. The only downside of this approach is that you have to temporally grant access to root from the IP address of OTRS. You can remove this access once the installer has finished.

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

[Holger....@t-systems.com]

Hi Leonardo,

 

I will try this tomorrow (as I am about to leave for today…) thanks.

 

BTW.: I had to grant root remote access for the web Installation anyway, too.

Which I found irritating. I would prefer some SQL example(s) in the documentation to create the Db and the necessary user,

(best with minimum rights, not some “grant all”…) and then the rest via web-gui.

But still: the gui is unable to skip the db-, and User-creation Steps… ignoring the fact, that one might be on this path on the second run already.

 

Bye,

Holger

 

--

 

Holger Patzelt

 

[Leonardo Certuche]

Hello Holger,

The information that you hope exists! Go to /opt/otrs/scripts/database/ and there you'll find otrs-schema.mysql.sql, otrs-initial_insert.mysql.sql and otrs-schema-post.mysql.sql. Run them in that order and you'll have a funtional OTRS database. After that you'll need a

GRANT ALL PRIVILEGES ON `otrs`.* TO 'otrs'@'YOUR-OTRS-IP-ADDRESS' WITH GRANT OPTION

In order to run the installer without issues, you could temporary install mysql-server on your OTRS box, run the installer with local database and then edit the /opt/otrs/Kernel/Config.pm file to point it to your mysql server. Then run /opt/otrs/bin/otrs.CheckDB.pl to make sure all is set.

[Michiel Beijen]

Hi Holger,

I made some improvements to the web installer back in 2013; the feature to not need mysql ROOT permission is one of the features that got added. This has been part of OTRS since version 3.2 or 3.3.

In the Database Settings screen you can choose 'use an existing database for OTRS' and in that case you can use a user and database that has been already created by your DBA on your centralized database.

​There used to be an option to 'drop' a database from the web installer but this was both confusing to some users and dangerous.


Please let me know if this option works for you!

--

Michiel