• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Horde Webmail and DB sqlite

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:

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: 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:

Code: 
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:

Code: 
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

Code: 
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:

Code: 
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:

Code: 
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

Code: 
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

Code: 
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.

Code: 
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.

Code: 
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

Code: 
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.

Code: 
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: 
[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?
 
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:

Code: 
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
 
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:
Code: 
include_path = "c:/inetpub/vhosts/webmail/horde/pear;.;./includes;./pear"

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

Code: 
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.
 
Good follow up. I'm sure someone will benefit from this in the future.
 
You must log in or register to reply here.

Similar threads

P
Issue Certificate problem in Plesk
Replies
5
Views
1K
Raul A.
R
K
Issue Cannot access vite config file
Replies
7
Views
5K
SDGPete
S
T
Resolved connection webmail to mailserver fails
Replies
8
Views
3K
Strangelove
Strangelove
P
Issue Backup Failures (Error 1920) The file cannot be accessed by the system. The file will not be archived.
Replies
7
Views
4K
Peter Debik
P
S
Issue Specified column is not in the row
Replies
1
Views
1K
Peter Debik
P
Back
Top