max_size_packet error

Moderator: crythias

Locked
bharat
Znuny newbie
Posts: 16
Joined: 08 Jul 2015, 08:57
Znuny Version: 4.0.9
Real Name: dharmendra
Company: neso

max_size_packet error

Post by bharat »

Hi,
I am on centos 6.5 and mysql 5.5 version newly installed otrs.
I am running first time installer.pl and getting below error.(as attached)
even tough I have made changes in my.cnf file and restarted mysql multiple time but still getting same error msg.


regards
You do not have the required permissions to view the files attached to this post.
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: max_size_packet error

Post by RStraub »

You made them under [mysqld_safe].

You should make that entry under [mysqld] and [mysqldump].
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: max_size_packet error

Post by crythias »

also please don't double post.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
bharat
Znuny newbie
Posts: 16
Joined: 08 Jul 2015, 08:57
Znuny Version: 4.0.9
Real Name: dharmendra
Company: neso

Re: max_size_packet error

Post by bharat »

Hi,
After making below changes I am not able to start mysql services.
You do not have the required permissions to view the files attached to this post.
bharat
Znuny newbie
Posts: 16
Joined: 08 Jul 2015, 08:57
Znuny Version: 4.0.9
Real Name: dharmendra
Company: neso

Re: max_size_packet error

Post by bharat »

Thanks for info.
I have reached to the level to create new data base on installer.pl but when creating db is giving fatel error on web page.
bharat
Znuny newbie
Posts: 16
Joined: 08 Jul 2015, 08:57
Znuny Version: 4.0.9
Real Name: dharmendra
Company: neso

Re: max_size_packet error

Post by bharat »

Hi,
when creating new db giving below error message in log file.

Jul 24 17:03:04 serverotrs OTRS-CGI-10[23861]: [Error][Kernel::System::Main::FileWrite][Line:462]: Can't write '/opt/otrs/var/tmp/CacheFileStorable/TemplateProvider/a/a/aadb6ccb58003cb7b49aebdca0fb5d76': Permission denied
Jul 24 17:03:04 serverotrs OTRS-CGI-10[23861]: [Error][Kernel::System::Main::FileWrite][Line:462]: Can't write '/opt/otrs/var/tmp/CacheFileStorable/TemplateProvider/6/9/69e89ef02158dc4941467d492c3a699a': Permission denied
Jul 24 17:03:27 serverotrs OTRS-CGI-10[23865]: [Error][Kernel::System::Main::FileWrite][Line:462]: Can't write '/opt/otrs/var/tmp/CacheFileStorable/TemplateProvider/a/d/addd25729fae0e029550475b30b0a587': Permission denied
Jul 24 17:03:27 serverotrs OTRS-CGI-10[23865]: [Error][Kernel::System::Main::FileWrite][Line:462]: Can't write '/opt/otrs/var/tmp/CacheFileStorable/TemplateProvider/6/2/62dfe6a179a6d7712f7535c6f3c8fca3': Permission denied
Jul 24 17:03:27 serverotrs OTRS-CGI-10[23865]: [Error][Kernel::System::Main::FileWrite][Line:462]: Can't write '/opt/otrs/var/tmp/CacheFileStorable/TemplateProvider/0/9/09c41b902419cd44856b6c98e8e02e66': Permission denied
Jul 24 17:03:27 serverotrs OTRS-CGI-10[23865]: [Error][Kernel::Output::HTML::LayoutTemplate::Output][Line:196]: mkdir /opt/otrs/var/tmp/CacheFileStorable/TemplateProvider/d: Permission denied at /opt/otrs/bin/cgi-bin/../../Kernel/System/Cache/FileStorable.pm line 88
Jul 24 17:03:27 serverotrs OTRS-CGI-10[23865]: [Error][Kernel::Output::HTML::LayoutTemplate::Output][Line:196]: mkdir /opt/otrs/var/tmp/CacheFileStorable/TemplateProvider/f: Permission denied at /opt/otrs/bin/cgi-bin/../../Kernel/System/Cache/FileStorable.pm line 88
Jul 24 17:03:27 serverotrs OTRS-CGI-10[23865]: [Error][Kernel::System::Main::FileWrite][Line:462]: Can't write '/opt/otrs/var/tmp/CacheFileStorable/TemplateProvider/6/9/69e89ef02158dc4941467d492c3a699a': Permission denied
pls suggest.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: max_size_packet error

Post by crythias »

Fix the permissions.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked