chok/sfMelodyPlugin — Issue #45: Problem with authentification
Author: Khalezis
Created: 2011-12-28 20:46:52+00:00
State: open

HI,

I have a problem. Indeed, when the user is already in the database I have a infinite loop. See that log file:

Dec 28 21:21:26 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signin" (/guard/login)
Dec 28 21:21:26 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signout" (/guard/logout)
Dec 28 21:21:26 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_register" (/guard/register)
Dec 28 21:21:26 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password)
Dec 28 21:21:26 symfony [info] {sfPatternRouting} Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key)
Dec 28 21:21:26 symfony [info] {sfPatternRouting} Match route "melody_access" (/access/:service) for /access/facebook with parameters array ( 'module' => 'sfMelody', 'action' => 'access', 'service' => 'facebook',)
Dec 28 21:21:26 symfony [info] {sfFilterChain} Executing filter "sfRenderingFilter"
Dec 28 21:21:26 symfony [info] {sfFilterChain} Executing filter "sfExecutionFilter"
Dec 28 21:21:26 symfony [info] {sfMelodyActions} Call "sfMelodyActions->executeAccess()"
Dec 28 21:21:26 symfony [info] {Doctrine_Connection_Mysql} exec : SET NAMES 'UTF8' - ()
Dec 28 21:21:26 symfony [info] {Doctrine_Connection_Statement} execute : SELECT s.id AS s__id, s.first_name AS s__first_name, s.last_name AS s__last_name, s.email_address AS s__email_address, s.username AS s__username, s.algorithm AS s__algorithm, s.salt AS s__salt, s.password AS s__password, s.is_active AS s__is_active, s.is_super_admin AS s__is_super_admin, s.last_login AS s__last_login, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sf_guard_user s WHERE (s.id = ?) LIMIT 1 - (1)
Dec 28 21:21:26 symfony [info] {Doctrine_Connection_Statement} execute : SELECT t.id AS t__id, t.name AS t__name, t.token_key AS t__token_key, t.token_secret AS t__token_secret, t.user_id AS t__user_id, t.expire AS t__expire, t.params AS t__params, t.identifier AS t__identifier, t.status AS t__status, t.o_auth_version AS t__o_auth_version, t.created_at AS t__created_at, t.updated_at AS t__updated_at FROM token t WHERE (t.user_id = ?) - (1)
Dec 28 21:21:28 symfony [info] {OAuth} call url "https://graph.facebook.com/oauth/access_token?client_id=202088659876193&client_secret=3639274d9ba3d2578a1a72a00da053e9&redirect_uri=http%3A%2F%2Faltezis.localhost%2Ffrontend_dev.php%2Faccess%2Ffacebook" with params "client_id=202088659876193&client_secret=3639274d9ba3d2578a1a72a00da053e9&redirect_uri=http%3A%2F%2Faltezis.localhost%2Ffrontend_dev.php%2Faccess%2Ffacebook" post "" by method "GET" give response "{"error":{"message":"An unknown error has occurred.","type":"OAuthException"}}"
Dec 28 21:21:28 symfony [err] {OAuth} access token failed - facebook returns Array
(
[{"error":{"message":"An unknown error has occurred.","type":"OAuthException"}}] =>
)

