CRITICAL ERROR: Module [DBD::mysql] WAS NOT FOUND !

[motokochan]

What version of ispCP are you trying to run? If you are on 1.0.7, did you compile your own Perl 5.10?

Just to make sure run the following commands at the terminal/shell and report back the output:
which perl
`which perl` -v
rpm -qf `which perl`

Note the back-quotes in the last two commands. They are important. On US keyboards, it's the key to the left of the 1 (sharing the key as ~). For best results, copy/paste the commands.

[Eyon]

(12-15-2010 02:03 PM)fluser Wrote:  What says the default-error.log?

Code:

[Wed Dec 15 03:00:35 2010] [error] [client **MY IP**] File does not exist: /var/www/ispcp
[Wed Dec 15 03:00:35 2010] [error] [client **MY IP**] File does not exist: /var/www/ispcp
[Wed Dec 15 03:00:35 2010] [error] [client **MY IP**] File does not exist: /var/www/ispcp
[Wed Dec 15 03:01:18 2010] [error] [client **MY IP**] File does not exist: /var/www/ispcp
[Wed Dec 15 03:01:18 2010] [error] [client **MY IP**] File does not exist: /var/www/ispcp
[Wed Dec 15 03:01:18 2010] [error] [client **MY IP**] File does not exist: /var/www/ispcp
[Wed Dec 15 03:01:18 2010] [error] [client **MY IP**] File does not exist: /var/www/ispcp
[Wed Dec 15 03:01:25 2010] [error] [client **MY IP**] File does not exist: /var/www/ispcp
[Wed Dec 15 03:01:25 2010] [error] [client **MY IP**] File does not exist: /var/www/ispcp
[Wed Dec 15 03:01:25 2010] [error] [client **MY IP**] File does not exist: /var/www/ispcp
[Wed Dec 15 03:01:25 2010] [error] [client **MY IP**] File does not exist: /var/www/ispcp

This is probably because I deleted the install, even without using the installer. Shouldn't of done this, I guess. I'll try reinstalling later today.

(12-15-2010 04:07 PM)motokochan Wrote:  What version of ispCP are you trying to run? If you are on 1.0.7, did you compile your own Perl 5.10?

Just to make sure run the following commands at the terminal/shell and report back the output:
which perl
`which perl` -v
rpm -qf `which perl`

Note the back-quotes in the last two commands. They are important. On US keyboards, it's the key to the left of the 1 (sharing the key as ~). For best results, copy/paste the commands.

Code:

[root@admin ~]# `which perl` -v

This is perl 5, version 12, subversion 2 (v5.12.2) built for x86_64-linux-thread-multi

Copyright 1987-2010, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

[root@admin ~]# rpm -qf `which perl`
[b]file /usr/local/bin/perl is not owned by any package[/b]

I don't really get what the last one means, but ok. However, 5.12 is installed, so I guess perl is up-to-date. I did as well compile it manually.

[motokochan]

Since you built Perl manually, you cannot use any of the perl-* packages for dependencies. Those will only work with the system-shipped Perl. You will need to use CPAN to install every single Perl module needed. Look over the package list and find any packages following that naming scheme.

Luckily, the naming scheme is fairly easy to translate to Perl's naming. For example, with perl-DBD-MySQL, you'd need to install DBD::MySQL. The only exception is libwwwperl, which is named LWP.

[Eyon]

(12-16-2010 02:00 AM)motokochan Wrote:  Since you built Perl manually, you cannot use any of the perl-* packages for dependencies. Those will only work with the system-shipped Perl. You will need to use CPAN to install every single Perl module needed. Look over the package list and find any packages following that naming scheme.

Luckily, the naming scheme is fairly easy to translate to Perl's naming. For example, with perl-DBD-MySQL, you'd need to install DBD::MySQL. The only exception is libwwwperl, which is named LWP.

Code:

