• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

where are the mail alias stored?

  • Thread starter Carlos Treviño
  • Start date
C

Carlos Treviño

Guest
I make an OS reload and loose my plesk functionality on the old server but I have the discs and information.

Where are the mail alias stored on the server?
I can't find them on /var/qmail/alias

I need to restore the users alias configuration and I think the data should be somewere phisically on the server but I can't find it any help is appreciated

Thanks
 
The aliases are stored in psa.mail_aliases. The mn_id column references the id in the mail table. The dom_id column in the mail table references the id of the domains table. With that you can build a query that suits your need. For example if you want to know all aliases of a domain name "mydomain.xx" your query could be:

Code:
SELECT a.alias AS alias
FROM psa.mail_aliases AS a
INNER JOIN psa.mail AS b ON b.id = a.mn_id
INNER JOIN psa.domains AS c ON c.id = b.dom_id
WHERE c.name LIKE 'mydomain.xx';
 
The aliases are stored in psa.mail_aliases. The mn_id column references the id in the mail table. The dom_id column in the mail table references the id of the domains table. With that you can build a query that suits your need. For example if you want to know all aliases of a domain name "mydomain.xx" your query could be:

Code:
SELECT a.alias AS alias
FROM psa.mail_aliases AS a
INNER JOIN psa.mail AS b ON b.id = a.mn_id
INNER JOIN psa.domains AS c ON c.id = b.dom_id
WHERE c.name LIKE 'mydomain.xx';
Thank you very much. Since my install was completely broken, instead of having to recover psa database, I also found that aliases can be found in /var/lib/psa/dumps/domains/XXXXXX/backup_info_XXXXX.xml
 
Back
Top