asterisk users - Oct 2011 - Can we use MySQL native connector for ARA?

Hello Everyone,

The documentation suggests using unixodbc for asterisk realtime. Is
there any way
we can just use native database clients such as libmysqlclient from
MySQL? The native
clients tend to be more up-to-date.

Thanks in Advance,

Nick.

1. odbc has been successful for some posters
2. I would personally use System or AGI to handle my MYSQL stuff so you have
clean "bash-like" handling.

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Nick Khamis
Sent: Wednesday, October 19, 2011 4:35 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: [asterisk-users] Can we use MySQL native connector for ARA?

Hello Everyone,

The documentation suggests using unixodbc for asterisk realtime. Is there
any way we can just use native database clients such as libmysqlclient from
MySQL? The native clients tend to be more up-to-date.

Thanks in Advance,

Nick.

--
_____________________________________________________________________
-- 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

Hello Danny,

Thank you for your response. Actually, what I was referring to is
Asterisk Realtime, and not
our own agi application. Can we use the native database connectors for
ARA. I currently have
everything working with unixodbc + myodbc however, looking to use the
native DB connector
if possible.

Thanks in Advace,

Nick.

On Wed, Oct 19, 2011 at 5:38 PM, Danny Nicholas <danny at debsinc.com>
wrote:
> 1. odbc has been successful for some posters
> 2. I would personally use System or AGI to handle my MYSQL stuff so you
have
> clean "bash-like" handling.
>
> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com
> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Nick
Khamis
> Sent: Wednesday, October 19, 2011 4:35 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: [asterisk-users] Can we use MySQL native connector for ARA?
>
> Hello Everyone,
>
> The documentation suggests using unixodbc for asterisk realtime. Is there
> any way we can just use native database clients such as libmysqlclient from
> MySQL? The native clients tend to be more up-to-date.
>
> Thanks in Advance,
>
> Nick.
>
> --
> _____________________________________________________________________
> -- 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
>

> Hello Everyone,
> 
> The documentation suggests using unixodbc for asterisk realtime. Is
> there any way
> we can just use native database clients such as libmysqlclient from
> MySQL? The native
> clients tend to be more up-to-date.
> 
> Thanks in Advance,
> 
> Nick.
I've used the MySQL addon for years with great success, initiated the
project to support read/write to separate databases for asterisk clustering.
You will get more functionality for complex queries using the odbc
connector, but for basic ARA applications, the MySQL addon works fine and
I've never had a problem with stability.  I also use the cdr_mysql as well.

I wrote a couple of papers on asterisk_clustering_with_mysql_replication.
They are a bit dated but still relevant.  I'll send over if you like.

Good luck.

JR