Fwd: MySQL5 and php5

[Mark Hattam]

Begin forwarded message:

> From: Mark Hattam <mark at dxradio.demon.co.uk>
> Date: 27 August 2009 22:27:46 BST
> To: MacPorts Users <macports-users at lists.macosforge.org>
> Subject: MySQL5 and php5
>
> As I've just port sync'd and received
>
> The following installed ports are outdated:
> mysql5                         5.0.84_0 < 5.0.85_0
> mysql5-server                  5.0.84_0 < 5.0.85_0
> php5                           5.3.0_1 < 5.3.0_2
>
> It seems a good opportunity to sort out my MySQL5 and php5  
> installations, as they're the "old" standard, rather than the  
> prolilfic number of new sub-ports.
>
> sudo port installed has
>
> The following ports are currently installed:
>  apache2 @2.2.11_0+darwin_9 (active)
>  apr @1.3.8_0 (active)
>  apr-util @1.3.9_0 (active)
>  autoconf @2.64_2 (active)
>  autoconf213 @2.13_1 (active)
>  automake @1.11_0 (active)
>  bash @4.0.28_0 (active)
>  bzip2 @1.0.5_2 (active)
>  ctags @5.8_0 (active)
>  curl @7.19.6_0 (active)
>  cyrus-sasl2 @2.1.23_0+kerberos (active)
>  db46 @4.6.21_5 (active)
>  dovecot @1.1.16_0+darwin_9 (active)
>  dspam @3.8.0_0+mysql5 (active)
>  expat @2.0.1_0 (active)
>  fontconfig @2.7.1_0+macosx (active)
>  freetype @2.3.9_0+macosx (active)
>  gawk @3.1.7_0 (active)
>  gdbm @1.8.3_1 (active)
>  getmail @4.11.0_0 (active)
>  gettext @0.17_4 (active)
>  gmake @3.81_0 (active)
>  gperf @3.0.4_0 (active)
>  grep @2.5.4_0 (active)
>  gsed @4.2.1_0 (active)
>  gzip @1.3.12_0 (active)
>  help2man @1.36.4_1 (active)
>  jpeg @6b_3 (active)
>  less @436_0 (active)
>  libiconv @1.13_0 (active)
>  libmcrypt @2.5.8_1 (active)
>  libpng @1.2.38_0 (active)
>  libtool @2.2.6a_0 (active)
>  libxml2 @2.7.3_0 (active)
>  libxslt @1.1.24_2 (active)
>  m4 @1.4.13_0 (active)
>  maildrop @2.2.0_0 (active)
>  mhash @0.9.9.9_0 (active)
>  mysql5 @5.0.84_0+server (active)
>  mysql5-server @5.0.84_0 (active)
>  ncurses @5.7_0 (active)
>  ncursesw @5.7_0 (active)
>  neon @0.28.6_0 (active)
>  openssl @0.9.8k_0 (active)
>  p5-locale-gettext @1.05_0 (active)
>  pcre @7.9_0 (active)
>  perl5.8 @5.8.9_3 (active)
>  php5 @5.3.0_1+apache2+macosx+mysql5 (active)
>  php5-gd @5.3.0_0 (active)
>  php5-mcrypt @5.3.0_1 (active)
>  pkgconfig @0.23_1 (active)
>  python25 @2.5.4_6+darwin_9+macosx (active)
>  python_select @0.2.1_0+darwin_9 (active)
>  readline @6.0.000_1 (active)
>  serf @0.3.0_0 (active)
>  sqlite3 @3.6.17_0 (active)
>  subversion @1.6.5_0 (active)
>  tcl @8.5.6_0 (active)
>  tiff @3.8.2_3+macosx (active)
>  tk @8.5.6_1 (active)
>  vim @7.2.245_0 (active)
>  wget @1.11.4_3 (active)
>  Xft2 @2.1.13_2 (active)
>  xorg-bigreqsproto @1.0.2_0 (active)
>  xorg-inputproto @1.5.1_0 (active)
>  xorg-kbproto @1.0.3_0 (active)
>  xorg-libX11 @1.2.2_0 (active)
>  xorg-libXau @1.0.4_1 (active)
>  xorg-libXdmcp @1.0.2_1 (active)
>  xorg-libXext @1.0.99.4_1 (active)
>  xorg-libXScrnSaver @1.2.0_0 (active)
>  xorg-renderproto @0.11_0 (active)
>  xorg-scrnsaverproto @1.2.0_0 (active)
>  xorg-util-macros @1.2.2_0 (active)
>  xorg-xcmiscproto @1.1.2_0 (active)
>  xorg-xextproto @7.1.1_0 (active)
>  xorg-xf86bigfontproto @1.1.2_0 (active)
>  xorg-xproto @7.0.15_0 (active)
>  xorg-xtrans @1.2.4_0 (active)
>  xrender @0.9.4_6 (active)
>  zlib @1.2.3_2 (active)
>
>
> But what do I have to uninstall in what order, and will I be able to  
> rebuild everything again ... ? Is there a standard crib sheet of  
> which php5 subports used to get installed as "standard" and which of  
> these I now have to install separately? So far I've only run foul of  
> gd and mcrypt as you can see above.
>
> does php5 need +mysql5 or +mysql5-server or php5-mysql +mysql5  
> or ... ?
> sudo port install php5 +mysql5
> sudo port install php5 +mysql5-server
> sudo port install php5-mysql +mysql5
>
> oh and apache2 is still 2.2.11 not 2.2.13 ...
>
> Mark