{"id":3369,"date":"2011-03-24T14:00:56","date_gmt":"2011-03-24T05:00:56","guid":{"rendered":"http:\/\/raftwood.net\/blog\/?p=3369"},"modified":"2025-04-08T13:37:52","modified_gmt":"2025-04-08T04:37:52","slug":"centos-%ed%99%98%ea%b2%bd%ec%97%90%ec%84%9c-php-%ec%9e%ac%ec%bb%b4%ed%8c%8c%ec%9d%bc-%ec%97%86%ec%9d%b4-ms-sql-%ec%97%b0%eb%8f%99-%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"https:\/\/raftwood.net\/blog\/3369\/","title":{"rendered":"CentOS \ud658\uacbd\uc5d0\uc11c PHP \uc7ac\ucef4\ud30c\uc77c \uc5c6\uc774 MS-SQL \uc5f0\ub3d9 \uc124\uc815"},"content":{"rendered":"<p>\uc720\ub2c9\uc2a4\/\ub9ac\ub205\uc2a4 \uacc4\uc5f4\uc758 OS \ud658\uacbd\uc5d0\uc11c MS-SQL\uc744 \uc5f0\ub3d9\ud558\uae30 \uc704\ud574\uc11c\ub294 FreeTDS \ub77c\uc774\ube0c\ub7ec\ub9ac\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<p><strong><span style=\"color: #ff00ff;\">1. FreeTDS \uc124\uce58<\/span><\/strong><\/p>\n<p><del>CentOS\uc5d0\uc11c\ub294 \uc644\uc804 \uac04\ub2e8\ud558\uc8e0. root \uad8c\ud55c\uc73c\ub85c \uc544\ub798 \uba85\ub839\ub9cc \uc2e4\ud589\ud558\uba74 \ub05d. \/usr\/local\/freetds \ub514\ub809\ud1a0\ub9ac\uc5d0 \uc124\uce58\ub429\ub2c8\ub2e4.<\/del><\/p>\n<pre lang=\"bash\">yum install freetds  #\uc548\ub429\ub2c8\ub2e4... \u3161,.\u3161;<\/pre>\n<p><strong>2012-11-15 \uc218\uc815.\u00a0<\/strong><\/p>\n<p><strong>yum\uc73c\ub85c \u00a0\uc124\uce58\ud558\ub294 \uacbd\uc6b0 \/usr\/local\/freetds \ub514\ub809\ud1a0\ub9ac\uc5d0 \uc124\uce58\ub418\uc9c0 \uc54a\ub2e4\ub294 \uac83\uc744 \uc544\uc8fc \ub2a6\uac8c \ubc1c\uacac\ud588\uc2b5\ub2c8\ub2e4. \uc8c4\uc1a1&#8230; \uc774 \uacbd\uc6b0\ub294 yum \uc124\uce58\uac00 \uc544\ub2cc \uc18c\uc2a4 \uc124\uce58\ub97c \ud558\uc2dc\ub294 \uac8c \ub9de\uc2b5\ub2c8\ub2e4. \uad00\ub828\ud558\uc5ec \ucc38\uace0 \ub9c1\ud06c(<a href=\"http:\/\/www.phpschool.com\/gnuboard4\/bbs\/board.php?bo_table=tipntech&amp;wr_id=46108\" target=\"_blank\" class=\"external external_icon\" rel=\"nofollow\">\ud074\ub9ad<\/a>)\ub97c \ub367\ubd99\uc774\ub2c8 \ub9c1\ud06c\ud55c \uae00\uc758 3\ubc88 \ud56d\ubaa9\uc744 \ucc38\uace0\ud558\uc5ec FreeTDS\ub97c \uc124\uce58\ud55c \ud6c4\uc5d0 \uc544\ub798 \ub0b4\uc6a9\uc73c\ub85c \uc774\uc5b4\uc11c \ubcf4\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/strong><\/p>\n<p><strong><span style=\"color: #ff00ff;\">2. PHP \ubaa8\ub4c8 \uc124\uce58<\/span><\/strong><\/p>\n<p>PHP\ub97c \uc0c8\ub85c \uc124\uce58\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 configure \uba85\ub839\uc5d0\uc11c \u2013-with-mssql=\/usr\/local\/freetds \uc635\uc158\uc744 \ucd94\uac00\ud558\uace0 \ub2e4\uc2dc \ucef4\ud30c\uc77c\uc744 \ud558\uba74 \ub418\uc9c0\ub9cc, PHP\ub97c \uc7ac\uc124\uce58\ud558\uae30 \uc2eb\uc5b4\uc11c \uc774\ub7ec\ub294 \uac83\uc774\ub2c8(\uc774\uc720\ub294 \uadf8\ub0e5&#8230;) \ubaa8\ub4c8\ub9cc \ucd94\uac00\ud558\ub294 \ubc29\uc2dd\uc744 \uc124\uba85\ud569\ub2c8\ub2e4. PHP \uc18c\uc2a4\uc758 \uc704\uce58\ub098 PHP\uc758 \uae30\uc874 \uc124\uce58 \uc704\uce58\ub294 \ud658\uacbd\uc5d0 \ub530\ub77c \ub2e4\ub97c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre lang=\"bash\">cd \/usr\/local\/src\/php-5.3.3\r\ncd ext\/mssql\r\n\/usr\/local\/php\/bin\/phpize\r\n.\/configure \u2013-with-mssql=\/usr\/local\/freetds\r\nmake\r\nmake install<\/pre>\n<p>PDO(PHP Data Object) \ubaa8\ub4c8\uc740 \uaf2d \uc124\uce58\ud558\uc9c0 \uc54a\uc544\ub3c4 \ub41c\ub2e4\uace0\ub294 \ud558\ub294\ub370 \uc77c\ub2e8 \uc124\uce58\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<pre lang=\"bash\">cd \/usr\/local\/src\/php-5.3.3\r\ncd ext\/pdo_dblib\r\n\/usr\/local\/php\/bin\/phpize\r\n.\/configure \u2013-with-pdo-dblib=\/usr\/local\/freetds\r\nmake\r\nmake install<\/pre>\n<p>\uc704 \uba85\ub839\ub4e4\uc744 \uc2e4\ud589\ud558\uba74 \ub9c8\uc9c0\ub9c9\uc5d0 \ud655\uc7a5 \ubaa8\ub4c8\uc758 \uc704\uce58\uac00 \ud45c\uc2dc\ub418\ubbc0\ub85c \uc774 \uacbd\ub85c\uc5d0 \ub9de\ucdb0 php.ini \ud30c\uc77c\uc5d0 \ud574\ub2f9 \ub0b4\uc6a9\uc744 \ub123\uc73c\uba74 \ub429\ub2c8\ub2e4. \uc81c \uacbd\uc6b0\ub294 &#8216;\/usr\/local\/php\/lib\/php\/extensions\/no-debug-zts-20090626\/&#8217;\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n<pre lang=\"bash\">extension=\/usr\/local\/php\/lib\/php\/extensions\/no-debug-zts-20090626\/mssql.so\r\nextension=\/usr\/local\/php\/lib\/php\/extensions\/no-debug-zts-20090626\/pdo_dblib.so<\/pre>\n<p><strong><span style=\"color: #ff00ff;\">3. freetds.conf \ud30c\uc77c \uc124\uc815 \ubc0f PHP\uc5d0\uc11c\uc758 \uc0ac\uc6a9<\/span><\/strong><\/p>\n<p>\/usr\/local\/freetds\/etc\/freetds.conf \ud30c\uc77c\uc744 \uc785\ub9db\uc5d0 \ub9de\uac8c(!) \uc124\uc815\ud558\uace0 \uc6f9\uc11c\ubc84\ub97c \uc7ac\uad6c\ub3d9\ud55c \ud6c4, PHP\uc5d0\uc11c \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4. conf \ud30c\uc77c\uc740 \ud55c \ubc88 \ub4e4\uc5ec\ub2e4 \ubcf4\uba74 \ub300\ucda9 \uc54c \uc218 \uc788\uace0, PHP \uc0ac\uc6a9 \ubd80\ubd84\uc740 \uc81c\uac00 \uac1c\ubc1c\uc790\uac00 \uc544\ub2cc \uad00\uacc4\ub85c \ud328\uc2a4\ud569\ub2c8\ub2e4. ^^;;<\/p>\n<div class=\"announcement\">\n<p><strong><span style=\"color: #ff00ff;\">\ubcf8\ubb38\uacfc \uc0c1\uad00\uc774 \uc788\uc744 \uc218\ub3c4 \uc5c6\uc744 \uc218\ub3c4 \uc788\ub294 \ub9cc\ud654<\/span><\/strong><\/p>\n<ul>\n<li><a href=\"http:\/\/www.aladin.co.kr\/shop\/wproduct.aspx?ISBN=8925231905\" target=\"_blank\" class=\"external external_icon\" rel=\"nofollow\">\ub098\ub294\uc57c, \uc624\ud0c0\ucfe0 \uc0d0\ub7ec\ub9ac\ub9e8 : \uce60\uc804\ud314\uae30\ud3b8<\/a>\/ \uae00,\uadf8\ub9bc : \uc694\uc2dc\ud0c0\ub2c8 \/ \ub300\uc6d0\uc528\uc544\uc774\ub530, \ub531\ud788 \uc8fc\uc778\uacf5\uc774 SE\ub77c\uc11c \uc5b8\uae09\ud55c \uac83\uc740 \uc544\ub2c8\ub77c\ub2a5&#8230;<\/li>\n<\/ul>\n<\/div>\n<p style=\"text-align: center;\"><strong><span style=\"color: #3366ff;\"><span style=\"background-color: #ffffff;\"><span style=\"color: #ffffff;\"><span style=\"background-color: #3366ff;\">\uc81c \uae00\uc774 \uc720\uc6a9\ud558\uc168\ub2e4\uba74 \uc544\ub798 \uc190\uac00\ub77d \ubaa8\uc591\uc744 \uafb8\uc6b1~ \ub20c\ub7ec\uc8fc\uc138\uc694.<\/span><\/span><\/span><\/span><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\uc720\ub2c9\uc2a4\/\ub9ac\ub205\uc2a4 \uacc4\uc5f4\uc758 OS \ud658\uacbd\uc5d0\uc11c MS-SQL\uc744 \uc5f0\ub3d9\ud558\uae30 \uc704\ud574\uc11c\ub294 FreeTDS \ub77c\uc774\ube0c\ub7ec\ub9ac\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. 1. FreeTDS \uc124\uce58 CentOS\uc5d0\uc11c\ub294 \uc644\uc804 \uac04\ub2e8\ud558\uc8e0. root \uad8c\ud55c\uc73c\ub85c \uc544\ub798 \uba85\ub839\ub9cc \uc2e4\ud589\ud558\uba74 \ub05d. \/usr\/local\/freetds \ub514\ub809\ud1a0\ub9ac\uc5d0 \uc124\uce58\ub429\ub2c8\ub2e4. <a class=\"mh-excerpt-more\" href=\"https:\/\/raftwood.net\/blog\/3369\/\" title=\"CentOS \ud658\uacbd\uc5d0\uc11c PHP \uc7ac\ucef4\ud30c\uc77c \uc5c6\uc774 MS-SQL \uc5f0\ub3d9 \uc124\uc815\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[65],"tags":[108,713,712,711,456,714,715],"class_list":["post-3369","post","type-post","status-publish","format-standard","hentry","category-job-it-common","tag-centos","tag-freetds","tag-mssql","tag-php","tag-456","tag-714","tag-715"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/raftwood.net\/blog\/wp-json\/wp\/v2\/posts\/3369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/raftwood.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/raftwood.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/raftwood.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/raftwood.net\/blog\/wp-json\/wp\/v2\/comments?post=3369"}],"version-history":[{"count":1,"href":"https:\/\/raftwood.net\/blog\/wp-json\/wp\/v2\/posts\/3369\/revisions"}],"predecessor-version":[{"id":541590,"href":"https:\/\/raftwood.net\/blog\/wp-json\/wp\/v2\/posts\/3369\/revisions\/541590"}],"wp:attachment":[{"href":"https:\/\/raftwood.net\/blog\/wp-json\/wp\/v2\/media?parent=3369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/raftwood.net\/blog\/wp-json\/wp\/v2\/categories?post=3369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/raftwood.net\/blog\/wp-json\/wp\/v2\/tags?post=3369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}