After I did a clean install of my system I needed to work on some of my project. I couldn’t get the php websites to work with the Snow Leopard. I had to go into the php.ini (php.ini.default) and edit the file.
nano /etc/php.ini or /etc/php.ini.default
Add in the 3306 for the port.
mysql.default_port = 3306 |
I ran into this little problem of compiling mysql gem on a centOS box and thought I would share this.
NOTE: updated January 2010
If you don’t have the mySQL development libraries installed then you might want to install them.
apt-get install libmysqlclient*-dev |
Make sure you have the DEV libraries installed on the linux box and then run this command
gem install mysql --no-rdoc --no-ri -- --with-mysql-config=/usr/bin/mysql_config |
It work for me on CentOS 5.3 just today.
I am working on a project for looking up distances from zipcodes. I found an open source database and some other information for making this happen. I will post more on this when I get it completed.
http://zips.sourceforge.net/
Also take a look at this site.
http://www.populardata.com/ (you can find the canadian DB from there)
Good luck and I will post a bunch of information on this page when I am finished.