[Home]

Summary:ASTERISK-02925: Pbx_realtime - SQL Fetch error!
Reporter:pmichalek (pmichalek)Labels:
Date Opened:2004-12-05 08:45:54.000-0600Date Closed:2011-06-07 14:10:06
Priority:MinorRegression?No
Status:Closed/CompleteComponents:Core/General
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:There is an error, when pbx_realtime is fetching a query. Problems are mostly in realtime_odbc and sometimes in realtime_multi_odbc. Log with sql query and binded parameters is attached.

****** STEPS TO REPRODUCE ******

Reproducibility is about 50%. Always after hangingup unanswered call SIP-SIP. Other types of calls are untested.

****** ADDITIONAL INFORMATION ******

Dec  5 15:24:57 WARNING[23876]: res_config_odbc.c:132 realtime_odbc: SQL Fetch error!
[SELECT * FROM extensions WHERE exten = ? AND context = ? AND priority = ?]

Dec  5 15:24:57 WARNING[23876]: res_config_odbc.c:135 realtime_odbc: SQL BIND![1]
Dec  5 15:24:57 WARNING[23876]: res_config_odbc.c:135 realtime_odbc: SQL BIND![d%]
Dec  5 15:24:57 WARNING[23876]: res_config_odbc.c:135 realtime_odbc: SQL BIND![(null)]
Dec  5 15:24:57 WARNING[23876]: res_config_odbc.c:137 realtime_odbc: SQL BIND!==========================
Comments:By: Brian West (bkw918) 2004-12-05 13:02:29.000-0600

Please post your configs.. works fine here.. I suspect a config issue.
By: pmichalek (pmichalek) 2004-12-05 17:35:46.000-0600

My configuration... Please tell me, if you need additional information?

extconfig.conf:
========
[settings]
iaxfriends => odbc,mysql1,iaxfriends
sipfriends => odbc,mysql1,sipfriends
voicemail => odbc,mysql1,voicemail

table = ast_config
connection = mysql1
extensions=>odbc,mysql1,extensions

extensions.conf:
=========
[general]
static=yes
writeprotect=yes
autofallthrough=yes

[globals]

[default]
exten => _.,1,Answer
exten => _.,2,BackGround(demo-congrats)
exten => _.,3,Congestion

[xxxx-sip-bt100]
include => xxxx-incoming
include => xxxx-outgoing

[xxxx-e1]
include => xxxx-incoming
include => xxxx-outgoing
;include => xxxx-mailbox

[xxxx-incoming]
switch=>Realtime/xxxx-incoming@extensions
include => xxxx-mailbox

[xxxx-mailbox]
exten => _.,102,Voicemail(b${EXTEN}@xxxx-mailbox)       ; BUSY
exten => _.,n,Voicemail(u${EXTEN}@xxxx-mailbox)         ; UNAVAILABLE

[xxxx-outgoing]
exten => _000.,1,Dial(Zap/g1/${EXTEN:1})    
exten => _0[1-9].,1,Dial(Zap/g1/00420${EXTEN:1},,t)
exten => _0.,2,Congestion

cat /etc/asterisk/res_odbc.conf
================
;;; odbc setup file


[ENV]
VAR=VALUE

[mysql1]
dsn => MySQL-asterisk
username => xxxxxxxx
password => ********
pre-connect => yes

MySQL:
====
CREATE TABLE `extensions` (
 `context` varchar(20) NOT NULL default '',
 `exten` varchar(20) NOT NULL default '',
 `priority` varchar(100) NOT NULL default '0',
 `app` varchar(20) NOT NULL default '',
 `appdata` varchar(50) default '',
 `descr` text,
 `flags` int(2) NOT NULL default '0',
 PRIMARY KEY  (`context`,`priority`,`exten`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

edited on: 12-05-04 17:41
By: Brian West (bkw918) 2004-12-05 18:43:33.000-0600

test it with isql and a realtime load at the cli

bkw
By: pmichalek (pmichalek) 2004-12-05 19:00:15.000-0600

Db connection seems to be working OK...
Mysql is about 14 days old - downloaded from mysql.com and unixODBC is from fedora-core 2

Is not problem in that we are selecting with NULL criteria on NOT NULL column?

If it will help, I am able to give you ssh access to our mashine.
By: Mark Spencer (markster) 2004-12-09 13:56:51.000-0600

Given the number of people that have this working, I'm pretty confident this is a configuration issue.  Please have bkw_ or one of the other bug marshals reopen this bug if they somehow find that it really is a bug.