Xavier Fustero wrote: Hi Xavi,

...

...

bash] grep mysql Kernel/Config.pm # (The database DSN for MySQL ==> more: "man DBD::mysql") $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";

Or do you ask for the syntax of these settings?

I am asking for the syntax here. We have a dedicated mysql server. It is reachable from any host on our network. Every mysql instance runs on a different port number. My otrs server, has a local mysql which I setup to test otrs quickly. I tried to use our mysql server but I could not make it work. Played a little bit with the port variable on the above code but I didn't success. I prefer to use our mysql server instead of a local one. That's the question. Is anybody doing it? If yes, can it be done defining the port number where mysql runs? (because it is not on the default port). If someone knows how to do it, can you please help me on this bit of code? You mean something like code derived from this example snippet: dbi:DriverName:database=database_name;host=hostname;port=port

what would give "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};port=<yourport>"; or you define a variable $self->{DatabasePort} = '3306'; and use "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};port=$self->{DatabasePort}"; I do not yet have much experience with that, but concluded that after googling a bit.

Thanks in advance,

Hth

Xavi

Gerold

Xavier, One way around this problem that i use for remote mysql servers, would be to create an ssh tunnel from your otrs server to your mysql server. the command i use is : ssh username@mysqlserver -L 3306:localhost:mysqlportonserver that way i use the local otrs program without any changes to the mysql connection details, and changing the port that it uses on the mysql server is as simple as changing the bit after localhost in the ssh line. I know its not the best solution, but i use it to connect to remote mysql servers when there running on unsecured networks. Hope this may help (worst case its a temp fix to the problem!) Matt Xavier Fustero wrote ..

Thanks Gerold,

...

...

has someone configured otrs to use an external mysql server? I can only make it working with a local mysql server. I tried to play a little bit with the file Config.pm to add a port number but I didn't success. Is this possible?

from my experiences in an other case I remember that there was one thing to keep in mind was the connectivity of the mysql database itself, that is, it was not configured to be accessible from other places then localhost out of the box, which was debian in my case. So did you test a connection to the mysql database from your otrs machine (first without having OTRS involved)?

...

bash] grep mysql Kernel/Config.pm # (The database DSN for MySQL ==> more: "man DBD::mysql") $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";

Or do you ask for the syntax of these settings?

I am asking for the syntax here. We have a dedicated mysql server. It is reachable from any host on our network. Every mysql instance runs on a different port number. My otrs server, has a local mysql which I setup to test otrs quickly. I tried to use our mysql server but I could not make it work. Played a little bit with the port variable on the above code but I didn't success. I prefer to use our mysql server instead of a local one. That's the question. Is anybody doing it? If yes, can it be done defining the port number where mysql runs? (because it is not on the default port). If someone knows how to do it, can you please help me on this bit of code?

Thanks in advance, Xavi

...

_______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/

-- Xavier Fustero Benavent Work: +44(0)1223 494664 Systems Unix Administrator Fax: +44(0)1223 494468 EMBL-European Bioinformatics Institute (EBI). Wellcome Trust Genome Campus

_______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/

-- This message has been scanned for viruses and dangerous content by the www.ms.mlsis.co.uk MailScanner, and is believed to be clean. Please contact ms@ms.mlsis.co.uk for support.

-- This message has been scanned for viruses and dangerous content by the www.ms.mlsis.co.uk MailScanner, and is believed to be clean. Please contact ms@ms.mlsis.co.uk for support.