Postfix, Configuration Error

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

Even if we have defined users in mysql we get the following error message:

<debug@[login to view URL]>: unknown user: "debug"

There might be one or more errors in the configuration. It is a setup to migrate from an old server. The server is up and running except for this misconfiguration.

We have defined the following files:

virtual_mailbox_domains = mysql:/etc/postfix/[login to view URL]

virtual_mailbox_maps = mysql:/etc/postfix/[login to view URL]

virtual_alias_maps = mysql:/etc/postfix/[login to view URL],

mysql:/etc/postfix/[login to view URL]

And the sql-log from mysql looks like this:

Connect postfixadmin@localhost on postfix using TCP/IP

Query SELECT goto FROM alias WHERE address='[login to view URL]'

Connect postfixadmin@localhost on postfix using TCP/IP

Query SELECT username FROM mailbox WHERE username='[login to view URL]'

Connect postfixadmin@localhost on postfix using TCP/IP

Query SELECT CONCAT(SUBSTRING_INDEX(username,'@',-1),'/',SUBSTRING_INDEX(username,'@',1),'/') FROM mailbox WHERE username='%s@%r' AND active = 1

Query SELECT goto FROM alias WHERE address='[login to view URL]'

Query SELECT username FROM mailbox WHERE username='[login to view URL]'

Query SELECT CONCAT(SUBSTRING_INDEX(username,'@',-1),'/',SUBSTRING_INDEX(username,'@',1),'/') FROM mailbox WHERE username='%s@%r' AND active = 1

Connect postfixadmin@localhost on postfix using TCP/IP

Query SELECT goto FROM alias WHERE address='debug@[login to view URL]'

Connect postfixadmin@localhost on postfix using TCP/IP

Query SELECT goto FROM alias WHERE address='debug@[login to view URL]'

Query SELECT goto FROM alias WHERE address='[login to view URL]'

Query SELECT username FROM mailbox WHERE username='[login to view URL]'

Query SELECT CONCAT(SUBSTRING_INDEX(username,'@',-1),'/',SUBSTRING_INDEX(username,'@',1),'/') FROM mailbox WHERE username='%s@%r' AND active = 1

Query SELECT goto FROM alias WHERE address='myself@[login to view URL]'

Query SELECT goto FROM alias WHERE address='[login to view URL]'

Query SELECT username FROM mailbox WHERE username='[login to view URL]'

Query SELECT CONCAT(SUBSTRING_INDEX(username,'@',-1),'/',SUBSTRING_INDEX(username,'@',1),'/') FROM mailbox WHERE username='%s@%r' AND active = 1

Linux MySQL System Admin Email Handling

Project ID: #22342797

About the project

12 proposals Remote project Active 4 years ago

Awarded to:

vili1977

Hello. I would like to help you with fixing postfix cfg after migration. I have experience. Please read my feedbacks. Thanks.

$55 USD in 1 day
(1213 Reviews)
7.8

12 freelancers are bidding on average $120 for this job

bindmission

Hello Hope you are doing well. I have 7 years of experience in Linux and email server management. I can fix the issue. Regards VishnuLal*

$100 USD in 1 day
(608 Reviews)
7.6
tanujchugh

Hi I will do the task of postfix configuration and resolve the issue as per your requirement and have expertise in the relevant field. I have 10 years of experience as system admin. Let me know for further queries. More

$100 USD in 1 day
(393 Reviews)
7.2
talhamq

I have experience in deploying and maintaining of: Cloud Computing Platforms: AWS Amazon Web Services,Microsoft AZURE, Google Cloud (GCP). Server Operating Systems: Windows Server 2003-to-2012R2, Windows Server 20 More

$60 USD in 1 day
(396 Reviews)
6.9
awxmem

Hello, I have 8+ years of development experience on Linux. I also have good knowledge of Postfix setup and configuration. I am sure that I can fix this migration issue. Best regards,

$140 USD in 2 days
(35 Reviews)
6.4
drkamine

Hello, i'm an expert IT with more 15 years of experience in IT industry . i'm certified Cisco networking professional 300-100 and 300-115 and Linux professional lpi 101, 102 and RHCSA and VCP 4, 5,5.5 and Data Center a More

$200 USD in 1 day
(145 Reviews)
6.5
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$180 USD in 4 days
(45 Reviews)
6.3
raj00565

Dear Client, Share the access details of Panel, let me review it I would handle this and fix this. I need further discussion for a quick start. I am an Oracle certified DBA and have hands-on experience in Linux Admini More

$140 USD in 2 days
(53 Reviews)
6.4
amiexpart

Hello, I have 3 years AWS & Web server admin experience and can fix Postfix configure issues. Please let me know the access details for a quick start. Thanks Amita G

$99 USD in 4 days
(61 Reviews)
5.5
Hostingsolutions

Hello, I Have read your whole proposal, This is very good job Depending on My Long experience Since 2010 I have rich skills in Linux,Windows... ✔️ Whm & Cpanel / Plesk/DirectAdmin/Webuzo ✔️ Amazon AWS/Google Cloud/Az More

$140 USD in 7 days
(40 Reviews)
5.6
jamesmartin81

Hi, I am ready to start right away. I have reviewed your job description as well and very confident to handle this project perfectly. I will do multiple revision in your project with 100% satisfaction work guaranteed More

$70 USD in 1 day
(63 Reviews)
5.1