IMPORTANT: due to the security updates since CrushFTP version 10.5.2+ any JDBC driver jar file needs to be placed into the CrushFTP10/plugins/lib/ directory, or it won't load.

You can also set whether CrushFTP is using XML files for its users and groups, or if its using SQL for this. We do not recommend using SQL for the backend storage of users. While it is supported, it adds another potential point of failure, adds delays for the login process as SQL is queried for results, and has limitations on column sizes for large data structures like "events" or "custom css" and "custom javascript" and others. It's only suggested to use this method when forced to use it by company policy that ignores our recommendation of best practice. CrushFTP supports replication and clustering of user configuration across multiple locations using the normal XML database of users.

---

SQL users are not equivalent to XMl users. They have limitations. They can be in conflict with each other with multiple servers writing to the same DB. Use at your own risk with your own POC testing for your scenarios. SQL users will never be as fast as XML users, nor will we ever treat it as an equivalent supported feature as XML. SQL is 2nd class when it comes to its capabilities and speed, etc.