Dec 28 21:21:28 symfony [info] {OAuth} call url "https://graph.facebook.com/me" with params "" post "" by method "GET" give response "{"error":{"message":"An active access token must be used to query information about the current user.","type":"OAuthException"}}"
Dec 28 21:21:29 symfony [info] {OAuth} call url "https://graph.facebook.com/me" with params "" post "" by method "GET" give response "{"error":{"message":"An active access token must be used to query information about the current user.","type":"OAuthException"}}"
Dec 28 21:21:29 symfony [info] {Doctrine_Connection_Statement} execute : DELETE FROM token WHERE (status = ? AND name = ? AND user_id = ?) - (access, facebook, 1)
Dec 28 21:21:29 symfony [info] {Doctrine_Connection_Statement} execute : INSERT INTO token (name, status, o_auth_version, params, user_id, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?) - (facebook, access, 2, {"{\"error\":{\"message\":\"An unknown error has occurred.\",\"type\":\"OAuthException\"}}":""}, 1, 2011-12-28 21:21:29, 2011-12-28 21:21:29)
Dec 28 21:21:29 symfony [info] {sfFrontWebController} Redirect to "http://altezis.localhost/frontend_dev.php/access/facebook"
Dec 28 21:21:29 symfony [info] {sfWebResponse} Send status "HTTP/1.1 302 Found"
Dec 28 21:21:29 symfony [info] {sfWebResponse} Send header "Location: http://altezis.localhost/frontend_dev.php/access/facebook"
Dec 28 21:21:29 symfony [info] {sfWebResponse} Send header "Content-Type: text/html; charset=utf-8"
Dec 28 21:21:29 symfony [info] {sfWebDebugLogger} Configuration 186.38 ms (8)
Dec 28 21:21:29 symfony [info] {sfWebDebugLogger} Factories 420.64 ms (1)
Dec 28 21:21:29 symfony [info] {sfWebDebugLogger} Action "sfMelody/access" 3156.09 ms (1)
Dec 28 21:21:29 symfony [info] {sfWebDebugLogger} Database (Doctrine) 0.17 ms (5)
Dec 28 21:21:29 symfony [info] {sfWebResponse} Send content (128 o)
Dec 28 21:21:30 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signin" (/guard/login)
Dec 28 21:21:30 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signout" (/guard/logout)
Dec 28 21:21:30 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_register" (/guard/register)
Dec 28 21:21:30 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password)
Dec 28 21:21:30 symfony [info] {sfPatternRouting} Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key)
Dec 28 21:21:30 symfony [info] {sfPatternRouting} Match route "melody_access" (/access/:service) for /access/facebook with parameters array ( 'module' => 'sfMelody', 'action' => 'access', 'service' => 'facebook',)
Dec 28 21:21:30 symfony [info] {sfFilterChain} Executing filter "sfRenderingFilter"
Dec 28 21:21:30 symfony [info] {sfFilterChain} Executing filter "sfExecutionFilter"
Dec 28 21:21:30 symfony [info] {sfMelodyActions} Call "sfMelodyActions->executeAccess()"
Dec 28 21:21:31 symfony [info] {Doctrine_Connection_Mysql} exec : SET NAMES 'UTF8' - ()
Dec 28 21:21:31 symfony [info] {Doctrine_Connection_Statement} execute : SELECT s.id AS s__id, s.first_name AS s__first_name, s.last_name AS s__last_name, s.email_address AS s__email_address, s.username AS s__username, s.algorithm AS s__algorithm, s.salt AS s__salt, s.password AS s__password, s.is_active AS s__is_active, s.is_super_admin AS s__is_super_admin, s.last_login AS s__last_login, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sf_guard_user s WHERE (s.id = ?) LIMIT 1 - (1)
Dec 28 21:21:31 symfony [info] {Doctrine_Connection_Statement} execute : SELECT t.id AS t__id, t.name AS t__name, t.token_key AS t__token_key, t.token_secret AS t__token_secret, t.user_id AS t__user_id, t.expire AS t__expire, t.params AS t__params, t.identifier AS t__identifier, t.status AS t__status, t.o_auth_version AS t__o_auth_version, t.created_at AS t__created_at, t.updated_at AS t__updated_at FROM token t WHERE (t.user_id = ?) - (1)
Dec 28 21:21:32 symfony [info] {OAuth} call url "https://graph.facebook.com/oauth/access_token?client_id=202088659876193&client_secret=3639274d9ba3d2578a1a72a00da053e9&redirect_uri=http%3A%2F%2Faltezis.localhost%2Ffrontend_dev.php%2Faccess%2Ffacebook" with params "client_id=202088659876193&client_secret=3639274d9ba3d2578a1a72a00da053e9&redirect_uri=http%3A%2F%2Faltezis.localhost%2Ffrontend_dev.php%2Faccess%2Ffacebook" post "" by method "GET" give response "{"error":{"message":"An unknown error has occurred.","type":"OAuthException"}}"
Dec 28 21:21:32 symfony [err] {OAuth} access token failed - facebook returns Array
(
[{"error":{"message":"An unknown error has occurred.","type":"OAuthException"}}] =>
)

