I have done "yum install asterisk18 freepbx" and it has installed Asterisk
and FreePBX just fine. However, none of the CDR get recorded in
asteriskcdrdb table in MySQL. They are available
in /var/log/asterisk/cdr-csv/Master.csv. What configuration file sets the
setting for writing these CDRs to MySQL? Thanks
We are currently looking for a PHP/MySQL senior developer in the Dominican Republic. We are offering a full contract with excellent salary. Requirements:
- OOP PHP
- MySQL knowledge (you don't have to be a ninja but you must have a good level)
- Must be efficient and proactive, oriented to results.
- Must live in Dominican Republic (Santo Domingo)
- HTML/CSS knowledge
- Linux CLI knowledge (this is a great plus)
The MariaDB project has announced the availability of MariaDB 5.3.3-rc, the first Release Candidate release in the 5.3 series. Several optimization features introduced in MariaDB 5.3 have been thoroughly tested, and switched on by default in 5.3.3.
Performance changes that has been worked:
- Subquery materialization (materialization=on)
- Semi-join optimizations (semijoin=on,firstmatch=on,loosescan=on)
- Derived table optimization (derived_merge=on,derived_with_keys=on -Documentation is being worked on-),
- Index Condition Pushdown (index_condition_pushdown=on)
- Nested loop join will use its Block-based variant more aggressively
- Block-based join for OUTER JOINs (outer_join_with_cache=on)
- Block-based join for semi-joins (semijoin_with_cache=on)
- Linked join…
Hi all I'm trying to configure my Asterisk setup to load the musiconhold.conf file from an ODBC connection to MySQL, working through the example given in the excellent book "Asterisk: The Definite Guide". I'm using Asterisk 1.4.19 and MySQL 5.1.58. I've configured the ODBC bit and in my GeneralLog on MySQL I can see the asterisk user connecting and sending a few SQL statements, such as "SET SQL_AUTO_IS_NULL = 0". After connecting, the asterisk user never sends another SQL statement, at least nothing that shows up in the General log. Asterisk is running as root. I've deleted the musiconhold.conf file…
This email is longer than usual, but that is because we are announcing today the availability of both MariaDB 5.2.10 and 5.1.60, the latest additions to our growing lineup of supported software. MariaDB 5.2.10 and 5.1.60 are primarily bug-fix updates to the previous 5.2.9 and 5.1.55 releases, respectively. == About MariaDB 5.2 MariaDB 5.2 contains features that didn't have time to go into MariaDB 5.1. For all practical purposes it's a drop in replacement for MariaDB 5.1 (and thus MySQL 5.1). The new features in 5.2 are quite isolated and as most have been in use by members in the…
Dear Asterisk users,
I use Asterisk for a long time with RealTime support. Until few days everything went alright. SIP registrations and call handling is still good,. but I saw a disturbing thing today when I was checking my RT database which is a MySQL database. I connect to MySQL with Asterisk 1.8 mysql module (so not with the ODBC driver).
I saw a row where one of my extension's details are weren't complete. For example: the fullcontact filed was filled but the ipaddr filed filled with "(null)" value. All the other extensions are filled total,…
From Slashdot: "Ars Technica analyzes the recent commercial additions by Oracle to MySQL Enterprise and the additional unrest it's added to the community. Oracle may be throwing itself out of the community as it pushes more customers to look at fully open-source alternatives."
The MariaDB project would like to announce the immediate availability of MariaDB 5.2.9, the latest iteration of the 5.2 series. The release notes are available from: * http://kb.askmonty.org/en/mariadb-529-release-notes A complete changelog is available from: * http://kb.askmonty.org/en/mariadb-529-changelog Sources, binaries and packages can be downloaded from: * http://downloads.askmonty.org/mariadb/5.2.9/ Debian and Ubuntu packages are available from repositories. A sources.list generator can be found at: * http://downloads.askmonty.org/mariadb/repositories/ MariaDB code hosting is on Launchpad: * https://launchpad.net/maria The project always strives for quality, but in reality nothing is perfect. Please take time to report any issues you encounter. * https://bugs.launchpad.net/maria…
The MariaDB project would like to announce the availability of MariaDB 5.3.1-beta, the latest addition to our growing lineup of supported software. MariaDB 5.3.1-beta is a bug-fix update to the previous 5.3.0-beta. The MariaDB 5.3 series introduces many new features, includes MariaDB 5.2, and is based on MySQL 5.1. Some highlights of new features in MariaDB 5.3 include: - subquery optimizations that finally make subqueries usable - many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown - NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic…