I have a stock install of Drupal 6 set up with a single user and 0 contrib modules. I have enabled only the OpenID module and my own custom theme.

When trying to add an OpenID identity using my 'phpMyID' hosted on my own domain I wait for approx. 30 seconds before being presented with:

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (3, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:354:\"MySQL server has gone away\nquery: INSERT INTO openid_association (idp_endpoint_uri, session_type, assoc_handle, assoc_type, expires_in, mac_key, created) VALUES('http://id.salienttraits.co.uk/', 'DH-SHA1', '89092eeb2af80c8da769ba80c089355e', 'HMAC-SHA1', 1440, 'NQ5bdAOapy8GmzrO27dDeYcNDH0=', 1203370703)\";s:5:\"%file\";s:54:\"/home/coopera/public_html/modules/openid/openid.module\";s:5:\"%line\";i:371;}', 3, '', 'http://networkpie.co.uk/user/3/openid', 'http://networkpie.co.uk/user/3/openid', '80.6.114.67', 120 in /home/coopera/public_html/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (3, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:137:\"Cannot modify header information - headers already sent by (output started at /home/coopera/public_html/includes/database.mysqli.inc:128)\";s:5:\"%file\";s:51:\"/home/coopera/public_html/modules/openid/openid.inc\";s:5:\"%line\";i:36;}', 3, '', 'http://networkpie.co.uk/user/3/openid', 'http://networkpie.co.uk/user/3/openid', '80.6.114.67', 1203370703) in /home/coopera/public_html/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (3, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:120:\"MySQL server has gone away\nquery: SELECT COUNT(*) FROM sessions WHERE sid = '23361b200182c725d5b455d2e3513ec0'\";s:5:\"%file\";s:46:\"/home/coopera/public_html/includes/session.inc\";s:5:\"%line\";i:65;}', 3, '', 'http://networkpie.co.uk/user/3/openid', 'http://networkpie.co.uk/user/3/openid', '80.6.114.67', 1203370703) in /home/coopera/public_html/includes/database.mysqli.inc on line 128

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (3, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:1455:\"MySQL server has gone away\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES ('23361b200182c725d5b455d2e3513ec0', 3, 0, '80.6.114.67', 'dblog_overview_filter|a:0:{}messages|a:2:{s:6:\\"status\\";a:1:{i:0;s:27:\\"Operating in off-line mode.\\";}s:5:\\"error\\";a:2:{i:0;s:439:\\"user warning: MySQL server has gone away\\nquery: INSERT INTO openid_association (idp_endpoint_uri, session_type, assoc_handle, assoc_type, expires_in, mac_key, created) VALUES('http://id.salienttraits.co.uk/', 'DH-SHA1&amp in /home/coopera/public_html/includes/database.mysqli.inc on line 128

When attemping to add my yahoo OpenID identity I get further. I get to the Yahoo signin page, click Login and am returned to the add Identity page. However, no ID will have been added to the table of available IDs, it appears that nothing has happened. On closer inspection I find that I have triggered #223316: OpenID failure causes permanent setting of drupal_http_request_error = true and am no longer able to make any outgoing connections from my Drupal install.

All in all. Both identities available to me fail to work with the Drupal OpenID implementation.

I'll add that both IDs have been used successfully to sign into ma.gnolia.com

Comments

Spiked’s picture

As said in this thread: http://drupal.org/node/163987 you need to tune your MySQL server

Spiked’s picture

Category: bug » support
Status: Active » Closed (fixed)

Closed; not a drupal bug.