dbdimp.c:3811: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:3812: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:3812: warning: assignment makes pointer from integer without a cast
dbdimp.c:3852: error: incompatible types in initialization
dbdimp.c: In function âmysql_st_destroyâ:
dbdimp.c:4040: error: âimp_sth_tâ has no member named âparamsâ
dbdimp.c:4042: error: âimp_sth_tâ has no member named âparamsâ
dbdimp.c:4042: warning: passing argument 1 of âfree_paramâ from incompatible pointer type
dbdimp.c:4043: error: âimp_sth_tâ has no member named âparamsâ
dbdimp.c:4049: error: âimp_sth_tâ has no member named âav_attrâ
dbdimp.c:4049: error: used struct type value where scalar is required
dbdimp.c:4050: error: âimp_sth_tâ has no member named âav_attrâ
dbdimp.c:4050: error: incompatible types in initialization
dbdimp.c:4051: error: âimp_sth_tâ has no member named âav_attrâ
dbdimp.c:4051: error: assignment of read-only location
dbdimp.c: In function âmysql_st_STORE_attribâ:
dbdimp.c:4095: error: âimp_sth_tâ has no member named âuse_mysql_use_resultâ
dbdimp.c: At top level:
dbdimp.c:4143: error: expected declaration specifiers or â...â before âMYSQL_RESâ
dbdimp.c: In function âmysql_st_FETCH_internalâ:
dbdimp.c:4149: error: âMYSQL_FIELDâ undeclared (first use in this function)
dbdimp.c:4149: error: âcurFieldâ undeclared (first use in this function)
dbdimp.c:4149: error: invalid operands to binary *
dbdimp.c:4156: error: âimp_sth_tâ has no member named âav_attrâ
dbdimp.c:4156: error: invalid operands to binary &&
dbdimp.c:4157: error: âimp_sth_tâ has no member named âav_attrâ
dbdimp.c:4157: error: incompatible types in assignment
dbdimp.c:4160: error: âresâ undeclared (first use in this function)
dbdimp.c:4174: error: âsql_type_info_tâ has no member named ânameâ
dbdimp.c:4174: error: âsql_type_info_tâ has no member named ânameâ
dbdimp.c:4174: warning: passing argument 1 of âstrlenâ from incompatible pointer type
dbdimp.c:4174: warning: passing argument 2 of âPerl_newSVpvâ from incompatible pointer type
dbdimp.c:4178: error: âsql_type_info_tâ has no member named âtableâ
dbdimp.c:4178: error: âsql_type_info_tâ has no member named âtableâ
dbdimp.c:4178: warning: passing argument 1 of âstrlenâ from incompatible pointer type
dbdimp.c:4178: warning: passing argument 2 of âPerl_newSVpvâ from incompatible pointer type
dbdimp.c:4182: error: âsql_type_info_tâ has no member named âtypeâ
dbdimp.c:4182: warning: cast from pointer to integer of different size
dbdimp.c:4186: error: âsql_type_info_tâ has no member named âtypeâ
dbdimp.c:4186: warning: passing argument 1 of ânative2sqlâ makes integer from pointer without a cast
dbdimp.c:4189: error: âsql_type_info_tâ has no member named âflagsâ
dbdimp.c:4193: error: âsql_type_info_tâ has no member named âflagsâ
dbdimp.c:4197: error: âsql_type_info_tâ has no member named âflagsâ
dbdimp.c:4201: error: âsql_type_info_tâ has no member named âlengthâ
dbdimp.c:4201: warning: cast from pointer to integer of different size
dbdimp.c:4205: error: âsql_type_info_tâ has no member named âtypeâ
dbdimp.c:4205: warning: passing argument 1 of ânative2sqlâ makes integer from pointer without a cast
dbdimp.c:4209: error: âsql_type_info_tâ has no member named âtypeâ
dbdimp.c:4209: warning: passing argument 1 of ânative2sqlâ makes integer from pointer without a cast
dbdimp.c:4213: error: âsql_type_info_tâ has no member named âmax_lengthâ
dbdimp.c:4213: warning: cast from pointer to integer of different size
dbdimp.c:4225: error: âsql_type_info_tâ has no member named âflagsâ
dbdimp.c:4225: error: âPRI_KEY_FLAGâ undeclared (first use in this function)
dbdimp.c:4225: error: âUNIQUE_KEY_FLAGâ undeclared (first use in this function)
dbdimp.c:4225: error: invalid operands to binary |
dbdimp.c:4225: error: âMULTIPLE_KEY_FLAGâ undeclared (first use in this function)
dbdimp.c:4225: error: invalid operands to binary |
dbdimp.c:4225: error: invalid operands to binary &
dbdimp.c:4229: error: âsql_type_info_tâ has no member named âflagsâ
dbdimp.c:4233: error: âsql_type_info_tâ has no member named âdecimalsâ
dbdimp.c:4233: warning: cast from pointer to integer of different size
dbdimp.c:4237: error: âsql_type_info_tâ has no member named âlengthâ
dbdimp.c:4237: error: âsql_type_info_tâ has no member named âmax_lengthâ
dbdimp.c:4237: error: âsql_type_info_tâ has no member named âlengthâ
dbdimp.c:4237: error: âsql_type_info_tâ has no member named âmax_lengthâ
dbdimp.c:4237: warning: passing argument 2 of âPerl_newSVivâ makes integer from pointer without a cast
dbdimp.c:4252: error: âimp_sth_tâ has no member named âav_attrâ
dbdimp.c:4252: error: assignment of read-only location
dbdimp.c: In function âmysql_st_FETCH_attribâ:
dbdimp.c:4303: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4303: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4303: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4305: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4305: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4305: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4309: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4309: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4309: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4321: error: âimp_sth_tâ has no member named âparamsâ
dbdimp.c:4321: error: âstruct sql_type_info_sâ has no member named âvalueâ
dbdimp.c:4321: warning: passing argument 2 of âPerl_newSVsvâ from incompatible pointer type
dbdimp.c:4330: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4330: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4330: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4334: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4334: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4334: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4340: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4340: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4340: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4344: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4344: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4344: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4348: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4348: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4348: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4350: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4350: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4350: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4352: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4352: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4352: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4354: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4358: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4358: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4358: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4365: error: âimp_sth_tâ has no member named âinsertidâ
dbdimp.c:4367: error: âimp_sth_tâ has no member named âinsertidâ
dbdimp.c:4367: warning: passing argument 2 of âPerl_sv_2mortalâ makes pointer from integer without a cast
dbdimp.c:4372: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4372: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4372: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4376: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4376: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4376: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4378: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4378: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4378: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c:4380: error: âimp_sth_tâ has no member named âuse_mysql_use_resultâ
dbdimp.c:4384: error: âimp_sth_tâ has no member named âwarning_countâ
dbdimp.c:4396: error: âimp_sth_tâ has no member named âresultâ
dbdimp.c:4396: warning: passing argument 3 of âmysql_st_FETCH_internalâ makes integer from pointer without a cast
dbdimp.c:4396: error: too many arguments to function âmysql_st_FETCH_internalâ
dbdimp.c: In function âmysql_bind_phâ:
dbdimp.c:4525: error: âimp_sth_tâ has no member named âparamsâ
dbdimp.c:4525: warning: passing argument 1 of âbind_paramâ from incompatible pointer type
dbdimp.c: In function âmysql_db_reconnectâ:
dbdimp.c:4670: error: âMYSQLâ undeclared (first use in this function)
dbdimp.c:4670: error: expected â;â before âsave_socketâ
dbdimp.c:4680: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4680: error: âCR_SERVER_GONE_ERRORâ undeclared (first use in this function)
dbdimp.c:4680: warning: comparison between pointer and integer
dbdimp.c:4684: error: âimp_dbh_tâ has no member named âauto_reconnectâ
dbdimp.c:4698: error: âsave_socketâ undeclared (first use in this function)
dbdimp.c:4698: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4699: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4699: warning: passing argument 3 of â__builtin___memcpy_chkâ makes integer from pointer without a cast
dbdimp.c:4699: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4699: warning: passing argument 3 of â__memcpy_ichkâ makes integer from pointer without a cast
dbdimp.c:4700: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4700: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4700: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4700: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4700: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4700: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4700: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4700: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4700: warning: passing argument 1 of â__builtin___memset_chkâ discards qualifiers from pointer target type
dbdimp.c:4700: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4700: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4700: warning: passing argument 1 of â__memset_ichkâ discards qualifiers from pointer target type
dbdimp.c:4708: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4708: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4709: warning: passing argument 3 of âmysql_dr_errorâ makes pointer from integer without a cast
dbdimp.c:4710: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4710: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4710: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4710: warning: passing argument 1 of â__builtin___memcpy_chkâ discards qualifiers from pointer target type
dbdimp.c:4710: warning: passing argument 3 of â__builtin___memcpy_chkâ makes integer from pointer without a cast
dbdimp.c:4710: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4710: warning: passing argument 1 of â__memcpy_ichkâ discards qualifiers from pointer target type
dbdimp.c:4710: warning: passing argument 3 of â__memcpy_ichkâ makes integer from pointer without a cast
dbdimp.c:4711: error: âimp_dbh_tâ has no member named âstatsâ
dbdimp.c:4711: error: request for member âauto_reconnects_failedâ in something not a structure or union
dbdimp.c:4711: error: invalid lvalue in increment
dbdimp.c:4720: error: âimp_dbh_tâ has no member named âstatsâ
dbdimp.c:4720: error: request for member âauto_reconnects_okâ in something not a structure or union
dbdimp.c:4720: error: invalid lvalue in increment
dbdimp.c: In function âmysql_db_quoteâ:
dbdimp.c:4880: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c: In function âmysql_db_last_insert_idâ:
dbdimp.c:4903: error: âimp_dbh_tâ has no member named âpmysqlâ
dbdimp.c:4903: warning: passing argument 2 of âPerl_sv_2mortalâ makes pointer from integer without a cast
make: *** [dbdimp.o] Error 1
  CAPTTOFU/DBD-mysql-4.018.tar.gz
  /usr/bin/make -- NOT OK
