{"id":831,"date":"2013-08-23T06:32:00","date_gmt":"2013-08-23T06:32:00","guid":{"rendered":"http:\/\/www.plugged.in\/?p=831"},"modified":"2013-08-23T06:32:00","modified_gmt":"2013-08-23T06:32:00","slug":"installing-ms-sql-module-to-php-on-directadmin","status":"publish","type":"post","link":"https:\/\/www.veriteknik.net.tr\/en\/installing-ms-sql-module-to-php-on-directadmin\/","title":{"rendered":"Installing MS SQL Module to PHP on DirectAdmin"},"content":{"rendered":"<p>If you need to connect to an MS Sql Server remotely from your DirectAdmin server via php, you need to rebuild PHP with necessary components. Get the latest stable release of FreeTDS and install it.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">cd \/root\nwget ftp:\/\/ftp.astron.com\/pub\/freetds\/current\/freetds-current.tgz\ntar -xvzf freetds-current.tgz\ncd freetds-dev.0.92.377\n.\/configure --prefix=\/usr\/local\/freetds\nmake\nmake install<\/pre>\n<p>Now we should tell Direct Admin&#8217;s custom build that we want the MS Sql libraries installed using freetds.Edit the file :\/usr\/local\/directadmin\/custombuild\/configure\/ap2\/configure.php5 add<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">--with-mssql=\/usr\/local\/freetds \\<\/pre>\n<p>to anywhere in the file. If you&#8217;re adding it the to end of the file, don&#8217;t add the <strong>\\<\/strong> at the end, instead add to the end of the line &#8220;before&#8221; the last line. Now go to custombuild and build the new PHP.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">cd \/usr\/local\/directadmin\/custombuild\n.\/build clean\n.\/build php d<\/pre>\n<p>Check if MS Sql is intalled.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">php -m|grep mssql\nmssql<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>If you need to connect to an MS Sql Server remotely from your DirectAdmin server via php, you need to rebuild PHP with necessary components. Get the latest stable release of FreeTDS and install it. cd \/root wget ftp:\/\/ftp.astron.com\/pub\/freetds\/current\/freetds-current.tgz tar -xvzf freetds-current.tgz cd freetds-dev.0.92.377 .\/configure &#8211;prefix=\/usr\/local\/freetds make make install Now we should tell Direct Admin&#8217;s [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[461,370],"tags":[455,415,375],"yst_prominent_words":[],"class_list":["post-831","post","type-post","status-publish","format-standard","hentry","category-directadmin-linux","category-linux","tag-directadmin","tag-mssql","tag-php"],"jetpack_featured_media_url":"","uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Mustafa Emre Ayd\u0131n","author_link":"https:\/\/www.veriteknik.net.tr\/en\/author\/eaydin\/"},"uagb_comment_info":0,"uagb_excerpt":"If you need to connect to an MS Sql Server remotely from your DirectAdmin server via php, you need to rebuild PHP with necessary components. Get the latest stable release of FreeTDS and install it. cd \/root wget ftp:\/\/ftp.astron.com\/pub\/freetds\/current\/freetds-current.tgz tar -xvzf freetds-current.tgz cd freetds-dev.0.92.377 .\/configure --prefix=\/usr\/local\/freetds make make install Now we should tell Direct Admin&#8217;s&hellip;","_links":{"self":[{"href":"https:\/\/www.veriteknik.net.tr\/en\/wp-json\/wp\/v2\/posts\/831","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.veriteknik.net.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.veriteknik.net.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.veriteknik.net.tr\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.veriteknik.net.tr\/en\/wp-json\/wp\/v2\/comments?post=831"}],"version-history":[{"count":0,"href":"https:\/\/www.veriteknik.net.tr\/en\/wp-json\/wp\/v2\/posts\/831\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.veriteknik.net.tr\/en\/wp-json\/wp\/v2\/media?parent=831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.veriteknik.net.tr\/en\/wp-json\/wp\/v2\/categories?post=831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.veriteknik.net.tr\/en\/wp-json\/wp\/v2\/tags?post=831"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.veriteknik.net.tr\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}