Displaying 13 results from an estimated 13 matches for "ast_odbc_prepare_and_execute".
2015 Apr 25
4
Error writing CDR
...error line.
"mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both returned OK for all tables.
Environment is:
in production Asterisk 11.7.0~dfsg-1ubuntu1
Ubuntu 14.04.1 LTS
Any thoughts?
Thanx
Ethy
[Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:645
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23000:
[MySQL][ODBC 5.1 Driver][mysqld-5.5.40-0ubuntu0.14.04.1-log]Duplicate entry
'0000-00-00 00:00:00-1234-CLIENT_ID' for key 'PRIMARY' (133)
[Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:657
ast_odbc_prepare_and_execute: SQL Execute...
2013 Apr 18
5
Dynamic realtime + queues
...???????????????????????????strategy?????
?1??????? ???????????? support???????? ????????????????????????rrmemory???????????
?
There are more fields but these are the most important
?
I keep getting this error:
?
node1*CLI> queue show
No queues.
[Apr 18 22:41:06] WARNING[18599]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\' ORDER BY name' at line 1 (202)
[Apr 18 22:41:06] WARNING[18599]...
2013 Apr 19
1
Dynamic realtime + queues.conf Unresolved
...m getting the following errors from the asterisk console:
?
node1*CLI> queue show support
support has 0 calls (max unlimited) in 'rrmemory' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0% within 60s
?? No Members
?? No Callers
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\' AND queue_name = ? ORDER BY interface' at line 1 (226)
[Apr 19...
2015 Apr 25
1
Error writing CDR
...s.
> >
> > Environment is:
> > in production Asterisk 11.7.0~dfsg-1ubuntu1
> > Ubuntu 14.04.1 LTS
> >
> > Any thoughts?
> >
> > Thanx
> >
> > Ethy
> >
> > [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:645
> > ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23000:
> > [MySQL][ODBC 5.1 Driver][mysqld-5.5.40-0ubuntu0.14.04.1-log]Duplicate
> > entry '0000-00-00 00:00:00-1234-CLIENT_ID' for key 'PRIMARY' (133)
> >
> > [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:657
>...
2015 Apr 25
0
Error writing CDR
...ot;mysqlcheck -c -e -v DBase" both returned OK for all tables.
>
> Environment is:
> in production Asterisk 11.7.0~dfsg-1ubuntu1
> Ubuntu 14.04.1 LTS
>
> Any thoughts?
>
> Thanx
>
> Ethy
>
> [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:645
> ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23000:
> [MySQL][ODBC 5.1 Driver][mysqld-5.5.40-0ubuntu0.14.04.1-log]Duplicate entry
> '0000-00-00 00:00:00-1234-CLIENT_ID' for key 'PRIMARY' (133)
>
> [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:657
> ast_odbc_prepare_a...
2013 Oct 14
1
realtime voicemail asterisk 11
...|
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
[Oct 14 10:06:16] WARNING[10037][C-00000003]: res_odbc.c:645
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42S02:
[MySQL][ODBC 5.2(w) Driver][mysqld-5.6.12]Table 'asterisk.voicemessages'
doesn't exist (86)
[Oct 14 10:06:16] WARNING[10037][C-00000003]: res_odbc.c:657
ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to
asterisk [asteri...
2015 Sep 24
2
problems with PJSIP install on UBUNTU 14.04
Ok, I reinstalled pkg-config from apt-get and now I think it?s all good.
Man, PJSIP has been a chore to get working right on this server and on the
last. Though the last server wasn?t near the issue this was. Lol
I think what happened was that after initial trouble, I ran the ?install
prereq? or something like that and it must have did it?s own install of
pjsip that sent me down a duplicate path,
2015 Oct 16
2
pjsip database error when using MS SQL via ODBC
I have a project that is requiring the use of MS SQL from asterisk. I get
an error when the pjsip contact tries to update the contact table.
[Oct 15 21:34:55] WARNING[3033]: res_odbc.c:649
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 22018:
[FreeTDS][SQL Server]Conversion failed when converting the varchar value
'3.000000' to data type int. (101)
The datatype in MySQL is integer and in MS SQL is integer. What could be
the cause of this? Is it likely some kind of FeeTDS conversio...
2010 Oct 22
0
CEL ODBC problem in 1.8.0
...h CEL in a trunk version of asterisk for some time and have upgraded my test machine to 1.8.0 today.
Made a few calls and it looks like the eventtype field is missing in the CEL insert query when using ODBC. I see the following errors on the console:
[Oct 22 21:46:09] WARNING[952]: res_odbc.c:634 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23502: ERROR: null value in column "eventtype" violates not-null constraint;
Error while executing the query (101)
[Oct 22 21:46:09] WARNING[952]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...
[Oct 22 21:46:...
2015 Apr 26
1
Error writing CDR
...eturned OK for all tables.
>>
>> Environment is: in production Asterisk 11.7.0~dfsg-1ubuntu1 Ubuntu
>> 14.04.1 LTS
>>
>> Any thoughts?
>>
>> Thanx
>>
>> Ethy
>>
>> [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:645
>> ast_odbc_prepare_and_execute: SQL Execute returned an error -1:
>> 23000: [MySQL][ODBC 5.1
>> Driver][mysqld-5.5.40-0ubuntu0.14.04.1-log]Duplicate entry
>> '0000-00-00 00:00:00-1234-CLIENT_ID' for key 'PRIMARY' (133)
> Hi Ethy,
>
> why date and time are empty?
>
> At least date...
2015 Apr 26
0
Error writing CDR
...ysqlcheck -c -e -v DBase" both
> returned OK for all tables.
>
> Environment is: in production Asterisk 11.7.0~dfsg-1ubuntu1 Ubuntu
> 14.04.1 LTS
>
> Any thoughts?
>
> Thanx
>
> Ethy
>
> [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:645
> ast_odbc_prepare_and_execute: SQL Execute returned an error -1:
> 23000: [MySQL][ODBC 5.1
> Driver][mysqld-5.5.40-0ubuntu0.14.04.1-log]Duplicate entry
> '0000-00-00 00:00:00-1234-CLIENT_ID' for key 'PRIMARY' (133)
Hi Ethy,
why date and time are empty?
At least date is used as a unique key and a uni...
2007 Oct 02
0
Segmentation fault in app_voicemail (ODBC/PSQL problem)
...uery () from /usr/lib/libodbcpsql.so
#3 0x0015c87c in SC_execute () from /usr/lib/libodbcpsql.so
#4 0x0014bd60 in PG_SQLExecute () from /usr/lib/libodbcpsql.so
#5 0x0014bf4d in SQLExecute () from /usr/lib/libodbcpsql.so
#6 0x00356cf7 in SQLExecute () from /usr/lib/libodbc.so.1
#7 0x00128e76 in ast_odbc_prepare_and_execute (obj=0x86e76e0, prepare_cb=0x113120 <custom_prepare>, data=0xb7d83794) at res_odbc.c:96
#8 0x00113511 in realtime_odbc (database=0xb7d838ec "asterisk", table=0xb7d837ec "miniminder.voicemail_users", ap=0xb7d83a04 "C???B")
at res_config_odbc.c:148
#9 0x0808c...
2016 Jan 18
2
Segmentation Fault Asterisk 13.7.0-rc2 (libmysqlclient?)
...ot;\340U\347\002\036\177\000\000\a\000\000\000\000\000\000\000;\000\000\000\000\000\000\000\002\000\000\000\035\177\000\001`\204\242\310\035\177\000\000\377\377\377\377\000\000\000\000\000"...
stmt = 0x0
__PRETTY_FUNCTION__ = "custom_prepare"
#4 0x00007f1e385b9783 in ast_odbc_prepare_and_execute (obj=0x1e588c8, prepare_cb=0x7f1e01e8f11f <custom_prepare>, data=0x7f1dc8a289b0) at res_odbc.c:640
res = 0
i = 0
attempt = 0
nativeerror = 0
numfields = 0
diagbytes = 0
state = "\v:\351\001\036\177\000\000t\001"
diagnos...