Re: Resetting 7825 call manager password

ubuntu_guy · ‎04-28-2011

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

ubuntu_guy · ‎04-28-2011

Also, I get the same errors when I try the reset procedure from ssh or directly from the server.

ubuntu_guy · ‎04-30-2011

Should I post this in a different pat of the forums?

ubuntu_guy · ‎05-02-2011

^^

bvanturn · ‎05-03-2011

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.

ubuntu_guy · ‎05-03-2011

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:

bvanturn · ‎05-03-2011

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

ubuntu_guy · ‎05-03-2011

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]

Component is not running

A Cisco DB[NOTRUNNING]

admin:

Thanks for the assistance

bvanturn · ‎05-03-2011

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?

ubuntu_guy · ‎05-03-2011

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.

bvanturn · ‎05-03-2011

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.

ubuntu_guy · ‎05-03-2011

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).