Davide Zerbetto added a comment - 16/Jan/17 5:25 PM The issue has been emailed: Time sent: 16/Jan/17 5:25 PM To: banyi@payowallet.com Cc: davide.zerbetto@eng.it with subject: Reply Hi 1. dataset problem: may be there is a problem when displaying datasets' list, do you see any error within browser's web console? 2. authentication problem: when invoking SpagoBI you should be redirected to IdM login page, isn't it? do you see any error in log files? Best regards

FW External User added a comment - 24/Jan/17 12:08 PM Comment by banyi@payowallet.com : Hello, 1) I don’t see any error in the console not even in the web console. 2) Well I have managed to redirect to IdM https://account.lab.fiware.org/oauth2/authorize/?response_type=code&client_id=481e754fc078463eb812c0c72c951efb&redirect_uri=http%3A%2F%2Flocalhost%3A8080%2FSpagoBI%2Fservlet%2FAdapterHTTP%3FPAGE%3DLoginPage%26NEW_SESSION%3DTRUE < https://account.lab.fiware.org/oauth2/authorize/?response_type=code&client_id=481e754fc078463eb812c0c72c951efb&redirect_uri=http://localhost:8080/SpagoBI/servlet/AdapterHTTP?PAGE=LoginPage&NEW_SESSION=TRUE > this is the URL/CALLBACK URL http://127.0.0.1:8080/SpagoBI/servlet/AdapterHTTP?PAGE=LoginPage&NEW_SESSION=TRUE this is the response: {"state": "None", "error": "mismatching_redirect_uri"} (HTTP 400) Error: An error occurred when trying to obtainthe authorization code. So therefore I am asking you again is this configuration right? What could be the problem now? Informations about OAuth2 application CLIENT_ID = 481e754fc078463eb812c0c72c951efb SECRET = 73ec391140144fbaa34d11e7d6300db6 OAuth2 urls AUTHORIZE_URL = https://account.lab.fiware.org/oauth2/authorize ACCESS_TOKEN_URL = https://account.lab.fiware.org/oauth2/token USER_INFO_URL = https://account.lab.fiware.org/user REDIRECT_URI = http://localhost:8080/SpagoBI/servlet/AdapterHTTP?PAGE=LoginPage&NEW_SESSION=TRUE REST API urls REST_BASE_URL = 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 = 481e754fc078463eb812c0c72c951efb Admin credentials ADMIN_ID = what should be here? I don’t see any ID in my profile URI only https://account.lab.fiware.org/idm/users/richban/ < https://account.lab.fiware.org/idm/users/richban/ > ADMIN_EMAIL = banyi@payowallet.com ADMIN_PASSWORD = password > On 16 Jan 2017, at 17:26, Help-Desk <jira-help-desk@jira.fiware.org> wrote: > > Hi > 1. dataset problem: may be there is a problem when displaying datasets' list, do you see any error within browser's web console? > 2. authentication problem: when invoking SpagoBI you should be redirected to IdM login page, isn't it? do you see any error in log files? > Best regards > > ------------------------------------------------------------------------------- > Davide Zerbetto created HELP-8123 : > ------------------------------------- > > Summary: [Fiware-tech-help] SpagoBI data Sets disappear | IdM Login | Fiware Accelerator Programme > Key: HELP-8123 > URL: https://jira.fiware.org/browse/HELP-8123 > Project: Help-Desk > Issue Type: extRequest > Components: FIWARE-TECH-HELP > Reporter: FW External User > Assignee: Davide Zerbetto > > > 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 >

Davide Zerbetto added a comment - 07/Mar/17 6:52 PM The issue has been emailed: Time sent: 07/Mar/17 6:52 PM To: banyi@payowallet.com Cc: davide.zerbetto@eng.it,alessandro.portosa@eng.it with subject: Reply Dear Richard 1. when loading the datasets' list, can you see any error in log files? those files are located within <SpagoBI_HOME>/logs folder 2. I noticed that you wrote both http://127.0.0.1 ... and http://localhost ... as callback/redirect URL, please consider that you should always use just 1 callback URL. Could you please verify this and use just one? Best regards Davide