Hello Guys,

I would like to kindly ask you to help me out with 2 problems:

1. SpagoBI data Sets Disappear - I managed to successfully connect to my own database. Data Set type: Query, I am able to see my data set in the Preview tab, I can even successfully save it. But After I leave the Data Sets views and come back it’s not there anymore and when I try to create a new one with the same name it says that this data set with the given name already exists. However it is not there. Even when a I search for it. Could you please help me out?

this is the configuration of my JDBC datasource

<Resource name=“jdbc/my_db" auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/my_db <postgresql://localhost:5432/my_db>"
username=“user_name"
password=“password"
maxActive="20" maxIdle="10"
maxWait="-1”/>

I have also define a new JNDI datasource with JNDI name “java:comp/env/jdbc/my_db”

2. Configuration with the IdM - KeyRock - I have done everything according to this tutorial https://github.com/SpagoBILabs/SpagoBI/tree/master/doc/admin <https://github.com/SpagoBILabs/SpagoBI/tree/master/doc/admin>
I have created and account and application I have configured it as it says in the tutorial I have my Cliend ID and Client Secret I have also created the new role /spagobi/admin. In SpagoBI have change these settings

SPAGOBI_SSO.ACTIVE = true
SPAGOBI.SECURITY.PORTAL-SECURITY-CLASS.className = it.eng.spagobi.security.OAuth2SecurityInfoProvider
SPAGOBI.SECURITY.USER-PROFILE-FACTORY-CLASS.className = it.eng.spagobi.security.OAuth2SecurityServiceSupplier
SPAGOBI_SSO.SECURITY_LOGOUT_URL = https://account.lab.fiware.org <https://account.lab.fiware.org/>
I have edited the SPAGOBI_SERVER_HOME/conf/server.xml

<Environment name="spagobi_sso_class" type="java.lang.String"
value="it.eng.spagobi.services.oauth2.Oauth2SsoService"/>
and then SPAGOBI_SERVER_HOME/webapps/SpagoBI/WEB-INF/web.xml

<!-- START OAUTH 2 -->
<filter>
<filter-name>OAuthFilter</filter-name>
<filter-class>it.eng.spagobi.security.oauth2.OAuth2Filter</filter-class>
</filter>
<!-- END OAUTH 2 -->

<!-- START OAUTH 2 -->
<filter-mapping>
<filter-name>OAuthFilter</filter-name>
<url-pattern>/servlet/AdapterHTTP/*</url-pattern>
</filter-mapping>
<!-- END OAUTH 2 -->

At this point I had everything configured. The I have tried to edit the :
SPAGOBI_SERVER_HOME/webapps/SpagoBI/WEB-INF/classes/oauth2.config.properties
however this files wasn’t in the classes directory so I have created it manually and configured it just like this:

1. Informations about OAuth2 application
   CLIENT_ID = <Client_ID>
   SECRET = <Client_Secret>

1. OAuth2 urls
   AUTHORIZE_URL = https://account.lab.fiware.org/oauth2/authorize <https://account.lab.fiware.org/oauth2/authorize>
   ACCESS_TOKEN_URL = https://account.lab.fiware.org/oauth2/token <https://account.lab.fiware.org/oauth2/token>
   USER_INFO_URL = https://account.lab.fiware.org/user <https://account.lab.fiware.org/user>
   REDIRECT_URI = http://localhost:8080/SpagoBI/servlet/AdapterHTTP?PAGE=LoginPage&NEW_SESSION=TRUE <http://localhost:8080/SpagoBI/servlet/AdapterHTTP?PAGE=LoginPage&NEW_SESSION=TRUE>

1. REST API urls
   REST_BASE_URL = http://cloud.lab.fiware.org:4730/v3/ <http://cloud.lab.fiware.org:4730/v3/>
   TOKEN_PATH = auth/tokens
   ROLES_PATH = OS-ROLES/roles
   ORGANIZATIONS_LIST_PATH = OS-ROLES/organizations/role_assignments
   ORGANIZATION_INFO_PATH = projects/

APPLICATION_ID = <application_id>

1. Admin credentials
   ADMIN_ID = <I couldn’t find this ID not event in the URL according to the tutorial so therefore I have put there my username>

ADMIN_ID is the id of the administrator on IdM. To obtain it, open the user page on the IdM (by clicking on the name of the user on the top right part of the page) and and look at the browser URL (for example, in FIWARE Lab instance, if your user page's URL is https://account.lab.fiware.org/idm/users/id_number/ <https://account.lab.fiware.org/idm/users/id_number/>, the ADMIN_ID is "id_number")

ADMIN_EMAIL = <my email with whome I have register to the accout https://account.lab.fiware.org <https://account.lab.fiware.org/>>
ADMIN_PASSWORD = <password>

The problem is that I can’t login in with IdM I encounted User or password invalid, Retry! <http://localhost:8080/SpagoBI/servlet/AdapterHTTP?LIGHT_NAVIGATOR_BACK_TO=1> error therefore I am not sure if the ADMIN_ID is wrong or where could be the problem?

I would appreciate any relevant help,

Thank you,

Richard
payowallet
__________________________________________________________________________________________

You can get more information about our cookies and privacy policies on the following links:

• http://forge.fiware.org/plugins/mediawiki/wiki/fiware/index.php/FIWARE_Privacy_Policy
• http://forge.fiware.org/plugins/mediawiki/wiki/fiware/index.php/Cookies_Policy_FIWARE

Fiware-tech-help mailing list
Fiware-tech-help@lists.fiware.org
https://lists.fiware.org/listinfo/fiware-tech-help

[Created via e-mail received from: Richard Banyi <banyi@payowallet.com>]