Hi Imesh, Please execute the above two SQL scripts. They are already in the setup.sh. need to add to wso2carbondb h2 database.
Touched, not typed. Erroneous words are a feature, not a typo. On Dec 16, 2014 6:55 AM, "Martin Eppel (meppel)" <mep...@cisco.com> wrote: > 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 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist -schema > change ? > > > > 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=? > > [2014-12-16 01:01:29,146] ERROR > {org.wso2.carbon.identity.oauth.dao.OAuthAppDAO} - *Table > "IDN_OAUTH_CONSUMER_APPS" not found; SQL statement:* > > SELECT * FROM IDN_OAUTH_CONSUMER_APPS WHERE USERNAME=? AND TENANT_ID=? AND > APP_NAME=? [42102-140] > > org.h2.jdbc.JdbcSQLException: Table "IDN_OAUTH_CONSUMER_APPS" not found; > SQL statement: > > SELECT * FROM IDN_OAUTH_CONSUMER_APPS WHERE USERNAME=? AND TENANT_ID=? AND > APP_NAME=? [42102-140] > > > > Did we update the H2 database with the OAuth modification? > > > > Thanks > > > > On Mon, Dec 15, 2014 at 10:47 AM, Udara Liyanage <ud...@wso2.com> wrote: > > 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 10:05 AM, Udara Liyanage <ud...@wso2.com> wrote: > > 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) <mep...@cisco.com> > wrote: > > [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 new > schema when stratos is installed or is it applied automatically when > stratos starts up the first time ? * > > *TID: [0] [STRATOS] [2014-12-12 22:45:38,977] DEBUG > {org.apache.stratos.autoscaler.client.oAuthAdminServiceClient} - Trying to > register oAuth application [test_app_10.6391721987360338] > {org.apache.stratos.autoscaler.client.oAuthAdminServiceClient}* > > *TID: [0] [STRATOS] [2014-12-12 22:45:39,038] INFO > {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} - > 'admin@carbon.super [-1234]' logged in at [2014-12-12 22:45:39,037+0000] > {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil}* > > *TID: [0] [STRATOS] [2014-12-12 22:45:39,061] 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=? {org.wso2.carbon.identity.oauth.dao.OAuthAppDAO}* > > *TID: [0] [STRATOS] [2014-12-12 22:45:39,061] ERROR > {org.wso2.carbon.identity.oauth.dao.OAuthAppDAO} - Table > 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist > {org.wso2.carbon.identity.oauth.dao.OAuthAppDAO}* > > *com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist* > > * at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method)* > > * at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)* > > * at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)* > > * at > java.lang.reflect.Constructor.newInstance(Constructor.java:526)* > > * at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)* > > * at com.mysql.jdbc.Util.getInstance(Util.java:384)* > > * at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:105* > > > > > > > > > > *From:* Reka Thirunavukkarasu [mailto:r...@wso2.com] > *Sent:* Friday, December 12, 2014 8:42 PM > *To:* dev > *Subject:* Re: [Testing] Stratos 4.1.0 Alpha - error deploying cartridge > > > > Hi Martin, > > > > You can find the latest updated samples in > https://github.com/rekathiru/grouping-samples.git > > > > Thanks, > > Reka > > > > On Sat, Dec 13, 2014 at 9:58 AM, Lakmal Warusawithana <lak...@wso2.com> > wrote: > > Yes, its is used in the UI constructions. This was there earlier with > under property called provider, and it has changed it to category and looks > like made it mandatory. > > > > On Sat, Dec 13, 2014 at 8:24 AM, Imesh Gunaratne <im...@apache.org> wrote: > > AFAIK still cartridge category is still not used for any decision making. > This might be useful in the UI when constructing an application. > > > > On Sat, Dec 13, 2014 at 5:49 AM, Martin Eppel (meppel) <mep...@cisco.com> > wrote: > > How is it (field category) being used ? > > > > *From:* Dakshika Jayathilaka [mailto:daksh...@wso2.com] > *Sent:* Friday, December 12, 2014 4:17 PM > *To:* dev > *Subject:* Re: [Testing] Stratos 4.1.0 Alpha - error deploying cartridge > > > > Hi Martin, > > > > Cartridge category is use to identify types of the cartridge. Currently > there are four types of cartridges. > > > > 1. Application > 2. Framework > 3. Data > 4. LB > > Thank you, > > > > Regards, > > > > *Dakshika Jayathilaka* > > Software Engineer > > WSO2, Inc. > > lean.enterprise.middleware > > 0771100911 > > > > On Sat, Dec 13, 2014 at 4:46 AM, Martin Eppel (meppel) <mep...@cisco.com> > wrote: > > Adding “category” : “Application” to the cartridge definition fixed the > cartridge exception. > > > > Now I am hitting the next one - 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 new > schema when stratos is installed or is it applied when stratos starts up > the first time ? > > > > Thanks > > > > Martin > > > > > > TID: [0] [STRATOS] [2014-12-12 22:45:38,977] DEBUG > {org.apache.stratos.autoscaler.client.oAuthAdminServiceClient} - Trying to > register oAuth application [test_app_10.6391721987360338] > {org.apache.stratos.autoscaler.client.oAuthAdminServiceClient} > > TID: [0] [STRATOS] [2014-12-12 22:45:39,038] INFO > {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} - > 'admin@carbon.super [-1234]' logged in at [2014-12-12 22:45:39,037+0000] > {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} > > TID: [0] [STRATOS] [2014-12-12 22:45:39,061] 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=? {org.wso2.carbon.identity.oauth.dao.OAuthAppDAO} > > TID: [0] [STRATOS] [2014-12-12 22:45:39,061] ERROR > {org.wso2.carbon.identity.oauth.dao.OAuthAppDAO} - Table > 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist > {org.wso2.carbon.identity.oauth.dao.OAuthAppDAO} > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) > > at com.mysql.jdbc.Util.getInstance(Util.java:384) > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:105 > > > > *From:* Martin Eppel (meppel) > *Sent:* Friday, December 12, 2014 12:55 PM > *To:* dev@stratos.apache.org > *Subject:* RE: [Testing] Stratos 4.1.0 Alpha - error deploying cartridge > > > > With the latest code from the master I get the exception below when I try > to deploy a cartridge, what is “Category is not specified” - what is > missing ? > > > > Also, seems like RestAPI’s got changed again (autoscaler) – it would be > great if we could stabilize and freeze them, > > > > Thanks > > > > Martin > > > > TID: [0] [STRATOS] [2014-12-12 20:49:52,607] INFO > {org.apache.stratos.rest.endpoint.api.StratosApiV41Utils} - Starting to > deploy a cartridge [type] cisco-sample-vm > {org.apache.stratos.rest.endpoint.api.StratosApiV41Utils} > > TID: [0] [STRATOS] [2014-12-12 20:49:52,608] ERROR > {org.apache.stratos.rest.endpoint.handlers.CustomExceptionMapper} *- > Category is not specified, cartridge deployment failed* > {org.apache.stratos.rest.endpoint.handlers.CustomExceptionMapper} > > org.apache.stratos.rest.endpoint.exception.RestAPIException: Category is > not specified, cartridge deployment failed > > at > org.apache.stratos.rest.endpoint.api.StratosApiV41Utils.createCartridgeDefinition(StratosApiV41Utils.java:98) > > at > org.apache.stratos.rest.endpoint.api.StratosApiV41.createCartridgeDefinition(StratosApiV41.java:147) > > > > > > > -- > > Imesh Gunaratne > > > > Technical Lead, WSO2 > > Committer & PMC Member, Apache Stratos > > > > > -- > > Lakmal Warusawithana > > Vice President, Apache Stratos > > Director - Cloud Architecture; WSO2 Inc. > > Mobile : +94714289692 > > Blog : http://lakmalsview.blogspot.com/ > > > > > -- > > Reka Thirunavukkarasu > Senior Software Engineer, > WSO2, Inc.:http://wso2.com, > > Mobile: +94776442007 > > > > > > > -- > > > Udara Liyanage > > Software Engineer > > WSO2, Inc.: http://wso2.com > > lean. enterprise. middleware > > web: http://udaraliyanage.wordpress.com > > phone: +94 71 443 6897 > > > > > -- > > > Udara Liyanage > > Software Engineer > > WSO2, Inc.: http://wso2.com > > lean. enterprise. middleware > > web: http://udaraliyanage.wordpress.com > > phone: +94 71 443 6897 > > > > > -- > > Imesh Gunaratne > > > > Technical Lead, WSO2 > > Committer & PMC Member, Apache Stratos >