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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpMyAdmin + Roundcube not work

Discussion in 'Database Discussions' 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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Thank you.
     
  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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page