For future reference for others - this was caused by a backward level of mysql client (3.1) connecting to mysql server 5.6 i.e. user error :-(
John Hawkins Director: Solutions Architecture On Wed, Jul 29, 2015 at 9:57 AM, John Hawkins <jo...@wso2.com> wrote: > Hi Folks, > > I'm trying to share databases between my API-M and my identity server. I'm > using a mysql db between them with three DB's - registry, userstore and > apimgt. When I start either the api-m or the identity server for the first > time they both come back with exactly the same error - they can't create > the admin user in the DB. > > I see that Elilmatha had exactly the same problem [1] - but there is no > response on that thread so I can't see what fixed it. I've spoken with Elil > who thinks it may have been something to do with setting wso2registry in > registry.xml - but I have that set up from what I can tell.. > > <dbConfig name="wso2registry"> > <dataSource>jdbc/WSO2REG_DB</dataSource> > </dbConfig> > > And as the error is a sql error on putting the data in the db I think that > it's more likely that there is an error with the values going into the DB > or that the definition of the UM_USER table is wrong? > Any clues folks ? > > [1] http://mail.wso2.org/mailarchive/dev/2015-July/051104.html > > many thanks, > John. > > > John Hawkins > Director: Solutions Architecture > >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev