{"id":1699,"date":"2024-05-08T17:57:35","date_gmt":"2024-05-08T09:57:35","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1699"},"modified":"2024-05-08T17:57:35","modified_gmt":"2024-05-08T09:57:35","slug":"%e6%89%b9%e9%87%8f%e4%bf%ae%e6%94%b9%e6%af%8f%e4%b8%aa%e5%9c%b0%e5%b8%82%e7%9a%84%e9%85%8d%e7%bd%ae%e6%96%87%e4%bb%b6swith_dburl_user_pass-sh","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1699","title":{"rendered":"\u6279\u91cf\u4fee\u6539\u6bcf\u4e2a\u5730\u5e02\u7684\u914d\u7f6e\u6587\u4ef6swith_dburl_user_pass.sh"},"content":{"rendered":"<pre><code class=\"language-shell\">#!\/usr\/bin\/ksh\n##\u811a\u672c\u5b9e\u73b0\u6279\u91cf\u66f4\u6539\u591a\u4e2a\u5730\u5e02\u7684\u591a\u4e2a\u914d\u7f6e\u6587\u4ef6##############\n##1.\u4fee\u6539\u6570\u636e\u5e93\u5b9e\u4f8b                                ####  \n##2.\u4fee\u6539\u7528\u6237\u540d\u4e0e\u5bc6\u7801                              ####\n##3.\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\u76f8\u5173\u7279\u5b9a\u7684\u8def\u5f84                    ####\n######################################################\ndburl1=uatdb\n# \u83b7\u53d6\u76ee\u5f55\n#ls -l|grep ^d |awk &#039;{print $9}&#039; &gt;&gt;dirlist.txt\ndircount=`wc -l dirlist.txt`\ncount=0\n#if [ $dircount -ne 0 ]; then\n#else\n#exit\n#fi\ncat dirlist.txt |while read dirname\n#\u83b7\u53d6\u5730\u5e02\u7b80\u79f0\nareaname=`echo $dirname |awk &#039;{print substr($0,1,2)}&#039;`\necho $areaname\n#\u5c06\u76ee\u5f55\u8f6c\u6362\u6210\u5927\u5199\u4f5c\u4e3a\u5bc6\u7801(typeset\u547d\u4ee4\u8981\u5728ksh\u91cc\u6267\u884c\uff0cbsh\u4e0d\u652f\u6301)\ntypeset -u password1=$dirname\necho $password1\ncd \/usr1\/run\/hsc\/conf\/$dirname\n#\u83b7\u53d6\u5f53\u524d\u76ee\u5f55\u4e0b\u7684\u6240\u6709\u914d\u7f6e\u6587\u4ef6\uff0c\u76ee\u5f55\u9664\u5916\nls \/usr1\/run\/hsc\/conf\/$dirname|grep -v &#039;^d&#039;  &gt; \/usr1\/run\/hsc\/conf\/$dirname\/filelist.txt\nsleep 1\ndo\n  cd \/usr1\/run\/hsc\/conf\/$dirname\n  echo `pwd`\n  cat \/usr1\/run\/hsc\/conf\/$dirname\/filelist.txt| while read name\n  do\n      #\u66ff\u6362DBURL\uff0cDBUSER\uff0cDBPASS\uff0cAREA\n                        sed -e&quot;s\/dburl\\=szuat\/dburl\\=$dburl1\/g;s\/\\\/fshsc\/\\\/$dirname\/g;s\/dbuser\\=fshsc\/dbuser\\=$dirname\/g;s\/dbpass\\=\/dbpass\\=$password1\/g;s\/area\\=FS\/area\\=$areaname\/g;s\/area\\=fs\/area\\=$areaname\/g;s\/areacode\\=FS\/areacode\\=$areaname\/g;s\/ngbccs\/$dburl1\/g&quot; $name &gt;$name.tmp\n      mv $name.tmp $name\n  done\n  count=`expr $count + 1`\n  echo $count\n  if [$count -gt $dircount ];then\n  exit;\n  fi\ndone \n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>#!\/usr\/bin\/ksh ##\u811a\u672c\u5b9e\u73b0\u6279\u91cf\u66f4\u6539\u591a\u4e2a\u5730\u5e02\u7684\u591a\u4e2a\u914d\u7f6e\u6587\u4ef6############## ##1.\u4fee\u6539\u6570\u636e\u5e93\u5b9e\u4f8b #### ##2.\u4fee\u6539\u7528\u6237\u540d\u4e0e\u5bc6\u7801 #### ##3.\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\u76f8\u5173\u7279\u5b9a\u7684\u8def\u5f84 #### ###################################################### dburl1=uatdb # \u83b7\u53d6\u76ee\u5f55 #ls -l|grep ^d |awk &#039;{print $9}&#039; &gt;&gt;dirlist.txt dircount=`wc -l dirlist.txt` count=0 #if [ $dircount -ne 0 ]; then #else #exit #fi cat dirlist.txt |while read dirname #\u83b7\u53d6\u5730\u5e02\u7b80\u79f0 areaname=`echo $dirname |awk &#039;{print substr($0,1,2)}&#039;` echo $areaname #\u5c06\u76ee\u5f55\u8f6c\u6362\u6210\u5927\u5199\u4f5c\u4e3a\u5bc6\u7801(typeset\u547d\u4ee4\u8981\u5728ksh\u91cc\u6267\u884c\uff0cbsh\u4e0d\u652f\u6301) typeset -u password1=$dirname echo $password1 cd \/usr1\/run\/hsc\/conf\/$dirname #\u83b7\u53d6\u5f53\u524d\u76ee\u5f55\u4e0b\u7684\u6240\u6709\u914d\u7f6e\u6587\u4ef6\uff0c\u76ee\u5f55\u9664\u5916 ls \/usr1\/run\/hsc\/conf\/$dirname|grep -v &#039;^d&#039; &gt; \/usr1\/run\/hsc\/conf\/$dirname\/filelist.txt sleep 1 do cd \/usr1\/run\/hsc\/conf\/$dirname echo `pwd` cat \/usr1\/run\/hsc\/conf\/$dirname\/filelist.txt| while read name do #\u66ff\u6362DBURL\uff0cDBUSER\uff0cDBPASS\uff0cAREA sed -e&quot;s\/dburl\\=szuat\/dburl\\=$dburl1\/g;s\/\\\/fshsc\/\\\/$dirname\/g;s\/dbuser\\=fshsc\/dbuser\\=$dirname\/g;s\/dbpass\\=\/dbpass\\=$password1\/g;s\/area\\=FS\/area\\=$areaname\/g;s\/area\\=fs\/area\\=$areaname\/g;s\/areacode\\=FS\/areacode\\=$areaname\/g;s\/ngbccs\/$dburl1\/g&quot; $name &gt;$name.tmp mv $name.tmp $name done count=`expr $count + 1` echo $count if [$count -gt $dircount ];then exit; fi done<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[82,96,101,80],"tags":[],"class_list":["post-1699","post","type-post","status-publish","format-standard","hentry","category-82","category-txt","category-101","category-80"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1699"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1699\/revisions"}],"predecessor-version":[{"id":1700,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1699\/revisions\/1700"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}