Hi Thomas,
Can you also check the value[1] in identity.xml(repository/conf/identity)
of Identity server. It should be as "jdbc/WSO2AM_DB"
<DataSource>
<!-- Include a data source name (jndiConfigName) from the set
of data
sources defined in master-datasources.xml -->
<Name>jdbc/WSO2AM_DB</Name>
</DataSource>
On Thu, Jun 15, 2017 at 2:04 PM, Thomas LEGRAND <
[email protected]> wrote:
> Hello Rajith,
>
> Thank you for your answer, too :)
>
> I re-checked my datasources and I have the same URL in both sides (IS and
> AM) for the WSO2AM_DB, WSO2REG_DB and WSO2UM_DB. So, maybe I did something
> wrong in another configuration file? Here are my master-datasources.xml for
> both side, if you want to take a look. I am using H2 in remote mode:
>
> IS datasources:
>
> <datasource>
> <name>WSO2_CARBON_DB</name>
> <description>The datasource used for registry and user
> manager</description>
> <jndiConfig>
> <name>jdbc/WSO2CarbonDB</name>
> </jndiConfig>
> <definition type="RDBMS">
> <configuration>
> <url>jdbc:h2:tcp://localhost/
> D:/ProjetESB/wso2is-5.3.0/repository/database/WSO2CARBON_DB;DB_CLOSE_ON_
> EXIT=FALSE</url>
> <username>wso2carbon</username>
> <password>wso2carbon</password>
> <driverClassName>org.h2.Driver</driverClassName>
> <maxActive>50</maxActive>
> <maxWait>60000</maxWait>
> <testOnBorrow>true</testOnBorrow>
> <validationQuery>SELECT 1</validationQuery>
> <validationInterval>30000</validationInterval>
> </configuration>
> </definition>
> </datasource>
>
> <datasource>
> <name>WSO2AM_DB</name>
> <description>The datasource used for API Manager
> database</description>
> <jndiConfig>
> <name>jdbc/WSO2AM_DB</name>
> </jndiConfig>
> <definition type="RDBMS">
> <configuration>
> <url>jdbc:h2:tcp://localhost/D:/ProjetESB/is_am_db/WSO2AM_
> DB;DB_CLOSE_ON_EXIT=FALSE</url>
> <username>apiuser</username>
> <password>apimanager</password>
> <driverClassName>org.h2.Driver</driverClassName>
> <maxActive>50</maxActive>
> <maxWait>60000</maxWait>
> <testOnBorrow>true</testOnBorrow>
> <validationQuery>SELECT 1</validationQuery>
> <validationInterval>30000</validationInterval>
> </configuration>
> </definition>
> </datasource>
>
> <datasource>
> <name>WSO2REG_DB</name>
> <description>The datasource used for registry</description>
> <jndiConfig>
> <name>jdbc/WSO2REG_DB</name>
> </jndiConfig>
> <definition type="RDBMS">
> <configuration>
> <url>jdbc:h2:tcp://localhost/D:/ProjetESB/is_am_db/WSO2REG_
> DB;DB_CLOSE_ON_EXIT=FALSE</url>
> <username>apiuser</username>
> <password>apimanager</password>
> <driverClassName>org.h2.Driver</driverClassName>
> <maxActive>50</maxActive>
> <maxWait>60000</maxWait>
> <testOnBorrow>true</testOnBorrow>
> <validationQuery>SELECT 1</validationQuery>
> <validationInterval>30000</validationInterval>
> </configuration>
> </definition>
> </datasource>
>
> AM datasources:
>
> <datasource>
> <name>WSO2AM_DB</name>
> <description>The datasource used for API Manager
> database</description>
> <jndiConfig>
> <name>jdbc/WSO2AM_DB</name>
> </jndiConfig>
> <definition type="RDBMS">
> <configuration>
> <!--url>jdbc:h2:tcp://localhost/D:/ProjetESB/wso2is-
> 5.3.0/repository/database/WSO2AM_DB;DB_CLOSE_ON_EXIT=FALSE</url-->
> <url>jdbc:h2:tcp://localhost/D:/ProjetESB/is_am_db/WSO2AM_
> DB;DB_CLOSE_ON_EXIT=FALSE</url>
> <username>apiuser</username>
> <password>apimanager</password>
> <driverClassName>org.h2.Driver</driverClassName>
> <maxActive>50</maxActive>
> <maxWait>60000</maxWait>
> <testOnBorrow>true</testOnBorrow>
> <validationQuery>SELECT 1</validationQuery>
> <validationInterval>30000</validationInterval>
> </configuration>
> </definition>
> </datasource>
> <datasource>
> <name>WSO2REG_DB</name>
> <description>The datasource used for registry</description>
> <jndiConfig>
> <name>jdbc/WSO2REG_DB</name>
> </jndiConfig>
> <definition type="RDBMS">
> <configuration>
> <url>jdbc:h2:tcp://localhost/D:/ProjetESB/is_am_db/WSO2REG_
> DB;DB_CLOSE_ON_EXIT=FALSE</url>
> <username>apiuser</username>
> <password>apimanager</password>
> <driverClassName>org.h2.Driver</driverClassName>
> <maxActive>50</maxActive>
> <maxWait>60000</maxWait>
> <testOnBorrow>true</testOnBorrow>
> <validationQuery>SELECT 1</validationQuery>
> <validationInterval>30000</validationInterval>
> </configuration>
> </definition>
> </datasource>
> <datasource>
> <name>WSO2UM_DB</name>
> <description>The datasource used for user
> management</description>
> <jndiConfig>
> <name>jdbc/WSO2UM_DB</name>
> </jndiConfig>
> <definition type="RDBMS">
> <configuration>
> <url>jdbc:h2:tcp://localhost/D:/ProjetESB/is_am_db/WSO2UM_
> DB;DB_CLOSE_ON_EXIT=FALSE</url>
> <username>apiuser</username>
> <password>apimanager</password>
> <driverClassName>org.h2.Driver</driverClassName>
> <maxActive>50</maxActive>
> <maxWait>60000</maxWait>
> <testOnBorrow>true</testOnBorrow>
> <validationQuery>SELECT 1</validationQuery>
> <validationInterval>30000</validationInterval>
> </configuration>
> </definition>
> </datasource>
>
>
> And maybe that will fix some problem I have in the store in API manager
> concerning the error message (Error! You have partially created keys.
> Please click the Clean Up button and try again). But that is another
> problem :)
>
> Regards,
>
> Thomas
>
> 2017-06-15 7:12 GMT+02:00 Rajith Roshan <[email protected]>:
>
>> Hi Thomas,
>>
>> Instead of configuring IS as key manager , you can use the pre packed IS
>> 5.3.0[1]. Using this pre packed IS is lot easier.
>>
>> [1] - https://docs.wso2.com/display/AM210/Configuring+the+Pre-Pa
>> ckaged+Identity+Server+with+API+Manager
>>
>> On Wed, Jun 14, 2017 at 6:12 PM, Thomas LEGRAND <
>> [email protected]> wrote:
>>
>>> Hello everybody,
>>>
>>> I have a little problem. I used the Identity Server (IS) in standalone
>>> where I configured a service provider and a AD user store. Everything
>>> worked perfectly.
>>>
>>> Then, I followed the procedure written in the document in [1] to make
>>> the API manager use the OAuth token generated by the IS. But, many wild
>>> problems appear:
>>>
>>> - First, when I connect to the IS, I can see my user store but I can't
>>> see my service provider anymore. Where can I find it?
>>> - Then, I try to recreate my service provider with the same name and I
>>> have a popup which appears saying:" Error while creating application role:
>>> Application/<NAME_HERE> with user admin"
>>> - At last, I try to recreate a service provider with another name and I
>>> can configre the SAML thing. So I type the same issuer name and continue
>>> the configuration until I click on the update button. And BOOM. Another
>>> popup appears telling me that "Could not add Service Provider. You might be
>>> entering a duplicate Service Provider". I assume that it is linked to the
>>> second point, here :(
>>>
>>> I noticed in the default database located in
>>> D:\ProjetESB\wso2is-5.3.0\repository\database\WSO2CARBON_DB.h2.db there
>>> is a table SP_APP which contained the declaration of my provider. But I
>>> don't know where to find its configuration.
>>>
>>
>> When you share the database between APIM and IS then data is not stored
>> in the h2 database. It's stored in the AM_DB (for ex : jdbc/WSO2AM_DB
>> which is mentioned in the doc[2])
>>
>>>
>>> Can you help me, please?
>>>
>>> [1] https://docs.wso2.com/display/AM210/Configuring+WSO2+Identit
>>> y+Server+as+a+Key+Manager
>>>
>> [2] - https://docs.wso2.com/display/AM210/Configuring+WSO2+Identit
>> y+Server+as+a+Key+Manager
>>
>>>
>>>
>>> _______________________________________________
>>> Dev mailing list
>>> [email protected]
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>> Thanks!
>> Rajith
>>
>>
>> --
>> Rajith Roshan
>> Software Engineer, WSO2 Inc.
>> Mobile: +94-7 <%2B94-71-554-8430>17-064-214
>>
>
>
--
Rajith Roshan
Software Engineer, WSO2 Inc.
Mobile: +94-7 <%2B94-71-554-8430>17-064-214
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
