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.

cPanel and Webmail..

Discussion in 'E-mail Discussions' 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:
    30,764
    Likes Received:
    662
    Trophy Points:
    113
    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.
     
  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:
    30,764
    Likes Received:
    662
    Trophy Points:
    113
    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.
     
  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:
    243
    Likes Received:
    3
    Trophy Points:
    18
    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
     
  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:
    243
    Likes Received:
    3
    Trophy Points:
    18
    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).
     
  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:
    14,466
    Likes Received:
    196
    Trophy Points:
    63
    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.
     
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,764
    Likes Received:
    662
    Trophy Points:
    113
    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.
     
  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