Hello, I’ve been trying to use HAProxy as a reverse proxy and load balancer to 3 frappe/erpnext virtual machines. Currently, the haproxy IP works, but I get stuck on the log in because of an authentication problem.
I get this error once I enter the login credentials correctly:
here is my haproxy config file:
log /dev/log local0 notice
timeout connect 5000
timeout client 50000
timeout server 50000
option httpchk HEAD / HTTP/1.1\r\nHost:localhost
http-request del-header Authorization
server frappe 192.168.254.200:80 check
server frappe1 192.168.254.201:80 check
server frappe2 192.168.254.202:80 check
Any help would be appreciated. Thanks!
Can you delete lines from backend that begin with option httpchk… and http-request del-header? See if it changes error. I am using haproxy for one of our installation and does not have those lines. Rest configuration seems fine. Seems no https - fyi.
I have seen this error when someone tries to access a document using QR code (url) in say sales invoice (pdf) but does not have login credentials.
Interested to know how you sync database across nodes… Will appreciate if you could share any info on that.
I tried doing that at first, still had the same error. I found a thread here in discuss where they added the lines but yeah, it’s still not working.
Will be using either Mariadb Galera clustering or Percona to sync the db’s. Or might have to use a remote mariadb host. If HAProxy and the clustering doesn’t work, might have to result to upgrading our server to higher specs instead of setting up a cluster.
Managed to get it working by enabling session stickiness. Now all I have to do is figure out out how cluster the databases without breaking the installation. Thanks!