– Kamailio SIP Server –

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
asterisk:realtime-mysql-views [2007/03/21 18:48] – 74.67.56.138asterisk:realtime-mysql-views [Unknown date] (current) – external edit (Unknown date) 127.0.0.1
Line 1: Line 1:
 +====== OpenSER to Asterisk Realtime Views for MySQL ======
  
 +==== Alter the OpenSER Tables to Work with Asterisk ====
 +
 +This is the easiest way to integrate them, in the future I will change this to use groups.
 +
 +<code>
 +USE openser;
 +ALTER TABLE subscriber
 +ADD vmail_password varchar(40) NULL,
 +ADD vmail BOOL DEFAULT TRUE;
 +</code>
 +
 +==== Create the Asterisk Database ====
 +<code>
 +CREATE DATABASE asterisk;
 +USE asterisk;
 +</code>
 +
 +==== Grant Permissions to Asterisk User ====
 +This allows asterisk to log in per your settings in the asterisk configuration.
 +<code>
 +GRANT ALL ON asterisk.* to asterisk@yourhostoriphere IDENTIFIED BY 'passwordhere';
 +</code>
 +
 +==== Voicemail Users View ====
 +This creates a view that maps every user with the vmail column set to true in openser.subscriber have access to voicemail.
 +<code>
 +CREATE VIEW voicemail AS
 +SELECT  phplib_id as uniqueid,
 + username as customer_id,
 + 'default' as context,
 + username as mailbox,
 + vmail_password as password,
 + CONCAT(first_name,' ',last_name) as fullname,
 + email_address as email,
 + NULL as pager,
 + datetime_created as stamp 
 +FROM openser.subscriber  WHERE vmail = TRUE;
 +</code>
 +
 +Note: for openser 1.2.0 I had to change "SELECT  phplib_id as uniqueid", to "SELECT  ha1 as uniqueid" for this to work, as that table does not exist with the new db schema. 
 +
 +===== SIP Users View =====
 +In this view, you can change the type from a static 'friend' to whatever you need this to be. You can do the same to other options.
 +<code>
 +CREATE VIEW sip AS
 +SELECT  username as name,
 + username,
 + 'friend' as type,
 + NULL as secret,
 + 'dynamic' as host,
 + CONCAT(rpid, ' ','<',username,'>') as callerid,
 + 'default' as context,
 + username as mailbox,
 + 'no' as nat,
 + 'no' as qualify,
 + NULL as fromuser,
 + NULL as authuser,
 + NULL as fromdomain,
 + NULL as insecure,
 + 'no' as canreinvite,
 + NULL as disallow,
 + NULL as allow,
 + NULL as restrictcid,
 + NULL as ipaddr,
 + NULL as port,
 + NULL as regseconds
 +FROM openser.subscriber;
 +</code>
 +
 +
 +Mail me at mikebwilliams@gmail.com.

Trace: • foundation-draft