Re: [otrs] OTRS with remote DB

2015-08-31 Thread 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

Von: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] Im Auftrag von 
holger.patz...@t-systems.com
Gesendet: Montag, 31. August 2015 17:20
An: otrs@otrs.org
Betreff: [otrs] OTRS with remote DB

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

-
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

Re: [otrs] OTRS with remote DB

2015-08-31 Thread 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.



On 31 August 2015 at 10:39, Rudolf Bargholz 
wrote:

> 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
>
>
>
> *Von:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *Im Auftrag
> von *holger.patz...@t-systems.com
> *Gesendet:* Montag, 31. August 2015 17:20
> *An:* otrs@otrs.org
> *Betreff:* [otrs] OTRS with remote DB
>
>
>
> 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
>
>
>
> -
> 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
>
-
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

Re: [otrs] OTRS with remote DB

2015-08-31 Thread Holger.Patzelt 
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

From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of 
Leonardo Certuche
Sent: Monday, August 31, 2015 5:53 PM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] OTRS with remote DB

Hello,

I believe that if you run installer.pl<http://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.



On 31 August 2015 at 10:39, Rudolf Bargholz 
<bargh...@onlinetravel.ch<mailto:bargh...@onlinetravel.ch>> wrote:
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

Von: otrs-boun...@otrs.org<mailto:otrs-boun...@otrs.org> 
[mailto:otrs-boun...@otrs.org<mailto:otrs-boun...@otrs.org>] Im Auftrag von 
holger.patz...@t-systems.com<mailto:holger.patz...@t-systems.com>
Gesendet: Montag, 31. August 2015 17:20
An: otrs@otrs.org<mailto:otrs@otrs.org>
Betreff: [otrs] OTRS with remote DB

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


-
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

-
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

Re: [otrs] OTRS with remote DB

2015-08-31 Thread 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.


On 31 August 2015 at 11:06, <holger.patz...@t-systems.com> wrote:

> 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
>
>
>
> *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf
> Of *Leonardo Certuche
> *Sent:* Monday, August 31, 2015 5:53 PM
> *To:* User questions and discussions about OTRS.
> *Subject:* Re: [otrs] OTRS with remote DB
>
>
>
> 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.
>
>
>
>
>
>
> On 31 August 2015 at 10:39, Rudolf Bargholz <bargh...@onlinetravel.ch>
> wrote:
>
> 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
>
>
>
> *Von:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *Im Auftrag
> von *holger.patz...@t-systems.com
> *Gesendet:* Montag, 31. August 2015 17:20
> *An:* otrs@otrs.org
> *Betreff:* [otrs] OTRS with remote DB
>
>
>
> 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
>
>
>
>
> -
> 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
>
>
>
> -
> 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
>
-
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