Sunder is looking - Are you on rocket.chat : integration Itohan ? Brian
From: FREEMAN, BRIAN D Sent: Wednesday, November 07, 2018 10:59 AM To: onap-discuss@lists.onap.org; itohan.ukponm...@intel.com Subject: MUSIC/PORTAL problem (Keyspace portal does not exist) -> RE: Cannot Login to ONAP Portal 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: onap-discuss@lists.onap.org<mailto:onap-discuss@lists.onap.org> <onap-discuss@lists.onap.org<mailto:onap-discuss@lists.onap.org>> On Behalf Of Ukponmwan, Itohan Sent: Tuesday, November 06, 2018 7:54 PM To: onap-discuss@lists.onap.org<mailto:onap-discuss@lists.onap.org> 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 | d...@openecomp.org<mailto:d...@openecomp.org> | | Jimmy | jh0003 | ad...@onap.org<mailto:ad...@onap.org> | | Carlos | cs0008 | desig...@onap.org<mailto:desig...@onap.org> | | Joni | jm0007 | tes...@onap.org<mailto:tes...@onap.org> | | Steve | op0001 | o...@onap.org<mailto:o...@onap.org> | | David | gv0001 | gover...@onap.org<mailto:gover...@onap.org> | | Teddy | pm0001 | p...@onap.org<mailto:p...@onap.org> | | Eden | ps0001 | p...@onap.org<mailto:p...@onap.org> | | vid1 | vid1 | v...@onap.org<mailto:v...@onap.org> | | vid2 | vid2 | v...@onap.org<mailto:v...@onap.org> | | vid3 | vid3 | v...@onap.org<mailto:v...@onap.org> | | steve | steve | st...@onap.org<mailto:st...@onap.org> | +------------+-------------+--------------------+ 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 (#13589): https://lists.onap.org/g/onap-discuss/message/13589 Mute This Topic: https://lists.onap.org/mt/28023831/21656 Group Owner: onap-discuss+ow...@lists.onap.org Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [arch...@mail-archive.com] -=-=-=-=-=-=-=-=-=-=-=-