Hi Imesh,

I will fix and let you know, so you can un comment it.

On Tue, Dec 16, 2014 at 9:04 AM, Imesh Gunaratne <im...@apache.org> wrote:
>
> 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
>


-- 

Udara Liyanage
Software Engineer
WSO2, Inc.: http://wso2.com
lean. enterprise. middleware

web: http://udaraliyanage.wordpress.com
phone: +94 71 443 6897

Reply via email to