Im doing a fresh install on my Mac OS X 10.5.2 (client) machine to use as a test server for building my site on MTOS. I've finished installing all the perl modules (everything in the test script goes fine), have MySQL (latest 5.0 release for 10.5) installed and have modified it's socket path so that DBD::mysql recognizes it and compiles.
When I go through the initial configuration all goes well until I go to test my MySQL connection and I get an "Internal Server Error" which is completely vague. On inspection of the logs I see the following:
[Wed Mar 05 22:46:12 2008] [error] [client ::1] dyld: lazy symbol binding failed: Symbol not found: mysqlserverinit, referer: http://localhost/mtos/mt-wizard.cgi [Wed Mar 05 22:46:12 2008] [error] [client ::1] Referenced from: /Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle, referer: http://localhost/mtos/mt-wizard.cgi [Wed Mar 05 22:46:12 2008] [error] [client ::1] Expected in: dynamic lookup, referer: http://localhost/mtos/mt-wizard.cgi [Wed Mar 05 22:46:12 2008] [error] [client ::1] , referer: http://localhost/mtos/mt-wizard.cgi [Wed Mar 05 22:46:12 2008] [error] [client ::1] dyld: Symbol not found: _mysqlserver_init, referer: http://localhost/mtos/mt-wizard.cgi [Wed Mar 05 22:46:12 2008] [error] [client ::1] Referenced from: /Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle, referer: http://localhost/mtos/mt-wizard.cgi [Wed Mar 05 22:46:12 2008] [error] [client ::1] Expected in: dynamic lookup, referer: http://localhost/mtos/mt-wizard.cgi [Wed Mar 05 22:46:12 2008] [error] [client ::1] , referer: http://localhost/mtos/mt-wizard.cgi [Wed Mar 05 22:46:12 2008] [error] [client ::1] Premature end of script headers: mt-wizard.cgi, referer: http://localhost/mtos/mt-wizard.cgi
I'm assuming this is an issue with the MySQL connection but I've no idea what to do and have been unable to find helpful information searching the web. MySQL is working just fine in PHP and Im connecting to it without problem via the MySQL Administrator application. Any suggestions would be greatly appreciated. Thanks.
I run a MAMP stack myself, but use MacPort for it. I just skimmed through http://2tbsp.com/content/installapache2andphp5macports and it seems like a good tutorial for you to use. I recommend MacPort as it seems to work better than the stuff that Apple includes by default.
This is how I would do it:
1) Install MySQL 5.1 from mysql.com. 2) Download DBI::mysql and compile it. You'll have to have the Apple development tools installed, and run the following command:
export PATH=/usr/local/mysql/bin:$PATH
That'll put the mysql_config script in the path. After that it should be: perl Makefile.PL make sudo make install 3) Install MacPort 4) Have MacPort install Apache2 and PHP5, but not mysql-server.
Those steps may be a little complicated for you if you're not comfortable with Unix, but they should get you through setting up MacPort completely with Apache and the rest of the environment you need.