OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

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.

  • Creator
    Topic
  • #27172

    ianfp
    Participant

    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?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Author
    Replies
  • #27173

    Alex Rudenko
    Participant

    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,
    Alex

    #27174

    ianfp
    Participant

    Alex,

    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\x75

    The hex body that you see there is clipped — the actual body is huge and comprises most of the log file.

    #27175

    ianfp
    Participant

    Here’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?

Viewing 3 replies - 1 through 3 (of 3 total)

The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.

Back to top