I wanted to update php to version 5.3.6 from 5.3.2 to cover some security issues. I also wanted to include the GD graphics library functions in this version of php. This will allow image manipulation by script, something that will allow for more dynamic, visual customization.
This is what got installed/updated:
jpeg8
libpng 1.2.44
libxml 2.7.8
freetype 2.4.4
php 5.3.6
So… […]
While updating to this new version of MySQL I found something interesting:
Size in bytes of website database at 7 June 2010 : 10034186
Size in bytes of website today, 22 March 2011: 32235361
Had extra time today. This is complete on production server.
This new version is out. I looked at the release notes https://dev.mysql.com/doc/refman/5.1/en/news-5-1-44.html and determined that none of these issues immediately affect this work or the new WERC website. I am not going to bother with this upgrade until the final rollover to production server.
Upgraded to 5.1.43.
mysql> select version();
+———————+
| version() |
+———————+
| 5.1.43-standard-log |
+———————+
1 row in set (0.00 sec)
./configure -prefix=/usr/local/mysql -with-server-suffix=-standard -enable-thread-safe-client -enable-local-infile -enable-shared -with-zlib-dir=bundled -with-big-tables -with-readline -with-plugins=all -without-docs –libexecdir=/usr/local/mysql/libexec/
Configure Commands
CFLAGS=”-arch x86_64″
CXXFLAGS=”-arch x86_64″
./configure -prefix=/usr/local/mysql
-with-server-suffix=-standard
-enable-thread-safe-client
-enable-local-infile
-enable-shared
-with-zlib-dir=bundled
-with-big-tables
-with-readline
-with-plugins=all
-with-unix-socket-path=/tmp/mysql.sock
-without-docs
This prompted a more robust set of steps to test out MySQL updates:
Read Patch Notes, make sure it does not break anything, see if the update fixes unrelated bugs, […]
I was running into errors with the previous ./configure command. I did some searching and found that the zlib library had changed and had to be recompiled if shared.
The PHP configure script now is:
./configure –prefix=/usr/local/php5
–mandir=/usr/share/man
–infodir=/usr/share/info
–sysconfdir=/etc
–with-config-file-path=/etc
–with-zlib
–with-zlib-dir=/usr/zlib
–with-openssl
–without-iconv
–enable-exif
–enable-ftp
–enable-mbstring
–enable-mbregex
–enable-sockets
–with-mysql=/usr/local/mysql
–with-pdo-mysql=/usr/local/mysql
–with-mysqli=/usr/local/mysql/bin/mysql_config
–with-mysql-sock=/tmp/mysql.sock
–with-apxs2=/usr/local/apache2/bin/apxs
Of course […]
changed the php.ini file to read:
sendmail_path = /usr/sbin/postfix -t -i
postfix actually changes over the “sendmail” binary I think.
There is a test doc up at:
https://beta.ine.uaf.edu/mailTest.php it contains a simple time function and mail() call. Just edit the email address there to have it send to you.
I test this out and it survives a restart.
Interesting mail […]