Wednesday, March 11, 2015

Cisco IM&P External Database Username Password

Client experiencing several issues with IM&P, one of which is an error found on Diagnostics | System Troubleshooter.  The External Database Troubleshooter tests indicated the external database was pingable, but the connection was failing.  The External Database Settings indicated the solution was "Verify the hostname, username, and password are valid."

The usernames and passwords were reset, the external database re-associated, the message archiver settings reset, XCP Router restarted,  etc., etc.  The PostgresSQL user was made a superuser, connections could be made manually, the PostgresSQL config files and schema was thoroughly checked and it was discovered instant messages were logged appropriately, even with this error. My predecessor must have been satisfied things were therefore fine, despite the error messages. I can't personally can't stand things almost being finished.

The fix? The fix was ultimately simply changing the DB user password to something that did not include the '$' character.

Hours wasted.

Hope it helps.

Wednesday, March 04, 2015

IPCelerate IPSession database cleanup procedures

This is likely dated material as I haven't had the chance to work with IPCelerate based solutions in years, but the following just helped me out of a jam.  The issue was communication between a Status Solutions TAP paging interface, the IPCelerate IPSession server and ultimately Cisco 7925 handsets was delayed.

1. Open up Windows Service and stop the following services:
   Apache Tomcat Tomcat5

2. Open command prompt and type osql -E

3. Then type the following commands
   1> use nipa
   2> backup log NIPA TO DISK ='NUL'
   3> go

Note: This may take a few minutes before you receive a message similar to this:
      Processed 33136 pages for database 'NIPA', file 'NIPA_log' on file 1.
      BACKUP LOG successfully processed 33136 pages in 3.697 seconds (73.423 MB/sec).

4. Once you see this message type in the following.

   1> dbcc loginfo(nipa)
   2> go
  This will display a long list and the far left column is where you will either see 0 or 2.
  Example of 2:     2            5570560            224526336    200
            0    64        1960000000961100001   

  Example of 0:     0            5570560            224526336    200
            0    64        1960000000961100001   

5. After running this wait about 5 minutes and then type exit to logout of the SQL.

6. Go to Windows Services and stop the MSSQLSERVER service.

7. Wait about 2 minutes and then Start the MSSQLSERVER service

8. repeat steps 2 through 4

9. No wait is needed this time, begin typing the following:
   1> dbcc shrinkfile (NIPA_log,10)
   2> go

   Note: You should get the following message below with no errors. 
   DbId   FileId CurrentSize MinimumSize UsedPages   EstimatedPages
   ------ ------ ----------- ----------- ----------- --------------
       5      2        1303         128        1296            128

  (1 row affected)
  DBCC execution completed. If DBCC printed error messages, contact your system

! 1> dbcc shrinkfile (NIPA_log,10)
! 2> go
! Msg 8985, Level 16, State 1, Server IPCELERATE1, Line 1
! Could not locate file 'NIPA_log' in sysfiles.
! DBCC execution completed. If DBCC printed error messages, contact your system
! administrator.

10. Verify the NIAP_log.LDF file under C:\Program Files\Microsoft SQL Server\MSSQL\Data is rougly 10MB, if not repeat step 9 again.

11. Type the following to exit SQL:
    1> exit

12. Start the following services in this order:
    Apache Tomcat Tomcat5

Tuesday, February 24, 2015

CUCM <None> CSS and PT

From an old CUCM Sytem Guide:

"Before you configure any partitions or calling search spaces, all directory numbers (DN) reside in a special partition named <None>, and all devices are assigned a calling search space also named <None>. When you create custom partitions and calling search spaces, any calling search space that you create also contains the <None> partition, while the <None> calling search space contains only the <None> partition."

Short story:
  • <None> partition is accessible from everywhere.
  • <None> calling search space can only access the <None> partition.

Thursday, February 05, 2015

Cisco Unity Connection CLID / Calling Number modifications in email notifications or Unified Messaging

Customer asked to have the leading PSTN access code digits removed from the CLID that was shown in email notifications / Unified Messages accessible in Outlook.

When an incoming call was presented to users, they were accustomed to seeing a 9 or a 91 in front of a number in the phone CLID display.  They liked this, as it allowed them to dial from the received calls or missed calls on their Cisco phones.

If a call went to voice mail, users were likely away from their phones and were picking up the messages on their smart phones remotely via an MS Exchange integration.  The problem then was that the phone number couldn't be clicked and dialed from the smartphone with the same leading 9 or 91 used for outgoing calls on their desk phone.

For example...
  • Incoming call from Joe's Pizza at 1(585)555-1212 shows up as 915855551212 on the Cisco phone display.  This is good, as it can be returned from the phone's directories without editting the number.
  • Incoming call from Joe's Pizza at 1(585)555-1212 gets forwarded to Unity Connection, and the message is delivered to your iPhone with the CLID of 915855551212. This is bad because the iPhone doesn't know you use a 9 in your office to make calls and considers it an invalid number.
Note: Need a picture or more detail here

My fix was to set the Calling Party Transformation Mask to XXXXXXXXXX on the voice mail's hunt pilot.  This allows the 10 CLID digit format iPhone's like to be passed to Unity Connection.  Then you also need to check Use Calling Party's External Phone Number Mask in the hunt pilot as well.

Wednesday, February 04, 2015

Cisco CUCM VMware tools install issue

Just ran into a customer running CUCM 9.1.2 where I was tasked with adding another subscriber to the cluster.  Good fun with a new C240 chassis, and all things went as planned until I found I could not install VMware tools on the server.

Given it's version 9, I first tried the simple method to install from the vSphere client. Normally you can right-click the guest server and choose Guest | Install / Upgrade VMware tools.  My experience is this is typically a 30 second process, but after a couple minutes I felt it was failing and cancelled the install from the same menu.

I was able to edit the server properties through the vSphere client and under the Advanced section, checked the Check and upgrade Tools during power cycling option, but I wasn't in the mood to wait for a graceful restart, nor interupt any services.

Instead, I SSH'd to the server and  ran "utils os secure permissive".  This basically stops the CUCM firewall.

I then tried the install via the vSphere client and boom, 30 seconds or so later they are installed an up to date.

Then, for good measure ran "utils os secure enforce" to re-enable the firewall.

Good one.

For your install options per app and version, see:

For a similar thread and my inspiration, see: