<p>You could try our qloaderd - it was made for MySQL, but it should be simple enough that by changing the engine should be a no-brainer (it's a perl script). You get the added advantage that in case anything goes wrong with the DB system, you lose no data.</p>
<p>It is here: <a href="http://queuemetrics.com/download.jsp">http://queuemetrics.com/download.jsp</a></p><p>l.</p><p> <br></p><br><div class="gmail_quote">2009/2/27 Rajkumar S <span dir="ltr"><<a href="mailto:rajkumars@gmail.com">rajkumars@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi,<br>
<br>
I am trying to log queue_log to odbc (MS SQL) I have res_odbc.conf<br>
configured and modules.conf have<br>
<br>
preload => res_odbc.so<br>
preload => res_config_odbc.so<br>
<br>
extconfig.conf has queue_log => odbc,asterisk.<br>
<br>
When I start asterisk I get the following messages. The important one being:<br>
<br>
Realtime mapping for 'queue_log' found to engine 'odbc', but the<br>
engine is not available<br>
<br>
I can see that res_odbc is loading and registering Config Engine odbc,<br>
but that's after logger has started. Any clue what I am doing wrong?<br>
<br>
with regards,<br>
<br>
raj<br>
<br>
Asterisk 1.6.0.5, Copyright (C) 1999 - 2008 Digium, Inc. and others.<br>
<snip><br>
=========================================================================<br>
== Parsing '/etc/asterisk/asterisk.conf': == Found<br>
== Parsing '/etc/asterisk/extconfig.conf': == Found<br>
== Binding queue_log to odbc/asterisk/queue_log<br>
Started Asterisk Event Logger<br>
Realtime mapping for 'queue_log' found to engine 'odbc', but the<br>
engine is not available<br>
Asterisk Event Logger Started /var/log/asterisk/event_log<br>
3 modules will be loaded.<br>
Connecting sqlserver<br>
Asterisk Dynamic Loader Starting:<br>
== Parsing '/etc/asterisk/modules.conf': == Found<br>
== Parsing '/etc/asterisk/res_odbc.conf': == Found<br>
res_odbc: Connected to sqlserver [DSN_NAME]<br>
Registered ODBC class 'sqlserver' dsn->[DSN_NAME]<br>
res_odbc loaded.<br>
res_odbc.so => (ODBC resource)<br>
Registered Config Engine odbc<br>
<br>
_______________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Loway - home of QueueMetrics - <a href="http://queuemetrics.com">http://queuemetrics.com</a><br><br>