Web Hosting Talk







View Full Version : DBD + DBI module installation problems


hoot
06-04-2002, 11:02 AM
Hi I have got plesk 2.5 running on linux 7.1.
I have followed the following instructions taken from :
http://forum.plesk.com/showthread.php?s=&postid=17975#post17975

I've copied them here :

1. Download DBI module from CPAN:
# ncftpget
ftp://ftp.cpan.org/pub/CPAN/authors...DBI-1.20.tar.gz
2. Uncompress DBI module archive:
# gunzip -c DBI-1.20.tar.gz |tar xvf -
3. Change directory to DBI-1.20
# cd DBI-1.20
4. Configure DBI modules:
# perl Makefile.PL
5. Make and install DBI modules:
# make && make install



Msql-Mysql modules installation:


1. Download Mysql modules from the CPAN:
# ncftp
ftp://ftp.cpan.org/pub/CPAN/authors...sql-modules-1.2
219.tar.gz
2. Uncompress Mysql modules:
# gunzip -c Msql-Mysql-modules-1.2216.tar.gz |tar xvf -
3. Change directory to Msql-Mysql-modules-1.2216
# cd Msql-Mysql-modules-1.2216
4. Configure Mysql modules
# perl Makefile.PL


answer questions:
a) Which drivers do you want to install?


1) MySQL only
2) mSQL only (either of mSQL 1 or mSQL 2)
3) MySQL and mSQL (either of mSQL 1 or mSQL 2)


4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2


Enter the appropriate number: [3]


Answer '1'.



b) Do you want to install the MysqlPerl emulation? You might keep your
old
Mysql module (to be distinguished from DBD::mysql!) if you are concerned
about compatibility to existing applications! [n]


Answer 'n'



c) Where is your MySQL installed? Please tell me the directory that
contains the subdir 'include'. [/usr/local]


Answer '/usr/local/psa/mysql'



d) Answer with default answer to any other questions



5. Make and install modules
# make && make install


But I get this error when installing DBD (after the config) :

Warning: prerequisite Data::ShowTable failed to load: Can't locate Data/ShowTable.pm in @INC (@INC contains: lib /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0 /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) at (eval 18) line 3.


Any ideas what it means ?

When I run the ikon board test after having done the last make and make install and rebooting the server I get this :


Software error:
DBD::mysql object version 2.0416 does not match bootstrap parameter 2.1011 at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 219.
For help, please send mail to the webmaster (*@*.com), giving this error message and the time and date of the error. Content-type: text/html

Software error:
[Tue Jun 4 11:04:06 2002] test.cgi: DBD::mysql object version 2.0416 does not match bootstrap parameter 2.1011 at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 219. Compilation failed in require at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 219.
For help, please send mail to the webmaster (*@*.com), giving this error message and the time and date of the error. Content-type: text/html

Ikonboard Path and Environment Test
This script checks your paths and environment variables and prints the results based on its best information available.


--------------------------------------------------------------------------------


The absolute path to this script is: /usr/local/psa/home/vhosts/domain.com/cgi-bin, on a Linux based platform.
This server is running perl version: 5.006.
DOCUMENT_ROOT: /usr/local/psa/home/vhosts/domain.com/httpdocs.
CGI Version: 2.56

Has DB_File Perl module installed? Yes
Has CGI Perl module installed? Yes
Has DBI Perl module installed? Yes
Has DBD-Mysql Perl module installed? No



Any ideas why this happens or what I could do to get DBD to work?

microsol
06-04-2002, 11:07 AM
That means that you need to install Data::ShowTable . You can find it on http://search.cpan.org

hoot
06-04-2002, 11:19 AM
But is this the reason why the dbd ins't working?
And how would I install it, I'm just going to see if I can find it :)

hoot
06-04-2002, 11:23 AM
I have found data show table,
So once uncompressed do I have to confugure it ?
and then do I just do make and then make install ?
Can I install it anywhere?

thanks,

hoot

hoot
06-04-2002, 11:37 AM
I don't get the error anymore, the module showtable module seems to have morked ok, I'm now going to do the make and make install and see if the DBD module works :

I got :

4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2

Enter the appropriate number: [3] 1


Do you want to install the MysqlPerl emulation? You might keep your old
Mysql module (to be distinguished from DBD::mysql!) if you are concerned
about compatibility to existing applications! [n] n
Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lgz
Using DBI 1.20 installed in /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI
Writing Makefile for DBD::mysql
Writing Makefile for Msql-Mysql-modules

hoot
06-04-2002, 11:45 AM
Well the showtable module fixed the error I was getting during the install
Bot for the DBD when I do the make, and make test I get no errors so I do the make install and restart the server, but with the perl CGI Ikonboard checker I still get :

Software error:
DBD::mysql object version 2.0416 does not match bootstrap parameter 2.1011 at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 219.
For help, please send mail to the webmaster (*@*.com), giving this error message and the time and date of the error. Content-type: text/html

Software error:
[Tue Jun 4 11:46:05 2002] test.cgi: DBD::mysql object version 2.0416 does not match bootstrap parameter 2.1011 at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 219. Compilation failed in require at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 219.
For help, please send mail to the webmaster (*@*.com), giving this error message and the time and date of the error. Content-type: text/html

Ikonboard Path and Environment Test
This script checks your paths and environment variables and prints the results based on its best information available.


--------------------------------------------------------------------------------


The absolute path to this script is: /usr/local/psa/home/vhosts/domain.com/cgi-bin, on a Linux based platform.
This server is running perl version: 5.006.
DOCUMENT_ROOT: /usr/local/psa/home/vhosts/domain.com/httpdocs.
CGI Version: 2.56

Has DB_File Perl module installed? Yes
Has CGI Perl module installed? Yes
Has DBI Perl module installed? Yes
Has DBD-Mysql Perl module installed? No

hoot
06-04-2002, 11:48 AM
I'm not sure but it seems to be this line that says what the problem is :

"mysql object version 2.0416 does not match bootstrap parameter 2.1011 at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 219"

Thanks in advance,
Hoot

hoot
06-04-2002, 06:35 PM
I have discovered that if I install
Msql-Mysql-modules-1.2216 I get the error :
mysql object version 2.0416 does not match bootstrap parameter 2.1011 at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 219

and when I install Msql-Mysql-modules-1.2216 I get :

mysql object version 2.0419 does not match bootstrap parameter 2.1011 at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 219

So maybe I'm not installing the right dbd version for my server ???

I've got plesk 2.5 on linux 7.1 please could someone try and help me find what is wrong ? I think that it seems to be a dbd version problem But I rearly don't know, maybe I need a more recent version of ddb ...

Please help :(

Thanks in advance,

hoot