<html>
<head>
<base href="https://wiki.asterisk.org/wiki">
<link rel="stylesheet" href="/wiki/s/en/2176/25/9/_/styles/combined.css?spaceKey=AST&forWysiwyg=true" type="text/css">
</head>
<body style="background: white;" bgcolor="white" class="email-body">
<div id="pageContent">
<div id="notificationFormat">
<div class="wiki-content">
<div class="email">
<h2><a href="https://wiki.asterisk.org/wiki/display/AST/MSSQL+CEL+Backend?focusedCommentId=21464401#comment-21464401">MSSQL CEL Backend</a></h2>
<h4>Page
<b>comment added</b> by <a href="https://wiki.asterisk.org/wiki/display/~wolfantec">Antonio Insuasti</a>
</h4>
<br/>
<div class="notificationGreySide">
<p><b>bold</b> For FreeTDS, cel_tds</p>
<p>this is the correct database create statment. </p>
<p>CREATE TABLE cel ( <br/>
<span class="error">[eventtype]</span> <span class="error">[varchar]</span> (30) NULL ,<br/>
<span class="error">[eventtime]</span> <span class="error">[datetime]</span> NULL , <br/>
<span class="error">[cidname]</span> <span class="error">[varchar]</span> (80) NULL , <br/>
<span class="error">[cidnum]</span> <span class="error">[varchar]</span> (80) NULL , <br/>
<span class="error">[cidani]</span> <span class="error">[varchar]</span> (80) NULL ,<br/>
<span class="error">[cidrdnis]</span> <span class="error">[varchar]</span> (80) NULL , <br/>
<span class="error">[ciddnid]</span> <span class="error">[varchar]</span> (80) NULL ,<br/>
<span class="error">[exten]</span> <span class="error">[varchar]</span> (80) NULL , <br/>
<span class="error">[context]</span> <span class="error">[varchar]</span> (80) NULL , <br/>
<span class="error">[channel]</span> <span class="error">[varchar]</span> (80) NULL ,<br/>
<span class="error">[linkedid]</span> <span class="error">[varchar]</span> (80) NULL ,<br/>
<span class="error">[appname]</span> <span class="error">[varchar]</span> (80) NULL ,<br/>
<span class="error">[appdata]</span> <span class="error">[varchar]</span> (80) NULL , <br/>
<span class="error">[amaflags]</span> <span class="error">[varchar]</span> (16) NULL , <br/>
<span class="error">[accountcode]</span> <span class="error">[varchar]</span> (20) NULL ,<br/>
<span class="error">[uniqueid]</span> <span class="error">[varchar]</span> (32) NULL , <br/>
<span class="error">[userfield]</span> <span class="error">[varchar]</span> (255) NULL , <br/>
<span class="error">[peer]</span> <span class="error">[varchar]</span> (80) NULL <br/>
) ;</p>
<p><b>bold</b> Setup FreeTds file</p>
<p>in the file /etc/freetds/freetds.conf define Freetds conection (conection name, host, port) </p>
<p><span class="error">[Microsoft]</span><br/>
host = 192.168.1.110<br/>
port = 1433<br/>
tds version = 7.0</p>
<p><b>bold</b> Setup cel_tds.conf</p>
<p><span class="error">[global]</span><br/>
connection=Microsoft<br/>
dbname=asterisk<br/>
table=cel<br/>
user=voipdbuser<br/>
password=voipdpass<br/>
charset=BIG5</p>
</div>
<div id="commentsSection" class="wiki-content pageSection">
<div style="float: right;" class="grey">
<a href="https://wiki.asterisk.org/wiki/users/removespacenotification.action?spaceKey=AST">Stop watching space</a>
<span style="padding: 0px 5px;">|</span>
<a href="https://wiki.asterisk.org/wiki/users/editmyemailsettings.action">Change email notification preferences</a>
</div>
<a href="https://wiki.asterisk.org/wiki/display/AST/MSSQL+CEL+Backend?focusedCommentId=21464401#comment-21464401">View Online</a>
|
<a id="reply-21464401" href="https://wiki.asterisk.org/wiki/display/AST/MSSQL+CEL+Backend?replyToComment=21464401#comment-21464401">Reply To This</a>
</div>
</div>
</div>
</div>
</div>
</body>
</html>