09-22-2005
tried all what ways?
Are you using an exceedingly new, or exceedingly old version of MySQL? Try upgrading, or downgrading.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How do i start linux without going straight into X window enviroment, but into the console instead, and also, how do i get back in ? (2 Replies)
Discussion started by: stealthdestroyr
2 Replies
2. UNIX for Advanced & Expert Users
Hiya All,
I can't fire up MySql on my FC-3 Server at work.
I get the Error message at the end of this post.
Looks like some Config problem on the Server itself. (Ie web server and MYSQL is all on the same box. I get the same errror when trying to fire up MYSQL at the Box, as well as... (2 Replies)
Discussion started by: marty 600
2 Replies
3. UNIX for Dummies Questions & Answers
hi guys,
pls help me to find out what is the latest version of linux that i can install in my pc or should i install fedora... (1 Reply)
Discussion started by: anankumar3
1 Replies
4. Solaris
I've been working on a project to replace one of the my group's primary NIS servers. It also runs mysql and apache, as it is the host for the our team's hardware tracking database and website. Its running apache 1.3, and for some odd reason, I can't get apache to start on system boot. The... (1 Reply)
Discussion started by: godspunk32
1 Replies
5. UNIX for Dummies Questions & Answers
Hi friends, Is FEDORA and REDHAT LINUX are same? (4 Replies)
Discussion started by: haisubbu
4 Replies
6. UNIX for Dummies Questions & Answers
I'm running a FreedBSD server with mysql 4.1. When I start mysqld via the command:
# /usr/local/bin/safe_mysqld --user=mysql
it starts the mysql db (I know because the websites are running off of it) but does not return to a prompt, it will let me type but will not respond unless I restart... (15 Replies)
Discussion started by: unispace
15 Replies
7. UNIX for Advanced & Expert Users
Can any of you Kind Experts out there plz tell me how to access NTFS partitions in Linux? This thing has been buggin me since my birth so to say.. :confused: Please oblige (2 Replies)
Discussion started by: srikumar_cs
2 Replies
8. Linux
hi i dont know much about linux but my boss gave me a job to backup all the mysql database and tables from fedora core4 running as web/database server. i can enter in fedora using remote desktop from my laptop but after that i am unable to do anything. if any one can help me in finding mysql and... (3 Replies)
Discussion started by: obstinate
3 Replies
9. Linux
Hi all
I am application Programmer.
In my college(2 yrs back) i have learnt Unix i.e commads, shell scripts, Filesystem,I reffered to a book by "Sumitabha Das".
I want to learn Linux.
But i cant understand where should i start from and which book to refer to.
Most of the books these days eg.... (2 Replies)
Discussion started by: FullMetal
2 Replies
10. Fedora
Hi,
i'm currently part of an apprenticeship becoming a IT specialist.
Because I'm already an electronic technician (finished apprenticeship) I can do this one in 2 years (normally you need 3).
Thing is, in school they started out with basic unix stuff (working with the shell) in the first... (3 Replies)
Discussion started by: Dr. Nick
3 Replies
LEARN ABOUT CENTOS
cgi::session::driver::mysql
CGI::Session::Driver::mysql(3) User Contributed Perl Documentation CGI::Session::Driver::mysql(3)
NAME
CGI::Session::Driver::mysql - CGI::Session driver for MySQL database
SYNOPSIS
$s = new CGI::Session( 'driver:mysql', $sid);
$s = new CGI::Session( 'driver:mysql', $sid, { DataSource => 'dbi:mysql:test',
User => 'sherzodr',
Password => 'hello' });
$s = new CGI::Session( '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 = new CGI::Session('driver:mysql', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
DataSource=>'dbi:mysql:project',
});
or
$s = new CGI::Session('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 = new CGI::Session( 'driver:mysql', $sid, {DataSource=>'shopping_cart'});
# is the same as:
$s = new CGI::Session( '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.16.3 2008-07-16 CGI::Session::Driver::mysql(3)