Module: sip-router Branch: master Commit: b7f51d5d2b24063037ae18e82fb046b066cc52a0 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b7f51d5… Author: Ovidiu Sas &lt;osas(a)voipembedded.com&gt; Committer: Ovidiu Sas &lt;osas(a)voipembedded.com&gt; Date: Mon Dec 17 12:03:11 2012 -0500 modules_k/db_text: documentation updates for db_text.dump rpc command --- modules_k/db_text/README | 71 ++++++++++++++++++++---------- modules_k/db_text/doc/db_text.xml | 5 ++ modules_k/db_text/doc/db_text_admin.xml | 17 ++++++-- 3 files changed, 65 insertions(+), 28 deletions(-) diff --git a/modules_k/db_text/README b/modules_k/db_text/README index c4698cb..6e2b176 100644 --- a/modules_k/db_text/README +++ b/modules_k/db_text/README @@ -6,11 +6,17 @@ Daniel-Constantin Mierla Edited by +Ovidiu Sas + + &lt;osas(a)voipembedded.com&gt; + +Edited by + Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; - Copyright � 2003, 2004 FhG FOKUS + Copyright © 2003, 2004 FhG FOKUS __________________________________________________________________ Table of Contents @@ -32,7 +38,10 @@ Daniel-Constantin Mierla 3.1. db_mode (integer) - 4. Functions + 4. Exported RPC Functions + + 4.1. db_text.dump + 5. Installation and Running 5.1. Using dbtext with basic Kamailio configuration @@ -70,7 +79,10 @@ Chapter 1. Admin Guide 3.1. db_mode (integer) - 4. Functions + 4. Exported RPC Functions + + 4.1. db_text.dump + 5. Installation and Running 5.1. Using dbtext with basic Kamailio configuration @@ -107,10 +119,10 @@ Chapter 1. Admin Guide * a database is represented by a directory in the local file system. NOTE: when you use dbtext in Kamailio, the database URL for modules must be the path to the directory where the table-files are - located, prefixed by "text://", e.g., "text:///var/dbtext/ser". If - there is no "/" after "text://" then "CFG_DIR/" is inserted at the + located, prefixed by “text://”, e.g., “text:///var/dbtext/ser”. If + there is no “/” after “text://” then “CFG_DIR/” is inserted at the beginning of the database path. So, either you provide an absolute - path to database directory or a relative one to "CFG_DIR" + path to database directory or a relative one to “CFG_DIR” directory. * a table is represented by a text file inside database directory. @@ -121,7 +133,7 @@ Chapter 1. Admin Guide * the name of column must not include white spaces. * the format of a column definition is: name(type,attr). * between two column definitions must be a white space, e.g., - "first_name(str) last_name(str)". + “first_name(str) last_name(str)”. * the type of a column can be: + int - integer numbers. + double - real numbers with two decimals. @@ -133,11 +145,11 @@ Chapter 1. Admin Guide + null - accept null values in column fields. + if no attribute is set, the fields of the column cannot have null value. - * each other line is a row with data. The line ends with "\n". - * the fields are separated by ":". + * each other line is a row with data. The line ends with “\n”. + * the fields are separated by “:”. * no value between two ':' (or between ':' and start/end of a row) - means "null" value. - * next characters must be escaped in strings: "\n", "\r", "\t", ":". + means “null” value. + * next characters must be escaped in strings: “\n”, “\r”, “\t”, “:”. * 0 -- the zero value must be escaped too. Example 1.1. Sample of a dbtext table @@ -195,16 +207,27 @@ suser:supasswd:xxx:alpha.org:xxx table is requested whether the corresponding file on disk has changed, and if yes, will re-load table from file. - Default value is "0". + Default value is “0”. Example 1.4. Set db_mode parameter ... modparam("db_text", "db_mode", 1) ... -4. Functions +4. Exported RPC Functions - None. + 4.1. db_text.dump + +4.1. db_text.dump + + Write back to hard drive modified tables. + + Name: db_text.dump + + Parameters: none + + RPC Command Format: + kamcmd db_text.dump 5. Installation and Running @@ -214,10 +237,10 @@ modparam("db_text", "db_mode", 1) REMINDER: when you use text in Kamailio, the database URL for modules must be the path to the directory where the table-files are located, - prefixed by "text://", e.g., "text:///var/dbtext/ser". If there is no - "/" after "text://" then "CFG_DIR/" is inserted at the beginning of the + prefixed by “text://”, e.g., “text:///var/dbtext/ser”. If there is no + “/” after “text://” then “CFG_DIR/” is inserted at the beginning of the database path. So, either you provide an absolute path to database - directory or a relative one to "CFG_DIR" directory. + directory or a relative one to “CFG_DIR” directory. Example 1.5. Load the dbtext module ... @@ -239,17 +262,17 @@ modparam("module_name", "db_url", "text:///path/to/dbtext/database") Example 1.6. Definition of 'subscriber' table (one line) ... -username(str) domain(str) password(str) first_name(str) last_name(str) phone(str -) email_address(str) datetime_created(int) datetime_modified(int) confirmation(s -tr) flag(str) sendnotification(str) greeting(str) ha1(str) ha1b(str) perms(str) -allow_find(str) timezone(str,null) rpid(str,null) +username(str) domain(str) password(str) first_name(str) last_name(str) phone(st +r) email_address(str) datetime_created(int) datetime_modified(int) confirmation +(str) flag(str) sendnotification(str) greeting(str) ha1(str) ha1b(str) perms(st +r) allow_find(str) timezone(str,null) rpid(str,null) ... Example 1.7. Definition of 'location' and 'aliases' tables (one line) ... -username(str) domain(str,null) contact(str,null) received(str) expires(int,null) - q(double,null) callid(str,null) cseq(int,null) last_modified(str) flags(int) us -er_agent(str) socket(str) +username(str) domain(str,null) contact(str,null) received(str) expires(int,null +) q(double,null) callid(str,null) cseq(int,null) last_modified(str) flags(int) +user_agent(str) socket(str) ... Example 1.8. Definition of 'version' table and sample records diff --git a/modules_k/db_text/doc/db_text.xml b/modules_k/db_text/doc/db_text.xml index a1b856a..7836c92 100644 --- a/modules_k/db_text/doc/db_text.xml +++ b/modules_k/db_text/doc/db_text.xml @@ -19,6 +19,11 @@ &lt;email&gt;miconda(a)gmail.com&lt;/email&gt; </author> <editor> + <firstname>Ovidiu</firstname> + <surname>Sas</surname> + &lt;email&gt;osas(a)voipembedded.com&lt;/email&gt; + </editor> + <editor> <firstname>Daniel-Constantin</firstname> <surname>Mierla</surname> &lt;email&gt;miconda(a)gmail.com&lt;/email&gt; diff --git a/modules_k/db_text/doc/db_text_admin.xml b/modules_k/db_text/doc/db_text_admin.xml index 4403e20..fa63826 100644 --- a/modules_k/db_text/doc/db_text_admin.xml +++ b/modules_k/db_text/doc/db_text_admin.xml @@ -266,10 +266,19 @@ modparam("db_text", "db_mode", 1) </section> </section> <section> - <title>Functions</title> - <para> - <emphasis>None</emphasis>. - </para> + <title>Exported RPC Functions</title> + <section> + <title> + <function moreinfo="none">db_text.dump</function> + </title> + <para>Write back to hard drive modified tables.</para> + <para>Name: <emphasis>db_text.dump</emphasis></para> + <para>Parameters: <emphasis>none</emphasis></para> + <para>RPC Command Format:</para> + <programlisting format="linespecific"> + kamcmd db_text.dump + </programlisting> + </section> </section> <section> <title>Installation and Running</title>