How to edit sender hostname in sql

Use this forum for all questions related to bounce management of OpenEMM

Moderator: moderator

nodetx
Posts: 2
Joined: Sat Apr 16, 2011 6:05 pm

How to edit sender hostname in sql

Post by nodetx » Sat Apr 16, 2011 6:22 pm

I followed the install instructions, but once completed the set up I noticed that I had put a http:// in front of my sender host name by accident. I am looking for a way to correct this without having to reload the openemm-6.2.sql back into the db. My sql skills are poor at best. This is a headless server running Ubuntu 10.04 LTS if that helps. I don't want to loose any of the changes I have made. Any help or documentation will be greatly appreciated. Thanks.

nodetx
Posts: 2
Joined: Sat Apr 16, 2011 6:05 pm

Re: How to edit sender hostname in sql

Post by nodetx » Sat Apr 16, 2011 8:57 pm

If you would like to change the mailloop_domain in sql for any reason. This is your sender host name in the install documentation. The example host name they use is news.openemm.org . If you would like to change this after initial set up, use these commands.

mysql -u root openemm

update company_tbl set mailloop_domain="news.yourserver.com";

Post Reply