Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

cPanel and Webmail..

Discussion in 'E-mail Discussion' started by userxyz, May 11, 2014.

  1. userxyz

    userxyz Member

    Joined:
    May 11, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hey,

    I need some help with my freshly installed cPanel. I'm using it on CentOS 6.5.

    I try to explain it. When I try to open Horde or Roundcube via cPanel, I'm getting an 404 error (page not found). (Squirrel Mail is working without error...) I looked in the 3rdparty folder and there is no Horde or Roundcube folder.
    So yeah, It seems that they aren't installed ? (I don't understand why, because Roundcube and Horde are enabled in Tweak Settings)

    When I try to install roundcube with the (often posted) update-roundcube --force, I'm getting the error message, that mysqld is not running. When I try to start or update mysql, there are also a few errors.

    Does anybody have an advice for me ? I'm very frustrated...

    Best regards
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,378
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please review the MySQL error log (/var/lib/mysql/$hostname.err) and let us know the exact output that appears when MySQL fails to start.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. userxyz

    userxyz Member

    Joined:
    May 11, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks for your answer

    When I try to run the roundcube command:

    Code:
    root@server [~]# /usr/local/cpanel/bin/update-roundcube --force
    mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql .sock' (2)'
    Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex ists!
    Mysqld not running
    
    When I try to start mysql

    Code:
    root@server [/etc/init.d]# /etc/init.d/mysql start
    Starting MySQL..... ERROR! The server quit without updating PID file (/var/lib/mysql/(host).pid).
    
    Log

    Code:
    140512 20:06:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    2014-05-12 20:06:32 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --$
    2014-05-12 20:06:32 30575 [Note] Plugin 'FEDERATED' is disabled.
    2014-05-12 20:06:32 30575 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    2014-05-12 20:06:32 30575 [Note] InnoDB: The InnoDB memory heap is disabled
    2014-05-12 20:06:32 30575 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
    2014-05-12 20:06:32 30575 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2014-05-12 20:06:32 30575 [Note] InnoDB: Using Linux native AIO
    2014-05-12 20:06:32 30575 [Note] InnoDB: Not using CPU crc32 instructions
    2014-05-12 20:06:32 b73c88e0 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts $
    InnoDB: Warning: io_setup() attempt 1 failed.
    InnoDB: Warning: io_setup() attempt 2 failed.
    InnoDB: Warning: io_setup() attempt 3 failed.
    InnoDB: Warning: io_setup() attempt 4 failed.
    InnoDB: Warning: io_setup() attempt 5 failed.
    2014-05-12 20:06:34 b73c88e0 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
    InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
    2014-05-12 20:06:34 30575 [ERROR] InnoDB: Fatal : Cannot initialize AIO sub-system
    2014-05-12 20:06:34 30575 [ERROR] Plugin 'InnoDB' init function returned error.
    2014-05-12 20:06:34 30575 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2014-05-12 20:06:34 30575 [ERROR] Unknown/unsupported storage engine: InnoDB
    2014-05-12 20:06:34 30575 [ERROR] Aborting
    
    2014-05-12 20:06:34 30575 [Note] Binlog end
    2014-05-12 20:06:34 30575 [Note] Shutting down plugin 'partition'
    2014-05-12 20:06:34 30575 [Note] Shutting down plugin 'ARCHIVE'
    2014-05-12 20:06:34 30575 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2014-05-12 20:06:34 30575 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    .... ....
    {lots of plugins...}
    .... ....
    
    2014-05-12 20:06:34 30575 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140512 20:06:34 mysqld_safe mysqld from pid file /var/lib/mysql/(host).pid ended
    
    Maybe I have to install Horde and Roundcube on another way ?

    How can it be possible, that there are these problems with a freshly installed CentOS and WHM/cPanel?
     
    #3 userxyz, May 12, 2014
    Last edited by a moderator: May 12, 2014
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,378
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    The MySQL error message you pasted indicates that native AIO support is not enabled on the server. Add the following line to /etc/my.cnf and MySQL should then restart successfully:

    Code:
    innodb_use_native_aio = 0
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. userxyz

    userxyz Member

    Joined:
    May 11, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thank you, MySQL is starting. but...

    I still get this

    Code:
    root@server [/etc]# /usr/local/cpanel/bin/update-roundcube --force
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: YES)'
    Mysqld not running
    
    When I try to start mysqld (/http://theos.in/desktop-linux/tip-that-matters/how-do-i-restart-mysql-server/)

    Code:
    root@server [/usr/local/cpanel/bin]# /etc/init.d/mysqld start
    -bash: /etc/init.d/mysqld: No such file or directory
    
    (I checked, there isn't this file)
    
    Can you help me, please ?

    Another question: Is there also a function like the update-roundcube for horde ?
     
  6. lorio

    lorio Well-Known Member

    Joined:
    Feb 25, 2004
    Messages:
    277
    Likes Received:
    9
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    The root password for mysqld seems to be wrong/not set

    Take a look at:
    /root/.my.cnf

    To set the password via WHM
    MySQL Root Password
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. userxyz

    userxyz Member

    Joined:
    May 11, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thank you, now I just have to (re)install Horde as 3rdparty, any advice ? :)
     
  8. lorio

    lorio Well-Known Member

    Joined:
    Feb 25, 2004
    Messages:
    277
    Likes Received:
    9
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    I would first try to use the horde / roundcube / etc. services integrated in Cpanel/WHM.
    Third Party often means to install it on your own under /home. So not sure if you mean that.

    Check WHM/Tweaks to activate the webmailservices you want to use.

    Then start with an /scripts/upcp or Update via WHM to see if the system is now back on track.

    A /scripts/upcp --force can be an option too (Or Force Option via WHM Update).
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. userxyz

    userxyz Member

    Joined:
    May 11, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I said 3rdparty because Roundcube and Squirrel are installed in the folder '3rdparty'. "Pseudo-3rdparty" :)

    Horde is enabled in Tweak Settings but it isn't installed an I get an 404 error when I try to open it (it isn't in the 3rdparty folder), re-enabling it and also /scripts/upcp didn't solved the problem.
     
  10. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,309
    Likes Received:
    393
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    If deselecting Horde (and saving) in Tweak Settings, and then re-selecting and saving settings, and then finally, forcing an update to cPanel does not solve this for you, you might want to open a ticket to cPanel technical Support about it to find out whats preventing the system from doing what it's supposed to.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,378
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Now that MySQL is operating well on the server, the issue should resolve itself when forcing an update of cPanel:

    Code:
    /scripts/upcp --force
    Feel free to open a support ticket if you continue to experience issues after the cPanel update.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  12. userxyz

    userxyz Member

    Joined:
    May 11, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    The forced cPanel update finally solved the issue with Horde.

    Thank you all very much for your help ! :)
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice