id verloren / cant connect to mysql?

Hilfe zu Znuny Problemen aller Art
Locked
nohow
Znuny newbie
Posts: 4
Joined: 10 Aug 2012, 09:45
Znuny Version: 3.0.0

id verloren / cant connect to mysql?

Post by nohow »

hallo

wieder mein "geerbtes" otrs... nichts wurde geändert oder gemacht (am system)
seit heute gibts massig diese fehler..
[Wed Aug 22 14:04:13 2012] -e: DBI connect('otrs','otrs_production',...) failed: Access denied for user 'otrs_production'@'localhost' <- mysql auf der cli ausprobiert mit den pwd/id gehts! ich weis nicht wieso er sagt access denied. ein "show processlist" zeigt auch eingeloggte user...

und was hat das mit "need ticket number / need ticket id" auf sich?

für jegliche erleuchtung bin ich dankbar.
n kleiner auszug aus dem log...


[Wed Aug 22 12:22:04 2012] -e: Use of uninitialized value in print at /opt/otrs//Kernel/System/Main.pm line 473.
[Wed Aug 22 12:43:15 2012] -e: cannot remove directory for /otrs/article/2012/08/22/check_permissions.24818: No such file or directory at /opt/otrs//Kernel/System/Ticket/ArticleStorageFS.pm line 46
ERROR: OTRS-CGI-99 Perl: 5.10.1 OS: linux Time: Wed Aug 22 12:47:15 2012

Message: Got no SessionID!!

Traceback (24818):
Module: Kernel::System::AuthSession::FS::CheckSessionID (v1.43) Line: 49
Module: Kernel::System::AuthSession::CheckSessionID (v1.45) Line: 118
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 360
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46
Module: (eval) (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::run (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.89.2.1) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

[Wed Aug 22 13:08:59 2012] -e: Use of uninitialized value in print at /opt/otrs//Kernel/System/Main.pm line 473.
[Wed Aug 22 13:32:07 2012] [error] [client 10.234.189.50] File does not exist: /var/www/favicon.ico
[Wed Aug 22 14:02:26 2012] [error] [client 10.234.189.50] File does not exist: /var/www/favicon.ico
[Wed Aug 22 14:04:13 2012] -e: DBI connect('otrs','otrs_production',...) failed: Access denied for user 'otrs_production'@'localhost' (using password: YES) at /opt/otrs/Kernel/cpan-lib/Apache/DBI.pm line 233
SV = PV(0x7f12e6943528) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
SV = PV(0x7f12e6943528) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
SV = PV(0x7f12e6943528) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
SV = PV(0x7f12e6943528) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
SV = PV(0x7f12e6957a48) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
SV = PV(0x7f12e6943528) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
SV = PV(0x7f12e6957a48) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
SV = PV(0x7f12e6957a48) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
SV = PV(0x7f12e6957a48) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
SV = PV(0x7f12e6943528) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
SV = PV(0x7f12e6943528) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
SV = PV(0x7f12e6943528) at 0x7f12e692aeb8
REFCNT = 2
FLAGS = ()
PV = 0
[Wed Aug 22 14:18:52 2012] [warn] child process 3325 still did not exit, sending a SIGTERM
[Wed Aug 22 14:18:54 2012] [warn] child process 3325 still did not exit, sending a SIGTERM
[Wed Aug 22 14:18:56 2012] [warn] child process 3325 still did not exit, sending a SIGTERM
[Wed Aug 22 14:18:58 2012] [error] child process 3325 still did not exit, sending a SIGKILL
[Wed Aug 22 14:18:59 2012] [notice] caught SIGTERM, shutting down
[Wed Aug 22 14:19:03 2012] -e: DBI connect('otrs','otrs_production',...) failed: Access denied for user 'otrs_production'@'localhost' (using password: YES) at /opt/otrs/Kernel/cpan-lib/Apache/DBI.pm line 233
[Wed Aug 22 14:19:03 2012] [notice] Apache/2.2.16 (Ubuntu) mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Wed Aug 22 14:19:03 2012] -e: DBI connect('otrs','otrs_production',...) failed: Access denied for user 'otrs_production'@'localhost' (using password: YES) at /opt/otrs/Kernel/cpan-lib/Apache/DBI.pm line 233
[Wed Aug 22 14:19:03 2012] [error] [Wed Aug 22 14:19:03 2012] -e: Error: Can't create /otrs/article/check_permissions_7601: File exists \n[Wed Aug 22 14:19:03 2012] -e: \n[Wed Aug 22 14:19:03 2012] -e: Try: $OTRS_HOME/bin/otrs.SetPermissions.pl !!!\n
ERROR: OTRS-CGI-99 Perl: 5.10.1 OS: linux Time: Wed Aug 22 14:20:57 2012

Message: No article found for TicketID 242396!

Traceback (7629):
Module: Kernel::System::Ticket::Article::ArticleLastCustomerArticle (v1.274) Line: 1166
Module: Kernel::Output::HTML::TicketOverviewSmall::Run (v1.37) Line: 137
Module: Kernel::Output::HTML::LayoutTicket::TicketListShow (v1.123.2.3) Line: 1372
Module: Kernel::Modules::AgentTicketLockedView::Run (v1.15) Line: 209
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46
Module: (eval) (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::run (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.89.2.1) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-99 Perl: 5.10.1 OS: linux Time: Wed Aug 22 14:20:57 2012

Message: Need TicketNumber!

Traceback (7629):
Module: Kernel::System::Ticket::TicketSubjectClean (v1.488.2.6) Line: 827
Module: Kernel::Output::HTML::TicketOverviewSmall::Run (v1.37) Line: 142
Module: Kernel::Output::HTML::LayoutTicket::TicketListShow (v1.123.2.3) Line: 1372
Module: Kernel::Modules::AgentTicketLockedView::Run (v1.15) Line: 209
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46
Module: (eval) (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::run (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.89.2.1) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-99 Perl: 5.10.1 OS: linux Time: Wed Aug 22 14:20:57 2012

Message: Need TicketID!

Traceback (7629):
Module: Kernel::System::Ticket::TicketPermission (v1.488.2.6) Line: 3203
Module: Kernel::Output::HTML::TicketMenuLock::Run (v1.18) Line: 51
Module: Kernel::Output::HTML::TicketOverviewSmall::Run (v1.37) Line: 179
Module: Kernel::Output::HTML::LayoutTicket::TicketListShow (v1.123.2.3) Line: 1372
Module: Kernel::Modules::AgentTicketLockedView::Run (v1.15) Line: 209
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46
Module: (eval) (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::run (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.89.2.1) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-99 Perl: 5.10.1 OS: linux Time: Wed Aug 22 14:20:57 2012

Message: Need TicketID!

Traceback (7629):
Module: Kernel::System::Ticket::TicketPermission (v1.488.2.6) Line: 3203
Module: Kernel::Output::HTML::TicketMenuGeneric::Run (v1.15) Line: 54
Module: Kernel::Output::HTML::TicketOverviewSmall::Run (v1.37) Line: 179
Module: Kernel::Output::HTML::LayoutTicket::TicketListShow (v1.123.2.3) Line: 1372
Module: Kernel::Modules::AgentTicketLockedView::Run (v1.15) Line: 209
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46
Module: (eval) (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::run (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.89.2.1) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-99 Perl: 5.10.1 OS: linux Time: Wed Aug 22 14:20:57 2012
oleole
Znuny advanced
Posts: 148
Joined: 08 Jun 2012, 10:19
Znuny Version: 4.0.x

Re: id verloren / cant connect to mysql?

Post by oleole »

Hatte auch mal so was ähnliches.

Im Errorlog steht das hier: Try: $OTRS_HOME/bin/otrs.SetPermissions.pl !!!\n
Und Access denied lässt daraufhin schliessen dass der otrs-user wohl hier keine benötigten Rechte hat. Ich würd mal die SetPermissions.pl neu starten.
Produktiv: OTRS 4.0.X | Ubuntu 12.04.2 | Apache2 | MySQL 5.5 | KIX4OTRS
Locked