Question

Litespeed (OLS) phpmyadmin access - Error 404 after installing SSL..?

Aaargh! Just lost an entire post during login - please fix your sessions, DO!</rant>

I have an Ubuntu 18.04, Wordpress, MySQL, Litespeed OLS installation and had access to my phpmyadmin via the IP address. I installed the SSL and got that setup and running and now I can’t figure out how to configure OLS to access my phpmyadmin.

I’ve tried putting a static context on the OLS VH to redirect */phpmyadmin/ to the phpmyadmin directory on the server, but I just get the Wordpress 404 error.

Obviously I’m missing something, but I don’t know what.

Any ideas? I’m new to Litespeed server (pls note: NOT using Apache or Nginx, and articles describing how to configure them haven’t been helpful).

Thanks in advance for your help with this!

Regards, Justin

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Have you tried using a subdomain like https://sql.mencher.net/?

OK, Eric helped me with the solution - many thanks for your time and attention, Eric!

We’re in Litespeed Server Admin: Virtual Host > Context > Static

It seems that the URI and the Location don’t quite work the way the tooltips imply - which is that <Location> is appended to the <URI>.

In fact, the Location (which is the directory you’re mapping to) needs to include the directory name itself (not just the path to the directory it’s in).

Example: URI: /phpmyadmin/
–> this is what’s appended to your VH domain, i.e. what the user accesses: https://www.domain.com/phpmyadmin/

Location /var/www/phpmyadmin/ –> NOT /var/www/

(These are default locations for the DO image I downloaded, YMMV).

Summary: tooltips need updating, plus a How-to maybe?! Thanks!

Hi,

Do you mean issue now is visiting phpmyadmin and return a 404 page?

It maybe faster to help you with the issue on LiteSpeed Community on Slack

You can direct message me @eric, or just post your question in random channel.

Best, Eric

Hi @digitalocean1918664677468e,

LiteSpeed does provide an wordpress+openlitespeed+MariaDB+CertBot+phpmyadmin solution image on Marketplace.

So you can just launch and play with it in few minutes.

If you want to manually setup a phpmyadmin context, please see example settings below:

  • URl: /phpmyadmin/
  • Location: YOUR_PHPMYADMIN_PATH
  • Accessible: Yes
  • Index Files: index.php
  • Access Allowed: *
  • Enable Rewrite: No
  • Rewrite Inherit: No

Best, Eric

Hey Justin,

I understand your frustration but (I may be wrong) whoever signs a SSL cert signs it for the requested domain… not the IP address. Please try it with the domain for the droplet.

I hope this helps, Bud Manz