MG's Notes

if you get something like this:

error: Bad exit status from /var/tmp/rpm-tmp.64195 (%build)

i found a solution:

go to /usr/src/redhat/SOURCES/ and you will find:

-rw-r–r– 1 root root 196944 2006-11-10 02:14 simscan-1.3.1.tar.bz2
-rw-r–r– 1 root root 256 2007-01-12 02:22 simscan-1.3.x-clamav.patch.bz2

unpack simscan-1.3.1.tar.bz2 to a directory, unpack simscan-1.3.x-clamav.patch.bz2 to the same directory and apply patch:

patch -p 0 < simscan-1.3.x-clamav.patch

now let’s compile by hand:

#./configure –enable-user=clamav –enable-clamav=y –enable-spam=y –enable-spam-passthru=n –enable-per-domain=y –enable-ripmime –enable-attach=y –enable-received=y –enable-clamdscan=/usr/bin/clamdscan –enable-clamavdb-path=/usr/share/clamav/ –enable-custom-smtp-reject=y –enable-spam-hits=20 –enable-workdir=/var/qmail/simscan/ –enable-controldir=/var/qmail/control/ –enable-received=y

#make
#make install-strip
#cd /var/qmail/control/; touch simcontrol;

edit file simcontrol and add:

:clam=yes,spam=yes,spam_hits=10,attach=.mp3:.src:.bat:.pif:.exe

#chown clamav.root simcontrol
#qmailctl cdb

and now you must have in /var/qmail/control/ this files:

-rw-r–r– 1 clamav root 64 2008-07-16 14:05 simcontrol
-rw-r–r– 1 root root 2134 2008-07-16 14:05 simcontrol.cdb
-rw-r–r– 1 root root 2164 2008-07-16 14:05 simversions.cdb

and in /var/qmail/bin/:

-rws–x–x 1 clamav root 27032 2008-07-16 17:03 /var/qmail/bin/simscan
-rwxr-xr-x 1 root root 13120 2008-07-16 17:03 /var/qmail/bin/simscanmk

I hope this is ok!

written by MG \\ tags: simscan

#!/bin/bash
#destination directory named with daily date
DIR=”/var/backup/mysql/$(date +%m%d%Y)”
if [ -d $DIR ]; then
    echo “Dir $DIR exists”;
else
    echo “Creating $DIR”;
    mkdir $DIR
fi

USER=”root”
ROOT_PASSWORD=”root_password”

#get list of databases
LIST=`mysql -u $USER -p$ROOT_PASSWORD -e”show databases” -s |egrep -v ‘Database|information_schema|mysql|temp’`

Continue reading »

written by MG \\ tags: backup, Linux, MySql

NTFS is a great filesystem, but its feature-set comes at a slight cost in performance. You can negate this a little with the following tips:

* By default NTFS will automatically update timestamps whenver a directory is traversed. This isn’t a necessary feature, and it slows down large volumes.

Disable it by pointing regedit to:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem and set ‘DisableNTFSLastAccessUpdate’ to 1.

* NTFS uses disparate master file control tables to store filesystem information about your drives. Over time these core MFT files grow and become fragmented, slowing down all accesses to the drive. By setting aside a little space, MFT’s can grow without becoming fragmented. In the same key where you disabled the last access feature creat a new DWORD value called ‘NtfsMftZoneReservation’ and set it to 2.

written by MG \\ tags: ntfs

Click on the start button and select run. Then type in “osk” in the box and click OK.

written by MG \\ tags: Windows

Ggo into registry with REGEDIT.EXE, go to

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer\

and (if not already there) add DWORD (without quotes) “NoLowDiskSpaceChecks” and change the value to 1. Restart.

written by MG \\ tags: LowDiskSpace

Go to Start –> Run and type Regedit
Navigate to:

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control

Click on the “Control” Folder.
In the right window you will see this key WaitToKillServiceTimeout
Double click that key and set it a value
lower than 2000, we set it to 100. Reboot.

written by MG \\ tags: registry, shutdown, Windows

One feature that I can do without is error reporting. Every time a program crashes I do not want to send a report to microsoft. Read below to find out how to disable this feature.

1. Open Control Panel
2. Click on Preformance and Maintenance.
3. Click on System.
4. Then click on the Advanced tab
5. Click on the error reporting button on the bottom of the windows.
6. Select Disable error reporting.
7. Click OK
8. Click OK

written by MG \\ tags: error reporting