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