Are you asking which module you should use? There are several solid ones for mod_perl, based on ticket access models. One question is whether or not you need to track session data, or just need to grant access.
Comment on Re: Writing a secure Apache Module mysql DB interface