Knowledgebase

In some cases the routing on SmartMedia 10K series can not be done just using the static routing table.

As a new case study, in some cases the remapped nap is depending on the actual time / the calling party number of the called party number. All these data are available already in a MySQL database, so the most logical is to use it.

Link to attachment 

What you need:

- A SmartMedia VoIP Gateway

- A MySQL Server ( version <= 5.1.47 as of now )

- The attached Ruby Script.

Database Scheme:

mysql> describe route\G;

*************************** 1. row ***************************
Field: id
Type: int(11)
Null: NO
Key: PRI
Default: NULL
Extra: auto_increment
*************************** 2. row ***************************
Field: numberA
Type: varchar(255)
Null: NO
Key:
Default: NULL
Extra:
*************************** 3. row ***************************
Field: numberB
Type: varchar(255)
Null: NO
Key:
Default: NULL
Extra:
*************************** 4. row ***************************
Field: napB
Type: varchar(255)
Null: NO
Key:
Default: NULL
Extra:
4 rows in set (0.00 sec)