[otrs] About database location

[teebot at gsmserver.com]

Nils Breunese (Lemonbit) ?????:
> teebot at gsmserver.com wrote:
>
>> The problem is that if database is located on the same server as OTRS 
>> base system it works fine but when i move database to another server 
>> - OTRS shows following error: "Panic! No user data!"
>> Be sure that I have changed setting in my Config.pm file
>> What is the problem with this?
>> And one more detail. If i am connecting with mysql -h my_db_host -u 
>> otrs -p otrs everything works fine i can execute any SQL queries. 
>> Connection is rapid and reliable
>>
>> I will be grateful for your help.
>
> Have you restarted apache after changing our config (important if 
> you're using mod_perl)? If so, then it looks like there is an error in 
> your Config.pm. Could you post the relevant lines? Is the remote 
> database a copy of the former local database?
>
> Nils Breunese.
1) I am not using mod_perl.

2) Here is my Config.pm

package Kernel::Config;

sub Load {
my $Self = shift;

$Self->{'DatabaseHost'} = 'IP_of_database_host';
$Self->{'Database'} = 'otrs';
$Self->{'DatabaseUser'} = 'otrs';
$Self->{'DatabasePw'} = 'db_user_password';
$Self->{DatabaseDSN} = 
"DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";

$Self->{Home} = '/opt/otrs';
$Self->{'SystemID'} = 10;
$Self->{'SecureMode'} = 1;
$Self->{'Organization'} = 'Name_of_my_organozation';
$Self->{'LogModule::LogFile'} = '/var/log/otrs.log';
$Self->{'LogModule'} = 'Kernel::System::Log::SysLog';
$Self->{'FQDN'} = 'www.mydomain.com';
$Self->{'DefaultLanguage'} = 'en';
$Self->{'DefaultCharset'} = 'cp1251';
$Self->{'AdminEmail'} = 'admin at mydomain.com';

$Self->{'CustomerGroupSupport'} = '1';
$Self->{'CustomerGroupAlwaysGroups'} = ['test','test1'];
$Self->{'SwitchToUser'} = '1';
$Self->{'AttachmentDownloadType'} = 'inline';
$Self->{'PostMasterPOP3MaxEmailSize'} = '8000000';
}

use strict;
use vars qw(@ISA $VERSION);
use Kernel::Config::Defaults;
push (@ISA, 'Kernel::Config::Defaults');
$VERSION = '$Revision: 1.18 $';
$VERSION =~ s/^\$.*:\W(.*)\W.+?$/$1/;

1;


3) Yes, database is a copy of local database.