diff options
Diffstat (limited to 'doc/tex/cdrdriver.tex')
-rw-r--r-- | doc/tex/cdrdriver.tex | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/doc/tex/cdrdriver.tex b/doc/tex/cdrdriver.tex index 3fe7e148b..9a9337d5f 100644 --- a/doc/tex/cdrdriver.tex +++ b/doc/tex/cdrdriver.tex @@ -197,8 +197,40 @@ \subsection{MySQL} +\subsubsection{ODBC} + Using MySQL for CDR records is supported by using ODBC and the cdr\_odbc module. +\subsubsection{Native} + +Alternatively, there is a native MySQL CDR module. + +To use it, configure the module in cdr\_mysql.conf. Create a table called cdr under the database name you will be using the following schema. + +\begin{astlisting} +\begin{verbatim} +CREATE TABLE cdr ( + calldate datetime NOT NULL default '0000-00-00 00:00:00', + clid varchar(80) NOT NULL default '', + src varchar(80) NOT NULL default '', + dst varchar(80) NOT NULL default '', + dcontext varchar(80) NOT NULL default '', + channel varchar(80) NOT NULL default '', + dstchannel varchar(80) NOT NULL default '', + lastapp varchar(80) NOT NULL default '', + lastdata varchar(80) NOT NULL default '', + duration int(11) NOT NULL default '0', + billsec int(11) NOT NULL default '0', + disposition varchar(45) NOT NULL default '', + amaflags int(11) NOT NULL default '0', + accountcode varchar(20) NOT NULL default '', + uniqueid varchar(32) NOT NULL default '', + userfield varchar(255) NOT NULL default '' +); +\end{verbatim} +\end{astlisting} + + \subsection{PostgreSQL} If you want to go directly to postgresql database, and have the cdr\_pgsql.so compiled you can use the following sample setup. |