'YAML' not installed, will not store persistent state
Running make test
  Can't test without successful make
Running make install
  Make had returned bad status, install seems impossible

Can't get the complete log as it disappears.

Edit: Now I'm getting the following;

Code:

[root@admin setup]# perl -MCPAN -e 'install DBD::mysql'
Going to read '/root/.cpan/Metadata'
  Database was generated on Tue, 14 Dec 2010 21:49:28 GMT
  LWP not available
Fetching with Net::FTP:
ftp://mirror.leaseweb.com/CPAN/authors/01mailrc.txt.gz
Going to read '/root/.cpan/sources/authors/01mailrc.txt.gz'
............................................................................DONE​
  LWP not available
Fetching with Net::FTP:
ftp://mirror.leaseweb.com/CPAN/modules/02packages.details.txt.gz
Going to read '/root/.cpan/sources/modules/02packages.details.txt.gz'
  Database was generated on Wed, 15 Dec 2010 21:38:34 GMT
  HTTP::Date not available
............................................................................DONE​
  LWP not available
Fetching with Net::FTP:
ftp://mirror.leaseweb.com/CPAN/modules/03modlist.data.gz
Going to read '/root/.cpan/sources/modules/03modlist.data.gz'
............................................................................DONE​
Going to write /root/.cpan/Metadata
[b]DBD::mysql is up to date (4.018).[/b]

The bolded part is the funny part about this.

Whenever I run perl ispcp-setup, I'm getting this error;

Code:

[root@admin setup]# perl ispcp-setup

CRITICAL ERROR: Module [DBD::mysql] WAS NOT FOUND !

Modules [DBD::mysql] WAS NOT FOUND in your system...

[motokochan]

Odd. Maybe CPAN is messed up? If you have your root account password-protected, make test will fail. You'll have to do the build and install manually, set up a ~/.my.cnf with the password, or temporarily remove the password on user root. Also make sure DBI is installed as the DBD::* modules rely on it.

The alternative is to use 1.0.6 until CentOS 6 is out, with Perl 5.10 included.

[Eyon]

I guess I'll try 1.0.6 then. Thank for your help though.

[camilojaraba]

Hello Everyone!!!

For those like me who try to install ispcp 1.1.0 beta on Centos 5.X here is the solution.

1. Download lastest stable perl release (at this moment 5.14), unpack and compile it.
2. install with yum some dependencies as mysql-devel mysql++-devel
3. using CPAN install all dependencies showing you when trying to run "perl ispcp-update" on /var/www/ispcp/engine/setup/ directory.
4. after you install all dependencies using CPAN install DateTime LIKE: perl -MCPAN -e 'install DateTime'
5. DONE!!! Just run again 'perl ispcp-update' and everything runs excellent!

K.