Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] Accessing a MySQL database and using the sa


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
cyril.scetbon at free.fr
Guest
PostPosted: Fri Jan 18, 2008 9:33 am    Post subject: [asterisk-users] Accessing a MySQL database and using the sa Reply with quote
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
Back to top
a.spadaccini at mediat...
Guest
PostPosted: Fri Jan 18, 2008 10:02 am    Post subject: [asterisk-users] Accessing a MySQL database and using the sa Reply with quote
Ciao Cyril,

Quote:
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
Back to top
atis at iq-labs.net
Guest
PostPosted: Fri Jan 18, 2008 10:02 am    Post subject: [asterisk-users] Accessing a MySQL database and using the sa Reply with quote
On 1/18/08, Cyril SCETBON <cyril.scetbon at free.fr> wrote:
Quote:
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 Smile 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

Quote:

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
Back to top
cyril.scetbon at free.fr
Guest
PostPosted: Mon Jan 21, 2008 1:17 pm    Post subject: [asterisk-users] Accessing a MySQL database and using the sa Reply with quote
Andrea Spadaccini wrote:
Quote:
Ciao Cyril,

Quote:
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.
yes
Quote:

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.
I want to make special request and not just set or get
Quote:

HTH,


--
Cyril SCETBON
Back to top
cyril.scetbon at free.fr
Guest
PostPosted: Mon Jan 21, 2008 1:23 pm    Post subject: [asterisk-users] Accessing a MySQL database and using the sa Reply with quote
Atis Lezdins wrote:
Quote:
On 1/18/08, Cyril SCETBON <cyril.scetbon at free.fr> wrote:
Quote:
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 Smile I'm waiting for something that would
have the same interface that res_odbc but would use MySQL directly.

Quote:

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
Thanks, but I don't want to have too much work. I just want to know what
is needed and to chose the best and fastest solution.

Quote:

Regards,
Atis

Quote:
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




--
Cyril SCETBON
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services