Yet Another GuestBook
Perl CSS JavaScript
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
cgi-bin
conf
data
htdocs
lib
templates
.gitignore
README

README

YAGB
Yet Another GuestBook

FEATURES

* CAPTCHA
  http://en.wikipedia.org/wiki/CAPTCHA

DEPENDENCIES

perl >= 5.10
Config::Tiny
DBI
DBD::SQLite / DBD::mysql / maybe another
GD::SecurityImage   (optional, for CAPTCHA)
CGI::Session        (optional, for CAPTCHA)
HTML::Parser
HTML::Template

INSTALL

Just copy to need dir

SETUP

* Create database
  for SQLite like:
    $ sqlite3 data/yagb.sqlite < conf/yagb.schema.sql
  for MySQL like:
    $ mysqladmin create yagb
    $ mysql -e "GRANT ALL PRIVILEGES ON yagb.* TO yagb@localhost IDENTIFIED BY 'password'"
    $ mysql -e "FLUSH PRIVILEGES"
    $ mysql -uyagb -ppassword yagb < conf/yagb.schema.sql
    $ mysql -uyagb -ppassword yagb -e "ALTER TABLE yagb_messages MODIFY id SERIAL"

* Copy conf/yagb.conf.exmaple to conf/yagb.conf
  and edit it

* Setup apache
  Copy conf/yagb.httpd.conf.example to /path/to/apache/conf/yagb.httpd.conf
   (or paste to httpd.conf) and edit it

* Permissions
  If you use SQLite DB you make sure set write permission for webserver user at 'data/yagb.sqlite' and data dir.
  You set permissions like:
    $ chgrp -R www data && chmod 775 data && chmod 664 data/yagb.sqlite
  or
    $ chown -R www data && chmod 755 data && chmod 644 data/yagb.sqlite
  or
    $ chmod -R 777 data && chmod 666 data/yagb.sqlite