# Web Interface Login Help

**URL:** <http://discussions.gridprotectionalliance.org/t/web-interface-login-help/343>\
**Category:** openHistorian\
**Created:** [June 26, 2018, 2:54pm UTC](http://discussions.gridprotectionalliance.org/t/web-interface-login-help/343 "2018-06-26T14:54:47Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![GlorifiedManual](http://discussions.gridprotectionalliance.org/letter_avatar_proxy/v4/letter/g/2acd7d/32.png) [@GlorifiedManual](http://discussions.gridprotectionalliance.org/u/GlorifiedManual)\
**Post date:** [June 26, 2018, 2:54pm UTC](http://discussions.gridprotectionalliance.org/t/web-interface-login-help/343/1 "2018-06-26T14:54:47Z")

</div>

After installing openHistorian, the utility opens a locally hosted web page asking for credentials. No matter what I type in I always get a red box at the bottom stating: “No access available for “null” using pass-through authentication” if I have use integrated windows authentication or “Login attempt failed: Internal Server Error (500)” if I use my MySQL database username and password.

What credentials is this page asking for exactly?

---

<div class="post-metadata">

**Author:** ![StephenCWills](http://discussions.gridprotectionalliance.org/user_avatar/discussions.gridprotectionalliance.org/stephencwills/32/20_2.png) [@StephenCWills](http://discussions.gridprotectionalliance.org/u/StephenCWills)\
**Post date:** [June 26, 2018, 3:24pm UTC](http://discussions.gridprotectionalliance.org/t/web-interface-login-help/343/2 "2018-06-26T15:24:04Z")

</div>

When setting up the openHistorian with the Configuration Setup Utility during installation, one of the screens asked you to set up the admin account. Assuming you left everything on that page alone and used the defaults, it will have set up the system to use the Windows account of the user that was logged into the system during installation. That would most likely be your Windows account.

The issue you’re having is likely with the Edge browser, which does not allow integrated Windows authentication for pages hosted on the loopback interface. You can enter your Windows credentials (`DOMAIN\user` and the corresponding password) with NTLM authentication or use a different browser with integrated Windows authentication.

Alternatively, and I just found out about this so we haven’t tested it, but it looks like they did implement a workaround for Edge by enabling the user to configure an intranet app container in Edge to include the loopback interface. You can see more details in the comments of the following webpage.  
[https://developer.microsoft.com/en-us/microsoft-edge/platform/issues/4776775/](https://developer.microsoft.com/en-us/microsoft-edge/platform/issues/4776775/)

---

<div class="post-metadata">

**Author:** ![GlorifiedManual](http://discussions.gridprotectionalliance.org/letter_avatar_proxy/v4/letter/g/2acd7d/32.png) [@GlorifiedManual](http://discussions.gridprotectionalliance.org/u/GlorifiedManual)\
**Post date:** [June 26, 2018, 3:44pm UTC](http://discussions.gridprotectionalliance.org/t/web-interface-login-help/343/3 "2018-06-26T15:44:20Z")

</div>

So log-in still fails with integrated authentication and NTLM using the domain\user & password in IE11, Chrome, and Firefox.

I used the configuration setup utility to set up a new configuration and this time used the Database Authentication method where I entered my own username, password, first name & last name. Now I get “Login attempt failed: Internal Server Error (500)” with every attempt on IE11, Chrome, and Firefox.

Next I tried using the same username & password in IE11 running it with administrator privileges. This resulted in the same internal server error.

Next I opened openHistorian Console and tried to login there.  
Enter password:  
Connecting to tcp://localhost:8510…

```
Exception during connection attempt: A connection attempt failed because the con
nected party did not properly respond after a period of time, or established con
nection failed because connected host has failed to respond

Disconnected from tcp://localhost:8510:

              Client state: Disconnected
           Connection time: 33 seconds
            Receive buffer: 8192
        Transport protocol: Tcp
        Text encoding used: US-ASCII

Connection was terminated before completing authentication.

Connecting to tcp://localhost:8510...

Connected to tcp://localhost:8510:

              Client state: Connected
           Connection time: less than 1 second
            Receive buffer: 8192
        Transport protocol: Tcp
        Text encoding used: US-ASCII

Exception during connection attempt: Unable to authenticate connection to server
: Cannot access a disposed object.
Object name: 'SslStream'.

Disconnected from tcp://localhost:8510:

              Client state: Disconnected
           Connection time: less than 1 second
            Receive buffer: 8192
        Transport protocol: Tcp
        Text encoding used: US-ASCII

Connection to the service was rejected due to authentication failure.
Enter the credentials to be used for authentication with the service.

Enter user name:

```

Next I tried to open the openHistorian manager, I get the splash screen, then a error in a dialog box that looks like Java but it opens and closes too fast for me to read.

---

<div class="post-metadata">

**Author:** ![StephenCWills](http://discussions.gridprotectionalliance.org/user_avatar/discussions.gridprotectionalliance.org/stephencwills/32/20_2.png) [@StephenCWills](http://discussions.gridprotectionalliance.org/u/StephenCWills)\
**Post date:** [June 26, 2018, 4:00pm UTC](http://discussions.gridprotectionalliance.org/t/web-interface-login-help/343/4 "2018-06-26T16:00:15Z")

</div>

It looks like your system is not working at all. You said you are using a MySQL database, right? What version of MySQL Connector/NET are you using? We’ve identified numerous issues when using the latest version (8.0.11) as well as the latest previously GA release (6.10.7). We recommend using version 6.9.12 with our products.

---

<div class="post-metadata">

**Author:** ![GlorifiedManual](http://discussions.gridprotectionalliance.org/letter_avatar_proxy/v4/letter/g/2acd7d/32.png) [@GlorifiedManual](http://discussions.gridprotectionalliance.org/u/GlorifiedManual)\
**Post date:** [June 26, 2018, 4:18pm UTC](http://discussions.gridprotectionalliance.org/t/web-interface-login-help/343/5 "2018-06-26T16:18:29Z")

</div>

It looks like I am using MySQL Server 5.7.20-log & MySQL Connector version 6.10.5 so that could be it. The database test connection in the setup works correctly so I know it can contact the database, write tables, etc. I can see it created ~47 tables during install.

I will start working on changing versions.

---

<div class="post-metadata">

**Author:** ![GlorifiedManual](http://discussions.gridprotectionalliance.org/letter_avatar_proxy/v4/letter/g/2acd7d/32.png) [@GlorifiedManual](http://discussions.gridprotectionalliance.org/u/GlorifiedManual)\
**Post date:** [June 26, 2018, 4:28pm UTC](http://discussions.gridprotectionalliance.org/t/web-interface-login-help/343/6 "2018-06-26T16:28:49Z")

</div>

Hurrah!

Uninstalling MySQL Connector/NET 6.10.5 and installing 6.9.12 coupled with a reboot has fixed the log-in issue.

---

<div class="post-metadata">

**Author:** ![Itan](http://discussions.gridprotectionalliance.org/letter_avatar_proxy/v4/letter/i/85e7bf/32.png) [@Itan](http://discussions.gridprotectionalliance.org/u/Itan)\
**Post date:** [May 17, 2022, 8:57am UTC](http://discussions.gridprotectionalliance.org/t/web-interface-login-help/343/7 "2022-05-17T08:57:08Z")

</div>

Hi @StephenCWills,  
The official download page does not have the 6.9.12 version. Can you suggest a valid source to get this version?  
[https://downloads.mysql.com/archives/c-net/](https://downloads.mysql.com/archives/c-net/)  
Thanks!

---

<div class="post-metadata">

**Author:** ![StephenCWills](http://discussions.gridprotectionalliance.org/user_avatar/discussions.gridprotectionalliance.org/stephencwills/32/20_2.png) [@StephenCWills](http://discussions.gridprotectionalliance.org/u/StephenCWills)\
**Post date:** [May 17, 2022, 2:42pm UTC](http://discussions.gridprotectionalliance.org/t/web-interface-login-help/343/8 "2022-05-17T14:42:04Z")

</div>

Hi Itan,

The 6.9.12 version used to be available as an option under generally available releases. The link for the download may still be active, but it seems that Oracle has changed their webpage a bit so I am no longer able to navigate to it. The 6.9.11 version should work just fine too so that’s the best one I can recommend at this point.

Thanks,  
Stephen
