Warning: Not Installed. (install the PEAR RPM

[cbrenchley]

Trying to load TimeTrex to another server that I have setup and I have all required components loaded but on my Required page I have this Error:
I do have PEAR installed !!!!!!!!!

PHP Version: OK (v5.0.4)
Database Engine: OK
PHP BCMATH Enabled: OK
PHP SOAP Enabled: OK
PEAR: Warning: Not Installed. (install the PEAR RPM or package from http://pear.php.net)
Writable TimeTrex-Debug Configuration File (timetrex.ini.php): OK
Writable Cache Directory: OK
Writable Storage Directory: OK
Writable Log Directory: OK
PHP Safe Mode Turned Off: OK
PHP Memory Limit: OK (32M)

* Your TimeTrex-Debug configuration file (timetrex.ini.php) is located at:
/var/www/vhosts/webconnexions.org/httpdocs/admin/time/includes/../timetrex.ini.php

* Your PHP configuration file (php.ini) is located at:
/etc/php.ini, the include path is: ".:"

* Detailed PHP Information


Copyright © 2006 TimeTrex-Debug

Employee Time, Attendance and Payroll Software

Debug Buffer
============================================================================
Memory Usage: 2674456
----------------------------------------------------------------------------
DEBUG [135]: [Function](): URI: /admin/time/interface/install/Requirements.php
DEBUG [137]: [Function](): Production: 0
DEBUG [92]: DateTime::setTimeZone(): Setting TimeZone: PST8PDT
DEBUG [49]: [Function](): Bypassing Authentication
DEBUG [67]: Install::isInstallMode(): Install Mode is ON
DEBUG [429]: Install::checkPHPVersion(): Comparing with Version: 5.0.4
DEBUG [463]: Install::checkPHPVersion(): RetVal: 0
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [804] Array: Install::checkAllRequirements(): RetArr:

array(3) {
[0]=>
int(10)
[1]=>
int(1)
[2]=>
int(0)
}


DEBUG [429]: Install::checkPHPVersion(): Comparing with Version: 5.0.4
DEBUG [463]: Install::checkPHPVersion(): RetVal: 0
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [429]: Install::checkPHPVersion(): Comparing with Version: 5.0.4
DEBUG [463]: Install::checkPHPVersion(): RetVal: 0
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [804] Array: Install::checkAllRequirements(): RetArr:

array(3) {
[0]=>
int(10)
[1]=>
int(1)
[2]=>
int(0)
}


DEBUG [429]: Install::checkPHPVersion(): Comparing with Version: 5.0.4
DEBUG [463]: Install::checkPHPVersion(): RetVal: 0
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [429]: Install::checkPHPVersion(): Comparing with Version: 5.0.4
DEBUG [463]: Install::checkPHPVersion(): RetVal: 0
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [491]: Install::getMemoryLimit(): RAW Limit: 32M
DEBUG [493]: Install::getMemoryLimit(): Limit: 32
DEBUG [804] Array: Install::checkAllRequirements(): RetArr:

array(3) {
[0]=>
int(10)
[1]=>
int(1)
[2]=>
int(0)
}


============================================================================

============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 0.0000 ms (0.00 %) unprofiled

243.2370 ms (100.00 %) Missed
============================================================================
243.2370 ms (100.00 %) OVERALL TIME
============================================================================

[cbrenchley]

Here is my php info:
You can see that php is finding PEAR

PHP Version 5.0.4

System Linux ds214-237.ipowerweb.com 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:55:56 EDT 2005 i686
Build Date Nov 8 2005 08:28:03
Configure Command './configure' '--build=i386-redhat-linux' '--host=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-pear=/usr/share/pear' '--with-kerberos' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--with-mime-magic=/etc/httpd/conf/magic' '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml' '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' '--without-odbc' '--disable-dom' '--disable-dba'

[shaunw]

The PEAR directory (where PEAR.php is located) must be in your php.ini's include path:

include_path = ".:/usr/share/pear/"

[cbrenchley]

Not quite sure how to set that up!!

[cbrenchley]

Ok got the path figured out now I get passed the Database connection and I get this error when I click continue:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1005: Can't create table './time/absence_policy.frm' (errno: 121)] in adodb_throw(CREATE TABLE absence_policy ( id integer AUTO_INCREMENT NOT NULL, company_id integer NOT NULL, name varchar(250) NOT NULL, type_id integer NOT NULL, over_time boolean DEFAULT false NOT NULL, accrual_policy_id integer, premium_policy_id integer, pay_stub_entry_account_id integer, created_date integer, created_by integer, updated_date integer, updated_by integer, deleted_date integer, deleted_by integer, deleted boolean DEFAULT false NOT NULL, PRIMARY KEY(id) ) ENGINE=InnoDB, ) ' in /var/www/vhosts/webconnexions.org/httpdocs/admin/time/classes/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/vhosts/webconnexions.org/httpdocs/admin/time/classes/adodb/adodb-exceptions.inc.php(78): adodb_throw() #1 /var/www/vhosts/webconnexions.org/httpdocs/admin/time/classes/adodb/adodb.inc.php(221): adodb_throw('m in /var/www/vhosts/webconnexions.org/httpdocs/admin/time/classes/adodb/adodb-exceptions.inc.php on line 78

[shaunw]

Did you create the database user as per: http://forums.timetrex.com/viewtopic.php?t=65 ?

[cbrenchley]

I created the database and user name and password in plesk 8 interface. It has all right and privailages for that database. Do I still need to?

[shaunw]

I created the database and user name and password in plesk 8 interface. It has all right and privailages for that database. Do I still need to?

According to the error it can't create a table, so this is the first thing I would try.

[cbrenchley]

Ok, I got through that and ran the setup again from the start and everything is ok until I click next on the Database Configuration
Here is the error:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1005: Can't create table './time/absence_policy.frm' (errno: 121)] in adodb_throw(CREATE TABLE absence_policy ( id integer AUTO_INCREMENT NOT NULL, company_id integer NOT NULL, name varchar(250) NOT NULL, type_id integer NOT NULL, over_time boolean DEFAULT false NOT NULL, accrual_policy_id integer, premium_policy_id integer, pay_stub_entry_account_id integer, created_date integer, created_by integer, updated_date integer, updated_by integer, deleted_date integer, deleted_by integer, deleted boolean DEFAULT false NOT NULL, PRIMARY KEY(id) ) ENGINE=InnoDB, ) ' in /var/www/vhosts/webconnexions.org/httpdocs/admin/time/classes/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/vhosts/webconnexions.org/httpdocs/admin/time/classes/adodb/adodb-exceptions.inc.php(78): adodb_throw() #1 /var/www/vhosts/webconnexions.org/httpdocs/admin/time/classes/adodb/adodb.inc.php(221): adodb_throw('m in /var/www/vhosts/webconnexions.org/httpdocs/admin/time/classes/adodb/adodb-exceptions.inc.php on line 78

[shaunw]

Looks like the exact same error to me.

What version of MySQL are you using and does it support InnoDB tables?

[cbrenchley]

Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3
I'm not sure how to find out if it supports InnoDB tables. And if not, How do I make it so...

[shaunw]

Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3
I'm not sure how to find out if it supports InnoDB tables. And if not, How do I make it so...

You need to run this SQL command:

SHOW ENGINES;

It should list:

InnoDB = YES

[cbrenchley]

SHOW ENGINES;

+------------+---------+------------------------------------------------------------+

| Engine | Support | Comment |

+------------+---------+------------------------------------------------------------+

| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |

| HEAP | YES | Alias for MEMORY |

| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |

| MERGE | YES | Collection of identical MyISAM tables |

| MRG_MYISAM | YES | Alias for MERGE |

| ISAM | YES | Obsolete storage engine, now replaced by MyISAM |

| MRG_ISAM | YES | Obsolete storage engine, now replaced by MERGE |

| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |

| INNOBASE | YES | Alias for INNODB |

| BDB | YES | Supports transactions and page-level locking |

| BERKELEYDB | YES | Alias for BDB |

| NDBCLUSTER | NO | Clustered, fault-tolerant, memory-based tables |

| NDB | NO | Alias for NDBCLUSTER |

| EXAMPLE | NO | Example storage engine |

| ARCHIVE | NO | Archive storage engine |

| CSV | NO | CSV storage engine |

| BLACKHOLE | NO | Storage engine designed to act as null storage |

+------------+---------+------------------------------------------------------------+

17 rows in set (0.00 sec)

[shaunw]

This is a MySQL error, you'll have to try a MySQL forum to figure out whats wrong.

Try searching Google for:

mysql errno: 121