08-25-2005
Quote:
# perl Makefile.PL --libs="-L/usr/local/mysql/lib/mysql -L/usr/local/lib -lmysqlclient -lz -lposix4 -lgen -lsocket -lnsl -lm" --cflags=-I/usr/local/mysql/include/mysql/
Do you really need so many options? Most of the time, compiling without any option should be fine (you may need a few in case you would like to run the test suite before installing, but I will usually skip it), because the parameters are provided by mysql_config, which gives all the values needed.
May be we get back to the basics. Post what you see with
perl Makefile.PL
and the results of "make".
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I changed a few perl modules that it seems I should not have...
Any way that I can re-install perl from scratch? (1 Reply)
Discussion started by: frustrated1
1 Replies
2. Shell Programming and Scripting
I have a script that uses the File::Listing module. I am trying to install it, but I read the ReadMe and it states that the following modules should be installed first:
URI
MIME-Base64
HTML-Parser
libnet
Digest-MD5
Compress-Zlib
I am very new to Perl and would apprciate anyone's input on... (1 Reply)
Discussion started by: ssmiths001
1 Replies
3. Shell Programming and Scripting
I am trying to write a program that will use templates, so I figured I would use the Text::Template CPAN module...
...only problem is that I cant force my "clients" to install this module, cause they are clueless. Is there anyway that I can NOT install it for the whole machine, but install it... (1 Reply)
Discussion started by: jjinno
1 Replies
4. Shell Programming and Scripting
Hi, i have some queries on installing the Perl DBI and the DBD Oracle.
I know that i have to install the DBI first. I have the source files in a folder in my home directory.The commands to install arecd /home/DBI
Perl Makefile.PL
make
make installI would like to know, after executing these... (4 Replies)
Discussion started by: new2ss
4 Replies
5. Shell Programming and Scripting
Hi All,
When I tried to install Math::Pari module in a AIX 5.3 server,I am getting the following error.
# pwd
/usr/local/bin
# cd Math-Pari-2.010709
# perl Makefile.PL
Did not find GP/PARI build directory around.
Do you want to me to fetch GP/PARI automatically?
(If you do not, you... (2 Replies)
Discussion started by: surjithss
2 Replies
6. UNIX for Dummies Questions & Answers
I resulted to using /usr/sfw/bin/gmake to install my perl modules until i ran into a problem installing perl/Tk Tk-804.028
gmake: Entering directory `/export/home/Tk-804.028/pod'
Sorry no HTML building yet
gmake: Leaving directory `/export/home/Tk-804.028/pod'
I dont unstand what the error... (2 Replies)
Discussion started by: jameskay
2 Replies
7. Shell Programming and Scripting
Hi, experts,
I am trying to intall Perl/Tk module (Tk-804.028 ) into Perl5.6.1, however, the directory structure seems to be different from i386 than x86_64 and the installation keeps failing. Is this a known/common issue? Or does anyone has any workaround for this?
~* Dniz *~ (0 Replies)
Discussion started by: dniz
0 Replies
8. Red Hat
Hi All,
I have a customer asking me to install these perl modules on redhat 4 ent:
File::Temp
Getopt::Long
DBD::mysql
Mail::Mailer
DBD::DB2
Any idea how can I install those modules.
Thanks for any comment you may add. (3 Replies)
Discussion started by: itik
3 Replies
9. Shell Programming and Scripting
Hi,
I want to install WWW:Mechanize module.
Followed the following steps:
1. wget http://www.cpan.org/authors/id/C/CO/CORION/Bundle-
WWW-Mechanize-Shell-0.29.tar.gz
perl Makefile.PL
make
make test
make install (Got the below message)
Appending installation info to... (1 Reply)
Discussion started by: Anjan1
1 Replies
10. Shell Programming and Scripting
Hi,
I need to install Sys::HostAddr inorder to run the following command:
perl -le 'use Sys::Hostaddr; print Sys::HostAddr->new->main_ip'
I tried installing this package using CPAN by using the following command:
$ sudo perl -MCPAN -e shell
cpan> install Sys::HostAddr
But still I am... (2 Replies)
Discussion started by: royalibrahim
2 Replies
LEARN ABOUT DEBIAN
cgi::session::driver::mysql
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)