Re: [otrs] Storing of large/binary data in Non-MySQL databases

2015-05-07 Thread Christoph Zwerschke
Am 07.05.2015 um 18:17 schrieb David Boyes: > I also think you'll find that your backup load is much smaller with > attachments outside the database -- every time you change the > database, the whole file has to get dumped (unless you have a fairly > smart backup system and are doing table-level b

Re: [otrs] Storing of large/binary data in Non-MySQL databases

2015-05-07 Thread David Boyes
> LONGBLOBs are just streams of bytes. Intel or not (endianness) should not > matter when you fetch and store the data using database methods. > BLOBs are good for storing binary objects such as attachments or emails that > you want to keep in their original encoding. Everything else should be stor

Re: [otrs] wrong timezone in DATE email header, OTRS 4.0.7

2015-05-07 Thread Gerald Young
This is only for reference. Perhaps it might help. Kernel/System/Email.pm sends mail. https://github.com/OTRS/otrs/blob/rel-4_0/Kernel/System/Email.pm#L308 # add date header $Header{Date} = 'Date: ' . $Kernel::OM->Get(' Kernel::System::Time')->MailTimeStamp(); MailTimeStamp is defined here: https

Re: [otrs] Storing of large/binary data in Non-MySQL databases

2015-05-07 Thread Christoph Zwerschke
Am 07.05.2015 um 15:02 schrieb David Boyes: >> These are handled differently by OTRS - for >> databases other than MySQL, OTRS stores them in BASE64 encoding. The >> conversion can be done with Postgres using encode(column, 'base64'). > I'd rather see MySQL use base64 too. All the world isn't Int

Re: [otrs] wrong timezone in DATE email header, OTRS 4.0.7

2015-05-07 Thread Roman Ovchinnikov
Thank you Gerald! I've just checked several hours ago this idea about SMTP MTA is doing weird things, so I captured traffic (tcpdump on localhost, port 25) and I see that MTA is not problem here, see below cut of the dump in text viewable format by tcpflow, highlighted Date with red: 127.000.000.0

Re: [otrs] Storing of large/binary data in Non-MySQL databases

2015-05-07 Thread David Boyes
> These are handled differently by OTRS - for > databases other than MySQL, OTRS stores them in BASE64 encoding. The > conversion can be done with Postgres using encode(column, 'base64'). I'd rather see MySQL use base64 too. All the world isn't Intel-based, and at least base64 is not ambiguous wh

Re: [otrs] wrong timezone in DATE email header, OTRS 4.0.7

2015-05-07 Thread Gerald Young
This is more about your MTA/SMTP server than it is about OTRS. OTRS doesn't really do anything more than use mailing APIs to adjust offset. But yes, offset on "Date" is wrong, but 9:30 UTC= 12:30 UTC+3. https://www.google.com/search?q=smtp+header+utc+offset+date On Thu, May 7, 2015 at 4:40 AM, R

Re: [otrs] wrong timezone in DATE email header, OTRS 4.0.7

2015-05-07 Thread Roman Ovchinnikov
Hello! Any ideas about this? Ovchinnikov Roman, Paymantix Cell +7 (926) 262-40-05 | Email: r.ovchinni...@paymantix.com| Skype: rovchinnikov.mm On 30.04.2015 13:13, Roman Ovchinnikov wrote: > Hello! > Recently we have installed otrs 4.0.7 and found that emails being sent > from system has wrong t