Reliable Penguin - Blog Reliable Penguin

Email alerts with Sophos virus scanner

By admin on January 24, 2008 in Misc

I have looked through the Sophos configuration options and below is a list of commands that you can preform to get proper e-mail alerts:

/opt/sophos-av/bin/savconfig SendErrorEmail true
/opt/sophos-av/bin/savconfig SentThreatEmail true
/opt/sophos-av/bin/savconfig EmailNotifier true
/opt/sophos-av/bin/savconfig EmailDemandSummaryIfThreat true
/opt/sophos-av/bin/savconfig Email your@emailaddress.com

/opt/sophos-av/bin/savconfig SendErrorEmail true

/opt/sophos-av/bin/savconfig SentThreatEmail true

/opt/sophos-av/bin/savconfig EmailNotifier true

/opt/sophos-av/bin/savconfig EmailDemandSummaryIfThreat true

/opt/sophos-av/bin/savconfig Email your@emailaddress.com

To remove an email address from the list:

/opt/sophos-av/bin/savconfig delete Email yoursecond@emailaddress.com

1	/opt/sophos-av/bin/savconfig delete Email yoursecond@emailaddress.com

You can repeat the Email command above with a single email address and until you delete that new email using the delete command it will remain, so you can add multiple addresses at different times (the first time, add your address, then later add another technical addy.)

Disable on-access scanning with Sophos

By admin on January 23, 2008 in Misc

To disable the on-access scanning in Sophos for now with this command:

/opt/sophos-av/bin/savdctl disable

1	/opt/sophos-av/bin/savdctl disable

It can later be re-enabled with this command:

/opt/sophos-av/bin/savdctl enable

1	/opt/sophos-av/bin/savdctl enable

As for checking for what Sophos has been doing lately, the log files are located in the following path:

/opt/sophos-av/log

1	/opt/sophos-av/log

As for further documentation, there are man pages for most of the various Sophos binaries that you can find in /opt/sophos-av/bin so you should be able to view the man page for them with “man savdctl” or whichever binary you need to look at.

Add RBL to Postfix

By admin on January 22, 2008 in Email

Add the following line to the bottom of /etc/postfix/main.cf or extend the existing smtpd_client_restrictions line:

smtpd_client_restrictions = reject_rbl_client sbl.spamhaus.org, reject_rbl_client bl.spamcop.net

1	smtpd_client_restrictions = reject_rbl_client sbl.spamhaus.org, reject_rbl_client bl.spamcop.net

MySQL Import Problem – Autoincrement

By admin on September 26, 2007 in MySQL

Trying to dump and import a mysql database from an old MySQL 3.x server to a 4.x server. Here’s an exerpt from the dump file:

DROP TABLE IF EXISTS ds_categories;
CREATE TABLE ds_categories (
catID int(11) NOT NULL auto_increment,
catName varchar(80) default NULL,
catDesc text NOT NULL,
catPhoto varchar(200) NOT NULL default '',
catPhotoWidth int(11) NOT NULL default '0',
catPhotoHeight int(11) NOT NULL default '0',
PRIMARY KEY  (catID),
UNIQUE KEY catID (catID)
) TYPE=MyISAM;

INSERT INTO ds_categories VALUES (0,'DEFAULT','','',0,0);
INSERT INTO ds_categories VALUES (1,'Products','','',0,0);

DROP TABLE IF EXISTS ds_categories;

CREATE TABLE ds_categories (

catID int(11) NOT NULL auto_increment,

catName varchar(80) default NULL,

catDesc text NOT NULL,

catPhoto varchar(200) NOT NULL default '',

catPhotoWidth int(11) NOT NULL default '0',

catPhotoHeight int(11) NOT NULL default '0',

PRIMARY KEY (catID),

UNIQUE KEY catID (catID)

) TYPE=MyISAM;

INSERT INTO ds_categories VALUES (0,'DEFAULT','','',0,0);

INSERT INTO ds_categories VALUES (1,'Products','','',0,0);

What’s happening, is when it inserts the first row, it’s
auto-incrementing the key value to 1, so the next row that tries to
import gets a “Duplicate entry ‘1’ for key 1” error.

The solution was to add the following line to the top of your sql dump file:

SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';

1	SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';

Later versions of mysql do this automatically.

Problem is the first insert tries to put a 0 into the autoincrement
field. Normal behavior is for the 0 to be converted to the next
available increment which is one. Then the second row fails because
there is already a 1 in the table. The mode setting above tells mysql to
allow the 0 in the auto increment field.

Nameserver check script

By admin on August 4, 2007 in Apache

#!/usr/bin/perl

my @allnameserver;

while (&lt;STDIN&gt;) {
        chomp();
        $domain = $_;
        $ns = `whois $domain | grep -A 4 "Domain servers" | grep -v "Domain servers"`;
        chomp($ns);
        @nameservers = split(/\n/,$ns);

        print $domain . "\n";
        foreach $n (@nameservers) {
                chomp($n);
                $n =~ s/(\s*)(\S+)(\s*)/$2/gm;
                if ($n =~ /\s+/) {

                } else {
                        if ($n ne "") {
                                $n = lc($n);
                                push(@allnameserver,$n);
                                print "\t" . $n . "\n";
                        };
                };
        };
};

print "\nALL NAMESERVERS\n";
print "==================\n";
foreach $n (@allnameserver) {
        print $n . "\n";
};

#!/usr/bin/perl

my @allnameserver;

while (<STDIN>) {

chomp();

$domain = $_;

$ns = `whois $domain | grep -A 4 "Domain servers" | grep -v "Domain servers"`;

chomp($ns);

@nameservers = split(/\n/,$ns);

print $domain . "\n";

foreach $n (@nameservers) {

chomp($n);

$n =~ s/(\s*)(\S+)(\s*)/$2/gm;

if ($n =~ /\s+/) {

} else {

if ($n ne "") {

$n = lc($n);

push(@allnameserver,$n);

print "\t" . $n . "\n";

};

print "\nALL NAMESERVERS\n";

print "==================\n";

foreach $n (@allnameserver) {

print $n . "\n";

};

← Previous 1 … 64 65 66 … 85 Next →

Need help immediately?

$100/hour
Satisfaction Guaranteed

Top Nav

Navigation

Reliable Penguin - Blog

Email alerts with Sophos virus scanner

Disable on-access scanning with Sophos

Add RBL to Postfix

MySQL Import Problem – Autoincrement

Nameserver check script