OTRS::Core::Error! Please help

Ho everybody, OTRS is broken and i have to repair quickly for my user... and it is very bizarre ! intranet.sales.com http://intranet.sales.com is my intranet and otrs was working great on it Today apache has crash and i repair it but now OTRS do not work and in the error it is about intranet.marketing.com http://intranet.marketing.comthat is not mine but on my company network. i do not understand how otrs find this address ! Can anyone halp me ? thanks. Nicolas Error: Host 'intranet.marketing.com http://intranet.marketing.com' is not allowed to connect to this MySQL server Comment: Please contact your admin Bug Report: Traceback: ERROR: OTRS-CGI-10 Perl: 5.8.0 OS: linux Time: Wed Jul 27 19:20:37 2005 Message: Host 'intranet.marketing.com http://intranet.marketing.com' is not allowed to connect to this MySQL server Traceback (3516): Module: Kernel::System::DB::new (v1.40) Line: 222 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 124 Module: (eval) (v1.73) Line: 184 Module: ModPerl::RegistryCooker::run (v1.73) Line: 184 Module: ModPerl::RegistryCooker::default_handler (v1.73) Line: 154 Module: ModPerl::Registry::handler (v1.99) Line: 16 I launch CheckDB.pl and i have DBI connect('database=otrs;host=intranet.sales.comhttp://intranet.sales.com;','root',...) failed: Host 'intranet.marketing.com http://intranet.marketing.com' is not allowed to connect to this MySQL server at /opt/otrs/Kernel/System/DB.pm line 245 ERROR: OTRS-CheckDB-10 Perl: 5.8.0 OS: linux Time: Wed Jul 27 20:19:17 2005 Message: Host 'intranet.marketing.com http://intranet.marketing.com' is not allowed to connect to this MySQL server Traceback (3837): Module: Kernel::System::DB::new (v1.40) Line: 222 Module: ./CheckDB.pl (v1.11) Line: 47 No database connect! DB.pm line 245 is : # db connect if (!($Self->{dbh} = DBI->connect("$Self->{DSN}", $Self->{USER}, $Self->{PW}, $Self->{'DB::Attribute'}))) { what can be wrong ? a con file ? i did not find....

On 27 Jul 2005 at 20:36, Nicolas Motte wrote:
I launch CheckDB.pl and i have
DBI connect('database=otrs;host=intranet.sales.com;','root',...) failed: Host 'intranet.marketing.com' is not allowed to connect to this MySQL server at /opt/otrs/Kernel/System/DB.pm line 245 ERROR: OTRS-CheckDB-10 Perl: 5.8.0 OS: linux Time: Wed Jul 27 20:19:17 2005
Message: Host 'intranet.marketing.com' is not allowed to connect to this MySQL server
No database connect!
This sounds as MySQL permissions. MySQL uses a user:host permission scheme, and after the repair it seems that your OTRS is trying to connect using a different IP or interface to your DB server. In $OTRSHOME/Kernel/Config.pm chech for your database settings, specially the IP address OTRS it's connecting to. Then check for the correct permissions in MySQL: http://dev.mysql.com/doc/mysql/en/adding-users.html Hope this helps! --- Victor R. Rodriguez Departamento de Sistemas Valoraciones del Mediterraneo, S.A. ---
participants (2)
-
Nicolas Motte
-
Victor Rodriguez Cortes