[Home]

Summary:ASTERISK-17016: Conference with scheduler blocks on realtime ODBC connection to MSSQL database
Reporter:tnakonz (tnakonz)Labels:
Date Opened:2010-11-24 07:58:39.000-0600Date Closed:2010-11-27 04:41:22.000-0600
Priority:BlockerRegression?No
Status:Closed/CompleteComponents:Applications/app_meetme
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:In the SQL select statement is an error in the formatting of the datetime string. The profiler recognizes the following parameter: "2010-11-24 10:04:".

To resolve this problem change the following lines in the app_meetme.c:
line 3786 in find_conf_realtime: char currenttime[19] = ""; --> char currenttime[21] = "";
line 3787 in find_conf_realtime: char eatime[19] = ""; --> char eatime[21] = "";

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

Asterisk log:

[Nov 24 14:47:29] NOTICE[16898]: res_odbc.c:1472 odbc_obj_connect: Connecting RealtimeConfiguration
[Nov 24 14:47:29] NOTICE[16898]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to RealtimeConfiguration [MSSQL_Asterisk]
   -- Executing [5555@default:1] MeetMe("SIP/2000-00000000", "1")
 == Parsing '/etc/asterisk/meetme.conf':   == Found
[Nov 24 14:47:29] WARNING[16898]: res_odbc.c:634 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 22007: [FreeTDS][SQL Server]Conversion failed when converting date and/or time from character string. (94)
[Nov 24 14:47:29] WARNING[16898]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...
[Nov 24 14:47:29] WARNING[16898]: res_odbc.c:742 ast_odbc_sanity_check: Connection is down attempting to reconnect...
Comments:By: Digium Subversion (svnbot) 2010-11-27 04:39:02.000-0600

Repository: asterisk
Revision: 296466

U   branches/1.6.2/apps/app_meetme.c

------------------------------------------------------------------------
r296466 | tilghman | 2010-11-27 04:39:01 -0600 (Sat, 27 Nov 2010) | 5 lines

18 characters is too short for most date/times (20 is the usual, but we add more in case of greater precision).

(closes issue ASTERISK-17016)
Reported by: tnakonz

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=296466
By: Digium Subversion (svnbot) 2010-11-27 04:40:23.000-0600

Repository: asterisk
Revision: 296467

_U  branches/1.8/
U   branches/1.8/apps/app_meetme.c

------------------------------------------------------------------------
r296467 | tilghman | 2010-11-27 04:40:22 -0600 (Sat, 27 Nov 2010) | 12 lines

Merged revisions 296466 via svnmerge from
https://origsvn.digium.com/svn/asterisk/branches/1.6.2

........
 r296466 | tilghman | 2010-11-27 04:39:01 -0600 (Sat, 27 Nov 2010) | 5 lines
 
 18 characters is too short for most date/times (20 is the usual, but we add more in case of greater precision).
 
 (closes issue ASTERISK-17016)
  Reported by: tnakonz
........

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=296467
By: Digium Subversion (svnbot) 2010-11-27 04:41:21.000-0600

Repository: asterisk
Revision: 296468

_U  trunk/
U   trunk/apps/app_meetme.c

------------------------------------------------------------------------
r296468 | tilghman | 2010-11-27 04:41:21 -0600 (Sat, 27 Nov 2010) | 19 lines

Merged revisions 296467 via svnmerge from
https://origsvn.digium.com/svn/asterisk/branches/1.8

................
 r296467 | tilghman | 2010-11-27 04:40:22 -0600 (Sat, 27 Nov 2010) | 12 lines
 
 Merged revisions 296466 via svnmerge from
 https://origsvn.digium.com/svn/asterisk/branches/1.6.2
 
 ........
   r296466 | tilghman | 2010-11-27 04:39:01 -0600 (Sat, 27 Nov 2010) | 5 lines
   
   18 characters is too short for most date/times (20 is the usual, but we add more in case of greater precision).
   
   (closes issue ASTERISK-17016)
    Reported by: tnakonz
 ........
................

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=296468