I'm running OS X Snow Leopard on a MacBook Pro. I've installed Mysql using Macports. MySQL works fine, but I need to install the DBI module. I've tried several ways, but I always get the following error: - install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /Library/Perl/Updates/5.10.0 /System/Library/Perl/5.10.0/darwin-thread-multi-2level /System/Library/Perl/5.10.0 /Library/Perl/5.10.0/darwin-thread-multi-2level /Library/Perl/5.10.0 /Network/Library/Perl/5.10.0/darwin-thread-multi-2level /Network/Library/Perl/5.10.0 /Network/Library/Perl /System/Library/Perl/Extras/5.10.0/darwin-thread-multi-2level /System/Library/Perl/Extras/5.10.0 .) at (eval 3) line 3.
-
Perhaps the DBD::mysql perl module hasn't been fully installed,
-
or perhaps the capitalisation of 'mysql' isn't right.
-
Available drivers: DBM, ExampleP, File, Gofer, Proxy, SQLite, Sponge.
-
at /Users/peterv/Perl1/db.pl line 7
-
What I'd like to know is how to display what @INC contains, and how to set it to the correct values. I've searched everywhere I could think of and have found nothing. One guy suggested that @INC is a path (seems reasonable) that's not pointing to where the DBD/mysql.pm is. I really need to fix this, so any help debugging this will be really appreciated!
4  4739  numberwhun 3,509
Recognized Expert Moderator Specialist
Did you try writing some code that uses DBI? Last time I checked, DBI was a core module that was distributed with Perl. You should not have to install it.
@INC is the Perl specific path variable that contains a list of the path's that Perl looks for modules. This is set at installation/compilation and cannot be changed.
Regards,
Jeff
Jeff,
Yes I did write a simple script using DBI, and it failed. I don't remember what the original error message was, since I've been installing & uninstalling things all weekend trying to get the thing to work. Currently, this is the error message I get: - peterv@MBP17.local<502>$: db.pl
-
install_driver(mysql) failed: Can't locate loadable object for module DBD::mysql in @INC (@INC contains: /opt/local/lib/perl5/site_perl/5.10.1/darwin-multi-2level /opt/local/lib/perl5/site_perl/5.10.1 /opt/local/lib/perl5/site_perl/5.8.9 /opt/local/lib/perl5/site_perl /opt/local/lib/perl5/vendor_perl/5.10.1/darwin-multi-2level /opt/local/lib/perl5/vendor_perl/5.10.1 /opt/local/lib/perl5/vendor_perl /opt/local/lib/perl5/5.10.1/darwin-multi-2level /opt/local/lib/perl5/5.10.1 .) at (eval 3) line 3
-
Compilation failed in require at (eval 3) line 3.
-
Perhaps a module that DBD::mysql requires hasn't been fully installed
-
at /Users/peterv/Perl1/db.pl line 8
-
-
Mon Apr 19 08:32:26 EDT 2010
-
I installed the DBD module manually, according to the directions from CPAN, and, unfortunately, the Makefile.PL script they provide for installation has errors in it. I'm currently trying to debug that. I'm probably going to need help with it though, as I'm a novice perl programmer.
Can anyone help me debug this output? I've followed all the installation instructions to the letter, and I'm still getting this error: - peterv@MBP17.local<506>$: sudo Perl Makefile.PL | tee makefile.log
-
tee: makefile.log: Permission denied
-
-
-
PLEASE NOTE:
-
-
For 'make test' to run properly, you must ensure that the
-
database user 'root' can connect to your MySQL server
-
and has the proper privileges that these tests require such
-
as 'drop table', 'create table', 'drop procedure', 'create procedure'
-
as well as others.
-
-
mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';
-
-
You can also optionally set the user to run 'make test' with:
-
-
perl Makefile.pl --testuser=username
-
-
Use of uninitialized value in printf at Makefile.PL line 175, <PIPE> line 102.
-
I will use the following settings for compiling and testing:
-
-
cflags (mysql_config) = -I/opt/local/mysql/include -g -Os -arch x86_64 -fno-common -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL
-
embedded (mysql_config) =
-
libs (mysql_config) = -L/opt/local/mysql/lib -lmysqlclient -lz -lm -lmygcc
-
mysql_config (guessed ) = mysql_config
-
nocatchstderr (default ) = 0
-
nofoundrows (default ) = 0
-
ssl (guessed ) = 0
-
testdb (default ) = test
-
testhost (default ) =
-
testpassword (default ) =
-
testsocket (default ) =
-
testuser ( ) = root
-
-
To change these settings, see 'perl Makefile.PL --help' and
-
'perldoc INSTALL'.
-
-
Multiple copies of Driver.xst found in: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI/ /System/Library/Perl/Extras/5.10.0/darwin-thread-multi-2level/auto/DBI/ at Makefile.PL line 748
-
Using DBI 1.608 (for perl 5.010000 on darwin-thread-multi-2level) installed in /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBI/
-
Writing Makefile for DBD::mysql
-
-
Mon Apr 19 09:43:29 EDT 2010
-
/Library/Perl/DBD-mysql-4.011 ->
-
peterv@MBP17.local<507>$: db.pl
-
install_driver(mysql) failed: Can't locate loadable object for module DBD::mysql in @INC (@INC contains: /opt/local/lib/perl5/site_perl/5.10.1/darwin-multi-2level /opt/local/lib/perl5/site_perl/5.10.1 /opt/local/lib/perl5/site_perl/5.8.9 /opt/local/lib/perl5/site_perl /opt/local/lib/perl5/vendor_perl/5.10.1/darwin-multi-2level /opt/local/lib/perl5/vendor_perl/5.10.1 /opt/local/lib/perl5/vendor_perl /opt/local/lib/perl5/5.10.1/darwin-multi-2level /opt/local/lib/perl5/5.10.1 .) at (eval 3) line 3
-
Compilation failed in require at (eval 3) line 3.
-
Perhaps a module that DBD::mysql requires hasn't been fully installed
-
at /Users/peterv/Perl1/db.pl line 8
-
-
Mon Apr 19 09:43:29 EDT 2010
-
Is there some better way to install this DBD module? is there ANY way to successfully install this thing? PLEASE I need help!
@numberwhun
Jeff, I'm still having massive problems with this. No matter how I install the DBI module, it's never in the @INC path. You said that that path is set upon installation. Is it set in the Perl installation? If so, would uninstalling Perl and resinstalling it reset it? Also, what's the best way to remove perl from OS X? If all else fails, I'm about ready to do a clean reinstall of OS X and start from scratch.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Slant |
last post by:
I have been using MySQL in conjunction with PHP for many years now...
I have been using the exact same method for not only connecting to a
database and performing the queries but also displaying the results.
I've been told numerous times that my methods are out-dated. I'm more
than willing to cede to this possibility but I need help getting out
of the rut!!! Can anyone help me?
Here are some examples:
|
by: john townsley |
last post by:
I cant get mysql to run on my winXP computer. I have downloaded it and
installed , unzipped and run setup.exe and placed it in c:\mysql.
I type the command to start the mysql server
c:\mysql\bin\mysqld --console
It opens the console and then the console shows some inoDB commands and the
console hangs.
I followed the mysql manual and i cant find the answer
there is no command prompt and nothing...how do I run mysql?
|
by: Rich |
last post by:
Hello,
I need to change the font size of a datagridview to accommodate a screen
resolution of 800x600. I know how to set the fontsize at runtime
datagridview1.Font = New Font("arial", 8, FontStyle.Regular)
But I would prefer to set this at the property sheet.
The datasource for the datagridview is a dataview that I use for filtering.
|
by: HugoFromBOSS |
last post by:
Hello, all this is starting to buy me the "make" compiler cant find "mysql.h" nor does "mysql.h" exisit on my system. I have tired searching for an answer on google but I cant understand any of them can somone post a quick how-to?
# find / -name mysql.h
#
# mysql_config --cflags --libs
-I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -D_GNU_SOURCE...
|
by: HugoFromBOSS |
last post by:
Hey,
I have compiled my application and it works fine connection to a MySQL database. When I move the application onto another computer It cant locate mySQL.h this is resolved by "yum install mysql-devel" however, how do I include MySQL in my project without the need to install mysql-devel on each machine I run my app on.
Thanks
| | |
by: Bob |
last post by:
Im setting up a fedora core 8 web server. Im currently running
everything on another fedora core 6 server (working fine). Ive
installed php 5.2.5 and apache 2.0.63
Im getting the following:
Warning: include_once() : Failed opening 'mysql.inc'
for inclusion (include_path='/home/jeff/src/soccer/php_inc') in /home/
http/soc/show.php on line 13
|
by: scorpionbilli |
last post by:
Hi,
The local mysql server is running on my Macbook. I can access it
through the console client:
$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.45 MySQL Community Server (GPL)
|
by: bthalapathi |
last post by:
I have written a script to connect the mysql db
#!/usr/bin/perl -w
use DBI;
#definition of variables
$db="MYTEST";
$host="localhost";
$user="root";
$password="rootpass";
|
by: lisles |
last post by:
i have a page funtion.php which hs the function to connect to the db
/* Mysql Connection */
function connect(){
global $db_server,$db_user,$db_pass,$db;//Global Values from the config.php
$conn = @mysql_connect($db_server,$db_user,$db_pass) or die("Connection to Database Server Failed");
@mysql_select_db($db) or die("Database Selection Failed");
return $conn;
}
|
by: Atli |
last post by:
What to discuss:
What is a "MySQL resource".
What causes the error.
How to fix it.
Common Newbie Pitfalls
This article is the second installment in a series of (hopefully) many, following Markus' first installment: 1: Headers Already Sent.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
