Cron Email to Ticket Parsing not working

enclavelabs

Currently receiving this error when running "php cron_mail_queue.php {Cron key}" from the "/var/www/domainname" directory. It says script already running, but it doesn't seem to be generating tickets.

johnny

delete the lock file in /tmp and retry the script

it should be called itflow_somethingsomthing

enclavelabs

After deleting the file from /tmp, I receive the following error:

PHP Warning: iconv(): Wrong encoding, conversion from "UTF7-IMAP" to "UTF-8//IGNORE" is not allowed in /var/www/domain_name/plugins/php-imap/vendor/symfony/polyfill-mbstring/Mbstring.php on line 116

Error: No inbox folder found.PHP Warning: Undefined variable $messages in /var/www/domain_name/cron_ticket_email_parser.php on line 343

PHP Fatal error: Uncaught Error: Call to a member function count() on null in /var/www/domain_name/cron_ticket_email_parser.php:343

Stack trace:

#0 {main}

thrown in /var/www/domain_name/cron_ticket_email_parser.php on line 343

enclavelabs

Seems like there might be something wrong with the $messages variable in in the "cron_ticket_email_parser.php" file on line 343.

Also flagging from "UTF7-IMAP" to "UTF-8//IGNORE" in the plugins/php-imap/vendor/symfony/polyfill-mbstring/Mbstring.php on line 116.

ksguy

This is really killing me 🙁

I reinstalled on debian 12, set everything up like I had before

Was able to export / import many fields but not all of them.. seems a bit odd we can download a full backup but not import the backup.

Anyways.. I'm now on Debian 12, new install and my email isn't working

It worked great in April, that was the last time I messed with it.

I saw ticket emails weren't being picked up by the cron, updated and hasn't worked since

I was running ubuntu 22

Looking for advice.. also checking the "mail settings": shows IMAP connected successfully

Thanks

enclavelabs

ksguy So glad this isn't just me. I'm damn near about to pay 60 bucks for a month just to have some help getting this working. I really really LOVE the potential with IT flow, but the ticket generation is probably one of it's greatest strengths and if it isn't working, I have to do tickets via email and manually replicate them in the system.

johnny

Hello @ksguy and @enclavelabs can you please list your email provider and let us know what php version you are using

recently we updated the script from the builtin php mail parser to WEBKLEX PHP-IMAP for parsing ticket emails this is to allow future OAUTH2 Authentication in which Google and Microsoft use for auth

The new script looks for the following names when it comes to the inbox (INBOX, Inbox, inbox) Its possible yours may be different, please report that to us so we can include it in the search field for inbox names

The Parser is working fine for us with Exim / Dovecot IMAP for mail

johnny

Hey Everyone we just pushed out a possible fix. It may have been an encoding issues on certain mail servers.

Go ahead and update and assure your on at least php 8.2 and report back

itflow-org/itflowc27f9fd

enclavelabs

I currently use google with a passphrase for authentication. I can confirm I have IMAP enabled in Gmail and the IMAP test is working successfully. SMTP works fine with emails going out of ITflow, however email parsing doesn't seem to be working.

johnny

@enclavelabs

Did the update help?

Also if you updated please execute the cron mailer from the command line and report back any new error.

php cron_mail_queue.php {Cron key}

wrongecho

Is it worth just reverting back to the original PHP mail package at this point? This migration to allow Oauth has honestly been a complete clusterfuck :/

geotris

wrongecho I totally agree with you. i tried to upgrade my 22 ubuntu droplet to 24 and i end-up with a broken system. (Snapshot FTW 🙂 )
My proposal is to prepare documentation regarding upgrading only the php portion of a 22 system.
Also this incident is a good point to propose an import function for the DB.

just my 2 cents

George

johnny

@wrongecho I think were close as this is working for many users including myself. We will need this feedback to move forward as OAUTH2 is the most requested feature.

johnny

Hey @geotris

@athornfam2 has found a fix to just upgrade php to the latest version on ubuntu 22.04

see his post here for the fix

https://forum.itflow.org/d/954-composer/9

geotris

johnny Everything worked like a charm

thanks a mil 🙂

johnny

It would also be awesome to test google further if someone wants to setup a test account under their google workspaces and enable IMAP and passphrase, we can test further with Google Workspaces. It would deff take alot of the guess work out of troubleshooting

johnny

Fantastic @geotris

@enclavelabs We just did one more update to convert all UTF7 Encoding to UTF8 which I think Google uses and may further correct the mail parsing issue with Google. Please update once again and report back thanks

itflow-org/itflow6bdfe1b

enclavelabs

Well this is currently the error I'm having now after another complete reinstall on Ubuntu 24. I've enabled cron, enabled ticket-to-email parsing, I've set up smtp and imap, and authenticated with a passphrase for my gmail. Currently, when navigating to /var/www/domainname and runing "php cron_mail_queue.php {Cron key}" (using my cron key), I receive the following:

johnny

try this delete the lock file in /tmp/itflow-somethingsomething then rerun the script

enclavelabs

Sorry- forgot to mention I deleted that lock file as well. Still reporting that issue unfortunately.

« Previous Page Next Page »