[Case 89449] Horde (Not found?)
Starting just yesterday, when going to horde mail, we started receiving the following:
Now on one of our other servers, its working just fine, but our main server, we receive the above. We have not changed anything, added anything, removed anything. What is it that I would need to look for, or do, to try and fix this? [COLOR="silver">- - - Updated - - - Sorry, to add on to that... We get as far as which email to choose from... (Horde, Roundcube, and squirrelmail) When clicking on "Horde" mail, that is when it goes to the 404
HTTP error 404
The requested page was not found.
Possible reasons why you are seeing this page:
A bookmarked URL may have changed since you last visited.
The URL was entered incorrectly.
The URL was entered with inaccurate capitalization (URLs are case sensitive).
Please re-check the URL you are trying to reach. (Go Back)
Now on one of our other servers, its working just fine, but our main server, we receive the above. We have not changed anything, added anything, removed anything. What is it that I would need to look for, or do, to try and fix this? [COLOR="silver">- - - Updated - - - Sorry, to add on to that... We get as far as which email to choose from... (Horde, Roundcube, and squirrelmail) When clicking on "Horde" mail, that is when it goes to the 404
-
Hello :) Could you let us know which version of cPanel is installed on your system? cat /usr/local/cpanel/version
Thank you.0 -
root@ourservername [~]# cat /usr/local/cpanel/version 11.42.0.1 0 -
There is an internal case open (#89449) to address an issue similar to what you have reported. Please run the following command and let us know the output: mysql -e "select User,Host from mysql.user where User like '%horde%'"
In addition, please run this command and let us know if you notice any difference:/usr/local/cpanel/bin/update_horde_config
Thank you.0 -
root@ [~]# mysql -e "select User,Host from mysql.user where User like '%horde%'" +-------+-----------+ | User | Host | +-------+-----------+ | horde | localhost | +-------+-----------+ root@ [~]# /usr/local/cpanel/bin/update_horde_config horde conf: /usr/local/cpanel/base/horde/config/conf.php ==================== Fatal Error: Could not instantiate PDO with DSN "mysql:persistent=1;port=3306;protocol=tcp;ssl=1;host=127.0.0.1;dbname=horde". PDOException: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111) In /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Pdo/Base.php on line 46 1. Horde_Injector->getInstance() /usr/local/cpanel/3rdparty/php/54/bin/horde-db-migrate:121 2. Horde_Injector->createInstance() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector.php:247 3. Horde_Injector_Binder_Factory->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector.php:213 4. Horde_Core_Factory_DbBase->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector/Binder/Factory.php:111 5. Horde_Core_Factory_Db->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/DbBase.php:17 6. Horde_Core_Factory_Db->createDb() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/Db.php:99 7. Horde_Db_Adapter_Base->__construct() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/Db.php:156 8. Horde_Db_Adapter_Pdo_Mysql->connect() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Base.php:143 9. Horde_Db_Adapter_Pdo_Base->connect() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Pdo/Mysql.php:63 ==================== Archiving current Horde data to '/var/cpanel/horde/horde.backup.sql.20140131'. Cleaning old Horde data archives Removing old backup: horde.backup.sql.1384921977 ==================== Fatal Error: Could not instantiate PDO with DSN "mysql:persistent=1;port=3306;protocol=tcp;ssl=1;host=127.0.0.1;dbname=horde". PDOException: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111) In /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Pdo/Base.php on line 46 1. Horde_Injector->getInstance() /usr/local/cpanel/3rdparty/php/54/bin/horde-db-migrate:121 2. Horde_Injector->createInstance() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector.php:247 3. Horde_Injector_Binder_Factory->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector.php:213 4. Horde_Core_Factory_DbBase->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector/Binder/Factory.php:111 5. Horde_Core_Factory_Db->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/DbBase.php:17 6. Horde_Core_Factory_Db->createDb() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/Db.php:99 7. Horde_Db_Adapter_Base->__construct() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/Db.php:156 8. Horde_Db_Adapter_Pdo_Mysql->connect() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Base.php:143 9. Horde_Db_Adapter_Pdo_Base->connect() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Pdo/Mysql.php:63 ====================
Heres all of it.0 -
Please also paste the output of the following command: grep skip /etc/my.cnf
Thank you.0 -
root@ [~]# grep skip /etc/my.cnf skip_external_locking skip_networking0 -
Please remove the "skip_networking" entry, and then restart MySQL. Next, run the following command to see if it then completes successfully: /usr/local/cpanel/bin/update_horde_config
Thank you.0 -
The updated seems to have went through now... And Horde mail is now loading.. (ugh, what happened to it? lol, it was better the old way.. ) But at least it is working now.. Thank you. [COLOR="silver">- - - Updated - - - Theres no "Purge" link anymore, to remove the "Trash" emails. 0 -
The change you notice is due to an update to Horde Groupware Webmail Edition 5.1 in cPanel verison 11.42 [url=http://blog.cpanel.net/horde-groupware-webmail-edition-5/]Horde Groupware Webmail Edition 5 | cPanel Blog In Horde, on the main menu bar, scroll over the preferences icon (it's to the right of "Notes"), go to preferences, and click on "Mail". The option for "Deleting and Moving Messages" is what you are looking for. Selecting "Move deleted messages to your Trash mailbox instead of marking them as deleted in the current mailbox" will show the additional purge options. Thank you. 0 -
It appears that the original error has returned again... Everything was running fine till today.. Now what could be the issue this time? cat /usr/local/cpanel/version 11.42.0.15
------------------------------mysql -e "select User,Host from mysql.user where User like '%horde%'" +-------+-----------+ | User | Host | +-------+-----------+ | horde | 127.0.0.1 | | horde | localhost | +-------+-----------+
-----------------------------grep skip /etc/my.cnf skip_external_locking
-------------------------------/usr/local/cpanel/base/horde/config/conf.php ==================== Fatal Error: Could not instantiate PDO with DSN "mysql:persistent=1;port=3306;protocol=tcp;ssl=1;host=127.0.0.1;dbname=horde". PDOException: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111) In /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Pdo/Base.php on line 46 1. Horde_Injector->getInstance() /usr/local/cpanel/3rdparty/php/54/bin/horde-db-migrate:121 2. Horde_Injector->createInstance() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector.php:247 3. Horde_Injector_Binder_Factory->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector.php:213 4. Horde_Core_Factory_DbBase->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector/Binder/Factory.php:111 5. Horde_Core_Factory_Db->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/DbBase.php:17 6. Horde_Core_Factory_Db->createDb() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/Db.php:99 7. Horde_Db_Adapter_Base->__construct() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/Db.php:156 8. Horde_Db_Adapter_Pdo_Mysql->connect() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Base.php:143 9. Horde_Db_Adapter_Pdo_Base->connect() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Pdo/Mysql.php:63 ==================== Archiving current Horde data to '/var/cpanel/horde/horde.backup.sql.20140227.2'. Cleaning old Horde data archives Removing old backup: horde.backup.sql.20140131 ==================== Fatal Error: Could not instantiate PDO with DSN "mysql:persistent=1;port=3306;protocol=tcp;ssl=1;host=127.0.0.1;dbname=horde". PDOException: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111) In /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Pdo/Base.php on line 46 1. Horde_Injector->getInstance() /usr/local/cpanel/3rdparty/php/54/bin/horde-db-migrate:121 2. Horde_Injector->createInstance() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector.php:247 3. Horde_Injector_Binder_Factory->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector.php:213 4. Horde_Core_Factory_DbBase->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector/Binder/Factory.php:111 5. Horde_Core_Factory_Db->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/DbBase.php:17 6. Horde_Core_Factory_Db->createDb() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/Db.php:99 7. Horde_Db_Adapter_Base->__construct() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/Db.php:156 8. Horde_Db_Adapter_Pdo_Mysql->connect() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Base.php:143 9. Horde_Db_Adapter_Pdo_Base->connect() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Pdo/Mysql.php:63 ==================== PHP Strict Standards: Non-static method System::tmpdir() should not be called statically in /usr/local/cpanel/3rdparty/php/54/lib/php/PEAR/Config.php on line 158 PHP Strict Standards: Non-static method System::tmpdir() should not be called statically in /usr/local/cpanel/3rdparty/php/54/lib/php/PEAR/Config.php on line 167 PHP Strict Standards: Non-static method System::tmpdir() should not be called statically in /usr/local/cpanel/3rdparty/php/54/lib/php/PEAR/Config.php on line 176 PHP Strict Standards: Non-static method System::which() should not be called statically in /usr/local/cpanel/3rdparty/php/54/lib/php/PEAR/Config.php on line 229 PHP Strict Standards: Non-static method PEAR_Config::singleton() should not be called statically in /usr/local/cpanel/3rdparty/php/54/bin/ingo-convert-prefs-to-sql on line 29 PHP Strict Standards: Non-static method PEAR_Installer_Role::initializeConfig() should not be called statically, assuming $this from incompatible context in /usr/local/cpanel/3rdparty/php/54/lib/php/PEAR/Config.php on line 599 PHP Strict Standards: Non-static method PEAR_Installer_Role::registerRoles() should not be called statically, assuming $this from incompatible context in /usr/local/cpanel/3rdparty/php/54/lib/php/PEAR/Installer/Role.php on line 45 PHP Strict Standards: Non-static method PEAR_Installer_Role::getBaseinstallRoles() should not be called statically, assuming $this from incompatible context in /usr/local/cpanel/3rdparty/php/54/lib/php/PEAR/Installer/Role.php on line 270 PHP Strict Standards: Non-static method PEAR_Installer_Role::getInstallableRoles() should not be called statically, assuming $this from incompatible context in /usr/local/cpanel/3rdparty/php/54/lib/php/PEAR/Installer/Role.php on line 271 PHP Strict Standards: Non-static method PEAR_Installer_Role::getPhpRoles() should not be called statically, assuming $this from incompatible context in /usr/local/cpanel/3rdparty/php/54/lib/php/PEAR/Installer/Role.php on line 272 PHP Strict Standards: Non-static method PEAR_Installer_Role::getValidRoles() should not be called statically, assuming $this from incompatible context in /usr/local/cpanel/3rdparty/php/54/lib/php/PEAR/Installer/Role.php on line 273 ==================== Fatal Error: Could not instantiate PDO with DSN "mysql:persistent=1;port=3306;protocol=tcp;ssl=1;host=127.0.0.1;dbname=horde". PDOException: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111) In /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Pdo/Base.php on line 46 1. Horde_Registry::appInit() /usr/local/cpanel/3rdparty/php/54/bin/ingo-convert-prefs-to-sql:32 2. Horde_Registry->pushApp() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Registry.php:264 3. Horde_Registry->_pushAppError() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Registry.php:1573 4. Horde_Registry::appInit() /usr/local/cpanel/3rdparty/php/54/bin/ingo-convert-prefs-to-sql:32 5. Horde_Registry->pushApp() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Registry.php:264 6. Horde_Registry->callAppMethod() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Registry.php:1568 7. call_user_func_array() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Registry.php:1181 8. Horde_Registry_Application->init() 9. Ingo_Application->_init() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Registry/Application.php:105 10. Ingo_Application->_createSession() /usr/local/cpanel/base/horde/ingo/lib/Application.php:64 11. Ingo_Factory_Script->createAll() /usr/local/cpanel/base/horde/ingo/lib/Application.php:132 12. Ingo_Factory_Script->create() /usr/local/cpanel/base/horde/ingo/lib/Factory/Script.php:117 13. Ingo_Factory_Storage->create() /usr/local/cpanel/base/horde/ingo/lib/Factory/Script.php:58 14. Horde_Injector->getInstance() /usr/local/cpanel/base/horde/ingo/lib/Factory/Storage.php:57 15. Horde_Injector->createInstance() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector.php:247 16. Horde_Injector_Binder_Factory->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector.php:213 17. Horde_Core_Factory_DbBase->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Injector/Binder/Factory.php:111 18. Horde_Core_Factory_Db->create() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/DbBase.php:17 19. Horde_Core_Factory_Db->createDb() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/Db.php:99 20. Horde_Db_Adapter_Base->__construct() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Core/Factory/Db.php:156 21. Horde_Db_Adapter_Pdo_Mysql->connect() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Base.php:143 22. Horde_Db_Adapter_Pdo_Base->connect() /usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Pdo/Mysql.php:63 ====================0 -
Feel free to open a support ticket if the previous existing solutions listed on this thread are no longer working. You can post the ticket number here so we can update this thread with the outcome. Thank you. 0 -
Request ID: 4618571 0 -
To update, the "skip_external_locking" line needed to be removed from the /etc/my.cnf file so that Horde could update and run properly. Thank you. 0 -
I am running into the same problem but don't have skip_external_locking in the my.cnf -- was hoping there was an easy solution! :) 0 -
Hi! After doing /usr/local/cpanel/bin/update_horde_config /etc/my.cnf with skip-networking makes Horde fail? #commenting it out makes Horde work again. Yes. What can I do to fix this? skip-networking and Horde both on, please? Thanks! ER I see the "Horde HTTP error 404" screen today. WHM 11.42.0 (build 19) has this problem. mysql -e "select User,Host from mysql.user where User like '%horde%'" +-------+-----------+ | User | Host | +-------+-----------+ | horde | 127.0.0.1 | | horde | localhost | +-------+-----------+ /etc/my.cnf [mysqld] #skip-networking ie commented out, as if it weren't there cat /usr/local/cpanel/version 11.42.0.19 /usr/local/cpanel/bin/update_horde_config 0 -
[quote="eurorocco, post: 1589181">What can I do to fix this? skip-networking and Horde both on, please?
Horde does not currently function with "skip-networking" enabled in your MySQL configuration. Out of curiosity, are you using the skip-networking option for anything in particular? Thank you.0 -
Michael, skip-networking was on purpose to prevent Mysql access from outside of the server. For security reasons. I know it can be enforced other ways, but skip-networking was the sure way to get it done in a simple way Well, if its Horde or skip-networking we're going without skip-networking then. Getting rid of skip-networking to get Horde back. Thanks! ER 0 -
Horde has caused me problems to be assigned a port to mysql service. example: root@# cat /etc/my.cnf [mysqld] innodb_file_per_table=1 port=1096 0 -
[quote="javiercampos, post: 1590022">Horde has caused me problems to be assigned a port to mysql service. example: root@# cat /etc/my.cnf [mysqld] innodb_file_per_table=1 port=1096
Please ensure you submit a support ticket for new issues that you discover when using Horde with cPanel: Submit A Ticket This allows us to open an internal case if necessary. Also, it's a good idea to open a new thread if you find the existing thread is associated with a different issue or cause of the problem. Feel free to let us know the ticket number so we can update the thread with the outcome. Thank you.0 -
Re: [Case 89449] Horde (Not found?) 404 The problem in my case was caused because we are not allowing external connections to the main ip of the server to prevent attacks on standard ports. So we have in /etc/my.cnf a line like this: bind-address=198.xx.xx.xx
To fix it without removing your additional configuration and without restarting MYSQL go and modify the file: [QUOTE]/usr/local/cpanel/3rdparty/php/54/lib/php/Horde/Db/Adapter/Pdo/Mysql.php
Changing 127.0.0.1 to localhost in the line: [QUOTE]$this->_config['host"> = '127.0.0.1';
After that, execute:/usr/local/cpanel/bin/update_horde_config
With that, the horde update should finish without problems. Regards0 -
Re: [Case 89449] Horde (Not found?) 404 But you still don't have the skip-networking in /etc/my.cnf, right? We have Horde, but Mysql is open to external connections. We'd like to close them too. Thanks! ER 0 -
Re: [Case 89449] Horde (Not found?) 404 [quote="wwwcad, post: 1595432">The problem in my case was caused because we are not allowing external connections to the main ip of the server to prevent attacks on standard ports. So we have in /etc/my.cnf a line like this: bind-address=198.xx.xx.xx
To fix it without removing your additional configuration and without restarting MYSQL go and modify the file: Changing 127.0.0.1 to localhost in the line: After that, execute:/usr/local/cpanel/bin/update_horde_config
With that, the horde update should finish without problems. Regards
This helped me too, while using different mysql port and mysql.default.host=localhost in php configuration. Thanks.0 -
Hello, I had the same issue on my servers after updating cPanel. I don't know what the recommended solution is, but this is how I solved it: # vim /usr/local/cpanel/base/horde/config/conf.php Change: $conf['sql">['hostspec"> = 'localhost'; $conf['sql">['port"> = 3306; $conf['sql">['protocol"> = 'tcp'; to: $conf['sql">['protocol"> = 'unix'; $conf['sql">['socket"> = '/tmp/mysql.sock'; # /usr/local/cpanel/bin/update_horde_config Of course, on my servers this problem appeared beacause I have skip_networking on my.cnf. If it is the same for you, it will probably solve your problem :) 0 -
Sounds great! I like this to return to "skip_networking". Thanks a lot for this info. ER 0 -
Michael, could you or should we... How to go about having Cpanel return Horde to mysql socket instead of networking like this? # vim /usr/local/cpanel/base/horde/config/conf.php Change: $conf['sql">['hostspec"> = 'localhost'; $conf['sql">['port"> = 3306; $conf['sql">['protocol"> = 'tcp'; to: $conf['sql">['protocol"> = 'unix'; $conf['sql">['socket"> = '/tmp/mysql.sock'; # /usr/local/cpanel/bin/update_horde_config 0 -
[quote="eurorocco, post: 1608702">Michael, could you or should we... How to go about having Cpanel return Horde to mysql socket instead of networking like this?
The existing configuration is by design so it's not an issue that can be opened as a bug. I recommend opening a feature request for the option to use the alternate method for the MySQL connections with Horde. Submit A Feature Request Thank you.0 -
Got it. Feature request submitted. Thanks Michael and all! :) 0 -
Sergiu Tot, and all... Thanks for your help! Here is the link to the Cpanel Feature Request to have this Horde back with skip-networking. The feature will more likely be adopted if many more support it by a simple click. Try [url=http://features.cpanel.net/responses/horde-to-connect-to-mysql-through-sockets-not-networking-to-let-servers-skip-networking]Horde to connect to Mysql through sockets, not networking, to let servers skip networking | cPanel Feature Requests 0 -
eurorocco, I'm glad I could help :) I also voted. I think it would be a good feature. 0
Please sign in to leave a comment.
Comments
30 comments