SQL help please (Mysql/MariaDB).

2021-09-11 Thread C. Petro
I'm trying to build a mail server for a friend using Postfix, Dovecot and Postfixadmin, using Mariadb as the backend for user information and authentication. I've got it *almost* working. (dovecot -n at the bottom because I don't think the problem is in the SQL) I have things up to the point wher

Re: SQL help please (Mysql/MariaDB).

2021-09-12 Thread C. Petro
To be more clear about my problem. This server will be hosting multiple email domains, and I would prefer to have the filesystem structured like /var/mail/vmail// rather than /var/mail/vmail/@. On Sat, Sep 11, 2021 at 3:06 PM C. Petro wrote: > I'm trying to build a mail server for

Re: SQL help please (Mysql/MariaDB).

2021-09-12 Thread C. Petro
That appears to have done the trick. Thank you for your quick response. I probably should have found that setting. Sorry. On Sun, Sep 12, 2021 at 10:39 AM Aki Tuomi wrote: > Try > > mail_location = maildir:/var/mail/vmail/%Ld/%Ln > > Aki > > > On 12/09/20

Re: SQL help please (Mysql/MariaDB).

2021-09-12 Thread C. Petro
e sure I didn't miss anything. I'll give it another lok. On Sun, Sep 12, 2021 at 11:05 AM Benny Pedersen wrote: > On 2021-09-12 18:38, C. Petro wrote: > > To be more clear about my problem. > > > > This server will be hosting multiple email domains, and I would pre

Authentication problems due to file ownership issue.

2021-10-03 Thread C. Petro
I am getting: Oct 03 20:19:52 auth: Error: net_connect_unix(auth-worker) in directory /run/dovecot failed: Permission denied (euid=5000(vmail) egid=5000(vmail) missing +r perm: /run/dovecot/auth-worker, dir owned by 0:0 mode=0755) Because: root@mailserver:/run/dovecot# ls -l auth-worker srw---

Re: Authentication problems due to file ownership issue.

2021-10-11 Thread C. Petro
This is a late response, sorry--it got pushed down the stack. > Not sure what you are trying to do, but another option I am trying to get postfix + postfixadmin working with Dovecot. All of the user and domain configuration is in Mysqldb, and the mail directories in /var/mail/vmail are owned by