Question

Is Amazon RDS supported as repository db

Laserfiche Version 10

Updated May 10, 2019

asked on May 2, 2019

A customer is hoping to use Amazon RDS for their new RIO repository database.

The laserfiche server components are installed on a separate AWS server with port 1433 open to Amazon RDS.

They have provided a dedicated SQL account with dbo access for Repository Creation, however the Wizard is unable to complete the creation of the schema with the access provided.

Is it possible to provide scripts for the customer to create the repository?

Is Amazon RDS a supported db environment?

many thanks

0 0

Replies

replied on May 9, 2019

Amazon RDS is just SQL Server. It'll work fine. We're still validating Azure SQL (though, at this time it's missing Filestream as a feature, so it is not suitable for Laserfiche Discussions).

One thing to be aware of is that if you're hosting the server in your organization and connect it with Amazon RDS, there's likely to be more latency due to your internet connection.

1 0

replied on May 3, 2019

I was looking for a similar answer last year using Azure SQL instances and got no reply from Laserfiche. https://answers.laserfiche.com/questions/134035/Laserfiche-on-Azure-Servers-and-Azure-SQL-Server#134605

You probably need to create your SQL databases locally and then migrate to Amazon RDS. However, I'm not sure about what happens with upgrades when the database needs to be converted. We just ended up using SQL Server installed on an Azure VM for production.

0 0

replied on May 8, 2019

Hi,

Could we please have a formal reply from Laserfiche that can give support guidance to the customer?

If not in 10.4 could you please advise if support for Amazon RDS is on the roadmap?

many thanks

0 0

replied on May 9, 2019

Hi Miruna,

Many thanks for your guidance.

The database has been previously created by the customer with an SQL account assigned as dbo to connect and create table schema.

When I execute creating the repository the error in the attached screenshot is displayed.

Also the following error is logged in Event Viewer;

There was an error creating the Laserfiche repository "Payroll". Function=ALTER DATABASE [laserfichepayroll] SET RECOVERY SIMPLE; Error=0x5BC; [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The operation cannot be performed on database "laserfichepayroll" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.

The repository isn't created.

Many thanks for your help

Repository Wizard error1.JPG (51.15 KB)

| Download

0 0

replied on May 10, 2019

That looks like a bug in the Laserfiche Server where it always tries to set the recovery mode to simple. Reference ID 171096. We'll try to address it for the 10.4.1 release next month.

In the meantime, I think you can temporarily disable the multi-availability zone feature of the database and reenable it after the repository is created.

1 0

replied on May 10, 2019

Seconding Miruna's point about temporarily disabling Multi-AZ on the RDS instance, as that feature implements database mirroring/availability groups on the backend.

I have successfully created many repository databases on RDS with Multi-AZ turned off.

0 0

You are not allowed to follow up in this post.

Question

Question

Is Amazon RDS supported as repository db

Replies

Sign in to reply to this post.