phpmyadmin.sh Addon

George I installed centmin with phpmyadmin.sh as the developers for the webshop requested it...

This webshop is going to a new baremetal server in company but the existing one (company.com) is still outside so we have the DNS pointing to that host.

I asked them to add two DNS entries webserver.company.com for the new webshop with laravel project set, and a server.company.com the server hostname, internally we placed a redirection on the firewall to port 5556 for http and 5557 to https, I can get the laravel test page using webshop.company.com:5556 without a problem and the server.company.com:5556 shows centmin test page correctly.

Now the issue is getting into phpmyadmin, with the host file edit it works without any problem, but need somehow a way so they can reach it outside like server.mycompany:5557/12345_mysqladmin1234

Any ideas?

 

Hi George . I've read that PHPMA script it's still on beta. What does it need ?

Regards

 

The single thing a friend of mine asks me help him with is : to have access ( via an app he made) to a hosted db he wants to access via pma.
In case I follow the guidelines this way it should be secure for me to have the db online?
I will be making use of let's encrypt, put a vpn server inside the box and only allow the server ip ( plus some other vpns of my own) to reach the modified url of pma and make use of keys with passphrase.
Should that suffice to think would be secure?
I'm telling him to encrypt the db maybe with bcrypt.

 

I installed phpmyadmin following instructions here:
Addon phpmyadmin.sh - CentminMod.com LEMP Nginx web stack for CentOS

I noticed that some public directories and file get own by "phpmyadmin" user and "nginx" group. is it normal? In particular, directory migrated from another server with rsync.

Code:

[02:01][root@sub.domain.com domain.com]# ls -lhrt public
totale 152K
-rw-r-----.  1 nginx      nginx 1,7K  9 feb  2016 README.md
-rw-r-----.  1 nginx      nginx  636  9 feb  2016 package.json
-rw-r-----.  1 nginx      nginx 1,1K  9 feb  2016 LICENSE
-rw-r-----.  1 nginx      nginx 2,2K  9 feb  2016 Gruntfile.js
-rw-r-----.  1 nginx      nginx  35K 10 gen  2018 index.html
drwxrwxr-x. 14 phpmyadmin nginx 4,0K 13 gen  2018 invoices
-rw-r-----.  1 nginx      nginx 6,5K 15 ott 17.45 index_centmin.html
-rw-r-----.  1 nginx      nginx 2,0K 15 ott 17.45 401.html
-rw-r-----.  1 nginx      nginx 2,0K 15 ott 17.45 403.html
-rw-r-----.  1 nginx      nginx 1,9K 15 ott 17.45 404.html
-rw-r-----.  1 nginx      nginx 2,0K 15 ott 17.45 502.html
-rw-r-----.  1 nginx      nginx 2,0K 15 ott 17.45 500.html
-rw-r-----.  1 nginx      nginx 7,6K 15 ott 17.45 503.jpg
-rw-r-----.  1 nginx      nginx 2,0K 15 ott 17.45 503.html
-rw-r-----.  1 nginx      nginx 2,0K 15 ott 17.45 504.html
-rw-r-----.  1 nginx      nginx 2,0K 15 ott 17.45 50x.html
-rw-r-----.  1 nginx      nginx 2,1K 15 ott 17.45 maintenance.html
drwxr-s---.  6 nginx      nginx 4,0K 15 ott 17.57 font-awesome
drwxr-s---.  2 nginx      nginx 4,0K 15 ott 18.00 css
drwxr-s---.  2 nginx      nginx 4,0K 15 ott 18.00 fonts
drwxr-s---.  6 nginx      nginx 4,0K 15 ott 18.00 img
drwxr-s---.  2 nginx      nginx 4,0K 15 ott 18.00 js
drwxr-s---.  2 nginx      nginx 4,0K 15 ott 18.00 less
drwxr-s---.  2 nginx      nginx 4,0K 15 ott 18.00 mail
drwxr-s---.  4 nginx      nginx 4,0K 15 ott 22.51 stripe
drwxr-s---.  5 nginx      nginx 4,0K 15 ott 22.52 ebay
drwxr-xr-x.  6 phpmyadmin nginx 4,0K 16 ott 02.01 invoiceplane

Code:

[02:01][root@sub.domain.com domain.com]# ls -lhrt public/invoiceplane/
totale 272K
drwxr-xr-x. 16 phpmyadmin nginx 4,0K  3 giu  2017 application
drwxr-xr-x.  5 phpmyadmin nginx 4,0K  3 giu  2017 assets
drwxr-xr-x.  6 phpmyadmin nginx 4,0K  3 giu  2017 uploads
drwxr-xr-x. 14 phpmyadmin nginx 4,0K  3 giu  2017 vendor
-rw-r--r--.  1 phpmyadmin nginx 2,7K  3 set  2017 DEVELOPMENT.md
-rw-r--r--.  1 phpmyadmin nginx 1,6K 16 ott 00.25 ipconfig.php
-rw-r--r--.  1 phpmyadmin nginx 5,9K 16 ott 01.25 Gruntfile.js
-rw-r--r--.  1 phpmyadmin nginx  90K 16 ott 01.25 composer.lock
-rwxr-xr-x.  1 phpmyadmin nginx  11K 16 ott 01.25 index.php
-rw-r--r--.  1 phpmyadmin nginx 1,5K 16 ott 01.25 ipconfig.php.example
-rw-r--r--.  1 phpmyadmin nginx  724 16 ott 01.25 Dockerfile
-rw-r--r--.  1 phpmyadmin nginx  640 16 ott 01.25 htaccess
-rwxr-xr-x.  1 phpmyadmin nginx 3,0K 16 ott 01.25 README.md
-rw-r--r--.  1 phpmyadmin nginx  90K 16 ott 01.25 package-lock.json
-rw-r--r--.  1 phpmyadmin nginx 1,2K 16 ott 01.25 package.json
-rw-r--r--.  1 phpmyadmin nginx 7,1K 16 ott 01.25 CONTRIBUTING.md
-rw-r--r--.  1 phpmyadmin nginx   25 16 ott 01.26 robots.txt
-rwxr-xr-x.  1 phpmyadmin nginx 5,0K 16 ott 01.26 LICENSE.txt
-rw-r--r--.  1 phpmyadmin nginx  634 16 ott 01.26 composer.json

 

Can be a bug?

Now I'm going to chown nginx:nginx those directory, now

 

I think I understood... can be possible that rsynced file/dirs inherit owner:group ids... and then the new server recognize them as a different user:group?

 

no chown command presents in the history... I think happened this:
phpmyadmin.sh Addon is it impossibile?

 

502 bad gateway

It was ok and after x days maybe related to php updates? it was not working....

I uninstall and reinstall it but again it doesn't work...

The only change that i did was to update to the latest version of php 7.2.x and to enable the systemd for php....

 

Yes it was related to systemd script for php and when i revert it, phpmyadmin was ok !
(i got also some upgrade issues on my forum that all gone after reverting it)

So something needs a fix at Phpmyadmin script ....

 

So with your fix it will work on both now?

Initd or systemd ?