{"id":34765,"date":"2023-12-31T11:12:01","date_gmt":"2023-02-19T18:49:55","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/"},"modified":"2024-05-04T16:07:39","modified_gmt":"2024-05-04T08:07:39","slug":"%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/","title":{"rendered":"\u5728DigitalOcean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic"},"content":{"rendered":"<h1>\u5728DigitalOcean\u4e0a\u5b89\u88c5Mautic\u3002<\/h1>\n<p>\u867d\u7136\u542c\u8bf4\u65e5\u672c\u6ca1\u6709\u5ec9\u4ef7\u7684\u6570\u636e\u4e2d\u5fc3\uff0c\u4f46\u7531\u4e8e\u60f3\u5c1d\u8bd5\u4e00\u4e0bDigitalOcean\u8fd9\u4e2a\u6211\u65e9\u5c31\u542c\u8bf4\u8fc7\u7684\u5e73\u53f0\uff0c\u53c8\u60f3\u5c1d\u8bd5\u4e00\u4e0bmautic\u8fd9\u4e2a\u6211\u4e00\u76f4\u60f3\u7528\u7684\u5de5\u5177\uff0c\u6240\u4ee5\u6211\u4e00\u4e3e\u4e24\u5f97\u3002<\/p>\n<h2>\u5173\u4e8eDigitalOcean<\/h2>\n<p>\u53ef\u4ee5\u4f7f\u7528Droplet\u4f5c\u4e3a\u865a\u62df\u670d\u52a1\u5668\u7684\u5355\u4f4d\uff0c\u6700\u4fbf\u5b9c\u7684Droplet\u914d\u7f6e\uff08512MB\u5185\u5b58\u300120GB SSD\u786c\u76d8\uff09\u4ef7\u683c\u7ea6\u4e3a5\u7f8e\u5143\uff0c\u652f\u6301\u572828\u5929\u5185\u4f7f\u7528\u3002<br \/>\n\u867d\u7136\u65e0\u6cd5\u4f7f\u7528\u65e5\u672c\u7684\u6570\u636e\u4e2d\u5fc3\u6709\u4e9b\u9057\u61be\uff0c\u4f46\u7531\u4e8e\u53ef\u4ee5\u4f7f\u7528\u65b0\u52a0\u5761\u7684\u6570\u636e\u4e2d\u5fc3\uff0c\u5bf9\u4e8e\u9a8c\u8bc1\u6765\u8bf4\u5df2\u7ecf\u8db3\u591f\u4e86\uff0c\u6240\u4ee5\u51b3\u5b9a\u4f7f\u7528\u3002<\/p>\n<p>DigitalOcean\u5728\u6b64\u94fe\u63a5\u2192https:\/\/www.digitalocean.com\/<\/p>\n<p>\u53ea\u9700\u8981\u63d0\u4f9b\u7535\u5b50\u90ae\u4ef6\u3001\u5bc6\u7801\u3001\u5730\u5740\u548c\u652f\u4ed8\u4fe1\u606f\u8fdb\u884c\u6ce8\u518c\uff0c\u53ea\u89815\u5206\u949f\u4e0d\u5230\u3002<\/p>\n<h2>\u5173\u4e8eMautic<\/h2>\n<p>\u8fd9\u662f\u4e00\u4e2a\u5f00\u6e90\u7684\u8425\u9500\u81ea\u52a8\u5316\uff08MA\uff09\u5de5\u5177\u3002\u7531\u4e8e\u6211\u7ecf\u5e38\u542c\u5230 MA \u5de5\u5177\u8fd9\u4e2a\u8bcd\uff0c\u6211\u9996\u5148\u60f3\u77e5\u9053\u5b83\u7a76\u7adf\u662f\u4ec0\u4e48\u3002\u867d\u7136\u53ef\u4ee5\u901a\u8fc7\u4e66\u7c4d\u7b49\u9014\u5f84\u6765\u5b66\u4e60\uff0c\u4f46\u6211\u5076\u7136\u95f4\u77e5\u9053\u4e86\u8fd9\u4e2a\u5f00\u6e90\u7684 MA \u5de5\u5177\uff0c\u540c\u65f6\u4e5f\u60f3\u8bd5\u8bd5\u4e0a\u8ff0\u7684 DigitalOcean\uff0c\u4e8e\u662f\u6211\u51c6\u5907\u4e86\u4e00\u4e2a Droplet\uff0c\u5c06 mautic \u5b89\u88c5\u5728\u5176\u4e2d\uff0c\u4ee5\u8bd5\u9a8c\u6027\u5730\u4f7f\u7528\u3002<\/p>\n<p>Mautic\u53ef\u5728\u6b64\u5904\u627e\u5230\u2192https:\/\/www.mautic.org\/<\/p>\n<h2>\u8bf7\u63d0\u4f9b\u66f4\u591a\u4e0a\u4e0b\u6587\u4fe1\u606f\u3002<\/h2>\n<p>\u6211\u5df2\u7ecf\u914d\u7f6e\u597d\u4e86Nginx\u3001PHP7\u548cMySQL\u7684\u73af\u5883\u3002<\/p>\n<h3>\u521b\u5efa Droplet<\/h3>\n<p>\u64cd\u4f5c\u7cfb\u7edf\u4e3aCentOS6.9\uff0864\u4f4d\uff09\uff0c\u6700\u4f4e\u914d\u7f6e\u4e3a5\u7f8e\u5143\uff0c\u5728\u65b0\u52a0\u5761\u7684\u6570\u636e\u4e2d\u5fc3\uff0c\u52fe\u9009\u79c1\u4eba\u7f51\u7edc\uff08\u5b9e\u9645\u4e0a\u8fd9\u662f\u4e0d\u5fc5\u8981\u7684\uff09\uff0c\u6ce8\u518c\u4e86SSH\u516c\u94a5\uff0c\u5e76\u8bbe\u7f6e\u4e86\u4e3b\u673a\u540d\u521b\u5efa\u3002\u5927\u7ea61\u5206\u949f\u5b8c\u6210\uff0c\u53ef\u4ee5\u901a\u8fc7\u5bc6\u94a5\u8ba4\u8bc1\u767b\u5f55\u865a\u62df\u670d\u52a1\u5668\u3002<\/p>\n<h3>\u521b\u5efaiptables<\/h3>\n<p>\u5c3d\u7ba1\u662f\u4e3a\u4e86\u9a8c\u8bc1\uff0c\u4f46\u4e3a\u786e\u4fdd\u6700\u4f4e\u9650\u5ea6\u7684\u5b89\u5168\u6027\uff0c\u6211\u5728iptables\u4e0a\u8bbe\u7f6e\u4e86\u7b80\u5355\u7684\u9632\u706b\u5899\u914d\u7f6e\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">#<\/span><span class=\"o\">!<\/span>\/bin\/sh\r\n<span class=\"go\">\r\niptables -F INPUT\r\niptables -F OUTPUT\r\niptables -F FORWARD\r\n\r\niptables -P INPUT DROP\r\niptables -P OUTPUT ACCEPT\r\niptables -P FORWARD DROP\r\n\r\niptables -A INPUT -i lo -j ACCEPT\r\niptables -A OUTPUT -o lo -j ACCEPT\r\n\r\niptables -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT\r\n\r\niptables -A INPUT -p tcp --dport 22 -j ACCEPT\r\niptables -A INPUT -p tcp --dport 80 -j ACCEPT\r\niptables -A INPUT -p tcp --dport 443 -j ACCEPT\r\n<\/span><\/code><\/pre>\n<p>\u5728\u4e0a\u8ff0\u8bbe\u7f6e\u4e2d\uff0c\u9664\u4e86ssh\u548chttp\u4e4b\u5916\u7684\u901a\u4fe1\u90fd\u4e0d\u88ab\u5141\u8bb8\u3002\u4f46\u662f\uff0c\u5bf9\u4e8e\u6765\u81ea\u670d\u52a1\u5668\u7684\u54cd\u5e94\uff0c\u6211\u4eec\u8fdb\u884c\u4e86\u63a5\u53d7\u3002\u901a\u8fc7\u6267\u884c\u4e0a\u8ff0shell\u811a\u672c\uff0c\u6211\u4eec\u5b9e\u73b0\u4e86\u4e00\u4e2a\u7b80\u6613\u9632\u706b\u5899\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> \/bin\/sh \/root\/tools\/iptables.sh\r\n<\/code><\/pre>\n<p>\u53e6\u5916\uff0c\u5728\u91cd\u65b0\u542f\u52a8\u65f6\uff0c\u8bf7\u5728\/etc\/rc.local\u6587\u4ef6\u4e2d\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"go\">\/bin\/sh \/root\/tools\/iptables.sh\r\n<\/span><\/code><\/pre>\n<h3>\u8bbe\u7f6e\u65f6\u95f4<\/h3>\n<h4>\u65f6\u533a\u7684\u53d8\u66f4<\/h4>\n<p>\u5c06\u65f6\u533a\u66f4\u6539\u4e3a\u65e5\u672c\u65f6\u95f4\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> <span class=\"nb\">cp<\/span> \/usr\/share\/zoneinfo\/Japan \/etc\/localtime\r\n<\/code><\/pre>\n<h4>\u4e0eNTP\u670d\u52a1\u5668\u7684\u540c\u6b65<\/h4>\n<p>\u5b89\u88c5ntpd\uff0c\u5e76\u786e\u4fdd\u4ee5SLEW\u6a21\u5f0f\u51c6\u786e\u5730\u4fdd\u6301\u8f6f\u4ef6\u65f6\u949f\u3002<\/p>\n<h5>\u5b89\u88c5ntpd\u3002<\/h5>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> yum <span class=\"nb\">install <\/span>ntp\r\n<span class=\"gp\">$<\/span> chkconfig ntpd on\r\n<\/code><\/pre>\n<h4>ntpd\u7684\u914d\u7f6e<\/h4>\n<p>\u628antp.conf\u6587\u4ef6\u6309\u7167\u4ee5\u4e0b\u7684\u65b9\u5f0f\u8fdb\u884c\u7f16\u5199\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">#<\/span> For more information about this file, see the man pages\r\n<span class=\"gp\">#<\/span> ntp.conf<span class=\"o\">(<\/span>5<span class=\"o\">)<\/span>, ntp_acc<span class=\"o\">(<\/span>5<span class=\"o\">)<\/span>, ntp_auth<span class=\"o\">(<\/span>5<span class=\"o\">)<\/span>, ntp_clock<span class=\"o\">(<\/span>5<span class=\"o\">)<\/span>, ntp_misc<span class=\"o\">(<\/span>5<span class=\"o\">)<\/span>, ntp_mon<span class=\"o\">(<\/span>5<span class=\"o\">)<\/span><span class=\"nb\">.<\/span>\r\n<span class=\"go\">\r\ndriftfile \/var\/lib\/ntp\/drift\r\n\r\n<\/span><span class=\"gp\">#<\/span> Permit <span class=\"nb\">time <\/span>synchronization with our <span class=\"nb\">time source<\/span>, but <span class=\"k\">do <\/span>not\r\n<span class=\"gp\">#<\/span> permit the <span class=\"nb\">source <\/span>to query or modify the service on this system.\r\n<span class=\"go\">restrict default kod nomodify notrap nopeer noquery\r\nrestrict -6 default kod nomodify notrap nopeer noquery\r\n\r\n<\/span><span class=\"gp\">#<\/span> Permit all access over the loopback interface.  This could\r\n<span class=\"gp\">#<\/span> be tightened as well, but to <span class=\"k\">do <\/span>so would effect some of\r\n<span class=\"gp\">#<\/span> the administrative functions.\r\n<span class=\"go\">restrict 127.0.0.1\r\nrestrict -6 ::1\r\n\r\n<\/span><span class=\"gp\">#<\/span> Hosts on <span class=\"nb\">local <\/span>network are less restricted.\r\n<span class=\"gp\">#<\/span>restrict 192.168.1.0 mask 255.255.255.0 nomodify notrap\r\n\r\n<span class=\"gp\">#<\/span> Use public servers from the pool.ntp.org project.\r\n<span class=\"gp\">#<\/span> Please consider joining the pool <span class=\"o\">(<\/span>http:\/\/www.pool.ntp.org\/join.html<span class=\"o\">)<\/span><span class=\"nb\">.<\/span>\r\n<span class=\"gp\">#<\/span>server 0.centos.pool.ntp.org iburst\r\n<span class=\"gp\">#<\/span>server 1.centos.pool.ntp.org iburst\r\n<span class=\"gp\">#<\/span>server 2.centos.pool.ntp.org iburst\r\n<span class=\"gp\">#<\/span>server 3.centos.pool.ntp.org iburst\r\n<span class=\"go\">\r\nserver -4 ntp.nict.jp\r\nserver -4 ntp1.jst.mfeed.ad.jp\r\nserver -4 ntp2.jst.mfeed.ad.jp\r\nserver -4 ntp3.jst.mfeed.ad.jp\r\n\r\n<\/span><span class=\"gp\">#<\/span>broadcast 192.168.1.255 autokey    <span class=\"c\"># broadcast server<\/span>\r\n<span class=\"gp\">#<\/span>broadcastclient            <span class=\"c\"># broadcast client<\/span>\r\n<span class=\"gp\">#<\/span>broadcast 224.0.1.1 autokey        <span class=\"c\"># multicast server<\/span>\r\n<span class=\"gp\">#<\/span>multicastclient 224.0.1.1      <span class=\"c\"># multicast client<\/span>\r\n<span class=\"gp\">#<\/span>manycastserver 239.255.254.254     <span class=\"c\"># manycast server<\/span>\r\n<span class=\"gp\">#<\/span>manycastclient 239.255.254.254 autokey <span class=\"c\"># manycast client<\/span>\r\n\r\n<span class=\"gp\">#<\/span> Enable public key cryptography.\r\n<span class=\"gp\">#<\/span>crypto\r\n<span class=\"go\">\r\nincludefile \/etc\/ntp\/crypto\/pw\r\n\r\n<\/span><span class=\"gp\">#<\/span> Key file containing the keys and key identifiers used when operating\r\n<span class=\"gp\">#<\/span> with symmetric key cryptography.\r\n<span class=\"go\">keys \/etc\/ntp\/keys\r\n\r\n<\/span><span class=\"gp\">#<\/span> Specify the key identifiers which are trusted.\r\n<span class=\"gp\">#<\/span>trustedkey 4 8 42\r\n\r\n<span class=\"gp\">#<\/span> Specify the key identifier to use with the ntpdc utility.\r\n<span class=\"gp\">#<\/span>requestkey 8\r\n\r\n<span class=\"gp\">#<\/span> Specify the key identifier to use with the ntpq utility.\r\n<span class=\"gp\">#<\/span>controlkey 8\r\n\r\n<span class=\"gp\">#<\/span> Enable writing of statistics records.\r\n<span class=\"gp\">#<\/span>statistics clockstats cryptostats loopstats peerstats\r\n<\/code><\/pre>\n<h4>\u542f\u52a8ntpd<\/h4>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> \/etc\/init.d\/ntpd start\r\n<\/code><\/pre>\n<h4>\u5c06\u5176\u53cd\u6620\u5230\u786c\u4ef6\u65f6\u949f\u4e2d<\/h4>\n<p>\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> hwclock <span class=\"nt\">-w<\/span> <span class=\"o\">&gt;<\/span> \/dev\/null 2&gt;&amp;1\r\n<\/code><\/pre>\n<p>\u5728Cron\u4e2d\uff0c\u6dfb\u52a0\u5e76\u8fdb\u884c\u4e0b\u8ff0\u8bbe\u7f6e\u975e\u5e38\u7b80\u4fbf\u3002<br \/>\n\u5728\u4e0b\u8ff0\u793a\u4f8b\u4e2d\uff0c\u6211\u4eec\u5c06\u540c\u6b65\u8bbe\u7f6e\u4e3a\u6bcf\u5468\u4e00\u4e0a\u53483\u70b9\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">0 3 * * 1 root \/sbin\/hwclock -w &gt;<\/span> \/dev\/null 2&gt;&amp;1\r\n<\/code><\/pre>\n<h3>\u521b\u5efa\u4ea4\u6362\u7a7a\u95f4<\/h3>\n<p>\u521b\u5efa droplet \u540e\uff0cswap \u533a\u57df\u53d8\u4e3a\u4e86 0\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> free\r\n<span class=\"go\">             total       used       free     shared    buffers     cached\r\nMem:        501968     493816       8152      53488       3736      74344\r\n-\/+ buffers\/cache:     415736      86232\r\nSwap:            0          0          0\r\n<\/span><\/code><\/pre>\n<p>\u5982\u679c\u5728\u6ca1\u6709swap\u7a7a\u95f4\u7684\u60c5\u51b5\u4e0b\u8fdb\u884c\u8fd0\u8425\uff0cMySQL\u4f1a\u9891\u7e41\u51fa\u73b0\u9519\u8bef\uff0c\u5bfc\u81f4\u6570\u636e\u5e93\u5d29\u6e83\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">017-06-23T16:52:56.670021Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed;<\/span> errno 12\r\n<span class=\"go\">2017-06-23T16:52:56.670092Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool\r\n2017-06-23T16:52:56.670117Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error\r\n2017-06-23T16:52:56.670145Z 0 [ERROR] Plugin 'InnoDB' init function returned error.\r\n2017-06-23T16:52:56.670161Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.\r\n2017-06-23T16:52:56.670175Z 0 [ERROR] Failed to initialize plugins.\r\n2017-06-23T16:52:56.670196Z 0 [ERROR] Aborting\r\n<\/span><\/code><\/pre>\n<h4>\u4f7f\u7528dd\u547d\u4ee4\u521b\u5efa\u7528\u4e8e\u4ea4\u6362\u7684\u6587\u4ef6\u3002<\/h4>\n<p>\u6211\u5728\u8fd9\u91cc\u521b\u5efa\u4e86\u4e00\u4e2a1GB\u7684\u4ea4\u6362\u6587\u4ef6\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> <span class=\"nb\">dd <\/span><span class=\"k\">if<\/span><span class=\"o\">=<\/span>\/dev\/zero <span class=\"nv\">of<\/span><span class=\"o\">=<\/span>\/swapfile <span class=\"nv\">bs<\/span><span class=\"o\">=<\/span>1M <span class=\"nv\">count<\/span><span class=\"o\">=<\/span>1024\r\n<span class=\"go\">\r\n1024+0 records in\r\n1024+0 records out\r\n1073741824 bytes (1.1 GB) copied, 2.83618 s, 379 MB\/s\r\n<\/span><\/code><\/pre>\n<h4>\u521b\u5efa\u4e00\u4e2a\u4ea4\u6362\u9886\u57df<\/h4>\n<pre class=\"post-pre\"><code><span class=\"go\"> mkswap \/swapfile\r\nmkswap: \/swapfile: warning: don't erase bootbits sectors\r\n        on whole disk. Use -f to force.\r\nSetting up swapspace version 1, size = 1048572 KiB\r\nno label, UUID=4cc2fb29-7e0d-4342-b888-d131c248febe\r\n<\/span><\/code><\/pre>\n<h4>\u6fc0\u6d3b\u4ea4\u6362\u9886\u57df<\/h4>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> swapon \/swapfile\r\n<\/code><\/pre>\n<p>\u901a\u8fc7\u542f\u7528\u4ea4\u6362\u9886\u57df\uff0c\u53ef\u4ee5\u786e\u8ba4\u4ee5\u4e0b\u4ea4\u6362\u9886\u57df\u5df2\u51c6\u5907\u5c31\u7eea\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> free\r\n<span class=\"go\">             total       used       free     shared    buffers     cached\r\nMem:        501968     495760       6208      53488       2728      76548\r\n-\/+ buffers\/cache:     416484      85484\r\nSwap:      1048572          0    1048572\r\n<\/span><\/code><\/pre>\n<h4>\u5f53\u4f60\u91cd\u65b0\u542f\u52a8\u65f6\uff0c\u4ecd\u7136\u8981\u786e\u4fdd\u6fc0\u6d3bswap\u5206\u533a\u3002<\/h4>\n<p>\u7f16\u8f91\/etc\/fstab\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"go\">UUID=3fda56ee-2072-4762-b2d8-51a806890759 \/                       ext4    defaults        1 1\r\ntmpfs                   \/dev\/shm                tmpfs   defaults        0 0\r\ndevpts                  \/dev\/pts                devpts  gid=5,mode=620  0 0\r\nsysfs                   \/sys                    sysfs   defaults        0 0\r\nproc                    \/proc                   proc    defaults        0 0\r\n\/swapfile               swap                    swap    defaults        0 0\r\n<\/span><\/code><\/pre>\n<h3>\u5b89\u88c5MySQL5.7<\/h3>\n<h4>\u5b89\u88c5<\/h4>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> rpm <span class=\"nt\">--import<\/span> http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/checking-gpg-signature.html\r\n<span class=\"gp\">$<\/span> rpm <span class=\"nt\">-ihv<\/span> http:\/\/dev.mysql.com\/get\/mysql57-community-release-el6-7.noarch.rpm\r\n<span class=\"gp\">$<\/span> yum <span class=\"nt\">--disablerepo<\/span><span class=\"o\">=<\/span><span class=\"se\">\\*<\/span> <span class=\"nt\">--enablerepo<\/span><span class=\"o\">=<\/span><span class=\"s1\">'mysql57-community*'<\/span> list available\r\n<span class=\"gp\">$<\/span> yum <span class=\"nt\">--enablerepo<\/span><span class=\"o\">=<\/span><span class=\"s1\">'mysql57-community*'<\/span> <span class=\"nb\">install<\/span> <span class=\"nt\">-y<\/span> mysql-community-server\r\n<\/code><\/pre>\n<h4>\u8bbe\u5b9a\u6587\u4ef6<\/h4>\n<pre class=\"post-pre\"><code><span class=\"go\">[mysqld]\r\ncharacter-set-server=utf8mb4\r\ncollation-server=utf8mb4_general_ci\r\ndefault-storage-engine=innodb\r\ninnodb_large_prefix\r\n\r\nsql_mode=ONLY_FULL_GROUP_BY,NO_AUTO_CREATE_USER,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION\r\n\r\ndatadir=\/var\/lib\/mysql\r\nsocket=\/var\/lib\/mysql\/mysql.sock\r\n\r\nsymbolic-links=0\r\n\r\nlog-error=\/var\/log\/mysqld.log\r\npid-file=\/var\/run\/mysqld\/mysqld.pid\r\n\r\n[client]\r\ndefault-character-set=utf8mb4\r\n\r\n[mysql]\r\ndefault-character-set=utf8mb4\r\n<\/span><\/code><\/pre>\n<h4>\u542f\u52a8<\/h4>\n<p>\u542f\u52a8MySQL 5.7\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> \/etc\/init.d\/mysqld start\r\n<\/code><\/pre>\n<h4>\u8bf7\u786e\u8ba4root\u7528\u6237\u7684\u521d\u59cb\u5bc6\u7801\u3002<\/h4>\n<p>\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\uff0c\u786e\u8ba4\u521d\u59cb\u5bc6\u7801\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> <span class=\"nb\">cat<\/span> \/var\/log\/mysqld.log | <span class=\"nb\">grep<\/span> <span class=\"s1\">'password is generated'<\/span>\r\n<\/code><\/pre>\n<h4>\u66f4\u6539\u6839\u76ee\u5f55\u7684\u5bc6\u7801<\/h4>\n<p>\u4f7f\u7528\u786e\u8ba4\u8fc7\u7684\u521d\u59cb\u5bc6\u7801\u767b\u5f55MySQL5.7\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">mysql&gt;<\/span> ALTER USER <span class=\"s1\">'root'<\/span>@<span class=\"s1\">'localhost'<\/span> IDENTIFIED BY <span class=\"s1\">'LxAeT$#11op'<\/span><span class=\"p\">;<\/span>\r\n<\/code><\/pre>\n<p>\u53e6\u5916\uff0c\u5728 Mautic \u4e2d\u521b\u5efa\u6570\u636e\u5e93\u3002<\/p>\n<p>shell-session<br \/>\nmysql&gt; \u521b\u5efa\u6570\u636e\u5e93 mautic;<\/p>\n<h3>MTA\u68c0\u67e5<\/h3>\n<p>\u5b89\u88c5mailx\uff0c\u5e76\u5c1d\u8bd5\u53d1\u9001\u6d4b\u8bd5\u90ae\u4ef6\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> yum <span class=\"nb\">install<\/span> <span class=\"nt\">-y<\/span> mailx\r\n<span class=\"gp\">$<\/span> alternatives <span class=\"nt\">--display<\/span> mta\r\n<span class=\"gp\">$<\/span> <span class=\"nb\">echo<\/span> <span class=\"s2\">\"test\"<\/span> | mail <span class=\"nt\">-s<\/span> <span class=\"s2\">\"subject\"<\/span> myname@mydomain.com\r\n<\/code><\/pre>\n<h3>\u5b89\u88c5Nginx<\/h3>\n<h4>\u5b89\u88c5<\/h4>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> rpm <span class=\"nt\">-ivh<\/span> http:\/\/nginx.org\/packages\/centos\/6\/noarch\/RPMS\/nginx-release-centos-6-0.el6.ngx.noarch.rpm\r\n<span class=\"gp\">$<\/span> yum <span class=\"nt\">-y<\/span> <span class=\"nb\">install <\/span>nginx\r\n<\/code><\/pre>\n<h4>\u914d\u7f6e\u6587\u4ef6<\/h4>\n<pre class=\"post-pre\"><code><span class=\"gp\">user  nginx;<\/span>\r\n<span class=\"gp\">worker_processes  1;<\/span>\r\n\r\n\r\n<span class=\"gp\">pid        \/var\/run\/nginx.pid;<\/span>\r\n<span class=\"go\">\r\nevents {\r\n<\/span><span class=\"gp\">    worker_connections  1024;<\/span>\r\n<span class=\"go\">}\r\n\r\n\r\nhttp {\r\n<\/span><span class=\"gp\">    include       \/etc\/nginx\/mime.types;<\/span>\r\n<span class=\"gp\">    default_type  application\/octet-stream;<\/span>\r\n\r\n<span class=\"gp\">    log_format  main  '$<\/span>remote_addr - <span class=\"nv\">$remote_user<\/span> <span class=\"o\">[<\/span><span class=\"nv\">$time_local<\/span><span class=\"o\">]<\/span> <span class=\"s2\">\"<\/span><span class=\"nv\">$request<\/span><span class=\"s2\">\"<\/span> <span class=\"s1\">'\r\n<\/span><span class=\"gp\">                      '$<\/span><span class=\"s1\">status $body_bytes_sent \"$http_referer\" '<\/span>\r\n<span class=\"gp\">                      '\"$<\/span>http_user_agent<span class=\"s2\">\" \"<\/span><span class=\"nv\">$http_x_forwarded_for<\/span><span class=\"s2\">\"';\r\n<\/span>\r\n<span class=\"gp\">    access_log  \/var\/log\/nginx\/access.log  main;<\/span>\r\n<span class=\"gp\">    error_log  \/var\/log\/nginx\/error.log warn;<\/span>\r\n\r\n<span class=\"gp\">    sendfile        off;<\/span>\r\n<span class=\"gp\">    #<\/span>tcp_nopush     on<span class=\"p\">;<\/span>\r\n\r\n<span class=\"gp\">    keepalive_timeout  65;<\/span>\r\n\r\n<span class=\"gp\">    fastcgi_read_timeout 180;<\/span>\r\n\r\n<span class=\"gp\">    #<\/span><span class=\"nb\">gzip  <\/span>on<span class=\"p\">;<\/span>\r\n\r\n<span class=\"gp\">    include \/etc\/nginx\/conf.d\/*.conf;<\/span>\r\n<span class=\"go\">}\r\n<\/span><\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"go\">server {\r\n<\/span><span class=\"gp\">    listen 80 default;<\/span>\r\n<span class=\"gp\">    server_name _;<\/span>\r\n<span class=\"gp\">    root \/var\/www\/html\/mautic;<\/span>\r\n<span class=\"gp\">    index index.php index.html index.htm;<\/span>\r\n<span class=\"gp\">    charset utf-8;<\/span>\r\n\r\n<span class=\"gp\">    access_log \/var\/log\/nginx\/default.access.log;<\/span>\r\n<span class=\"gp\">    error_log \/var\/log\/nginx\/default.error.log;<\/span>\r\n<span class=\"go\">\r\n    location \/ {\r\n<\/span><span class=\"gp\">        try_files $<\/span>uri <span class=\"nv\">$uri<\/span>\/ \/index.php<span class=\"nv\">$is_args$args<\/span><span class=\"p\">;<\/span>\r\n<span class=\"go\">    }\r\n\r\n<\/span><span class=\"gp\">    sendfile off;<\/span>\r\n\r\n<span class=\"gp\">    location ~ \\.php$<\/span> <span class=\"o\">{<\/span>\r\n<span class=\"gp\">        fastcgi_split_path_info ^(.+\\.php)(\/.+)$<\/span><span class=\"p\">;<\/span>\r\n<span class=\"gp\">        fastcgi_pass unix:\/var\/run\/php-fpm\/php-fpm.sock;<\/span>\r\n<span class=\"gp\">        fastcgi_intercept_errors on;<\/span>\r\n<span class=\"gp\">        fastcgi_index index.php;<\/span>\r\n<span class=\"gp\">        fastcgi_param SCRIPT_FILENAME  $<\/span>document_root<span class=\"nv\">$fastcgi_script_name<\/span><span class=\"p\">;<\/span>\r\n<span class=\"gp\">        fastcgi_buffer_size 16k;<\/span>\r\n<span class=\"gp\">        fastcgi_buffers 4 16k;<\/span>\r\n<span class=\"gp\">        include       fastcgi_params;<\/span>\r\n<span class=\"go\">    }\r\n}\r\n<\/span><\/code><\/pre>\n<h3>\u5b89\u88c5PHP7\u548cphp-fpm\u3002<\/h3>\n<h4>\u5b89\u88c5<\/h4>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> yum <span class=\"nb\">install<\/span> <span class=\"nt\">--enablerepo<\/span><span class=\"o\">=<\/span>remi-php70 <span class=\"nt\">-y<\/span> <span class=\"se\">\\<\/span>\r\n      php <span class=\"se\">\\<\/span>\r\n      php-fpm <span class=\"se\">\\<\/span>\r\n      php-cli <span class=\"se\">\\<\/span>\r\n      php-mcrypt <span class=\"se\">\\<\/span>\r\n      php-common <span class=\"se\">\\<\/span>\r\n      php-devel <span class=\"se\">\\<\/span>\r\n      php-mbstring <span class=\"se\">\\<\/span>\r\n      php-mysqlnd <span class=\"se\">\\<\/span>\r\n      php-opcache <span class=\"se\">\\<\/span>\r\n      php-pdo <span class=\"se\">\\<\/span>\r\n      php-pear <span class=\"se\">\\<\/span>\r\n      php-pecl-apcu <span class=\"se\">\\<\/span>\r\n      php-pecl-zip <span class=\"se\">\\<\/span>\r\n      php-process <span class=\"se\">\\<\/span>\r\n      php-xml <span class=\"se\">\\<\/span>\r\n      php-intl <span class=\"se\">\\<\/span>\r\n      php-soap <span class=\"se\">\\<\/span>\r\n      php-pecl-memcache <span class=\"se\">\\<\/span>\r\n      php-pecl-memcached <span class=\"se\">\\<\/span>\r\n      php-couchbase <span class=\"se\">\\<\/span>\r\n      php-imap <span class=\"se\">\\<\/span>\r\n      php-json <span class=\"se\">\\<\/span>\r\n      php-curl <span class=\"se\">\\<\/span>\r\n      php-gd\r\n<\/code><\/pre>\n<h4>\u8a2d\u7f6e\u6a94\u6848<\/h4>\n<pre class=\"post-pre\"><code><span class=\"go\">default_charset = \"UTF-8\"\r\ndate.timezone = \"Asia\/Tokyo\"\r\n\r\ndisplay_errors = On\r\ndisplay_startup_errors = On\r\nlog_errors = On\r\n\r\n[mbstring]\r\nmbstring.language = Japanese\r\n<\/span><\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"go\">user = nginx\r\ngroup = nginx\r\n\r\nlisten = \/var\/run\/php-fpm\/php-fpm.sock\r\nlisten.owner = nginx\r\nlisten.group = nginx\r\nlisten.mode = 0660\r\n\r\ncatch_workers_output = yes\r\n\r\nphp_flag[display_errors] = on\r\nphp_admin_value[display_errors] = 'stderr'\r\n<\/span><\/code><\/pre>\n<h3>\u5b89\u88c5Node.js\uff08npm\uff09\uff0cgulp\u548cwebpack<\/h3>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> yum <span class=\"nb\">install<\/span> <span class=\"nt\">-y<\/span> gcc-c++ make\r\n<span class=\"gp\">$<\/span> curl <span class=\"nt\">-sL<\/span> https:\/\/rpm.nodesource.com\/setup_6.x | <span class=\"nb\">sudo<\/span> <span class=\"nt\">-E<\/span> bash -\r\n<span class=\"gp\">$<\/span> yum <span class=\"nb\">install <\/span>nodejs\r\n<span class=\"gp\">$<\/span> npm i <span class=\"nt\">-g<\/span> grunt-cli\r\n<span class=\"gp\">$<\/span> npm i <span class=\"nt\">-g<\/span> browserify\r\n<span class=\"gp\">$<\/span> npm i <span class=\"nt\">-g<\/span> uglify-js\r\n<span class=\"gp\">$<\/span> npm i <span class=\"nt\">-g<\/span> webpack\r\n<\/code><\/pre>\n<h3>\u5b89\u88c5Mautic<\/h3>\n<p>\u5b89\u88c5git\u548ccomposer<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> yum <span class=\"nb\">install<\/span> <span class=\"nt\">-y<\/span> git\r\n<span class=\"gp\">$<\/span> <span class=\"nb\">cd<\/span> \/tmp\r\n<span class=\"gp\">$<\/span> curl <span class=\"nt\">-sS<\/span> https:\/\/getcomposer.org\/installer | php\r\n<span class=\"gp\">$<\/span> <span class=\"nb\">mv <\/span>composer.phar \/usr\/local\/bin\/composer\r\n<span class=\"gp\">$<\/span> composer self-update\r\n<\/code><\/pre>\n<p>\u4e8b\u524d\u306bgithub\u306b\u3042\u308bmautic\u3092fork\u3059\u308b\u3002<br \/>\n\u305d\u306e\u5f8c\u3001\u4eee\u60f3\u30b5\u30fc\u30d0\u3067\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3001fork\u3057\u305fmautic\u3092git clone\u3059\u308b\u3053\u3068\u3067\u8a2d\u7f6e\u3002mautic\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u66f4\u65b0\u3059\u308b\u3068\u304d\u306f\u3001git pull origin master\u3067\u3001\u66f4\u65b0\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> <span class=\"nb\">cd<\/span> \/var\/www\/html\r\n<span class=\"gp\">$<\/span> git clone https:\/\/github.com\/myacccount\/mautic.git\r\n<span class=\"gp\">$<\/span> <span class=\"nb\">cd <\/span>mautic\r\n<span class=\"gp\">$<\/span> git checkout master\r\n<span class=\"gp\">$<\/span> composer <span class=\"nb\">install<\/span>\r\n<\/code><\/pre>\n<h3>\u30a2\u30af\u30bb\u30b9\u6a29\u9650\u306e\u5909\u66f4<\/h3>\n<p>\u3053\u306e\u307e\u307e\u3060\u3068nginx\u3092\u8d77\u52d5\u3057\u3066\u3082\u3001\u30d6\u30e9\u30a6\u30b6\u30a2\u30af\u30bb\u30b9\u3057\u305f\u3068\u304d\u306b\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u306e\u3067\u3001\u6a29\u9650\u3092\u5909\u66f4\u3059\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> <span class=\"nb\">touch<\/span> \/var\/log\/php-fpm\/www-error.log\r\n<span class=\"gp\">$<\/span> <span class=\"nb\">chmod <\/span>777 <span class=\"nt\">-R<\/span> \/var\/log\/php-fpm\r\n<span class=\"gp\">$<\/span> <span class=\"nb\">chmod <\/span>777 <span class=\"nt\">-R<\/span> \/var\/lib\/php\/session\r\n<span class=\"gp\">$<\/span> <span class=\"nb\">chmod <\/span>777 <span class=\"nt\">-R<\/span> \/var\/www\/html\/app\/cache\r\n<span class=\"gp\">$<\/span> <span class=\"nb\">chmod <\/span>777 <span class=\"nt\">-R<\/span> \/var\/www\/html\/app\/logs\r\n<\/code><\/pre>\n<h3>\u542f\u52a8 nginx \u548c php-fpm\u3002<\/h3>\n<p>\u307e\u305a\u306fphp-fpm\u304b\u3089\u8d77\u52d5\u3059\u308b\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> \/etc\/init.d\/php-fpm start\r\n<\/code><\/pre>\n<p>\u63a5\u4e0b\u6765\u542f\u52a8nginx\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"gp\">$<\/span> \/etc\/init.d\/nginx start\r\n<\/code><\/pre>\n<h2>\u542f\u52a8Mautic\u3002<\/h2>\n<p>\u53ea\u8981\u6253\u5f00\u6d4f\u89c8\u5668\uff0cMautic\u7684\u6570\u636e\u5e93\u8bbe\u7f6e\u548c\u7ba1\u7406\u5458\u7528\u6237\u6ce8\u518c\u9875\u9762\u5c06\u4f9d\u6b21\u663e\u793a\u51fa\u6765\uff0c\u5e76\u4e14\u6210\u529f\u663e\u793a\u4eea\u8868\u76d8\u9875\u9762\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d1f3637434c4406c19733\/103-0.png\" alt=\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8 2017-05-12 0.31.00.png\" \/><\/div>\n<p>\u203b\u30ad\u30e3\u30d7\u30c1\u30e3\u753b\u50cf\u3067\u306f\u65e5\u672c\u8a9e\u5bfe\u5fdc\u3067\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u3002\u8a2d\u5b9a\u306e\u8a73\u7d30\u306f\u3053\u3061\u3089\u3092\u53c2\u7167\u3057\u305f\u3002\u305f\u3060\u3057\u3001\u4e00\u5ea6\u30ed\u30b0\u30a2\u30a6\u30c8\u3057\u306a\u3044\u3068\u65e5\u672c\u8a9e\u5316\u3055\u308c\u306a\u304b\u3063\u305f\u306e\u3067\u3001\u52d5\u4f5c\u4ed5\u69d8\u306b\u3064\u3044\u3066\u8abf\u3079\u3066\u307f\u305f\u3044\u3068\u601d\u3046\u3002<\/p>\n<h2>\u305d\u306e\u4ed6<\/h2>\n<h3>\u963f\u51e1\u8fbe (\u0100 d\u00e1)<\/h3>\n<p>mautic\u306b\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u3068\u30a2\u30d0\u30bf\u30fc\u753b\u50cf\u304c\u8868\u793a\u3055\u308c\u306a\u3044\u72b6\u614b\u306b\u306a\u308b\u306e\u3067\u3001\u6c17\u306b\u306a\u308b\u306e\u3067\u3042\u308c\u3070gravatar\u3067\u3001\u30a2\u30ab\u30a6\u30f3\u30c8\u4f5c\u6210\u6642\u306b\u6307\u5b9a\u3057\u305f\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3067gravatar\u306b\u767b\u9332\u3059\u308c\u3070\uff08\u767b\u9332\u3057\u3066\u3082\u5373\u6642\u53cd\u6620\u3055\u308c\u306a\u304b\u3063\u305f\uff09\u6b63\u5e38\u306b\u8868\u793a\u3055\u308c\u308b\u3002<\/p>\n<h3>\u6545\u969c\u76f8\u5173<\/h3>\n<p>\u203b\u5b9f\u306fMariaDB\u3067mautic\u3092\u52d5\u4f5c\u3055\u305b\u3088\u3046\u3068\u3057\u305f\u304c\u3001\u4e0b\u8a18\u306ePHP\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u305f\u3081\u3001\u65ad\u5ff5\u3057\u3001Droplet\u3092\u518d\u4f5c\u6210\u3057\u305f\u80cc\u666f\u304c\u3042\u3063\u305f\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"p\">[<\/span><span class=\"mi\">2017<\/span><span class=\"o\">-<\/span><span class=\"mo\">05<\/span><span class=\"o\">-<\/span><span class=\"mo\">02<\/span> <span class=\"mi\">11<\/span><span class=\"o\">:<\/span><span class=\"mi\">55<\/span><span class=\"o\">:<\/span><span class=\"mi\">53<\/span><span class=\"p\">]<\/span> <span class=\"n\">mautic<\/span><span class=\"mf\">.<\/span><span class=\"no\">CRITICAL<\/span><span class=\"o\">:<\/span> <span class=\"nc\">Uncaught<\/span> <span class=\"no\">PHP<\/span> <span class=\"nc\">Exception<\/span> <span class=\"nc\">Doctrine\\DBAL\\Exception\\DriverException<\/span><span class=\"o\">:<\/span> <span class=\"s2\">\"An exception occurred while executing 'SELECT COUNT(t.date_added) AS leads, ll.id, ll.name FROM lead_lists_leads t INNER JOIN lead_lists ll ON ll.id = t.leadlist_id WHERE (ll.is_published = ?) AND (t.date_added BETWEEN ? AND ?) GROUP BY ll.id ORDER BY leads DESC LIMIT 9' with params [true, \"<\/span><span class=\"mi\">2017<\/span><span class=\"o\">-<\/span><span class=\"mo\">04<\/span><span class=\"o\">-<\/span><span class=\"mo\">02<\/span> <span class=\"mo\">00<\/span><span class=\"o\">:<\/span><span class=\"mo\">00<\/span><span class=\"o\">:<\/span><span class=\"mo\">00<\/span><span class=\"s2\">\", \"<\/span><span class=\"mi\">2017<\/span><span class=\"o\">-<\/span><span class=\"mo\">05<\/span><span class=\"o\">-<\/span><span class=\"mo\">02<\/span> <span class=\"mi\">23<\/span><span class=\"o\">:<\/span><span class=\"mi\">59<\/span><span class=\"o\">:<\/span><span class=\"mi\">59<\/span><span class=\"s2\">\"]:  SQLSTATE[42000]: Syntax error or access violation: 1055 'mautic.ll.name' isn't in GROUP BY\"<\/span> <span class=\"n\">at<\/span> <span class=\"o\">\/<\/span><span class=\"k\">var<\/span><span class=\"o\">\/<\/span><span class=\"n\">www<\/span><span class=\"o\">\/<\/span><span class=\"n\">html<\/span><span class=\"o\">\/<\/span><span class=\"n\">src<\/span><span class=\"o\">\/<\/span><span class=\"n\">mautic<\/span><span class=\"o\">\/<\/span><span class=\"n\">vendor<\/span><span class=\"o\">\/<\/span><span class=\"n\">doctrine<\/span><span class=\"o\">\/<\/span><span class=\"n\">dbal<\/span><span class=\"o\">\/<\/span><span class=\"n\">lib<\/span><span class=\"o\">\/<\/span><span class=\"nc\">Doctrine<\/span><span class=\"o\">\/<\/span><span class=\"no\">DBAL<\/span><span class=\"o\">\/<\/span><span class=\"nc\">Driver<\/span><span class=\"o\">\/<\/span><span class=\"nc\">AbstractMySQLDriver<\/span><span class=\"mf\">.<\/span><span class=\"n\">php<\/span> <span class=\"n\">line<\/span> <span class=\"mi\">115<\/span> <span class=\"p\">{<\/span><span class=\"s2\">\"exception\"<\/span><span class=\"o\">:<\/span><span class=\"s2\">\"[object] (Doctrine<\/span><span class=\"se\">\\\\<\/span><span class=\"s2\">DBAL<\/span><span class=\"se\">\\\\<\/span><span class=\"s2\">Exception<\/span><span class=\"se\">\\\\<\/span><span class=\"s2\">DriverException(code: 0): An exception occurred while executing 'SELECT COUNT(t.date_added) AS leads, ll.id, ll.name FROM lead_lists_leads t INNER JOIN lead_lists ll ON ll.id = t.leadlist_id WHERE (ll.is_published = ?) AND (t.date_added BETWEEN ? AND ?) GROUP BY ll.id ORDER BY leads DESC LIMIT 9' with params [true, <\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">2017-04-02 00:00:00<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">, <\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">2017-05-02 23:59:59<\/span><span class=\"se\">\\\"<\/span><span class=\"s2\">]:<\/span><span class=\"se\">\\n\\n<\/span><span class=\"s2\">SQLSTATE[42000]: Syntax error or access violation: 1055 'mautic.ll.name' isn't in GROUP BY at \/var\/www\/html\/src\/mautic\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php:115, Doctrine<\/span><span class=\"se\">\\\\<\/span><span class=\"s2\">DBAL<\/span><span class=\"se\">\\\\<\/span><span class=\"s2\">Driver<\/span><span class=\"se\">\\\\<\/span><span class=\"s2\">PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 'mautic.ll.name' isn't in GROUP BY at \/var\/www\/html\/src\/mautic\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php:93, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 'mautic.ll.name' isn't in GROUP BY at \/var\/www\/html\/src\/mautic\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php:91)\"<\/span><span class=\"p\">}<\/span> <span class=\"p\">[]<\/span>\r\n<\/code><\/pre>\n<p>\u6211\u603b\u7ed3\u4e86\u5173\u4e8e\u8fd9\u4e2a\u9519\u8bef\u7684\u8c03\u67e5\u7ed3\u679c\u3002\u7531\u4e8e\u5728GROUP BY\u4e2d\u7701\u7565\u4e86\u5217\u6307\u5b9a\u800c\u8fdb\u884c\u4e86SELECT\u64cd\u4f5c\u3002\u4e0d\u662fMariaDB\u6216MySQL\uff0c\u800c\u662f\u53d6\u51b3\u4e8esql_mode\u662f\u5426\u8bbe\u7f6e\u4e3aONLY_FULL_GROUP_BY\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728DigitalOcean\u4e0a\u5b89\u88c5Mautic\u3002 \u867d\u7136\u542c\u8bf4\u65e5\u672c\u6ca1\u6709\u5ec9\u4ef7\u7684\u6570\u636e\u4e2d\u5fc3\uff0c\u4f46\u7531\u4e8e\u60f3\u5c1d\u8bd5\u4e00\u4e0bDigital [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-34765","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u5728DigitalOcean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728digitalocean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5728DigitalOcean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic\" \/>\n<meta property=\"og:description\" content=\"\u5728DigitalOcean\u4e0a\u5b89\u88c5Mautic\u3002 \u867d\u7136\u542c\u8bf4\u65e5\u672c\u6ca1\u6709\u5ec9\u4ef7\u7684\u6570\u636e\u4e2d\u5fc3\uff0c\u4f46\u7531\u4e8e\u60f3\u5c1d\u8bd5\u4e00\u4e0bDigital [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728digitalocean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-19T18:49:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-04T08:07:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d1f3637434c4406c19733\/103-0.png\" \/>\n<meta name=\"author\" content=\"\u96c5, \u609f\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u96c5, \u609f\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/\",\"name\":\"\u5728DigitalOcean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-02-19T18:49:55+00:00\",\"dateModified\":\"2024-05-04T08:07:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5728DigitalOcean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6\",\"name\":\"\u96c5, \u609f\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"caption\":\"\u96c5, \u609f\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5728DigitalOcean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728digitalocean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5728DigitalOcean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic","og_description":"\u5728DigitalOcean\u4e0a\u5b89\u88c5Mautic\u3002 \u867d\u7136\u542c\u8bf4\u65e5\u672c\u6ca1\u6709\u5ec9\u4ef7\u7684\u6570\u636e\u4e2d\u5fc3\uff0c\u4f46\u7531\u4e8e\u60f3\u5c1d\u8bd5\u4e00\u4e0bDigital [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728digitalocean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-02-19T18:49:55+00:00","article_modified_time":"2024-05-04T08:07:39+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d1f3637434c4406c19733\/103-0.png"}],"author":"\u96c5, \u609f","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u96c5, \u609f","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"7 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/","name":"\u5728DigitalOcean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-02-19T18:49:55+00:00","dateModified":"2024-05-04T08:07:39+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5728DigitalOcean\u4e0a\u5f15\u5165\u8425\u9500\u81ea\u52a8\u5316\u5de5\u5177mautic"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6","name":"\u96c5, \u609f","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","caption":"\u96c5, \u609f"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8digitalocean%e4%b8%8a%e5%bc%95%e5%85%a5%e8%90%a5%e9%94%80%e8%87%aa%e5%8a%a8%e5%8c%96%e5%b7%a5%e5%85%b7mautic\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/34765","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=34765"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/34765\/revisions"}],"predecessor-version":[{"id":99324,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/34765\/revisions\/99324"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=34765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=34765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=34765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}