search for: origtime

Hi, Is there any reason why ODBC voicemail storage requires varchar for most fields? For example, is there anything stopping me using a BIGINT or similar for origtime or INT for duration? Kind regards, Dan

...| int(11) | YES | | NULL | | | dir | varchar(80) | YES | MUL | NULL | | | context | varchar(80) | YES | | NULL | | | macrocontext | varchar(80) | YES | | NULL | | | callerid | varchar(40) | YES | | NULL | | | origtime | varchar(40) | YES | | NULL | | | duration | varchar(20) | YES | | NULL | | | recording | longblob | YES | | NULL | | +--------------+-------------+------+-----+---------+-------+ manage users and storing voicemail messages according to s...

...(80) | YES | MUL | NULL > > | | > > | context | varchar(80) | YES | | NULL > > | | > > | macrocontext | varchar(80) | YES | | NULL > > | | > > | callerid | varchar(40) | YES | | NULL > > | | > > | origtime | varchar(40) | YES | | NULL > > | | > > | duration | varchar(20) | YES | | NULL > > | | > > | mailboxuser | varchar(80) | YES | | NULL > > | |* > > | mailboxcontext | varchar(80) | YES | | NULL > > |...

...updated schema for the generic voicemail storage table. Apparently, only the "flag" field has appeared, but I can't find out what is the type of the field. Here are the fields it's trying to update : [INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)] I had to roll back to 1.6.1.0 in the meantime. Thanks. Hoggins! -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/200907...

...(80) | YES | MUL | NULL > > | | > > | context | varchar(80) | YES | | NULL > > | | > > | macrocontext | varchar(80) | YES | | NULL > > | | > > | callerid | varchar(40) | YES | | NULL > > | | > > | origtime | varchar(40) | YES | | NULL > > | | > > | duration | varchar(20) | YES | | NULL > > | | > > | mailboxuser | varchar(80) | YES | | NULL > > | |* > > | mailboxcontext | varchar(80) | YES | | NULL > > |...

I have Asterisk 1.4.32 and I would like save all VoiceMail to MSSQL 2008 database. I configured ODBC, but I receive this errors. [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: Connecting sqlserver [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] [Jun 18 14:00:37] WARNING[19914] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail

...]... [2014-05-28 14:55:13] WARNING[12260][C-00000006]: app_voicemail.c:4086 insert_data_cb: SQL Direct Execute failed! [2014-05-28 14:55:13] WARNING[12260][C-00000006]: app_voicemail.c:4202 store_file: SQL Execute error! [INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag,msg_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)] == Parsing '/var/spool/asterisk/voicemail/default/701/INBOX/msg0000.txt': Found == Parsing '/var/spool/asterisk/voicemail/default/701/INBOX/msg0000.txt': Found -- Auto fallthrough, channel ...

...xt file in /var/spool/asterisk/voicemail/default/101/INBOX ; ; Message Information file ; [message] origmailbox=101 context=voicepulse-in macrocontext= exten=12222222 priority=5 callerchan=SIP/mrXXXX-08XXXX callerid="ATIVA DAVID " <3333333> origdate=Wed Jan 28 06:20:34 PM EST 2009 origtime=1233184834 category= duration=6 Thank you. I really appreciate any help. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090128/18e8a7cf/attachment.htm

...emove (Reported by Corey Farrell) * ASTERISK-24799 - [patch] make fails with undefined reference to SSLv3_client_method (Reported by Alexander Traud) * ASTERISK-24787 - [patch] - Microsoft exchange incompatibility for playing back messages stored in IMAP - play_message: No origtime (Reported by Graham Barnett) * ASTERISK-24814 - asterisk/lock.h: Fix syntax errors for non-gcc OSX with 64 bit integers (Reported by Corey Farrell) * ASTERISK-24796 - Codecs and bucket schema's prevent module unload (Reported by Corey Farrell) * ASTERISK-24724 - 'httpstatus...

...en') > > > msg0001.txt looks like this: > > [message] > origmailbox=400 > context=vm-in > macrocontext= > exten=vmu > priority=106 > callerchan=SIP/vm-082b9f78 > callerid="Buck Aneer" <300> > origdate=Thu Sep 28 04:18:36 PM UTC 2006 > origtime=1159460316 > category= > duration=7 > > > No entry in voicemail config file for "3" leads me to think that > Asterisk is parsing "300" from the callerid line above as "3", which > obviously isn't correct. There is a 300 in the voicemail con...

Ok, this issue I resolved, I just changed the TDS version to 7.0. But now I receive different error, I can't insert into database. [Jun 19 14:30:25] WARNING[6212] app_voicemail.c: SQL Prepare failed![INSERT INTO pbx_VoiceMail (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext) VALUES (?,?, ? , ?,?,?,?,?,?,?)] [Jun 19 14:30:25] WARNING[6212] res_odbc.c: SQL Prepare failed. Attempting a reconnect... [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: Connecting sqlserver [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: res_odbc: Connected to sqlserve...

