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!

phpMyAdmin + Roundcube not work

Discussion in 'Database Discussion' started by Sebi M, Apr 4, 2017.

  1. Sebi M

    Sebi M Member

    Joined:
    Mar 21, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Romania
    cPanel Access Level:
    DataCenter Provider
    Hello,

    due lack of space I moved mysql folder to /home.
    After that all client inclusive root can't access phpMyAdmin and Roundcube.
    All other services functioned properly only after I reset passwords databases.

    On phpMyAdmin page is asking user/pass but not logging and for Roundcube I receive error:

    DATABASE ERROR: CONNECTION FAILED!
    Unable to connect to the database!
    Please contact your server-administrator.

    I try to fix with all recommendations from this forum and another blogs without success.
    Now I'm out of ideas and any help is welcome.

    Thank you.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Could you let us know the specific steps you took to move the MySQL directory to /home?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Sebi M

    Sebi M Member

    Joined:
    Mar 21, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Romania
    cPanel Access Level:
    DataCenter Provider
    Hello,

    all step is from this thread: How to move MySQL data directory

    /etc/init.d/mysql stop
    mkdir /home/var_mysql
    mv /var/lib/mysql /home/var_mysql
    chown -R mysql:mysql /home/var_mysql/mysql
    ln -s /home/var_mysql/mysql /var/lib/mysql
    /etc/init.d/mysql start
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Do you notice any error messages in /var/lib/mysql/$hostname.err (or it's linked location) when restarting MySQL on the server?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Sebi M

    Sebi M Member

    Joined:
    Mar 21, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Romania
    cPanel Access Level:
    DataCenter Provider
    Hello


    2017-04-04 22:21:00 32059 [Note] Giving 2 client threads a chance to die gracefully
    2017-04-04 22:21:00 32059 [Note] Event Scheduler: Purging the queue. 0 events
    2017-04-04 22:21:00 32059 [Note] Shutting down slave threads
    2017-04-04 22:21:02 32059 [Note] Forcefully disconnecting 0 remaining clients
    2017-04-04 22:21:02 32059 [Note] Binlog end
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'partition'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'ARCHIVE'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_METRICS'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_CMP'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_LOCKS'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'INNODB_TRX'
    2017-04-04 22:21:02 32059 [Note] Shutting down plugin 'InnoDB'
    2017-04-04 22:21:02 32059 [Note] InnoDB: FTS optimize thread exiting.
    2017-04-04 22:21:02 32059 [Note] InnoDB: Starting shutdown...
    2017-04-04 22:21:04 32059 [Note] InnoDB: Shutdown completed; log sequence number 13023984968
    2017-04-04 22:21:04 32059 [Note] Shutting down plugin 'BLACKHOLE'
    2017-04-04 22:21:04 32059 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2017-04-04 22:21:04 32059 [Note] Shutting down plugin 'MRG_MYISAM'
    2017-04-04 22:21:04 32059 [Note] Shutting down plugin 'CSV'
    2017-04-04 22:21:04 32059 [Note] Shutting down plugin 'MEMORY'
    2017-04-04 22:21:04 32059 [Note] Shutting down plugin 'MyISAM'
    2017-04-04 22:21:04 32059 [Note] Shutting down plugin 'sha256_password'
    2017-04-04 22:21:04 32059 [Note] Shutting down plugin 'mysql_old_password'
    2017-04-04 22:21:04 32059 [Note] Shutting down plugin 'mysql_native_password'
    2017-04-04 22:21:04 32059 [Note] Shutting down plugin 'binlog'
    2017-04-04 22:21:04 32059 [Note] /usr/sbin/mysqld: Shutdown complete


    2017-04-04 22:21:05 931 [Note] Plugin 'FEDERATED' is disabled.
    2017-04-04 22:21:05 931 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2017-04-04 22:21:05 931 [Note] InnoDB: The InnoDB memory heap is disabled
    2017-04-04 22:21:05 931 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2017-04-04 22:21:05 931 [Note] InnoDB: Memory barrier is not used
    2017-04-04 22:21:05 931 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2017-04-04 22:21:05 931 [Note] InnoDB: Using Linux native AIO
    2017-04-04 22:21:05 931 [Note] InnoDB: Not using CPU crc32 instructions
    2017-04-04 22:21:05 931 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2017-04-04 22:21:05 931 [Note] InnoDB: Completed initialization of buffer pool
    2017-04-04 22:21:05 931 [Note] InnoDB: Highest supported file format is Barracuda.
    2017-04-04 22:21:05 7fcc4fcb0720 InnoDB: Operating system error number 2 in a file operation.
    InnoDB: The error means the system cannot find the path specified.
    InnoDB: If you are installing InnoDB, remember that you must create
    InnoDB: directories yourself, InnoDB does not create them.
    2017-04-04 22:21:05 931 [Note] InnoDB: 128 rollback segment(s) are active.
    2017-04-04 22:21:05 931 [Note] InnoDB: Waiting for purge to start
    2017-04-04 22:21:05 931 [Note] InnoDB: 5.6.35 started; log sequence number 13023984968
    2017-04-04 22:21:05 931 [Note] Server hostname (bind-address): '*'; port: 3306
    2017-04-04 22:21:05 931 [Note] IPv6 is available.
    2017-04-04 22:21:05 931 [Note] - '::' resolves to '::';
    2017-04-04 22:21:05 931 [Note] Server socket created on IP: '::'.
    2017-04-04 22:21:05 931 [Note] Event Scheduler: Loaded 0 events
    2017-04-04 22:21:05 931 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.6.35' socket: '/home/var_mysql/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

    and errors about can't open few tables from clients database.
     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Check to ensure there's no InnoDB corruption on your system. There's a thread with information on how to do this at:

    InnoDB Corruption Repair Guide

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
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