Dec 28 21:21:33 symfony [info] {OAuth} call url "https://graph.facebook.com/me" with params "" post "" by method "GET" give response "{"error":{"message":"An active access token must be used to query information about the current user.","type":"OAuthException"}}"
Dec 28 21:21:33 symfony [info] {OAuth} call url "https://graph.facebook.com/me" with params "" post "" by method "GET" give response "{"error":{"message":"An active access token must be used to query information about the current user.","type":"OAuthException"}}"
Dec 28 21:21:33 symfony [info] {Doctrine_Connection_Statement} execute : DELETE FROM token WHERE (status = ? AND name = ? AND user_id = ?) - (access, facebook, 1)
Dec 28 21:21:33 symfony [info] {Doctrine_Connection_Statement} execute : INSERT INTO token (name, status, o_auth_version, params, user_id, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?) - (facebook, access, 2, {"{\"error\":{\"message\":\"An unknown error has occurred.\",\"type\":\"OAuthException\"}}":""}, 1, 2011-12-28 21:21:33, 2011-12-28 21:21:33)
Dec 28 21:21:33 symfony [info] {sfFrontWebController} Redirect to "http://altezis.localhost/frontend_dev.php/access/facebook"
Dec 28 21:21:33 symfony [info] {sfWebResponse} Send status "HTTP/1.1 302 Found"
Dec 28 21:21:33 symfony [info] {sfWebResponse} Send header "Location: http://altezis.localhost/frontend_dev.php/access/facebook"
Dec 28 21:21:33 symfony [info] {sfWebResponse} Send header "Content-Type: text/html; charset=utf-8"
Dec 28 21:21:33 symfony [info] {sfWebDebugLogger} Configuration 200.26 ms (8)
Dec 28 21:21:33 symfony [info] {sfWebDebugLogger} Factories 419.30 ms (1)
Dec 28 21:21:33 symfony [info] {sfWebDebugLogger} Action "sfMelody/access" 3166.90 ms (1)
Dec 28 21:21:33 symfony [info] {sfWebDebugLogger} Database (Doctrine) 0.17 ms (5)
Dec 28 21:21:33 symfony [info] {sfWebResponse} Send content (128 o)
Dec 28 21:21:34 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signin" (/guard/login)
Dec 28 21:21:34 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signout" (/guard/logout)
Dec 28 21:21:34 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_register" (/guard/register)
Dec 28 21:21:34 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password)
Dec 28 21:21:34 symfony [info] {sfPatternRouting} Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key)
Dec 28 21:21:34 symfony [info] {sfPatternRouting} Match route "melody_access" (/access/:service) for /access/facebook with parameters array ( 'module' => 'sfMelody', 'action' => 'access', 'service' => 'facebook',)
Dec 28 21:21:35 symfony [info] {sfFilterChain} Executing filter "sfRenderingFilter"
Dec 28 21:21:35 symfony [info] {sfFilterChain} Executing filter "sfExecutionFilter"
Dec 28 21:21:35 symfony [info] {sfMelodyActions} Call "sfMelodyActions->executeAccess()"
Dec 28 21:21:35 symfony [info] {Doctrine_Connection_Mysql} exec : SET NAMES 'UTF8' - ()
Dec 28 21:21:35 symfony [info] {Doctrine_Connection_Statement} execute : SELECT s.id AS s__id, s.first_name AS s__first_name, s.last_name AS s__last_name, s.email_address AS s__email_address, s.username AS s__username, s.algorithm AS s__algorithm, s.salt AS s__salt, s.password AS s__password, s.is_active AS s__is_active, s.is_super_admin AS s__is_super_admin, s.last_login AS s__last_login, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sf_guard_user s WHERE (s.id = ?) LIMIT 1 - (1)
Dec 28 21:21:35 symfony [info] {Doctrine_Connection_Statement} execute : SELECT t.id AS t__id, t.name AS t__name, t.token_key AS t__token_key, t.token_secret AS t__token_secret, t.user_id AS t__user_id, t.expire AS t__expire, t.params AS t__params, t.identifier AS t__identifier, t.status AS t__status, t.o_auth_version AS t__o_auth_version, t.created_at AS t__created_at, t.updated_at AS t__updated_at FROM token t WHERE (t.user_id = ?) - (1)
Dec 28 21:21:36 symfony [info] {OAuth} call url "https://graph.facebook.com/oauth/access_token?client_id=202088659876193&client_secret=3639274d9ba3d2578a1a72a00da053e9&redirect_uri=http%3A%2F%2Faltezis.localhost%2Ffrontend_dev.php%2Faccess%2Ffacebook" with params "client_id=202088659876193&client_secret=3639274d9ba3d2578a1a72a00da053e9&redirect_uri=http%3A%2F%2Faltezis.localhost%2Ffrontend_dev.php%2Faccess%2Ffacebook" post "" by method "GET" give response "{"error":{"message":"An unknown error has occurred.","type":"OAuthException"}}"
Dec 28 21:21:36 symfony [err] {OAuth} access token failed - facebook returns Array
(
[{"error":{"message":"An unknown error has occurred.","type":"OAuthException"}}] =>
)

