Control Web Panel

WebPanel => MySQL => Topic started by: alebal on January 07, 2017, 10:02:46 PM

Title: PhpMyAdmin 403
Post by: alebal on January 07, 2017, 10:02:46 PM

Phpmyadmin always says:
------------------------------
Error in Processing Request
Error code: 403
Error text: Forbidden
------------------------------
Whatever I click inside a table window...

What happen? How can solve?


----------------------------------
server version/features

Application Version

    Apache version: Apache/2.2.31
    PHP version: 7.0.13 [PHP Switcher]
    MySQL version: 10.1.20-MariaDB
    FTP version: 1.0.36

System Info

    CPU Model: Intel(R) Xeon(R) CPU E5-2650L v3 @ 1.80GHz
    CPU Details: 2 Core (1800 MHz)
    Distro Name: CentOS release 6.8 (Final)
    Kernel Version: 2.6.32-642.1.1.el6.x86_64
    Platform: x86_64 [kvm]

Title: Re: PhpMyAdmin 403
Post by: alebal on January 10, 2017, 08:51:20 PM

as I use it I realize that phpmyadmin does not work ... even trying to export a database you end up on a blank page ...

php7's fault?

HELP!

Title: Re: PhpMyAdmin 403
Post by: Administrator on January 11, 2017, 05:35:56 AM

you should check the error log, info about the error should be there

Title: Re: PhpMyAdmin 403
Post by: mozev on January 11, 2017, 09:04:54 AM

do you have enabled the mod_security module?
maybe you just have to "SecRuleRemoveById" for phpmyadmin

Title: Re: PhpMyAdmin 403
Post by: alebal on January 11, 2017, 08:09:31 PM

I tried uninstalling and reinstalling ModSecurity, but never change anything

What logs should I look at? there are a million ...

Title: Re: PhpMyAdmin 403
Post by: Administrator on January 12, 2017, 05:15:39 AM

All important are here
http://wiki.centos-webpanel.com/service-log-paths

Title: Re: PhpMyAdmin 403
Post by: alebal on January 12, 2017, 08:57:33 PM

This is mysql ... there you understand something?

What is Aria?

Code: [Select]

160909 23:40:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-09-09 23:40:46 139761619175456 [Note] /usr/sbin/mysqld (mysqld 10.1.16-MariaDB) starting as process 5768 ...
2016-09-09 23:40:46 139761619175456 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2016-09-09 23:41:17 139761619175456 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
2016-09-09 23:41:17 139761619175456 [ERROR] Plugin 'Aria' init function returned error.
2016-09-09 23:41:17 139761619175456 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Memory barrier is not used
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Using Linux native AIO
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Using SSE crc32 instructions
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Completed initialization of buffer pool
2016-09-09 23:41:18 139761619175456 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Retrying to lock the first data file
2016-09-09 23:41:19 139761619175456 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-09-09 23:41:19 139761619175456 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-09 23:41:20 139761619175456 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-09-09 23:41:20 139761619175456 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-09 23:41:21 139761619175456 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-09-09 23:41:21 139761619175456 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-09 23:41:22 139761619175456 [Note] InnoDB: Highest supported file format is Barracuda.
2016-09-09 23:41:22 139761619175456 [Note] InnoDB: 128 rollback segment(s) are active.
2016-09-09 23:41:22 139761619175456 [Note] InnoDB: Waiting for purge to start
2016-09-09 23:41:22 139761619175456 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.30-76.3 started; log sequence number 1819725
2016-09-09 23:41:22 139761619175456 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-09 23:41:22 139761619175456 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-09-09 23:41:22 139761619175456 [ERROR] Aborting

160909 23:41:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-09-09 23:41:45 140347292117024 [Note] /usr/sbin/mysqld (mysqld 10.1.16-MariaDB) starting as process 1306 ...
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Memory barrier is not used
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Using Linux native AIO
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Using SSE crc32 instructions
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Completed initialization of buffer pool
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Highest supported file format is Barracuda.
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: 128 rollback segment(s) are active.
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Waiting for purge to start
2016-09-09 23:41:45 140347292117024 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.30-76.3 started; log sequence number 1819735
2016-09-09 23:41:45 140347292117024 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-09 23:41:45 140346543535872 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-09-09 23:41:45 140347292117024 [Note] Server socket created on IP: '::'.
2016-09-09 23:41:45 140347292117024 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.16-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
160909 23:41:46 mysqld_safe A mysqld process already exists
2016-09-09 23:51:36 140346501245696 [Note] /usr/sbin/mysqld: Normal shutdown

