[horde] database write requirements on log-in

[Jan Schneider]

Please don't top-post.

Zitat von Gonzalo Palacios Goicolea <gonzalo.palacios at externo.uam.es>:

>
> El 08/08/2017 a las 11:54, Jan Schneider escribió:
>>
>> Zitat von Gonzalo Palacios Goicolea <gonzalo.palacios at externo.uam.es>:
>>
>>> Hi all,
>>>
>>> We're running horde 5.2.11 with MySQL database. The db schema has  
>>> servers for write and servers for read, so on the conf.local.php  
>>> we have the read server configuration, and we have enabled the  
>>> read split option at conf.php
>>>
>>> I changed the read server on one webmail server through the GUI  
>>> because on php.conf it had the value of the write server, and now  
>>> the php.conf shows the same read server that php.local.conf, but  
>>> GUI is still showing the write server
>>>
>>> If we try to log in with the write instance down, we can't, we get  
>>> the following error:
>>>
>>> Connect failed: (2003) Can't connect to MySQL server on  
>>> 'dbwebmail.ti.uam.es' (113)
>>>
>>> 1. Horde_Registry::appInit() /var/www/html/horde/imp/basic.php:26
>>> 2. Horde_Registry->setTimeZone() /usr/share/pear/Horde/Registry.php:349
>>> 3. Horde_Prefs->getValue() /usr/share/pear/Horde/Registry.php:2964
>>> 4. Horde_Prefs->_getScope() /usr/share/pear/Horde/Prefs.php:250
>>> 5. Horde_Prefs->_loadScope() /usr/share/pear/Horde/Prefs.php:343
>>> 6. Horde_Core_Prefs_Storage_Hooks->get()  
>>> /usr/share/pear/Horde/Prefs.php:413
>>> 7. Horde_Core_Hooks->callHook()  
>>> /usr/share/pear/Horde/Core/Prefs/Storage/Hooks.php:41
>>> 8. call_user_func_array() /usr/share/pear/Horde/Core/Hooks.php:62
>>> 9. IMP_Hooks->prefs_init()
>>> 10. Horde_Registry->call() /var/www/html/horde/imp/config/hooks.php:29
>>> 11. Horde_Registry->callByPackage() /usr/share/pear/Horde/Registry.php:1084
>>> 12. Horde_Registry->pushApp() /usr/share/pear/Horde/Registry.php:1124
>>> 13. Horde_Registry->_pushAppError() /usr/share/pear/Horde/Registry.php:1630
>>> 14. Horde_Registry::appInit() /var/www/html/horde/imp/basic.php:26
>>> 15. Horde_Registry->setTimeZone() /usr/share/pear/Horde/Registry.php:349
>>> 16. Horde_Prefs->getValue() /usr/share/pear/Horde/Registry.php:2964
>>> 17. Horde_Prefs->_getScope() /usr/share/pear/Horde/Prefs.php:250
>>> 18. Horde_Prefs->_loadScope() /usr/share/pear/Horde/Prefs.php:343
>>> 19. Horde_Core_Prefs_Storage_Hooks->get()  
>>> /usr/share/pear/Horde/Prefs.php:413
>>> 20. Horde_Core_Hooks->callHook()  
>>> /usr/share/pear/Horde/Core/Prefs/Storage/Hooks.php:41
>>> 21. call_user_func_array() /usr/share/pear/Horde/Core/Hooks.php:62
>>> 22. IMP_Hooks->prefs_init()
>>> 23. Horde_Registry->call() /var/www/html/horde/imp/config/hooks.php:29
>>> 24. Horde_Registry->callByPackage() /usr/share/pear/Horde/Registry.php:1084
>>> 25. Horde_Registry->pushApp() /usr/share/pear/Horde/Registry.php:1124
>>> 26. Horde_Registry->callAppMethod() /usr/share/pear/Horde/Registry.php:1625
>>> 27. call_user_func_array() /usr/share/pear/Horde/Registry.php:1192
>>> 28. Horde_Registry_Application->init()
>>> 29. Turba_Application->_init()  
>>> /usr/share/pear/Horde/Registry/Application.php:105
>>> 30. Turba::getConfigFromShares()  
>>> /var/www/html/horde/turba/lib/Application.php:116
>>> 31. Turba::listShares() /var/www/html/horde/turba/lib/Turba.php:464
>>> 32. Horde_Injector->getInstance()  
>>> /var/www/html/horde/turba/lib/Turba.php:639
>>> 33. Horde_Injector->createInstance() /usr/share/pear/Horde/Injector.php:272
>>> 34. Horde_Injector_Binder_Factory->create()  
>>> /usr/share/pear/Horde/Injector.php:238
>>> 35. Turba_Factory_Shares->create()  
>>> /usr/share/pear/Horde/Injector/Binder/Factory.php:119
>>> 36. Horde_Core_Factory_Share->create()  
>>> /var/www/html/horde/turba/lib/Factory/Shares.php:19
>>> 37. Horde_Core_Factory_ShareBase->create()  
>>> /usr/share/pear/Horde/Core/Factory/Share.php:37
>>> 38. Horde_Injector->getInstance()  
>>> /usr/share/pear/Horde/Core/Factory/ShareBase.php:69
>>> 39. Horde_Injector->createInstance() /usr/share/pear/Horde/Injector.php:272
>>> 40. Horde_Injector_Binder_Factory->create()  
>>> /usr/share/pear/Horde/Injector.php:238
>>> 41. Horde_Core_Factory_Group->create()  
>>> /usr/share/pear/Horde/Injector/Binder/Factory.php:119
>>> 42. Horde_Core_Factory_Db->create()  
>>> /usr/share/pear/Horde/Core/Factory/Group.php:37
>>> 43. Horde_Core_Factory_Db->_createDb()  
>>> /usr/share/pear/Horde/Core/Factory/Db.php:99
>>> 44. Horde_Core_Factory_Db->_createDb()  
>>> /usr/share/pear/Horde/Core/Factory/Db.php:142
>>> 45. Horde_Db_Adapter_Base->__construct()  
>>> /usr/share/pear/Horde/Core/Factory/Db.php:180
>>> 46. Horde_Db_Adapter_Mysqli->connect()  
>>> /usr/share/pear/Horde/Db/Adapter/Base.php:150
>>>
>>> Does horde requires write access during log in?
>>
>> Yes. In this case for creating the user's personal default address book.
>>
> Thanks Jan for your answer, but we get the same error even if we're  
> already logged in, without changing any parameter or something that  
> might involve a write in the database, so, it's always necessary to  
> have write database up?
>

Yes.

-- 
Jan Schneider
The Horde Project
https://www.horde.org/