{"id":318,"date":"2024-07-26T12:50:47","date_gmt":"2024-07-26T04:50:47","guid":{"rendered":"https:\/\/blog.iwonder.cc\/?p=318"},"modified":"2024-07-26T12:50:47","modified_gmt":"2024-07-26T04:50:47","slug":"%e5%ae%9d%e5%a1%94%e4%bf%ae%e6%94%b9%e7%ab%99%e7%82%b9%e5%90%8d%e7%a7%b0%e5%92%8c%e7%9b%ae%e5%bd%95","status":"publish","type":"post","link":"https:\/\/blog.iwonder.cc\/index.php\/2024\/07\/26\/%e5%ae%9d%e5%a1%94%e4%bf%ae%e6%94%b9%e7%ab%99%e7%82%b9%e5%90%8d%e7%a7%b0%e5%92%8c%e7%9b%ae%e5%bd%95\/","title":{"rendered":"\u5b9d\u5854\u4fee\u6539\u7ad9\u70b9\u540d\u79f0\u548c\u76ee\u5f55"},"content":{"rendered":"<p>\u5b9d\u5854\u7248\u672c\uff1a9.1.0<\/p>\n<h2>\u4fee\u6539\u7ad9\u70b9\u540d\u79f0\u548c\u76ee\u5f55<\/h2>\n<p>\u5b9d\u5854\u7ad9\u70b9\u4fe1\u606f\u5b58\u5728 sqlite \u6570\u636e\u5e93\u4e2d\uff0c\u6240\u4ee5\u8981\u53bb\u6570\u636e\u5e93\u6587\u4ef6\u4e2d\u4fee\u6539\u3002 \u6570\u636e\u5e93\u6587\u4ef6\uff1a<code>\/www\/server\/panel\/data\/db\/site.db<\/code><\/p>\n<p>\u7528 sqlite3 \u6253\u5f00\u6570\u636e\u5e93\uff0c\u6267\u884c sql \u8bed\u53e5\u4fee\u6539\uff1a<\/p>\n<ul>\n<li>\u67e5\u8be2\u7ad9\u70b9\u4fe1\u606f<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">select * from sites;\n<\/code><\/pre>\n<ul>\n<li>\u66f4\u65b0\u7ad9\u70b9\u540d\u79f0\u548c\u8def\u5f84<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">update sites set name=&#039;xxx&#039;, path=&#039;\/www\/wwwroot\/xxx&#039; where id = xx;\n<\/code><\/pre>\n<h2>\u4fee\u6539\u914d\u7f6e<\/h2>\n<p>\u56e0\u4e3a\u7ad9\u70b9\u76f8\u5173\u914d\u7f6e\u6587\u4ef6\u8def\u5f84\u662f\u548c\u7ad9\u70b9\u540d\u79f0\u6709\u5173\u7684\uff0c\u8981\u53bb\u76f8\u5e94\u7684\u76ee\u5f55\u4fee\u6539\uff1a<\/p>\n<ol>\n<li>\u4fee\u6539 nginx \u914d\u7f6e\u6587\u4ef6\u540d\u79f0\u4ee5\u53ca\u5185\u5bb9\uff08root\u3001\u8bc1\u4e66\u8def\u5f84\u7b49\uff09 <code>\/www\/server\/panel\/vhost\/nginx<\/code><code>\/www\/server\/panel\/vhost\/nginx\/well-known<\/code><\/li>\n<li>\u4fee\u6539 ssl \u8bc1\u4e66\u76ee\u5f55 <code>\/www\/server\/panel\/vhost\/ssl<\/code><code>\/www\/server\/panel\/vhost\/cert<\/code><\/li>\n<li>\u4fee\u6539\u4f2a\u9759\u6001\u6587\u4ef6\u540d\u79f0 <code>\/www\/server\/panel\/vhost\/rewrite<\/code><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u5b9d\u5854\u7248\u672c\uff1a9.1.0 \u4fee\u6539\u7ad9\u70b9\u540d\u79f0\u548c\u76ee\u5f55 \u5b9d\u5854\u7ad9\u70b9\u4fe1\u606f\u5b58\u5728 sqlite \u6570\u636e\u5e93\u4e2d\uff0c\u6240\u4ee5\u8981\u53bb\u6570\u636e\u5e93\u6587\u4ef6\u4e2d\u4fee\u6539\u3002 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[26],"class_list":["post-318","post","type-post","status-publish","format-standard","hentry","category-devops","tag-26"],"_links":{"self":[{"href":"https:\/\/blog.iwonder.cc\/index.php\/wp-json\/wp\/v2\/posts\/318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.iwonder.cc\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.iwonder.cc\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.iwonder.cc\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.iwonder.cc\/index.php\/wp-json\/wp\/v2\/comments?post=318"}],"version-history":[{"count":2,"href":"https:\/\/blog.iwonder.cc\/index.php\/wp-json\/wp\/v2\/posts\/318\/revisions"}],"predecessor-version":[{"id":321,"href":"https:\/\/blog.iwonder.cc\/index.php\/wp-json\/wp\/v2\/posts\/318\/revisions\/321"}],"wp:attachment":[{"href":"https:\/\/blog.iwonder.cc\/index.php\/wp-json\/wp\/v2\/media?parent=318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.iwonder.cc\/index.php\/wp-json\/wp\/v2\/categories?post=318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.iwonder.cc\/index.php\/wp-json\/wp\/v2\/tags?post=318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}