查看目前的執行原則
Get-ExecutionPolicy
預設原則為Restricted，也就是受到限制的意思，所以造成你無法執行Powershell的腳本。
PowerShell 執行原則共有七個：
AllSigned: 可執行已簽署的腳本
Bypass: 不會封鎖任何項目，且不會顯示警告或提示
Default: 設定預設執行原則。(用戶端會是Restricted，伺服器會是RemoteSigned。)
RemoteSigned: 本機撰寫的腳本不必簽署可執行，遠端下載的腳本需簽署才可執行
Restricted: 不允許執行腳本。
Undefined: 無定義
Unrestricted: 所有腳本都可以執行
選擇執行原則
Set-ExecutionPolicy Unrestricted
解決方法是強制啟用 TLS 1.2
檢查當前 PowerShell 使用的安全性協定
[Net.ServicePointManager]::SecurityProtocol在指令碼上方加入
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
紀錄一下~
最近把老舊的Centos換成 Ubuntu ，重裝後 發現 log 總有 clamav 沒有權限
2025-04-01T08:07:37.567746+08:00 mail amavis[24976]: (24976-01) (!)run_av (ClamAV-clamd) FAILED - unexpected , output="/var/lib/amavis/tmp/amavis-20250401T080737-24976-hh7Vafwe/parts: File path check failure: Permission denied. ERROR\n/var/lib/amavis/tmp/amavis-20250401T080737-24976-hh7Vafwe/parts: File path check failure: Permission denied. ERROR\n"
研究了一下，是clamav沒有權限存取 /var/lib/amavis/tmp這個資料匣
先把這個資料匣群組改成clamav
chown -R amavis:clamav /var/lib/amavis/tmp
接著修改群組權限
chmod -R g+w /var/lib/amavis/tmp
再編輯 /sbin/amavisd-submit 找到
chmod(0750, $tempdir)
改成
chmod(0770, $tempdir)
重啟服務，觀察log就沒再出現問題!
web.config 加入下面內容
<connectionStrings>
<add name="connect string" connectionString="server=IP;user id=user name;password=Password;Persist Security Info=True;Database=DB name;" providerName="MySql.Data.MySqlClient"/>
</connectionStrings>
程式引用
using MySql.Data.MySqlClient;
........
MySqlConnectionStringBuilder sqlsb = new MySqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["connect string"].ConnectionString);
MySqlConnection MySqlConnection = new MySqlConnection(sqlsb.ConnectionString);
string sqlStatement = @"select * from test";
MySqlCommand MySqlCommand = new MySqlCommand(sqlStatement);
MySqlCommand.Connection = MySqlConnection;
MySqlConnection.Open();
1. 安裝 mb2md 套件
#dnf install mb2md
2. 建立 maildir 目錄並修改權限
#mkdir /var/spool/maildir
#chown root.mail /var/spool/maildir
#chmod 775 /var/spool/maildir
3. 修改 postfix 設定 vi /etc/postfix/main.cf
home_mailbox = Maildir/
mailbox_command = /usr/bin/procmail -a "$EXTENSION" DEFAULT=/var/spool/maildir/$USER/ MAILDIR=/var/spool/maildir/$USER
4. 修改 dovecot 設定 vi /etc/dovecot.conf
mail_location = maildir:/var/spool/maildir/%u
5. 停止 mail service
#systemctl stop postfix
#systemctl stop dovecot
6. 寫一個 script 執行
#!/bin/sh
set -x
MAILBOX_DIR="/var/spool/mail"
MAILDIR_DIR="/var/spool/maildir"
[ -d $MAILDIR_DIR ] || mkdir -p $MAILDIR_DIR
cd $MAILBOX_DIR
for user in *; do
mb2md -s $MAILBOX_DIR/$user -d $MAILDIR_DIR/$user
chown -R $user.mail $MAILDIR_DIR/$user/
done
7. 啟動郵件服務
#systemctl start postfix
#systemctl start dovecot
