<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I am trying to port our Asterisk front end to Asterisk 13 but I
cannot get realtime static to work. Realtime for PJSIP, Voicemail
and Queues is working fine so I know res_odbc is configures
properly. In past versions of Asterisk I was using Mysql
(res_config_mysql) to load realtime databases but now I am loading
everything via ODBC. Is realtime Static deprecated? Have there
been any undocumented changes to ast_config? This is the structure
I have been using since Asterisk 1.X:<br>
<br>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div class="container" title="Hint: double-click to select code">
<div class="line number1 index0 alt2"><code class="java plain">CREATE
TABLE `ast_config` (</code></div>
<div class="line number2 index1 alt1"><code class="java spaces"> </code><code
class="java plain">`id` </code><code class="java keyword">int</code><code
class="java plain">(</code><code class="java value">11</code><code
class="java plain">) NOT NULL auto_increment,</code></div>
<div class="line number3 index2 alt2"><code class="java spaces"> </code><code
class="java plain">`cat_metric` </code><code class="java
keyword">int</code><code class="java plain">(</code><code
class="java value">11</code><code class="java plain">) NOT
NULL </code><code class="java keyword">default</code> <code
class="java string">'0'</code><code class="java plain">,</code></div>
<div class="line number4 index3 alt1"><code class="java spaces"> </code><code
class="java plain">`var_metric` </code><code class="java
keyword">int</code><code class="java plain">(</code><code
class="java value">11</code><code class="java plain">) NOT
NULL </code><code class="java keyword">default</code> <code
class="java string">'0'</code><code class="java plain">,</code></div>
<div class="line number5 index4 alt2"><code class="java spaces"> </code><code
class="java plain">`commented` </code><code class="java
keyword">int</code><code class="java plain">(</code><code
class="java value">11</code><code class="java plain">) NOT
NULL </code><code class="java keyword">default</code> <code
class="java string">'0'</code><code class="java plain">,</code></div>
<div class="line number6 index5 alt1"><code class="java spaces"> </code><code
class="java plain">`filename` varchar(</code><code class="java
value">128</code><code class="java plain">) NOT NULL </code><code
class="java keyword">default</code> <code class="java string">''</code><code
class="java plain">,</code></div>
<div class="line number7 index6 alt2"><code class="java spaces"> </code><code
class="java plain">`category` varchar(</code><code class="java
value">128</code><code class="java plain">) NOT NULL </code><code
class="java keyword">default</code> <code class="java string">'default'</code><code
class="java plain">,</code></div>
<div class="line number8 index7 alt1"><code class="java spaces"> </code><code
class="java plain">`var_name` varchar(</code><code class="java
value">128</code><code class="java plain">) NOT NULL </code><code
class="java keyword">default</code> <code class="java string">''</code><code
class="java plain">,</code></div>
<div class="line number9 index8 alt2"><code class="java spaces"> </code><code
class="java plain">`var_val` varchar(</code><code class="java
value">128</code><code class="java plain">) NOT NULL </code><code
class="java keyword">default</code> <code class="java string">''</code><code
class="java plain">,</code></div>
<div class="line number10 index9 alt1"><code class="java spaces"> </code><code
class="java plain">PRIMARY KEY (`id`),</code></div>
<div class="line number11 index10 alt2"><code class="java spaces"> </code><code
class="java plain">KEY `filename_comment`
(`filename`,`commented`)</code></div>
<div class="line number12 index11 alt1"><code class="java plain">)
TYPE=MyISAM;<br>
<br>
My extconfig.conf has:<br>
extensions.conf => odbc,asterisk,ast_config<br>
chan_dahdi.conf => odbc,asterisk,ast_config<br>
voicemail => odbc,asterisk,voicemail<br>
iaxusers => odbc,asterisk,iaxfriends<br>
iaxpeers => odbc,asterisk,iaxfriends<br>
queues => odbc,asterisk,queues<br>
;followme => odbc,asterisk,followme<br>
;followme_numbers => odbc,asterisk,followme_numbers<br>
musiconhold => odbc,asterisk,musiconhold<br>
<br>
ps_endpoints => odbc,asterisk<br>
ps_auths => odbc,asterisk<br>
ps_aors => odbc,asterisk<br>
ps_domain_aliases => odbc,asterisk<br>
ps_endpoint_id_ips => odbc,asterisk<br>
ps_contacts => odbc,asterisk<br>
<br>
</code></div>
</div>
Any ideas?<br>
<pre class="moz-signature" cols="72">--
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161</pre>
</body>
</html>