Hi,
I'm trying to setup Dspam with MySQL replication.
- We have two SMTP servers, each running its own Dspam and MySQL.
- I managed to set up MySQL master/slave replication.
- Dspam is working in the master.
However, here's what happens in the slave server (from sql.errors):
[01/29/2013 17:31:29] 26395: UPDATE command denied to user
'dspam'@'slave.example.com' for table 'dspam_stats': UPDATE
dspam_stats SET innocent_learned=innocent_learned+1 WHERE uid=10
(And likewise for other tables like dspam_token_data ).
It appears it's trying to write to its own SQL server? Am I
misunderstanding how MySQLWriteServer works? My
/etc/dspam.d/mysql.conf looks like this (in the slave):
MySQLServer /var/run/mysqld/mysqld.sock
# MySQLPort 3306
MySQLUser <dspamuser>
MySQLPass <localpass>
MySQLDb dspam
MySQLCompress true
MySQLReconnect true
# If you are using replication for clustering, you can also
specify a separate
# server to perform all writes to.
#
MySQLWriteServer master.example.com
MySQLWritePort 3306
MySQLWriteUser <dspamuser>
MySQLWritePass <remotepass>
MySQLWriteDb dspam
# MySQLCompress true
# MySQLReconnect true
I can log in manually to the MySQL server master.example.com with
<remotepass>, but from the logs it appears that DSpam is not even
trying to write remotely? Am I missing something obvious?
I'm running dspam 3.10.1 on debian stable.
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user
