[Case 89449] Horde (Not found?)

[Mark_CFH]

Starting just yesterday, when going to horde mail, we started receiving the following:

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?

- - - 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

 

[cPanelMichael]

Hello

Could you let us know which version of cPanel is installed on your system?

cat /usr/local/cpanel/version

Thank you.

 

[Mark_CFH]

[email protected] [~]# cat /usr/local/cpanel/version
11.42.0.1

 

[cPanelMichael]

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.

 

[Mark_CFH]

[email protected]  [~]# mysql -e "select User,Host from mysql.user where User like '%horde%'"
+-------+-----------+
| User  | Host      |
+-------+-----------+
| horde | localhost |
+-------+-----------+
[email protected] [~]# /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.

 

[cPanelMichael]

Please also paste the output of the following command:

grep skip /etc/my.cnf

Thank you.

 

[Mark_CFH]

[email protected] [~]# grep skip /etc/my.cnf
skip_external_locking
skip_networking

 

[cPanelMichael]

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.

 

[Mark_CFH]

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.

- - - Updated - - -

Theres no "Purge" link anymore, to remove the "Trash" emails.

 

[cPanelMichael]

The change you notice is due to an update to Horde Groupware Webmail Edition 5.1 in cPanel verison 11.42

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.

 

[Mark_CFH]

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

====================

 

[cPanelMichael]

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.

 

[Mark_CFH]

Request ID: 4618571

 

[cPanelMichael]

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.

 

[jpenner]

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!

 

[cPanelMichael]

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!

Please post the output of the following command:

grep skip /etc/my.cnf

Also, please review this post from earlier in the thread:

http://forums.cpanel.net/f43/case-89449-horde-not-found-388141.html#post1560972

Thank you.

 

[eurorocco]

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

 

[cPanelMichael]

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.

 

[eurorocco]

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

 

[javiercampos]

Horde has caused me problems to be assigned a port to mysql service.

example:

[email protected]# cat /etc/my.cnf
[mysqld]
innodb_file_per_table=1
port=1096