Script cannot find Apache-session-mysql

[seekperlwisdom]

hi monks,

i am learning session in Perl, when i tried to run the script, Top bit of the script is,

#!/usr/bin/perl -w

use strict;

#use DBI;

use CGI::Carp qw(fatalsToBrowser);

use CGI qw(:stanadard);

#use CGI::Session qw(-ip-match);

#use CGI::Session::Driver::mysql;

my $cgi = CGI->new();

my $ip = $cgi->remote_host();

my $sid = $cgi->cookie("CGISESSID") || undef;

use Apache::Session::MySql;

use Apache::Session;

my $session;

my %hash; 

tie %hash, 'Apache::Session::MySql',$sid,{

    DataSource => 'dbi:mysql:phones',

    UserName   => 'name',

    Password   => 'password',

    TableName  => 'sessions',

};

i received this message.

Can't locate Apache/Session/MySql.pm in @INC 
(@INC contains: 
/usr/lib/perl5/site_perl/5.10.0/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.10.0 
/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.10.0 
/usr/lib/perl5/5.10.0/i386-linux-thread-multi 
/usr/lib/perl5/5.10.0 
/usr/lib/perl5/site_perl 
/usr/lib/perl5/vendor_perl/5.8.8 
/usr/lib/perl5/vendor_perl .) at session1.pl line 11.
BEGIN failed--compilation aborted

whereas i can see visually the file Mysql.pm at /usr/lib/perl5/vendor_perl/5.10.0/Apache/Session

I dont know what to do. MCPAN tell me that it is update. thanks

[hominid]

Try

use Apache::Session::MySQL.

The case is important.

[seekperlwisdom]

thanks you are right stupid me but i am getting this message Can't connect to data source '' because I can't work out what driver to use (it doesn't seem to contain a 'dbi:driver:' prefix and the DBI_DRIVER env var is not set) at /usr/lib/perl5/vendor_perl/5.10.0/Apache/Session/Lock/MySQL.pm line 36

[toolic]

Wrong case? MySql should be MySQL?

use Apache::Session::MySql;
                        ||
                        vv
use Apache::Session::MySQL;

Apache::Session::MySQL

[seekperlwisdom]

thanks you are right stupid me but i am getting this message Can't connect to data source '' because I can't work out what driver to use (it doesn't seem to contain a 'dbi:driver:' prefix and the DBI_DRIVER env var is not set) at /usr/lib/perl5/vendor_perl/5.10.0/Apache/Session/Lock/MySQL.pm line 36

[seekperlwisdom]

thanks you are right stupid me but i am getting this message Can't connect to data source '' because I can't work out what driver to use (it doesn't seem to contain a 'dbi:driver:' prefix and the DBI_DRIVER env var is not set) at /usr/lib/perl5/vendor_perl/5.10.0/Apache/Session/Lock/MySQL.pm line 36