similar to: OT: Best DB

I was just going through my call records ( stored in mysql database by cdr_MYSQL module ) and saw a record having duration = 0 and billsec of more than 50 seconds . I did a query on cdr where duration < billsec and saw that there were infact some 250 records with duration less than billsecond ( table had around 4,00,000 records) . Did anyone came across this ? I also checked csv files and they

When I try and start asterisk I get the following, however I have commented out the data the connections in res_mysql.conf and res_pgsql.conf. I am not sure therefore why I am getting these errors. Do I have to change something else to turn this off? Thanks Asterisk 1.4.21.2~dfsg-3, Copyright (C) 1999 - 2008 Digium, Inc. and others. Created by Mark Spencer <markster at digium.com> Asterisk

Hi, Anyone got any cool tricks for converting a Rails site (in this case, a typo installation) from a mysql database to a postgresql database? I''ve got it almost working -- I''m doing a SQL dump from mysql and loading it into postgres. However, mysql does booleans as a tinyint with 0 = false and 1 = true. When I try to import that into a postgres database that expects booleans

May be slightly off topic, but I was wondering what everyone thinks of this latest ruling against Vonage? Does anyone really know what Verizon hold patents for, and could those patents possible affect anything in Asterisk? Who knows who Verizon will go after next. Brent -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi all,as good? It would like to know if already they had had success, in the integration of the functions of asterisk, with one pabx legacy (Avaya)for that pabx avaya, could use the voicemail of asterisk. For sample, user of pabx avaya, it would have its calls directed for not attendance and busy, for asterisk and asterisk, it would send the same one for the voicemail. Best Regards Josu?

Hello Everybody, I am trying to configure Asterisk to listen into a database which is created in PostgreSQL. Whenever asterisk starts up, it is unable to connect to the pg database and gives the following error: [cdr_pgsql.so] => (PostgreSQL CDR Backend) == Parsing '/etc/asterisk/cdr_pgsql.conf': Found Jun 24 21:20:53 DEBUG[1074494336]: cdr_pgsql.c:284 my_load_module: cdr_pgsql:

I''m coming from an Oracle and SQL Server background. I''d like to use OpenSource for my next RoR project. MySQL5.x and Postgres8.1 seem to be the most popular. I''d like some comments on which would be the better choice for a production environment and why. Here are my initial concerns in order of priority: 1. Works well with RoR. ( migrations, etc) 2. Stable enough

Nothing has changed in my Asterisk configuration and now outbound US is getting nothing, but 403's. Anyone else having the same problem? Inbound calls to my DID's are working fine. Thanks, SG -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070325/1f30a3d3/attachment.htm

Hi Guys, we're needing a special implementation on Asterisk Our intention is to contribute the development and share back the code to Asterisk community Here is what we need: - An option to Asterisk Dial command which, if used, when calls is answered gives monodirectional audio (Caller should hear the called party but not vice-versa) - A DTMF sequence (maybe handled in features.conf) for

Is there any reason to avoid using postgresql for small web apps? That is, is it''s overhead so large that the lighter MySQL will work substantially better for small apps on small machines? Or are they very similar in performance and configuration? I''ve used MySQL but postgresql has its appeals and I''m wondering if I need to keep MySQL around at all. On the other

Hi, I am a RoR newbie and I''ve been experimenting with different databases (mySQL, PostgreSQL, etc.) and different table types (MyISAM vs. InnoDB). Is there a preferred database/table type for RoR development. I like how MySQL''s InnoDB tables enforce referential integrity, but these tables require a lot more storage space then MyISAM tables. For everyone with a lot of RoR

Hi I've install Asterisk 1.4.2 and its working fine. In my sip.conf I've allowed ulaw and g729. I want to change the codec for outbond calls. Please help not able to find anything using search. thanks arun -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070501/af78de7a/attachment.htm

Hi; I've been playing around with various report writers on the cdr_mysql table and I'm getting rather irritated. I started a thread a couple weeks ago on "Billing Fun" and got a lot of good responses on how to get an up-to-date copy of the NDA/NXX database, which I managed to retrieve and bring into MySQL in a script from the various pieces of code people posted... very nice.

Hi, I have some annoying telemarketer calling me on a recurring basis, but I'd like to discourage them a bit and have some fun. I found this: http://www.voip-info.org/wiki/view/Asterisk+AEL+Telemarketer+Torture but the link to download the sound files is dead (wyoming.e-tools.com is NXDOMAIN). Anyone have a copy of these? -Adam

I would like some Asterisk community input: It was requested of me to create an Asterisk FreeTDS (cdr_tds.c) module to allow Asterisk to populate MS SQL Server (and Sybase) with CDR records. unixODBC has been thrown around as a bright shiny button but it adds an additional layer of DB abstraction. That additional layer of abstraction can cause problems when it is not necessary for our TDS (MS

Here's a flipside of this subject: what is the absolute cheapest Linux device that can be connected to a PC's USB port? That has just enough power for a minimal Asterisk server running on it. The Asterisk just maintains a CDR database on its Flash memory, which it periodically submits over the PC's network connection with an HTTP hit on a remote full-service Asterisk server? No call

Hi @ all Does anyone has some experience with PostgreSQL and RoR? Does it gives any disadvantages or problems with PostgreSQL? I have a webapplication, that manage (read/write) many records (no. 200''000 records) and I search a ideal database. Actually, I have two options: - MySQL / - PostgreSQL And now, I would like to ascertain a good solution... Thx, ribit -- Posted via

I am running CentOS 5 with Asterisk 1.4.14. I am trying to setup storage of voicemail messages into MySQL. It is my understanding that I can only do this via ODBC. I installed per http://www.voip-info.org/wiki/view/CentOS+5+and+Asterisk+1.4.x+installation unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel and mysql-connector-odbc. I reconfigured and built Asterisk, using menuconfig to

Hi, I have been using myisam tables in mysql with rails because my client will soon want fulltext searchable content, however when I migrated my development db from schema.rb all of the tables generated were innodb. I understand that I can override this, but also like the transactions and foreign keys of innodb. So 2 questions really: 1. are transactions in activerecord dependent on innodb or do

Hi to all!! Here's my problem: [cdr_pgsql.so] => (PostgreSQL CDR Backend) == Parsing '/etc/asterisk/cdr_pgsql.conf': Found May 26 17:21:35 ERROR[16384]: cdr_pgsql.c:298 my_load_module: cdr_pgsql: Unable to connect to database server localhost. Calls will not be logged! May 26 17:21:35 ERROR[16384]: cdr_pgsql.c:299 my_load_module: cdr_pgsql: Reason: could not connect to server: