Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 25th October 2007, 11:47
l.ansaloni l.ansaloni is offline
Junior Member
 
Join Date: Oct 2007
Location: Italy - Modena
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default DSPM WebUI + MySQL preferences

Hi,
I install and configure an ISP-style mailserver with postfix+dovecot+dspam and virtual user upon MySQL databases.

In particular I use this two howto:I use a debian etch and the DSPAM installed package are:
Code:
dspam 3.6.8-5
dspam-doc 3.6.8-5
dspam-webfrontend 3.6.8-5
libdspam7 3.6.8-5
libdspam7-drv-mysql 3.6.8-5
I configure DSPAM to save the preferences of each user on MySQL dspam database, as You can see in /etc/dspam/dspam.conf:
Code:
Home /var/spool/dspam
StorageDriver /usr/lib/dspam/libmysql_drv.so
#TrustedDeliveryAgent "/usr/sbin/sendmail"
DeliveryHost 127.0.0.1
DeliveryPort 10026
DeliveryIdent localhost
DeliveryProto SMTP
Trust root
Trust dspam
Trust vmail
Debug *
DebugOpt process spam fp
TrainingMode teft
Algorithm graham burton
PValue graham
AllowOverride trainingMode
AllowOverride spamAction spamSubject
AllowOverride statisticalSedation
AllowOverride enableBNR
AllowOverride enableWhitelist
AllowOverride signatureLocation
AllowOverride showFactors
AllowOverride optIn optOut
AllowOverride whitelistThreshold
Opt out
TrackSources spam virus
ParseToHeaders on
ChangeModeOnParse on
ChangeUserOnParse off
ClamAVPort     3310
ClamAVHost     127.0.0.1
ClamAVResponse reject
ServerPID /var/run/dspam.pid
ServerMode auto
ServerPass.Relay1 "secret"
ServerParameters "--deliver=innocent"
ServerIdent "prometeo-steelform.steelform.lan"
ServerDomainSocketPath "/var/spool/postfix/var/run/dspam.sock"
ClientHost /var/spool/postfix/var/run/dspam.sock
ClientIdent "secret@Relay1"
MySQLServer       /var/run/mysqld/mysqld.sock
MySQLUser         dspam
MySQLPass         <password>
MySQLDb           dspam
MySQLConnectionCache    10
MySQLVirtualTable          dspam_virtual_uids
MySQLVirtualUIDField       uid
MySQLVirtualUsernameField  username
MySQLUIDInSignature    on
If I set the preferences using dspam_admin the preferences are correctly saved into MySQL database.
For example if I give the command:
Code:
# dspam_admin add preference admin@mydomain.lan trainingMode TEFT
into mysql log I watch this:
Code:
071025 10:27:37      65 Connect     dspam@localhost on dspam
                     65 Query       select uid from dspam_virtual_uids where username = 'admin@mydomain.lan'
                     65 Query       insert into dspam_virtual_uids (uid, username) values(NULL, 'admin@mydomain.lan')
                     65 Query       select uid from dspam_virtual_uids where username = 'admin@mydomain.lan'
                     65 Query       delete from dspam_preferences where uid = 2 and preference = 'trainingMode'
                     65 Query       insert into dspam_preferences (uid, preference, value) values(2, 'trainingMode', 'TEFT')
As You can see it create the user in the virtual table and then set the preferences for the user.

But when i use the WebUI to display preferences it load and save the users preferences into file in the folder /var/spool/dspam/data/ and not into MySQL.
How can force the WebUI to use MySQL?
Reply With Quote
Sponsored Links
  #2  
Old 3rd November 2008, 20:15
NothingHere NothingHere is offline
Junior Member
 
Join Date: Oct 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

I've just read your post, and I have same problem.

I think 1 year later you have solved your problem ... how ?

Thanks,
Reply With Quote
  #3  
Old 8th November 2008, 16:42
l.ansaloni l.ansaloni is offline
Junior Member
 
Join Date: Oct 2007
Location: Italy - Modena
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Hi,
you really are unlucky.

I tried the system a ago, and since not working, I left to lose.
I also would be very happy if someone tell us where we were wrong.

The system that still use is based on postgrey + spamassassin.

By,
Lorenzo
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 17:03
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 17:37
I'm dying! m u r Installation/Configuration 41 17th September 2006 13:44
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 17:37.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.