Forums › Forums › OroCRM › OroCRM – Installation/Technical Issues or Problems › You have lost your access to organization…. Please relogin.
This topic contains 3 replies, has 2 voices, and was last updated by ianfp 7 years, 9 months ago.
Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.
- CreatorTopic
- June 8, 2016 at 1:55 pm #27172
When I try to log in with Google, I get this error:
You have lost your access to organization “My Organization, Inc.” Please relogin.
I used the oro:user:update command to reset my password and I tried logging in with that (instead of with Google) but I got the same error.
I logged into the database and checked the oro_organization and oro_user tables; my user’s organization_id matches the one in oro_organization, and everything is enabled.
I’m not the only one who is locked out — everyone at my company is.
Any suggestions for what might have caused this problem or what to check?
- CreatorTopic
- AuthorReplies
- June 9, 2016 at 1:28 am #27173
Hi Ianfp,
We would like to know more about your organizational structure to solve the problem. Could you please provide us with some logs from app/logs/prod.log. We will investigate this case and answer you soon.
Thank you,
AlexJune 9, 2016 at 9:29 am #27174Alex,
Thanks for getting back to me so quickly. The prod.log file is fairly large (3.2M). Is there a secure way for me to send it to you?
In the meantime, here’s a snippet:
[2016-06-08 13:49:20] security.DEBUG: Check class based an access using “orocrm_magento_order_view” ACL annotation. [] []
[2016-06-08 13:49:20] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
[2016-06-08 13:49:23] security.DEBUG: Check an access using “oro_email_email_view” ACL annotation. [] []
[2016-06-08 13:49:23] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
[2016-06-08 13:49:23] security.DEBUG: Check an access using “oro_calendar_view” ACL annotation. [] []
[2016-06-08 13:49:23] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
[2016-06-08 13:49:23] security.DEBUG: Check an access using “orocrm_task_view” ACL annotation. [] []
[2016-06-08 13:49:23] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
[2016-06-08 13:49:23] security.DEBUG: Invoked controller “Oro\Bundle\EmailBundle\Controller\EmailController::placeholderLastAction”. (SUB_REQUEST) [] []
[2016-06-08 13:49:25] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO oro_email_body (created, body, body_is_text, has_attachments, persistent) VALUES (?, ?, ?, ?, ?)’ with params [“2016-06-08 20:49:25”, “\x3c\x68\x74\x6d\x6c\x20\x78\x6d\x6c\x6e\x73\x3a\x76\x3d\x22\x75The hex body that you see there is clipped — the actual body is huge and comprises most of the log file.
June 10, 2016 at 11:21 am #27175Here’s an update: the following error occurs every time I try to log in. I wonder if the database exception is being caught and interpreted (incorrectly?) as an authentication exception:
[2016-06-10 11:11:27] security.DEBUG: Check an access using “oro_email_email_view” ACL annotation. [] []
[2016-06-10 11:11:27] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
[2016-06-10 11:11:27] security.DEBUG: Check an access using “oro_calendar_view” ACL annotation. [] []
[2016-06-10 11:11:27] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
[2016-06-10 11:11:27] security.DEBUG: Check an access using “orocrm_task_view” ACL annotation. [] []
[2016-06-10 11:11:27] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
[2016-06-10 11:11:27] security.DEBUG: Invoked controller “Oro\Bundle\EmailBundle\Controller\EmailController::placeholderLastAction”. (SUB_REQUEST) [] []
[2016-06-10 11:11:29] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO oro_email_body (created, body, body_is_text, has_attachments, persistent) VALUES (?, ?, ?, ?, ?)’ with params [“2016-06-10 18:11:28”, “\x3c\x68\x74\x6d\x6c\x20\[very long hex email body]
SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF3nico …’ for column ‘body’ at row 1” at /home/ubuntu/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:”[object] (Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing ‘INSERT INTO oro_email_body (created, body, body_is_text, has_attachments, persistent) VALUES (?, ?, ?, ?, ?)’ with params [\”2016-06-10 18:11:28\”, \”\\x3c\\x68\\x74\\x6d\\x6c\\x20\\
[very long hex email body]
SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\\xF3nico …’ for column ‘body’ at row 1 at /home/ubuntu/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\\xF3nico …’ for column ‘body’ at row 1 at /home/ubuntu/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\\xF3nico …’ for column ‘body’ at row 1 at /home/ubuntu/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)”} []
[2016-06-10 11:11:31] security.DEBUG: Calling Authentication entry point. [] []It appears to be failing to insert an oro_email_body record into the database. I have a guess as to which email message is causing the problem. Can I send you the original email via a non-public channel?
UPDATE:
I archived the Gmail message that I suspected was causing the problem. This solved the problem and allowed me to log in. This seems like a bug in how that database error was handled, no? - AuthorReplies
The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.