search for: mailboxuser

Hi list, i wonder if this is possible with some dovecot configuration. Selected mailboxusers will only mark their mails as deleted, when a mail is being deleted through any client. No automatic expunge. This is default behaviour in Outlook, and i think in Thunderbird too, but unfortunately not in Open-Xchange for example. So i was asking myself if it would be possible to simply turn thi...

...(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 | longblob | YES | | NULL > > | | > > > +----------------+-------------+------+-----+---------+-------+...

...(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 | longblob | 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

...4: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 'SIP/0015-00000007&...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 5 May 2015, zucca at systemschmiede.com wrote: > i wonder if this is possible with some dovecot configuration. > Selected mailboxusers will only mark their mails as deleted, when a mail is > being deleted through any client. > No automatic expunge. That's a client configuration out of the reach of Dovecot. Maybe you can work around this behaviour with: http://wiki2.dovecot.org/Plugins/Lazyexpunge > This is defaul...

...r 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/20090717/6627ce44/attachmen...

...k, 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 sqlserver [kupalaodbc] ------...

...4: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 'SIP/1ffa9-00000007...

...| | 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 | longblob | YES | | NULL | | +----------------+-------------+------+-----+---------+----------------+ 11 rows in set (0.00...

...t(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 causing this error? Why would MySQL not have enough memory? What does it mean, "poin...

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