[horde] database write requirements on log-in

Tue Aug 8 09:30:27 UTC 2017

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?

Thanks a lot

-- 
*Gonzalo Palacios Goicolea*

/Tecnologías de la Información/
Universidad Autónoma de Madrid • Campus de Cantoblanco
c/ Francisco Tomás y Valiente 11, EPS Informática, Edif. B, Desp. TI-208 
- 28049, Madrid
Tel.: 91497 2368 - gonzalo.palacios at externo.uam.es - www.uam.es 
<http://www.uam.es>

LinkedIn <https://www.linkedin.com/in/universidadautonomademadrid/> | 
Twitter <https://twitter.com/uam_madrid> | Facebook 
<https://www.facebook.com/universidadautonomademadrid/> | Youtube 
<https://www.youtube.com/user/uam>
¿Eres de la Autónoma? Hazte AlumniUAM <https://alumni.uam.es>

Antes de imprimir este correo piense si es necesario. Cuidemos el 
medioambiente.