Webinoly is just the perfect tool for NGINX experts. Give it a try!
0 votes
12.2k views
by

1. phpMyadmin error all database, table: 

Thanks

2 Answers

0 votes
by Expert
Is it PMA failing?

Or is it just you running some commands in PMA and failing?

Please, give more details and maybe we can help you.
by
Go http://domain.com:22222

Login root user

Click any database name, chooses  any table, and see error.

I dont run any commands

I dont know why
by Expert
Please, provide more technical details, PMA version, OS, PHP version, Webinoly version, stack, etc.

Did you try to re-install PMA?
by
edited

php -v

PHP 7.2.4-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: Apr  5 2018 08:53:57) ( NTS )

Copyright (c) 1997-2018 The PHP Group

Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies

    with Zend OPcache v7.2.4-1+ubuntu16.04.1+deb.sury.org+1, Copyright (c) 1999-2018, by Zend Technologies

 php -i | grep -i '^libxml'

libxml Version => 2.9.4

libxml

libXML support => active

libXML Compiled Version => 2.9.4

libXML Loaded Version => 20903

libXML streams => enabled

libxml2 Version => 2.9.4

 sudo webinoly -info 

[SYSTEM]

Operating System: Linux version 4.4.0-109-generic (buildd@lgw01-amd64-038) (gcc version 5.4.0 20160609 (Ubuntu 5.4.0-6ubuntu1~16.04.5) ) #132-Ubuntu SMP Tue Jan 9 19:52:39 UTC 2018

Description:    Ubuntu 16.04.3 LTS

Codename:       xenial

Cores: 1

RAM: 1015984kb

SWAP: 1048572kb

File descriptors: 304795

[Disk Usage]

Filesystem     Type  Size  Used Avail Use% Mounted on

/dev/vda1      ext4   25G  4.3G   20G  19% /

[NGINX]

nginx version: nginx/1.12.2

Nginx file descriptors: 198116

worker_processes: auto

worker_connections: 8192

worker_rlimit_nofile: 100000

client_max_body_size: 100m

[CACHE]

FastCGI 200: 30d

FastCGI 3xx/4xx: 1m

FastCGI inactive: 7d

FastCGI max-size: 100m

open_file_cache_valid: 3m

open_file_cache max: 30000

open_file_cache inactive: 1m

[PHP]

PHP 7.2.4-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: Apr 5 2018 08:53:57) ( NTS )

memory_limit:  128M

post_max_size:  100M

upload_max_filesize:  100M

max_file_uploads:  20

max_execution_time:  300

[MYSQL]

mysql  Ver 15.1 Distrib 10.2.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

PhpMyAdmin: true

[Raw Conf]

tools-port:22222

nginx-ppa:stable

pre-packs:true

nginx:true

swap-owner:webinoly

nginx-tool:true

php-ver:7.2

php:true

web-tool:true

php-tool:true

mysql-client:true

mysql-root:xxxxxx

mysql-admin:xxxxxx

mysql:true

mysql-tool:true

mail:xxxxxx@xxxx.com

login-www-data:true

server-version:1.0

nginx-optim:true

app-version:1.4.1

linux-optim:purged

php-optim:true

wp-admin-auth:purged

I've updated Webinoly lastest version.

sudo webinoly -update 

sudo webinoly -server-update

I'm not try reinstall PMA yet. 

Reinstall PMA by run command bellow ?

sudo stack -pma -purge
sudo stack -pma

My conf attribute second site error ? See image in link: http://prntscr.com/jfxk8e

Thank you.

by Expert
Try to update && upgrade Ubuntu.

sudo apt-get update && sudo apt-get upgrade

If it didn't work, then try to re-install PMA with commands you mentioned before.

What error do you see in your 2nd site?
by
I did as you instructed but issues still. Websites are working fine, but phpMyAdmin doesn't.
http://prntscr.com/jg1nli
sudo webinoly -info
[SYSTEM]
Operating System: Linux version 4.4.0-109-generic (buildd@lgw01-amd64-038) (gcc version 5.4.0 20160609 (Ubuntu 5.4.0-6ubuntu1~16.04.5) ) #132-Ubuntu SMP Tue Jan 9 19:52:39 UTC 2018
Description:    Ubuntu 16.04.4 LTS
Codename:       xenial
Cores: 1
RAM: 1015984kb
SWAP: 1048572kb
File descriptors: 304795