2016-09-09 23:51:36 140346501245696 [Note] Event Scheduler: Purging the queue. 0 events
2016-09-09 23:51:36 140346522556160 [Note] InnoDB: FTS optimize thread exiting.
2016-09-09 23:51:36 140346501245696 [Note] InnoDB: Starting shutdown...
2016-09-09 23:51:38 140346501245696 [Note] InnoDB: Shutdown completed; log sequence number 1819745
2016-09-09 23:51:38 140346501245696 [Note] /usr/sbin/mysqld: Shutdown complete

Title: Re: PhpMyAdmin 403
Post by: Sandeep on January 14, 2017, 06:53:24 AM

Quote from: alebal on January 12, 2017, 08:57:33 PM

This is mysql ... there you understand something?

What is Aria?

Code: [Select]

160909 23:40:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-09-09 23:40:46 139761619175456 [Note] /usr/sbin/mysqld (mysqld 10.1.16-MariaDB) starting as process 5768 ...
2016-09-09 23:40:46 139761619175456 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2016-09-09 23:41:17 139761619175456 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
2016-09-09 23:41:17 139761619175456 [ERROR] Plugin 'Aria' init function returned error.
2016-09-09 23:41:17 139761619175456 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Memory barrier is not used
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Using Linux native AIO
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Using SSE crc32 instructions
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Completed initialization of buffer pool
2016-09-09 23:41:18 139761619175456 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-09 23:41:18 139761619175456 [Note] InnoDB: Retrying to lock the first data file
2016-09-09 23:41:19 139761619175456 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-09-09 23:41:19 139761619175456 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-09 23:41:20 139761619175456 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-09-09 23:41:20 139761619175456 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-09 23:41:21 139761619175456 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2016-09-09 23:41:21 139761619175456 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-09-09 23:41:22 139761619175456 [Note] InnoDB: Highest supported file format is Barracuda.
2016-09-09 23:41:22 139761619175456 [Note] InnoDB: 128 rollback segment(s) are active.
2016-09-09 23:41:22 139761619175456 [Note] InnoDB: Waiting for purge to start
2016-09-09 23:41:22 139761619175456 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.30-76.3 started; log sequence number 1819725
2016-09-09 23:41:22 139761619175456 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-09 23:41:22 139761619175456 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-09-09 23:41:22 139761619175456 [ERROR] Aborting

160909 23:41:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-09-09 23:41:45 140347292117024 [Note] /usr/sbin/mysqld (mysqld 10.1.16-MariaDB) starting as process 1306 ...
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Memory barrier is not used
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Using Linux native AIO
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Using SSE crc32 instructions
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Completed initialization of buffer pool
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Highest supported file format is Barracuda.
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: 128 rollback segment(s) are active.
2016-09-09 23:41:45 140347292117024 [Note] InnoDB: Waiting for purge to start
2016-09-09 23:41:45 140347292117024 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.30-76.3 started; log sequence number 1819735
2016-09-09 23:41:45 140347292117024 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-09 23:41:45 140346543535872 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-09-09 23:41:45 140347292117024 [Note] Server socket created on IP: '::'.
2016-09-09 23:41:45 140347292117024 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.16-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
160909 23:41:46 mysqld_safe A mysqld process already exists
2016-09-09 23:51:36 140346501245696 [Note] /usr/sbin/mysqld: Normal shutdown

2016-09-09 23:51:36 140346501245696 [Note] Event Scheduler: Purging the queue. 0 events
2016-09-09 23:51:36 140346522556160 [Note] InnoDB: FTS optimize thread exiting.
2016-09-09 23:51:36 140346501245696 [Note] InnoDB: Starting shutdown...
2016-09-09 23:51:38 140346501245696 [Note] InnoDB: Shutdown completed; log sequence number 1819745
2016-09-09 23:51:38 140346501245696 [Note] /usr/sbin/mysqld: Shutdown complete

check the error log of webserver

Title: Re: PhpMyAdmin 403
Post by: alebal on January 16, 2017, 11:43:42 PM

Quote

check the error log of webserver

You have to say where, because I do not know where to look ...

Title: Re: PhpMyAdmin 403
Post by: Sandeep on February 03, 2017, 06:32:28 AM

/usr/local/apache/