Error Log form Group Email

[bradaks]

Getting this error in my log. Cannot get the Group Email to receive anything.

[2018-02-05 01:20:09] Espo.ERROR: Display Error: cannot connect to host ; error = fsockopen(): unable to connect to ssl://imap.google.com:993 (php_network_getaddresses: getaddrinfo failed: Name or service not known) (errno = 0 ), Code: 0 URL: /espocrm/api/v1/InboundEmail/action/testConnection [] []
[2018-02-05 01:20:17] Espo.WARNING: E_WARNING: mkdir(): File exists {"code":2,"message":"mkdir(): File exists","file":"/opt/bitnami/apps/espocrm/htdocs/application/Espo/Core/Utils/File/Manager.php","line":396,"context":{"path":"data/cache/application/acl","permission":"509","recursive":true,"fullPat h ":"data/cache/application/acl","defaultPermissions":{"dir":"0775","file":"0 6 64","user":1,"group":1}}} []
[2018-02-05 01:20:17] Espo.ERROR: API [GET]:/Stream, Params:Array ( ) , InputData: - Permission denied: unable to create a folder on the server - data/cache/application/acl [] []
[2018-02-05 01:20:17] Espo.ERROR: Display Error: Permission denied: unable to create a folder on the server - data/cache/application/acl, Code: 500 URL: /espocrm/api/v1/Stream?maxSize=50&offset=0&sortBy=number&asc=false [] []
[2018-02-05 01:20:25] Espo.ERROR: API [POST]:/:controller/action/:action, Params:Array ( [controller] => InboundEmail [action] => testConnection ) , InputData: {"host":"imap.google.com","port":"993","ssl":tr ue, "username":"info@phlebfinders.com","password": null ,"id":"*****"} - cannot connect to host ; error = fsockopen(): unable to connect to ssl://imap.google.com:993 (php_network_getaddresses: getaddrinfo failed: Name or service not known) (errno = 0 ) [] []
[2018-02-05 01:20:25] Espo.ERROR: Display Error: cannot connect to host ; error = fsockopen(): unable to connect to ssl://imap.google.com:993 (php_network_getaddresses: getaddrinfo failed: Name or service not known) (errno = 0 ), Code: 0 URL: /espocrm/api/v1/InboundEmail/action/testConnection [] []
[2018-02-05 01:24:02] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2018-02-05 01:28:02] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2018-02-05 01:32:01] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2018-02-05 01:36:02] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Select Folder) [0] cannot change folder, maybe it does not exist [] []

[bradaks]

I repaired my SQL and did a rebuild. No luck.

[tanya]

Hello.
try imap.gmail.com

[bradaks]

I did that as well after realizing I goofed that up. After doing that, I get the error:
[2018-02-05 01:24:02] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Select Folder) [0] cannot change folder, maybe it does not exist [] []

[tanya]

Does selected folder (INBOX or other one) exist?

[bradaks]

Here is what happens with INBOX selected:
[2018-02-05 15:48:02] Espo.ERROR: InboundEmail 5a77b123715f49a00 (Import Message w/ PhpMimeMailParser): [HY000] SQLSTATE[HY000]: General error: 1100 Table 'hourly_rate_currency_alias' was not locked with LOCK TABLES [] []


When I have just [Gmail] selected it only has the folder error.

[bradaks]

So Inbox actually fetched 3 emails. And then I get the same error again:

[2018-02-05 17:25:02] Espo.ERROR: EmailAccount 5a7892d2d83e90016 (Import Message w/ PhpMimeMailParser): [HY000] SQLSTATE[HY000]: General error: 1100 Table 'hourly_rate_currency_alias' was not locked with LOCK TABLES [] []

[tanya]

Is this table internal? (Do you have entity HourlyRateCurrencyAlias)?

[bradaks]

I do not have a table named that. There is an hourlyRateCurrency Varchar field in the email entity, but this is not one I created.

[tanya]

Remove this field with Entity Manager, please. It's not a good idea to add a field to this Entity

[bradaks]

Thank you so much for helping me troubleshoot this. Not sure how that got in there, but I appreciate the work you did to help out. It works great now.