will Mysql die ?

http://monty-says.blogspot.com/2009/12/help-saving-mysql.html

lovely error message from CPAN

Undefined subroutine &Compress::Zlib::gzopen called at /opt/local/lib/perl5/5.8.8/CPAN.pm line 5721

no solution, yet!

my best wild guess is that port/CPAN has broken the installation of CPAN/port.

Should I use cpan or port ?
May I use both ?
Since I'm not binded to any version in particular I could probably u

se both...

CPAN not working

uh, CPAN stopped working on my MacBook yesterday...
no apparent reason for that, only an error like:

Can't locate Mac/Files.pm in @INC (...)

after checking libraries and the file /Library/Perl/5.8.8/AppendToPath
I've decided to make a fresh installation of Mac::Files...

I've downloaded from:
http://search.cpan.org/~cnandor/Mac-Carbon-0.77/Files/Files.pm

and made a forced installation...

CPAN is back at work, now!

ImageMagick

I think ImageMagick is the right weapon for most image manipulation scripts...

I generally use mac ports to install / update it, I've found a small bug about
a mismatching checksum.

A port selfupdate solved all (since some good guy solved the checksum bug ahead)

reset mysql password

just a short memo, as usual:

stop mysql

restart in safe mode:

mysqld_safe --skip-grant-tables &

enter as root, now:

mysql -u root

and reset table password:

use mysql
update user set password=PASSWORD('newpassword') where user='root';

Web Scraping

AKA convert a standard web page to RSS feed...

still to check:

http://www.feedyes.com

http://www.feed43.com

http://www.feedfire.com

installing PHP with GD on OS X

I was quite disappointed when realized that the apache+php coming with OS X was without the GD libs compiled in...

A complete recompile of both programs is needed, but this guy decided to help:
http://www.entropy.ch/software/macosx/php/
from here you can dowload an updated version of php precompiled, with some libraries included... se his pages for more details.

Apache, as usual from http://httpd.apache.org...

I paraphrased MArk's advices for compiling Apache:
CFLAGS="-isysroot /Developer/SDKs/MacOSX10.5.sdk -arch i686" sudo ./configure --prefix=/opt/apache2 --enable-mods-shared=all --enable-proxy-balancer --enable-proxy-ajp --enable-proxy-http --enable-proxy-ftp --enable-proxy-connect --enable-proxy --enable-ssl --enable-so

I've changed the location of the brand new sdk, removed the 386 arch, the ppc arch and added the i686 arch.

sudo make
sudo make install

sudo shouldn't be really necessary 'til the last step, but shouldn't harm much.

Created a conf/other directory for my configurations,
added an Include directive in the main .conf file,
added the php.conf as described in the entropy.conf

Unfortunately a nasty error message appeared on starting up the web server on a missing lib...

I needed to:
696 cd /opt/apache2/
697 sudo mkdir lib
698 cd lib
699 sudo ln -s /opt/local/lib/libexpat.0.dylib .
create the missing dir, creating a symlink to the missing library to resolve this. Dumb working solution.