{"id":333,"date":"2014-10-20T08:11:12","date_gmt":"2014-10-20T13:11:12","guid":{"rendered":"http:\/\/www.popmartian.com\/tipsntricks\/?p=333"},"modified":"2014-10-20T08:15:19","modified_gmt":"2014-10-20T13:15:19","slug":"how-to-build-non-root-freetds-for-linux","status":"publish","type":"post","link":"https:\/\/www.popmartian.com\/tipsntricks\/2014\/10\/20\/how-to-build-non-root-freetds-for-linux\/","title":{"rendered":"HOW TO Build non-root FreeTDS for Linux"},"content":{"rendered":"<p>This tutorial shows you how to build FreeTDS on any Linux (and probably Unix) system in a stand-alone fashion.  No root or packages required.<\/p>\n<p><strong>Prerequisites:<\/strong><br \/>\nYou do need a compiler and functional build environment.  If you can successfully <code>.\/configure && make && make install<\/code> then you are all set.<\/p>\n<p><strong>Step 1: Get the software<\/strong><br \/>\nDownload the latest stable release from <a href=\"http:\/\/freetds.org\" title=\"freetds.org\">freetds.org<\/a><\/p>\n<p><strong>Step 2: Unpack<\/strong><br \/>\nUnpack the software in to a directory <strong><em>different<\/em><\/strong> from the install directory.<\/p>\n<p>In this example, I&#8217;m using <code>\/appserver\/freetdsbuild\/<\/code>, but I will install in to <code>\/appserver\/freetds-0.91\/<\/code><\/p>\n<p><code>mkdir \/appserver\/freetdsbuild\/<br \/>\ncp freetds-stable.tgz \/appserver\/freetdsbuild\/<br \/>\ncd \/appserver\/freetdsbuild\/<br \/>\ngunzip freetds-stable.tgz<br \/>\ntar xf freetds-stable.tar<br \/>\ncd freetds-0.91<br \/>\n<\/code><\/p>\n<p><strong>Step 3: Compile<\/strong><br \/>\nHere we are going to configure it to install in to an alternate directory<\/p>\n<p><code>.\/configure --prefix=\/appserver\/freetds-0.91 --exec-prefix=\/appserver\/freetds-0.91\/ --enable-msdblib<br \/>\nmake<br \/>\nmake install<br \/>\n<\/code><\/p>\n<p>At this point it is safe to remove <code>\/appserver\/freetdsbuild\/<\/code> if you don&#8217;t need it.<\/p>\n<p><strong>Step 4: Make the symlink<\/strong><br \/>\nThe final stop is to make a symlink from <code>\/appserver\/freetds-0.91<\/code> to <code>\/appserver\/freetds<\/code>.  This lets you point your application to the freetds directory.  If you need to modify to upgrade FreeTDS, you can build a new version and simply move the symlink.  Your application won&#8217;t need to change.<\/p>\n<p><code>ln -s \/appserver\/freetds-0.91\/ \/appserver\/freetds\/<\/code><\/p>\n<p>Done!<\/p>\n<p>P.S. You can find your config files in <code>\/appserver\/freetds\/etc\/<\/code><\/p>\n<blockquote><p>Did you find this post useful or have questions or comments?  Please let  me know!<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial shows you how to build FreeTDS on any Linux (and probably Unix) system in a stand-alone fashion. No root or packages required. Prerequisites: You do need a compiler and functional build environment. If you can successfully .\/configure &#038;&#038; &hellip; <a href=\"https:\/\/www.popmartian.com\/tipsntricks\/2014\/10\/20\/how-to-build-non-root-freetds-for-linux\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,27],"tags":[68],"class_list":["post-333","post","type-post","status-publish","format-standard","hentry","category-how-to-do-stuff","category-linux","tag-freetds"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.popmartian.com\/tipsntricks\/wp-json\/wp\/v2\/posts\/333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.popmartian.com\/tipsntricks\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.popmartian.com\/tipsntricks\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.popmartian.com\/tipsntricks\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.popmartian.com\/tipsntricks\/wp-json\/wp\/v2\/comments?post=333"}],"version-history":[{"count":9,"href":"https:\/\/www.popmartian.com\/tipsntricks\/wp-json\/wp\/v2\/posts\/333\/revisions"}],"predecessor-version":[{"id":342,"href":"https:\/\/www.popmartian.com\/tipsntricks\/wp-json\/wp\/v2\/posts\/333\/revisions\/342"}],"wp:attachment":[{"href":"https:\/\/www.popmartian.com\/tipsntricks\/wp-json\/wp\/v2\/media?parent=333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.popmartian.com\/tipsntricks\/wp-json\/wp\/v2\/categories?post=333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.popmartian.com\/tipsntricks\/wp-json\/wp\/v2\/tags?post=333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}