Re: [Testing] Stratos 4.1.0 Alpha - database error deploying cartridge - Table 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist -schema change ?

2014-12-15 Thread Udara Liyanage
added it >>> >>> >>> >>> *From:* Imesh Gunaratne [mailto:im...@apache.org] >>> *Sent:* Monday, December 15, 2014 11:37 AM >>> *To:* dev >>> *Subject:* Re: [Testing] Stratos 4.1.0 Alpha - database error deploying >>> cartridge -

Re: [Testing] Stratos 4.1.0 Alpha - database error deploying cartridge - Table 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist -schema change ?

2014-12-15 Thread Imesh Gunaratne
cation-sql.mysql was missing in >> the 4.1.0-test branch so I added it >> >> >> >> *From:* Imesh Gunaratne [mailto:im...@apache.org] >> *Sent:* Monday, December 15, 2014 11:37 AM >> *To:* dev >> *Subject:* Re: [Testing] Stratos 4.1.0 Alpha - databa

RE: [Testing] Stratos 4.1.0 Alpha - database error deploying cartridge - Table 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist -schema change ?

2014-12-15 Thread Udara Liyanage
ler/resources /application-sql.mysql was missing in > the 4.1.0-test branch so I added it > > > > *From:* Imesh Gunaratne [mailto:im...@apache.org] > *Sent:* Monday, December 15, 2014 11:37 AM > *To:* dev > *Subject:* Re: [Testing] Stratos 4.1.0 Alpha - databas

RE: [Testing] Stratos 4.1.0 Alpha - database error deploying cartridge - Table 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist -schema change ?

2014-12-15 Thread Martin Eppel (meppel)
tools/stratos-installer/resources /application-sql.mysql was missing in the 4.1.0-test branch so I added it From: Imesh Gunaratne [mailto:im...@apache.org] Sent: Monday, December 15, 2014 11:37 AM To: dev Subject: Re: [Testing] Stratos 4.1.0 Alpha - database error deploying cartridge - Table

Re: [Testing] Stratos 4.1.0 Alpha - database error deploying cartridge - Table 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist -schema change ?

2014-12-15 Thread Imesh Gunaratne
Hi Udara, I'm also seeing this error now in 4.1.0-test branch in single JVM mode with H2 database: [2014-12-16 01:01:29,145] ERROR {org.wso2.carbon.identity.oauth.dao.OAuthAppDAO} - Error when executing the SQL : SELECT * FROM IDN_OAUTH_CONSUMER_APPS WHERE USERNAME=? AND TENANT_ID=? AND APP_NAME

Re: [Testing] Stratos 4.1.0 Alpha - database error deploying cartridge - Table 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist -schema change ?

2014-12-14 Thread Udara Liyanage
Hi, You have to secute below database queries within tools/stratos-installer/resources in addition to mysql.sql in the under the same directory. application-mysql.sql security-mysql.sql I have added them to setup.sh also. Please take an update from the 4.1.0-test branch. On Mon, Dec 15, 2014 at

Re: [Testing] Stratos 4.1.0 Alpha - database error deploying cartridge - Table 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist -schema change ?

2014-12-14 Thread Udara Liyanage
Hi Martin, This is due to that you have not executed databases related to oAuth added recently. I will point you to the database location soon. On Mon, Dec 15, 2014 at 9:50 AM, Martin Eppel (meppel) wrote: > > [Resending it with a slightly different Subject] > > > > I run into the following iss

[Testing] Stratos 4.1.0 Alpha - database error deploying cartridge - Table 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist -schema change ?

2014-12-14 Thread Martin Eppel (meppel)
[Resending it with a slightly different Subject] I run into the following issue when I tried to deploy a cartridge (based on Friday’s code from master): - looks like the database schema has changed and a new field was added. My question is, how is this supposed to work, do we need to apply the n