https://wiki.thnic.or.th/index.php?action=history&feed=atom&title=3._%E0%B8%95%E0%B8%B1%E0%B9%89%E0%B8%87%E0%B8%84%E0%B9%88%E0%B8%B2_postfix_%E0%B9%80%E0%B8%9E%E0%B8%B7%E0%B9%88%E0%B8%AD%E0%B9%83%E0%B8%AB%E0%B9%89%E0%B9%80%E0%B8%8A%E0%B8%B7%E0%B9%88%E0%B8%AD%E0%B8%A1%E0%B8%95%E0%B9%88%E0%B8%AD%E0%B8%81%E0%B8%B1%E0%B8%9A_MariaDB 3. ตั้งค่า postfix เพื่อให้เชื่อมต่อกับ MariaDB - ประวัติรุ่นแก้ไข 2026-10-23T13:41:23Z ประวัติรุ่นแก้ไขของหน้านี้ในวิกิ MediaWiki 1.46.2 https://wiki.thnic.or.th/index.php?title=3._%E0%B8%95%E0%B8%B1%E0%B9%89%E0%B8%87%E0%B8%84%E0%B9%88%E0%B8%B2_postfix_%E0%B9%80%E0%B8%9E%E0%B8%B7%E0%B9%88%E0%B8%AD%E0%B9%83%E0%B8%AB%E0%B9%89%E0%B9%80%E0%B8%8A%E0%B8%B7%E0%B9%88%E0%B8%AD%E0%B8%A1%E0%B8%95%E0%B9%88%E0%B8%AD%E0%B8%81%E0%B8%B1%E0%B8%9A_MariaDB&diff=254&oldid=prev Tanagan เมื่อ 06:42, 8 พฤษภาคม 2563 2020-05-08T06:42:37Z <p></p> <table style="background-color: #fff; color: #202122;" data-mw-interface=""> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="th"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←รุ่นแก้ไขก่อนหน้า</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">รุ่นแก้ไขเมื่อ 06:42, 8 พฤษภาคม 2563</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l10">บรรทัดที่ 10:</td> <td colspan="2" class="diff-lineno">บรรทัดที่ 10:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>2. สร้างไฟล์ script เพื่อใช้สำหรับ forward email</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>2. สร้างไฟล์ script เพื่อใช้สำหรับ forward email</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># vi /etc/postfix/mysql-virtual_forwardings.cf</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> '''</ins># vi /etc/postfix/mysql-virtual_forwardings.cf<ins style="font-weight: bold; text-decoration: none;">'''</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  &#039;&#039;&#039;user = &#039;&#039;&#039;[[yourdbuser]]&#039;&#039;&#039;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  &#039;&#039;&#039;user = &#039;&#039;&#039;[[yourdbuser]]&#039;&#039;&#039;</div></td></tr> <!-- diff cache key wiki_staging:diff:1.41:old-253:rev-254:php=table --> </table> Tanagan https://wiki.thnic.or.th/index.php?title=3._%E0%B8%95%E0%B8%B1%E0%B9%89%E0%B8%87%E0%B8%84%E0%B9%88%E0%B8%B2_postfix_%E0%B9%80%E0%B8%9E%E0%B8%B7%E0%B9%88%E0%B8%AD%E0%B9%83%E0%B8%AB%E0%B9%89%E0%B9%80%E0%B8%8A%E0%B8%B7%E0%B9%88%E0%B8%AD%E0%B8%A1%E0%B8%95%E0%B9%88%E0%B8%AD%E0%B8%81%E0%B8%B1%E0%B8%9A_MariaDB&diff=253&oldid=prev Tanagan: Created page with "1. สร้างไฟล์ script เพื่อใช้สำหรับเรียกค่า domain '''# vi /etc/postfix/mysql-virtual_domains.cf''' '''user =..." 2020-05-08T06:41:51Z <p>Created page with &quot;1. สร้างไฟล์ script เพื่อใช้สำหรับเรียกค่า domain &#039;&#039;&#039;# vi /etc/postfix/mysql-virtual_domains.cf&#039;&#039;&#039; &#039;&#039;&#039;user =...&quot;</p> <p><b>หน้าใหม่</b></p><div>1. สร้างไฟล์ script เพื่อใช้สำหรับเรียกค่า domain <br /> &#039;&#039;&#039;# vi /etc/postfix/mysql-virtual_domains.cf&#039;&#039;&#039;<br /> <br /> &#039;&#039;&#039;user = &#039;&#039;&#039;[[yourdbuser]]&#039;&#039;&#039;<br /> password = &#039;&#039;&#039;[[yourdbpassword]]&#039;&#039;&#039;<br /> dbname = &#039;&#039;&#039;[[eaimail]]&#039;&#039;&#039;<br /> query = SELECT domain AS virtual FROM domains WHERE domain=&#039;%s&#039;<br /> hosts = 127.0.0.1&#039;&#039;&#039;<br /> <br /> <br /> 2. สร้างไฟล์ script เพื่อใช้สำหรับ forward email<br /> # vi /etc/postfix/mysql-virtual_forwardings.cf<br /> <br /> &#039;&#039;&#039;user = &#039;&#039;&#039;[[yourdbuser]]&#039;&#039;&#039;<br /> password = &#039;&#039;&#039;[[yourdbpassword]]&#039;&#039;&#039;<br /> dbname = &#039;&#039;&#039;[[eaimail]]&#039;&#039;&#039;<br /> query = SELECT destination FROM forwardings WHERE source=&#039;%s&#039;<br /> hosts = 127.0.0.1&#039;&#039;<br /> <br /> <br /> 3. สร้างไฟล์ script เพื่อใช้สำหรับ สร้าง mailbox และใช้ login <br /> &#039;&#039;&#039;# vi /etc/postfix/mysql-virtual_mailboxes.cf&#039;&#039;&#039;<br /> <br /> &#039;&#039;&#039;user = &#039;&#039;&#039;[[yourdbuser]]&#039;&#039;&#039; <br /> password = &#039;&#039;&#039;[[yourdbpassword]]&#039;&#039;&#039;<br /> dbname = &#039;&#039;&#039;[[eaimail]]&#039;&#039;&#039;<br /> query = SELECT CONCAT(SUBSTRING_INDEX(email,&#039;@&#039;,-1),&#039;/&#039;,SUBSTRING_INDEX(email,&#039;@&#039;,1),&#039;/&#039;) FROM users WHERE email=&#039;%s&#039;<br /> hosts = 127.0.0.1&#039;&#039;&#039;<br /> <br /> <br /> 4. สร้างไฟล์ script เพื่อใช้สำหรับ ส่งต่อ email ทั้งหมด ไปยัง smtp server อื่น ซึ่งใช้ในกรณีที่ host เป็น IP Address<br /> &#039;&#039;&#039;# vi /etc/postfix/mysql-virtual_email2email.cf&#039;&#039;&#039;<br /> <br /> &#039;&#039;&#039;user = yourdbuser<br /> password = yourdbpassword<br /> dbname = eaimail<br /> query = SELECT email FROM users WHERE email=&#039;%s&#039;<br /> hosts = 127.0.0.1&#039;&#039;&#039;<br /> <br /> <br /> 5. กำหนดสิทธิ์ให้กับ script ที่สร้างขึ้น<br /> &#039;&#039;&#039;# chmod o= /etc/postfix/mysql-virtual_*.cf<br /> # chgrp postfix /etc/postfix/mysql-virtual_*.cf&#039;&#039;&#039;<br /> <br /> <br /> 6. สร้าง user และ group เพื่อใช้กับ mailbox <br /> &#039;&#039;&#039;# groupadd -g 5000 vmail<br /> # useradd -g vmail -u 5000 vmail -d /home/vmail -m&#039;&#039;&#039;</div> Tanagan