cgi::session::driver::mysql(3pm) [debian man page]

CGI::Session::Driver::mysql(3pm)			User Contributed Perl Documentation			  CGI::Session::Driver::mysql(3pm)

NAME

       CGI::Session::Driver::mysql - CGI::Session driver for MySQL database

SYNOPSIS

	   $s = CGI::Session->new( 'driver:mysql', $sid);
	   $s = CGI::Session->new( 'driver:mysql', $sid, { DataSource  => 'dbi:mysql:test',
							  User	      => 'sherzodr',
							  Password    => 'hello' });
	   $s = CGI::Session->new( 'driver:mysql', $sid, { Handle => $dbh } );

DESCRIPTION

       mysql stores session records in a MySQL table. For details see CGI::Session::Driver::DBI, its parent class.

       It's especially important for the MySQL driver that the session ID column be defined as a primary key, or at least "unique", like this:

	CREATE TABLE sessions (
	    id CHAR(32) NOT NULL PRIMARY KEY,
	    a_session TEXT NOT NULL
	 );

       To use different column names, change the 'create table' statement, and then simply do this:

	   $s = CGI::Session->new('driver:mysql', undef,
	   {
	       TableName=>'session',
	       IdColName=>'my_id',
	       DataColName=>'my_data',
	       DataSource=>'dbi:mysql:project',
	   });

       or

	   $s = CGI::Session->new('driver:mysql', undef,
	   {
	       TableName=>'session',
	       IdColName=>'my_id',
	       DataColName=>'my_data',
	       Handle=>$dbh,
	   });

   DRIVER ARGUMENTS
       mysql driver supports all the arguments documented in CGI::Session::Driver::DBI. In addition, DataSource argument can optionally leave
       leading "dbi:mysql:" string out:

	   $s = CGI::Session->new( 'driver:mysql', $sid, {DataSource=>'shopping_cart'});
	   # is the same as:
	   $s = CGI::Session->new( 'driver:mysql', $sid, {DataSource=>'dbi:mysql:shopping_cart'});

   BACKWARDS COMPATIBILITY
       As of V 4.30, the global variable $CGI::Session::MySQL::TABLE_NAME cannot be used to set the session table's name.

       This is due to changes in CGI::Session::Driver's new() method, which now allows the table's name to be changed (as well as allowing both
       the 'id' column name and the 'a_session' column name to be changed).

       See the documentation for CGI::Session::Driver::DBI for details.

       In particular, the new syntax for "new()" applies to all database drivers, whereas the old - and bad - global variable method only applied
       to MySQL.

       Alternately, call $session -> table_name('new_name') just after creating the session object if you wish to change the session table's name.

LICENSING

       For support and licensing see CGI::Session.

perl v5.12.4							    2011-07-08					  CGI::Session::Driver::mysql(3pm)

CGI::Session::Driver::postgresql(3pm)			User Contributed Perl Documentation		     CGI::Session::Driver::postgresql(3pm)

NAME

       CGI::Session::Driver::postgresql - PostgreSQL driver for CGI::Session

SYNOPSIS

	   use CGI::Session;
	   $session = CGI::Session->new("driver:PostgreSQL", undef, {Handle=>$dbh});

DESCRIPTION

       CGI::Session::PostgreSQL is a CGI::Session driver to store session data in a PostgreSQL table.

STORAGE

       Before you can use any DBI-based session drivers you need to make sure compatible database table is created for CGI::Session to work with.
       Following command will produce minimal requirements in most SQL databases:

	   CREATE TABLE sessions (
	       id CHAR(32) NOT NULL PRIMARY KEY,
	       a_session BYTEA NOT NULL
	   );

       and within your code use:

	   use CGI::Session;
	   $session = CGI::Session->new("driver:PostgreSQL", undef, {Handle=>$dbh, ColumnType=>"binary"});

       Please note the ColumnType argument. PostgreSQL's text type has problems when trying to hold a null character. (Known as "" in Perl, not
       to be confused with SQL NULL). If you know there is no chance of ever having a null character in the serialized data, you can leave off the
       ColumnType attribute. Using a BYTEA column type and "ColumnType => 'binary'" is recommended when using Storable as the serializer or if
       there's any possibility that a null value will appear in any of the serialized data.

       To use different column names, change the 'create table' statement, and then simply do this:

	   $s = CGI::Session->new('driver:pg', undef,
	   {
	       TableName=>'session',
	       IdColName=>'my_id',
	       DataColName=>'my_data',
	       DataSource=>'dbi:pg:dbname=project',
	   });

       or

	   $s = CGI::Session->new('driver:pg', undef,
	   {
	       TableName=>'session',
	       IdColName=>'my_id',
	       DataColName=>'my_data',
	       Handle=>$dbh,
	   });

       For more details see CGI::Session::Driver::DBI, parent class.

       Also see sqlite driver, which exercises different method for dealing with binary data.

COPYRIGHT

       Copyright (C) 2002 Cosimo Streppone. All rights reserved. This library is free software and can be modified and distributed under the same
       terms as Perl itself.

AUTHORS

       Cosimo Streppone <cosimo@cpan.org>, heavily based on the CGI::Session::MySQL driver by Sherzod Ruzmetov, original author of CGI::Session.

       Matt LeBlanc contributed significant updates for the 4.0 release.

LICENSING

       For additional support and licensing see CGI::Session

perl v5.12.4							    2011-07-08				     CGI::Session::Driver::postgresql(3pm)