stratos-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Martin Eppel (meppel)" <mep...@cisco.com>
Subject [Testing] Stratos 4.1.0 Alpha - database error deploying cartridge - Table 'userstore.IDN_OAUTH_CONSUMER_APPS' doesn't exist -schema change ?
Date Mon, 15 Dec 2014 04:20:42 GMT
[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:reka@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 <lakmal@wso2.com<mailto:lakmal@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 <imesh@apache.org<mailto:imesh@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) <meppel@cisco.com<mailto:meppel@cisco.com>>
wrote:
How is it (field category) being used ?

From: Dakshika Jayathilaka [mailto:dakshika@wso2.com<mailto:dakshika@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<tel:0771100911>

On Sat, Dec 13, 2014 at 4:46 AM, Martin Eppel (meppel) <meppel@cisco.com<mailto:meppel@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<mailto: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<tel:%2B94714289692>
Blog : http://lakmalsview.blogspot.com/


--
Reka Thirunavukkarasu
Senior Software Engineer,
WSO2, Inc.:http://wso2.com,
Mobile: +94776442007

Mime
View raw message