[freeside-users] How to change all e-mail addresses?

[Scott]

On 2018/9/6 17:19, Ernie Dunbar wrote:
> Hi everyone.
> 
> I've set up a copy of our Freeside virtual machine for testing purposes. 
> Now, in order to test invoicing properly before making changes on the 
> live server, I need to change every e-mail address in the database so 
> that our live customers don't get error messages every time we run a test.
> 
> The problem is that the database relation isn't so obvious for the 
> customer e-mail contact field. If anyone knows where you can change this 
> in Postgres, it would save me a lot of time.
> 

This doesn't answer your question, but might give you a solution.  You 
should be able to modify the mail server, Postfix / Exim / Sendmail / 
whatever, to not actually attempt to deliver the messages which are sent 
by FreeSide.

I don't have an instance of FreeSide running.  I don't know what mail 
sending process it actually uses.  Most Unix software tries to use a 
local MTA on the machine such as Postfix, Exim, or Sendmail.

I know it would be pretty easy to convince Postfix to "hold" or drop all 
mail not bound for a specific domain.

It might be easier than messing with your database.


-- 
Scott Lambert                  KC5MLE                     Unix SysAdmin
lambert at lambertfam.org