{"id":453,"date":"2012-11-19T08:54:27","date_gmt":"2012-11-19T16:54:27","guid":{"rendered":"http:\/\/blt.homenet.org\/wordpress\/?p=453"},"modified":"2017-08-01T21:22:38","modified_gmt":"2017-08-02T04:22:38","slug":"fun-times-with-apache-2-4-3-php-5-4-3-and-mysql-5-5-updates","status":"publish","type":"post","link":"https:\/\/bt.beerprojects.com\/wordpress\/?p=453","title":{"rendered":"Fun times with Apache 2.4.3, PHP 5.4.3, and MySql 5.5 updates"},"content":{"rendered":"<p><a href=\"http:\/\/dilbert.com\/strips\/comic\/1997-11-27\/\"><\/a><\/p>\n<p>About a month ago I got a virus on my computer and in my infinite wisdom I used a registry scanner to help clean up the issue.\u00a0 This scanner also decided to delete some files that allowed my website to work.\u00a0\u00a0 I should have just rolled back my windows 7 to the last registry backup, but too late the damage was done.\u00a0 For the life of me I couldn&#8217;t figure out which files it wiped out as it didnt&#8217; have a log of the actions it took.<\/p>\n<p>So I embarked on re-setting up my apache server.\u00a0 I didn&#8217;t keep any of the installation files I used the first go around so I ended up downloading the files all over again. I got apache from <a href=\"http:\/\/www.apachelounge.com\/download\/win64\/\" target=\"_blank\">Apache Lounge<\/a>.\u00a0 I found 64-bit version of php at <a href=\"http:\/\/www.anindya.com\/php-5-4-3-and-php-5-3-13-x64-64-bit-for-windows\/\" target=\"_blank\">http:\/\/www.anindya.com\/php-5-4-3-and-php-5-3-13-x64-64-bit-for-windows\/<\/a>\u00a0 and don&#8217;t forget about the extensions needed on the same webpage.\u00a0 And MySQL from their own <a href=\"http:\/\/dev.mysql.com\/downloads\/mysql\/\" target=\"_blank\">website<\/a>. Lesson 1:\u00a0 Save the installation files for future re-use.<\/p>\n<p>Well of course apache, php, and mysql all had updates that caused various issues.\u00a0 This being my first real upgrade I discovered something quite important that is noted in all the installation files.\u00a0 First backup the apache and php config files.\u00a0 Then start with the generic config files (httpd.conf and php.ini-production) and then add back in my unique settings.\u00a0 I initially tried to just start with my old configuration files and then add in the new default settings, but this is really messy and not the way to do it.<\/p>\n<p>In apache, Order commands are depreciated are now depreciated\u00a0 as noted in these two links (<a href=\"http:\/\/systembash.com\/content\/apache-2-4-upgrade-and-the-invalid-command-order-error\/\" target=\"_blank\">1<\/a> and <a href=\"http:\/\/dabase.com\/blog\/AH01630:_client__by_server_configuration\/\" target=\"_blank\">2<\/a>) so I had to make several updates to the httpd.conf file to correct this.\u00a0 Additionally, several changes were made to the LoadModule selections.<\/p>\n<pre>\u00a0#new for 2.4.3 update\r\nLoadModule access_compat_module modules\/mod_access_compat.so\r\nLoadModule allowmethods_module modules\/mod_allowmethods.so<\/pre>\n<pre>###This is needed for SSL to work in update\r\nLoadModule socache_shmcb_module modules\/mod_socache_shmcb.so<\/pre>\n<pre>#changed with 2.4.3 update\r\n#LoadModule authz_default_module modules\/mod_authz_default.so\r\nLoadModule authz_core_module modules\/mod_authz_core.so<\/pre>\n<pre>#changed with 2.4.3 update\r\n#LoadModule authn_default_module modules\/mod_authn_default.so\r\nLoadModule authn_core_module modules\/mod_authn_core.so<\/pre>\n<p>With the updates I was\/am having issues with wordpress so I updated that again too to version 3.4.2 and still noticed the problem with numeric links and have blogged about it <a title=\"Numeric Permalinks are broken\" href=\"http:\/\/bt.beerprojects.com\/wordpress\/?p=451\">here<\/a>.<\/p>\n<p>But after all of that I appear to be back up and working.\u00a0 I did notice during this whole process that the use of Location in the httpf.conf file to make sure certain webpages use https rather than http was not case sensitive.\u00a0 I&#8217;m still working on this and hope to post about it again when I understand things, but for here is a link the <a href=\"http:\/\/www.apachelounge.com\/viewtopic.php?t=5051&amp;highlight=\" target=\"_blank\">my forum post<\/a> about the topic<\/p>\n","protected":false},"excerpt":{"rendered":"<p>About a month ago I got a virus on my computer and in my infinite wisdom I used a registry scanner to help clean up the issue.\u00a0 This scanner also decided to delete some files that allowed my website to work.\u00a0\u00a0 I should have just rolled back my windows 7 to the last registry backup, [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[59,57,54,56,58,55,60],"class_list":["post-453","post","type-post","status-publish","format-standard","hentry","category-tech-talk","tag-64-bit","tag-apache","tag-apache-2-4-3","tag-mysql-5-5","tag-php","tag-php-5-4-3","tag-windows"],"_links":{"self":[{"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/453","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=453"}],"version-history":[{"count":10,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/453\/revisions"}],"predecessor-version":[{"id":1734,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/453\/revisions\/1734"}],"wp:attachment":[{"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bt.beerprojects.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}