Looks like portal is throwing an error in SB06
2018-11-07T15:57:29.035Z|941fe7df-7920-4c9d-9591-7ab8259b496e|http-nio-8443-exec-10|ECOMP_PORTAL_BE|Unknown|||||||
Keyspace portal does not exist
2018-11-07T15:57:29.035Z|941fe7df-7920-4c9d-9591-7ab8259b496e|http-nio-8443-exec-10|ECOMP_PORTAL_BE|Unknown|||||||
org.onap.music.main.MusicCore - Keyspace portal does not exist
2018-11-07T15:57:29.036Z|941fe7df-7920-4c9d-9591-7ab8259b496e|http-nio-8443-exec-10|ECOMP_PORTAL_BE|Unknown|||||||
getMaxInactiveInterval failed with id c71681e3~2d8a~4809~a033~978a21bfdd70
org.onap.music.exceptions.MusicServiceException: Keyspace portal does not exist
at org.onap.music.main.MusicCore.get(MusicCore.java:717)
at
org.onap.portalapp.music.service.MusicService.getAttribute(MusicService.java:231)
at
org.onap.portalapp.music.conf.MusicSession.getMaxInactiveInterval(MusicSession.java:247)
at
org.onap.portalapp.music.service.MusicService.setMetaAttribute(MusicService.java:144)
at
org.onap.portalapp.music.conf.MusicSessionRepositoryHandler.put(MusicSessionRepositoryHandler.java:97)
at
org.onap.portalapp.music.conf.MusicSessionRepository.save(MusicSessionRepository.java:104)
at
org.onap.portalapp.music.conf.MusicSessionRepository.save(MusicSessionRepository.java:63)
at
org.springframework.session.web.http.SessionRepositoryFilter$SessionRepositoryRequestWrapper.commitSession(SessionRepositoryFilter.java:228)
at
org.springframework.session.web.http.SessionRepositoryFilter$SessionRepositoryRequestWrapper.access$100(SessionRepositoryFilter.java:196)
at
org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:149)
at
org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:81)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
From: [email protected] <[email protected]> On Behalf Of
Ukponmwan, Itohan
Sent: Tuesday, November 06, 2018 7:54 PM
To: [email protected]
Subject: [onap-discuss] Cannot Login to ONAP Portal
Hi All,
I have deployed ONAP OOM on Integration-SB-06 in Windriver lab. When I try to
login to the ONAP portal, I get the following error;
Invalid username or password. Please try again.
So far, I have tried using the users demo, cs0008 and op0001 all with the
password demo123456!
Does anyone know how to fix this error?
As part of my troubleshooting I have tried querying the portal db to confirm
the users are there using the following;
kubectl exec -it -n onap dev-portal-portal-db-86ccccf7bf-8kc28 -- /bin/bash
mysql -u root -p
MariaDB [(none)]> USE portal;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [portal]> SELECT first_name, org_user_id, email FROM fn_user;
+------------+-------------+--------------------+
| first_name | org_user_id | email |
+------------+-------------+--------------------+
| Demo | demo | [email protected]<mailto:[email protected]> |
| Jimmy | jh0003 | [email protected]<mailto:[email protected]> |
| Carlos | cs0008 | [email protected]<mailto:[email protected]> |
| Joni | jm0007 | [email protected]<mailto:[email protected]> |
| Steve | op0001 | [email protected]<mailto:[email protected]> |
| David | gv0001 | [email protected]<mailto:[email protected]> |
| Teddy | pm0001 | [email protected]<mailto:[email protected]> |
| Eden | ps0001 | [email protected]<mailto:[email protected]> |
| vid1 | vid1 | [email protected]<mailto:[email protected]> |
| vid2 | vid2 | [email protected]<mailto:[email protected]> |
| vid3 | vid3 | [email protected]<mailto:[email protected]> |
| steve | steve | [email protected]<mailto:[email protected]> |
+------------+-------------+--------------------+
12 rows in set (0.000 sec)
When I do a show on the portal configmap, I see the following in the data;
kubectl get configmap dev-portal-portal-app-onapportal -n onap -o yaml
apiVersion: v1
data:
fusion.properties: "# Copyright (c) 2018 Amdocs, Bell Canada, AT&T\n#
Modifications
Copyright (c) 2018 AT&T\n#\n# Licensed under the Apache License, Version
2.0 (the
\"License\");\n# you may not use this file except in compliance with the
License.\n#
You may obtain a copy of the License at\n#\n#
http://www.apache.org/licenses/LICENSE-2.0<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.apache.org_licenses_LICENSE-2D2.0&d=DwQFAg&c=LFYZ-o9_HUMeMTSQicvjIg&r=e3d1ehx3DI5AoMgDmi2Fzw&m=FL_u-JnxQAdTe-c7AAzSMqcU6u1jFWC8Ry5GJbBltj8&s=VmH1--h34qJMsn_0YGezpbESF7I3ajpNNu17GdJthgA&e=>\n#\n#
Unless required by applicable law or agreed to in writing, software\n#
distributed
under the License is distributed on an \"AS IS\" BASIS,\n# WITHOUT
WARRANTIES
OR CONDITIONS OF ANY KIND, either express or implied.\n# See the License
for the
specific language governing permissions and\n# limitations under the
License.\n\n#
domain settings\n#domain_class_location =\n\n# validator
settings\n#default_error_message
= Default error message\n\nlogin_url_no_ret_val =
http://portal.api.simpledemo.onap.org:8989/ONAPPORTAL/login.htm<https://urldefense.proofpoint.com/v2/url?u=http-3A__portal.api.simpledemo.onap.org-3A8989_ONAPPORTAL_login.htm&d=DwQFAg&c=LFYZ-o9_HUMeMTSQicvjIg&r=e3d1ehx3DI5AoMgDmi2Fzw&m=FL_u-JnxQAdTe-c7AAzSMqcU6u1jFWC8Ry5GJbBltj8&s=6X7Uen1lSGBhrmMt4OD0A7eVDMBvmyRxSxpgN8xBids&e=>\n\nuser_attribute_name
\ = user\n\n# User Session settings\nroles_attribute_name =
roles\nrole_functions_attribute_name
= role_functions\n\n# menu settings\nmenu_query_name =
menuData\napplication_menu_set_name
\ = APP\napplication_menu_attribute_name =
applicationMenuData\nbusiness_direct_menu_set_name
\ = BD\nbusiness_direct_menu_attribute_name =
businessDirectMenuData\n\n#
ECOMP settings\necomp_app_id = 1\n# Role settings\nsys_admin_role_id =
1\naccount_admin_role_id
= 999\nrestricted_app_role_id = 900\n\n# Home Page index html\nhome_page
\t\t\t\t\t=
/index.html\n\nauthentication_mechanism =DBAUTH\n\nlogin.error.hrid.empty =
Login
failed, please contact system administrator.\nlogin.error.hrid.not-found =
User
not found, please contact system administrator.\nlogin.error.user.inactive
= Account
is disabled, please contact system administrator.\n\n#\n# Number of seconds
to
poll health (database operational, etc.)\n#\nhealth_poll_interval_seconds =
5\n#\n#
If a component is down a log entry will be written that triggers an alert.
This
parameter specifies how often this alert should be triggered\n# if the
component
remains down. For example a value of 30, would translate to 30 * 60
seconds
= 1800 seconds, or every 30 minutes\n#\nhealth_fail_alert_every_x_intervals
=
\ 30\n"
Thanks,
Itohan
-=-=-=-=-=-=-=-=-=-=-=-
Links: You receive all messages sent to this group.
View/Reply Online (#13588): https://lists.onap.org/g/onap-discuss/message/13588
Mute This Topic: https://lists.onap.org/mt/28023831/21656
Group Owner: [email protected]
Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub
[[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-
