OK, I found my own answer:
Since all I'm working with is the qmail-toaster smtp daemon, and it
uses vpopmail for auth, I found the database connection specified in
/home/vpopmail/etc/vpopmail.mysql
I changed the first 2 entries, so it reads instead:
server_address|3306|vpopmail|SsEeCcRrEeTt|vpopmail
Then, I went over to the actual MySQL server and did 2 things: first, I
enabled the MySQL ports in through the iptables firewall, then I
permitted the remote server to query the database (but ONLY query it!)
mysql -u root -p<password>
grant select on vpopmail.* to 'vpopmail'@'remote_address'
identified by 'SsEeCcRrEeTt';
NOTE: If you haven't previously, you should change the vpopmail default
password AWAY from "SeEeCcRrEeTt" :)
That should do it!
Dan
On 12/4/2013 4:02 PM, Dan McAllister wrote:
Greetings all:
I have 2 QMT servers that need to share a SQL (user) database. I have
tried synching them, but when the synch gets lost all hell breaks
loose and it makes me look bad. What I'd really like to do is to allow
(through IPTables) for the main mail server (where all inbound mail is
delivered) to share the MySQL ports with the outbound mail server
(accepts mail only on submission and smtps ports -- not port 25 -- and
delivers it as necessary -- including, potentially back to the primary
mail server -- for which there are special routing rules in smtproutes).
So, in order to do what I think I want to do, I need the smtpauth
(qmail-auth, vpopmail auth, or whatever) to connect to an external
MySQL database server.
How would I go about doing this?
Thanks,
Dan McAllister
--
IT4SOHO, LLC
33 - 4th Street N, Suite 211
St. Petersburg, FL 33701-3806
CALL TOLL FREE:
877-IT4SOHO
877-484-7646 Phone
727-647-7646 Local
727-490-4394 Fax
We have support plans for QMail!
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
