04-28-2011 06:40 AM - edited 03-19-2019 02:50 AM
I'm trying to reset the login cred's for the gui side of my 7825 with the process found here;
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cli_ref/8_0_3/cli_ref_803.html#wp42401
however when I enter the command;
utils reset_ui_administrator_name
I get this;
Thu Apr 28 07:29:21 CDT 2011:ClassExecutionThread:General SQL failure:
Thu Apr 28 07:29:21 CDT 2011:ClassExecutionThread:java.sql.SQLException: Failed to get Connection.Connector(NOT CONNECTED: Driver=com.informix.jdbc.IfxDriver;)
at com.cisco.ccm.dbl.Connector.getConn(Connector.java:738)
at com.cisco.ccm.dbl.Connector.connect(Connector.java:621)
at com.cisco.ccm.dbl.Connector.connect(Connector.java:563)
at com.cisco.ccm.dbl.Connector.createTemporaryStatement(Connector.java:891)
at com.cisco.ccm.dbl.Connector.executeUpdate(Connector.java:979)
at com.cisco.ccm.dbl.idbl.executeUpdate(idbl.java:1216)
at com.cisco.ccm.dbl.idbl.executeSQL(idbl.java:1278)
at com.cisco.ccm.dbl.idbl.run(idbl.java:1426)
at com.cisco.iptplatform.cli.cmdResetUserName.executeQuery(cmdResetUserName.java:157)
at com.cisco.iptplatform.cli.cmdResetUserName.executecommand(cmdResetUserName.java:86)
at com.cisco.iptplatform.cli.cmdUtilsDb.executeCmd(cmdUtilsDb.java:54)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.cisco.iptplatform.cli.cmdClassThread.run(cmdClassThread.java:109)
Error, Administrator user name has not been successfully updated.
Please check if the application user already exists,username should not be more than 50 characters and allow only characters,digits,hyphen(-) and underscore(_).
Regular expression used to validate the user ^[a-zA-Z][a-zA-Z0-9-_]{0,49}$
Failed to get Connection.Connector(NOT CONNECTED: Driver=com.informix.jdbc.IfxDriver;)
This is a brand new install I just dont know what the original person who started installing the thing set the gui credentials to.
Thanks for the help,
Richard
04-28-2011 08:17 AM
Also, I get the same errors when I try the reset procedure from ssh or directly from the server.
04-30-2011 06:36 AM
Should I post this in a different pat of the forums?
05-02-2011 07:34 AM
^^
05-03-2011 12:28 AM
Hi Richard,
You can lookup the username manually in the database like this:
admin:run sql select name from applicationuser
name
===================
CCMAdministrator
CCMSysUser
WDSysUser
CCMQRTSysUser
IPMASysUser
WDSecureSysUser
CCMQRTSecureSysUser
IPMASecureSysUser
TabSyncSysUser
CUCService
So in this example from my server, first name ( CCMAdministrator )is the name of my username for the admin account. The others are system accounts.
05-03-2011 05:46 AM
Well at least it's a different error Thanks for the reply, I'm making a note of that command/query, seems like that'll be handy going forward.
admin:run sql select name from applicationuser
Tue May 03 06:38:57 CDT 2011:ClassExecutionThread:General SQL failure:
Tue May 03 06:38:57 CDT 2011:ClassExecutionThread:java.sql.SQLException: Failed to get Connection.Connector(NOT CONNECTED: Driver=com.informix.jdbc.IfxDriver;)
at com.cisco.ccm.dbl.Connector.getConn(Connector.java:738)
at com.cisco.ccm.dbl.Connector.connect(Connector.java:621)
at com.cisco.ccm.dbl.Connector.connect(Connector.java:563)
at com.cisco.ccm.dbl.Connector.createStatement(Connector.java:797)
at com.cisco.ccm.dbl.Connector.createStatement(Connector.java:784)
at com.cisco.ccm.dbl.Connector.executeQuery(Connector.java:961)
at com.cisco.ccm.dbl.idbl.executeSelect(idbl.java:693)
at com.cisco.ccm.dbl.idbl.executeSQL(idbl.java:1272)
at com.cisco.ccm.dbl.idbl.run(idbl.java:1426)
at com.cisco.iptplatform.cli.cmdRunSql.executeCmd(cmdRunSql.java:71)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.cisco.iptplatform.cli.cmdClassThread.run(cmdClassThread.java:109)
Failed to get Connection.Connector(NOT CONNECTED: Driver=com.informix.jdbc.IfxDriver;)
admin:
05-03-2011 05:53 AM
Hi Richard,
You should check if your database is actually running with this command:
utils service list page
check for the status of "A Cisco DB", it should list:
A Cisco DB[STARTED]
It it is stopped, to start it you need to issue:
utils service start A Cisco DB
If it is running, to restart it you need to issue:
utils service restart A Cisco DB
05-03-2011 06:28 AM
admin:utils service list page
Requesting service status, please wait...
System SSH [STARTED]
Cluster Manager [STARTED]
Service Manager is running
Getting list of all services
>> Return code = 0
A Cisco DB[STOPPED] Component is not running
A Cisco DB Replicator[STARTED]
admin:utils service start A Cisco DB
Service Manager is running
A Cisco DB[STARTING]
A Cisco DB[STARTING]
A Cisco DB[STARTING]
A Cisco DB[STARTING]
A Cisco DB[STARTING]
A Cisco DB[STARTING]
Component is not running
A Cisco DB[NOTRUNNING]
admin:
Thanks for the assistance
05-03-2011 06:31 AM
You could try to reboot the system, if that does not fix it the fastest way forward would be to quickly reinstall the system. Since it is a new system it likely has no configuration yet anyways?
05-03-2011 06:42 AM
I'm starting to suspect that I should just flatten it and start over. Does cisco have documentation on that process? I'm rebooting the server now and I'll post the results.
05-03-2011 06:44 AM
You can follow the installation guide applicable to your version here:
http://www.cisco.com/en/US/products/sw/voicesw/ps556/prod_installation_guides_list.html
Make sure you have the proper bootable media to perform this.
05-03-2011 05:55 AM
When I use "admin" as the username which is what I believe to be the default username for this account I get this;
admin:utils reset_ui_administrator_name admin
Expected 0 mandatory and up to 0 non-mandatory parmeter(s)
but 1 parameter(s) were found
Executed command unsuccessfully
Error executing command
admin:utils reset_ui_administrator_name admin
Expected 0 mandatory and up to 0 non-mandatory parmeter(s)
but 1 parameter(s) were found
Executed command unsuccessfully
Error executing command
admin:
Which is different from using other usernames in the reset commands(see original post).
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide