Code Snippets

Shell Script To Configure A Read Only User On A PostgreSQL Database

**UPDATE: New article here.

Its a little more complicated to create a read only database user with PostgreSQL than say using something like MySQL. You will need to grant select access on each table in the database for the read only user. Keep in mind that each time you add a new table you will need to either run the shell script below again or manually grant select access on the new table for the read only user.

Details
Technology Insights

Cisco IOS: Forward Called Teclo DID To An Extension, Translate, Translation-Rule Limitation

A client of mine had a Cisco 2811 installed before I started working for them so I had to go over the configuration to become familiar with things. One of the Cisco IOS configuration items used was translation-rule which will allow 10 to 15 Rules to be created under each translation-rule. In this scenario they were using translation-rule to forward external DID’s from their telco provider┬áto internal extensions. This works fine except for the fact that if you have more than 10 (in this case) external numbers you won’t be able to continue to forward them to internal extensions without complicating the configuration using multiple dial plans, etc. The easiest way to get away from the translation-rule being used in this way is to assign t he external DID telephone numbers as secondary numbers under each extension configuration as explained below.

Details