[ 
https://issues.apache.org/jira/browse/RANGER-2021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sean Roberts updated RANGER-2021:
---------------------------------
    Description: 
"Ranger User Sync" logs into Ranger multiple times a second. This is with:
{code}
ranger.usersync.source.impl.class=org.apache.ranger.unixusersync.process.UnixUserGroupBuilder
ranger.usersync.unix.backend=nss
{code}

The high number and rate of these sessions makes it impossible to use the 
"Login Sessions" audit page:

Further, it's adding a lot of extra requests and overhead to Ranger, Ranger 
User Sync, and the backing database (e.g. MySQL).

*The service should re-use its session rather than continual logins.*

!screenshot-1.png|width=640!

{code}
$ rpm -qa *usersync*
ranger_2_6_4_0_91-usersync-0.7.0.2.6.4.0-91.x86_64
{code}

  was:
"Ranger User Sync" logs into Ranger multiple times a second. This is with:
{code}
ranger.usersync.source.impl.class=org.apache.ranger.unixusersync.process.UnixUserGroupBuilder
ranger.usersync.unix.backend=nss
{code}

The high number and rate of these sessions makes it impossible to use the 
"Login Sessions" audit page:

Further, it's adding a lot of extra requests and overhead to Ranger, Ranger 
User Sync, and the backing database (e.g. MySQL).

*The service should re-use its session rather than continual logins.*

!screenshot-1.png|width=640!

{code}
MariaDB [ranger]> select count(*),DATE(create_time) as date from x_auth_sess 
where login_id='rangerusersync' group by DATE(create_time) order by date desc 
limit 10;
+----------+------------+
| count(*) | date       |
+----------+------------+
|     3558 | 2018-03-14 |
|     8520 | 2018-03-13 |
|     8514 | 2018-03-12 |
|     8508 | 2018-03-11 |
|     8520 | 2018-03-10 |
|     8523 | 2018-03-09 |
|     8532 | 2018-03-08 |
|     8522 | 2018-03-07 |
|     8528 | 2018-03-06 |
|     8520 | 2018-03-05 |
+----------+------------+
10 rows in set (0.13 sec)
{code}

{code}
$ rpm -qa *usersync*
ranger_2_6_4_0_91-usersync-0.7.0.2.6.4.0-91.x86_64
{code}


> Ranger "Login Sessions" Audits impossible to browse due to 'rangerusersync'
> ---------------------------------------------------------------------------
>
>                 Key: RANGER-2021
>                 URL: https://issues.apache.org/jira/browse/RANGER-2021
>             Project: Ranger
>          Issue Type: Bug
>          Components: usersync
>    Affects Versions: 0.7.0
>            Reporter: Sean Roberts
>            Priority: Major
>         Attachments: screenshot-1.png
>
>
> "Ranger User Sync" logs into Ranger multiple times a second. This is with:
> {code}
> ranger.usersync.source.impl.class=org.apache.ranger.unixusersync.process.UnixUserGroupBuilder
> ranger.usersync.unix.backend=nss
> {code}
> The high number and rate of these sessions makes it impossible to use the 
> "Login Sessions" audit page:
> Further, it's adding a lot of extra requests and overhead to Ranger, Ranger 
> User Sync, and the backing database (e.g. MySQL).
> *The service should re-use its session rather than continual logins.*
> !screenshot-1.png|width=640!
> {code}
> $ rpm -qa *usersync*
> ranger_2_6_4_0_91-usersync-0.7.0.2.6.4.0-91.x86_64
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to