use Apache;
use Apache::Session::MySQL;
my $r = Apache->request();
my $cookie = $r->header_in('Cookie');
$cookie =~ s/SESSION_ID=(\w*)/$1/;
tie %session, 'Apache::Session::MySQL', $cookie,{
    DataSource => 'dbi:mysql:weblog',
    UserName   => $db_user,
    Password   => $db_pass,
    LockDataSource => 'dbi:mysql:weblog',
    LockUserName   => $db_user,
    LockPassword   => $db_pass,
};
my $session_cookie = "SESSION_ID=$session{_session_id};";
$r->header_out("Set-Cookie" => $session_cookie);