Thanks Dan. You beat me to it. :)
FWIW, I hope to get QMT to a point where vpopmail itself can be
implemented on its own host, and allow access via network connections
for all dependent packages (qmail, dovecot, vqadmin, qmailadmin). That's
going to take some doing, but will alleviate the need to have vpopmail
on multiple hosts when things are segmented.
You're moving in a good direction with your configuration. I'm looking
forward to your continued participation as QMT develops.
--
-Eric 'shubes'
On 12/04/2013 03:20 PM, Dan McAllister wrote:
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
