03-22-2021, 11:59 PM
... problem solved thanks to the Delphi-PRAXiS user group.
There is a FireDAC component (TFDMoniFlatFileClientLink) that I forgot all about that allowed me to pin point the problem.
This maybe one for Alexandre.
In my database I log the IP addresses for all log in attempts.
When a user connects through the Azure Load Balancer, the WebApplication.IP returns the IP Address AND Port resulting in a string longer than my database field is set for.
I have used other load balancers with IW apps in the past but this is the first time I experienced this.
The easy solution was to truncate the string to exclude the Port.
There is a FireDAC component (TFDMoniFlatFileClientLink) that I forgot all about that allowed me to pin point the problem.
This maybe one for Alexandre.
In my database I log the IP addresses for all log in attempts.
When a user connects through the Azure Load Balancer, the WebApplication.IP returns the IP Address AND Port resulting in a string longer than my database field is set for.
I have used other load balancers with IW apps in the past but this is the first time I experienced this.
The easy solution was to truncate the string to exclude the Port.