PHP-OpenID server is not working , blank page is coming while using it from other sites

[Kushal Das]

On Tuesday 29 January 2008 11:26:54 am Jonathan Daugherty wrote:
> Which association store are you using?  I've seen problems with some
> MySQL versions due to a bug in index creation that prevents the
> required tables from being created.  You might need to look for
> failing queries in your database statement log, and you'll need to
> turn on statement logging if it's not on by default.
Finally got the logs.
Below is a paste:

20 Connect     openid at localhost on
                     20 Init DB     php_openid_server
                     20 Init DB     php_openid_server
                     20 Query       CREATE TABLE accounts (id INTEGER 
AUTO_INCREMENT PRIMARY KEY, username VARCHAR(255) UNIQUE, password 
VARCHAR(32))
                     20 Init DB     php_openid_server
                     20 Init DB     php_openid_server
                     20 Query       CREATE TABLE identities (id INTEGER 
AUTO_INCREMENT NOT NULL PRIMARY KEY, account VARCHAR(255) NOT NULL, url TEXT 
NOT NULL, UNIQUE (account, url(255)))
                     20 Init DB     php_openid_server
                     20 Query       CREATE TABLE personas (id INTEGER 
AUTO_INCREMENT NOT NULL PRIMARY KEY, account VARCHAR(255) NOT NULL, nickname 
VARCHAR(255), email VARCHAR(255), fullname VARCHAR(255), dob DATE, gender 
CHAR(1), postcode VARCHAR(255), country VARCHAR(32), language VARCHAR(32), 
timezone VARCHAR(255))
                     20 Init DB     php_openid_server
                     20 Query       CREATE TABLE sites (account VARCHAR(255) 
NOT NULL, trust_root TEXT, trusted BOOLEAN, UNIQUE (account, 
trust_root(255)))
                     20 Quit
                     19 Query       SELECT sid FROM sessions WHERE sid 
= '5gk2l30rao806qk8g4ogn8o4v7'
                     19 Query       UPDATE sessions SET uid = 0, cache = 0, 
hostname = '127.0.0.1', session = 'openid_op_endpoint|s:46:
\"http://172.16.1.189/openid/src/index.php/serve\";openid_claimed_id|s:43:
\"http://172.16.1.189/openid/src/?user=kushal\";', timestamp = 1201596225 
WHERE sid = '5gk2l30rao806qk8g4ogn8o4v7'
                     19 Quit
                     21 Connect     openid at localhost on
                     21 Init DB     php_openid_server
                     21 Init DB     php_openid_server
                     21 Query       CREATE TABLE accounts (id INTEGER 
AUTO_INCREMENT PRIMARY KEY, username VARCHAR(255) UNIQUE, password 
VARCHAR(32))
                     21 Init DB     php_openid_server
                     21 Init DB     php_openid_server
                     21 Query       CREATE TABLE identities (id INTEGER 
AUTO_INCREMENT NOT NULL PRIMARY KEY, account VARCHAR(255) NOT NULL, url TEXT 
NOT NULL, UNIQUE (account, url(255)))
                     21 Init DB     php_openid_server
                     21 Query       CREATE TABLE personas (id INTEGER 
AUTO_INCREMENT NOT NULL PRIMARY KEY, account VARCHAR(255) NOT NULL, nickname 
VARCHAR(255), email VARCHAR(255), fullname VARCHAR(255), dob DATE, gender 
CHAR(1), postcode VARCHAR(255), country VARCHAR(32), language VARCHAR(32), 
timezone VARCHAR(255))
                     21 Init DB     php_openid_server
                     21 Query       CREATE TABLE sites (account VARCHAR(255) 
NOT NULL, trust_root TEXT, trusted BOOLEAN, UNIQUE (account, 
trust_root(255)))
                     21 Init DB     php_openid_server
                     21 Init DB     php_openid_server
                     21 Query       SELECT * FROM oid_nonces LIMIT 0
                     21 Init DB     php_openid_server
                     21 Query       SELECT * FROM oid_associations LIMIT 0
                     21 Quit



But I can not see any sessions table in mysql :(

Kushal
-- 
Fedora Ambassador, India
http://kushaldas.in
http://dgplug.org (Linux User Group of Durgapur)