{"id":169,"date":"2018-05-31T13:49:28","date_gmt":"2018-05-31T05:49:28","guid":{"rendered":"http:\/\/www.leohe.net.cn\/?p=169"},"modified":"2023-12-21T20:23:49","modified_gmt":"2023-12-21T12:23:49","slug":"freebsd-nginx-mysql-php-fpm","status":"publish","type":"post","link":"https:\/\/china-abc.leohe.net.cn\/?p=169","title":{"rendered":"freebsd nginx mysql php-fpm"},"content":{"rendered":"<h2>pkg \u6e90\u66f4\u65b0:<\/h2>\n<p>mkdir -p \/usr\/local\/etc\/pkg\/repos<\/p>\n<p>vim \/usr\/local\/etc\/pkg\/repos\/FreeBSD.conf<\/p>\n<p><span class=\"hljs-meta\"> #<\/span><span class=\"bash\"> content of FreeBSD.conf<\/span><\/p>\n<p>FreeBSD: { url: \"pkg+http:\/\/mirrors.ustc.edu.cn\/freebsd-pkg\/${ABI}\/quarterly\", }<\/p>\n<p>\u8fd0\u884c\u00a0<code class=\"docutils literal notranslate\"><span class=\"pre\">pkg<\/span>\u00a0<span class=\"pre\">update<\/span>\u00a0<span class=\"pre\">-f<\/span><\/code>\u00a0\u66f4\u65b0\u7d22\u5f15\u3002<\/p>\n<h2 id=\"step-ndash-install-nginx-web-server\">\u5b89\u88c5Nginx Web\u670d\u52a1\u5668<\/h2>\n<p>ls \/usr\/ports\/www\/ | grep nginx<\/p>\n<p>pkg search -o nginx<\/p>\n<p>pkg install nginx<\/p>\n<p>sysrc nginx_enable=yes<\/p>\n<p>service nginx start<\/p>\n<p>sockstat -4 -6 | grep nginx<\/p>\n<p>\u6709nginx\u8fdb\u7a0b \u5219\u6210\u529f<\/p>\n<p>\u8bbf\u95ee:http:\/\/yourdomain.com<\/p>\n<p>nano \/usr\/local\/etc\/nginx\/nginx.conf<\/p>\n<h2 id=\"step-ndash-install-php-programming-language\">\u5b89\u88c5PHP\u7f16\u7a0b\u8bed\u8a00<\/h2>\n<p>ls \/usr\/ports\/lang\/ | grep php<\/p>\n<p>pkg search -o php<\/p>\n<p>pkg install php71<\/p>\n<p>#php71-mcrypt mod_php71 php71-mbstring php71-curl php71-zlib php71-gd php71-json\/\/\u770b\u60c5\u51b5\u81ea\u884c\u6dfb\u52a0<\/p>\n<p>pkg install php71-mysqli\u00a0php71-session<\/p>\n<p>cp \/usr\/local\/etc\/php-fpm.d\/www.conf{,.backup}<\/p>\n<p>nano \/usr\/local\/etc\/php-fpm.d\/www.conf<\/p>\n<p>\u6ce8\u610f\u4ee5\u4e0b\u4fe1\u606f<\/p>\n<pre class=\"prettyprint prettyprinted\"><span class=\"pln\">user <\/span><span class=\"pun\">=<\/span><span class=\"pln\"> www<\/span>\r\n<span class=\"kwd\">group<\/span> <span class=\"pun\">=<\/span><span class=\"pln\"> www\r\nsockstat -4 -6| grep php-fpm\r\n\u6709php-fpm\u8fdb\u7a0b \u5219\u6210\u529f\r\n\u914d\u7f6ephp-fpm:\r\nnano \/usr\/local\/etc\/nginx\/nginx.conf\r\n\u6dfb\u52a0\u6216\u6dfb\u52a0\u5982\u4e0b\u4fe1\u606f:\r\n<\/span><\/pre>\n<pre class=\"prettyprint prettyprinted\"><span class=\"pln\"> location <\/span><span class=\"pun\">~<\/span><span class=\"pln\"> \\.php$ <\/span><span class=\"pun\">{<\/span>\r\n<span class=\"pln\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <span style=\"color: #ff0000;\">root\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><span style=\"color: #ff0000;\"><span class=\"pun\">\/<\/span><span class=\"pln\">usr<\/span><span class=\"pun\">\/<\/span><span class=\"kwd\">local<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">www<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">nginx<\/span><span class=\"pun\">;<\/span><\/span>\r\n<span class=\"pln\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fastcgi_pass\u00a0\u00a0 <\/span><span class=\"lit\">127.0<\/span><span class=\"pun\">.<\/span><span class=\"lit\">0.1<\/span><span class=\"pun\">:<\/span><span class=\"lit\">9000<\/span><span class=\"pun\">;<\/span>\r\n<span class=\"pln\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fastcgi_index\u00a0 index<\/span><span class=\"pun\">.<\/span><span class=\"pln\">php<\/span><span class=\"pun\">;<\/span>\r\n<span class=\"pln\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <span style=\"color: #ff0000;\">fastcgi_param SCRIPT_FILENAME $request_filename<\/span><\/span><span class=\"pun\" style=\"color: #ff0000;\">;<\/span><span class=\"pln\"><span style=\"color: #ff0000;\">\u00a0\u00a0<\/span>\u00a0 <\/span>\r\n<span class=\"pln\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 include \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0fastcgi_params<\/span><span class=\"pun\">;<\/span>\r\n<span class=\"pun\">}<\/span><\/pre>\n<pre class=\"prettyprint prettyprinted\"><span class=\"pln\">ln -s \/usr\/local\/etc\/php.ini-production \/usr\/local\/etc\/php.ini\r\nsysrc php_fpm_enable=yes\r\nservice php-fpm restart\r\n<\/span><\/pre>\n<p>\u6d4b\u8bd5nginx\u914d\u7f6e\u7684\u8bed\u6cd5\u9519\u8bef\uff1a<\/p>\n<p class=\"command\">nginx \u2013t<\/p>\n<p class=\"command\">service nginx restart<\/p>\n<p>\u5c31\u8fd9\u6837\uff01 \u60a8\u5df2\u7ecf\u5728FreeBSD 11\u4e2d\u6210\u529f\u5b89\u88c5.<\/p>\n<h2>\u5b89\u88c5mysql\u6570\u636e\u5e93<\/h2>\n<p>ls \/usr\/ports\/databases\/ | grep mysql<br \/>\npkg search -o mysql<br \/>\npkg install mysql56-server mysql56-client<br \/>\nsysrc mysql_enable=YES<br \/>\nservice mysql-server restart<\/p>\n<p>\u521b\u5efa\u66f4\u65b0\u7528\u6237:<br \/>\ngrant all privileges on *.* to metin@'%' identified by \"1234\";<br \/>\nflush privileges;<\/p>\n<p>\u5b89\u88c5pdomysql\u6269\u5c55\u652f\u6301\uff1a<\/p>\n<p>pkg install php71-pdo_mysql<\/p>\n<p>service php-fpm restart<\/p>\n<p>\u95ee\u9898:<\/p>\n<p>nginx\u4e0bphp\u6587\u4ef6404\u4f46\u662fhtml\u6587\u4ef6\u6b63\u5e38\u8bbf\u95ee<\/p>\n<p>1. \u00a0 nginx.conf \u6587\u4ef6 \u91cc\uff0croot \u6307\u4ee4 \u548c fastcgi_param \u6307\u4ee4 \u00a0\u4e0e \u4f60\u8981\u8bbf\u95ee\u7684\u6587\u4ef6 \u7684\u8def\u5f84\u662f\u5426\u4e00\u81f4<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-170\" src=\"http:\/\/www.leohe.net.cn\/wp-content\/uploads\/2018\/05\/QQ\u56fe\u724720180531134742.png\" alt=\"\" width=\"737\" height=\"292\" srcset=\"https:\/\/china-abc.leohe.net.cn\/wp-content\/uploads\/2018\/05\/QQ\u56fe\u724720180531134742.png 737w, https:\/\/china-abc.leohe.net.cn\/wp-content\/uploads\/2018\/05\/QQ\u56fe\u724720180531134742-300x119.png 300w\" sizes=\"(max-width: 737px) 100vw, 737px\" \/><\/p>\n<p><span class=\"pln\">\/usr\/local\/www\/nginx$fastcgi_script_name<\/span><\/p>\n<p>2. \u5c31\u662f\u6743\u9650\u95ee\u9898\u3002<\/p>\n<pre class=\"prettyprint prettyprinted\"><span class=\"pln\">\u4fee\u6539 nginx php-fpm \u7684 www.conf \u00a0\u6587\u4ef6\uff0c \u67e5\u770b\u5230 php-fpm\u7684 \u6240\u5c5e\u7ec4\u548c\u6240\u5c5e\u7528\u6237 \u00a0\r\n\r\nports\u5b89\u88c5\u65b9\u5f0f\uff1a\r\n1\u3001\u8f93\u5165 cd \/usr\/ports\/databases\/mysql51-server\r\n2\u3001\u8f93\u5165 make install clean \u7b49\u5f85\u5b89\u88c5\u5b8c\u6210\u3002\r\n\u53c2\u8003url:\r\nhttps:\/\/www.howtoing.com\/install-nginx-mariadb-and-php-femp-stack-in-freebsd-11x\r\nports\u6e90\u66f4\u65b0:\r\nhttps:\/\/forums.freebsd.org\/threads\/how-to-upgrade-ports-and-all-apps.15799\/\r\n\r\n\r\n\r\n\r\n\u62a5\u9519\u5904\u7406:\r\n<\/span><\/pre>\n<pre><code>==&gt; lf-elf.so.1: Shared object \"libssl.so.8\" not found required by \"pkg\".\r\n<\/code><\/pre>\n<pre><code># pkg-static install -f pkg\r\n<\/code><\/pre>\n<pre><code># pkg-static bootstrap -f\r\n<\/code><\/pre>\n<pre><code># pkg update\r\n<\/code>\r\n\u5fc5\u6740:<\/pre>\n<pre class=\"bz_comment_text\">'pkg bootstrap -f' worked for me\r\nthen 'pkg update|upgrade'<\/pre>\n<pre class=\"prettyprint prettyprinted\"><span class=\"pln\">\u00a0<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>pkg \u6e90\u66f4\u65b0: mkdir -p \/usr\/local\/etc\/pkg\/repos vim \/usr\/loc [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,12,5],"tags":[],"_links":{"self":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts\/169"}],"collection":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=169"}],"version-history":[{"count":11,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts\/169\/revisions"}],"predecessor-version":[{"id":636,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts\/169\/revisions\/636"}],"wp:attachment":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}