Horde Webmail and DB sqlite

[netors]

I get this error when trying to access my webmail from http://webmail.mydomain.com/, this url redirects me to http://webmail.mydomain.com/horde/ and the following error pops up:

[b]Fatal error[/b]: Cannot use object of type DB_sqlite as array in [b]C:\Inetpub\vhosts\webmail\horde\lib\Horde\DataTree.php [/b]on line [b]656[/b]

 

[netors]

solution found

I found a similar problem and solution in this thread:

http://forum.swsoft.com/showthread.php?threadid=32922

However, they are having the problem with MySQL and Linux while i use Plesk 8.1 for Windows with Horde configured on sqlite. I tried to fix by attempting to upgrade DB using the following commands:

C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade DB
downloading DB-1.7.11.tgz ...
Starting to download DB-1.7.11.tgz (132,064 bytes)
.............................done: 132,064 bytes
requires package `PEAR' >= 1.0b1
DB: Dependencies failed

After this, i figured i had to upgrade PEAR also, so my next command was:

C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade PEAR
downloading PEAR-1.6.0.tgz ...
Starting to download PEAR-1.6.0.tgz (296,465 bytes)
.........................done: 296,465 bytes
requires package `PEAR' >= 1.3.3
requires package `Archive_Tar' >= 1.3.1
requires package `Console_Getopt' >= 1.2
requires package `Structures_Graph' >= 1.0.2
PEAR: Dependencies failed

More dependencies... continue upgrading:

C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade Archive_Tar
downloading Archive_Tar-1.3.2.tgz ...
Starting to download Archive_Tar-1.3.2.tgz (17,150 bytes)
......done: 17,150 bytes
upgrade ok: Archive_Tar 1.3.2

Everything seems to be working

C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade Console_Getopt
downloading Console_Getopt-1.2.3.tgz ...
Starting to download Console_Getopt-1.2.3.tgz (4,011 bytes)
....done: 4,011 bytes
No handlers for package.xml version 2.0

I did some reaserch, and found this thread on a forum:
http://forums.codewalkers.com/pear-packages-47/no-handlers-for-package-xml-version-2-0t-47252.html
they said this three simple commands will fix this:

pear upgrade --force PEAR-1.3.6 Archive_Tar-1.3.1 Console_Getopt-1.2
pear upgrade --force PEAR-1.4.11
pear upgrade PEAR

So i attempted this:

C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade --force PEAR-1.3.6 Archive_Tar
-1.3.1 Console_Getopt-1.2
downloading PEAR-1.3.6.tgz ...
Starting to download PEAR-1.3.6.tgz (106,880 bytes)
.........................done: 106,880 bytes
downloading Archive_Tar-1.3.1.tgz ...
Starting to download Archive_Tar-1.3.1.tgz (15,102 bytes)
...done: 15,102 bytes
downloading Console_Getopt-1.2.tgz ...
Starting to download Console_Getopt-1.2.tgz (3,370 bytes)
...done: 3,370 bytes
upgrade ok: Console_Getopt 1.2
upgrade ok: Archive_Tar 1.3.1
requires package `XML_RPC' >= 1.4.0
PEAR: Dependencies failed

Another dependency package

C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade XML_RPC
downloading XML_RPC-1.5.1.tgz ...
Starting to download XML_RPC-1.5.1.tgz (32,215 bytes)
.........done: 32,215 bytes
upgrade ok: XML_RPC 1.5.1

Retry the first command

C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade --force PEAR-1.3.6 Archive_Tar
-1.3.1 Console_Getopt-1.2
downloading PEAR-1.3.6.tgz ...
Starting to download PEAR-1.3.6.tgz (106,880 bytes)
.....................done: 106,880 bytes
downloading Archive_Tar-1.3.1.tgz ...
Starting to download Archive_Tar-1.3.1.tgz (15,102 bytes)
...done: 15,102 bytes
downloading Console_Getopt-1.2.tgz ...
Starting to download Console_Getopt-1.2.tgz (3,370 bytes)
...done: 3,370 bytes
upgrade ok: Console_Getopt 1.2
upgrade ok: Archive_Tar 1.3.1
Optional dependencies:
'xmlrpc' PHP extension is recommended to utilize some features
upgrade ok: PEAR 1.3.6

Seems that this upgrade went ok, on to the next command.

C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade --force PEAR-1.4.11
downloading PEAR-1.4.11.tgz ...
Starting to download PEAR-1.4.11.tgz (283,272 bytes)
...................done: 283,272 bytes
Optional dependencies:
package `PEAR_Frontend_Web' version >= 0.5.0 is recommended to utilize some feat
ures.
package `PEAR_Frontend_Gtk' version >= 0.4.0 is recommended to utilize some feat
ures.
package `PEAR_Frontend_Gtk2' version >= 0.1.0 is recommended to utilize some fea
tures.
upgrade ok: PEAR 1.4.11

Finally the last command.

C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade PEAR
downloading PEAR-1.6.0.tgz ...
Starting to download PEAR-1.6.0.tgz (296,465 bytes)
.............................................................done: 296,465 bytes

requires package `Structures_Graph' >= 1.0.2
PEAR: Dependencies failed

