Encrypted, Authenticated, Dual-stack, Single User Data Source that supports attachments
Encrypted, Authenticated, Dual-stack, Single User Data Source that supports attachments
I am looking for a way to accomplish the following with a Data Source
1. Can be accessed on tcp/443 with TLS encryption
2. Works on both IPv4 and IPv6
3. Provides an authentication mechanism
4. Supports attachments
5. Doesn't cost a fortune per year
6. Doesn't depend on 3rd party drive sync. Makes mobile complicated.
*. Bonus of being multi-user and having connection logs.
Going down the list of Data Sources, I am left with very few potentials.
AWS - no attachments
Devolution Server - $500/yr to get attachments.
Dropbox - no attachments
FTP - no attachments
MariaDB/MySQL - doable, but very hackish
Access - lol, no
Azure - Can't change the port (AFAIK)
SQL Server - Expensive to host, but might be doable
Online Drive - no attachments
SFTP - no attachments
SQLLite - not networked, would require Dropbox/Drive/other to share DB around.
Web - Read Only
XML - not networked, would require Dropbox/Drive/other to share DB around (What I am doing currently + Keepass)
MariaDB/MySQL is currently the "best" solution, but it is very hackish to get it dual-stacked, on port 443 and using SSL.
Is there a better solution? I would be happy to pay something like $5/mo for Online Drive if it included attachments.
All Comments (6)
Hello,
Indeed Azure is only on port 1433, sad because its the best solution for power users IMHO.
I had a great experience with AWS EC2 in the past, the MySQL connector should work. Sadly I cannot comment on the initial setup complexity.
Devolutions Online Drive is meant to be a simple data source, I do not expect we will add the attachments in the near future.
Sorry about that,
Maurice
It would be great if there could be some combo of SFTP+SQLLite. If/when I get MySQL/MariaDB/other functional as I want it, I will try to post a howto.
After a few more hours of futzing with this, I have found 2 more problems.
1. The MySQL/MariaDB doens't even attempt to connect over IPv6. Straight to v4 when dual stacked.
2. More importantly, I can not find any mechanism to tell RDM to use TLS for the connection. Only references to MySQL/MariaDB and SSL are for client authentication. Is that even a function within RDM? MySQL/MariaDB over TLS?
Bump, can MySQL/MariaDB connect over TLS? I setup MySQL with SSL and created a REQUIRE SSL user and the connection just fails. Its possible I've misconfigured something though.
Hello,
In the advanced tab of the data source properties, there is an "Advanced settings" button.
AFAIK, if you've imported the certificate to your store, you should only have to use two of these settingsCertificate Store Location=CurrentUser Certificate Thumbprint=[your cert thumbprint here]
Maurice
forgot about SSL Mode=Requiredso three settings in all
Maurice