You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Nahappan Somasundaram (JIRA)" <ji...@apache.org> on 2016/06/21 18:46:58 UTC
[jira] [Created] (AMBARI-17350) If two users are created differing
in case then no users are shown due to error
Nahappan Somasundaram created AMBARI-17350:
----------------------------------------------
Summary: If two users are created differing in case then no users are shown due to error
Key: AMBARI-17350
URL: https://issues.apache.org/jira/browse/AMBARI-17350
Project: Ambari
Issue Type: Bug
Components: ambari-server
Affects Versions: 2.4.0
Reporter: Nahappan Somasundaram
Assignee: Nahappan Somasundaram
Priority: Critical
Fix For: 2.4.0
When usernames that differ only by case are created, no users are show in the when clicking the Users link in Ambari Management page due to the following error.
The fix is to block creating usernames that differ only by case.
{code}
12 Jun 2016 03:59:28,569 WARN [ambari-client-thread-559] ServletHandler:628 - /api/v1/users/
javax.persistence.NonUniqueResultException: More than one result was returned from Query.getSingleResult()
at org.eclipse.persistence.internal.jpa.QueryImpl.throwNonUniqueResultException(QueryImpl.java:980)
at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:529)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:400)
at org.apache.ambari.server.orm.dao.UserDAO.findUserByName(UserDAO.java:69)
at org.apache.ambari.server.orm.AmbariLocalSessionInterceptor.invoke(AmbariLocalSessionInterceptor.java:53)
at org.apache.ambari.server.controller.internal.ActiveWidgetLayoutResourceProvider.getResources(ActiveWidgetLayoutResourceProvider.java:161)
at org.apache.ambari.server.controller.internal.ClusterControllerImpl$ExtendedResourceProviderWrapper.queryForResources(ClusterControllerImpl.java:966)
at org.apache.ambari.server.controller.internal.ClusterControllerImpl.getResources(ClusterControllerImpl.java:141)
at org.apache.ambari.server.api.query.QueryImpl.doQuery(QueryImpl.java:512)
at org.apache.ambari.server.api.query.QueryImpl.queryForSubResources(QueryImpl.java:464)
...
{code}
{code}
select * from users ;
***(press return to proceed or enter x and return to cancel)********************
user_id | principal_id | ldap_user | user_name | user_type | create_time | user_password | active | active
_widget_layouts
---------+--------------+-----------+-----------+-----------+----------------------------+----------------------------------------------------------------------------------+--------+-------
----------------
1 | 1 | 0 | admin | LOCAL | 2016-06-11 16:08:51.300678 | 538916f8943ec225d97a9a86a2c6ec0818c1cd400e09e03b660fdaaec4af29ddbb6f2b1033b81b00 | 1 | [{"id"
:"6"}]
3 | 14 | 0 | Abcd | LOCAL | 2016-06-12 03:58:38.944 | ee677dc216a63092fd1e4dbb56c3661dcca0053feae5968bdf82e15cb95e9b83747f1b7d25c3badc | 1 |
4 | 15 | 0 | abcd | LOCAL | 2016-06-12 03:58:49.32 | f941a9570f1b42f2f74b164e9e419fb7d63660681e3ccd9e9313f0369c6d5d03e3249fcfc1fd835e | 1 |
(3 rows)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)