[VoIP] CentOS MySQL

[Shane Young]

Can you SSH into your box and run the commands below?


Quoting Lee Spenadel <lee at spenadel.com>:

> I do have MySQL installed.  I tried to import the files via the Webmin
> interface and that's where I failed.  I also fired up Samba so I mount the
> Linux box in Windows.  I unzipped the zip code files on my Windows PC and
> transferred them on to the Linux PC, but that's where my efforts ended after
> my inability to get it in to MySQL.  Currently the zip code files reside in
> /home/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 8:30 AM
> To: voip at ckts.info
> Subject: Re: [VoIP] CentOS MySQL
>
> Well, let's start from the top.  Do you have mysql installed on your system?
>
> If not, you'll need to get that installed.
>
> You can type "which mysql" to see if mysql is installed.
>
> shane at bridge01:~$ which mysql
> /usr/bin/mysql
>
> Assuming it is, you need to get the files onto your system and unzipped.
>
>
> shane at bridge01:~$ wget http://nerdvittles.com/trixbox123/zipcodes.zip
> --07:27:01--  http://nerdvittles.com/trixbox123/zipcodes.zip
>             => `zipcodes.zip'
> Resolving nerdvittles.com... 70.103.189.89 Connecting to
> nerdvittles.com[70.103.189.89]:80... connected.
> HTTP request sent, awaiting response... 200 OK
> Length: 877,924 [application/zip]
>
> 100%[=======================================================================
> ============================================================================
> ======>] 877,924
> 669.83K/s
>
> 07:27:03 (667.76 KB/s) - `zipcodes.zip' saved [877924/877924]
>
> shane at bridge01:~$ unzip zipcodes.zip
> Archive:  zipcodes.zip
>    inflating: zipcodes1.sql
>    inflating: zipcodes2.sql
> shane at bridge01:~$ mysql -u root -p < zipcodes1.sql Enter password:
> shane at bridge01:~$ mysql -u root -p < zipcodes2.sql Enter password:
> shane at bridge01:~$
>
> Try that and let me know how far you get.
>
>
>
> Quoting Lee Spenadel <lee at spenadel.com>:
>
>> 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/
>>
>>
>>
>> _______________________________________________
>> VoIP mailing list
>> VoIP at ckts.info
>> http://lists.ckts.info/mailman/listinfo/voip
>> Project Web Page: http://www.ckts.info/
>>
>>
>
>
>
>
>
> _______________________________________________
> VoIP mailing list
> VoIP at ckts.info
> http://lists.ckts.info/mailman/listinfo/voip
> Project Web Page: http://www.ckts.info/
>
>
>
> _______________________________________________
> VoIP mailing list
> VoIP at ckts.info
> http://lists.ckts.info/mailman/listinfo/voip
> Project Web Page: http://www.ckts.info/
>
>