The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[Case 89449] Horde (Not found?)

Discussion in 'E-mail Discussions' started by Mark_CFH, Jan 31, 2014.

  1. Mark_CFH

    Mark_CFH Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Starting just yesterday, when going to horde mail, we started receiving the following:

    Code:
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. Mark_CFH

    Mark_CFH Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    root@ourservername [~]# cat /usr/local/cpanel/version
    11.42.0.1
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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:

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

    Code:
    /usr/local/cpanel/bin/update_horde_config
    Thank you.
     
  5. Mark_CFH

    Mark_CFH Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Code:
    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.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  7. Mark_CFH

    Mark_CFH Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Code:
    root@ [~]# grep skip /etc/my.cnf
    skip_external_locking
    skip_networking
    
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Please remove the "skip_networking" entry, and then restart MySQL. Next, run the following command to see if it then completes successfully:

    Code:
    /usr/local/cpanel/bin/update_horde_config
    Thank you.
     
  9. Mark_CFH

    Mark_CFH Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    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.
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  11. Mark_CFH

    Mark_CFH Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    It appears that the original error has returned again... Everything was running fine till today.. Now what could be the issue this time?

    Code:
    cat /usr/local/cpanel/version
    11.42.0.15
    
    ------------------------------

    Code:
     mysql -e "select User,Host from mysql.user where User like '%horde%'"
    +-------+-----------+
    | User  | Host      |
    +-------+-----------+
    | horde | 127.0.0.1 |
    | horde | localhost |
    +-------+-----------+
    
    -----------------------------

    Code:
    grep skip /etc/my.cnf
    skip_external_locking
    
    -------------------------------

    Code:
    /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
    
    ====================
    
     
    #11 Mark_CFH, Feb 27, 2014
    Last edited: Feb 27, 2014
  12. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  13. Mark_CFH

    Mark_CFH Well-Known Member

    Joined:
    Apr 2, 2013
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Request ID: 4618571
     
  14. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  15. jpenner

    jpenner Registered

    Joined:
    Apr 11, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    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! :)
     
  16. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  17. eurorocco

    eurorocco Well-Known Member

    Joined:
    Jun 23, 2003
    Messages:
    99
    Likes Received:
    0
    Trophy Points:
    6
    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
     
    #17 eurorocco, Mar 6, 2014
    Last edited by a moderator: Mar 6, 2014
  18. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  19. eurorocco

    eurorocco Well-Known Member

    Joined:
    Jun 23, 2003
    Messages:
    99
    Likes Received:
    0
    Trophy Points:
    6
    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
     
    #19 eurorocco, Mar 6, 2014
    Last edited: Mar 6, 2014
  20. javiercampos

    javiercampos Well-Known Member
    PartnerNOC

    Joined:
    Jan 12, 2010
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    /tmp
    cPanel Access Level:
    Root Administrator
    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
     
Loading...

Share This Page