Need one more dependency package first

C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade Structures_Graph
downloading Structures_Graph-1.0.2.tgz ...
Starting to download Structures_Graph-1.0.2.tgz (30,947 bytes)
.........done: 30,947 bytes
upgrade ok: Structures_Graph 1.0.2

Upgrade ok, retry last command.

C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade PEAR
downloading PEAR-1.6.0.tgz ...
Starting to download PEAR-1.6.0.tgz (296,465 bytes)
.............................................................done: 296,465 bytes

Optional dependencies:
package `PEAR_Frontend_Web' version >= 0.5.0 is recommended to utilize some feat
ures.
package `PEAR_Frontend_Gtk' version >= 0.4.0 is recommended to utilize some feat
ures.
upgrade ok: PEAR 1.6.0

Then try to upgrade DB again

[code]C:\Inetpub\vhosts\webmail\horde\pear>pear upgrade DB
downloading DB-1.7.11.tgz ...
Starting to download DB-1.7.11.tgz (132,064 bytes)
.............................done: 
upgrade ok: DB-1.7.11

After all these upgrades, I typed the URL http://webmail.mydomain.com/ and ended up with the same error.

Anyone have any ideas?

 

[netors]

copy pear

I noticed i was updating PEAR on

C:\Program Files\SWsoft\Plesk\Aditional\PleskPHP5\PEAR

So i thought i would copy this PEAR folder into

C:\Inetpub\vhosts\webmail\horde\pear\PEAR

Also copied the folder

C:\Inetpub\vhosts\webmail\horde\pear\PEAR\DB

to

C:\Inetpub\vhosts\webmail\horde\pear\DB

and the files

C:\Inetpub\vhosts\webmail\horde\pear\PEAR\DB.php
C:\Inetpub\vhosts\webmail\horde\pear\PEAR\PEAR.php
C:\Inetpub\vhosts\webmail\horde\pear\PEAR\pearcmd.php
C:\Inetpub\vhosts\webmail\horde\pear\PEAR\System.php

to

C:\Inetpub\vhosts\webmail\horde\pear\DB.php
C:\Inetpub\vhosts\webmail\horde\pear\PEAR.php
C:\Inetpub\vhosts\webmail\horde\pear\pearcmd.php
C:\Inetpub\vhosts\webmail\horde\pear\System.php

This fixed the error, but now when i type http://webmail.mydomain.com, this redirects my broswer to http://webmail.industrika.com/horde/imp/login.php, which gives me the following error:

Warning: include_once(PEAR.php) [function.include-once]: failed to open stream: No such file or directory in C:\Inetpub\vhosts\webmail\horde\lib\core.php on line 45

Warning: include_once() [function.include]: Failed opening 'PEAR.php' for inclusion (include_path='C:\Inetpub\vhosts\webmail\horde\lib;.;./includes;./pear') in C:\Inetpub\vhosts\webmail\horde\lib\core.php on line 45

Warning: include_once(Log.php) [function.include-once]: failed to open stream: No such file or directory in C:\Inetpub\vhosts\webmail\horde\lib\Horde.php on line 3

Warning: include_once() [function.include]: Failed opening 'Log.php' for inclusion (include_path='C:\Inetpub\vhosts\webmail\horde\lib;.;./includes;./pear') in C:\Inetpub\vhosts\webmail\horde\lib\Horde.php on line 3

Warning: DataTree_sql::require_once(DB.php) [function.DataTree-sql-require-once]: failed to open stream: No such file or directory in C:\Inetpub\vhosts\webmail\horde\lib\Horde\DataTree\sql.php on line 1620

Fatal error: DataTree_sql::require_once() [function.require]: Failed opening required 'DB.php' (include_path='C:\Inetpub\vhosts\webmail\horde\lib;.;./includes;./pear') in C:\Inetpub\vhosts\webmail\horde\lib\Horde\DataTree\sql.php on line 1620

 

[netors]

include_path

To fix this last issue, i had to edit the include_path in my php.ini in C:\Program Files\SWsoft\Plesk\Aditional\PleskPHP5\php.ini

I added c:/inetpub/vhosts/webmail/horde/pear; to the line:

include_path = "c:/inetpub/vhosts/webmail/horde/pear;.;./includes;./pear"

After this, i just had to reset IIS by typing the following command:

C:\Inetpub\vhosts\webmail\horde\pear>iisreset

Attempting stop...
Internet services successfully stopped
Attempting start...
Internet services successfully restarted

Now when i go to http://webmail.mydomain.com i get redirected to http://webmail.mydomain.com/horde/imp/login.php free of errors.

 

[rmmoore80]

Good follow up. I'm sure someone will benefit from this in the future.