Page 1 of 1

How to edit sender hostname in sql

Posted: Sat Apr 16, 2011 6:22 pm
by nodetx
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.

Re: How to edit sender hostname in sql

Posted: Sat Apr 16, 2011 8:57 pm
by nodetx
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";