Mac OS X Install MySQL, Apache + mod_xsendfile, PHP with iconv, gd, pdo, and bug fixes, and PHPMyAdmin

By -
apache:
- for apache + mod_xsendfile, read the blog post regarding on mod_xsendfile compiling w/in mac os x for apache module

php:

sudo CFLAGS="-arch x86_64 -g -Os -pipe -no-cpp-precomp" CCFLAGS="-arch x86_64 -g -Os -pipe" CXXFLAGS="-arch x86_64 -g -Os -pipe" LDFLAGS="-arch x86_64 -bind_at_load" './configure' '--prefix=/usr' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--with-config-file-path=/etc/' '--with-config-file-scan-dir=/opt/local/var/db/php5' '--enable-bcmath' '--enable-ctype' '--enable-dom' '--enable-fileinfo' '--enable-filter' '--enable-hash' '--enable-json' '--enable-libxml' '--enable-pdo' '--enable-phar' '--enable-session' '--enable-simplexml' '--enable-tokenizer' '--enable-xml' '--enable-xmlreader' '--enable-xmlwriter' '--with-bz2=/opt/local' '--with-mhash=/opt/local' '--with-pcre-regex=/opt/local' '--with-readline=/opt/local' '--with-libxml-dir=/opt/local' '--with-zlib=/opt/local' '--disable-cgi' '--with-ldap=/usr' '--with-apxs2=/opt/local/apache2/bin/apxs' '--with-mysqli=/usr/local/mysql/bin/mysql_config' '--with-openssl' '--with-mcrypt=/opt/local/' '--with-mysql=/usr/local/mysql-5.1.42-osx10.6-x86_64/' '--with-iconv=/usr' '--with-curl=/opt/local' '--enable-mbstring' '--with-gd' '--with-jpeg-dir=/opt/local' '--with-png-dir=/opt/local' '--with-freetype-dir=/opt/local' '--with-t1lib=/opt/local' '--enable-gd-native-ttf'  --with-ttf


- afer running ./configure successfully, vi Makefile, then add -lresolv in EXTRA_LIBS assignment which would avoid the "error _res_9_dn_expand" as undefined symbol (in php 5.2.12 this is fixed and won't be encountered anymore).
- save then run make
- with-iconv problem bug was "_iconv_close" undefined symbol and the fix was  I did use the php 5.2.12 version and it works smoothly.
- for php with mysql, use the downloaded mysql which are located in /usr/local/mysql-5.1.42-osx10.6-x86_64/ which contains the headers and the source, then point that thru '--with-mysql=/usr/local/mysql-5.1.42-osx10.6-x86_64/'
- --with-ttf and --enable-gd-native-ttf will avoid this error:
Fatal error: Call to undefined function imagettftext()
Encountering the error above, you must also make clean before issuing the "make" command, else error will still keep resuming


mysql:
- http://dev.mysql.com/downloads/mysql/4.0.html then chose the Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive
- install
- system preferences, start mysql or start mysql  on startup
- files are in /usr/local/mysql

phpmyadmin:
- PHP Fatal error: Class 'ArrayObject' not found in /www/phpmyadmin/libraries/List.class.php on line 14
- workaround is download thru PEAR though I manage it by copying the PEAR contents from my slackware linux box
- ArrayObject is part of SPL (Standard PHP Library)


Comments

PHP Developer India said…
Thanks for sharing nice stuff.
February 12, 2010 at 9:36 PM
Post a Comment

Popular posts from this blog

Using Oracle 11g thru VirtualBox appliance in Mac OS X Lion

By -
Image
I just found that its quite a lot of handy work to make Oracle work in Mac OS X Lion. Currently, I have this quite cool machine with good memory anyway, so I decided to step the easy way, than the "too-much-time-to-work way". So, I just decided to use VirtualBox with Oracle's pre-built virtual appliance with Oracle 11g Enterprise Edition. To use this, I use the steps below. 1. Download VirtualBox at http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html 2. Download the virtual appliances at http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html then just follow the steps. 3. I added some specific ports, since I access it thru  NAT so whenever I am, it's easier for me just to hook up my virtual appliance and turn it on. So you can issue these command in your terminal, $> VBoxManage modifyvm "OTN Developer Days" --natpf1 "ssh,tcp,,2222,,22" $> VBoxManag...
Read more

Use Shell Editor for Eclipse for editing bash, ksh, csh in Unix/Linux system

By -
Image
I found ShellEd when googling for any shell editor. It was trouble at first because there's no  how-to that directs me, where I expect to have a direct link that I can copy-en-paste to my Eclipse for installation. So what I did, I download ShellEd (as of this writing file version ShellEd-Update-2.0.0_M3.zip) from sourceforge.net and install, as required, the Linux Tools . After installing Linux Tools, I then locate thru archive the ShellEd zip file and install it successfully. It works good and I feel satisfied with this cool tool to be embedded in eclipse. The sample attached shell script is from JBoss twiddle. It does supports syntax highlighting, intellisense which is cool. Hope this helps.
Read more

LVM: How to remove a volume using pvremove

By -
First, I encountered this error "Can't pvremove physical volume "/dev/sdc1" of volume group "nova-volumes" without -ff" (I'm actually using OpenStack but it's another story). So to remove this, do first, ~# pvscan   PV /dev/sdb1   VG nova-volumes    lvm2 [1.82 TiB / 1.82 TiB free]   PV /dev/sda5   VG cloudmaster     lvm2 [297.85 GiB / 12.00 MiB free]   PV /dev/sdc1                      lvm2 [1.82 TiB]   Total: 3 [3.93 TiB] / in use: 2 [2.11 TiB] / in no VG: 1 [1.82 TiB] Then, when I do, ~# pvremove /dev/sdc1  Can't pvremove physical volume "/dev/sdc1" of volume group "nova-volumes" without -ff So I need to, ~# vgreduce nova-volumes /dev/sdc1   Removed "/dev/sdc1" from volume group "nova-volumes" Then do `pvscan` again, ~# pvscan   PV /dev/sdb1   VG nova-volumes    lvm2 [1.82 TiB / 1.82 TiB free]   PV /dev/sda5   VG clou...
Read more