[Fiware-tech-help] SpagoBI data Sets disappear | IdM Login | Fiware Accelerator Programme

[Richard Banyi]

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:


# Informations about OAuth2 application
CLIENT_ID = <Client_ID>
SECRET = <Client_Secret>

# 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>

# 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>

# 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20170116/15c5394c/attachment.html>