{"id":643,"title":"crmeb\u914d\u7f6e\u53caredis,mysql,\u5ba2\u670d\u5404\u79cd\u95ee\u9898\u5904\u7406","good":0,"bad":0,"hit":1053,"created_at":"2024-06-13 21:37:18","content":"

\u5b9d\u5854\u9762\u677f\u5b89\u88c5\uff1a<\/span><\/p>

yum install -y wget && wget -O install.sh https:\/\/download.bt.cn\/install\/install_6.0.sh && sh install.sh ed8484bec<\/span><\/p>

<\/span><\/p>

\u4fee\u6539host\u6587\u4ef6\uff1aC:\\Windows\\System32\\drivers\\etc\\hosts\uff0c\u914d\u7f6e\u4e00\u4e2a\u57df\u540d<\/span><\/p>

192.168.1.100 www.xxx.local<\/span><\/p>

<\/span><\/p>

\u9700\u8981\u5b89\u88c5\u7684\u8f6f\u4ef6\u53ca\u914d\u7f6e<\/span><\/p>

nginx-1.22.1<\/span><\/p>

mysql5.7<\/span><\/p>

php7.3-7.4<\/span><\/p>

redis<\/span><\/p>

supervisor<\/span><\/p>

<\/span><\/p>

\u963f\u91cc\u4e91\u53ca\u5b9d\u5854\u5b89\u5168\u4e2d\u653e\u884c\u7aef\u53e3\uff0c\u6216\u5173\u95ed\u9632\u706b\u5899<\/span><\/p>

\u6dfb\u52a07\u4e2a\u7aef\u53e3\uff1a80,21,8888,888,443,3306,6379\uff0c20002,20003,20012<\/span><\/p>

<\/span><\/p>

\u6240\u5728\u670d\u52a1\u5668\u5173\u95ed\u9632\u706b\u5899<\/span><\/p>

systemctl firewalld stop<\/span><\/p>

service firewalld stop<\/span><\/p>

<\/span><\/p>

\u914d\u7f6e<\/span><\/p>

\u7f51\u7ad9-\u6dfb\u52a0\u7ad9\u70b9-\u6839\u76ee\u5f55\uff1a<\/span><\/p>

\/mnt\/hgfs\/windows_linux\/bird\/trunk\/crmeb\/<\/span><\/p>

\u70b9\u5bf9\u5e94\u7f51\u7ad9\u540e\u9762\u7684\u8bbe\u7f6e-\u7f51\u7ad9\u76ee\u5f55-\u8fd0\u884c\u76ee\u5f55\u8bbe\u4e3apublic,\u8bb0\u5f97\u70b9\u4fdd\u5b58<\/span><\/p>

\u4f2a\u9759\u6001\u9009crmeb\u6216thinkphp<\/span><\/p>

\u7f51\u7ad9\u5bf9\u5e94\u7684\u914d\u7f6e\u6587\u4ef6\u4e2d\u6dfb\u52a0\u6216\u4fee\u6539\uff08\u5982\u679c\u7aef\u53e3\u6539\u4e86\u7684\u8bdd\u4e5f\u8981\u5bf9\u5e94\u4fee\u6539)\uff0c\u505c\u6b62\u518d\u542f\u52a8nginx\u76f4\u63a5\u91cd\u542f\u6709\u53ef\u80fd\u4e0d\u751f\u6548<\/span><\/p>

    location ~ .*\\.(js|css|json)?$<\/span><\/p>

    {<\/span><\/p>

           add_header 'Access-Control-Allow-Origin' "$http_origin";<\/span><\/p>

           add_header 'Access-Control-Allow-Credentials' "true";<\/span><\/p>

           if ($request_method = "OPTIONS") {<\/span><\/p>

               add_header 'Access-Control-Max-Age' 86400;<\/span><\/p>

               add_header 'Access-Control-Allow-Methods' 'GET, POST, OPTIONS, DELETE';<\/span><\/p>

               add_header 'Access-Control-Allow-Headers' 'reqid, nid, host, x-real-ip, x-forwarded-ip, event-type, event-id, accept, content-type';<\/span><\/p>

               add_header 'Content-Length' 0;<\/span><\/p>

              add_header 'Content-Type' 'text\/plain, charset=utf-8';<\/span><\/p>

              return 204;<\/span><\/p>

          }<\/span><\/p>

        expires      12h;<\/span><\/p>

        error_log \/dev\/null;<\/span><\/p>

        access_log \/dev\/null;<\/span><\/p>

    }<\/span><\/p>

<\/span><\/p>

    location \/notice {<\/span><\/p>

        proxy_pass http:\/\/127.0.0.1:20002\/;  <\/span><\/p>

        proxy_http_version 1.1;<\/span><\/p>

        proxy_set_header Upgrade $http_upgrade;<\/span><\/p>

        proxy_set_header Connection "upgrade";<\/span><\/p>

        proxy_set_header X-real-ip $remote_addr;<\/span><\/p>

        proxy_set_header X-Forwarded-For $remote_addr;<\/span><\/p>

    }<\/span><\/p>

    location \/msg {<\/span><\/p>

        proxy_pass http:\/\/127.0.0.1:20003\/;  <\/span><\/p>

        proxy_http_version 1.1;<\/span><\/p>

        proxy_set_header Upgrade $http_upgrade;<\/span><\/p>

        proxy_set_header Connection "upgrade";<\/span><\/p>

        proxy_set_header X-real-ip $remote_addr;<\/span><\/p>

        proxy_set_header X-Forwarded-For $remote_addr;<\/span><\/p>

    }<\/span><\/p>

