Hi, see this lists for answers on your mysql-question. I think you have to increase max_allowed_packet within /etc/my.cfg, but see the mysql-docs for details. Bye, Alex Varsani, Rajendrakumar (PSD) schrieb:

OK I worked out how to increase the limits in OTRS by utilising the following chat contents:

# PostMasterPOP3MaxSize # (max. email size) $Self->{PostMasterPOP3MaxEmailSize} = 1024 * 12;

But now I seem have reached the limits of the defaults in MySQL. How do I permenantly set the limit of max_allowed_packet to be larger?

Thu Jun 22 15:50:38 2006 error OTRS-PM3-10 Got a packet bigger than 'max_allowed_packet', SQL: 'INSERT INTO article_attachment (article_id, filename, content_type, content, create_time, create_by, change_time, change_by) VALUES (33135, 'RAM FAA2v4.104.pdf', 'application/octet -stream\; name="RAM FAA2v4.104.pdf"', '%PDF-1.3

Thanks again!

======================================================================== =====

I'm very confused. Some things get through that are 9Mb or so big but when I send an item that is 5Mb I get this in the system log and OTRS refuses to collect it:

Thu Jun 22 14:56:02 2006 error OTRS-PM3-10 Can't fetch email 3 from OTRSHelp@exchange. Email to big (8032 KB - max 6144 KB)!

Any help appreciated

Rajendrakumar Varsani Tel: 01904 455805 Department for Environment, Food and Rural Affairs (Defra)

This email and any attachments is intended for the named recipient only. If you have received it in error you have no authority to use, disclose, store or copy any of its contents and you should destroy it and inform the sender. Whilst this email and associated attachments will have been checked for known viruses whilst within Defra systems we can accept no responsibility once it has left our systems. Communications on Defra's computer systems may be monitored and/or recorded to secure the effective operation of the system and for other lawful purposes. _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? =http://www.otrs.com/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? =http://www.otrs.com/

Silly question I'm sure but other than off the admin menu, how I get to see the system log? I'm sue it'll be in a log file somewhere. Thanks in advance Department for Environment, Food and Rural Affairs (Defra) This email and any attachments is intended for the named recipient only. If you have received it in error you have no authority to use, disclose, store or copy any of its contents and you should destroy it and inform the sender. Whilst this email and associated attachments will have been checked for known viruses whilst within Defra systems we can accept no responsibility once it has left our systems. Communications on Defra's computer systems may be monitored and/or recorded to secure the effective operation of the system and for other lawful purposes.

Hello. How did you get it to work? In the user interface, I changed "Config Options: Framework -> Core::Log" from 'LogModule: Syslog' to 'LogModule: File' and kept the default file location as 'LogModule::LogFile: /tmp/otrs.log' and the file was not created. The checks in the checkboxes are grayed out. I want to be able to view the log via both the interface AND store the data in the file. Any suggestions to get it to work? Thanks. ===================================

From: Bipin Reply-To: "User questions and discussions about OTRS.org" To: "User questions and discussions about OTRS.org" Subject: Re: [otrs] Where do I find the system log? Date: Tue, 11 Jul 2006 22:31:56 +0530

Hi

Login as root user in to the system

tail -f /var/log/messages (Only work with Unix based systems. I tried it on trustix 2.2)

regards

-- ___________________________ Bipin Das Linux Administrator, Spectrum Softtech Solutions, Mahakavi G Road,Cochin-682011. Phone 0484 4082000. www.spectrum.net.in www.spectramedi.com

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/

Thanks for your reply. I have 'write' permissions on the folder; enough that the file, 'Kernel-System-Stats-StateAction-2006-06.cache' was able to write to it a few days ago. For the SysLog file in SysConfig, I have '/tmp/otrs.log' as the LogFile name (using the default) which I'm ASSUMING that this implies that this folder is located in the 'var' subdirectory. As another attempt, I manually created the 'otrs.log' file with 777 and placed it in '/tmp/otrs.log' (which is contained in 'var') subdir. I logged in then out of a test account in order to generate a line entry in the log. The 'System Log' on the web interface was updated, but nothing was written to the 'otrs.log' file I created. Any ideas? Thanks.

That did it! I used the full path '/usr/.../otrs/var/tmp/otrs.log' and now the file has been created by the system (prior to this last test, I deleted the file I manually created) and is being updated with each syslog entry! Thanks, Andy! ========================================

From: Andy Lubel Reply-To: "User questions and discussions about OTRS.org" To: "User questions and discussions about OTRS.org" Subject: Re: [otrs] Where do I find the system log? Date: Tue, 11 Jul 2006 15:35:04 -0400

If its entered as /tmp/otrs.log then its going to the root, not relative to where its called from.. If you wanted that relative then you want tmp/otrs.log. Mine is set to /opt/otrs/tmp/otrs.log but would also work if I did tmp/otrs.log (because /opt/otrs is my home directory and considered the root of the application)

In other words if you put '/' at the beginning its like going to the root of the drive.

HTH,

Andy

On 7/11/06 3:12 PM, "s taylor" wrote:

...

Thanks for your reply.

I have 'write' permissions on the folder; enough that the file, 'Kernel-System-Stats-StateAction-2006-06.cache' was able to write to it a few days ago.

For the SysLog file in SysConfig, I have '/tmp/otrs.log' as the LogFile name (using the default) which I'm ASSUMING that this implies that this folder is located in the 'var' subdirectory.

As another attempt, I manually created the 'otrs.log' file with 777 and placed it in '/tmp/otrs.log' (which is contained in 'var') subdir. I logged in then out of a test account in order to generate a line entry in the log. The 'System Log' on the web interface was updated, but nothing was written to the 'otrs.log' file I created.

Any ideas?

Thanks.

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/

--

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/

See Bug# 1231 for attachment and comments. HTH. =============================

From: Andy Lubel Reply-To: "User questions and discussions about OTRS.org" To: "User questions and discussions about OTRS.org" Subject: [otrs] Uh oh! /opt/otrs/Kernel/System/DB.pm line 219 Date: Tue, 11 Jul 2006 17:51:43 -0400

What is the correct fix for this? I have a couple other systems but my management has asked for mysql5 testing. Is there a bug with DBI or the interaction of this perl script with mysql5?

DBI::db=HASH(0x1a8a56c)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /opt/otrs/Kernel/System/DB.pm line 219, <DATA> line 225.

OTRS 2.0.4 (tarball) Mysql 5.0.22 (binary from mysql.com) Mac OSX 10.4.7 SERVER Fink (Latest) Developer Tools (latest)

Any help would be great!

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/