{"id":237,"date":"2019-09-02T01:13:45","date_gmt":"2019-09-01T22:13:45","guid":{"rendered":"https:\/\/buraksuatgorgun.com.tr\/?p=237"},"modified":"2019-09-02T01:13:45","modified_gmt":"2019-09-01T22:13:45","slug":"directadmin-mssql_connect-freetds-kurulumu","status":"publish","type":"post","link":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/2019\/09\/02\/directadmin-mssql_connect-freetds-kurulumu\/","title":{"rendered":"DirectAdmin mssql_connect (FreeTDS) Kurulumu"},"content":{"rendered":"\n

Selamlar arkada\u015flar,<\/p>\n\n\n\n

DirectAdmin’in derledi\u011fi PHP, default hali ile mssql veritabanlar\u0131na ba\u011flanmamaktad\u0131r.<\/p>\n\n\n\n

Bunun i\u00e7in freetds kurulmal\u0131.<\/p>\n\n\n\n

\nhttp:\/\/www.freetds.org\/\n<\/div><\/figure>\n\n\n\n

Siteden Stable Release’in URL sini al\u0131yoruz.<\/p>\n\n\n\n

ftp:\/\/ftp.freetds.org\/pub\/freetds\/stable\/freetds-patched.tar.gz<\/p>\n\n\n\n

Sunucu \u00fczerinde,<\/p>\n\n\n\n

wget ftp:\/\/ftp.freetds.org\/pub\/freetds\/stable\/freetds-patched.tar.gz
tar -zxvf freetds-patched.tar.gz
cd freetds-1.00.86\/ (Bu s\u00fcr\u00fcm build numaras\u0131 de\u011fi\u015febilir)
.\/configure --prefix=\/usr\/local\/freetds
make
make install<\/code><\/p>\n\n\n\n

Komutlar\u0131n\u0131 uyguluyoruz.<\/p>\n\n\n\n

Ard\u0131ndan, DirectAdmin Custombuild’e PHP de MSSQL lib’lerinin de derlenmesini istedi\u011fimizi belirtmeliyiz.<\/p>\n\n\n\n

cd \/usr\/local\/directadmin\/custombuild\/configure\/ap2<\/p>\n\n\n\n

\u015eeklinde ilerleyin. Burada, sunucuda hangi PHP kurulu ise (Hangi conf dosyas\u0131 kullan\u0131laca\u011f\u0131) ona g\u00f6re se\u00e7meliyiz.<\/p>\n\n\n\n

\u00d6rnek sunucuda php -v komutu ile php 5.5 kurulu oldu\u011funu tespit ediyorum, yani configure.php55 dosyas\u0131n\u0131 d\u00fczenlemeliyim.<\/p>\n\n\n\n

Dosya i\u00e7erisinde, en son sat\u0131r\u0131 di\u011fer sat\u0131rlarda g\u00f6rd\u00fc\u011f\u00fcm\u00fcz gibi \\ ekleyerek devam belirtip hemen alt\u0131na<\/p>\n\n\n\n

--with-mssql=\/usr\/local\/freetds<\/code><\/p>\n\n\n\n

\u015eeklinde ekliyoruz.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Ard\u0131ndan,<\/p>\n\n\n\n

cd \/usr\/local\/directadmin\/custombuild
.\/build clean
.\/build php d<\/code><\/p>\n\n\n\n

Komutlar\u0131n\u0131 kullan\u0131yoruz.<\/p>\n\n\n\n

\u0130\u015flem bu kadar!<\/p>\n\n\n\n

phpinfo \u00fczerinde yahut SSH \u00fczerinde;<\/p>\n\n\n\n

php -m|grep mssql<\/code><\/p>\n\n\n\n

Komutu ile kurulumu teyid edebilirsiniz.<\/p>\n\n\n\n

\u0130yi \u00e7al\u0131\u015fmalar dilerim.<\/p>\n","protected":false},"excerpt":{"rendered":"

Selamlar arkada\u015flar, DirectAdmin’in derledi\u011fi PHP, default hali ile mssql veritabanlar\u0131na ba\u011flanmamaktad\u0131r. Bunun i\u00e7in freetds kurulmal\u0131. Siteden Stable Release’in URL sini al\u0131yoruz. ftp:\/\/ftp.freetds.org\/pub\/freetds\/stable\/freetds-patched.tar.gz Sunucu \u00fczerinde, wget ftp:\/\/ftp.freetds.org\/pub\/freetds\/stable\/freetds-patched.tar.gztar -zxvf freetds-patched.tar.gzcd freetds-1.00.86\/ (Bu s\u00fcr\u00fcm build numaras\u0131 de\u011fi\u015febilir).\/configure –prefix=\/usr\/local\/freetdsmakemake install Komutlar\u0131n\u0131 uyguluyoruz. Ard\u0131ndan, DirectAdmin Custombuild’e PHP de MSSQL lib’lerinin de derlenmesini istedi\u011fimizi belirtmeliyiz. cd \/usr\/local\/directadmin\/custombuild\/configure\/ap2 \u015eeklinde ilerleyin. Burada, sunucuda […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-237","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/posts\/237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/comments?post=237"}],"version-history":[{"count":0,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/posts\/237\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/media?parent=237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/categories?post=237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.buraksuatgorgun.com.tr\/index.php\/wp-json\/wp\/v2\/tags?post=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}