seekperlwisdom has asked for the wisdom of the Perl Monks concerning the following question:

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

Replies are listed 'Best First'.
Re: Script cannot find Apache-session-mysql
by hominid (Priest) on Dec 08, 2009 at 19:08 UTC
    Try
    use Apache::Session::MySQL.
    The case is important.
      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
Re: Script cannot find Apache-session-mysql
by toolic (Bishop) on Dec 08, 2009 at 19:08 UTC
      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
Re: Script cannot find Apache-session-mysql
by seekperlwisdom (Acolyte) on Dec 08, 2009 at 19:14 UTC
    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