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]
-=-=-=-=-=-=-=-=-=-=-=-

Reply via email to