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

Reply via email to