Issue fetching email

mandyrc · 21 Nov 2023, 20:53

Hi, I tried all and still not work. I'm in DEV mode because when changed to PROD mode I get 500 error. Please help, i'm not able to fetch emails to tickets

This is the error I'm getting:

  # Processing all found emails iteratively:

    API http://support.elitechforce.com/etfsupport/public/mailbox/listener

    - Processing email 1 of 1:
  An unexpected error occurred: Notice: Trying to access array offset on value of type null

mandyrc · 21 Nov 2023, 21:32

@peopleinside Hi man. Thank for all your support, I figured out, the problem, like another user, was that the API used HTTP instead of HTTPS, I was able to modify RefreshMailboxCommand.php and now enforcing API to communicate using HTTPS, this is the change I made, probably will help other users. The project still in DEV mode because I cannot login as admin when I change to PROD. But for now I'm OK with this.

uvdeskprojectfolder/vendor/uvdesk/mailbox-component/Console/RefreshMailboxCommand.php

Changed this line:

$this->router->getContext()->setScheme((bool) $input->getOption('secure') ? 'https' : 'http');

To this:

$this->router->getContext()->setScheme('https');

Now emails are fetching and added to the respective ticket (I covered some info in case you want to share this solution with other users):

peopleinside · 21 Nov 2023, 11:58

Hi, I tried all and still not work. I'm in DEV mode because when changed to PROD mode I get 500 error.

If you get 500 error check your server error logs.
Be sure to use a supported PHP version I suggest 8.1 or 8.2
PHP 8.0 is a little bit old.

@mandyrc said in Mail retrieval error:

Trying to access array offset on value of type null

You can check this post, maybe can help you to do some checks.
https://forums.uvdesk.com/topic/1988/how-to-debug-errors-and-email-fetching-errors

mandyrc · 21 Nov 2023, 15:56

@peopleinside Hi, thanks for your quick reply, I've updated php version to 8.2 now in production the site load, but I'm not able to login as admin, when tried to do forget password the link to reset password give me a 500 error. And in production mode the error fetching the email changed to this:

  - Establishing connection with mailbox
  - Fetching all emails since 20 November 2023
  - Found a total of 1 emails in mailbox since 20 November 2023

  # Processing all found emails iteratively:

    API http://support.elitechforce.com/etfsupport/public/mailbox/listener

    - Processing email 1 of 1:
15:55:45 WARNING   [php] Warning: Trying to access array offset on value of type null ["exception" => ErrorException { …}]

      ERROR 

  - Mailbox refreshed successfully!

peopleinside · 21 Nov 2023, 16:35

@mandyrc you need maybe to check your server error log.
Maybe you configured email settings not correctly?

Have you cleared the cache after change to prod mode?
At the end of the update you should need to run php bin/console c:c inside the root UVdesk directory

peopleinside · 21 Nov 2023, 16:38

@mandyrc be sure also, when you run wizard, to have all checks passed green. Actually I see they are not all green in the setup wizard.
You may are trying to reinstall UVdesk again.. currently in your link I can see setup wizard showed.

PHP mailparse extension

Need to resolve this issue can be done by reading this blog link:How to resolve PHP mailparse extension

You meet 2 out of 3 config files permission.

Issue can be resolved by simply enabling read/write permissions for your files under config/packages folder of your project.

https://www.uvdesk.com/en/blog/open-source-helpdesk-installation-on-ubuntu-uvdesk/

mandyrc · 21 Nov 2023, 17:44

@peopleinside How do see setup wizard in my link, I can't

peopleinside · 21 Nov 2023, 17:57

@mandyrc Now the link load the UVdesk instance. You should have already done the wizard.

mandyrc · 21 Nov 2023, 20:01

@peopleinside This is what I did:

Installed mailparser, now is showing as installed
Went back to DEV mode and still have this error:
If change to PROD mode the error is different and also I'm not able to login as admin in the instance website:
Changed site_url in uvdesk.yaml adding and removing eftsupport/public same error on both options
Here is my .htaccess file, my index.php is on etfsupport/public folder

<IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteRule ^(.*)$ ./index.php/$1 [QSA,L]
    RewriteCond %{HTTP:Authorization} ^(.*)
    RewriteRule .* - [e=HTTP_AUTHORIZATION:%1]
</IfModule>

Apache2.conf file has this

AllowOverride All
Require all granted

I checked the folders and .ENV files:

For .env file – chmod 775 -R path of .env file of UVdesk project

For var folder -chmod 775 -R path of var folder of UVdesk project

For config folder – chmod 775 -R path of config folder of UVdesk project

I don't know what else I can do... I would be possible to give you access to my instance so you can check what is wrong? If so, let me know how to send you the credentials privately.

Thanks so much for your time and support.

peopleinside · 21 Nov 2023, 20:59

@mandyrc

I moved your topic here to avoid stressing users that saw solved his own question.
I cannot access other application is for security.

How you compiled the host field in mail settings?
Something like: ```
{imap.gmail.com:993/imap/ssl}INBOX


Are you using your domain provider?
Your email address has a two factor authentication active?

I hope also a UVdesk staff member can add here and help you.

mandyrc · 21 Nov 2023, 21:32

@peopleinside Hi man. Thank for all your support, I figured out, the problem, like another user, was that the API used HTTP instead of HTTPS, I was able to modify RefreshMailboxCommand.php and now enforcing API to communicate using HTTPS, this is the change I made, probably will help other users. The project still in DEV mode because I cannot login as admin when I change to PROD. But for now I'm OK with this.

uvdeskprojectfolder/vendor/uvdesk/mailbox-component/Console/RefreshMailboxCommand.php

Changed this line:

$this->router->getContext()->setScheme((bool) $input->getOption('secure') ? 'https' : 'http');

To this:

$this->router->getContext()->setScheme('https');

Now emails are fetching and added to the respective ticket (I covered some info in case you want to share this solution with other users):

peopleinside · 21 Nov 2023, 21:46

@mandyrc I'm glad to read you was able to resolve!
I don't know if the code can be improved but I will try to report this to developers.

Thanks for your update

peopleinside · 21 Nov 2023, 21:52

@mandyrc said in Issue fetching email:

The project still in DEV mode because I cannot login as admin when I change to PROD. But for now I'm OK with this.

What error do you get when switching to prod and try to login?
Did you checked if some errors are present in server error log or developer console?

When you edit DEV to PROD do you clear also cache before login?
Are you sure to use the correct operator login link and not the customer login link?

Solved Issue fetching email