10-19-2023 09:52 AM
I wanted to post this as I was not able to find any details/guides about how to deploy Lansweeper in AWS utilizing RDS for the database. With some testing, I currently have a production Lansweeper environment running on an EC2 instance and an RDS database.
The only post that I found discussing this architecture was this:
Installation Guide for installing Lansweeper in AW... - Lansweeper Community - 27539
The challenge mickjf was facing is that AWS does not support assigning the sysadmin server-level role as the service that AWS provides is completely managed and does not allow any input from the user to the OS. During the Lansweeper installation if you choose to connect to an external database and provide the details, it checks if the provided user has the sysadmin role. If it does not, it will not proceed with the installation.
I found a reasonable workaround to solve this issue. This was much easier than anticipated.
Keep in mind that this is for a fresh install of Lansweeper.
The configuration for the RDS is as follows:
Note: Make sure to choose the correct time zone upon creating the RDS. This cannot be changed when created. If you encounter this issue, you can follow this guide from the AWS documentation and set the time zone again when restoring the RDS from the backup.
The solution is as follows:
Lansweeper will now skip checking if the user has the sysadmin role, proceed to check the database. It will find that the schema is missing and create it.
You can following along this process and tail the logs by launching PowerShell and entering the following commands:
cd 'C:\Program Files (x86)\Lansweeper\Service\'
Get-Content errorlog.txt -Wait -Tail 30
You can verify the connection to the database using DatabaseMaintainance.exe found in C:\Program Files (x86)\Lansweeper\Tools.
After that Lansweeper should up and running using an RDS database.
I hope that the Lansweeper team could test this themselves and modify it to be included in the official documentation.
If you have any questions, don't hesitate to ask.
10-19-2023 07:19 PM
This is really helpful - thank you for sharing with the rest of the community
10-20-2023 08:51 PM
Happy to help
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now