[Disk Usage]
Filesystem     Type  Size  Used Avail Use% Mounted on
/dev/vda1      ext4   25G  4.5G   19G  20% /

[NGINX]
nginx version: nginx/1.14.0
Nginx file descriptors: 198116
worker_processes: auto
worker_connections: 8192
worker_rlimit_nofile: 100000
client_max_body_size: 100m

[CACHE]
FastCGI 200: 30d
FastCGI 3xx/4xx: 1m
FastCGI inactive: 7d
FastCGI max-size: 100m
open_file_cache_valid: 3m
open_file_cache max: 30000
open_file_cache inactive: 1m

[PHP]
PHP 7.2.5-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: May 5 2018 04:59:13) ( NTS )
memory_limit:  128M
post_max_size:  100M
upload_max_filesize:  100M
max_file_uploads:  20
max_execution_time:  300

[MYSQL]
mysql  Ver 15.1 Distrib 10.2.14-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
PhpMyAdmin: true

[Raw Conf]
tools-port:22222
nginx-ppa:stable
pre-packs:true
nginx:true
swap-owner:webinoly
nginx-tool:true
php-ver:7.2
php:true
web-tool:true
php-tool:true
mysql-client:true
mysql-root:xxxxxx
mysql-admin:xxxxxx
mysql:true
mail:xxxxx@xxx.com
login-www-data:true
server-version:1.0
nginx-optim:true
app-version:1.4.1
linux-optim:purged
php-optim:true
wp-admin-auth:purged
mysql-tool:true

Hoow to fix it? Thank you. 

by Expert

It seems like a PMA bug with PHP 7.2.

I found this solution: https://medium.com/@chaloemphonthipkasorn/fix-bug-phpmyadmin-sql-lib-php-php7-2-ubuntu-16-04-836049630a40

In Webinoly PMA path is /var/www/22222/htdocs/pma  instead of /usr/share/phpmyadmin

Please, tell us if it work for you.

Regards.

by
edited
Hi QROkes,

That's a PMA bug with PHP 7.2.

Thanks for your help.
0 votes
by Expert

It will be fixed in the next Webinoly release v1.5.0.

As a temporary solution you can re-install PMA with the newest version.

Uninstall PMA.

sudo stack -pma -purge

Install the newest PMA version:

sudo mkdir /var/www/22222/htdocs/pma
sudo wget --timeout=15 -qrO /var/www/22222/htdocs/pma.tar.xz https://files.phpmyadmin.net/phpMyAdmin/4.8.1/phpMyAdmin-4.8.1-english.tar.xz
sudo tar -xf /var/www/22222/htdocs/pma.tar.xz -C /var/www/22222/htdocs/pma
sudo mv /var/www/22222/htdocs/pma/phpMyAdmin-4.8.1-english/* /var/www/22222/htdocs/pma/
sudo rm -rf /var/www/22222/htdocs/pma/phpMyAdmin-4.8.1-english
sudo rm /var/www/22222/htdocs/pma.tar.xz
sudo cp /var/www/22222/htdocs/pma/config.sample.inc.php /var/www/22222/htdocs/pma/config.inc.php
sudo sed -i "/blowfish_secret/c \$cfg['blowfish_secret'] = '$(pwgen -s -1 32)';" /var/www/22222/htdocs/pma/config.inc.php
sudo chown -R www-data:www-data /var/www/

Please, tell me if it works for you.

Regards.

by
If someone runs the command to install newest PMA version, does the existing data and tables get wiped?
Welcome to the Community site for Webinoly.

Our Optimized LEMP Web Server is a powerful set of commands for doing just about anything you could wish.

With Webinoly you can set up your NGINX web server in just one step.

* * * * * * *

To report a bug, please create a new issue on GitHub or ask a question here with the bug tag.
Webinoly Support Paypal Donations

PayPal · GitHub Sponsors · Bitcoin

It is very important that any visitor to the site read the disclaimer, terms of use and privacy and legal statement before start browsing.

...