We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
[GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
[GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
After a pletora of strange recurring phmyadmin errors like:
- feature/controlusers viewtopic.php?f=14&t=10307
- gettext errors (supposedly due to php7?)
- deprecated notices of all sorts
- strange 403 errors after an update (probably due to blowfish keys being shorter than recommended 32 chars, but whatever I tried couldn't get it work)
Thus I decided to replace phpmyadmin by https://www.adminer.org ... with a twist (to keep the phpmyadmin link working in VestaCP backend). Perform from terminal:
replace two occurrences of /usr/share/phpmyadmin/ by /usr/share/adminer/
restart webserver ... and done!
Life is bliss again!
- feature/controlusers viewtopic.php?f=14&t=10307
- gettext errors (supposedly due to php7?)
- deprecated notices of all sorts
- strange 403 errors after an update (probably due to blowfish keys being shorter than recommended 32 chars, but whatever I tried couldn't get it work)
Thus I decided to replace phpmyadmin by https://www.adminer.org ... with a twist (to keep the phpmyadmin link working in VestaCP backend). Perform from terminal:
Code: Select all
sudo mkdir /usr/share/adminer
sudo wget "https://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php
sudo ln -s /usr/share/adminer/latest.php /usr/share/adminer/index.php
sudo nano /etc/nginx/conf.d/phpmyadmin.inc
restart webserver ... and done!
Code: Select all
sudo apt remove phpmyadmin
sudo apt autoremove
Last edited by rhyker2u on Sun Apr 16, 2017 4:04 pm, edited 4 times in total.
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Question: if VestaCP is all about making things easy & lightweight, then why on earth is adminer not part of the default VestaCP package?! Saves soooo many problems, headaches, overhead and what not. Or at least make it an option in the advanced install script please. See detailed comparison: https://www.adminer.org/en/phpmyadmin/
P.S. I didn't know about adminer till I was about to give up on VestaCP. Things happen for a reason I suppose ;-)
P.S. I didn't know about adminer till I was about to give up on VestaCP. Things happen for a reason I suppose ;-)
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Only for nginx+php-fpm, sadly ;-)rhyker2u wrote:Life is bliss again!
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
phpmyadmin it's historical choice, and was made when adminer not so popular.rhyker2u wrote:Question: if VestaCP is all about making things easy & lightweight, then why on earth is adminer not part of the default VestaCP package?! Saves soooo many problems, headaches, overhead and what not. Or at least make it an option in the advanced install script please. See detailed comparison: https://www.adminer.org/en/phpmyadmin/
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
;-(
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Hi Rhyker2u
Many , many thanks for your post on how to replace phpMyAdmin /w Adminer
which I have been using without any CP
I have been using VestaCP since day 1 . My fav CP , until problems with phpMyAdmin
Thanks to you I am now back on VestaCP
Kind Regards
Nik
Many , many thanks for your post on how to replace phpMyAdmin /w Adminer
which I have been using without any CP
I have been using VestaCP since day 1 . My fav CP , until problems with phpMyAdmin
Thanks to you I am now back on VestaCP
Kind Regards
Nik
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
@skurudo: Ask anyone whom has used PhpMyAdmin in the past decade if they would like to use something else, and the answer will always be no. Different example: would you like to have an easier more lightweight webhosting control panel called VestaCP to replace Cpanel / DirectAdmin / Plesk? "Ehhh does that entail learning new things? No then I want to stick to what I know" :-p NGINX similar. It's not that I wanted to, my hand was forced and now I will never ever go back to Apache2 nor any other CP. ;-)
And a small addendum to my opening post: after doing the steps above, edit /etc/nginx/conf.d/phpmyadmin.inc again to replace the first line by these 3.
Where X.X.X.X == https://www.whatismyip.com
As I just used my own howto on a new server setup, and knew there was something I forgot for additional security tightening. Also see viewtopic.php?f=10&t=14346&p=60358#p60358 for more post-install tips.
And a small addendum to my opening post: after doing the steps above, edit /etc/nginx/conf.d/phpmyadmin.inc again to replace the first line by these 3.
Code: Select all
location /phpmyadmin {
allow X.X.X.X;
deny all;
As I just used my own howto on a new server setup, and knew there was something I forgot for additional security tightening. Also see viewtopic.php?f=10&t=14346&p=60358#p60358 for more post-install tips.
Last edited by rhyker2u on Tue Sep 25, 2018 4:45 pm, edited 1 time in total.
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
@rhyker2u it's not a deal about adminer... we'd like to add new and more, there is time matter and not such much free time ;-(rhyker2u wrote:@skurudo: Ask anyone whom has used PhpMyAdmin in the past decade if they would like to use something else, and the answer will always be no. Different example: would you like to have an easier more lightweight webhosting control panel called VestaCP to replace Cpanel / DirectAdmin / Plesk? "Ehhh does that entail learning new things? No then I want to stick to what I know" :-p NGINX similar. It's not that I wanted to, my hand was forced and now I will never ever go back to Apache2 nor any other CP. ;-)
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
How do you connect to adminer via the web gui? usually I connect to phpmyadmin via www.mysite.com/phpmyadmin I wondered if there was a way to do the same for adminer?
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Similar way as phpmyaminkinnth wrote:How do you connect to adminer via the web gui? usually I connect to phpmyadmin via http://www.mysite.com/phpmyadmin I wondered if there was a way to do the same for adminer?
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
No ... the EXACT same way. @kinnth : just follow instructions in the 1st post. Or create a second entry for adminer to have both (and to make things more complicated); I prefer easy :-pskurudo wrote:Similar way as phpmyaminkinnth wrote:How do you connect to adminer via the web gui? usually I connect to phpmyadmin via http://www.mysite.com/phpmyadmin I wondered if there was a way to do the same for adminer?