RE: [cobalt-users] [RaQ4] Was (Monkey Wrench Goes Nowhere) problem but now email problem?

[aljuhani <aljuhani@xxxxxxxxx>]

This is the fix I have found sometime before on another Cobalt Website:

This will happen if your admin pages die and you need to replace them with the 
sitefix script. You will need to go through and replace all the email server 
aliases on all your sites.

If you have a lot of sites this could take a while. So you probably want to 
make use of the fact that this setting isn't stored in the pg database but is 
taken from the system files. 
Basically you need to add each domain name to /etc/mail/local-host-names and 
the configuration for sending mail for that to the right place in 
/etc/mail/virtuser.

Adding the domains to local-host-names is easy. Use something like:
ls /home/sites/|awk -F '.' ' {if ($0 ~ /www/) {print $2"."$3}}' >> 
/etc/mail/local-host-names

Adding the configuration to the virtusertable is a little more involved (not 
much). You need to have the list in the form of:
@domain.dom %1@xxxxxxxxxxxxxx
So generate a list using something like:
ls /home/sites/ |awk -F '.' ' {if ($0 ~ /www/) {print 
"@"$2"."$3"\t%1@"$2"."$3}}' > /tmp/newvirt

This will create a file with what you need. And you just need to add it into 
the virtusertable file underneath the comment which says:
# accept-email-at-domain routes
You can do this in vi by going to the right place in the file and using:
:r /tmp/newvirt

Then restart sendmail (/etc/rc.d/init.d/sendmail restart). This will save you 
a lot of time if you have 150 sites or so.

Al-Juhani
aljuhani@xxxxxxxxx

>===== Original Message From cobalt-users@xxxxxxxxxxxxxxx =====
>Hi,
>
>I had the monkey wrench goes nowhere problem last night on a RaQ4 and
>followed the instructions to use the fixsite.pl script which worked OK but
>now it appears that all the sites on the RaQ have lost the entries in the
>site settings for Email Server Aliases. There are about 150 sites on this
>RaQ and they all had entries in this box for email.
>
>I noticed this after the monkey wrench problem was fixed with the fixsite.pl
>script was run. None of the sites were getting email and any test emails I
>sent to it were returned with the Relaying denied message. I manually added
>entries for a couple of sites and they now work OK but I dread having to
>manually do this for all 150 sites, is there an easier way to do this?
>
>Could it have been the fixsite.pl script that caused this?
>
>Thanks in advance for any assistance.
>
>Joe
>www.qitc.net