Default Mail scan settings for new users

Discussion in 'Installation/Configuration' started by timehost, Dec 31, 2005.

  1. timehost

    timehost New Member

    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.
     
  2. falko

    falko Super Moderator Howtoforge Staff

    You could change the table definition for the table isp_isp_user from
    Code:
    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,
      [B][COLOR="Red"]`user_spamfilter` char(1) default NULL,[/COLOR][/B]
      `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*** ',
      [B][COLOR="Red"]`antivirus` char(1) NOT NULL default '0',[/COLOR][/B]
      `user_lang` char(2) NOT NULL default '',
      PRIMARY KEY  (`doc_id`),
      KEY `doctype_id` (`doctype_id`)
    ) TYPE=MyISAM;
    to

    Code:
    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,
      [B][COLOR="Red"]`user_spamfilter` char(1) default '1',[/COLOR][/B]
      `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*** ',
      [B][COLOR="Red"]`antivirus` char(1) NOT NULL default '1',[/COLOR][/B]
      `user_lang` char(2) NOT NULL default '',
      PRIMARY KEY  (`doc_id`),
      KEY `doctype_id` (`doctype_id`)
    ) TYPE=MyISAM;
     
  3. stpe

    stpe New Member

    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.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

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

Share This Page