Hi Udara, I have temporarily commented out the token generation logic since this is a blocker for the on going work. Once you fix the H2 database, please add it back.
Thanks On Tue, Dec 16, 2014 at 7:28 AM, Udara Liyanage <ud...@wso2.com> wrote: > > 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 >> > -- Imesh Gunaratne Technical Lead, WSO2 Committer & PMC Member, Apache Stratos