{"id":140,"date":"2015-10-05T08:30:16","date_gmt":"2015-10-05T08:30:16","guid":{"rendered":"http:\/\/alain.fi\/?p=140"},"modified":"2019-07-30T04:00:52","modified_gmt":"2019-07-30T04:00:52","slug":"php-5-4-on-squeeze-dtc-gplhost-hosting-server","status":"publish","type":"post","link":"https:\/\/alain.fi\/?p=140","title":{"rendered":"PHP 5.4 on Squeeze DTC GPLHost hosting server"},"content":{"rendered":"<p>Old stuff, update PHP for squeeze<\/p>\n<p>Before going into distribution upgrade for my hosting server:<\/p>\n<p>DTC GPLHost running on Squeeze (yeah, I know.)<\/p>\n<p>I will update php, using dotdeb repositories<\/p>\n<p>https:\/\/www.dotdeb.org\/instructions\/<\/p>\n<div class=\"crayon-pre\">\n<div id=\"crayon-56122a627e570808284463-1\" class=\"crayon-line\">deb\u00a0\u00a0\u00a0\u00a0 http:\/\/packages.dotdeb.org squeeze all<\/div>\n<div id=\"crayon-56122a627e570808284463-2\" class=\"crayon-line\">deb-src http:\/\/packages.dotdeb.org squeeze all<\/div>\n<div id=\"crayon-56122a627e570808284463-3\" class=\"crayon-line\">deb\u00a0\u00a0\u00a0\u00a0 http:\/\/packages.dotdeb.org squeeze-php54 all<\/div>\n<div id=\"crayon-56122a627e570808284463-4\" class=\"crayon-line\">deb-src http:\/\/packages.dotdeb.org squeeze-php54 all<\/div>\n<\/div>\n<div class=\"crayon-line\"><\/div>\n<div class=\"crayon-line\">apt-get update<\/div>\n<div class=\"crayon-line\"><\/div>\n<div class=\"crayon-line\">!? I do not remove the dtc-toaster, just a bad feeling doing that, I should test this sometimes on some vm.<\/div>\n<div class=\"crayon-line\"><\/div>\n<div class=\"crayon-line\">To do so, first I update mysql -&gt; 5.1 -&gt; 5.5<\/div>\n<div class=\"crayon-line\"><\/div>\n<div class=\"crayon-line\">No fear,<\/div>\n<div class=\"crayon-line\"><\/div>\n<div class=\"crayon-line\">Except mysql will not work, you need to update the user table, not the &#8220;use&#8221; command, to select the db &#8220;mysql&#8221;:<\/div>\n<div class=\"crayon-line\">killall mysqld<\/div>\n<div class=\"crayon-line\">mysqld &#8211;skip-grant-tables<\/div>\n<div class=\"crayon-line\">-&gt; in other terminal:<\/div>\n<div class=\"crayon-line\">mysql &#8211;execute=&#8217;use mysql; ALTER table `user` MODIFY COLUMN `dtcowner` varchar(255) AFTER `authentication_string`&#8217;<\/div>\n<div class=\"crayon-line\">killall mysqld<\/div>\n<div class=\"crayon-line\">\/etc\/init.d\/mysql restart<\/div>\n<div class=\"crayon-line\"><\/div>\n<div class=\"crayon-line\">\n<div class=\"crayon-line\">Then the PHP stuff, I had to remove roundcube-sqlite but that does not matter as it can use mysql.<\/div>\n<div class=\"crayon-line\"><\/div>\n<div class=\"crayon-line\">And it works, great \ud83d\ude42<\/div>\n<\/div>\n<div class=\"crayon-line\"><\/div>\n<div class=\"crayon-line\">I did not keep old config, make sure to keep copy of your old php config, and check what you should modify.<\/div>\n<div class=\"crayon-line\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Old stuff, update PHP for squeeze Before going into distribution upgrade for my hosting server: DTC GPLHost running on Squeeze (yeah, I know.) I will update php, using dotdeb repositories https:\/\/www.dotdeb.org\/instructions\/ deb\u00a0\u00a0\u00a0\u00a0 http:\/\/packages.dotdeb.org squeeze all deb-src http:\/\/packages.dotdeb.org squeeze all deb\u00a0\u00a0\u00a0\u00a0 &hellip; <a href=\"https:\/\/alain.fi\/?p=140\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-140","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/alain.fi\/index.php?rest_route=\/wp\/v2\/posts\/140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alain.fi\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alain.fi\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alain.fi\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alain.fi\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=140"}],"version-history":[{"count":3,"href":"https:\/\/alain.fi\/index.php?rest_route=\/wp\/v2\/posts\/140\/revisions"}],"predecessor-version":[{"id":174,"href":"https:\/\/alain.fi\/index.php?rest_route=\/wp\/v2\/posts\/140\/revisions\/174"}],"wp:attachment":[{"href":"https:\/\/alain.fi\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alain.fi\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alain.fi\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}