Default Mail scan settings for new users

[timehost]

Hello,

I think life would be easier for us (web admins) if ISPConfig by default activated virus and spam filters for each new created user. If a user does not want his / her email scanned, then they can log in and disable it. I assume this can be done using forms designer, but there was no documentation of it in the manuals.

[falko]

You could change the table definition for the table isp_isp_user from

CREATE TABLE `isp_isp_user` (
  `doc_id` bigint(20) NOT NULL auto_increment,
  `doctype_id` bigint(20) NOT NULL default '1014',
  `user_username` varchar(32) default NULL,
  `user_passwort` varchar(20) default NULL,
  `user_speicher` varchar(10) default NULL,
  `user_admin` char(1) default NULL,
  `user_shell` char(1) default NULL,
  `user_emailalias` text,
  `user_name` varchar(255) default NULL,
  `status` char(1) default NULL,
  `user_autoresponder` char(1) default NULL,
  `user_autoresponder_text` text,
  `user_mailquota` varchar(10) default NULL,
  `user_catchallemail` char(1) default '0',
  `user_mailscan` char(1) default NULL,
  `user_emailweiterleitung_local_copy` smallint(6) default NULL,
  `user_email` varchar(255) default NULL,
  `user_emailweiterleitung` text,
  `user_spamfilter` char(1) default NULL,
  `spam_strategy` varchar(255) NOT NULL default 'accept',
  `spam_hits` varchar(255) default '5.0',
  `spam_rewrite_subject` char(1) NOT NULL default '1',
  `spam_subject_tag` varchar(255) NOT NULL default '***SPAM*** ',
  `antivirus` char(1) NOT NULL default '0',
  `user_lang` char(2) NOT NULL default '',
  PRIMARY KEY  (`doc_id`),
  KEY `doctype_id` (`doctype_id`)
) TYPE=MyISAM;

to

CREATE TABLE `isp_isp_user` (
  `doc_id` bigint(20) NOT NULL auto_increment,
  `doctype_id` bigint(20) NOT NULL default '1014',
  `user_username` varchar(32) default NULL,
  `user_passwort` varchar(20) default NULL,
  `user_speicher` varchar(10) default NULL,
  `user_admin` char(1) default NULL,
  `user_shell` char(1) default NULL,
  `user_emailalias` text,
  `user_name` varchar(255) default NULL,
  `status` char(1) default NULL,
  `user_autoresponder` char(1) default NULL,
  `user_autoresponder_text` text,
  `user_mailquota` varchar(10) default NULL,
  `user_catchallemail` char(1) default '0',
  `user_mailscan` char(1) default NULL,
  `user_emailweiterleitung_local_copy` smallint(6) default NULL,
  `user_email` varchar(255) default NULL,
  `user_emailweiterleitung` text,
  `user_spamfilter` char(1) default '1',
  `spam_strategy` varchar(255) NOT NULL default 'accept',
  `spam_hits` varchar(255) default '5.0',
  `spam_rewrite_subject` char(1) NOT NULL default '1',
  `spam_subject_tag` varchar(255) NOT NULL default '***SPAM*** ',
  `antivirus` char(1) NOT NULL default '1',
  `user_lang` char(2) NOT NULL default '',
  PRIMARY KEY  (`doc_id`),
  KEY `doctype_id` (`doctype_id`)
) TYPE=MyISAM;

[stpe]

Where will it’s be best to edit the default value in web gui or in ispconfig database table isp_isp_user
I have change the value for spam, virus and user_speicher in table isp_isp_user.
Spam and virus is working but the user_speicer is still -1 and if I log in isp_isp_user form there is no change.

[till]

You will ahve to change the default values in the database and the form editor.