# Admin page not working after enabling local auth

**URL:** <https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578>\
**Category:** Rancher 1.x\
**Created:** [September 28, 2015, 11:06pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578 "2015-09-28T23:06:33Z")\
**Posts on this page:** 19\
**Page:** 1

<div class="post-metadata">

**Author:** ![rrioux](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@rrioux](https://forums.suse.com/u/rrioux)\
**Post date:** [September 28, 2015, 11:06pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/1 "2015-09-28T23:06:33Z")

</div>

Admin was working fine before local auth, after local auth is enabled, when clicking on admin, it hangs at “Loading…” and never returns.  
I have rebooted the server, used both firefox and chrome. no luck.  
I am running a proxmox vm, with 1GB of ram, and it is a rancher os install on the vm.

---

<div class="post-metadata">

**Author:** ![denise](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@denise](https://forums.suse.com/u/denise)\
**Post date:** [September 29, 2015, 9:08pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/2 "2015-09-29T21:08:32Z")

</div>

When you say it was working fine, were you using a different authentication provider? We don’t really support switching between authentication providers.

Also, if there are no hosts added onto Rancher server, you might hit this issue when you enable local auth. [https://github.com/rancher/rancher/issues/2051](https://github.com/rancher/rancher/issues/2051)

---

<div class="post-metadata">

**Author:** ![rrioux](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@rrioux](https://forums.suse.com/u/rrioux)\
**Post date:** [September 29, 2015, 11:38pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/3 "2015-09-29T23:38:13Z")

</div>

i mean the default installation. there was a warning at the top of the screen saying authentication wasnt enabled so i enabled local auth and it was hung after making that change. I have 3 hosts in total, 1 server and 2 with agents.

---

<div class="post-metadata">

**Author:** ![denise](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@denise](https://forums.suse.com/u/denise)\
**Post date:** [September 30, 2015, 4:38pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/4 "2015-09-30T16:38:09Z")

</div>

Hmm, I am not really sure what it could be as I don’t have any issues with enabling local auth and going to the admin page.

@vincent Any ideas on what else could be causing the UI to have loading issues?

---

<div class="post-metadata">

**Author:** ![Bill\_George](https://avatars.discourse-cdn.com/v4/letter/b/a698b9/32.png) [@Bill\_George](https://forums.suse.com/u/Bill_George)\
**Post date:** [September 30, 2015, 5:32pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/5 "2015-09-30T17:32:29Z")

</div>

With regard to the issue2051 did we not have to do the following to the database

update setting set value=“true” where name=“api.security.enabled”;  
update account set external\_id=19, external\_id\_type=“rancher\_id” where id=1;

Just wonder if it is same symtoms

---

<div class="post-metadata">

**Author:** ![zauberertz](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/zauberertz/32/310_2.png) [@zauberertz](https://forums.suse.com/u/zauberertz)\
**Post date:** [October 3, 2015, 11:52am UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/6 "2015-10-03T11:52:22Z")

</div>

Same here, the admin tab is not visible

---

<div class="post-metadata">

**Author:** ![vincent](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/vincent/32/7156_2.png) [@vincent](https://forums.suse.com/u/vincent)\
**Post date:** [October 3, 2015, 5:43pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/7 "2015-10-03T17:43:52Z")

</div>

I’m not sure exactly what the issues(s) are here, or that any two people are talking about the same thing… Can everyone with a problem open up the browser (preferably Chrome) Dev tools -\> network tab, enable “Preserve Log”. Then do whatever causes your problem and check the network tab for failed requests or the console tab for error messages and post what you see.

---

<div class="post-metadata">

**Author:** ![zauberertz](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/zauberertz/32/310_2.png) [@zauberertz](https://forums.suse.com/u/zauberertz)\
**Post date:** [October 4, 2015, 1:35am UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/8 "2015-10-04T01:35:20Z")

</div>

Hi @vincent,

the thing is that there is a admin route where you able to manage the users for example but this tab is not visible to me. I assume for some reason is my user not equipped with the proper permissions.  
 ![](https://us1.discourse-cdn.com/flex022/uploads/suse/original/1X/18b710ca1a2c8407e52eea0ed1101d239cae2f95.png)

```
Rancher	v0.40.0
Cattle	v0.97.0
User Interface	v0.54.0

```

Was the same with server version 0.39

---

<div class="post-metadata">

**Author:** ![denise](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@denise](https://forums.suse.com/u/denise)\
**Post date:** [October 5, 2015, 7:20pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/9 "2015-10-05T19:20:25Z")

</div>

@zauberertz

For some reason, the user that you have logged in as is not an admin of Rancher. Were you the one to enable authentication for Rancher or was it someone else in the company? The first account that was enabled using local auth is considered the admin. Any other users can be created and made into an admin.

Note: In previous release, there was a UI bug that could have overwritten the Admin rights of users. It won’t fix the permission issue, but will prevent for further accidental changes in Admin rights.

> <https://github.com/rancher/rancher/issues/2163>
>
> On /admin/accounts, if you edit an user Account Type appears always as User.
> Besides its an UI bug, it could lead to...

---

<div class="post-metadata">

**Author:** ![zauberertz](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/zauberertz/32/310_2.png) [@zauberertz](https://forums.suse.com/u/zauberertz)\
**Post date:** [October 6, 2015, 9:34am UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/10 "2015-10-06T09:34:30Z")

</div>

@denise

I Have enabled the authentication in rancher. See the screenshot of the accounts table of the rancher Database.

 ![](https://us1.discourse-cdn.com/flex022/uploads/suse/original/1X/48f544cda6c103778471b60f39743a897e9f02c7.png)

Any recommendations how to fix my permissions? I’m user id 1.

---

<div class="post-metadata">

**Author:** ![denise](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@denise](https://forums.suse.com/u/denise)\
**Post date:** [October 6, 2015, 6:54pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/11 "2015-10-06T18:54:08Z")

</div>

@zauberertz Can you also share the portion of external\_id and external\_id\_type in the account table?

Also, can you share the result of:

```auto
select * from credential where account_id=1;

```

---

<div class="post-metadata">

**Author:** ![zauberertz](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/zauberertz/32/310_2.png) [@zauberertz](https://forums.suse.com/u/zauberertz)\
**Post date:** [October 7, 2015, 12:45am UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/12 "2015-10-07T00:45:43Z")

</div>

@denise

here you go:

 ![](https://us1.discourse-cdn.com/flex022/uploads/suse/original/1X/8bc089146cd46c2bcb759eebc94034d689d635e3.png)

---

<div class="post-metadata">

**Author:** ![denise](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@denise](https://forums.suse.com/u/denise)\
**Post date:** [October 7, 2015, 4:21am UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/13 "2015-10-07T04:21:31Z")

</div>

@zauberertz Can you show me the full row of the account table?

---

<div class="post-metadata">

**Author:** ![zauberertz](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/zauberertz/32/310_2.png) [@zauberertz](https://forums.suse.com/u/zauberertz)\
**Post date:** [October 7, 2015, 8:21am UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/14 "2015-10-07T08:21:07Z")

</div>

@denise

 ![](https://us1.discourse-cdn.com/flex022/uploads/suse/original/1X/8c46feaa14f0f870d08405ea469b5f0712fbf51e.png)

as you wish

---

<div class="post-metadata">

**Author:** ![denise](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@denise](https://forums.suse.com/u/denise)\
**Post date:** [October 7, 2015, 6:15pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/15 "2015-10-07T18:15:14Z")

</div>

Sorry @zauberertz. I meant the `account` table that you had previously shown in the first post of the DB.

Can you provide the full row of these two statements?

```auto
select * from account where id=1;
select * from credential where account_id=1;

```

---

<div class="post-metadata">

**Author:** ![zauberertz](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/zauberertz/32/310_2.png) [@zauberertz](https://forums.suse.com/u/zauberertz)\
**Post date:** [October 7, 2015, 10:35pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/16 "2015-10-07T22:35:07Z")

</div>

![](https://us1.discourse-cdn.com/flex022/uploads/suse/original/1X/216a125bfb496cf464819572eb05ddb006ac0d15.png)

Here the additional queries

---

<div class="post-metadata">

**Author:** ![denise](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@denise](https://forums.suse.com/u/denise)\
**Post date:** [October 8, 2015, 5:13am UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/17 "2015-10-08T05:13:39Z")

</div>

@zauberertz Here’s the SQL statement to change your account to an admin account.

```auto
update account set kind="admin" where id=1;

```

---

<div class="post-metadata">

**Author:** ![zauberertz](https://sea2.discourse-cdn.com/flex022/user_avatar/forums.suse.com/zauberertz/32/310_2.png) [@zauberertz](https://forums.suse.com/u/zauberertz)\
**Post date:** [October 8, 2015, 7:25am UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/18 "2015-10-08T07:25:06Z")

</div>

@denise, that worked. now the admin tab is visible.

---

<div class="post-metadata">

**Author:** ![denise](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@denise](https://forums.suse.com/u/denise)\
**Post date:** [October 8, 2015, 1:16pm UTC](https://forums.suse.com/t/admin-page-not-working-after-enabling-local-auth/578/19 "2015-10-08T13:16:07Z")

</div>


