Have a look at CGI::Application, especially at CGI::Application::Plugin::Authentication. Another good idea is to take pieces of wisdom from a Perl-driven forum, like YaBB.

Unfortunately, YaBB is plain-file-based,so it's source code will make little hep if you want to communicate with a SQL dtabase engine. But the source code of Ikonboard can help :)