VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
View previous topic :: View next topic |
Author |
Message |
vitor.mazuco at gmail.com Guest
|
Posted: Wed Jan 13, 2016 8:49 am Post subject: [asterisk-users] cdr_odbc: Error in ExecDirect: -1 |
|
|
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
|
Posted: Wed Jan 13, 2016 12:13 pm Post subject: [asterisk-users] cdr_odbc: Error in ExecDirect: -1 |
|
|
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 |
|
|
|
|
|
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
|