Dec 28 21:21:37 symfony [info] {OAuth} call url "https://graph.facebook.com/me" with params "" post "" by method "GET" give response "{"error":{"message":"An active access token must be used to query information about the current user.","type":"OAuthException"}}"
Dec 28 21:21:38 symfony [info] {OAuth} call url "https://graph.facebook.com/me" with params "" post "" by method "GET" give response "{"error":{"message":"An active access token must be used to query information about the current user.","type":"OAuthException"}}"
Dec 28 21:21:38 symfony [info] {Doctrine_Connection_Statement} execute : DELETE FROM token WHERE (status = ? AND name = ? AND user_id = ?) - (access, facebook, 1)
Dec 28 21:21:38 symfony [info] {Doctrine_Connection_Statement} execute : INSERT INTO token (name, status, o_auth_version, params, user_id, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?) - (facebook, access, 2, {"{\"error\":{\"message\":\"An unknown error has occurred.\",\"type\":\"OAuthException\"}}":""}, 1, 2011-12-28 21:21:38, 2011-12-28 21:21:38)
Dec 28 21:21:38 symfony [info] {sfFrontWebController} Redirect to "http://altezis.localhost/frontend_dev.php/access/facebook"
Dec 28 21:21:38 symfony [info] {sfWebResponse} Send status "HTTP/1.1 302 Found"
Dec 28 21:21:38 symfony [info] {sfWebResponse} Send header "Location: http://altezis.localhost/frontend_dev.php/access/facebook"
Dec 28 21:21:38 symfony [info] {sfWebResponse} Send header "Content-Type: text/html; charset=utf-8"
Dec 28 21:21:38 symfony [info] {sfWebDebugLogger} Configuration 209.45 ms (8)
Dec 28 21:21:38 symfony [info] {sfWebDebugLogger} Factories 417.19 ms (1)
Dec 28 21:21:38 symfony [info] {sfWebDebugLogger} Action "sfMelody/access" 3020.33 ms (1)
Dec 28 21:21:38 symfony [info] {sfWebDebugLogger} Database (Doctrine) 0.18 ms (5)
Dec 28 21:21:38 symfony [info] {sfWebResponse} Send content (128 o)
Dec 28 21:21:38 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signin" (/guard/login)
Dec 28 21:21:38 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_signout" (/guard/logout)
Dec 28 21:21:38 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_register" (/guard/register)
Dec 28 21:21:38 symfony [info] {sfPatternRouting} Connect sfRoute "sf_guard_forgot_password" (/guard/forgot_password)
Dec 28 21:21:38 symfony [info] {sfPatternRouting} Connect sfDoctrineRoute "sf_guard_forgot_password_change" (/guard/forgot_password/:unique_key)
Dec 28 21:21:38 symfony [info] {sfPatternRouting} Match route "melody_access" (/access/:service) for /access/facebook with parameters array ( 'module' => 'sfMelody', 'action' => 'access', 'service' => 'facebook',)
Dec 28 21:21:39 symfony [info] {sfFilterChain} Executing filter "sfRenderingFilter"
Dec 28 21:21:39 symfony [info] {sfFilterChain} Executing filter "sfExecutionFilter"
Dec 28 21:21:39 symfony [info] {sfMelodyActions} Call "sfMelodyActions->executeAccess()"
Dec 28 21:21:39 symfony [info] {Doctrine_Connection_Mysql} exec : SET NAMES 'UTF8' - ()
Dec 28 21:21:39 symfony [info] {Doctrine_Connection_Statement} execute : SELECT s.id AS s__id, s.first_name AS s__first_name, s.last_name AS s__last_name, s.email_address AS s__email_address, s.username AS s__username, s.algorithm AS s__algorithm, s.salt AS s__salt, s.password AS s__password, s.is_active AS s__is_active, s.is_super_admin AS s__is_super_admin, s.last_login AS s__last_login, s.created_at AS s__created_at, s.updated_at AS s__updated_at FROM sf_guard_user s WHERE (s.id = ?) LIMIT 1 - (1)
Dec 28 21:21:39 symfony [info] {Doctrine_Connection_Statement} execute : SELECT t.id AS t__id, t.name AS t__name, t.token_key AS t__token_key, t.token_secret AS t__token_secret, t.user_id AS t__user_id, t.expire AS t__expire, t.params AS t__params, t.identifier AS t__identifier, t.status AS t__status, t.o_auth_version AS t__o_auth_version, t.created_at AS t__created_at, t.updated_at AS t__updated_at FROM token t WHERE (t.user_id = ?) - (1)
Dec 28 21:21:40 symfony [info] {OAuth} call url "https://graph.facebook.com/oauth/access_token?client_id=202088659876193&client_secret=3639274d9ba3d2578a1a72a00da053e9&redirect_uri=http%3A%2F%2Faltezis.localhost%2Ffrontend_dev.php%2Faccess%2Ffacebook" with params "client_id=202088659876193&client_secret=3639274d9ba3d2578a1a72a00da053e9&redirect_uri=http%3A%2F%2Faltezis.localhost%2Ffrontend_dev.php%2Faccess%2Ffacebook" post "" by method "GET" give response "{"error":{"message":"An unknown error has occurred.","type":"OAuthException"}}"
Dec 28 21:21:40 symfony [err] {OAuth} access token failed - facebook returns Array
(
[{"error":{"message":"An unknown error has occurred.","type":"OAuthException"}}] =>
)

