Re: [asterisk-users] asterisk realtime database structure
On 8/4/12 10:38 AM, virendra bhati wrote: best link for asterisk realtime is below one http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example On Fri, Aug 3, 2012 at 1:51 PM, Leandro Dardini ldard...@gmail.com mailto:ldard...@gmail.com wrote: If you check the contrib/realtime/mysql directory in the source tree, you'll find scripts for almost all the tables. Thank you all for the hints! Cheers, Daniel -- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - http://asipto.com/u/katu Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - http://asipto.com/u/kpw -- _ -- 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
Re: [asterisk-users] asterisk realtime database structure
best link for asterisk realtime is below one http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example On Fri, Aug 3, 2012 at 1:51 PM, Leandro Dardini ldard...@gmail.com wrote: If you check the contrib/realtime/mysql directory in the source tree, you'll find scripts for almost all the tables. Leandro 2012/8/3 Daniel-Constantin Mierla mico...@gmail.com Hello, I was wondering if there is a tool that can create the realtime database structure for latest Asterisk version or a web resource/file containing the sql scripts. Hope I haven't missed obvious things, I had no luck searching on the web, in the wiki I found few pages with bits of sql or table structures, like: https://wiki.asterisk.org/**wiki/display/AST/SIP+Realtime,** +MySQL+table+structurehttps://wiki.asterisk.org/wiki/display/AST/SIP+Realtime,+MySQL+table+structure https://wiki.asterisk.org/**wiki/display/AST/ODBC+**Voicemail+Storagehttps://wiki.asterisk.org/wiki/display/AST/ODBC+Voicemail+Storage I have several table structures from the Asterisk 1.6, I dug for them in the code or found on the web when I wrote the tutorial about integration with Kamailio 3.1 (http://kb.asipto.com/**asterisk:realtime:kamailio-3.* *1.x-asterisk-1.6.2-astdbhttp://kb.asipto.com/asterisk:realtime:kamailio-3.1.x-asterisk-1.6.2-astdb), but hopefully now it is an easy way to get the db structure. Thanks, Daniel -- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/**micondahttp://www.linkedin.com/in/miconda Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - http://asipto.com/u/katu Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - http://asipto.com/u/kpw -- __**__** _ -- 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-**usershttp://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 -- Thanks and regards Virendra Bhati +91-9718300881 Asterisk Developer E-mail-: virbh...@gmail.com Skype id:- virbhati2 New Delhi(India) -- _ -- 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
[asterisk-users] asterisk realtime database structure
Hello, I was wondering if there is a tool that can create the realtime database structure for latest Asterisk version or a web resource/file containing the sql scripts. Hope I haven't missed obvious things, I had no luck searching on the web, in the wiki I found few pages with bits of sql or table structures, like: https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime,+MySQL+table+structure https://wiki.asterisk.org/wiki/display/AST/ODBC+Voicemail+Storage I have several table structures from the Asterisk 1.6, I dug for them in the code or found on the web when I wrote the tutorial about integration with Kamailio 3.1 (http://kb.asipto.com/asterisk:realtime:kamailio-3.1.x-asterisk-1.6.2-astdb), but hopefully now it is an easy way to get the db structure. Thanks, Daniel -- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - http://asipto.com/u/katu Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - http://asipto.com/u/kpw -- _ -- 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
Re: [asterisk-users] asterisk realtime database structure
If you check the contrib/realtime direco 2012/8/3 Daniel-Constantin Mierla mico...@gmail.com Hello, I was wondering if there is a tool that can create the realtime database structure for latest Asterisk version or a web resource/file containing the sql scripts. Hope I haven't missed obvious things, I had no luck searching on the web, in the wiki I found few pages with bits of sql or table structures, like: https://wiki.asterisk.org/**wiki/display/AST/SIP+Realtime,** +MySQL+table+structurehttps://wiki.asterisk.org/wiki/display/AST/SIP+Realtime,+MySQL+table+structure https://wiki.asterisk.org/**wiki/display/AST/ODBC+**Voicemail+Storagehttps://wiki.asterisk.org/wiki/display/AST/ODBC+Voicemail+Storage I have several table structures from the Asterisk 1.6, I dug for them in the code or found on the web when I wrote the tutorial about integration with Kamailio 3.1 (http://kb.asipto.com/**asterisk:realtime:kamailio-3.** 1.x-asterisk-1.6.2-astdbhttp://kb.asipto.com/asterisk:realtime:kamailio-3.1.x-asterisk-1.6.2-astdb), but hopefully now it is an easy way to get the db structure. Thanks, Daniel -- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/**micondahttp://www.linkedin.com/in/miconda Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - http://asipto.com/u/katu Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - http://asipto.com/u/kpw -- __**__**_ -- 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-**usershttp://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
Re: [asterisk-users] asterisk realtime database structure
If you check the contrib/realtime/mysql directory in the source tree, you'll find scripts for almost all the tables. Leandro 2012/8/3 Daniel-Constantin Mierla mico...@gmail.com Hello, I was wondering if there is a tool that can create the realtime database structure for latest Asterisk version or a web resource/file containing the sql scripts. Hope I haven't missed obvious things, I had no luck searching on the web, in the wiki I found few pages with bits of sql or table structures, like: https://wiki.asterisk.org/**wiki/display/AST/SIP+Realtime,** +MySQL+table+structurehttps://wiki.asterisk.org/wiki/display/AST/SIP+Realtime,+MySQL+table+structure https://wiki.asterisk.org/**wiki/display/AST/ODBC+**Voicemail+Storagehttps://wiki.asterisk.org/wiki/display/AST/ODBC+Voicemail+Storage I have several table structures from the Asterisk 1.6, I dug for them in the code or found on the web when I wrote the tutorial about integration with Kamailio 3.1 (http://kb.asipto.com/**asterisk:realtime:kamailio-3.** 1.x-asterisk-1.6.2-astdbhttp://kb.asipto.com/asterisk:realtime:kamailio-3.1.x-asterisk-1.6.2-astdb), but hopefully now it is an easy way to get the db structure. Thanks, Daniel -- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/**micondahttp://www.linkedin.com/in/miconda Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - http://asipto.com/u/katu Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - http://asipto.com/u/kpw -- __**__**_ -- 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-**usershttp://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