Remote configuration of MySQL

[fondofotrs]

hi,

is it possible to install mysql on remote system and access it from a system where we have OTRS and apache? has anybody done it? can someone share high level view or steps to configure OTRS with remote mysql ? i am referring to installing otrs for the first time by having its MySQL database installed remotely.

TIA.

[Wolfgangf]

sure you can!

look at your Config.pm and you'll find the parameters:

Code: Select all

$Self->{DatabaseHost} = 'localhost';
# Database
# (The database name.)
$Self->{Database} = 'otrs';
# DatabaseUser
# (The database user.)
$Self->{DatabaseUser} = 'otrs';
$Self->{DatabasePw} = 'some-pass';
# DatabaseDSN
# (The database DSN for MySQL ==> more: "man DBD::mysql")
$Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};"; 

[fondofotrs]

thanks a ton Wolfgangf. if i mention dataabase DSN, database name and host ip address for the below fields{DatabaseDSN}, {Database} and {DatabaseHost}, that should work. right?

$Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";

[Wolfgangf]

exactly!

I only change this four settings to my remote mySql database and it worked just find

$Self->{DatabaseHost} = 'localhost';
$Self->{Database} = 'otrs';
$Self->{DatabaseUser} = 'otrs';
$Self->{DatabasePw} = 'some-pass';

[fondofotrs]

Excellent. thank you. i think that otrs and apache can reside on one system while mysql can be separately installed on other system. am i right?

[Wolfgangf]

exactly

[fondofotrs]

initially, i was thinking to install otrs completely (including apache and mysql) on the same server, install a separate remote mysql server and then change it appropriately in config.pm. but now i am thinking that i can just untar the otrs on first server, install apache and then install mysql on remote server. after this change config.pm appropriately. this way, i don't need to install mysql twice. wolfgangf, can you let me know which method you had tried please?

[Wolfgangf]

you can do it like this:

Server 1: otrs + apache
Server 2: mySql

start the installation procedure; on the web-installer, take server 2 as database server (make sure server 1 has rights to access)

Myself, i splitted up database and apache after having OTRS running for 2 year, so i install Mysql on a seperate server, exported the database from server 1, imported in server2, made sure server1 can access mysql on server2 and changed Config.pm as stated earlier

[fondofotrs]

perfect, thanks a ton. i didn't realize of specifying server2 as database server while installing otrs db in the first instance.

[hariprasaadh]

I want the complete tutorials about mysql.can any one post it..

[MichaelR]

I want the complete tutorials about mysql.can any one post it..

Sure! They all can be found right here!

http://lmgtfy.com/?q=mysql+tutorials

[hariprasaadh]

thanks for your posting.i want to learn adobe flash.do you have any tutorials like this.