ssossossosso

Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

This topic contains 3 replies, has 2 voices, and was last updated by  ianfp 1 year, 3 months ago.

  • Creator
    Topic
  • #18507

    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
  • #18510
    Alex Rudenko
    Alex Rudenko
    Oro Core

    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

    #18514

    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.

    #20025

    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)

You must be logged in to reply to this topic.