Score:1

Not permitted to view my newly installed phpMyAdmin

gb flag

I'm using Google Compute Engine to host a couple applications under one .dev domain so SSL is required.

I have Apache installed based from this guide and my /var/www/ directory looks like:

- domain.dev/ (currently in use - WordPress site)
  - html/
    - wp-content/
    - index.php
    - ...
  - log/
- database.domain.dev/ (currently unused - I want to access phpMyAdmin by going to this URL)
  - html/
  - log/
- subdomain.domain.dev/ (currently in use - a separate project but still under the same domain)
  - html/
    - css/
    - scripts/
    - index.php
    - ...
  - log/

Right now I can visit these three URLS and they work, except of course database.domain.dev - it just gives me the default page that shows Apache is working. I'm trying to install phpMyAdmin on this subdomain but it's not working.

I already have MySQL installed on this server - it's what WordPress is using. I plan to add another database and another user to it that's why I'm trying to install phpMyAdmin as it's easier to manage from there.

SSL is already working since I can see the page that shows Apache is working when I visit the page. The DNS settings have been taken care of from GCP's Cloud DNS.

On my /etc/httpd/sites-available/database.domain.dev.conf, I have this:

<VirtualHost *:80>
    ServerName www.database.domain.dev
    ServerAlias database.domain.dev
    DocumentRoot /var/www/database.domain.dev/html
    ErrorLog /var/www/database.domain.dev/log/error.log
    CustomLog /var/www/database.domain.dev/log/requests.log combined
    RewriteEngine on
    RewriteCond %{SERVER_NAME} =www.database.domain.dev [OR]
    RewriteCond %{SERVER_NAME} =database.domain.dev
    RewriteRule ^ https://%{SERVER_NAME}%{REQUEST_URI} [END,NE,R=permanent]
</VirtualHost>

On my /etc/httpd/conf.d/phpMyAdmin.conf, I have this:

Alias /manage /usr/share/phpMyAdmin

...

<VirtualHost *:80>
    ServerAdmin [email protected]
    DocumentRoot /var/www/database.domain.dev/html
    ServerName database.domain.dev
</VirtualHost>

When I visited https://database.domain.dev/manage I expected to see phpMyAdmin pop up but I got an error that said I'm not permitted to view the page. When I tried https://database.domain.dev/bogus it said, the URL can't be found. So that gives me an idea that the alias is working but I don't know why I don't have access to view the page.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.