Asipto - SIP and VoIP Knowledge Base Site

User Tools

Site Tools

Trace::

Book: SIP Routing With Kamailio

Learn how to build your own real time communication service!
Kamailio Advanced Training - Online
~~~ Click Here for More Details!~~~
asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb

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
Last revisionBoth sides next revision
asterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb [2013/05/14 13:19] – [Asterisk Database] adminasterisk:realtime:kamailio-4.0.x-asterisk-11.3.0-astdb [2013/06/03 21:32] – admin
Line 513: Line 513:
 </note> </note>
 <note important> <note important>
-In previous versions of this tutorial, there were different table names for **voicemail** and **voicemail_messages** (respectively **voiceboxes** and **voicemessages**) -- they were changed to match the default name in Asterisk, because they have same structure. **sipusers** and **sipregs** are a bit customized, thus they have different names - **sipusers** maps over **sippeers** and **sipregs** can be actually a view over **sipusers**.+In previous versions of this tutorial, there were different table names for **voicemail** and **voicemail_messages** (respectively **voiceboxes** and **voicemessages**) -- they were changed to match the default name in Asterisk, because they have same structure. **sipusers** and **sipregs** are a bit customized, thus they have different names - **sipusers** maps over **sippeers** and **sipregs** can be actually a view over **sipusers**. The table **voicemail_messages** is used for storing voice messages in database via odbc, you have to set its value inside voicemail.conf file, in the attribute **odbctable**.
 </note> </note>
  
Line 601: Line 601:
  
 <code sql> <code sql>
-insert into sipusers (name, username, host, sippasswd, fromuser, fromdomain, mailbox)+insert into sipusers (name, defaultuser, host, sippasswd, fromuser, fromdomain, mailbox)
   values ('101', '101', 'dynamic', '101', '101', 'yoursip.com', '101');   values ('101', '101', 'dynamic', '101', '101', 'yoursip.com', '101');
-insert into sipusers (name, username, host, sippasswd, fromuser, fromdomain, mailbox)+insert into sipusers (name, defaultuser, host, sippasswd, fromuser, fromdomain, mailbox)
   values ('102', '102', 'dynamic', '102', '102', 'yoursip.com', '102');   values ('102', '102', 'dynamic', '102', '102', 'yoursip.com', '102');
-insert into sipusers (name, username, host, sippasswd, fromuser, fromdomain, mailbox)+insert into sipusers (name, defaultuser, host, sippasswd, fromuser, fromdomain, mailbox)
   values ('103', '103', 'dynamic', '103', '103', 'yoursip.com', '103');   values ('103', '103', 'dynamic', '103', '103', 'yoursip.com', '103');
  
Line 612: Line 612:
 insert into sipregs(name) values('103'); insert into sipregs(name) values('103');
  
-insert into voiceboxes(customer_id, context, mailbox, password) values ('101', 'default', '101', '1234'); +insert into voicemail(context, mailbox, password) values ('default', '101', '1234'); 
-insert into voiceboxes(customer_id, context, mailbox, password) values ('101', 'default', '102', '1234'); +insert into voicemail(context, mailbox, password) values ('default', '102', '1234'); 
-insert into voiceboxes(customer_id, context, mailbox, password) values ('101', 'default', '103', '1234');+insert into voicemail(context, mailbox, password) values ('default', '103', '1234');
 </code> </code>
  
Line 1024: Line 1024:
  
 #!ifdef WITH_ASTERISK #!ifdef WITH_ASTERISK
-modparam("auth_db", "user_column", "username")+modparam("auth_db", "user_column", "name")
 modparam("auth_db", "password_column", "sippasswd") modparam("auth_db", "password_column", "sippasswd")
 modparam("auth_db", "db_url", DBASTURL) modparam("auth_db", "db_url", DBASTURL)

Page Tools

100%

Copyright 2010-2020 Asipto.com