{"id":170,"date":"2006-03-07T14:18:54","date_gmt":"2006-03-07T19:18:54","guid":{"rendered":"http:\/\/blog.elharo.com\/blog\/?p=170"},"modified":"2006-03-22T09:57:57","modified_gmt":"2006-03-22T14:57:57","slug":"converting-a-mini-to-a-server-part-3-mysql-and-php","status":"publish","type":"post","link":"https:\/\/www.elharo.com\/blog\/software-development\/databases\/2006\/03\/07\/converting-a-mini-to-a-server-part-3-mysql-and-php\/","title":{"rendered":"Converting a Mini to a Server, Part 3: MySQL and PHP"},"content":{"rendered":"

To summarize what has gone before, I now have headless, network access to a Mac X86 Mini<\/a>, and have successfully installed Apache 2.0.55<\/a>. The next step is to install MySQL, PHP, and WordPress; then copy The Cafes and elharo.com from the old server to the Mini.
\n<\/p>\n

First up, MySQL. This almost couldn’t be easier. MySQL AB publishes a precompiled binary for X86 Macs, and it’s installed using the usual Mac installer. This is about the easiest server side install I’ve ever had to do. The only thing that could be better would be to not include a separate install for the autolauncher. Oh, and it should probably ask you for a database root password while installing rather than letting it be set later. Let’s do that before I forget:<\/p>\n

mini:\/usr\/local\/mysql elharo$ .\/bin\/mysqladmin -u root password mynewpassword
\nmini:\/usr\/local\/mysql elharo$ .\/bin\/mysql -u root -pmynewpassword
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 5 to server version: 5.0.18-standard<\/p>\n

Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the buffer.<\/p>\n

mysql> DELETE FROM mysql.user WHERE User = ”;
\nQuery OK, 2 rows affected (0.00 sec)<\/p>\n

mysql> FLUSH PRIVILEGES;
\nQuery OK, 0 rows affected (0.00 sec)
\n<\/samp><\/p>\n

But honestly these are nickel-and-dime issues compared to what you have to go through with most server side software.<\/p>\n

Next up is PHP. I’ll need to build this one from source. <\/p>\n

mini:~\/Desktop\/php-5.1.2 elharo$ .\/configure –with-apxs2=\/usr\/httpd\/bin\/apxs –with-mysql=\/usr\/local\/mysql –prefix=\/opt\/php5 –with-libxslt –with-tidy
\ncreating cache .\/config.cache
\nchecking for Cygwin environment… no
\nchecking for mingw32 environment… no
\n…
\ncreating main\/internal_functions_cli.c
\n+——————————————————————–+
\n| License: |
\n| This software is subject to the PHP License, available in this |
\n| distribution in the file LICENSE. By continuing this installation |
\n| process, you are bound by the terms of this license agreement. |
\n| If you do not agree with the terms of this license, you must abort |
\n| the installation process at this point. |
\n+——————————————————————–+<\/samp><\/p>\n

Thank you for using PHP.<\/samp><\/p>\n

Now onto make:<\/p>\n

mini:~\/Desktop\/php-5.1.2 elharo$ make
\n\/bin\/sh \/Users\/elharo\/Desktop\/php-5.1.2\/libtool –silent –preserve-dup-deps –mode=compile gcc -Iext\/libxml\/ -I\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/libxml\/ -DPHP_ATOM_INC -I\/Users\/elharo\/Desktop\/php-5.1.2\/include -I\/Users\/elharo\/Desktop\/php-5.1.2\/main -I\/Users\/elharo\/Desktop\/php-5.1.2 -I\/usr\/include\/libxml2 -I\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/date\/lib -I\/usr\/local\/mysql\/include -I\/usr\/include\/tidy -I\/Users\/elharo\/Desktop\/php-5.1.2\/TSRM -I\/Users\/elharo\/Desktop\/php-5.1.2\/Zend -no-cpp-precomp -I\/usr\/include -g -O2 -c \/Users\/elharo\/Desktop\/php-5.1.2\/ext\/libxml\/libxml.c -o ext\/libxml\/libxml.lo
\n\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/libxml\/libxml.c: In function ‘php_libxml_streams_IO_open_wrapper’:
\n\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/libxml\/libxml.c:264: warning: pointer targets in passing argument 1 of ‘xmlParseURI’ differ in signedness
\n\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/libxml\/libxml.c:265: warning: pointer targets in passing argument 1 of ‘xmlStrncmp’ differ in signedness
\n\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/libxml\/libxml.c:265: warning: pointer targets in passing argument 2 of ‘xmlStrncmp’ differ in signedness
\n\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/libxml\/libxml.c: In function ‘_php_list_set_error_structure’:
\n\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/libxml\/libxml.c:433: warning: pointer targets in passing argument 1 of ‘xmlStrdup’ differ in signedness
\n\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/libxml\/libxml.c:433: warning: pointer targets in assignment differ in signedness
\n…
\n\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/tidy\/tidy.c:1084: warning: pointer targets in initialization differ in signedness
\n\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/tidy\/tidy.c: In function ‘zif_tidy_get_output’:
\n\/Users\/elharo\/Desktop\/php-5.1.2\/ext\/tidy\/tidy.c:1100: warning: pointer targets in initialization differ in signedness
\nmake: *** [ext\/tidy\/tidy.lo] Error 1
\n<\/samp><\/p>\n

Hmm, those libxml warnings are troublesome. I wonder if Tidy and\/or libxsl assuming something they shouldn’t be about the signedness of a Mac? I don’t think I have to have libxsl or libtidy right now so let’s reconfigure and try again without them.<\/p>\n

mini:~\/Desktop\/php-5.1.2 elharo$ make clean
\nfind . -name \\*.lo -o -name \\*.o | xargs rm -f
\nfind . -name \\*.la -o -name \\*.a | xargs rm -f
\nfind . -name \\*.so | xargs rm -f
\nfind . -name .libs -a -type d|xargs rm -rf
\nrm -f libphp5.la sapi\/cli\/php libs\/libphp5.bundle modules\/* libs\/*
\nmini:~\/Desktop\/php-5.1.2 elharo$ .\/configure –with-apxs2=\/usr\/httpd\/bin\/apxs –with-mysql=\/usr\/local\/mysql –prefix=\/opt\/php5
\nloading cache .\/config.cache
\nchecking for Cygwin environment… (cached) no
\nchecking for mingw32 environment… (cached) no
\nchecking for egrep… (cached) grep -E
\nchecking for a sed that does not truncate output… (cached) \/usr\/bin\/sed
\nchecking host system type… i686-apple-darwin8.5.3
\nchecking target system type… i686-apple-darwin8.5.3
\nchecking for gcc… (cached) gcc
\n…
\nBuild complete.
\n(It is safe to ignore warnings about tempnam and tmpnam).
\n<\/samp><\/p>\n

OK. That worked. I’ll have to remember that I don’t have libtidy or libxslt installed in this. Finally install:<\/p>\n

mini:~\/Desktop\/php-5.1.2 elharo$ sudo make install
\nPassword:
\nInstalling PHP SAPI module: apache2handler
\n\/usr\/httpd\/build\/instdso.sh SH_LIBTOOL=’\/usr\/httpd\/build\/libtool’ libs\/libphp5.so \/usr\/httpd\/modules
\n\/usr\/httpd\/build\/libtool –mode=install cp libs\/libphp5.so \/usr\/httpd\/modules\/
\ncp libs\/libphp5.so \/usr\/httpd\/modules\/libphp5.so
\nWarning! dlname not found in \/usr\/httpd\/modules\/libphp5.so.<\/em>
\nAssuming installing a .so rather than a libtool archive.
\n…
\nWrote PEAR system config file at: \/opt\/php5\/etc\/pear.conf
\nYou may want to add: \/opt\/php5\/lib\/php to your php.ini include_path
\nInstalling PDO headers: \/opt\/php5\/include\/php\/ext\/pdo\/
\n<\/samp><\/p>\n

OK. Let’s load up a simple PHP page and see if PHP is working or if I need to restart Apache or some such. Nope. Doesn’t work. It’s just displaying the PHP file, not interpreting it. Let’s restart the server. OK. Now something’s changed. It isn’t showing anything at all instead of showing the PHP source code. At least that means it understands there’s something didfferent about a .phtml file. Let’s look in the error log and see what we see. [Tue Mar 07 13:46:33 2006] [notice] child pid 18205 exit signal Bus error (10)
\n[Tue Mar 07 13:46:37 2006] [notice] child pid 18206 exit signal Bus error (10)
\n[Tue Mar 07 13:46:51 2006] [notice] child pid 18207 exit signal Bus error (10)<\/samp><\/p>\n

Could that be the problem? Let’s reload the .php<\/tt> page one more time and see if that adds an error. Yep, that’s it all right. Now the question becomes, why is that happening? Googling on the error message is sometimes productive. This thread<\/a> may be relevant, but doesn’t seem to have a definite answer. <\/p>\n

OK. Figured it out. I hadn’t installed a php.ini<\/tt> in \/usr\/ocal\/lib<\/tt>. You’d think that would have been installed by default but I guess not. But now it’s back to showing the PHP source code? Why?<\/p>\n

OK. Figured that out. I had not yet added the line <\/p>\n

AddType application\/x-httpd-php .php .phtml<\/code><\/p>\n

to httpd.conf<\/tt>. Again the installer should have done this, but it didn’t. Believe it or not, it took me longer than it should have to figure out the problem because of yet another variation of the nastiest bug<\/a>. This time, I had httpd.conf<\/tt> files from two different web servers open in several different terminal windows, and I checked for the AddType line in what I thought was the new server but was in fact the old server.<\/p>\n

In any case, I now seem to have a functioning Apache 2\/MySQL 5\/PHP 5 system compiled natively for the Mac Mini. The next step is to set up the virtual hosts, install WordPress in each one, and load the old data. This seems like as a good a time as any to update to the latest version of WordPress, and since I have it on good authority that 2.0.2 is coming out very<\/em> soon, I think I’ll wait for that before moving ahead. <\/p>\n","protected":false},"excerpt":{"rendered":"

To summarize what has gone before, I now have headless, network access to a Mac X86 Mini, and have successfully installed Apache 2.0.55. The next step is to install MySQL, PHP, and WordPress; then copy The Cafes and elharo.com from the old server to the Mini.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[410],"class_list":["post-170","post","type-post","status-publish","format-standard","hentry","category-databases","tag-flash"],"_links":{"self":[{"href":"https:\/\/www.elharo.com\/blog\/wp-json\/wp\/v2\/posts\/170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.elharo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.elharo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.elharo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.elharo.com\/blog\/wp-json\/wp\/v2\/comments?post=170"}],"version-history":[{"count":0,"href":"https:\/\/www.elharo.com\/blog\/wp-json\/wp\/v2\/posts\/170\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.elharo.com\/blog\/wp-json\/wp\/v2\/media?parent=170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.elharo.com\/blog\/wp-json\/wp\/v2\/categories?post=170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.elharo.com\/blog\/wp-json\/wp\/v2\/tags?post=170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}