Horde installation failed and need help correcting it.

[DiogoR]

Hi.

I recently updated Centos 5.5 to 5.10 and Plesk from 11.0.x to 11.5.30.

Initially I had problems with update because there where a few packages installed by yum that were of higher version compared to what plesk wanted, I removed that packaged and the update went through ok except for horde webmail.

Then I have successfully removed it and installed Roundcube, but horde always fails to install.

After the installation fails, I get a message to run
/usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/bootstrapper.sh repair
and when I run there are errors on the log

Note: I've tried inumerous workarounds that I've found on foruns, including this one, with no success.

Any help would be appreciated.
Best Regards.

This are the last lines on the error log (If necessary, I will post it all, but I believe that what is important are the last few lines)

[ ERROR! ] [db_error: message="DB Error: no such table" code=-18 mode=return
level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
object_category VARCHAR(80) [nativecode=1146 ** Table
'horde.turba_objects' doesn't exist]"]
[ ERROR! ] [db_error: message="DB Error: no such table" code=-18 mode=return
level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
object_url VARCHAR(255) [nativecode=1146 ** Table
'horde.turba_objects' doesn't exist]"]
[ ERROR! ] [db_error: message="DB Error: no such table" code=-18 mode=return
level=notice prefix="" info="CREATE INDEX turba_email_idx ON
turba_objects (object_email) [nativecode=1146 ** Table
'horde.turba_objects' doesn't exist]"]
[ ERROR! ] [db_error: message="DB Error: no such table" code=-18 mode=return
level=notice prefix="" info="CREATE INDEX turba_firstname_idx ON
turba_objects (object_firstname) [nativecode=1146 ** Table
'horde.turba_objects' doesn't exist]"]
[ ERROR! ] [db_error: message="DB Error: no such table" code=-18 mode=return
level=notice prefix="" info="CREATE INDEX turba_lastname_idx ON
turba_objects (object_lastname) [nativecode=1146 ** Table
'horde.turba_objects' doesn't exist]"]
[ ERROR! ] [db_error: message="DB Error: no such table" code=-18 mode=return
level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
object_photo BLOB [nativecode=1146 ** Table 'horde.turba_objects'
doesn't exist]"]
[ ERROR! ] [db_error: message="DB Error: no such table" code=-18 mode=return
level=notice prefix="" info="ALTER TABLE turba_objects ADD COLUMN
object_logo BLOB [nativecode=1146 ** Table 'horde.turba_objects'
doesn't exist]"]
Continue? [n]
(y) Yes
(n) No

Type your choice: [ ERROR! ] [db_error: message="DB Error: no such table" code=-18 mode=return
level=notice prefix="" info="SELECT object_id, object_lastname FROM
turba_objects [nativecode=1146 ** Table 'horde.turba_objects'
doesn't exist]"]

WARNING!
Some problems are found during change turba address book scheme(see log file: /tmp/plesk_11.5.30_repair.log)

Continue...

Trying to upgrade turba database 2.2.1 -> 2.3... done
Trying to upgrade ingo database 1.2 -> 1.2.1... done
Trying to upgrade ingo database 1.2.1 -> 1.2.2... done
Trying to upgrade mnemo database 2.2 -> 2.2.1... done
Trying to upgrade mnemo database 2.2.1 -> 2.2.2... done
Trying to upgrade kronolith database 2.1 -> 2.2... ERROR 1146 (42S02) at line 1: Table 'horde.kronolith_events' doesn't exist
InnoDB
=====================================
140625 2:24:22 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 32 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 10727 1_second, 10722 sleeps, 1000 10_second, 751 background, 745 flush
srv_master_thread log flush and writes: 10783
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 713, signal count 725
Mutex spin waits 12490, rounds 19700, OS waits 41
RW-shared spins 644, rounds 19288, OS waits 626
RW-excl spins 199, rounds 1821, OS waits 43
Spin rounds per wait: 1.58 mutex, 29.95 RW-shared, 9.15 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 26B90A7E
Purge done for trx's n < 26B90500 undo n < 0
History list length 3263
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 36558, OS thread handle 0x2b5a792a4940, query id 1433227 localhost admin
SHOW ENGINE innodb status
---TRANSACTION 26B90A7D, not started
MySQL thread id 36552, OS thread handle 0x2b5a78f98940, query id 1433210 localhost peter_user
---TRANSACTION 26B83CF3, not started
MySQL thread id 32301, OS thread handle 0x2b5a7911e940, query id 1256668 localhost user_aml
---TRANSACTION 26B83CB3, not started
MySQL thread id 32296, OS thread handle 0x2b5a790dd940, query id 1256587 localhost user_aml
---TRANSACTION 26B83C81, not started
MySQL thread id 32291, OS thread handle 0x2b5a78f57940, query id 1256520 localhost user_aml
---TRANSACTION 26B907C6, not started
MySQL thread id 28507, OS thread handle 0x2b5a7915f940, query id 1431283 localhost admin
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
4173 OS file reads, 54393 OS file writes, 23552 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 6.78 writes/s, 1.44 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 24 merges
merged operations:
insert 56, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276671, node heap has 224 buffer(s)
28.41 hash searches/s, 123.96 non-hash searches/s
---
LOG
---
Log sequence number 14722434393
Log flushed up to 14722434393
Last checkpoint at 14722434383
0 pending log writes, 0 pending chkp writes
21261 log i/o's done, 1.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 137363456; in additional pool allocated 0
Dictionary memory allocated 6002216
Buffer pool size 8191
Free buffers 1778
Database pages 6189
Old database pages 2264
Modified db pages 1
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 114, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 3830, created 2359, written 31473
0.00 reads/s, 0.06 creates/s, 5.53 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 6189, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 21110, id 47667575339328, state: sleeping
Number of rows inserted 360160, updated 8832, deleted 2208, read 289960229
0.69 inserts/s, 0.00 updates/s, 0.00 deletes/s, 24315.90 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================


ERROR while trying to Unable to upgrade kronolith database 2.1 -> 2.2, see psa log for details
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again

***** problem report *****
Passwords for some MySQL users were not upgraded.
All MySQL DB users that may be used by Panel MUST have passwords in new 41-character format in order for Panel to function properly.
Currently following users have passwords in old format: billing@localhost, bug115166_16803@%, norberto2010@%, user_1_2010@%, bug115166_11330@%, user_norberto@%, user_callme@%, bug115166_72383@%, user_teste@%, bug115166_11638@%, AAA@%, A12345@%, aspcomplete@%, aspcomplete@localhost, [email protected], aspcsk@%, aspcsk@localhost, [email protected], aspcss@%, aspcss@localhost, [email protected], aspsession@%, aspsession@localhost, [email protected].
Please ensure that MySQL server is not forced to use old password hashing algorithm and upgrade password format manually for users from the list above. Consult with MySQL server manual on detailed steps.
You may skip certain users if you are sure they weren't created and aren't used by Panel.
ERROR while trying to Unable to upgrade kronolith database 2.1 -> 2.2, see psa log for details
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again

 

[DiogoR]

At this point this situation is passed for me (maybe there are other users with this problem).
I have upgraded to plesk 12 and have a new problem that I will post in a new thread.