\u5982\u679c\u8981https\u65b9\u5f0f\u8bbf\u95ee\uff0c\u8981\u8bbe\u7f6essl\u8bc1\u4e66<\/span><\/p>

<\/span><\/p>

\u6570\u636e\u5e93<\/span><\/p>

\u6839\u636e.env\u4e2d\u7684\u914d\u7f6e\uff0c\u65b0\u5efa\u6570\u636e\u5e93\uff0c\u8bbe\u7f6e\u7528\u6237\u540d\u53ca\u5bc6\u7801<\/span><\/p>

\u4fee\u6539.env\u4e2d\u6570\u636e\u5e93\u7684ip\u5730\u5740<\/span><\/p>

\u5b9d\u5854\u4e2d\u5bf9root\u5bc6\u7801\u4fee\u6539<\/span><\/p>

\u5bfc\u5165\u6570\u636e\u8868\u6570\u636e\u5e93<\/span><\/p>

\u8f6f\u4ef6\u5546\u5e97\u4e2d\u4fee\u6539mysql\u914d\u7f6e\u6587\u4ef6<\/span><\/p>

sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION<\/span><\/p>

.env\u914d\u7f6e-\u6d4b\u8bd5\u73af\u5883\uff0c\u6ce8\u610f\u4e0d\u8981\u628a\u6ce8\u91ca\u5199\u5728\u540e\u9762\uff0c\u5982:HOSTNAME = 47.243.226.159#\u8fd9\u53f0\u670d\u52a1\u5668\u662f\u65b0\u7684<\/span><\/p>

\u5982\u679c\u65e0\u6cd5\u8fdc\u7a0b\u8fde\u63a5\uff1a<\/span><\/p>

mysql -uroot -p<\/span><\/p>

use mysql;<\/span><\/p>

grant all privileges on *.* to 'root'@"%" identified by "\u4f60\u7684\u5bc6\u7801";<\/span><\/p>

flush privileges;<\/span><\/p>

\u653e\u884c\u7aef\u53e33306<\/span><\/p>

<\/span><\/p>

<\/span><\/p>

redis\u65e0\u6cd5\u8fdc\u7a0b\u8fde\u63a5\uff1a<\/span><\/p>

1. bind 127.0.0.1\u6539\u4e3a bind 0.0.0.0<\/span><\/p>

127.0.0.1\uff1a \u4ee3\u8868\u672c\u5730\u5730\u5740\uff0c\u8bbf\u95eeredis\u670d\u52a1\u53ea\u80fd\u901a\u8fc7\u672c\u673a\u7684\u5ba2\u6237\u7aef\u8fde\u63a5\uff0c\u800c\u65e0\u6cd5\u901a\u8fc7\u8fdc\u7a0b\u8fde\u63a5<\/span><\/p>

0.0.0.0\uff1a \u63a5\u53d7\u6240\u6709\u6765\u81ea\u4e8e\u53ef\u7528\u7f51\u7edc\u63a5\u53e3\u7684\u8fde\u63a5<\/span><\/p>

2. protected-mode yes \u6539\u4e3a protected-mode no<\/span><\/p>

yes\uff1a \u4fdd\u62a4\u6a21\u5f0f\uff0c\u53ea\u5141\u8bb8\u672c\u5730\u94fe\u63a5<\/span><\/p>

no\uff1a \u4fdd\u62a4\u6a21\u5f0f\u5173\u95ed<\/span><\/p>

\u6539\u5bc6\u7801\uff08\u540e\u9762\u7684\u5bc6\u7801\u6839\u636e\u73af\u5883\u4fee\u6539)<\/span><\/p>

requirepass wenmKgO!9<\/span><\/p>

<\/span><\/p>

php<\/span><\/p>

\u5b89\u88c5\u6269\u5c55<\/span><\/p>

fileinfo<\/span><\/p>

redis<\/span><\/p>

\u5220\u9664\u7981\u7528\u51fd\u6570<\/span><\/p>

proc_open <\/span><\/p>

pcntl_signal<\/span><\/p>

pcntl_signal_dispatch<\/span><\/p>

pcntl_fork<\/span><\/p>

pcntl_wait<\/span><\/p>

pcntl_alarm<\/span><\/p>

<\/span><\/p>

php think workerman start --d<\/span><\/p>

php think timer start --d<\/span><\/p>

\u6839\u76ee\u5f55\u4e2d\u6267\u884c\u4ee5\u4e0a\uff0c<\/span><\/p>

supervisor\u4e2d\u6dfb\u52a0\u5b88\u62a4\u8fdb\u7a0b<\/span><\/p>

php think queue:listen --queue<\/span><\/p>

<\/span><\/p>

\u4ee5\u4e0b\u76ee\u5f55\u53ca\u6587\u4ef6\u8981\u5199\u5165\u6743\u9650\uff0c\u6839\u636e\u9879\u76ee\u5b9e\u9645\u60c5\u51b5\u800c\u5b9a<\/span><\/p>

chmod -R 777\u4ee5\u4e0b\u76ee\u5f55<\/span><\/p>

runtime<\/span><\/p>

runtime\/log\/UnpaidOrderCancelJob<\/span><\/p>

public\/log<\/span><\/p>

chmod 777 workerman.pid<\/span><\/p>

chmod 777 vendor\/workerman\/workerman.log<\/span><\/p>

chmod 777 unpaidCancel_test.sh<\/span><\/p>

chmod 777 weaverbird_test.sh<\/span><\/p>

<\/p>"}