Create Separate DB for Subdomain(Vhost)

I create a git.example.com/gitea as subdomain as vhost. However, under databases, the drop-down doesn't include "git.example.com/gitea"

So my question is how do I create the db for the subdomain?

 

I've done that... and now I have tried both variants of the gitea documentation apache reverse-proxy settings

Code:

  ProxyPreserveHost On
    ProxyRequests off
    AllowEncodedSlashes NoDecode
    SSLProxyEngine on
    ProxyPass /.well-known !
    ProxyPass / http://127.0.0.1:3000/ nocanon
    ProxyPassReverse / http://127.0.0.1:3000/
   
   
   -or-

    <Proxy *>
         Order allow,deny
         Allow from all
    </Proxy>
    AllowEncodedSlashes NoDecode
    # Note: no trailing slash after either /git or port
    ProxyPass / http://127.0.0.1:3000 nocanon
    ProxyPassReverse / http://127.0.0.1:3000

both result in a 500 server error...
so I removed the apache directives from the options page... and disabled proxy... interestingly, I get a 404 error stating that
https://git.example.com/gitea doesn't exist. I was expecting the default green "welcome to your site" message.

 

I need to run an errand before I check the other logs, but apache error log has one error
[Mon Oct 04 17:49:04.240411 2021] [:error] [pid 18198] avahi_entry_group_add_service_strlst("server1") failed: Local name collision
[Mon Oct 04 17:49:04.241945 2021] [:error] [pid 18198] avahi_entry_group_add_service_strlst("server1") failed: Local name collision

 

With subdomain(vhost) -> options -> proxy enable using the apache directive below for the reverse proxy

Code:

ProxyPreserveHost On
    ProxyRequests off
    AllowEncodedSlashes NoDecode
    SSLProxyEngine on
    ProxyPass / http://127.0.0.1:3000/ nocanon
    ProxyPassReverse / http://127.0.0.1:3000/

I get a 500 server error:
gitea log is empty
/var/lib/gitea/log

checking the site error log:

Code:

#cat /var/log/ispconfig/httpd/git.example.com/error.log
Mon Oct 04 19:18:07.798332 2021] [proxy:warn] [pid 2930] [client 40.387.652.176:52522] AH01144: No protocol handler was valid for the URL /gitea (scheme 'http'). If you are using a DSO version of mod_proxy, make sure the proxy submodules are included in the configuration using LoadModule.
[Mon Oct 04 19:18:07.800696 2021] [proxy:warn] [pid 2930] [client 40.387.652.176:52522] AH01144: No protocol handler was valid for the URL /error/500.html (scheme 'http'). If you are using a DSO version of mod_proxy, make sure the proxy submodules are included in the configuration using LoadModule.

The apache error log doesn't show any relevant error, the only error is the showing that I haven't, whitelisted my monit url on my prod server yet.

 

I enabled the missing submodules...(below), but ran into a new 500 server error

Code:

#a2enmod module proxy_http
#a2enmod proxy_balancer

Code:

AH00898: Error during SSL Handshake with remote server returned by /error/500.html
AH01097: pass request body failed to 127.0.0.1:3000 (127.0.0.1) from
40.387.652.176 ()

Didn't see a quick fix for this... any tips?

 

cracked it!

a bit of trial & error
but using

Code:

ProxyPreserveHost On
    ProxyRequests off
    AllowEncodedSlashes NoDecode
    SSLProxyEngine on
    ProxyPass /.well-known !
    ProxyPass / http://localhost:3000/ nocanon
    ProxyPassReverse / http://localhost:3000/

seems to solve the problem (I literally exchange 127.0.0.1 for localhost, which I advised against doing in a different forum)

now https://git.example.com/gitea sends me to https://git.example.com and displays the gitea installation page.

I haven't tried the install yet.. but looks good.

 

'twas a short lived victory. The install went sideways...
the login page should have loaded following the install, instead I was taken to

https://git.example.com/git.example.com/user/login

with these errors:

Code:

AH00957: HTTP: attempt to connect to 127.0.0.1:3000 (localhost) failed
AH01114: HTTP: failed to make connection to backend: localhost

anyway will revert to these directives:

Code:

ProxyPreserveHost On
   ProxyRequests off
   AllowEncodedSlashes NoDecode
   SSLProxyEngine on
   ProxyPass /.well-known !
   ProxyPass / http://127.0.0.1:3000/ nocanon
   ProxyPassReverse / http://127.0.0.1:3000/

and call it a night... tips.. welcome

 

Ok.. I am back on test server... I have a basic question:

I have the subdomain vhost git.example.com with web folder "gitea".
so I ssh into the server and copied the standard_index.html into "gitea"

But instead of seeing the index.html, the browser shows the default home of the wp site located at example.com.

How do I fix this?

 

Actually, figured it out... I put apache into debug mode... and ran apache2ctl -S which showed that my alias for git.example.com wasn't being recognized.

is it impossible to add an alias to subdomain vhost? i.e. (test.git.example.com)

Via the gui.. it says I successfully created that alias, but apache denies it.

 

I just checked... not there isn't .err version for this subdomain vhost.

 

Whats happening is that tester1.git.example.com is "reverting" to tester1.example.com... but no .err vhost is being generated.
Whereas if I go to git.example.com I get the proper landing page.

Not a huge problem.. but I want to avoid missteps between prod and test, hence I always use a "tester1." domain alias locally.

 

I think anyone who reads my bumbling posts can figure out that I am far from being a coder capable of editing source code... Seemed odd.. so I added the screenshot above..

As for steps.. I just added tester1.git.example.com in the top field and selected example.com from the drop-down.

 

I don't work on this everyday... still climbing the learning curve from zero... I wanted tester1.git.example.com, so I typed that.. In any case, sorry for setting off any alarm bells... now I know.