Verbindung zu Server Fehlgeschlagen

Hilfe zu Znuny Problemen aller Art
Locked
MarcoB106
Znuny newbie
Posts: 32
Joined: 14 Jan 2015, 12:20
Znuny Version: 3.3.10
Real Name: Marco
Company: DB

Verbindung zu Server Fehlgeschlagen

Post by MarcoB106 »

Hallo zusammen

und zwar habe ich seit kurzem keinen Zugriff mehr auf die Web Oberfläche von OTRS. Falls ich den Server mittels "Putty" neustarten möchte kommt folgende Fehlermeldung : Restarting web server: "apache2Action 'start' failed. The Apache error log may have more information. failed!".

Desweiteren taucht im Verzeichnis : /opt/otrs/var/log folgende Fehlermeldung auf:

DBD::mysql::st execute failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 639.
ERROR: OTRS-otrs.Scheduler-40 Perl: 5.14.2 OS: linux Time: Mon Feb 9 16:24:56 2015

Message: MySQL server has gone away, SQL: '
SELECT process_name, process_id, process_host, process_create, process_change
FROM process_id
WHERE process_name = ? LIMIT 1'

Traceback (4385):
Module: Kernel::System::PID::PIDGet (OTRS 3.3.10) Line: 181
Module: Kernel::Scheduler::_PIDChangedTimeUpdate (OTRS 3.3.10) Line: 337
Module: Kernel::Scheduler::Run (OTRS 3.3.10) Line: 127
Module: main::_Start (unknown version) Line: 501
Module: /opt/otrs/bin/otrs.Scheduler.pl (unknown version) Line: 161

Use of uninitialized value in addition (+) at /opt/otrs/Kernel/Scheduler.pm line 340.
DBD::mysql::st execute failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 639.
ERROR: OTRS-otrs.Scheduler-40 Perl: 5.14.2 OS: linux Time: Mon Feb 9 16:24:56 2015

Message: MySQL server has gone away, SQL: '
SELECT process_name, process_id, process_host, process_create, process_change
FROM process_id
WHERE process_name = ? LIMIT 1'

Traceback (4385):
Module: Kernel::System::PID::PIDGet (OTRS 3.3.10) Line: 181
Module: Kernel::System::PID::PIDUpdate (OTRS 3.3.10) Line: 274
Module: Kernel::Scheduler::_PIDChangedTimeUpdate (OTRS 3.3.10) Line: 348
Module: Kernel::Scheduler::Run (OTRS 3.3.10) Line: 127
Module: main::_Start (unknown version) Line: 501
Module: /opt/otrs/bin/otrs.Scheduler.pl (unknown version) Line: 161

ERROR: OTRS-otrs.Scheduler-40 Perl: 5.14.2 OS: linux Time: Mon Feb 9 16:24:56 2015

Message: Can not get PID

Traceback (4385):
Module: Kernel::System::PID::PIDUpdate (OTRS 3.3.10) Line: 277
Module: Kernel::Scheduler::_PIDChangedTimeUpdate (OTRS 3.3.10) Line: 348
Module: Kernel::Scheduler::Run (OTRS 3.3.10) Line: 127
Module: main::_Start (unknown version) Line: 501
Module: /opt/otrs/bin/otrs.Scheduler.pl (unknown version) Line: 161

ERROR: OTRS-otrs.Scheduler-40 Perl: 5.14.2 OS: linux Time: Mon Feb 9 16:24:56 2015

Message: Could not update PID

Traceback (4385):
Module: Kernel::Scheduler::_PIDChangedTimeUpdate (OTRS 3.3.10) Line: 352
Module: Kernel::Scheduler::Run (OTRS 3.3.10) Line: 127
Module: main::_Start (unknown version) Line: 501
Module: /opt/otrs/bin/otrs.Scheduler.pl (unknown version) Line: 161

