[VoIP] CentOS MySQL

Lee Spenadel lee at spenadel.com
Tue Jan 23 07:05:30 CST 2007


Thanks for the reply Shane.  I'm trying to get a weather by zip code
application up on Asterisk as a dial extension.  I found the instructions at
http://nerdvittles.com/index.php?p=160

However, the instructions reference certain programming interfaces that
would be installed on a TriBox PBX.  So the problem that I'm having is
getting the zip code data in to a MySQL database.  I still have no clue how
I'll get the AGI script working, if it will even work in my PBX, but right
now the script can't even read the zip code data because I couldn't import
it properly.  The TriBox PBX has this nice import feature in to MySQL that
our version of Asterisk doesn't.  Not being a programming guru, especially
in C, Pearl, etc, I was lost.

I've attached the zip code archive.  There are two files that I need to get
in to MySQL, unfortunately I do not know the format of the file; csv, how
many fields, etc. 

Let me know what, if anything, you can do.

Thanks
Lee

-----Original Message-----
From: voip-bounces at ckts.info [mailto:voip-bounces at ckts.info] On Behalf Of
Shane Young
Sent: Tuesday, January 23, 2007 6:33 AM
To: voip at ckts.info
Subject: Re: [VoIP] CentOS MySQL

I can help.  Tell me more...


Quoting Lee Spenadel <lee at spenadel.com>:

> Does anyone have experience with MySQL?  I'm trying to launch a 
> weather application on my Asterisk box and am having trouble importing 
> the zip code files in to a MySQL database.  Offers of help are welcome.
>



_______________________________________________
VoIP mailing list
VoIP at ckts.info
http://lists.ckts.info/mailman/listinfo/voip
Project Web Page: http://www.ckts.info/





More information about the VoIP mailing list