similar to: Help need to do Lookup from odbc database

Hi guys, Having issue with getting CDR to write to MS-SQL via ODBC. > cdr_odbc: Connected to freetds-connector > cdr_odbc: Error in PREPARE -1 > cdr_odbc: Query FAILED Call not logged! == Spawn extension (cisco, ##########, 2) exited non-zero on 'IAX2/astYYYY-507 Isql test: [xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY

Is there any way to return multiple values from functions defined in func_odbc.conf? It appears that you can only return one value. True? Hope not.... Doug. ____________________________________________________________________________________ Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/ -------------- next part

I'm trying to use func_odbc to write to a MS SQL db. Here's my func_odbc conf: [OPTIN] dsn=MSSQL-Optin write=INSERT into OptIn (orgID) values (${VAL1}) Dial Plan exten => +18665551212,n,Set(ODBC_OPTIN()=dave) When I do an odbc show, it shows that I am connected to the db. If I use isql, I can write to the db, however, when I use func_odbc, a record will not write. I'm using

Hi listers, We want to implement one call center with asterisk. The idea is it should be scalable, with openser as an dispatcher and bunch of asterisk servers to do ACD, Queues, Agents things... Easy to say :( Look closely to the current asterisk, we do see some problem: - SIP registrations was stored in astdb. - And queue members also was stored in astdb. - ... asterisk was built as

Hi, I'm getting the following at asterisk startup. OCBC was working with 1.4 no problem, but now under 1.6 (I've tried 1.6.1, 1.6.2-beta3/beta4) I can't seem to get rid of this .... anyone? WARNING[32664]: loader.c:385 load_dynamic_module: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined symbol: ast_odbc_clear_cache

Hi all, I am planning to implement LCR routing on my already running asterisk server. Uptill now i have found out that asterisk has no support for lcr, i have to do something about it myself, for example using the AGI. Im looking for ideas here. Whats the best way to start implementing lcr in asterisk. Should i use agi and start implementing my own lcr script or is there any plugin available which

Hi all, The asterisk book states the following for using ODBC to connect to an MS database. ? The pooling and limit options are quite useful for MS SQL Server and Sybase databases. These permit you to establish multiple connections (up to limit connections) to a database while ensuring that each connection has only one statement executing at once (this is due to a limitation in the protocol

Hi, I'm using gotoiftime on asterisk, but it seems  there is a difference between the asterisk time and the system time. could it be because i adjusted the system timezone on my linux? do asterisk not detect the change of timezone on the system? How can I fix this prob? Regards, nhadie -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi, I have a strange problem. I'm using Asterisk 1.4.xx with ODBC storage (FreeTDS -> Mssql 2008 database). Everything it's working fine, but sometimes I receive this error and Asterisk crashes. [Aug 25 13:25:13] WARNING[14032] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk /voicemail/default/7002/INBOX'] [Aug 25

Hello, Does asterisk func odbc support multi query? I'm executing stored procedure which returns two tables. With tsql command I can see both tables. But asterisk only shows the first. My database is MSSQL. Maybe there is workaround... Thanks -- Best Regards, Giedrius -------------- next part -------------- An HTML attachment was scrubbed... URL:

Ok, sorry for the response on the same thread. This is a new one. The main thing is that with this I set the Store Procedure or Query directly on the dialplan line, is easier to configure, change, manage, etc. I also know that works great with heavy load, and it reconnects when the network goes down and up. Can you help me porting this app? I think woun`t be difficult for someone that

Hi. Is it possible to override the standard DB function in Asterisk? My dialplan contains a lot of calls to "Set(DB(...))" and "${DB(...)} which of course use astdb to store/read data. I would like to stop using astdb and switch to Clustered MySQL (I don't suppose "clustered astdb" exists?). So instead of rewriting extensions.conf and replacing the DB calls with

Hi, Since I've upgraded to Asterisk 1.4 I can't use a MySQL database anymore for select queries :-( I'm using dbquery from MysqlPool Application 1.4 and selecting something from a table returns nothing even if I try to do a query like "SELECT 1;" Is anyone in the same troubles ? Do you advice me another solution to connect to my database ? For information, I'm using

Dear List, I have an asterisk 1.6.2 installation. I'm trying to configure func_odbc to read some mysql tables... but every time I tried I got this message: ERROR[24968] func_odbc.c: Unable to execute query [SELECT bloqueada FROM funciones WHERE extension='750'] I'm sure the DSN is right because I can do this: [root at grupodelavega asterisk]# su - asterisk [asterisk at

Hi list, I hope someone could help me. I've started using Asterisk 1.6.0.14 to get queue logs in real time with odbc (our databases are all PostgreSQL) but it's not working. However, cdr odbc is working well. When asterisk starts next message appears: WARNING[4217] config.c: Realtime mapping for 'queue_log' found to engine 'odbc', but the engine is not available My

Hi all, I'm trying to set up an odbc connection to a ms-sql server from an asterisk 1.6.1 install My problem is that I cannot get asterisk to build func_odbc & res_odbc.so I installed yum -y install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel And then went on to reconfigure / recompile asterisk after a ./configure --with-odbc=/usr/lib/ I get

Yell at me if you will, but I hate func_realtime - it's not very usable nor is it change-friendly (update your database and your dialplan completely breaks). I'm getting a new 1.6 box built out and working, and wanted to emulate the functionality of APP_realtime somehow, so I started digging around in the func_realtime source - here's what I came up with: For 1.6.0, look at line 86

Hi, Why do CDR second field, src field have a dest???? The real src field is 9500. Is a bug?? Example; "Q-aereos","1147938811","9500","outbound","1147938811","DAHDI/31-1","SIP/9500-0de0ea60","Dial","SIP/9500|60|t","2009-08-11 18:12:41","2009-08-11 18:12:45","2009-08-11

?Many people are reporting the same issue, so it is not my imagination. Asterisk 13 above 13.1 is useless for anybody who ?relies on res_odbc.so. As you know, after that version, the dropped the complexity of Pooling onto unix_odbc itself. Not so simple, it seems. I noticed that after a few hours of inactivity, any call to func_odbc-defined funcions will block and hang for ever. All we can do at

This is primarily aimed at Sir Lesher, whose name graces the source code for func_odbc that I'm currently trying to read to answer this question. Tilghman (or anyone else who has determined the answer to this query), I have googled, searched wikis, and I'm currently perusing the source code, but the long and short of it is that I cannot seem to find any reference to variables set by