Cron Email to Ticket Parsing not working

johnny

ah okay, lemme do some more testing on the Install Script. We do recommend that you use Debian 12 or Ubuntu 24.04 so you have the latest php which should be 8.2 or above

enclavelabs

Oh dang, that must be my misunderstanding then. I did find that information regarding issues with mail parsing on Ubuntu 24 in my troubleshooting process, but I also saw in the install script instructions that it lists Ubuntu 22 as a requirement. Because of this, I thought it may actually be better than using Ubuntu 24. If you recommend Ubuntu 24 instead, I can certainly nuke the VM and use that instead. If I could just get ticket parsing working man I'd be golden!

johnny

I can replicate your issue to a T on a new install and getting the same error, This all seems to happened when we switched from mail-parse to to Webklex PHP-IMAP so we could get OAUTH2 Support. Before you go further let me troubleshoot on my end and update the docs, scripts to reflect these changes better

johnny

This looks like a known bug on Ubuntu 24.04

https://bugs.launchpad.net/ubuntu/+source/php-mailparse/+bug/2067365

Im going to try the install on debian 12

johnny

Hey I got an update, everything totally works awesome with debian 12. Ubuntu 24.04 has a bug with mailparse ubuntu 22.04 has an old version of PHP and PHP 8.2 and above is required. Im going to update the script and docs to to reflect we only support Debian 12 at the moment

Bigbug

johnny I'm running it on Debian 12 and have no issues
I prefer Debian over Ubuntu as the Debian OS itself doesn't eat so much resources as Ubuntu

but that's just my personal preference…

enclavelabs

Understood and seriously, THANK YOU SO MUCH for your continued investigation into this issue. It's really easy to be an angry end-user about problems like these, but it's just as easy to blow someone off angry or not. I love what you guys are doing with itflow and I appreciate that you make this available for free. While I would prefer I could use something like this with Ubuntu, it's really only because I've never worked in Debian so I'm sure it doesn't really matter.

I'll download a debian 12 server image and try installing that on a new VM then report back. THANK YOU THANK YOU THANK YOU!!!

johnny

@enclavelabs Your super welcome!! I'm glad you really like ITFlow! =]

And yes we just updated the documentation to remove references of Ubuntu and updated the script to only allow Debian 12 for now. Maybe it will be fixed in Ubuntu 24.04.1 who knows.

Ubuntu and Debian are pretty much one in the same so it should be an easy transition, in fact Ubuntu is based off of Debian.

enclavelabs

Bigbug This is really good to know! I figured it was just a weird preference out of ignorance on my side so looking forward to getting this running in Debian!

tMr

For Ubuntu 22.04 i didnt install php, i edited the script and installed php v8.3. I even tried it with Dockerfile also and it worked!

sudo apt install -y php8.3 php8.3-intl php8.3-mysqli php8.3-gd php8.3-curl php8.3-imap php8.3-mailparse php8.3-mbstring php8.3-curl php8.3-xml php8.3-bcmath php8.3-mailparse libapache2-mod-php libapache2-mod-md

enclavelabs

tMr so did you just remove the following lines from the install script and manually install the remaining packages?

Remove the php references here:

install_packages() {

apt-get update && apt-get -y upgrade

apt-get install -y apache2 mariadb-server \

php libapache2-mod-php php-intl php-mysqli php-gd \

php-curl php-imap php-mailparse libapache2-mod-md \

certbot python3-certbot-apache git sudo whois cron

enclavelabs

So I just reinstalled ITflow on Debian and was able to walk through setting up the interface. Once I got signed in though and began enabling cron for ticketing, I started receiving the "HTTP ERROR: 500" when trying to click save on various pages. I am now unable to update my app or enable cron for ticket email parsing as anytime I hit save, I'm brought to this screen.

johnny

@enclavelabs You must of just installed when I submitted a bad patch thats some timing 👀 .

Okay Everything should be fixed now I promise. Also I added Ubuntu 24.04 support back in.

So pick your poison ubuntu 24.04 or debian 12

enclavelabs

johnny No worries - I was just wondering if I somehow missed a step even though I've documented everything now for my own instructions! I thought I was going crazy! As always, thank you so much for your fast monitoring of this issue. I'll reinstall and try again!

johnny

Okay a quick recap on what we did

We removed the checks for php-imap and php-mailparse in the mail parser script as these checks are not needed

We updated the install script to only be compatible with ubuntu 24.04 or debian 12 as they both have php 8.2 or greater as WEBKLEX IMAP requires
We excluded installing packages: php-imap and php-mailparse from the install script as they are no longer needed.
In the settings > IMAP test we now use the WEBKLEX IMAP function instead of php-imap extension

johnny

enclavelabs Excellent since you been such a good tester do you mind testing both ubuntu 24.04 and debian 12 installs

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

« Previous Page Next Page »