[LibClamAV] Detected duplicate databases


  • administrators

    Duplicate database error from clamd:

    [LibClamAV] Detected duplicate databases /var/lib/clamav/daily.cld and /var/lib/clamav/daily.cvd. The /var/lib/clamav/daily.cld database is older and will not be loaded, you should manually remove it from the database directory.
    

    The message explains which database is older, however it’s always best practice to have a look for yourself.

    cd /var/lib/clamav/
    
    ls -l
    
    total 579308
    -rw-r--r-- 1 clam clam    766976 Jan 24 05:55 bytecode.cld
    -rw-r--r-- 1 clam clam 131058688 Jan 24 03:15 daily.cld
    -rw-r--r-- 1 clam clam  44118560 Jan 24 05:55 daily.cvd
    -rw-r--r-- 1 clam clam 307499008 Jan 24 05:54 main.cld
    -rw-r--r-- 1 clam clam 109143933 Jun 13  2016 main.cvd.rpmnew
    -rw------- 1 clam clam       156 Jan 24 05:55 mirrors.dat
    
    

    Look at the time as well as the date.

    rm -rf daily.cld
    
    total 451188
    -rw-r--r-- 1 clam clam    766976 Jan 24 05:55 bytecode.cld
    -rw-r--r-- 1 clam clam  44118560 Jan 24 05:55 daily.cvd
    -rw-r--r-- 1 clam clam 307499008 Jan 24 05:54 main.cld
    -rw-r--r-- 1 clam clam 109143933 Jun 13  2016 main.cvd.rpmnew
    -rw------- 1 clam clam       156 Jan 24 05:55 mirrors.dat
    

    Restart clamd

    service clamd restart
    

    fin!


 



  • Make ISO from DVD

    In this case I had an OS install disk which was required to be on a virtual node with no optical drive, so I needed to transfer an image to the server to create a VM

    Find out which device the DVD is:

    lsblk

    Output:

    NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sda 8:0 0 465.8G 0 disk ├─sda1 8:1 0 1G 0 part /boot └─sda2 8:2 0 464.8G 0 part ├─centos-root 253:0 0 50G 0 lvm / ├─centos-swap 253:1 0 11.8G 0 lvm [SWAP] └─centos-home 253:2 0 403G 0 lvm /home sdb 8:16 1 14.5G 0 disk /mnt sr0 11:0 1 4.1G 0 rom /run/media/rick/CCSA_X64FRE_EN-US_DV5

    Therefore /dev/sr0 is the location , or disk to be made into an ISO

    I prefer simplicity, and sometimes deal with the fallout after the fact, however Ive repeated this countless times with success.

    dd if=/dev/sr0 of=win10.iso

    Where if=Input file and of=output file

    I chill out and do something else while the image is being copied/created, and the final output:

    8555456+0 records in 8555456+0 records out 4380393472 bytes (4.4 GB) copied, 331.937 s, 13.2 MB/s

    Fin!

    read more
  • Recreate postrgresql database template encode to ASCII

    UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';

    Now we can drop it:

    DROP DATABASE template1;

    Create database from template0, with a new default encoding:

    CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UNICODE'; UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1'; \c template1 VACUUM FREEZE;

    read more
});