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-
> Packaged+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+
> Identity+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
>
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
