[Asterisk-Users] MYSQL asterisk configuration

[Terry Goodwin]

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 at 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 at 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 at lists.digium.com 
[mailto:asterisk-users-admin at lists.digium.com] On Behalf Of Terry
Goodwin
Sent: Friday, June 04, 2004 11:06 AM
To: asterisk-users at 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 at 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 at 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 at 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