Znuny and ((OTRS)) Community Edition

Sorry, yes, of course: Message: Data too long for column 'subject' at row 1, SQL: ' INSERT INTO smime_keys (key_hash, key_type, file_name, email_address, expiration_date, fingerprint, subject, create_time, create_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)' We are using MariaDB.

Hi all, after Upgrade to znuny 6.4. certificates were not visible in znuny S/MIME Management. This is solved by running ReindexSMIMECertificates (done also every night automatically). But this ran on an error for one certificate: Message: Data too long for column 'subject' at row 1, SQL: ' This was ...

Dear kivide,
thanks for your investigations! And Johannes, thanks for the confirmation!
Just fyi, from console I didn't saw any errors.
I now copied the 6.2.2-MailAccountFetch.pm to the custom folder and switched again to letting the Deamon run the command. Works fine!
Thanks to all of you!
Stefanie

Hi all, I had a maintenance today, tried to switch to LogModule "File", but this did not work as expected, did not saw any messages. I had not much time to investigate that further and switched back to syslog (errors are logged correctly in /var/log/messages). I was a little frightend that...

@TMS may I ask what mailserver is on the other end?

It's our central campus mailserver, afaik a microsoft exchange server, we access it via imaps.

Thanks,
Stefanie

The code differs because your link points to the dev-branch, in the branch 6.3 you find our code: https://github.com/znuny/Znuny/blob/rel-6_3/Kernel/System/Daemon/DaemonModules/SchedulerTaskWorker/Cron.pm . I understood the traceback in the way, that there the error was handled, e.g. in Cron.pm it's...

are you able to switch temporarily from syslog to file based to test if the syslog maybe the issue? I could try it during next maintenance. To be honest I don't think that this is the problem, we are running it via syslog for years now and the error occured after switch to the new znuny release, no...

We have SysLog defined for LogModule, so it's not writing to a dedicated file, but using the syslog daemon. Error messages are written to /var/log/messages, and there I also find the error messages like ... OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-10[72917]: [Error][Kernel::System::D...

Thanks a lot for your proposal!
As a pity, this is not the case for us, we already have PostMasterMaxEmailSize configured and are monitoring if there is a mail which is still too big. There is no big email leftover on one of the connected mail accounts.
Thanks and best,
Stefanie

Hi,
I still have no idea how to investigate this further.
I saw that version 6.3.1 was a feature release thich introduced OAuth authentication for e-mail accounts. We don't use OAuth, but obviously something was done on mailing interfaces. But also not sure if this is related..
Best regards,
Stefanie

Further remark: before upgrading to 6.3.1 we sometimes got "Error: Timeout of 600 seconds reached, killing child process!". In this cases emails indeed were not fetched. I did investigations on this about two years ago and didn't found a proper solution. But as emails were read fine in the...

Glad to find this here, I was just about to open the same ticket. We encountered the same problem since we upgraded from znuny 6.2.2 to 6.3.1. It's hard to investigate as we don't find details on the error. --debug works fine when executing the MailAccountFetch from the command line (but in my tests...