asterisk users - Jan 2008 - Accessing a MySQL database and using the same db for cdr

Hi guys,

Does someone use a mysql database for accessing data and in the same 
time for storing cdr ? if that is the case, which module is used ?

thanks

-- 
Cyril SCETBON

Ciao Cyril,
> Does someone use a mysql database for accessing data and in the same 
> time for storing cdr ? if that is the case, which module is used ?
> 
> thanks
Which kind of "data" are you talking about?

I suppose that you mean that you want to store non-Asterisk related data and
CDR data in the same database.

In this case, to handle CDR data you should use the cdr_mysql module, from
asterisk-addons (http://www.voip-info.org/wiki-Asterisk+cdr+mysql), storing CDR
data in a table of your choice.

Then you should use the DB for your data exactly as you would do if Asterisk
weren't storing his data.

HTH,

-- 
Dr. Andrea Spadaccini
Multimedia Technologies Institute - MTI S.r.l.
Web: www.x-voice.it - Tel: +39 (0) 95 7224945

On 1/18/08, Cyril SCETBON <cyril.scetbon at free.fr>
wrote:
> Hi guys,
>
> Does someone use a mysql database for accessing data and in the same
> time for storing cdr ? if that is the case, which module is used ?
There are two different modules for this. But it's all in
asterisk-addons. For queries you would need app_addon_sql_mysql and
for CDR - cdr_addon_mysql. However app_addon_sql_mysql would require
you to connect/disconnect and keep track of ID's. there's also
res_odbc that connects automatically, but that needs ODBC installed,
and i don't like extra layers :) I'm waiting for something that would
have the same interface that res_odbc but would use MySQL directly.

Btw, in trunk there's improvements for Realtime engine, so you can do
UPDATE's and DELETE's trough func_realtime. If you're interested - i
can send you backported patch for 1.4

Regards,
Atis
>
> thanks
>
> --
> Cyril SCETBON
>
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>

-- 
Atis Lezdins
VoIP Developer,
IQ Labs Inc.
atis at iq-labs.net
Skype: atis.lezdins
Cell Phone: +371 28806004
Work phone: +1 800 7502835

On Fri, Jan 18, 2008 at 03:33:07PM +0100, Cyril SCETBON
wrote:
> Hi guys,
> 
> Does someone use a mysql database for accessing data and in the same 
> time for storing cdr ? if that is the case, which module is used ?
> 
> thanks
> 
On a lightly used system with asterisk, I use ODBC to connect to MySQL
for CDR and SIP/IAX/voicemail etc realtime storage.

Other light application usage of the MySQL is also possible.

-- 
Ron Wellsted
ron at wellsted.org.uk http://www.wellsted.org.uk
N 52.567623, W 2.136111 Linux Counter No. 202120
Ekiga: 645022
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 483 bytes
Desc: Digital signature
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080118/d5f7c53a/attachment.pgp