I use Cloudflare and my VPS ip is hidden, so for me it’s better to open phpmyadmin from ipvps/phpmyadmin that giving the opportunity to someone go to mysite/phpmyadmin/ and try their luck. Please if it’s possible give me 2 ways/solutions on how:
why not just use it from hostname like it should be used? It is web and should be used anyway over ssl, so just open it from a secured domain and you’re good to go (https://hostname.domain.tld/phpmyadmin).
Thanks! Yes because I installed it from the command line. IDK how to install it from the Hestia. It seems like there’s no file manager on Hestia. At least I didn’t find it.
Please give me the command to make it owned by Hestia
I’m sorry, but I think we need to draw a line here: The idea behind the forum is to help out with hestia related issues and questions. In your case, and I don’t mean this in any case offensive, there is a big lack of knowledge how to handle linux systems including their right management.
I would suggest if you could have a look at a (reseller) webhosting, which would probaly fit better with your requirements.
I asked only a line. That’s it. And it think it’s kinda related to the hestia, because when it’s installed, my forum isn’t woking. Okay I’ll wait monsieur Lupu. Thanks for you time.
I use VPS because I have a lot onf things on it, not only sites. Rocket.chat, nextcloud, vpn, socks, dns.
@danonanon
The easiest way to open PHPMyAdmin would be using your direct IP/phpmyadmin or whatever you changed your URL with PMA command ScIT quoted above.
If IP/phpmyadmin doesn’t work and if you are behind Cloudflare, just create an entry in your hosts file like 1xx.2xx.xxx.xxx ServerName
and then open in your browser ServerName/phpmyadmin
This will bypass cloudflare’s lookup and take you straight to PHPmyAdmin.
I think you fiddled up way beyond needed, you did not needed to have PMA install of your own as Hestia already installs it for you globally server wide. Better start with a clean install if possible or else go step by step about permissions as advised above
I asked only about a line…not about the whole guide…
chown -R www-data:www-data /var/www/vanilla
As far as I understood Lupu, I need to change that www-data:www-data
What hestia created? I found hestia-users in /etc/group and tried
root@vps:~# chown -R hestia-users:hestia-users /var/www/vanilla
chown: invalid user: ‘hestia-users:hestia-users’
I’m really tired of finding the solution. Spend almost 2 days for it. Why not just to give me the nice solution, the line? I’m not a pro like you and it’s harder for me to find the solution.
If your hestia had file manager I would not ask this question and would not face this problem and my forum would work well because it was created from file manager, not the command line with different ownership.
Wrong User, probaly wrong position. I think you’re in /home/USER/web/DOMAIN/public_html. So according it should be something like chown -R USER:USER /home/USER/web/DOMAIN/public_html.
Because, as I described above, this problem is not related to hestia - it is a user sided issue due to a lack of knowledge.
Please be sure what you are doing here: You running a whole webserver in the wild (aka internet) - you have to maintain the server, install updates, be able to read/understand the logs and much more points. If you don’t know how to handle it, your server is a risk and can probaly get hackend - so we have a server more that is part of a botnet or spamming around…
Yeah my bad. I was so dissapointed that tried wrong location
chown -R user:user /home/user/web/mysite/public_html
This helped me. Thans for you time once again I’m happy now.
Here you sound like maintainin a vps is so hard like sending rockets into space. It’s not like that. But yeah sometimes I spend 2-3 days to find a solution which is so easy…
My server has been audited a few months ago, so it’s ok, no botnets and ip isn’t in blacklist for spamming cause there’s no spamming.
Once again thanks for the help. Now I’m totally happy