Cisco IM&P Chat Room Postgres Server

If you want to implement chat rooms/persistent chat or chat logging with Cisco IM and Presence, you need to setup an external postgres server.  The setup is relatively easy (I used a ubuntu server), and can be found HERE 

The problem I came across was that while testing, I created several chat rooms, then deleted the users who owned those chat rooms.  I needed a way to delete those test chat rooms, which needs to be done on the postgres server (since the users no longer existed).  Here are the steps I used:

  1. SSH to postgres server and become the postgres user: su – postgres
  2. As the postgres user, login to the database: psql -d tcmadb
  3. To view the chat rooms stored in the database, run: SELECT room_jid FROM tc_rooms;
  4. I wanted to delete ALL chat rooms previously created, so I truncated the table: TRUNCATE tc_rooms;
  5. All done!  All chat rooms are now deleted.  If you want to delete a specific room, you’ll need to select and delete a specific row instead of truncate

Additional useful postgres database commands:

Show all tables: \dt
To quit: \q
Show all rows in a table: \d+ tablename

Advertisements

Cisco CUCM TFTP server

If you want to view the files loaded on your CUCM TFTP server, you don’t have to download and open the file.  Just navigate to http://cucmipaddress:6970/file.xml.

For example, if I wanted to view my jabber config, I would go to: http://cucmipaddress:6970/jabber-config.xml

Alternatively, you can still download/upload files from CUCM OS Administration–>Software Upgrade–>TFTP File Management

New Cisco ISR4000 Series Routers

I got the chance to install a new Cisco ISR 4431 today, and the best surprise (besides the hugely upgraded throughput) is that the onboard router interfaces now support LACP! Before, you had to resort to getting a switch HWIC module, or just using “mode on” channel-groups.  Since the 4431 has four gig interfaces, you can use LACP for two WAN interfaces, and use LACP for two LAN interfaces using the command “channel-group 1 mode active”.

Show commands:

#show lacp internal

#show lacp neighbor