# Can't login to client after restoring

**URL:** <https://forum.inductiveautomation.com/t/cant-login-to-client-after-restoring/18979>\
**Category:** Ignition\
**Created:** [July 26, 2018, 4:13am UTC](https://forum.inductiveautomation.com/t/cant-login-to-client-after-restoring/18979 "2018-07-26T04:13:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![enertec](https://avatars.discourse-cdn.com/v4/letter/e/e9bcb4/32.png) [@enertec](https://forum.inductiveautomation.com/u/enertec)\
**Post date:** [July 26, 2018, 4:13am UTC](https://forum.inductiveautomation.com/t/cant-login-to-client-after-restoring/18979/1 "2018-07-26T04:13:09Z")

</div>

Hi,  
I can login to designer and gateway, but not in client [http://prntscr.com/kb4fco](http://prntscr.com/kb4fco)

GatewayException: Error authenticating.  
caused by Exception: SQL exception during authentication

But DB is OK, and user is exist

How tom solve?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 26, 2018, 2:20pm UTC](https://forum.inductiveautomation.com/t/cant-login-to-client-after-restoring/18979/2 "2018-07-26T14:20:25Z")

</div>

Get the full details (click ‘full’ on the dialog) and paste it in here, ideally inside of three backticks:

```auto

```

some error message

```auto

```

---

<div class="post-metadata">

**Author:** ![enertec](https://avatars.discourse-cdn.com/v4/letter/e/e9bcb4/32.png) [@enertec](https://forum.inductiveautomation.com/u/enertec)\
**Post date:** [July 27, 2018, 4:39am UTC](https://forum.inductiveautomation.com/t/cant-login-to-client-after-restoring/18979/3 "2018-07-27T04:39:14Z")

</div>

here it is

```auto
com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Error authenticating.
	at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:313)
	at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:287)
	at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:240)
	at com.inductiveautomation.factorypmi.application.runtime.ClientGatewayConnection.doLogin(ClientGatewayConnection.java:90)
	at com.inductiveautomation.ignition.client.gateway_interface.AbstractGatewayConnection.loginEncoded(AbstractGatewayConnection.java:530)
	at com.inductiveautomation.ignition.client.gateway_interface.AbstractGatewayConnection.login(AbstractGatewayConnection.java:525)
	at com.inductiveautomation.factorypmi.application.runtime.ClientPanel$LoginAction$LoginTask.run(ClientPanel.java:471)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.Exception: SQL exception during authentication
	at com.inductiveautomation.ignition.gateway.authentication.impl.DatabaseExpertUserSource.authenticate(DatabaseExpertUserSource.java:135)
	at com.inductiveautomation.ignition.gateway.authentication.UserSourceWrapper.authenticate(UserSourceWrapper.java:181)
	at com.inductiveautomation.ignition.gateway.servlets.Gateway.runLogin(Gateway.java:878)
	at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:393)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(null)

Ignition v7.6.7 (b2014082615)
Java: Oracle Corporation 1.8.0_171

```

---

<div class="post-metadata">

**Author:** ![joostjojo](https://avatars.discourse-cdn.com/v4/letter/j/ac91a4/32.png) [@joostjojo](https://forum.inductiveautomation.com/u/joostjojo)\
**Post date:** [August 1, 2018, 12:36pm UTC](https://forum.inductiveautomation.com/t/cant-login-to-client-after-restoring/18979/4 "2018-08-01T12:36:52Z")

</div>

> [@paul-griffith](#):
>
> ck 'full' on the dialog) and paste it in here

authentication need 3 things in the DB.

1. a user
2. a role
3. a connection between role and user

i think you missed at least 1 of these?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 1, 2018, 6:35pm UTC](https://forum.inductiveautomation.com/t/cant-login-to-client-after-restoring/18979/5 "2018-08-01T18:35:28Z")

</div>

> [@enertec](#):
>
> Ignition v7.6.7 (b2014082615)  
> Java: Oracle Corporation 1.8.0\_171

Is this a supported combination?

---

<div class="post-metadata">

**Author:** ![bpeake](https://avatars.discourse-cdn.com/v4/letter/b/c0e974/32.png) [@bpeake](https://forum.inductiveautomation.com/u/bpeake)\
**Post date:** [February 5, 2020, 5:49pm UTC](https://forum.inductiveautomation.com/t/cant-login-to-client-after-restoring/18979/6 "2020-02-05T17:49:42Z")

</div>

Hello,

I am having this same issue. I have tried to create a new user and assign it the appropriate roles with still no luck. The previous logins worked fine before. Below is the full details of the error:

com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Error authenticating.  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.newGatewayException(GatewayInterface.java:327)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:301)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:258)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.invoke(GatewayInterface.java:884)  
at com.inductiveautomation.factorypmi.application.runtime.ClientGatewayConnection.doLogin(ClientGatewayConnection.java:100)  
at com.inductiveautomation.ignition.client.gateway\_interface.AbstractGatewayConnection.login(AbstractGatewayConnection.java:900)  
at com.inductiveautomation.factorypmi.application.runtime.ClientPanel$LoginAction$LoginTask.run(ClientPanel.java:519)  
at java.lang.Thread.run(Unknown Source)  
Caused by: com.inductiveautomation.ignition.gateway.servlets.gateway.functions.GatewayFunctionException: Error authenticating.  
at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.Login.client(Login.java:194)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(null)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(null)  
at java.lang.reflect.Method.invoke(null)  
at com.inductiveautomation.ignition.gateway.servlets.gateway.AbstractGatewayFunction.invoke(AbstractGatewayFunction.java:209)  
at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:345)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)  
at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)  
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:837)  
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)  
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)  
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)  
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)  
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1160)  
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)  
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)  
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1092)  
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)  
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)  
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)  
at org.eclipse.jetty.server.Server.handle(Server.java:518)  
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308)  
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244)  
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)  
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)  
at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)  
at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:246)  
at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:156)  
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654)  
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572)  
at java.lang.Thread.run(null)

Ignition v7.8.4 (b2016082217)  
Java: Oracle Corporation 1.8.0\_241

Thanks!

brian
