What is it:
 
  Susanin is home CDROM management system allowing you to keep track of all
your zillions CDs. It's implemented as set of Perl scripts working with MySQL
DBMS providing web interface, and as such is pretty platform neutral.



           How to set up (for Linux):

  - make sure MySQL, Apache, mod-perl for Apache, and DBI for Perl is installed

  - set correct charset for MySQL in /etc/my.cfg, in [mysqld] section, like 
    this: default-character-set=koi8_ru, and restart mysqld
 
  - create database named "cdrom" (or whatever is named in common.pl) using 
      mysql shell, and proper table
         
         CREATE DATABASE cdrom;
         CREATE TABLE cd(id         INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, 
                         created    DATETIME, 
                         type       VARCHAR(60), 
                         descr      TEXT,  
                         loc        INT,   
                         notes      text);
         ALTER TABLE cd ADD FULLTEXT (descr);
         GRANT ALL PRIVILEGES ON cdrom.cd TO susanin@localhost IDENTIFIED BY 'passwd';
	
         or whatever you'd like to see for username and password

  - mkdir $HTTP_DIR/cgi-bin/susanin

  - copy 'add' 'search' 'manage' 'common.pl'  to $HTTP_DIR/cgi-bin/susanin

  - edit top of common.pl to set up your configuration parameters

  - point your browser to http://localhost/cgi-bin/susanin/add and if 
    everything is OK you should be able to add entries to database

  
          Problems:

  - web interface is plain ugly, as I'm not web designer by any mean - 
    I'd appreciate contribution of better interface

  - as for search we use fulltext search feature of MySQL
    (http://www.mysql.com/doc/en/Fulltext_Search.html) all its limitation
    implies, most important one is minimal 4 symbols for search strings
    (in MySQL 4.x may be controled by 
     [mysqld]
     ft_min_word_len=3)