We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on Vesta 2.0 and expect to release it by the end of 2024. Read more about it: https://vestacp.com/docs/vesta-2-development
[GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
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
Tip: Instead of having to run:
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. ;-)
Code: Select all
sudo wget "https://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
When I import with adminer after a minute or two, it gives 500 error
regards
regards
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
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
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
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
Code: Select all
#Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpmyadmin /usr/share/adminer
With regards to ...
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
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
I have added Adminer pull request to installer as additional option: https://github.com/serghey-rodin/vesta/pull/1847skurudo wrote: ↑Tue Apr 18, 2017 9:02 amAdminer 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
;-(
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
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
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
Code: Select all
service nginx restart && service httpd restart
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
I'm runing with apache2 and I switch to Adminer to several servers with success.
I follow my own small guide :
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 :
The mysql server running well by the way and I can connect from cli with
How to solve the problem ?
I follow my own small guide :
But I have a problem with the last server !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
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)
Code: Select all
mysql User_test -u User_test -p
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
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
Thanks!
Works for CentOS too.
Works for CentOS too.