{"id":162,"date":"2004-12-15T08:58:37","date_gmt":"2004-12-15T13:58:37","guid":{"rendered":"http:\/\/kev.needham.ca\/blog\/?p=162"},"modified":"2004-12-15T08:58:37","modified_gmt":"2004-12-15T13:58:37","slug":"sometimes-ignorance-is-painful","status":"publish","type":"post","link":"https:\/\/kev.needham.ca\/index.php\/2004\/12\/15\/sometimes-ignorance-is-painful\/","title":{"rendered":"sometimes, ignorance is painful"},"content":{"rendered":"<p>So I&#8217;m still working on getting the new <a href=\"http:\/\/www.deadsquid.com\/\">deadsquid<\/a> server up and running to my satisfaction. It&#8217;s now using recent software, and I think the upgrade went well. It still works, and I admit I am afraid to reboot it until someone else looks at it and says &#8220;looks good to me&#8221;. That&#8217;ll happen sometime in the next couple weeks when Walt comes up for air.<\/p>\n<p>The last obstacle is an up-to-date mail system, complete with a MySQL backend, user manageable preferences, and decent <a href=\"http:\/\/dspam.nuclearelephant.com\">spam controls<\/a>. I have been fighting with the <abbr title=\"Mail Transport Agent\">MTA<\/abbr> for almost a week, and have finally conquered it. <\/p>\n<p>Long story short, it wouldn&#8217;t authenticate against the MySQL 4.1.7 database installed on the server, so couldn&#8217;t do any kind of lookups. This makes it difficult to use a database as a back-end. Had I read the documentation, I would have come across <a href=\"http:\/\/dev.mysql.com\/doc\/mysql\/en\/Password_hashing.html\">this section<\/a>, and saved myself about two days of effort.<\/p>\n<p>If you&#8217;re using Debian with your own build (or an unstable build) of MySQL 4.1.<i>x<\/i>, and a package you are installing makes use of debian MySQL client libraries that use 4.0 or less (essentially libclientmysql1<i>x<\/i>), make sure you set the database user account password using the OLD_PASSWORD directive. <\/p>\n<p>It will save you a lot of pain. Trust me on this one.<\/p>\n<p>i.e.:<br \/>\nSET PASSWORD FOR &#8216;user&#8217;@&#8217;host&#8217; = OLD_PASSWORD(&#8216;yourpassword&#8217;);<\/p>\n<p>Ah well, the things we learn.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So I&#8217;m still working on getting the new deadsquid server up and running to my satisfaction. It&#8217;s now using recent software, and I think the upgrade went well. It still works, and I admit I am afraid to reboot it until someone else looks at it and says &#8220;looks good to me&#8221;. That&#8217;ll happen sometime [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-162","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/kev.needham.ca\/index.php\/wp-json\/wp\/v2\/posts\/162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kev.needham.ca\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kev.needham.ca\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kev.needham.ca\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kev.needham.ca\/index.php\/wp-json\/wp\/v2\/comments?post=162"}],"version-history":[{"count":0,"href":"https:\/\/kev.needham.ca\/index.php\/wp-json\/wp\/v2\/posts\/162\/revisions"}],"wp:attachment":[{"href":"https:\/\/kev.needham.ca\/index.php\/wp-json\/wp\/v2\/media?parent=162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kev.needham.ca\/index.php\/wp-json\/wp\/v2\/categories?post=162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kev.needham.ca\/index.php\/wp-json\/wp\/v2\/tags?post=162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}