Mysql settings for attachments

Hello, I want to add a standart attachment. When I click the stor button nothing happens, and there is no entry in my database. From the error_log I understand that maybe my pdf is larger than my database allows. Where can I adjust this setting ? Thanx Christoph

Hello, all done, I found the max_allowed_package by my own. I was to fix :-) Christoph Christoph Kaulich wrote:
Hello,
I want to add a standart attachment. When I click the stor button nothing happens, and there is no entry in my database.
From the error_log I understand that maybe my pdf is larger than my database allows. Where can I adjust this setting ?
Thanx
Christoph
_______________________________________________ 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

Hello Christoph, Where is that max_allowed_package ? Daniel Balan -----Original Message----- From: Christoph Kaulich otrs@otrs.org Sent: Tuesday, April 15, 2003, 5:24:23 PM, Christoph Kaulich> Hello, Christoph Kaulich> all done, I found the max_allowed_package by my own. I was to fix :-) Christoph Kaulich> Christoph Christoph Kaulich> Christoph Kaulich wrote:
Hello,
I want to add a standart attachment. When I click the stor button nothing happens, and there is no entry in my database.
From the error_log I understand that maybe my pdf is larger than my database allows. Where can I adjust this setting ?
Thanx
Christoph
_______________________________________________ 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
Christoph Kaulich> _______________________________________________ Christoph Kaulich> OTRS mailing list: otrs - Webpage: http://otrs.org/ Christoph Kaulich> Archive: http://lists.otrs.org/pipermail/otrs Christoph Kaulich> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Hi, it is set in /etc/my.cnf as a startup value of mysql. You can see it using SHOW VARIABLES; inside MySQL. Bye Christoph Daniel Balan wrote:
Hello Christoph,
Where is that max_allowed_package ?
Daniel Balan
-----Original Message----- From: Christoph Kaulich otrs@otrs.org Sent: Tuesday, April 15, 2003, 5:24:23 PM,
Christoph Kaulich> Hello,
Christoph Kaulich> all done, I found the max_allowed_package by my own. I was to fix :-)
Christoph Kaulich> Christoph
Christoph Kaulich> Christoph Kaulich wrote:
Hello,
I want to add a standart attachment. When I click the stor button nothing happens, and there is no entry in my database.
From the error_log I understand that maybe my pdf is larger than my database allows. Where can I adjust this setting ?
Thanx
Christoph
_______________________________________________ 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
Christoph Kaulich> _______________________________________________ Christoph Kaulich> OTRS mailing list: otrs - Webpage: http://otrs.org/ Christoph Kaulich> Archive: http://lists.otrs.org/pipermail/otrs Christoph Kaulich> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
_______________________________________________ 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

Hi, just a note about about the 'attachments' discussion. If your system will have a heavy load of big attachments (> 6 MB), it would be better to use the ticket filesystem storage module (attachments not in the database). For pro and contra see "TicketStorageModule" at http://otrs.org/pages/index.pl?Action=Ext&Site=Docu-CVS/performance-tuning.h... Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972

Hi, I do have TicketStorageModule = 'Kernel::System::Ticket::ArticleStorageFS' but if I try to install a attachment in the Admin Area, I need to reszie the 'max_allowed_package'. Are standart attachments stored in the database for both possibilties of TicketStorageModule ? I am using 1.0.2 in the moment. Bye Christoph Martin Edenhofer wrote:
Hi,
just a note about about the 'attachments' discussion.
If your system will have a heavy load of big attachments (> 6 MB), it would be better to use the ticket filesystem storage module (attachments not in the database).
For pro and contra see "TicketStorageModule" at http://otrs.org/pages/index.pl?Action=Ext&Site=Docu-CVS/performance-tuning.h...
Martin
-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972
_______________________________________________ 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

Hi Christoph, On Thu, Apr 17, 2003 at 08:38:01AM +0200, Christoph Kaulich wrote:
I do have
TicketStorageModule = 'Kernel::System::Ticket::ArticleStorageFS'
but if I try to install a attachment in the Admin Area, I need to reszie the 'max_allowed_package'.
Are standart attachments stored in the database for both possibilties of TicketStorageModule ?
I am using 1.0.2 in the moment.
Ohh! Yes. :) In OTRS 1.0 and OTRS 1.1. Sorry.
Bye Christoph
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Perfection is our goal, excellence will be tolerated. -- J. Yahl
participants (3)
-
Christoph Kaulich
-
Daniel Balan
-
Martin Edenhofer