tools/stratos-installer/resources /application-sql.mysql was missing in the 4.1.0-test branch so I added it
From: Imesh Gunaratne [mailto:[email protected]] 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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> 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) <[email protected]<mailto:[email protected]>> 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} - '[email protected] [-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:[email protected]<mailto:[email protected]>] 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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> 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) <[email protected]<mailto:[email protected]>> wrote: How is it (field category) being used ? From: Dakshika Jayathilaka [mailto:[email protected]<mailto:[email protected]>] 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<tel:0771100911> On Sat, Dec 13, 2014 at 4:46 AM, Martin Eppel (meppel) <[email protected]<mailto:[email protected]>> 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} - '[email protected] [-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: [email protected]<mailto:[email protected]> 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<tel:%2B94714289692> Blog : http://lakmalsview.blogspot.com/ -- Reka Thirunavukkarasu Senior Software Engineer, WSO2, Inc.:http://wso2.com, Mobile: +94776442007<tel:%2B94776442007> -- Udara Liyanage Software Engineer WSO2, Inc.: http://wso2.com<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<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
