Unity Connection 2.1.2 and CUCMBE 6.1.2

luke.maxwell · ‎08-05-2008

We have CUCMBE 6.1.2 running on the same box as Unity connection. We have completed integration using SCCP to CUCMBE and imported 2 test users.

Now we are not able to access the web links in Unity Connection. We are able to login at the initial prompt but then receive 'Not Authorized' when accessing any links

Any Ideas?

thfergus · ‎08-05-2008

Try this process:

From CUCM Admin:

* Verify that there is an Application Server configured for CUC by looking in System |

Application Server

* Verify that the 'Name' is .localdomain

* Verify that the 'Selected Application Users' list contains the default UI admin account

(account used to log into CUCM Admin).

From the CLI:

* Run the command below to get the objectid of the UI Admin account

from the CUC database:

admin:run cuc dbquery unitydirdb select objectid, ccmid from

vw_user where alias=''

(Where is the account you use to login to CUCM Admin and CUC Admin)

* Copy this objectid (1) and ccmid (2) somewhere for later use

* Run the command below to get the pkid of the Application Server of the CUC Application

Server

admin:run sql select pkid from appserver where name=''

(Where matches the 'Name' field from the CUC Application Server)

* Copy this pkid (3) somewhere for later use

* Run the command below to get the pkid of the UI Admin account and verify it matches the

ccmid (2)

admin:run sql select pkid from applicationuser where name=''

(Where is the account you use to login to CUCM Admin and CUC Admin)

* Verify that the pkid (4) returned matches the ccmid (2) returned in the first query

* Run the command below to set the 'content' in the database

admin:run sql update appserverapplicationusermap set

content='' where fkappserver='' and

fkapplicationuser=''

(Where the objectId and pkid's are as specified)

You should now be able to log into CUCM Admin and CUC Admin and have authorization in CUC

Admin.

luke.maxwell · ‎08-05-2008

Hi, That looks like it should work however none of the commands return anything of use.

We just get the following error.

Column (gcadmin) not found in any table in the query (or SLV is undefined).

Command failed

thfergus · ‎08-05-2008

run cuc dbquery unitydirdb select objectid, ccmid from

vw_user where alias=''

When you run the above command, hopefully you are omitting the left and right angle brackets, e.g. where alias='Admin'

Try these steps which would make entering the commands at the CLI unnecessary:

1. Log into CUCM Administration.

2. From the System menu select Application Server.

3. Find and click on the CUC Application Server to go to its configuration page.

4. Change the application server name so that is ends in .localdomain.

For example, if the server was previously changed to myserver.cisco.com, change it to myserver.localdomain and save your change.

You should now be able to log into the CUC Administration and Serviceability web applications.