DBD::mysql::st execute failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 639.
ERROR: OTRS-otrs.Scheduler-40 Perl: 5.14.2 OS: linux Time: Mon Feb 9 16:24:56 2015

Message: MySQL server has gone away, SQL: 'SELECT id, task_type, due_time FROM scheduler_task_list ORDER BY create_time, id ASC'

Traceback (4385):
Module: Kernel::System::Scheduler::TaskManager::TaskList (OTRS 3.3.10) Line: 295
Module: Kernel::Scheduler::Run (OTRS 3.3.10) Line: 130
Module: main::_Start (unknown version) Line: 501
Module: /opt/otrs/bin/otrs.Scheduler.pl (unknown version) Line: 161

DBD::mysql::st execute failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 639.
ERROR: OTRS-otrs.Scheduler-40 Perl: 5.14.2 OS: linux Time: Mon Feb 9 16:24:57 2015

Message: MySQL server has gone away, SQL: '
SELECT process_name, process_id, process_host, process_create, process_change
FROM process_id
WHERE process_name = ? LIMIT 1'

Traceback (4385):
Module: Kernel::System::PID::PIDGet (OTRS 3.3.10) Line: 181
Module: main::_Start (unknown version) Line: 445
Module: /opt/otrs/bin/otrs.Scheduler.pl (unknown version) Line: 161

DBI connect('database=otrs;host=127.0.0.1','otrs',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at /opt/otrs/Kernel/System/DB.pm line 252
ERROR: OTRS-otrs.Scheduler-40 Perl: 5.14.2 OS: linux Time: Mon Feb 9 16:24:57 2015

Message: Can't connect to MySQL server on '127.0.0.1' (111)

Traceback (4385):
Module: Kernel::System::DB::new (OTRS 3.3.10) Line: 223
Module: main::_CommonObjects (unknown version) Line: 199
Module: main::_AutoStop (unknown version) Line: 684
Module: main::_Start (unknown version) Line: 449
Module: /opt/otrs/bin/otrs.Scheduler.pl (unknown version) Line: 161

Got no DBObject! at /opt/otrs/Kernel/System/PID.pm line 76.



Ich hab OTRS 3.3.10 unter Debian 7.4. laufen.

Kann mir jemand bitte weiterhelfen?
Greetings

Marco

Im running OTRS::ITSM 3.3.10 on Debian 7.4.
wurzel
Znuny guru
Posts: 3273
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: Verbindung zu Server Fehlgeschlagen

Post by wurzel »

Hi,

das ist eher ein mysql Server issue.

Liegt oft an den max_allowed_packet in der my.cnf

wenn das zu klein ist, gibt's diese Fehler. Steht das bei Dir auf 1 MB?

Flo
OTRS 2025 SILVER (Prod)
OTRS 2025 auf Debian 12 (Test)
Znuny 7.x latest version testing auf Debian 12

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
MarcoB106
Znuny newbie
Posts: 32
Joined: 14 Jan 2015, 12:20
Znuny Version: 3.3.10
Real Name: Marco
Company: DB

Re: Verbindung zu Server Fehlgeschlagen

Post by MarcoB106 »

Hallo Flo

und danke für die schnelle Antwort!

In My.Cnf steht "16Mmax_allowed_packet = 25Mthread_stack"
Greetings

Marco

Im running OTRS::ITSM 3.3.10 on Debian 7.4.
MarcoB106
Znuny newbie
Posts: 32
Joined: 14 Jan 2015, 12:20
Znuny Version: 3.3.10
Real Name: Marco
Company: DB

Re: Verbindung zu Server Fehlgeschlagen

Post by MarcoB106 »

Habs!

Musste im Verzeichnis /etc/apache2/conf.d/otrs2

in Zeile 14

<IfModule mod_perl.c>

in


<IfModule mod_perl.so>

ändern.
Greetings

Marco

Im running OTRS::ITSM 3.3.10 on Debian 7.4.
Locked