Password for the default admin user for ConnectAdminGUI application

classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

Password for the default admin user for ConnectAdminGUI application

greggurr
CONNECT 4.4 has a new GUI application, ConnectAdminGUI.  The on-line release notes mentions the following:

"A default admin user is already configured in the module for administrator"

In looking at the db tables (UserLogin) for CONNECT I found default user name. However I am not sure how to extract the password for this default user.

Does someone know what the default password is or how to extract it?

Thanks
Reply | Threaded
Open this post in threaded view
|

Re: Password for the default admin user for ConnectAdminGUI application

Naresh Subramanyan
The default password is password

Thanks,
Naresh
Reply | Threaded
Open this post in threaded view
|

RE: Password for the default admin user for ConnectAdminGUI application

greggurr

Thanks.  I thought I already tried “password”, but I guess I did not. 

 

 

 

From: nareshcgi [via CONNECT Forums] [mailto:ml-node+[hidden email]]
Sent: Friday, February 27, 2015 4:45 PM
To: Greg Gurr
Subject: Re: Password for the default admin user for ConnectAdminGUI application

 

The default password is password

Thanks,
Naresh


To start a new topic under CONNECT Developers, email [hidden email]
To unsubscribe from CONNECT Forums, click here.
NAML

Reply | Threaded
Open this post in threaded view
|

RE: Password for the default admin user for ConnectAdminGUI application

Naresh Subramanyan
We have released a patch version CONNECT 4.4.1, we will recommend you to use/try this, it has fixes for eHealth Exchange certification issues and also a new feature to test connectivity between gateways using System Administration (aka AdminGUI) module. You can find more information from the below link

https://connectopensource.atlassian.net/wiki/display/CONNECT4/4.4.X+Patches

Thanks,
Naresh
CONNECT Product Team
Reply | Threaded
Open this post in threaded view
|

Re: Password for the default admin user for ConnectAdminGUI application

johnhd
In reply to this post by greggurr
What is the default username you're using. I'm stuck here. The documentation is missing this information:

-_-
Reply | Threaded
Open this post in threaded view
|

Re: Password for the default admin user for ConnectAdminGUI application

johnhd
johnhd wrote
What is the default username you're using. I'm stuck here. The documentation is missing this information:

-_-
Forgot to include:

https://connectopensource.atlassian.net/wiki/pages/viewpage.action?pageId=17203315

Best I could tell, the username should be either admin or CONNECTAdmin, but the password "password" doesn't work for either.
Reply | Threaded
Open this post in threaded view
|

Re: Password for the default admin user for ConnectAdminGUI application

christophermay07
The default username is "CONNECTAdmin", with default password of "password" (no quotes).  If you want to change the username, use the final insert statement at the end of the file adminguidb.sql (under Product/DBScripts/adminguidb) as a reference.

If this isn't working for you, run the default adminguidb.sql file and try logging in again.  We'll work to make the documentation a bit more clear, but let us know if this clears up your issue.

Regards,

Chris May
CONNECT Product Team
Reply | Threaded
Open this post in threaded view
|

Re: Password for the default admin user for ConnectAdminGUI application

johnhd
Thanks! Great info for others digging through this later.

It's not working for us but we're running into this when we try, so it's probably a setup thing:

[#|2015-08-18T18:14:03.884+0000|INFO|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=26839;_ThreadName=Thread-2;|[18/18:14:03:884] DEBUG  UserAuthorizationListener       current page: /login.xhtml


 |#]

[#|2015-08-18T18:14:03.887+0000|INFO|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=26839;_ThreadName=Thread-2;|Hibernate: select userlogin0_.ID as ID0_, userlogin0_.SALT as SALT0_, userlogin0_.SHA1 as SHA3_0_, userlogin0_.USERNAME as USERNAME0_, userlogin0_.userRole as userRole0_ from UserLogin userlogin0_ where (userName=? )|#]

[#|2015-08-18T18:14:03.889+0000|INFO|glassfish3.1.2|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=26839;_ThreadName=Thread-2;|[18/18:14:03:888] ERROR  UserLoginDAOImpl                Exception during query execution by: could not execute query


 org.hibernate.exception.GenericJDBCException: could not execute query
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.loader.Loader.doList(Loader.java:2223)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
	at org.hibernate.loader.Loader.list(Loader.java:2099)
	at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:912)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
	at gov.hhs.fha.nhinc.admingui.hibernate.dao.UserLoginDAOImpl.login(UserLoginDAOImpl.java:72)
	at gov.hhs.fha.nhinc.admingui.hibernate.LoginServiceImpl.login(LoginServiceImpl.java:89)
	at sun.reflect.GeneratedMethodAccessor1596.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at com.sun.proxy.$Proxy429.login(Unknown Source)
	at gov.hhs.fha.nhinc.admingui.managed.LoginBean.login(LoginBean.java:159)
	at gov.hhs.fha.nhinc.admingui.managed.LoginBean.loginAndNavigate(LoginBean.java:123)
	at sun.reflect.GeneratedMethodAccessor1595.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at javax.el.BeanELResolver.invokeMethod(BeanELResolver.java:779)
	at javax.el.BeanELResolver.invoke(BeanELResolver.java:528)
	at javax.el.CompositeELResolver.invoke(CompositeELResolver.java:257)
	at com.sun.el.parser.AstValue.invoke(AstValue.java:228)
	at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
	at org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96)
	at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:68)
	at javax.faces.component.UICommand.broadcast(UICommand.java:120)
	at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1041)
	at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:289)
	at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1415)
	at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:765)
	at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38)
	at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170)
	at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
	at org.apache.myfaces.webapp.MyFacesServlet.service(MyFacesServlet.java:112)
	at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
	at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:98)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
	at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:328)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)
	at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)
	at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)
	at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)
	at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)
	at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)
	at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)
	at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
	at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
	at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
	at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
	at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
	at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
	at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
	at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
	at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: No database selected
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228)
	at com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:642)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
	at org.hibernate.loader.Loader.doQuery(Loader.java:674)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
	at org.hibernate.loader.Loader.doList(Loader.java:2220)
	... 72 more
|#]






I'll try running that sql file and reporting back.
Reply | Threaded
Open this post in threaded view
|

Re: Password for the default admin user for ConnectAdminGUI application

qa_dossia
We struggled with logging in to the admin gui (connect 4.5)

looking in the logs we found - Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'assigningauthoritydb.UserLogin' doesn't exist

But the DBScripts folder in the source code does not have sqls to create this table

We modified the create tables queries for adminguidb to assigningauthoritydb and now we could login (CONNECTAdmin/password).

Is there a missing DBScript in 4.5 source code?
Reply | Threaded
Open this post in threaded view
|

Re: Password for the default admin user for ConnectAdminGUI application

christophermay07
The "DBScripts/nhincdb/nhincdb.sql" script should create all the databases and tables you need.  Can you also verify that your CONNECT properties directory has a "hibernate" folder containing the file "admingui.hibernate.cfg"?

Thanks,

Chris May
CONNECT Product Team
Reply | Threaded
Open this post in threaded view
|

Re: Password for the default admin user for ConnectAdminGUI application

johnhd_at_zen
In reply to this post by greggurr
Update on this super stale thread!

At least in CONNECT 4.7, it's username "CONNECTAdmin" (capitalization appears not to matter) and password "password".

https://connectopensource.atlassian.net/wiki/spaces/CONNECTWIKI/pages/85852259/Admin+GUI+User+Manual

Despite the instructions in this guide, there no apparent way to change the default password in the UI. Can't even delete the ConnectAdmin user.

Ask The Experts: http://consultzen.com/
Reply | Threaded
Open this post in threaded view
|

Re: Password for the default admin user for ConnectAdminGUI application

Minh
Administrator
Hi John,
We will create a new ticket to implement this feature in AdminGUI.   In the meantime, you can change the default password by following the wiki page:  https://connectopensource.atlassian.net/wiki/spaces/CONNECTWIKI/pages/59113483/Adopters+Implementation+Guidelines
Section (Change Default Password) For Post 4.6

Once you generate the new hash number, use sql script to update the table.

Thanks,
Minh-Hai Nguyen
CONNECT Product Team Member