Problem with PHP Standalone OpenID Server

[Benjamin Heil]

Hi Norman,

thanks for your reply.
As far as I can see, all tables are created correctly. I removed all 
tables from the database to test a fresh install, but the problem is the 
same. (The db user has all rights on the specific database.)

The server is a Debian Etch system with php 5.2 and MySQL 5.0. Here's a 
dump from phpmyadmin:

CREATE TABLE `accounts` (
   `id` int(11) NOT NULL auto_increment,
   `username` varchar(255) default NULL,
   `password` varchar(32) default NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;


INSERT INTO `accounts` (`id`, `username`, `password`) VALUES
(1, 'test', 'a681d0039910f6b38666d5cbc2e5ac1d');

CREATE TABLE `identities` (
   `id` int(11) NOT NULL auto_increment,
   `account` varchar(255) NOT NULL,
   `url` text NOT NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `account` (`account`,`url`(255))
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `identities` (`id`, `account`, `url`) VALUES
(1, 'test', 'http://openid.wankoo.org/?user=test');

CREATE TABLE `personas` (
   `id` int(11) NOT NULL auto_increment,
   `account` varchar(255) NOT NULL,
   `nickname` varchar(255) default NULL,
   `email` varchar(255) default NULL,
   `fullname` varchar(255) default NULL,
   `dob` date default NULL,
   `gender` char(1) default NULL,
   `postcode` varchar(255) default NULL,
   `country` varchar(32) default NULL,
   `language` varchar(32) default NULL,
   `timezone` varchar(255) default NULL,
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `sites` (
   `account` varchar(255) NOT NULL,
   `trust_root` text,
   `trusted` tinyint(1) default NULL,
   UNIQUE KEY `account` (`account`,`trust_root`(255))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


Norman Rasmussen schrieb:
> On 8/20/07, *Benjamin Heil* <benjamin.heil at wankoo.org 
> <mailto:benjamin.heil at wankoo.org>> wrote:
> 
>     Getting association: missing key in response from
>     http://openid.wankoo.org/index.php/serve: assoc_type
> 
> 
> Check to see if all the db tables were created correctly, they might not 
> have been.
> 
> -- 
> - Norman Rasmussen
> - Email: norman at rasmussen.co.za <mailto:norman at rasmussen.co.za>
> - Home page: http://norman.rasmussen.co.za/
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Dev mailing list
> Dev at lists.openidenabled.com
> http://lists.openidenabled.com/mailman/listinfo/dev