...--- s n i p ----- And the msg0000.txt file look like this: ----- s n i p ----- ; ; Message Information file ; [message] origmailbox=500 context=macro-switchboard-number macrocontext=default exten=s priority=26 callerchan=IAX2/alexander-1 callerid=XXXXXXXXX origdate=Thu Nov 1 12:43:38 PM UTC 2007 origtime=1193921018 category= duration=17 ----- s n i p ----- Alexander is the PRI Asterisk that IAX2 forwards all calls to Graham (where the log above is from). And the call to '*500' was made from 597. I have a *xxx extension because the 500 voicebox is a switchboard voicemail and can/should be c...

Hi all, What's the best method to send automon call recordings (*1) to the voicemail box of the Asterisk user? Do you have to trap hangups, etc, or is there some global variable that can be set? Thanks! S.

...emove (Reported by Corey Farrell) * ASTERISK-24799 - [patch] make fails with undefined reference to SSLv3_client_method (Reported by Alexander Traud) * ASTERISK-24787 - [patch] - Microsoft exchange incompatibility for playing back messages stored in IMAP - play_message: No origtime (Reported by Graham Barnett) * ASTERISK-24814 - asterisk/lock.h: Fix syntax errors for non-gcc OSX with 64 bit integers (Reported by Corey Farrell) * ASTERISK-24796 - Codecs and bucket schema's prevent module unload (Reported by Corey Farrell) * ASTERISK-24724 - 'httpstatus...

...]... [2014-05-28 14:55:13] WARNING[12260][C-00000006]: app_voicemail.c:4086 insert_data_cb: SQL Direct Execute failed! [2014-05-28 14:55:13] WARNING[12260][C-00000006]: app_voicemail.c:4202 store_file: SQL Execute error! [INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag,msg_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)] == Parsing '/var/spool/asterisk/voicemail/default/701/INBOX/msg0000.txt': Found == Parsing '/var/spool/asterisk/voicemail/default/701/INBOX/msg0000.txt': Found -- Auto fallthrough, channel ...

...p after outgoing PRI-Euroisdn call (Reported by Marcel Manz) * ASTERISK-24740 - [patch]Segmentation fault on aoc-e event (Reported by Panos Gkikakis) * ASTERISK-24787 - [patch] - Microsoft exchange incompatibility for playing back messages stored in IMAP - play_message: No origtime (Reported by Graham Barnett) * ASTERISK-24814 - asterisk/lock.h: Fix syntax errors for non-gcc OSX with 64 bit integers (Reported by Corey Farrell) * ASTERISK-24796 - Codecs and bucket schema's prevent module unload (Reported by Corey Farrell) * ASTERISK-24724 - 'httpstatus...

...p after outgoing PRI-Euroisdn call (Reported by Marcel Manz) * ASTERISK-24740 - [patch]Segmentation fault on aoc-e event (Reported by Panos Gkikakis) * ASTERISK-24787 - [patch] - Microsoft exchange incompatibility for playing back messages stored in IMAP - play_message: No origtime (Reported by Graham Barnett) * ASTERISK-24814 - asterisk/lock.h: Fix syntax errors for non-gcc OSX with 64 bit integers (Reported by Corey Farrell) * ASTERISK-24796 - Codecs and bucket schema's prevent module unload (Reported by Corey Farrell) * ASTERISK-24724 - 'httpstatus...

...| | dir | varchar(80) | YES | MUL | NULL | | | context | varchar(80) | YES | | NULL | | | macrocontext | varchar(80) | YES | | NULL | | | callerid | varchar(40) | YES | | NULL | | | origtime | varchar(40) | YES | | NULL | | | duration | varchar(20) | YES | | NULL | | | mailboxuser | varchar(80) | YES | | NULL | | | mailboxcontext | varchar(80) | YES | | NULL | | | recording |...

...iki: CREATE TABLE `voicemessages` ( `id` int(11) NOT NULL auto_increment, `msgnum` int(11) NOT NULL default '0', `dir` varchar(80) default '', `context` varchar(80) default '', `macrocontext` varchar(80) default '', `callerid` varchar(40) default '', `origtime` varchar(40) default '', `duration` varchar(20) default '', `mailboxuser` varchar(80) default '', `mailboxcontext` varchar(80) default '', `recording` longblob, PRIMARY KEY (`id`), KEY `dir` (`dir`) ) ENGINE=MyISAM; Does anybody have any ideas on what's...

Hi All, I have an issue with the ODBC voicemail storage option with asterisk. All appears to work fine, however, I get several sql execute warnings. I was wondering if anyone out there could help me get to the bottom of what is causing this and how I could possibly go about rectifying it. The warning message we are getting is as follows: WARNING[30115]: app_voicemail.c:1280 delete_file: SQL