Error Wrong username or password after redirection to subdomain

VPS server: Ubuntu 22.04 LTS
Software: Plesk Obsidian 18.0.60
Server: LiteSpeed 6.2.2
OpenJDK: version 11
Tomcat: Version 9.0.88

After installing Axelor 8.0.5, the application launches perfectly on http://194.164.203.221:8080/axelor/.

I created a sub-domain via plesk called: axelor.casakub.com

.htaccess file created :

RewriteEngine On
RewriteCond %{HTTP_HOST} ^axelor.casakub.com$ [NC]
RewriteRule ^(.*)$ http://localhost:8080/axelor/$1 [P,L]

The application launches correctly via the link: https://axelor.casakub.com

However, as soon as I enter my credentials, I get the following error message: Wrong username or password

I’ve tried to configure the file: axelor-config.properties | without success

Do you have any ideas on how to solve this problem?

Thanks in advance.
Alexandre

Does Catalina output anything more specific? Can you log in with admin credentials? It’s a strange issue because I haven’t been able to log in before after migrating to a newer versions because it seems my passwords for my user aren’t valid anymore. But I can always login with admin credentials no problem and then update the user passwords.

Yes, I’m able to connect without any problems via http://194.164.203.221:8080/axelor/#/; set up my modules, etc. I’ve created a redirect via .htaccess and the application is displayed on my sub-domain: https://axelor.casakub.com/ however, my credentials don’t work, I’m not sure why… ;-(

Doesn’t anyone have a solution to my problem?

Since I use plesk to install SSL certificates via Let’s Encrypt, am I required to configure SSL/TLS on Tomcat9 by creating a « keystore »?

Thank you in advance for your help…
Alexander

I’m unfortunately too unfamiliar with plesk. I use Nginx in order to do SSL and it works just fine with some configuration. Is your .htaccess possibly missing some rule? The rewrite rule on your .htaccess has a different link than the link you can access Axelor on normally. Possibly change those to be the same?

I modified my htaccess file as follows:

# Forcer le HTTPS
RewriteEngine On

# Rediriger vers Tomcat en préservant le chemin
RewriteRule ^(.*)$ http://localhost:8080/$1 [P,L]

# En-têtes CORS
Header always set Access-Control-Allow-Methods "GET,POST,OPTIONS,DELETE,HEAD,PUT"
Header always set Access-Control-Allow-Origin "https://axelor.casakub.com"  
Header always set Access-Control-Allow-Credentials true
Header always set Access-Control-Allow-Headers "Origin, Accept, X-Requested-With, Content-Type, Access-Control-Request-Method, Access-Control-Request-Headers"

# Sécuriser les cookies
<IfModule LiteSpeed>
ForceSecureCookie secure
SecureSessionCookie secure
</IfModule>

# Activer le cache et la compression
<IfModule LiteSpeed>
CacheEnable public  
CompressibleTypes text/html text/plain text/css application/javascript
</IfModule>

# Gérer les erreurs 404
ErrorDocument 404 /error-404.html

I uncommented and modified the following elements of the « server.xml » file:

<Connector 
           protocol="org.apache.coyote.http11.Http11NioProtocol"
           port="8444" maxThreads="200"
           scheme="https" secure="true" SSLEnabled="true"
           keystoreFile="${user.home}/.keystore" keystorePass="YourPassword"
           clientAuth="false" sslProtocol="TLS"/>

In my old .htaccess the « RewriteRule » line was: RewriteRule ^(.*)$ https://localhost:8444/axelor/$1 [P,L] , in reality, it had to conflict with tomcat, that’s for this reason my identifiers did not work…

Now my problem is that « tomcat » is displayed on my subdomain « https://axelor.casakub.com/ » and my application is displayed on « Axelor »

Do you have any idea of the problem?

Thanks in advance.
Alexander

Can I rename my « axelor » application to « ROOT »?

In the event that I change the name of my application to « ROOT », should I also « comment » the following code from the « web.xml » file in « /opt/tomcat/conf »:

    <welcome-file-list>
        <welcome-file>index.html</welcome-file>
        <welcome-file>index.htm</welcome-file>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>

By the way, I can access both of these sites on the internet. Not sure if that is your goal but do be careful, I did try the admin credentials and they did not work. Does your database show any users in it? I would uncomment that connector in the server.xml file. I use the basic connector that comes with the install and have Nginx reference that. Here’s a picture of my server.xml file. I don’t know how to setup SSL with tomcat but I imagine it’s not easy
CONNECTOR

I’m not sure, I don’t see why changing the name of the folder where the webapp exists would cause that issue. Your .htaccess file does include « https » in the beginning of the Rewrite Rule. Shouldn’t that be « http »?

It didn’t pose any more problem than that, but I still modified the .htaccess (see modification above).

I stopped tomcat, then deleted the root folder and edited the server.xml file by adding this:

<Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true">
           <Context path="" docBase="/opt/tomcat/webapps/axelor" debug="0" reloadable="true" />

From now on, my « Axelor » application redirects perfectly to my subdomain: https://axelor.casakub.com/

However, I had a problem this morning, my server crashed due to a memory problem. I modified all the logs to « error », made some modifications to prevent « catalina.out » from becoming too large. We’ll see if it happens again.

Applying :

<Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true">
            <Context path="" docBase="/opt/tomcat/webapps/axelor" debug="0" reloadable="true" />

This morning, my application was automatically duplicated in « ROOT », without taking into account the settings made in my « axelor-config.properties » file.