Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] cdr_odbc: Error in ExecDirect: -1


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
vitor.mazuco at gmail.com
Guest





PostPosted: Wed Jan 13, 2016 8:49 am    Post subject: [asterisk-users] cdr_odbc: Error in ExecDirect: -1 Reply with quote

Hi everybody!

I'm trying to install a CDR Viewer https://github.com/g613/asterisk-cdr-viewer

I'ts work well, but my problem is to make Asterisk store to MySQL using ODBC

When I make a call the CLI returns for me

See the log:
== Using SIP RTP CoS mark 5
-- Executing [2021@ramais:1] Dial("SIP/2020-00000000",
"SIP/2021,60,tT") in new stack
== Using SIP RTP CoS mark 5
-- Called SIP/2021
-- SIP/2021-00000001 is ringing
Quote:
0x7fd3f8014240 -- Probation passed - setting RTP source
address to 192.168.25.49:35528
[Jan 13 11:31:07] NOTICE[2279][C-00000000]: res_rtp_asterisk.c:4441
ast_rtp_read: Unknown RTP codec 95 received from '(null)'
-- SIP/2021-00000001 answered SIP/2020-00000000
Quote:
0x7fd3b4004eb0 -- Probation passed - setting RTP source
address to 192.168.25.100:8000
Quote:
0x7fd3f8014240 -- Probation passed - setting RTP source
address to 192.168.25.49:35528
Quote:
cdr_odbc: Error in ExecDirect: -1
[Jan 13 11:31:08] WARNING[2279][C-00000000]: res_odbc.c:604
ast_odbc_direct_execute: SQL Execute error! Verifying connection to
asterisk [asterisk-connector]...
Quote:
cdr_odbc: Error in ExecDirect: -1
[Jan 13 11:31:08] ERROR[2279][C-00000000]: cdr_odbc.c:177 odbc_log:
CDR direct execute failed


See my res_odbc.conf

[asterisk]
enabled = yes
dsn = asterisk-connector
username = root
password = 100567
pooling = no
limit = 1
pre-connect = yes

What can be happened?

Thank in advanced.

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
patrick at laimbock.com
Guest





PostPosted: Wed Jan 13, 2016 12:13 pm    Post subject: [asterisk-users] cdr_odbc: Error in ExecDirect: -1 Reply with quote

On 01/13/16 14:48, Vitor Mazuco wrote:
Quote:
Hi everybody!

I'm trying to install a CDR Viewer https://github.com/g613/asterisk-cdr-viewer

I'ts work well, but my problem is to make Asterisk store to MySQL using ODBC

When I make a call the CLI returns for me

See the log:
== Using SIP RTP CoS mark 5
-- Executing [2021@ramais:1] Dial("SIP/2020-00000000",
"SIP/2021,60,tT") in new stack
== Using SIP RTP CoS mark 5
-- Called SIP/2021
-- SIP/2021-00000001 is ringing
Quote:
0x7fd3f8014240 -- Probation passed - setting RTP source
address to 192.168.25.49:35528
[Jan 13 11:31:07] NOTICE[2279][C-00000000]: res_rtp_asterisk.c:4441
ast_rtp_read: Unknown RTP codec 95 received from '(null)'
-- SIP/2021-00000001 answered SIP/2020-00000000
Quote:
0x7fd3b4004eb0 -- Probation passed - setting RTP source
address to 192.168.25.100:8000
Quote:
0x7fd3f8014240 -- Probation passed - setting RTP source
address to 192.168.25.49:35528
Quote:
cdr_odbc: Error in ExecDirect: -1
[Jan 13 11:31:08] WARNING[2279][C-00000000]: res_odbc.c:604
ast_odbc_direct_execute: SQL Execute error! Verifying connection to
asterisk [asterisk-connector]...
Quote:
cdr_odbc: Error in ExecDirect: -1
[Jan 13 11:31:08] ERROR[2279][C-00000000]: cdr_odbc.c:177 odbc_log:
CDR direct execute failed


See my res_odbc.conf

[asterisk]
enabled = yes
dsn = asterisk-connector
username = root
password = 100567
pooling = no
limit = 1
pre-connect = yes

What can be happened?

Thank in advanced.

Just a guess but try setting "pooling" to yes and "limit" to a higher value.

Best,
Patrick

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services