jokn
13th December 2007, 00:34
Hi all!
First of all, sorry about the novell length post, hope you can stay awake through it all! :)
Hope someone can help me out, I'm doing pretty much the worst thing anyone can do, I'm running my employers web hosting service on a SUSE 10.2 machine without knowing very much about Linux.... (and I'm pretty much a full time Microsoft/Cisco consultant, so I'm more or less sysadmin by night)
Here's the problem, September 30th a customer called and said people mailing to them just get bounced, "unknown user", I read the logs and saw the message:
"Sep 30 13:12:43 suse postfix/postmap[13799]: fatal: open database /etc/postfix/virtusertable.db: No such file or directory"
I searched the forums and found the postmap/restart workaround figuring the bug would just get fixed by an online update (yes, most of my consulting is Microsoft-based, go figure...) but there seem to be no solution out there. In desperation I installed another machine exactly the same way, the brilliant Perfect setup SUSE 10.2 by Falko, and sure enough, I got the same error, every time I changed something in the web interface of ISPConfig I got the error message above and emails would bounce:
Dec 12 12:04:49 suse postfix/smtpd[9371]: NOQUEUE: reject: RCPT from public9.gotanet.se[62.80.209.34]: 550 5.1.1 <customer@company.tld>: Recipient address rejected: User unknown in local recipient table; from=<another_customer@another_company.tld> to=<customer@company.tld> proto=ESMTP helo=<public9.gotanet.se>
Addresses of course supressed, but you get the idea. As you can see by the time stamp I'm still getting screamed at by my less than patient customers...
Now for the fun part, since I was just running my own and a test website on the second test machine I went ahead and did an upgrade as soon as I finished downloading the 10.3 DVD, went well, the problems with the virtusertable.db is no longer there, I can change whatever I want and it just reloads as it's supposed to. Only thing that stopped working was TLS AUTH or whatever it's called, but I just had to enable it via chkconfig again and that too started working. The problem now is in three parts:
1. I need a script (yesterday or rather in October) that runs via cron that can read a line/word from /var/log/mail.err (the virtusertable.db error) and act upon it by running my fixmail-script (just postmap/restart), anyone know of a script like that IŽd be grateful. Have to have something until this is solved, I can't stay up 24/7 with a tail-f /var/log/mail....
2. Does anyone know where one may find the latest Postfix-rpm for SUSE, tried yast but it said latest 2.3.2 and installed 2.3.2 but I might be doing it wrong, self taught by night doesn't really cut it unless its Microsoft... Don't wanna go with a source compilation on the production machine either, I have 65 custumers there, already pissed off, but if I end up reinstalling the machine I might get lynched... Perhaps I have to change the repo server to get a later package?
3. For a full 10.3 upgrade (I know I'm getting nightmares just writing these words), any tips/warnings/anything? If that is how I need to proceed to get out of this I'm gonna get a one-way ticket far away first....
Thanks, hope you have some good tips for me!
/Jonas
First of all, sorry about the novell length post, hope you can stay awake through it all! :)
Hope someone can help me out, I'm doing pretty much the worst thing anyone can do, I'm running my employers web hosting service on a SUSE 10.2 machine without knowing very much about Linux.... (and I'm pretty much a full time Microsoft/Cisco consultant, so I'm more or less sysadmin by night)
Here's the problem, September 30th a customer called and said people mailing to them just get bounced, "unknown user", I read the logs and saw the message:
"Sep 30 13:12:43 suse postfix/postmap[13799]: fatal: open database /etc/postfix/virtusertable.db: No such file or directory"
I searched the forums and found the postmap/restart workaround figuring the bug would just get fixed by an online update (yes, most of my consulting is Microsoft-based, go figure...) but there seem to be no solution out there. In desperation I installed another machine exactly the same way, the brilliant Perfect setup SUSE 10.2 by Falko, and sure enough, I got the same error, every time I changed something in the web interface of ISPConfig I got the error message above and emails would bounce:
Dec 12 12:04:49 suse postfix/smtpd[9371]: NOQUEUE: reject: RCPT from public9.gotanet.se[62.80.209.34]: 550 5.1.1 <customer@company.tld>: Recipient address rejected: User unknown in local recipient table; from=<another_customer@another_company.tld> to=<customer@company.tld> proto=ESMTP helo=<public9.gotanet.se>
Addresses of course supressed, but you get the idea. As you can see by the time stamp I'm still getting screamed at by my less than patient customers...
Now for the fun part, since I was just running my own and a test website on the second test machine I went ahead and did an upgrade as soon as I finished downloading the 10.3 DVD, went well, the problems with the virtusertable.db is no longer there, I can change whatever I want and it just reloads as it's supposed to. Only thing that stopped working was TLS AUTH or whatever it's called, but I just had to enable it via chkconfig again and that too started working. The problem now is in three parts:
1. I need a script (yesterday or rather in October) that runs via cron that can read a line/word from /var/log/mail.err (the virtusertable.db error) and act upon it by running my fixmail-script (just postmap/restart), anyone know of a script like that IŽd be grateful. Have to have something until this is solved, I can't stay up 24/7 with a tail-f /var/log/mail....
2. Does anyone know where one may find the latest Postfix-rpm for SUSE, tried yast but it said latest 2.3.2 and installed 2.3.2 but I might be doing it wrong, self taught by night doesn't really cut it unless its Microsoft... Don't wanna go with a source compilation on the production machine either, I have 65 custumers there, already pissed off, but if I end up reinstalling the machine I might get lynched... Perhaps I have to change the repo server to get a later package?
3. For a full 10.3 upgrade (I know I'm getting nightmares just writing these words), any tips/warnings/anything? If that is how I need to proceed to get out of this I'm gonna get a one-way ticket far away first....
Thanks, hope you have some good tips for me!
/Jonas