Re: [asterisk-users] Join and listen to conference call through web-interface
This will help you start: http://www.757.org/~joat/wiki/index.php?n=Main.HomebrewAsteriskConferenceManager On Sun, May 1, 2011 at 12:41 PM, Alec Taylor alec.tayl...@gmail.com wrote: Good Afternoon, I'm working on an audio conferencing web-frontend. It'd be helpful if I could know: • Who's connected to the conference • Number of people listening to the stream I also need to be able to manage/screen/kick participants. One way I can think of is having acting as proxy between conference call and guest, and if I approve them, connect them through to the conference call. Features required: • Web frontend to listen to live audio stream of conference call • Web frontend to join conference call (1 click call-in, grab mic input) Can I do this with asterisk? - If so, how? Otherwise, can you recommend a different FOSS project to use for this? Thanks, Alec Taylor -- _ -- 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 -- _ -- 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
Re: [asterisk-users] CDR on Transfer...
Did you find the solution? On Thu, Aug 26, 2010 at 7:25 PM, Carlos Chavez cur...@telecomabmex.comwrote: I have searched for some time but I have not found an asnwer on how to fix the CDR when a call is transferred. The problem is that if someone dials a cell phone and then transfers the call to another extensión the CDR for the cell call stops and there is no way to track that the call was transferred so we can bill correctly. Many people have asked this question but there is no answer, only a mention that it should be fixed in 1.6 which it is not (at least on 1.6.2.11). Any tips oh how to correct this problem? A lot of customers give me grief about this because they cannot properly bill people for their cell calls. -- Telecomunicaciones Abiertas de México S.A. de C.V. Carlos Chávez Prats Director de Tecnología +52-55-91169161 ext 2001 -- _ -- 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 -- _ -- 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
[asterisk-users] ODBC Voicemail storage
Hi, I have a strange problem. I'm using Asterisk 1.4.xx with ODBC storage (FreeTDS - Mssql 2008 database). Everything it's working fine, but sometimes I receive this error and Asterisk crashes. [Aug 25 13:25:13] WARNING[14032] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk /voicemail/default/7002/INBOX'] [Aug 25 13:25:13] WARNING[14032] res_odbc.c: SQL Prepare failed. Attempting a reconnect... [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: Connecting sqlserver [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] Regards Andraž -- _ -- 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
Re: [asterisk-users] ODBC Voicemail storage
No, I didn't. On Wed, Aug 25, 2010 at 4:20 PM, Tilghman Lesher tles...@digium.com wrote: On Wednesday 25 August 2010 07:27:58 Andraž wrote: I have a strange problem. I'm using Asterisk 1.4.xx with ODBC storage (FreeTDS - Mssql 2008 database). Everything it's working fine, but sometimes I receive this error and Asterisk crashes. [Aug 25 13:25:13] WARNING[14032] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk /voicemail/default/7002/INBOX'] [Aug 25 13:25:13] WARNING[14032] res_odbc.c: SQL Prepare failed. Attempting a reconnect... [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: Connecting sqlserver [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] Regards Andraž Did you enable pooling in res_odbc.conf? It is mandatory when connecting to SQL Server. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org -- _ -- 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 -- _ -- 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
Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR
No, from sources version 0.64 it's working fine. On Sat, Jul 31, 2010 at 10:59 AM, Tzafrir Cohen tzafrir.co...@xorcom.comwrote: On Fri, Jul 30, 2010 at 07:15:00AM -0400, Fred Posner wrote: On Jul 30, 2010, at 5:04 AM, Andraž wrote: Ok, problem is another, when I run configure, it write this: checking for tds_version in -ltds... no configure: *** configure: *** The FreeTDS installation on this system appears to be broken. configure: *** Either correct the installation, or run configure configure: *** without explicitly specifying --with-tds ODBC is not a good solution, only if I can change the names of CDR fields. Hmm what was the exact '--with-tds' option you used? Have you passed any explicit path? How can I repair the installlation? If the above: try just not passing any explicit path. Or maybe even skipping this option altogether. Also: Have you tried installing freetds from source? This suggestion does not make sense to me. The package 1.6.2 I have here builds cdr_tds just fine. The Ubuntu package likewise: http://packages.ubuntu.com/lucid/amd64/asterisk/filelist As you can see from its build dependencies: http://packages.ubuntu.com/source/lucid/asterisk It depends on libfreetds-dev Have you installed it? As a rule of thumb, using: aptitude build-dep asterisk might be a good start. -- Tzafrir Cohen icq#16849755 jabber:tzafrir.co...@xorcom.comjabber%3atzafrir.co...@xorcom.com +972-50-7952406 mailto:tzafrir.co...@xorcom.com http://www.xorcom.com iax:gu...@local.xorcom.com/tzafrir -- _ -- 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 -- _ -- 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
Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR
Ok, problem is another, when I run configure, it write this: checking for tds_version in -ltds... no configure: *** configure: *** The FreeTDS installation on this system appears to be broken. configure: *** Either correct the installation, or run configure configure: *** without explicitly specifying --with-tds ODBC is not a good solution, only if I can change the names of CDR fields. How can I repair the installlation? On Wed, Jul 28, 2010 at 2:58 PM, Andraž atle...@gmail.com wrote: I resolved this isue using odbc. On Mon, Jul 26, 2010 at 11:27 AM, Tzafrir Cohen tzafrir.co...@xorcom.comwrote: On Mon, Jul 26, 2010 at 10:05:27AM +0200, Andraž wrote: Hi, I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from sources. I installed freetds-common,freetds-dev, libct4, libsybdb5, freetds-bin, but, when I run configure and then make menuconfig in section Call Detail Recording - cdr_tds it's disabled. It only writes that Depends on: freetds(E). On another server (same configuration) I installed the same packages, and it's working fine. Any suggestions, what I did wrong? Have you re-ron ./configure #? -- Tzafrir Cohen icq#16849755 jabber:tzafrir.co...@xorcom.comjabber%3atzafrir.co...@xorcom.com +972-50-7952406 mailto:tzafrir.co...@xorcom.com http://www.xorcom.com iax:gu...@local.xorcom.com/tzafrir -- _ -- 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 -- _ -- 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
Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR
From source also doesn't work. :( On Fri, Jul 30, 2010 at 1:15 PM, Fred Posner f...@teamforrest.com wrote: On Jul 30, 2010, at 5:04 AM, Andraž wrote: Ok, problem is another, when I run configure, it write this: checking for tds_version in -ltds... no configure: *** configure: *** The FreeTDS installation on this system appears to be broken. configure: *** Either correct the installation, or run configure configure: *** without explicitly specifying --with-tds ODBC is not a good solution, only if I can change the names of CDR fields. How can I repair the installlation? On Wed, Jul 28, 2010 at 2:58 PM, Andraž atle...@gmail.com wrote: I resolved this isue using odbc. On Mon, Jul 26, 2010 at 11:27 AM, Tzafrir Cohen tzafrir.co...@xorcom.com wrote: On Mon, Jul 26, 2010 at 10:05:27AM +0200, Andraž wrote: Hi, I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from sources. I installed freetds-common,freetds-dev, libct4, libsybdb5, freetds-bin, but, when I run configure and then make menuconfig in section Call Detail Recording - cdr_tds it's disabled. It only writes that Depends on: freetds(E). On another server (same configuration) I installed the same packages, and it's working fine. Any suggestions, what I did wrong? Have you re-ron ./configure #? -- Tzafrir Cohenv Have you tried installing freetds from source? wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz tar -zxvf freetds-stable.tgz cd freetds-0.82 ./configure --prefix=/usr --with-tdsver=7.0 --with-unixodbc=/usr/lib or ./configure --prefix=/usr --with-tdsver=7.0 --with-unixodbc=/usr make make install ---fred http://qxork.com -- _ -- 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 -- _ -- 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
Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR
I removed freetds which I installed from apt-get. Run what you said and stil doesn't work. :( I just hit reply, so I don't touch the subject line. On Fri, Jul 30, 2010 at 2:12 PM, A J Stiles asterisk_l...@earthshod.co.ukwrote: On Friday 30 Jul 2010, Andraž wrote: From source also doesn't work. :( If you ran ldconfig to force update of library configuration after you installed the freetds you compiled, and re-ran ./configure in the asterisk build directory, and it still doesn't want to let you use freeTDS, then something else must be the problem. It's possible that the configure script is getting confused with the FreeTDS installed using apt-get and the FreeTDS installed from source code. So try $ ./configure --with-tds=/usr/local/lib to force it to use the freeTDS files found in /usr/local/lib (make appropriate substitutions if required). By the way: Your reply belongs *under* whatever you are replying to. Then, somebody reading the messages in future can see the proper flow of the conversation. -- AJS -- _ -- 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 -- _ -- 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
Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR
Tnx, now it's working fine. :) On Fri, Jul 30, 2010 at 5:16 PM, Sean Bright sean.bri...@gmail.com wrote: On 7/26/2010 4:05 AM, Andraž wrote: I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from sources. I installed freetds-common,freetds-dev, libct4, libsybdb5, freetds-bin, but, when I run configure and then make menuconfig in section Call Detail Recording - cdr_tds it's disabled. The packaged version of FreeTDS on 10.04 is 0.82 which is too recent for the Asterisk 1.4. cdr_tds module. The latest version of FreeTDS supported by Asterisk 1.4 is 0.64. So you will have to compile from source (or find an ancient package) to get this working. -- _ -- 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 -- _ -- 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
[asterisk-users] CDR and custom name fields
Hi, I have Asterisk 1.4, trought ODBC I'm savind CDR to MSSQL. How can I change the fields name of database? Regards Andraz -- _ -- 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
Re: [asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR
I resolved this isue using odbc. On Mon, Jul 26, 2010 at 11:27 AM, Tzafrir Cohen tzafrir.co...@xorcom.comwrote: On Mon, Jul 26, 2010 at 10:05:27AM +0200, Andraž wrote: Hi, I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from sources. I installed freetds-common,freetds-dev, libct4, libsybdb5, freetds-bin, but, when I run configure and then make menuconfig in section Call Detail Recording - cdr_tds it's disabled. It only writes that Depends on: freetds(E). On another server (same configuration) I installed the same packages, and it's working fine. Any suggestions, what I did wrong? Have you re-ron ./configure #? -- Tzafrir Cohen icq#16849755 jabber:tzafrir.co...@xorcom.comjabber%3atzafrir.co...@xorcom.com +972-50-7952406 mailto:tzafrir.co...@xorcom.com http://www.xorcom.com iax:gu...@local.xorcom.com/tzafrir -- _ -- 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 -- _ -- 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
[asterisk-users] AMI Monitor - one file
Hi, I try to record a conversation trough AMI (Monitor). In the documentation is written, that if you would like recordings to be in one file, just use Mix: 1. I use this parameter, but still I have 2 files. Filename-in.wav and Filename-out.wav. Regards Andraž -- _ -- 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
[asterisk-users] FreeTDS (Microsoft MsSQL 2008) and CDR
Hi, I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from sources. I installed freetds-common,freetds-dev, libct4, libsybdb5, freetds-bin, but, when I run configure and then make menuconfig in section Call Detail Recording - cdr_tds it's disabled. It only writes that Depends on: freetds(E). On another server (same configuration) I installed the same packages, and it's working fine. Any suggestions, what I did wrong? Regards Andraž attachment: cdr.PNG-- _ -- 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
Re: [asterisk-users] Voicemail ODBC
Yes, with isql it's working fine, I can see the database and all fields. On Sun, Jun 20, 2010 at 9:11 PM, Tilghman Lesher tles...@digium.com wrote: On Sunday 20 June 2010 13:15:11 Andraž wrote: If I use MySQL with the same fields it's working fine. I think that is something wrong with FreeTDS drivers. Could also be that you're specifying the database name incorrectly. Are you able to see the tables when using the 'isql' command line tool? -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org -- _ -- 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 -- _ -- 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
Re: [asterisk-users] Voicemail ODBC
Now it's workin fine. It was problem with drivers, because it doesn't support all kind of fields. I just changed from varblog to picture data type and now it's working fine. Tnx for help. On Mon, Jun 21, 2010 at 2:08 PM, Tilghman Lesher tles...@digium.com wrote: On Monday 21 June 2010 01:16:30 Andraž wrote: Yes, with isql it's working fine, I can see the database and all fields. On Sun, Jun 20, 2010 at 9:11 PM, Tilghman Lesher tles...@digium.com wrote: On Sunday 20 June 2010 13:15:11 Andraž wrote: If I use MySQL with the same fields it's working fine. I think that is something wrong with FreeTDS drivers. Could also be that you're specifying the database name incorrectly. Are you able to see the tables when using the 'isql' command line tool? Did you remember to turn on pooling? TDS databases only support a single query per connection, thus connections may not be shared. Let's see your res_odbc.conf. Also, what version of Asterisk are you using? -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org -- _ -- 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 -- _ -- 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
Re: [asterisk-users] Voicemail ODBC
If I use MySQL with the same fields it's working fine. I think that is something wrong with FreeTDS drivers. On Sun, Jun 20, 2010 at 7:13 PM, Tilghman Lesher tles...@digium.com wrote: On Saturday 19 June 2010 08:35:47 Zeeshan Zakaria wrote: On 2010-06-19 9:10 AM, Andraž atle...@gmail.com wrote: 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,mailb oxuser,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] Seems to me that the SQL statement is not complete and asterisk is complaining about it. Do you prepare this statement in your dialplan or asterisk makes it automatically? What, specifically, do you think is not complete about this prepare statement? The only error that I can guess at is that the table pbx_VoiceMail does not have all of the columns listed in the statement. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org -- _ -- 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 -- _ -- 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
[asterisk-users] Voicemail ODBC
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 WHERE dir = '/var/spool/asterisk/voicemail/default/390/INBOX'] [Jun 18 14:00:37] WARNING[19914] res_odbc.c: SQL Prepare failed. Attempting a reconnect... [Jun 18 14:00:37] WARNING[19914] res_odbc.c: Unable to deallocate database handle? 0 errno=0 [unixODBC][Driver Manager]Function sequence error I have configured in voicemail.conf [general] format=wav49 odbcstorage=sqlserver odbctable=pbx_VoiceMail odbc.ini [kupalaodbc] Description = ODBC connection Driver = ms-sql Servername = ms-sql UID = TestDatabaseDemo database= TestDatabaseDemo Port= 1364 odbcinst.ini [ms-sql] Description = TDS connection Driver = /usr/lib/odbc/libtdsodbc.so Setup = /usr/lib/odbc/libtdsS.so UsageCount = 1 FileUsage = 1 freetds.conf [ms-sql] host = 192.168.1.10 port = 1364 tds version = 8.0 dump file = /var/log/freetds.log I reloaded module and restarted asterisk also, but with no success. What can be wrong? Regards Andraž -- _ -- 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
[asterisk-users] Asterisk ODBC
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 sqlserver [kupalaodbc] -- _ -- 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
[asterisk-users] Voicemail ODBC
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 sqlserver [kupalaodbc] -- _ -- 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
Re: [asterisk-users] Voicemail ODBC
Asterisk make it. It is in app_voicemail, I'm using voicemail ODBC. On Sat, Jun 19, 2010 at 3:35 PM, Zeeshan Zakaria zisha...@gmail.com wrote: Seems to me that the SQL statement is not complete and asterisk is complaining about it. Do you prepare this statement in your dialplan or asterisk makes it automatically? Zeeshan A Zakaria -- www.ilovetovoip.com On 2010-06-19 9:10 AM, Andraž atle...@gmail.com wrote: 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 sqlserver [kupalaodbc] -- _ -- 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 -- _ -- 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 -- _ -- 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