<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>Comment edited by <a href="https://wiki.asterisk.org/wiki/display/~wolfantec">Antonio Insuasti</a>
:</h4>
<br/>
<h4>Changes (1)</h4>
<div id="page-diffs">
<table class="diff" cellpadding="0" cellspacing="0">
<tr><td class="diff-snipped" >...<br></td></tr>
<tr><td class="diff-unchanged" >[global] <br>connection=Microsoft <br></td></tr>
<tr><td class="diff-changed-lines" ><span class="diff-deleted-words"style="color:#999;background-color:#fdd;text-decoration:line-through;">dbname=asterisk</span> <span class="diff-added-words"style="background-color: #dfd;">dbname=voipdb</span> <br></td></tr>
<tr><td class="diff-unchanged" >table=cel <br>user=voipdbuser <br></td></tr>
<tr><td class="diff-snipped" >...<br></td></tr>
</table>
</div> <h4>Full Content</h4>
<div class="notificationGreySide">
<p><b>For FreeTDS, cel_tds</b></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>Setup FreeTds file</b></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>Setup cel_tds.conf</b></p>
<p><span class="error">[global]</span><br/>
connection=Microsoft<br/>
dbname=voipdb<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>