This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
Subject: DBI MySQL installation
From: Valery <igwt@mdl.net>
Date: Mon, 03 Jul 2000 20:14:26 -0200
Hello gurus,
I've installed DBI module and MySQL & MySQL 3.22.32. Now I'm trying to
make Msql-MySQL-module and it prompts for usr/local/include/mysql.h file
and doesn't find it. What should I do to resolve. BTW command mysql from
bash doesn't work either while mysqld daemon is active.
TIA, Val.
===
Subject: installation of DBI and DBD
From: "E BERNARDET" <ebernardet@itlink.fr>
Date: Mon, 26 Jun 2000 15:53:53 +0200
Hi,
as it's a long time I'm now trying to make perl and mysql work together, and as it's getting worse, I'd like some information that I did'nt find exactly :
I have the following paths :
/usr/lib/perl5/perl5.005003 installed via linux redhat 6.2
/usr/local/mysql-3.22.32 installed via a downloaded tarball source on http://www.mysql.com/download_3.22.html
I'd like to know where it's preferable to install the different modules( downloaded on http://www.mysql.com/download_perl.html ) ?
Data-dumper (in the manual it's written "in the current path" ...?)
data-showtable
DBI 1.13
mysql-modules 1.2018 or mysql-modules 1.2209 (which one is best ?)
===
Subject: MySQL remote connection
From: Fran T Bridges <bridges@ziggy.acns.fsu.edu>
Date: Wed, 28 Jun 2000 10:27:29 -0400 (EDT)
Hello
I am trying to connect to a remote MySQL db with DBI. I have working
scripts in production that connect to a db on the local host.
I am getting the following error - does anyone have any words of
wisdom?
Thanks!!
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503 /usr/local/lib/perl5/site_perl/5.005/sun4-solaris /usr/local/lib/perl5/site_perl/5.005 .) at (eval 1) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: ADO, ExampleP, Oracle, Proxy.
at ./list-remote line 26
Here is my code:
use DBI;
my $database_name = "my_db";
my $location = "somewhere.at.fsu.edu";
my $port_num = "3306";
my $database = "DBI:mysql:$database_name:$location:$port_num";
my $db_user = "-----";
my $db_passwd = "----------";
$dbh = DBI->connect($database, $db_user, $db_passwd);
if ( !defined $dbh ) {
die "Cannot connect to database server: $DBI::errstr\n";
}
===
Subject: RE: MySQL remote connection
From: Ilya Sterin <ideas_pc@usa.com>
Date: Wed, 28 Jun 2000 10:36:04 -0400 (EDT)
Are you running this script on the same machine as woking script?
Looks like you don't have MySQL driver installed. If it is installed under
a different directory then @INC contains you have to add it to @INC. Also
what OS are you using?
===
Subject: Re: MySQL remote connection
From: Ilya Sterin <ideas_pc@usa.com>
Date: Wed, 28 Jun 2000 11:46:02 -0400 (EDT)
I am not positive, but the DBD::mysql docs suggest the connection syntax as
follows:
$dbh = DBI->connect(DBI:mysql:attr, username, password, {attr})
where attribute are key=value and separated by a semicolon
you are using: $dbh = DBI->connect($database, $db_user, $db_passwd);
try this
my $database_name = "my_db";
> my $location = "somewhere.at.fsu.edu";
> my $port_num = "3306";
$dbh =
DBI->connect(DBI:mysql:database=$database_name;host=$location:$port_num,
$db_user, $db_passwd);
Hope this helps, also host is defaulted to localhost, and I am not sure
about the port number but try the above.
===
Subject: Re: MySQL remote connection
From: "Erich L. Markert" <emarkert@pace.edu>
Date: Wed, 28 Jun 2000 13:35:12 -0400
Also check to make sure that you've granted permissions in MySQL for
this host to connect to the database. Check out the GRANT command in
MySQL.
===
Subject: Problems installing mysql 3.22.32 and DBD::mysql
From: Lael Heinig <lael@luckysurf.com>
Date: Fri, 30 Jun 2000 11:43:29 -0700
I am having problems installing mysql 3.22.32 and DBD::mysql. I
installed DBI 1.14 and then tried to install DBD::mysql 1.2214. When
running perl Makefile.PL I get the question:
Where is your MySQL installed? Please tell me the directory that
contains the subdir 'include'. [/usr/local]
This is looking for mysql.h. I don't have it because I installed MySQL
via rpm instead of source. At least I think that is the reason. In an
attempt to fix this problem, I removed MySQL and tried to reinstall it.
Now when I try to install the rpms I get:
% rpm -iv MySQL-3.22.32-1.i386.rpm
error: failed dependencies:
/usr/bin/perl is needed by MySQL-3.22.32-1
I have a version of perl sitting in /usr/bin:
% /usr/bin/perl -v
This is perl, v5.6.0 built for i386-linux-thread
............
What should I do? Does it not recognize the new version of Perl? BTW,
I'm running Linux 6.1.
===
Subject: Re: Problems installing mysql 3.22.32 and DBD::mysql
From: John Peacock <JPeacock@UnivPress.com>
Date: Fri, 30 Jun 2000 14:58:21 -0400
Two things: if you need the include files for mysql, you will need to
install the development RPM as well as the regular. You should find it
at the same location you got the RPM you want (should be named something
like MySQL-3.22.32-1-src.i386.rpm).
The other thing is that if you installed Perl from source, rather than
RPM, there is no way for the rpm database to know you have Perl already.
Go figure! If that is the only thing you are missing, then you can
always
do:
rpm --force -iv MySQL-3.22.32-1.i386.rpm
to force the installation.
You can do an "rpm -qRp MySQL-3.22.32-1.i386.rpm" to get the list of
requirements. Alternatively, you can build your own mysql from the
source; it is very straightforward.
===
Subject: Re: Problems installing mysql 3.22.32 and DBD::mysql
From: Miles Thompson <milesthompson@sprint.ca>
Date: Fri, 30 Jun 2000 17:45:56 -0300
There is a devel rpm for mysql. You could also get the
source and build from source; be aware that files end up in
different locations depending on whether you install from an
RPM or build from source.
===
Subject: RE: Basics of MySQL
From: Frank Peng <frank_peng_01@yahoo.com>
Date: Mon, 3 Jul 2000 09:19:47 -0700 (PDT)
I remember I compiled MySQL, DBI and DBD-mSQL-MySQL.
Go MySQL's site, you can find DBI and DBD for it. If
it does not work, try to compile MySQL then compile
DBI and DBD.
They are working pretty well on my Linux machine with
Perl5.0005_03, MySQL 3.22.32, DBD1.13 and
Msql-Mysql-modules-1.2209.
===