System information

ManualsBrandsATech Machine ManualsComputer equipmentLIBRA-02 M

391

392

393

394

395

396

397

398

399

400

At the PostgreSQL console, run the following commands:

asterisk=> INSERT INTO ast_hotdesk ('extension', 'first_name', 'last_name',\

'cid_name','cid_number', 'pin', 'context', 'location') \

VALUES (1101, 'Leif', 'Madsen', 'Leif Madsen', '4165551101', '555',\

'longdistance','0000FFFF0001');

At the MySQL console, run the following commands:

mysql> INSERT INTO ast_hotdesk (extension, first_name, last_name, cid_name,

cid_number, pin, context, location)

VALUES (1101, 'Leif', 'Madsen', 'Leif Madsen',

'4165551101', '555', 'longdistance', '0000FFFF0001');

Repeat these commands, changing the VALUES as needed, for all entries you wish to have

in the database. You can view the data in the ast_hotdesk table by running a simple

SELECT statement from the database console:

mysql> SELECT * FROM ast_hotdesk;

which would give you something like the following output:

|----+-----------+------------+----------------+--------------------+--------------

| 1 | 1101 | "Leif" | "Madsen" | "Leif Madsen" | "4165551101"

| 2 | 1102 | "Jim" | "Van Meggelen" | "Jim Van Meggelen" | "4165551102"

| 3 | 1103 | "Russell" | "Bryant" | "Russell Bryant" | "4165551103"

| 4 | 1104 | "Mark" | "Spencer" | "Mark Spencer" | "4165551104"

| 5 | 1105 | "Kevin" | "Fleming" | "Kevin Fleming" | "4165551105"

+-------+-----------------+---------+----------------+

| "556" | "longdistance" | "FALSE" | "" |

| "557" | "local" | "FALSE" | "" |

| "558" | "international" | "FALSE" | "" |

| "559" | "local" | "FALSE" | "" |

We’ve got the condiments now, so let’s get to our dialplan. This is where the magic is

going to happen.

Somewhere in extensions.conf we are going to have to create the hotdesk context. To

start, let’s define a pattern-match extension that will allow the users to log in:

; extensions.conf

; Hot-Desking Feature

[hotdesk]

; Hot Desk Login

exten => _#110[1-5],1,NoOp()

same => n,Set(E=${EXTEN:1}) ; strip off the leading hash (#) symbol

same => n,Verbose(1,Hot Desk Extension ${E} is changing status)

same => n,Verbose(1,Checking current status of extension ${E})

same => n,Set(${E}_STATUS=${HOTDESK_INFO(status,${E})})

same => n,Set(${E}_PIN=${HOTDESK_INFO(pin,${E})})

358 | Chapter 16: Relational Database Integration