install driver failed

am 29.08.2003 03:47:58 von Matt Lyon

I am getting an error message:

install_driver(mysql) failed: Can't locate loadable object for module
DBD::mysql in @INC (@INC contains: /home/httpd/lampwebhosting.com/WebGUI/lib
/usr/lib/perl5/5.8.0/i586-linux /usr/lib/perl5/5.8.0
/usr/lib/perl5/site_perl/5.8.0/i586-linux /usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i586-linux
/usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at (eval 15)
line 3
Compilation failed in require at (eval 15) line 3.
Perhaps a module that DBD::mysql requires hasn't been fully installed
at /home/httpd/lampwebhosting.com/WebGUI/lib/WebGUI/Session.pm line 392

I have been nosing around in my system and am noticing some differences in
files. I traced down the above paths and found in
/usr/lib/perl/site-perl/5.8.0/i586-linux/ is a file called Mysql.pm

In that directory is also a Direcoty Mysql. There is also a Direcory and
file for DBI and DBI.pm (amont others). The odd part is the file
permissions. I had a different umask set at the times of installations. The
Directory Mysql is chmod 700 while the file Mysql.pm is chmod 555. The
Directory DBI is chmod 755 and the file DBI.pm is chmod 444. All other perl
modules I installed with the CPAN shell but installed DBD::Mysql manualy
because of an incomplete mysql_config.

Your thoughts, time, and knowledge would be much apperciated.

Thanks

Matt

____________________________________________________________ _____
Help protect your PC: Get a free online virus scan at McAfee.com.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: install driver failed

am 29.08.2003 04:01:05 von Rudy Lippan

On Thu, 28 Aug 2003, Matt Lyon wrote:

> I am getting an error message:
>
> install_driver(mysql) failed: Can't locate loadable object for module
> DBD::mysql in @INC (@INC contains: /home/httpd/lampwebhosting.com/WebGUI/lib
> /usr/lib/perl5/5.8.0/i586-linux /usr/lib/perl5/5.8.0
> /usr/lib/perl5/site_perl/5.8.0/i586-linux /usr/lib/perl5/site_perl/5.8.0
> /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i586-linux
> /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at (eval 15)
> line 3
> Compilation failed in require at (eval 15) line 3.
> Perhaps a module that DBD::mysql requires hasn't been fully installed
> at /home/httpd/lampwebhosting.com/WebGUI/lib/WebGUI/Session.pm line 392
>
> I have been nosing around in my system and am noticing some differences in
> files. I traced down the above paths and found in
> /usr/lib/perl/site-perl/5.8.0/i586-linux/ is a file called Mysql.pm
>

You will need to look for a directory DBD/ and in that directory there
will be a mysql.pm and a directory mysq/

> In that directory is also a Direcoty Mysql. There is also a Direcory and
> file for DBI and DBI.pm (amont others). The odd part is the file
> permissions. I had a different umask set at the times of installations. The
> Directory Mysql is chmod 700 while the file Mysql.pm is chmod 555. The
> Directory DBI is chmod 755 and the file DBI.pm is chmod 444. All other perl
> modules I installed with the CPAN shell but installed DBD::Mysql manualy
> because of an incomplete mysql_config.
>
> Your thoughts, time, and knowledge would be much apperciated.
>

Maybe you are on to something with the file perms here. I have had
problems installing some CPAN modules (have not tried this with
DBD::mysql) if I had my umask set to 077 specifically the directoies would
end up being 0700, but the files would be set correctly; so maybe check to
make sure that you can access DBD/mysql.pm

Rudy

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: install driver failed

am 29.08.2003 04:01:05 von Rudy Lippan

Re: install driver failed

am 29.08.2003 04:19:00 von Matt Lyon

Thanks,

I found the directory DBD (should have noticed it but didn't) it is chmod
755 and the file mysql.pm is chmod 555 but the directroy mysql instide DBD
is chmod 700.

Are my file permissions messed up and need fixing or is it normal?

Now what?

>From: Rudy Lippan
>To: Matt Lyon
>CC: msql-mysql-modules@lists.mysql.com
>Subject: Re: install driver failed
>Date: Thu, 28 Aug 2003 22:01:05 -0400 (EDT)
>
>On Thu, 28 Aug 2003, Matt Lyon wrote:
>
> > I am getting an error message:
> >
> > install_driver(mysql) failed: Can't locate loadable object for module
> > DBD::mysql in @INC (@INC contains:
>/home/httpd/lampwebhosting.com/WebGUI/lib
> > /usr/lib/perl5/5.8.0/i586-linux /usr/lib/perl5/5.8.0
> > /usr/lib/perl5/site_perl/5.8.0/i586-linux /usr/lib/perl5/site_perl/5.8.0
> > /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i586-linux
> > /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at (eval
>15)
> > line 3
> > Compilation failed in require at (eval 15) line 3.
> > Perhaps a module that DBD::mysql requires hasn't been fully installed
> > at /home/httpd/lampwebhosting.com/WebGUI/lib/WebGUI/Session.pm line 392
> >
> > I have been nosing around in my system and am noticing some differences
>in
> > files. I traced down the above paths and found in
> > /usr/lib/perl/site-perl/5.8.0/i586-linux/ is a file called Mysql.pm
> >
>
>You will need to look for a directory DBD/ and in that directory there
>will be a mysql.pm and a directory mysq/
>
> > In that directory is also a Direcoty Mysql. There is also a Direcory and
> > file for DBI and DBI.pm (amont others). The odd part is the file
> > permissions. I had a different umask set at the times of installations.
>The
> > Directory Mysql is chmod 700 while the file Mysql.pm is chmod 555. The
> > Directory DBI is chmod 755 and the file DBI.pm is chmod 444. All other
>perl
> > modules I installed with the CPAN shell but installed DBD::Mysql manualy
> > because of an incomplete mysql_config.
> >
> > Your thoughts, time, and knowledge would be much apperciated.
> >
>
>Maybe you are on to something with the file perms here. I have had
>problems installing some CPAN modules (have not tried this with
>DBD::mysql) if I had my umask set to 077 specifically the directoies would
>end up being 0700, but the files would be set correctly; so maybe check to
>make sure that you can access DBD/mysql.pm
>
>
>Rudy
>

____________________________________________________________ _____
Help protect your PC: Get a free online virus scan at McAfee.com.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: install driver failed

am 29.08.2003 04:19:00 von Matt Lyon

Re: install driver failed

am 29.08.2003 04:29:24 von Rudy Lippan

On Thu, 28 Aug 2003, Matt Lyon wrote:

> Thanks,
>
> I found the directory DBD (should have noticed it but didn't) it is chmod
> 755 and the file mysql.pm is chmod 555 but the directroy mysql instide DBD
> is chmod 700.
>
> Are my file permissions messed up and need fixing or is it normal?
>
> Now what?

chmod go+rx the mysql directory.

Rudy

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: install driver failed

am 29.08.2003 04:29:24 von Rudy Lippan

Re: install driver failed

am 29.08.2003 05:02:45 von Matt Lyon

Ok,

I cleaned up all directories in /usr/lib/perl5/site_perl/*. Some of the
directories were chomd 700 so I went in and changed all the directories and
subdirectories to 755.

I still have the same results however.

I am wondering what the different directories do. I noticed that the
directories in /usr/lib/perl5/5.8.0/* were all chmod 755. What is the
directory split for?

Last question: Should I reinstall all add in modules with my umask set to
022 to make sure that all the modules install correctly?

Thanks again for you time.

Matt

>From: Rudy Lippan
>To: Matt Lyon
>CC: rlippan@remotelinux.com,
>Subject: Re: install driver failed
>Date: Thu, 28 Aug 2003 22:29:24 -0400 (EDT)
>
>On Thu, 28 Aug 2003, Matt Lyon wrote:
>
> > Thanks,
> >
> > I found the directory DBD (should have noticed it but didn't) it is
>chmod
> > 755 and the file mysql.pm is chmod 555 but the directroy mysql instide
>DBD
> > is chmod 700.
> >
> > Are my file permissions messed up and need fixing or is it normal?
> >
> > Now what?
>
>chmod go+rx the mysql directory.
>
>Rudy
>

____________________________________________________________ _____
Get MSN 8 and help protect your children with advanced parental controls.
http://join.msn.com/?page=features/parental

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: install driver failed

am 29.08.2003 05:02:45 von Matt Lyon

Re: install driver failed

am 29.08.2003 16:02:15 von Matt Lyon

Hmmmm, thanks.

As I don't know what you are talking about you could be correct.

If I need to read the propper documentation then point me at it or tell me
what I need to know.

Thanks

Matt

>From: Jochen Wiedmann
>To: Matt Lyon
>CC: rlippan@remotelinux.com, msql-mysql-modules@lists.mysql.com
>Subject: Re: install driver failed
>Date: Fri, 29 Aug 2003 08:04:07 +0200
>
>Quoting Matt Lyon :
>
> > I cleaned up all directories in /usr/lib/perl5/site_perl/*. Some of the
> > directories were chomd 700 so I went in and changed all the directories
>and
> > subdirectories to 755.
> >
>
>I think the real problem is that you did not copy the mysql.so file and
>similar stuff.
>
>
>Jochen
>

____________________________________________________________ _____
Enter for your chance to IM with Bon Jovi, Seal, Bow Wow, or Mary J Blige
using MSN Messenger http://entertainment.msn.com/imastar

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: install driver failed

am 29.08.2003 16:02:15 von Matt Lyon

Re: install driver failed

am 29.08.2003 22:26:17 von Matt Lyon

Jochen,

Thanks for your honesty. I would be tempted to go with php but my purpose is
more than just functionality. I would really like to learn this. I realize
it is not up to you to teach me but I would appreciate it if you pointed me
down the right direction.

Here is what is printed on make install:

Files found in blib/arch: installing files in blib/lib into architecture
dependant library tree.
Writing /usr/lib/perl5/site_perl/5.8.0/i586-linux/auto/DBD/mysql/.pa cklist -
the mysql.so and mysql.bs is loacted here
Appending installition info to /usr/lib/perl5/5.8.0/i586-linux/perllocal.pod
- this does show that DBD::Mysql is installed in the directory although it
deosn't show the whole path it stops at /usr/lib/perl5/site_perl/5.8.0/

Thanks,

Matt

>From: Jochen Wiedmann
>To: Matt Lyon
>CC: msql-mysql-modules@lists.mysql.com
>Subject: Re: install driver failed
>Date: Fri, 29 Aug 2003 17:53:01 +0200
>
>Quoting Matt Lyon :
>
> > As I don't know what you are talking about you could be correct.
> >
> > If I need to read the propper documentation then point me at it or tell
>me
> > what I need to know.
>
>There is no such thing than a proper documentation of module installation
>by manual copying, because it is highly discouraged - with good reason.
>
>The DBD::mysql driver is made of various files in various directories.
>I can't tell you exactly which, in particular because it varies from
>operating system to operating system and perl version to perl version.
>The list can be seen when doing a source installation: "make install".
>
>In fact, as your only reason for installing Perl this way is most
>probably that you are typical webspace user: I'd recommend you to
>use PHP. Not because it is better than Perl, but because it is
>most probably already installed.
>
>
>Jochen
>

____________________________________________________________ _____
MSN 8: Get 6 months for $9.95/month http://join.msn.com/?page=dept/dialup

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: install driver failed

am 29.08.2003 22:26:17 von Matt Lyon

Re: install driver failed

am 31.08.2003 17:47:18 von Matt Lyon

Jochen,

Thanks for your time.

I now have it working. Unfortunatly it was a problem with the folder
permissions on the mysql directory that the .so file was in. It was chmod
700. I thought I had changed it earlier but I gues I missed it.

Thanks again for your time and I apprecite you walking me through this
process.

Matt

>From: Jochen Wiedmann
>To: Matt Lyon
>CC: msql-mysql-modules-subscribe@lists.mysql.com
>Subject: Re: install driver failed
>Date: Sun, 31 Aug 2003 12:13:27 +0200
>
>Quoting Matt Lyon :
>
> > Here are the contents of the .packlist
>
>Well, you need to copy all the files in the .packlist. The error
>message that you receive (Can't locate loadable object ...) indicates
>the missing auto/DBD/mysql/mysql.so.
>
>
> > I noticed that in man DBD::mysql the install process said the it need
> > Data::ShowTable so I installed that and did a make realclean and
>reinstalled
>
>Forget about that. It is outdated and was required only if one intended
>to use the "dbimon" script.
>
>
>Jochen
>

____________________________________________________________ _____
Help protect your PC: Get a free online virus scan at McAfee.com.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: install driver failed

am 31.08.2003 17:47:18 von Matt Lyon