Apparently while it was a simple question it was either not a simple answer or no one found it interesting.. <br><br>I guess i'll give an example:<br><br>Here is a hard coded queue.conf queue configuration that i would like to put into real time config
<br><br>[CAIS]<br>musicclass = default<br>announce = queue-markq<br>strategy = rrmemory<br>context = queue<br>timeout = 15<br>retry = 333<br>weight=0<br>wrapuptime=90<br>autofill=yes<br>autopause=yes<br>maxlen = 0<br>announce-frequency = 90
<br>periodic-announce-frequency=60<br>; announce-round-seconds = 10<br>queue-youarenext = queue-youarenext<br>queue-thereare = queue-thereare<br>queue-callswaiting = queue-callswaiting<br>queue-thankyou = queue-thankyou<br>
queue-lessthan = queue-less-than<br>queue-reporthold = queue-reporthold<br>periodic-announce = queue-periodic-announce<br>;monitor-format = gsm|wav|wav49<br>;monitor-type = MixMonitor<br>;monitor-join = yes<br>joinempty = strict
<br>eventwhencalled = yes<br>eventmemberstatus = yes<br>reportholdtime = yes<br>ringinuse = no<br>memberdelay = 1<br>timeoutrestart = yes<br><br><br>Now the issue i've run into is this: the Real time queue is configured with the fallowing mySQL database setup
<br><br>CREATE TABLE queue_table (
<br><span style="font-family: monospace;"> name VARCHAR(128) PRIMARY KEY,
</span><br><span style="font-family: monospace;"> musiconhold VARCHAR(128),
</span><br><span style="font-family: monospace;"> announce VARCHAR(128),
</span><br><span style="font-family: monospace;"> context VARCHAR(128),
</span><br><span style="font-family: monospace;"> timeout INT(11),
</span><br><span style="font-family: monospace;"> monitor_join BOOL,
</span><br><span style="font-family: monospace;"> monitor_format VARCHAR(128),
</span><br><span style="font-family: monospace;"> queue_youarenext VARCHAR(128),
</span><br><span style="font-family: monospace;"> queue_thereare VARCHAR(128),
</span><br><span style="font-family: monospace;"> queue_callswaiting VARCHAR(128),
</span><br><span style="font-family: monospace;"> queue_holdtime VARCHAR(128),
</span><br><span style="font-family: monospace;"> queue_minutes VARCHAR(128),
</span><br><span style="font-family: monospace;"> queue_seconds VARCHAR(128),
</span><br><span style="font-family: monospace;"> queue_lessthan VARCHAR(128),
</span><br><span style="font-family: monospace;"> queue_thankyou VARCHAR(128),
</span><br><span style="font-family: monospace;"> queue_reporthold VARCHAR(128),
</span><br><span style="font-family: monospace;"> announce_frequency INT(11),
</span><br><span style="font-family: monospace;"> announce_round_seconds INT(11),
</span><br><span style="font-family: monospace;"> announce_holdtime VARCHAR(128),
</span><br><span style="font-family: monospace;"> retry INT(11),
</span><br><span style="font-family: monospace;"> wrapuptime INT(11),
</span><br><span style="font-family: monospace;"> maxlen INT(11),
</span><br><span style="font-family: monospace;"> servicelevel INT(11),
</span><br><span style="font-family: monospace;"> strategy VARCHAR(128),
</span><br><span style="font-family: monospace;"> joinempty VARCHAR(128),
</span><br><span style="font-family: monospace;"> leavewhenempty VARCHAR(128),
</span><br><span style="font-family: monospace;"> eventmemberstatus BOOL,
</span><br><span style="font-family: monospace;"> eventwhencalled BOOL,
</span><br><span style="font-family: monospace;"> reportholdtime BOOL,
</span><br><span style="font-family: monospace;"> memberdelay INT(11),
</span><br><span style="font-family: monospace;"> weight INT(11),
</span><br><span style="font-family: monospace;"> timeoutrestart BOOL
</span><br>);<br><br>Now say i would like to use the new feature ringinuse, however this is not a column in the database/table, can i just add a column? will that work... or do i have to wait until an update/fix is made to res_mysql?
<br><br>If you do have to wait until an update is made to res_mysql... why is it designed like this? to me it seems a better design would be to have a database/table setup strictly as <KEY> <VALUE> where each column's name is EXACTLY the same as the config option name and the VALUE can be a string with the value... that way when any new config options are added to any of the configuration files you simple just query the database for every key and pull any values found...
<br><br><br><br><div><span class="gmail_quote">On 4/26/07, <b class="gmail_sendername">0xception</b> <<a href="mailto:0xception@gmail.com">0xception@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi... <br><br>I just had a real quick and simple question... I have a asterisk implementation setup w/ real time off of a mySQL database for SIP peers and queues, voicemail, agents etc... I after the upgrade to asterisk 1.4.3
there are some new configuration features i would like to use. I was wondering if i could just add to the database table a column for the new config option? if this will work or not...<br><br>For example my queues.conf configuration in the database does not have a column for ringinuse so if i were just just add a column called ringinuse would this work? would this have to be a string for either yes or no or would it be a bool or an integer?
<br><br><br>thanks for any help<br>
</blockquote></div><br>