Hello all. I am a little (allot) lost on my next hurdle in getting an asterisk system built. I would like to get my asterisk servers configured exclusively from database. I have read through the wiki on this subject but once again I find that there is a certain level of knowledge that is assumed. As of now I know nothing about databases in general and specifically MYSQL. I do not know how to set up the database structure (SQL commands, scripts?) for the required databases. I think I have the add-on stuff done right but there have been a few conflicting documents and comments in the mailing list regarding this. Bottom line... I am rather confused as to where to start, what direction to go in and how the details are done. I am, however, willing to learn. I just need to do this in a compressed time frame as I need a really cool "show peace" to eval so that I can get some $ thrown at it. Future needs will be Netware Edirectory integration at some level, mainly looking to pull name and phone # out of edirectory and present it to a cisco 7940/60 via XML. I would love to be able to link the asterisk database directly (ldap, dirxml, etc) to edirectory at some point so that changes made in edirectory are sent to the appropriate asterisk system. Voicemail networking (the ability to forward voicemails to a user or group of users on remote asterisk systems and possibly an AMIS feature that will allow networking with existing avaya/octel voicemail systems until I can replace them with asterisk). Providing high reliability. I have been looking to have two asterisk servers (primary and secondary) share a PRI but Im still not real clear on how to achieve full redundancy of the server yet. ... and finally, at some point (when I can prove the potential of asterisk) HIRE A FREAKING DEVELOPER so I can do whatever I want with the system without causing myself to have an aneurism by trying to read (much less figure out) source code. Although I was successful in modifying mime-construct to change the (from: ) field of the email. Yeah I know, its Perl script... But I was still pretty proud of myself. If you actually read my entire screed I offer my sincere thanks. If not, well, your not reading this anyway. Respectfully, Terry -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20040604/038e2472/attachment.htm
Oh, forgot to officially ask... Could anyone help me out getting asterisk talking to MYSQL?>>> TGoodwin@packagingcorp.com 6/4/2004 11:36:24 AM >>>Hello all. I am a little (allot) lost on my next hurdle in getting an asterisk system built. I would like to get my asterisk servers configured exclusively from database. I have read through the wiki on this subject but once again I find that there is a certain level of knowledge that is assumed. As of now I know nothing about databases in general and specifically MYSQL. I do not know how to set up the database structure (SQL commands, scripts?) for the required databases. I think I have the add-on stuff done right but there have been a few conflicting documents and comments in the mailing list regarding this. Bottom line... I am rather confused as to where to start, what direction to go in and how the details are done. I am, however, willing to learn. I just need to do this in a compressed time frame as I need a really cool "show peace" to eval so that I can get some $ thrown at it. Future needs will be Netware Edirectory integration at some level, mainly looking to pull name and phone # out of edirectory and present it to a cisco 7940/60 via XML. I would love to be able to link the asterisk database directly (ldap, dirxml, etc) to edirectory at some point so that changes made in edirectory are sent to the appropriate asterisk system. Voicemail networking (the ability to forward voicemails to a user or group of users on remote asterisk systems and possibly an AMIS feature that will allow networking with existing avaya/octel voicemail systems until I can replace them with asterisk). Providing high reliability. I have been looking to have two asterisk servers (primary and secondary) share a PRI but Im still not real clear on how to achieve full redundancy of the server yet. ... and finally, at some point (when I can prove the potential of asterisk) HIRE A FREAKING DEVELOPER so I can do whatever I want with the system without causing myself to have an aneurism by trying to read (much less figure out) source code. Although I was successful in modifying mime-construct to change the (from: ) field of the email. Yeah I know, its Perl script... But I was still pretty proud of myself. If you actually read my entire screed I offer my sincere thanks. If not, well, your not reading this anyway. Respectfully, Terry -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20040604/08132dad/attachment.htm
Here come the flames.....watch out. Terry, I would suggest picking up a book about MySQL at Borders. Not a thick one, but a starter. There are many sites on the Net that can help too.. I would suggest: http://dev.mysql.com/tech-resources/articles/ The first link should get you started. I think reading some of this and refering back to wiki will help put the puzzle together. http://dev.mysql.com/tech-resources/articles/mysql_intro.html Joe -----Original Message----- From: asterisk-users-admin@lists.digium.com [mailto:asterisk-users-admin@lists.digium.com] On Behalf Of Terry Goodwin Sent: Friday, June 04, 2004 12:36 PM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] MYSQL asterisk configuration Hello all. I am a little (allot) lost on my next hurdle in getting an asterisk system built. I would like to get my asterisk servers configured exclusively from database. I have read through the wiki on this subject but once again I find that there is a certain level of knowledge that is assumed. As of now I know nothing about databases in general and specifically MYSQL. I do not know how to set up the database structure (SQL commands, scripts?) for the required databases. I think I have the add-on stuff done right but there have been a few conflicting documents and comments in the mailing list regarding this. Bottom line... I am rather confused as to where to start, what direction to go in and how the details are done. I am, however, willing to learn. I just need to do this in a compressed time frame as I need a really cool "show peace" to eval so that I can get some $ thrown at it. Future needs will be Netware Edirectory integration at some level, mainly looking to pull name and phone # out of edirectory and present it to a cisco 7940/60 via XML. I would love to be able to link the asterisk database directly (ldap, dirxml, etc) to edirectory at some point so that changes made in edirectory are sent to the appropriate asterisk system. Voicemail networking (the ability to forward voicemails to a user or group of users on remote asterisk systems and possibly an AMIS feature that will allow networking with existing avaya/octel voicemail systems until I can replace them with asterisk). Providing high reliability. I have been looking to have two asterisk servers (primary and secondary) share a PRI but Im still not real clear on how to achieve full redundancy of the server yet. ... and finally, at some point (when I can prove the potential of asterisk) HIRE A FREAKING DEVELOPER so I can do whatever I want with the system without causing myself to have an aneurism by trying to read (much less figure out) source code. Although I was successful in modifying mime-construct to change the (from: ) field of the email. Yeah I know, its Perl script... But I was still pretty proud of myself. If you actually read my entire screed I offer my sincere thanks. If not, well, your not reading this anyway. Respectfully, Terry
Thanks for the info, Ill give it a try. Terry>>> asterisk@ati-kos.com 6/4/2004 2:40:16 PM >>>If you dont know to build the database from command line try to get an MySQL client like PHPMyAdmin or MySQL module of web min can do the same job. if you have download add-on`s from the digium CVS server then the job is done.> Hello all. > > I am a little (allot) lost on my next hurdle in getting an asterisk > system built. > > I would like to get my asterisk servers configured exclusively from > database. I have read through the wiki on this subject but onceagain I> find that there is a certain level of knowledge that is assumed. Asof> now I know nothing about databases in general and specifically MYSQL.I> do not know how to set up the database structure (SQL commands, > scripts?) for the required databases. I think I have the add-onstuff> done right but there have been a few conflicting documents andcomments> in the mailing list regarding this. > > Bottom line... > > I am rather confused as to where to start, what direction to go inand> how the details are done. I am, however, willing to learn. I just > need to do this in a compressed time frame as I need a really cool"show> peace" to eval so that I can get some $ thrown at it. > > Future needs will be Netware Edirectory integration at some level, > mainly looking to pull name and phone # out of edirectory and presentit> to a cisco 7940/60 via XML. I would love to be able to link the > asterisk database directly (ldap, dirxml, etc) to edirectory at some > point so that changes made in edirectory are sent to the appropriate > asterisk system. Voicemail networking (the ability to forwardvoicemails> to a user or group of users on remote asterisk systems and possiblyan> AMIS feature that will allow networking with existing avaya/octel > voicemail systems until I can replace them with asterisk).Providing> high reliability. I have been looking to have two asterisk servers > (primary and secondary) share a PRI but Im still not real clear onhow> to achieve full redundancy of the server yet. > > ... and finally, at some point (when I can prove the potential of > asterisk) HIRE A FREAKING DEVELOPER so I can do whatever I want withthe> system without causing myself to have an aneurism by trying to read > (much less figure out) source code. Although I was successful in > modifying mime-construct to change the (from: ) field of the email. > Yeah I know, its Perl script... But I was still pretty proud of > myself. > > If you actually read my entire screed I offer my sincere thanks. If > not, well, your not reading this anyway. > > Respectfully, > Terry >_______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20040604/3b92aa1c/attachment.htm
If you dont know to build the database from command line try to get an MySQL client like PHPMyAdmin or MySQL module of web min can do the same job. if you have download add-on`s from the digium CVS server then the job is done.> Hello all. > > I am a little (allot) lost on my next hurdle in getting an asterisk > system built. > > I would like to get my asterisk servers configured exclusively from > database. I have read through the wiki on this subject but once again I > find that there is a certain level of knowledge that is assumed. As of > now I know nothing about databases in general and specifically MYSQL. I > do not know how to set up the database structure (SQL commands, > scripts?) for the required databases. I think I have the add-on stuff > done right but there have been a few conflicting documents and comments > in the mailing list regarding this. > > Bottom line... > > I am rather confused as to where to start, what direction to go in and > how the details are done. I am, however, willing to learn. I just > need to do this in a compressed time frame as I need a really cool "show > peace" to eval so that I can get some $ thrown at it. > > Future needs will be Netware Edirectory integration at some level, > mainly looking to pull name and phone # out of edirectory and present it > to a cisco 7940/60 via XML. I would love to be able to link the > asterisk database directly (ldap, dirxml, etc) to edirectory at some > point so that changes made in edirectory are sent to the appropriate > asterisk system. Voicemail networking (the ability to forward voicemails > to a user or group of users on remote asterisk systems and possibly an > AMIS feature that will allow networking with existing avaya/octel > voicemail systems until I can replace them with asterisk). Providing > high reliability. I have been looking to have two asterisk servers > (primary and secondary) share a PRI but Im still not real clear on how > to achieve full redundancy of the server yet. > > ... and finally, at some point (when I can prove the potential of > asterisk) HIRE A FREAKING DEVELOPER so I can do whatever I want with the > system without causing myself to have an aneurism by trying to read > (much less figure out) source code. Although I was successful in > modifying mime-construct to change the (from: ) field of the email. > Yeah I know, its Perl script... But I was still pretty proud of > myself. > > If you actually read my entire screed I offer my sincere thanks. If > not, well, your not reading this anyway. > > Respectfully, > Terry >
:-) flamed? I hope not. I have already started reading up on mysql and c and Perl and xml and java and aaaarrrrrgggghhhh... So many things I need to get working so little knowledge of coding and so little time. All I can offer anyone right now is good will and future benefits from anything code we eventually develop. I just need help getting started. Oh well, if someone wants to flame me so be it, Ill get over it and they will too. :-) Terry>>> jfinley@prcontrol.com 6/4/2004 1:42:55 PM >>>Here come the flames.....watch out. Terry, I would suggest picking up a book about MySQL at Borders. Not a thick one, but a starter. There are many sites on the Net that can help too.. I would suggest: http://dev.mysql.com/tech-resources/articles/ The first link should get you started. I think reading some of this and refering back to wiki will help put the puzzle together. http://dev.mysql.com/tech-resources/articles/mysql_intro.html Joe -----Original Message----- From: asterisk-users-admin@lists.digium.com [mailto:asterisk-users-admin@lists.digium.com] On Behalf Of Terry Goodwin Sent: Friday, June 04, 2004 12:36 PM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] MYSQL asterisk configuration Hello all. I am a little (allot) lost on my next hurdle in getting an asterisk system built. I would like to get my asterisk servers configured exclusively from database. I have read through the wiki on this subject but once again I find that there is a certain level of knowledge that is assumed. As of now I know nothing about databases in general and specifically MYSQL. I do not know how to set up the database structure (SQL commands, scripts?) for the required databases. I think I have the add-on stuff done right but there have been a few conflicting documents and comments in the mailing list regarding this. Bottom line... I am rather confused as to where to start, what direction to go in and how the details are done. I am, however, willing to learn. I just need to do this in a compressed time frame as I need a really cool "show peace" to eval so that I can get some $ thrown at it. Future needs will be Netware Edirectory integration at some level, mainly looking to pull name and phone # out of edirectory and present it to a cisco 7940/60 via XML. I would love to be able to link the asterisk database directly (ldap, dirxml, etc) to edirectory at some point so that changes made in edirectory are sent to the appropriate asterisk system. Voicemail networking (the ability to forward voicemails to a user or group of users on remote asterisk systems and possibly an AMIS feature that will allow networking with existing avaya/octel voicemail systems until I can replace them with asterisk). Providing high reliability. I have been looking to have two asterisk servers (primary and secondary) share a PRI but Im still not real clear on how to achieve full redundancy of the server yet. ... and finally, at some point (when I can prove the potential of asterisk) HIRE A FREAKING DEVELOPER so I can do whatever I want with the system without causing myself to have an aneurism by trying to read (much less figure out) source code. Although I was successful in modifying mime-construct to change the (from: ) field of the email. Yeah I know, its Perl script... But I was still pretty proud of myself. If you actually read my entire screed I offer my sincere thanks. If not, well, your not reading this anyway. Respectfully, Terry _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20040604/1b24d36b/attachment.htm
Sorry about the HTML. This should be better. I now have the mysql database created with the appropriate tables, keys. Wasn't to hard :) Im now trying to work out how to populate the database with my users information. Thank you for the info and the advice on HTML messages. Respectfully Terry>>> scott@evtmedia.com 6/4/2004 1:48:05 PM >>>Hi- Have you checked out the "Wiki" on this subject: http://www.voip-info.org/tiki-index.php?page=Asterisk%20cdr%20mysql This should help you get started with MySQL, which works great with asterisk, I've found. You have to install the MySQL package - use the free version 4 at www.mysql.com, and install as follows: Download to a new directory, like, /usr/src/mysql. Install by using rpm -U for each, in this order: * shared-compat * client * devel * server - and follow on screen instructions to create root password Then, you have to struggle a bit with passwords and permissions to get everybody to talk. That's it! Also, please don't post HTML messages in this forum, as many user's mail clients don't handle it, use text instead - thanks. regards Scott M. Stingel President, Emerging Voice Technology, Inc. Palo Alto California & London England www.evtmedia.com <http://www.evtmedia.com/> ________________________________ From: asterisk-users-admin@lists.digium.com [mailto:asterisk-users-admin@lists.digium.com] On Behalf Of Terry Goodwin Sent: Friday, June 04, 2004 11:06 AM To: asterisk-users@lists.digium.com Subject: Re: [Asterisk-Users] MYSQL asterisk configuration Oh, forgot to officially ask... Could anyone help me out getting asterisk talking to MYSQL?>>> TGoodwin@packagingcorp.com 6/4/2004 11:36:24 AM >>>Hello all. I am a little (allot) lost on my next hurdle in getting an asterisk system built. I would like to get my asterisk servers configured exclusively from database. I have read through the wiki on this subject but once again I find that there is a certain level of knowledge that is assumed. As of now I know nothing about databases in general and specifically MYSQL. I do not know how to set up the database structure (SQL commands, scripts?) for the required databases. I think I have the add-on stuff done right but there have been a few conflicting documents and comments in the mailing list regarding this. Bottom line... I am rather confused as to where to start, what direction to go in and how the details are done. I am, however, willing to learn. I just need to do this in a compressed time frame as I need a really cool "show peace" to eval so that I can get some $ thrown at it. Future needs will be Netware Edirectory integration at some level, mainly looking to pull name and phone # out of edirectory and present it to a cisco 7940/60 via XML. I would love to be able to link the asterisk database directly (ldap, dirxml, etc) to edirectory at some point so that changes made in edirectory are sent to the appropriate asterisk system. Voicemail networking (the ability to forward voicemails to a user or group of users on remote asterisk systems and possibly an AMIS feature that will allow networking with existing avaya/octel voicemail systems until I can replace them with asterisk). Providing high reliability. I have been looking to have two asterisk servers (primary and secondary) share a PRI but Im still not real clear on how to achieve full redundancy of the server yet. ... and finally, at some point (when I can prove the potential of asterisk) HIRE A FREAKING DEVELOPER so I can do whatever I want with the system without causing myself to have an aneurism by trying to read (much less figure out) source code. Although I was successful in modifying mime-construct to change the (from: ) field of the email. Yeah I know, its Perl script... But I was still pretty proud of myself. If you actually read my entire screed I offer my sincere thanks. If not, well, your not reading this anyway. Respectfully, Terry _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
f lamed? I hope not. I have already started reading up on mysql and c and Perl and xml and java and aaaarrrrrgggghhhh... So many things I need to get working so little knowledge of coding and so little time. All I can offer anyone right now is good will and future benefits from anything code we eventually develop. I just need help getting started. Oh well, if someone wants to flame me so be it, Ill get over it and they will too. :-) --------------------------------- Terry, not sure if this will help you, since i am not using it but here it is anyway: http://www.codecharge.com/index2.php PSS... and as Scott mentioned... can you send your messages in plain text NOT html ......... -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20040604/88954645/attachment.htm
Thanks for the input all. Its working now. Very cool stuff, just wish asterisk took more advantage of the database. In time I guess. Regards Terry>>> TGoodwin@packagingcorp.com 6/4/2004 3:04:18 PM >>>Sorry about the HTML. This should be better. I now have the mysql database created with the appropriate tables, keys. Wasn't to hard :) Im now trying to work out how to populate the database with my users information. Thank you for the info and the advice on HTML messages. Respectfully Terry>>> scott@evtmedia.com 6/4/2004 1:48:05 PM >>>Hi- Have you checked out the "Wiki" on this subject: http://www.voip-info.org/tiki-index.php?page=Asterisk%20cdr%20mysql This should help you get started with MySQL, which works great with asterisk, I've found. You have to install the MySQL package - use the free version 4 at www.mysql.com, and install as follows: Download to a new directory, like, /usr/src/mysql. Install by using rpm -U for each, in this order: * shared-compat * client * devel * server - and follow on screen instructions to create root password Then, you have to struggle a bit with passwords and permissions to get everybody to talk. That's it! Also, please don't post HTML messages in this forum, as many user's mail clients don't handle it, use text instead - thanks. regards Scott M. Stingel President, Emerging Voice Technology, Inc. Palo Alto California & London England www.evtmedia.com <http://www.evtmedia.com/> ________________________________ From: asterisk-users-admin@lists.digium.com [mailto:asterisk-users-admin@lists.digium.com] On Behalf Of Terry Goodwin Sent: Friday, June 04, 2004 11:06 AM To: asterisk-users@lists.digium.com Subject: Re: [Asterisk-Users] MYSQL asterisk configuration Oh, forgot to officially ask... Could anyone help me out getting asterisk talking to MYSQL?>>> TGoodwin@packagingcorp.com 6/4/2004 11:36:24 AM >>>Hello all. I am a little (allot) lost on my next hurdle in getting an asterisk system built. I would like to get my asterisk servers configured exclusively from database. I have read through the wiki on this subject but once again I find that there is a certain level of knowledge that is assumed. As of now I know nothing about databases in general and specifically MYSQL. I do not know how to set up the database structure (SQL commands, scripts?) for the required databases. I think I have the add-on stuff done right but there have been a few conflicting documents and comments in the mailing list regarding this. Bottom line... I am rather confused as to where to start, what direction to go in and how the details are done. I am, however, willing to learn. I just need to do this in a compressed time frame as I need a really cool "show peace" to eval so that I can get some $ thrown at it. Future needs will be Netware Edirectory integration at some level, mainly looking to pull name and phone # out of edirectory and present it to a cisco 7940/60 via XML. I would love to be able to link the asterisk database directly (ldap, dirxml, etc) to edirectory at some point so that changes made in edirectory are sent to the appropriate asterisk system. Voicemail networking (the ability to forward voicemails to a user or group of users on remote asterisk systems and possibly an AMIS feature that will allow networking with existing avaya/octel voicemail systems until I can replace them with asterisk). Providing high reliability. I have been looking to have two asterisk servers (primary and secondary) share a PRI but Im still not real clear on how to achieve full redundancy of the server yet. ... and finally, at some point (when I can prove the potential of asterisk) HIRE A FREAKING DEVELOPER so I can do whatever I want with the system without causing myself to have an aneurism by trying to read (much less figure out) source code. Although I was successful in modifying mime-construct to change the (from: ) field of the email. Yeah I know, its Perl script... But I was still pretty proud of myself. If you actually read my entire screed I offer my sincere thanks. If not, well, your not reading this anyway. Respectfully, Terry _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Hello We are just working on a billing sysem and config from mysql. so we`ll release it soon and it`ll be distributed under GPL. It`ll take some time (about one more month) so be patient untill then ;) Best Regards Hekuran ---------------------------------------------------------------------- Hekuran Doli Yjet e erenikut 14/2 Gjakova/Kosova heka@ati-kos.com www.ati-kos.com +37744387555> > > > > f lamed? I hope not. > > I have already started reading up on mysql and c and Perl and xml and > java and aaaarrrrrgggghhhh... So many things I need to get working so > little knowledge of coding and so little time. All I can offer anyone > right now is good will and future benefits from anything code we > eventually develop. I just need help getting started. > > Oh well, if someone wants to flame me so be it, Ill get over it and > they will too. :-) > --------------------------------- > > > > Terry, not sure if this will help you, since i am not using it but here > it is anyway: > http://www.codecharge.com/index2.php > > PSS... and as Scott mentioned... can you send your messages in plain > text NOT html ......... > > > >