Page 2 of 3

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Posted: Fri Jan 05, 2018 11:17 am
by rhyker2u
addendum ... as I love linking 'cross-posting' solutions together. Even adminer ain't perfect when migrating databases to a new VestaCP server. Hence I highly recommend to read this VestaCP forum post on cli commands to migrate databases.

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Posted: Sun Mar 18, 2018 12:06 pm
by rhyker2u
Tip: Instead of having to run:

Code: Select all

sudo wget "https://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php
manually at each and every update -- of which there have been two after creating the 1st post -- it's easier to create a cronjob for it. ;-)

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Posted: Sun Apr 08, 2018 6:44 pm
by jasland
When I import with adminer after a minute or two, it gives 500 error

regards

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Posted: Tue Apr 10, 2018 8:34 am
by jasland
When I import with adminer after one or two minutes, an error of 500 occurs.
The same thing happens when I try to move tables from one base to another.
Anyone else get this, is there a solution?
regards

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Posted: Sat Sep 08, 2018 1:52 pm
by rhyker2u
skurudo wrote:
Tue Apr 18, 2017 7:34 am
rhyker2u wrote:Life is bliss again!
Only for nginx+php-fpm, sadly ;-)
You know whats really sad? That the same phpmyadmin errors as in the 1st post are occuring still at the current / latest VestaCP (v0.9.8-22) on a default Vultr Ubuntu 18.04 installation. :-p but yes you're right; the adminer replacement cli syntax suggestion does only work on nginx+php-fpm. Quick-fix / hack for Apache2 (with or without nginx as caching) seems to be to edit:

Code: Select all

nano /etc/apache2/conf.d/phpmyadmin.conf
And make these changes:

Code: Select all

#Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpmyadmin /usr/share/adminer
Far from perfect -- as commenting out other stuff is probably smart -- but it works. ;-)

With regards to ...
jasland wrote:
Tue Apr 10, 2018 8:34 am
When I import with adminer after one or two minutes, an error of 500 occurs.
The same thing happens when I try to move tables from one base to another.
Anyone else get this, is there a solution?
regards
What kind of error 500? Being a little more specific sure helps ;-) However I always edit php.ini to support importing large DBs. And just got an error too when importing. Applying this fix https://stackoverflow.com/a/104176 pertaining MySQL error 1153 did the trick ( or override it in /etc/mysql/mysql.conf at line nr 23).

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Posted: Tue Mar 05, 2019 1:50 pm
by realjumy
Is anyone brave enough to create this as a plugin/addon for VestaCP?

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Posted: Thu Mar 28, 2019 11:17 pm
by dreiggy
skurudo wrote:
Tue Apr 18, 2017 9:02 am
Adminer pretty nice.
Well, we thought about this. And some time ago made idea, but not so many votes for adminer - https://bugs.vestacp.com/issues/145
;-(
I have added Adminer pull request to installer as additional option: https://github.com/serghey-rodin/vesta/pull/1847
Now vesta developers should decide if merge it.

Manual installation of Adminer (CentOS)

All these steps should be done as root user. Adminer will be installed beside phpMyAdmin. So you would be able to use both. If you want, you may remove phpMyAdmin manually.

Adminer installation:

Code: Select all

mkdir -p /usr/share/adminer
wget "https://www.adminer.org/latest.php" -O /usr/share/adminer/index.php
NGINX:

Code: Select all

echo "location /adminer {
    alias /usr/share/adminer/;

    location ~ ^/adminer/(.*\.php)$ {
        alias /usr/share/adminer/$1;
        fastcgi_pass 127.0.0.1:9000;
        fastcgi_index index.php;
        include fastcgi_params;
        fastcgi_param SCRIPT_FILENAME $request_filename;
    }
}
" > /etc/nginx/conf.d/adminer.inc
APACHE:

Code: Select all

echo "Alias /Adminer /usr/share/adminer
Alias /adminer /usr/share/adminer

<Directory /usr/share/adminer/>
   Order Deny,Allow
   Deny from All
   Allow from All
</Directory>
" > /etc/httpd/conf.d/adminer.conf
Reload or restar nginx and apache:

Code: Select all

service nginx restart && service httpd restart

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Posted: Wed Apr 17, 2019 12:16 pm
by Spheerys
I'm runing with apache2 and I switch to Adminer to several servers with success.
I follow my own small guide :
mkdir /usr/share/adminer
wget https://www.adminer.org/latest-mysql.php -O /usr/share/adminer/index.php
wget https://raw.githubusercontent.com/vrana ... dminer.css -O /usr/share/adminer/adminer.css
sed -i -e "s/\/usr\/share\/phpmyadmin/\/usr\/share\/adminer/" /etc/nginx/conf.d/phpmyadmin.inc
sed -i -e "s/\/usr\/share\/phpmyadmin/\/usr\/share\/adminer/" /etc/apache2/conf.d/phpmyadmin.conf
sed -i -e "s/php_admin_value/#php_admin_value/" /etc/apache2/conf.d/phpmyadmin.conf
systemctl restart nginx.service apache2.service
apt remove phpmyadmin
But I have a problem with the last server !
Maybe due to the removing of phpmyadmin : the system ask me about removing some phpmyadmin stuff and maybe I have answered the wrong anwser !!!

Now, when I'm trying to log in Adminer with correct user/pass I get this error :

Code: Select all

Access denied for user 'User_test'@'localhost' (using password: NO)
The mysql server running well by the way and I can connect from cli with

Code: Select all

mysql User_test -u User_test -p
How to solve the problem ?

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Posted: Fri May 17, 2019 8:46 am
by Nadayan
So that it works correctly phpmyadmin cannot be deleted? Or is this not the case?

Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

Posted: Mon Mar 16, 2020 2:06 am
by shally87
Thanks!
Works for CentOS too.