AWS and RDS  Topic is solved

Discussions relating to plugin development, and the Jiwa API.

AWS and RDS

Postby SBarnes » Fri Oct 11, 2019 11:38 am

Is Jiwa supported to be run under AWS and RDS?
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: AWS and RDS  Topic is solved

Postby Scott.Pearce » Fri Oct 11, 2019 2:47 pm

No. That's not to say it won't work though.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: AWS and RDS

Postby SBarnes » Fri Oct 11, 2019 2:50 pm

:lol: that's what I told the person who asked as I said given a connection string and created users it should work
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: AWS and RDS

Postby Mike.Sheen » Sat Oct 12, 2019 11:09 am

Also just be aware our next release (7.3 and the dev builds preceding that - 7.2.2 onwards) leverage contained database authentication, which requires SQL 2012 or later (previously SQL 2008R2 was supported) - so whatever version of MSSQL which Amazon's RDS for MSSQL uses needs to be SQL 2012 or later.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755

Re: AWS and RDS

Postby SBarnes » Wed Oct 16, 2019 10:16 am

See below, straight out of AWS documentation.

SQL Server 2017 RTM (CU13) 14.00.3049.1, released per KB4466404 on January 01, 2019.

SQL Server 2016 SP2 (CU3) 13.00.5216.0, released per KB4466404 on September 20, 2018.

SQL Server 2014 SP2 CU10 12.00.5571.0, released per KB4052725 on January 16, 2018.

SQL Server 2012 SP4 GDR 11.00.7462.6, released per KB4057116 on January 12, 2017.

SQL Server 2008: It is no longer possible to provision new instances in any region. Amazon RDS is actively migrating existing instances off this version.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: AWS and RDS

Postby NinaT » Fri Apr 09, 2021 11:14 am

Hi,
Just wondering if there has been a change to Jiwa being supported on RDS?
NinaT
I'm new here
I'm new here
 
Posts: 7
Joined: Tue Mar 16, 2021 3:54 pm
Topics Solved: 0

Re: AWS and RDS

Postby SBarnes » Fri Apr 09, 2021 11:31 am

As far as I know it's still not supported but as Scott said may work, the trick from having worked with Azure SQL is you need to make sure the requisite users JiwaLogin, JiwaUser and JiwaReports are created on the server with appropriate passwords.

The other thing is any databases regardless of being Jiwa ones also need to have these users as there was a bug related to this that I'm not sure has been fixed yet which causes issues with creating a connection.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: AWS and RDS

Postby NinaT » Fri Apr 09, 2021 12:32 pm

Scott/Mike,
Any potential change to this in the future given that Amazon are starting to make a push into the Australian SME market.
NinaT
I'm new here
I'm new here
 
Posts: 7
Joined: Tue Mar 16, 2021 3:54 pm
Topics Solved: 0

Re: AWS and RDS

Postby Mike.Sheen » Mon Apr 12, 2021 11:40 am

NinaT wrote:Scott/Mike,
Any potential change to this in the future given that Amazon are starting to make a push into the Australian SME market.


Hi Nina,

We think there may be nothing to do - but can't say for sure until someone spends the time to try.

I've logged DEV-8683 to verify that Jiwa does work ok with AWS RDS.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755

Re: AWS and RDS

Postby NinaT » Mon Apr 12, 2021 11:46 am

Thanks Mike, greatly appreciated!
NinaT
I'm new here
I'm new here
 
Posts: 7
Joined: Tue Mar 16, 2021 3:54 pm
Topics Solved: 0

Next

Return to Technical and or Programming

Who is online

Users browsing this forum: Google [Bot] and 1 guest