* You are viewing Posts Tagged ‘MySQL’

CDRs do not record in asteriskcdrdb using Digium repository

Hello,

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

PHP/MySQL developer needed

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)
  • jQuery
  • Must be efficient and proactive, oriented to results.
  • Must live in Dominican Republic (Santo Domingo)

Desirable:

  • HTML/CSS knowledge
  • Linux CLI knowledge (this is a great plus)

 

If you know would like to apply just send me an email (see the ‘About Me‘ section).

 

Note: This is not a Digium job vacancy neither it’s related with them.

New Release: MariaDB, MySQL alternative

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 buffers (more aggressive buffering of multi-way joins) (@@join_cache_level==2)

Also, DISTINCT and GROUP BY clauses are now removed from subqueries when possible. This allows for more efficient query plans. (backported from MySQL 5.6)

About the changes related to usability:

EXPLAIN  output has been improved in MariaDB 5.3.3 to be easier to understand:

  • The select_type column now shows MATERIALIZED for subqueries that are executed with Materialization (it used to show SUBQUERY, which made it hard to distinguish  materialized subqueries from other kinds subqueries).
  • For a Duplicate Elimination strategy, Start temporary is now shown at the first table from the subquery.

For a list of changes, about MariaDB 5.3, please read the following link:

Enjoy MariaDB!

ODBC problem – static realtime file not loading

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 from /etc/asterisk

Testing odbc from command line ( there is a difference from what the book says, I need to use sudo for isql to work, presumably since * is running as root)

$ odbcinst -q -d
[MySQL]
$echo “select 1″ | sudo isql -v asterisk-connector
+—————————————+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+—————————————+
SQL> select 1
+———————+
| 1 |
+———————+
| 1 |
+———————+
SQLRowCount returns 1
1 rows fetched

The extconfig.conf file gets parsed, and looks like this:

[settings]
musiconhold.conf => odbc,asterisk_development,asterisk_files

The modules.conf contains only:

[modules]
preload => res_odbc.so
preload => res_config_odbc.so
autoload=yes

On starting Asterisk with -cv I get the following:
[Dec 16 11:08:38] WARNING[1632]: res_musiconhold.c:1309 load_module: No music on hold classes configured, disabling music on hold.
[Dec 16 11:08:38] res_musiconhold.so => (Music On Hold Resource)

The second line loads the module in spite of the warning in the first line. The following commands give:

*CLI> moh show classes
*CLI> odbc show
Name: asterisk
DSN: asterisk-connector
Pooled: no
Connected: yes
*CLI> module reload res_musiconhold.so
*CLI>moh show classes
*CLI>

I guess the problem could lie with the database itself but I’ve checked and double-checked the column names and defs, and the asterisk user has full access rights to the database.

The SQL insert for the database looks like this:

INSERT INTO `asterisk_files` (`id`, `cat_metric`, `var_metric`, `filename`, `category`, `var_name`, `var_val`, `commented`, `created_at`, `updated_at`) VALUES
(1, 1, 1, ‘musiconhold.conf’, ‘default’, ‘mode’, ‘files’, 0, NULL, NULL),
(2, 1, 2, ‘musiconhold.conf’, ‘default’, ‘directory’, ‘/var/lib/asterisk/moh’, 0, NULL, NULL);

The two last columns (created_at, updated_at) were created by Rails, but I’ve also tried pointing Asterisk to a view without those two columns.

Basically, the ODBC connection works but it seems as if Asterisk never tries to read the definitions from the database. Any help would be greatly appreciated!

Regards

Binni

ITAnet
Kirkestien 20
9230 Svenstrup

Telefon: 3020 0868

Email: binni@itanet.nu
WWW: http://www.itanet.nu

[cid:image001.gif@01CCBBE7.6E001380]

MariaDB 5.2.10 and 5.1.60 Released

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 MySQL community for a long time. Current versions of
MariaDB 5.2 are stable. This is equivalent to a MySQL GA release.

For a list of the various changes in the MariaDB 5.2 series, please see:

* http://kb.askmonty.org/en/what-is-mariadb-52

=== PAM authentication plugin in MariaDB 5.2.10

One change in MariaDB 5.2.10 which we want to make you aware of is the inclusion of a new open source PAM authentication plugin. See http://kb.askmonty.org/en/pam-authentication-plugin for more
information.

=== Windows Binaries delayed

Due to some issues with our Windows build server, the Windows binaries for 5.2.10 have been delayed. They should be released soon.

=== MariaDB 5.2.10 Release Notes, Changelog, Downloads

See the following pages for more information on MariaDB 5.2.10 and to
download it:

* http://kb.askmonty.org/en/mariadb-5210-release-notes
* http://kb.askmonty.org/en/mariadb-5210-changelog
* http://downloads.askmonty.org/mariadb/5.2.10/

== About MariaDB 5.1

MariaDB 5.1 is a binary drop in replacement of MySQL 5.1, but with performance like MySQL 5.5 (thanks to XtraDB), fewer bugs, and more
features. Thanks to the extended and improved mysql_upgrade program it’s also easier to upgrade from MySQL 5.0 to MariaDB 5.1 than to MySQL
5.1.

MariaDB 5.1 is based on MySQL 5.1. In particular, MariaDB 5.1.60 is based on MySQL 5.1.60, with many improvements.

For a list of the various improvements in the MariaDB 5.1 series, please
see:

* http://kb.askmonty.org/en/what-is-mariadb-51

=== MariaDB 5.1.60 Release Notes, Changelog, Downloads

See the following pages for more information on MariaDB 5.1.60 and to
download it:

* http://kb.askmonty.org/en/mariadb-5160-release-notes
* http://kb.askmonty.org/en/mariadb-5160-changelog
* http://downloads.askmonty.org/mariadb/5.1.60/

== Debian & Ubuntu Software Repositories

Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at:
http://downloads.askmonty.org/mariadb/repositories/

== MariaDB Crash Course book

We would also like to mention the book “MariaDB Crash Course”, by Ben Forta. This book — for beginner to intermediate level users — will get you up and running with MariaDB, even if you’ve never used a
database before. More information is available at:
http://forta.com/books/0321799941/

== Reporting issues

The project always strives for quality, and we know that not everything may be perfect. Please take some time to report any issues you may
encounter at: https://bugs.launchpad.net/maria

Enjoy MariaDB 5.2.10 and 5.1.60!

Asterisk 1.8 RealTime problem with ipaddr field

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, in all cases it contains the ipaddr field too. But only at this one where i have fullcontact I dont have the ipaddr field. Thar is a problem for me bacuse without that field I cant even debug the sip messages, because when I insert into the Asterisk CLI: sip set debug peer (I insert the number of that extension where I cant find the ipaddr field. ) , the CLI shows me an error message: Unable to get IP address of peer ‘

 
So its quite confusing. Why it dont fill the ipaddr field?? From which SIP message get and cut out  the IP address?

 
 
 
Thank you

Peter