Dec 28 21:21:41 symfony [info] {OAuth} call url "https://graph.facebook.com/me" with params "" post "" by method "GET" give response "{"error":{"message":"An active access token must be used to query information about the current user.","type":"OAuthException"}}"
Dec 28 21:21:41 symfony [info] {OAuth} call url "https://graph.facebook.com/me" with params "" post "" by method "GET" give response "{"error":{"message":"An active access token must be used to query information about the current user.","type":"OAuthException"}}"
Dec 28 21:21:42 symfony [info] {Doctrine_Connection_Statement} execute : DELETE FROM token WHERE (status = ? AND name = ? AND user_id = ?) - (access, facebook, 1)
Dec 28 21:21:42 symfony [info] {Doctrine_Connection_Statement} execute : INSERT INTO token (name, status, o_auth_version, params, user_id, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?) - (facebook, access, 2, {"{\"error\":{\"message\":\"An unknown error has occurred.\",\"type\":\"OAuthException\"}}":""}, 1, 2011-12-28 21:21:42, 2011-12-28 21:21:42)
Dec 28 21:21:42 symfony [info] {sfFrontWebController} Redirect to "http://altezis.localhost/frontend_dev.php/access/facebook"
Dec 28 21:21:42 symfony [info] {sfWebResponse} Send status "HTTP/1.1 302 Found"
Dec 28 21:21:42 symfony [info] {sfWebResponse} Send header "Location: http://altezis.localhost/frontend_dev.php/access/facebook"
Dec 28 21:21:42 symfony [info] {sfWebResponse} Send header "Content-Type: text/html; charset=utf-8"
Dec 28 21:21:42 symfony [info] {sfWebDebugLogger} Configuration 203.90 ms (8)
Dec 28 21:21:42 symfony [info] {sfWebDebugLogger} Factories 419.05 ms (1)
Dec 28 21:21:42 symfony [info] {sfWebDebugLogger} Action "sfMelody/access" 2969.58 ms (1)
Dec 28 21:21:42 symfony [info] {sfWebDebugLogger} Database (Doctrine) 0.16 ms (5)
Dec 28 21:21:42 symfony [info] {sfWebResponse} Send content (128 o)

When the user don't exist in the database, the process is normally