[horde] Fresh Install following the Horde Project install Page

[L. D. James]

On 08/11/2014 05:52 AM, Jan Schneider wrote:
>
> Zitat von L. D. James <ljames at apollo3.com>:
>
>> On 08/11/2014 03:28 AM, L. D. James wrote:
>>> I'm trying to install Horde using the Pear/Quick Install.  I can't 
>>> get past step 8 under Quick Install.
>>>
>>> I click on database, fill out the access information.  Every thing 
>>> appears to work.  But the next time I click on something I get a 
>>> text screen that gives the errors posted below.
>>>
>>> It's obvious that the needed tables for the database are missing. 
>>> However, I can't figure out how to get them in.  The instructions 
>>> says "Click Update All DB Schemas."
>>>
>>> However I can't figure out how to get to that option.  After I get 
>>> past inputing the database information, the next click gives the error.
>>>
>>> Is there a script somewhere that I can manually run that will create 
>>> the table?
>>>
>>> Thanks in advance for any help.
>>>
>>> Error message when clicking the horde link:
>>> A fatal error has occurred
>>>
>>> SQLSTATE[42S02]: Base table or view not found: 1146 Table 
>>> 'horde.horde_prefs' doesn't exist
>>>
>>> 1. Horde_Themes_Image::tag() 
>>> /usr/share/php/www/horde/admin/config/index.php:142
>>> 2. Horde_Themes_Image::base64ImgData() 
>>> /usr/share/php/Horde/Themes/Image.php:99
>>> 3. Horde_Themes_Image->__get() 
>>> /usr/share/php/Horde/Themes/Image.php:137
>>> 4. Horde_Themes_Element->__get() 
>>> /usr/share/php/Horde/Themes/Image.php:44
>>> 5. Horde_Prefs->getValue() /usr/share/php/Horde/Themes/Element.php:122
>>> 6. Horde_Prefs->_getScope() /usr/share/php/Horde/Prefs.php:253
>>> 7. Horde_Prefs->_loadScope() /usr/share/php/Horde/Prefs.php:346
>>> 8. Horde_Prefs_Storage_Sql->get() /usr/share/php/Horde/Prefs.php:416
>>> 9. Horde_Themes_Image::tag() 
>>> /usr/share/php/www/horde/admin/config/index.php:142
>>> 10. Horde_Themes_Image::base64ImgData() 
>>> /usr/share/php/Horde/Themes/Image.php:99
>>> 11. Horde_Themes_Image->__get() 
>>> /usr/share/php/Horde/Themes/Image.php:137
>>> 12. Horde_Themes_Element->__get() 
>>> /usr/share/php/Horde/Themes/Image.php:44
>>> 13. Horde_Prefs->getValue() /usr/share/php/Horde/Themes/Element.php:122
>>> 14. Horde_Prefs->_getScope() /usr/share/php/Horde/Prefs.php:253
>>> 15. Horde_Prefs->_loadScope() /usr/share/php/Horde/Prefs.php:346
>>> 16. Horde_Prefs_Storage_Sql->get() /usr/share/php/Horde/Prefs.php:416
>>> 17. Horde_Db_Adapter_Pdo_Base->selectAll() 
>>> /usr/share/php/Horde/Prefs/Storage/Sql.php:74
>>> 18. Horde_Db_Adapter_Pdo_Base->execute() 
>>> /usr/share/php/Horde/Db/Adapter/Pdo/Base.php:109
>>> 19. Horde_Themes_Image::tag() 
>>> /usr/share/php/www/horde/admin/config/index.php:142
>>> 20. Horde_Themes_Image::base64ImgData() 
>>> /usr/share/php/Horde/Themes/Image.php:99
>>> 21. Horde_Themes_Image->__get() 
>>> /usr/share/php/Horde/Themes/Image.php:137
>>> 22. Horde_Themes_Element->__get() 
>>> /usr/share/php/Horde/Themes/Image.php:44
>>> 23. Horde_Prefs->getValue() /usr/share/php/Horde/Themes/Element.php:122
>>> 24. Horde_Prefs->_getScope() /usr/share/php/Horde/Prefs.php:253
>>> 25. Horde_Prefs->_loadScope() /usr/share/php/Horde/Prefs.php:346
>>> 26. Horde_Prefs_Storage_Sql->get() /usr/share/php/Horde/Prefs.php:416
>>> 27. Horde_Db_Adapter_Pdo_Base->selectAll() 
>>> /usr/share/php/Horde/Prefs/Storage/Sql.php:74
>>> 28. Horde_Db_Adapter_Pdo_Base->execute() 
>>> /usr/share/php/Horde/Db/Adapter/Pdo/Base.php:109
>>> 29. PDO->query() /usr/share/php/Horde/Db/Adapter/Pdo/Base.php:201
>>>
>>> -- L. James
>>>
>> I'm wondering if the fact that the system is looking for a table 
>> named "horde.horde_prefs" instead of "horde_prefs" is making a 
>> difference.  Checking my horde database I see the following tables:
>>
>> Database changed
>> mysql> show tables;
>> --------------------------------------------------------------------
>> +----------------------------------+
>> | Tables_in_horde                  |
>> +----------------------------------+
>> | horde_activesync_schema_info     |
>> | horde_alarm_schema_info          |
>> | horde_auth_schema_info           |
>> | horde_cache_schema_info          |
>> | horde_core_schema_info           |
>> | horde_dav_schema_info            |
>> | horde_group_schema_info          |
>> | horde_history_schema_info        |
>> | horde_imap_client_schema_info    |
>> | horde_lock_schema_info           |
>> | horde_perms_schema_info          |
>> | horde_prefs_schema_info          |
>> | horde_queue_schema_info          |
>> | horde_sessionhandler_schema_info |
>> | horde_syncml_schema_info         |
>> | horde_token_schema_info          |
>> | horde_vfs_schema_info            |
>> +----------------------------------+
>> 17 rows in set (0.00 sec)
>>
>> mysql> describe horde_prefs_schema_info;
>> +---------+---------+------+-----+---------+-------+
>> | Field   | Type    | Null | Key | Default | Extra |
>> +---------+---------+------+-----+---------+-------+
>> | version | int(11) | YES  |     | NULL    |       |
>> +---------+---------+------+-----+---------+-------+
>> 1 row in set (0.00 sec)
>>
>> mysql>
>>
>> ----------------------------------------------------------------------
>>
>> Is there a way to configure horde so that it will look for the tables 
>> the way they are actually configured by the default install?
>>
>> -- L. James
>>
>> -- 
>> L. D. James
>> ljames at apollo3.com
>> www.apollo3.com/~ljames
>
> Don't use the quick install, if it doesn't work for you.
>
Thanks, Jan.  After weeks of trying to repair my Horde mail system, I 
finally got it working.

I copied a backup database from my mysql 2004 horde backup and used it.  
Horde came right up and started working as expected.

I'll try to figure out how to get the tables from a fresh install for 
people who are starting totally new and don't have a backup. I'll update 
this thread with that information when I figure it out.

Have a nice day!

-- L. James

-- 
L. D. James
ljames at apollo3.com
www.apollo3.com/~ljames