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
