Questions tagged [ssl]

Secure Sockets Layer (SSL) is a cryptographic protocols that provide communication security over the Internet.

54 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
637 views

Create an SSL connection with ODBC driver to MySQL(5.6) using openSSL

I want to create an asymmetric SSL connection from MySQL to an ODBC driver but don't fully know how to generate the keys and certificates (I'm using openSSL as recommended here: https://dev.mysql.com/...
3
votes
1answer
730 views

MySQL 5.7 enforce SSL

I'm using MySQL 5.7 and I want to set up SSL to force the client to use a cert. This cert is a self-signed cert that I generate. I have the cert for both server and client being: - CA - cert - key ...
3
votes
0answers
155 views

Securing a Cassandra Cluster

We've managed to set up a Cassandra 2.2.6 cluster of two physical nodes (nodetool sees both of them, so I'm quite certain the cluster is indeed active). My steps to create the cluster were (this ...
3
votes
0answers
149 views

SSL for security - Percona MySQL

I have been told to implement SSL in my Master-Master MySQL instances by my security team to have secure traffic only to be received at the database end. I have never implemented SSL in a database ...
3
votes
0answers
60 views

How can I attach the SSL authenticated certificate for my SQL Server 2014 if it is not on domain controller

We have Microsoft Azure with Windows Server 2012 R2 in Cloud Computer and window Server is Standalone it is not come under domain controller. We want to add SSL authentication. SQL Server is not ...
3
votes
0answers
1k views

MySQL SSL using MariaDB JDBC Driver

We have the following setup: Ec2 instance running a jboss server with mariadb (1.1.7) datasources setup to connect to an rds instance running MySQL 5.6.21. We would like to turn on SSL on for this ...
3
votes
1answer
2k views

SSL on AWS Postgres RDS

I was reading this: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.SSL Step 2 says "Install the certificate in your operating system", but I ...
2
votes
0answers
2k views

Configuration of TCP/IP with SSL and TLS for Oracle

I am trying to configure the connections to my Oracle database with tcp / ip using ssl I have been guided by the procedure of the site https://oracle-base.com/articles/misc/configure-tcpip-with-ssl-...
2
votes
0answers
192 views

Postgresql: Enable TLS for localhost connections

What are the advantages and disadvantages to enable TLS to a Postgresql that only gets connections on localhost?
2
votes
0answers
20 views

remote postgres user logon with certificate

I would like to have each remote user logon using an SSL certificate and use their postgres logon role to better track their use of the system. I can set up a certificate for a given user per the ...
2
votes
0answers
344 views

Can you force pgpool to require SSL connections?

Can you force pgpool to drop non-ssl connections? I know you can with postgresql (Force PostgreSQL clients to use SSL?), but dropping that same syntax (hostssl instead of host) results in a hba_pool....
1
vote
0answers
28 views

PostgreSQL cannot work when opens SSL on Windows 10

I am not sure this topic will fit here but I don't know ask it where. I am trying to open the SSL of PostgreSQL 10.16 on Windows10. I read a lot of documents about creating an SSL certificate to ...
1
vote
1answer
338 views

Not able to connect to Mongodb vie mongo shell

I am no able to connect to mongodb via mongo shell. command: sudo mongo --tls --tlsCertificateKeyFile server.pem --tlsCAFile CA_INTERMEDIATE --host "mongodb://xxx:xxx@some-url:27020/data_base?ssl=...
1
vote
0answers
243 views

Unable to Connect to SQL Server 2005 through ODBC drivers from Windows 2012 server

We are unable to connect to a specific Database server which has SQL Server 2005 installed on Windows 2003 server from any of the Windows Server 2012. It used to work till last week, the only change ...
1
vote
0answers
96 views

Force psqlODBC Postgres drivers to use Windows Trusted Root Certificate Store

I need to configure my client software to use SSL when connecting to a postgres database (sslmode=verify-full). The configuration requires me to specify a root certificate file in the following ...
1
vote
1answer
799 views

Connection string for connecting mongo database with SSL enabled

Am facing some below problem in my mongodb replication environment I have 3 replica set environment with SSL enabled and ssl mode as preferSSL 3 servers has 3 different Key file with common CA file ...
1
vote
0answers
70 views

SSRS default URL not being referenced from Windows application

I have installed and configured SSRS and when I check the URL via HTTP it works fine (I haven't configured SSL). When I try to run a report from the Windows application, I get the following error ...
1
vote
0answers
329 views

SSL certificate for MS SQL Server

I'm trying to implement SSL certificate on a SQL Server and I already tried two methods. I tried with lets encrypt service and self certificate generated on Powershell. In the first scenario I can ...
1
vote
1answer
32 views

Why MongoDB not running SSL?

I need to run MongoDB with SSL, the version that is currently installed is 3.4.16 without SSL. Can I download 3.4.16 with SSL and just stop the service copy the Bin files across and then start up the ...
1
vote
0answers
257 views

Mongoimport with SSL

I want to dump a database in a remote server www.myweb.io with ssl. The mongo version is 2.6.12. It seems that I have to use mongoimport. I am looking at /etc/nginx/sites-enabled/myweb.io: server { ...
1
vote
2answers
2k views

Pulling data on SSL expiration from SQL server

I am trying to figure this out and seems to be out of thoughts and need your inputs to help me figure out on this. We have implemented SSL across our 200+ servers, SQL2012 & 2014. These cert are ...
1
vote
0answers
66 views

Does mongodb support Entrust based ssl

I am getting SSL: error:14094412:SSL routines:SSL3_READ_BYTES:sslv3 alert bad certificate" error at mongod console while connecting using ssl. and " exception={com.mongodb.MongoSocketOpenException:...
1
vote
0answers
1k views

MongoError: self signed certificate in certificate chain

I am trying to connect my node server with mongodb with ssl options enabled. mongod.conf storage: dbPath: /var/lib/mongodb journal: enabled: true # where to write logging data. systemLog: ...
1
vote
0answers
36 views

How do I log non-SSL connections to MySQL 5.5?

I've recently converted my applications to connect to MySQL 5.5 using SSL. However, I'm afraid that I've missed something, so I'm also allowing non-SSL connections to the server. How can I log ...
1
vote
0answers
270 views

MySQL SSL Master-Slave replication not syncing

I have originally posted this thread on stackoverflow and after a comment I moved it here. The original post can be found here. I have setup a typical Master-Slave replication scheme for my MySQL ...
1
vote
1answer
518 views

How to enable use of SSL in MySQL server?

I have 2 devices on my local network: a remote MySQL server (using MariaDB 10.3) and a laptop (acting as a client with Python). I need to connect to a remote MySQL server via Python using SSL ...
0
votes
1answer
7 views

MongoDB TLS unable to get issuer certificate

I'm setting up a MongoDB server, and wanted to use TLS from a proper CA and DNS. I got a domain name and put an A record in, linking to my server. Afterwards, I applied for a SSL certificate on ...
0
votes
0answers
18 views

Encrypted ODBC driver fails when job is scheduled in SQL Server Agent

I have installed an ODBC driver (system DSN) on a SQL server to connect to an external database. It uses SSL encryption. In SSMS I am able to query it using a linked server and openquery(). In C# ...
0
votes
0answers
26 views

AWS RDS Database not in a VPC, no SSL

If an AWS EC2 Server is connecting to an AWS RDS Database, but the database + server are not part of a VPC, and there is no SSL setup on the database... Does that mean the data is being sent over HTTP ...
0
votes
0answers
152 views

Postgres: ODBC: ERROR: SSL connection has been closed unexpectedly; Error while executing the query

I'm currently in Australia and so is the database. Staff attempting to connect to the database from overseas (USA, UK) consistently run into the error: ERROR: SSL connection has been closed ...
0
votes
1answer
55 views

MySQL SSL Setup

I am using the MySQL 5.7 SSL Setup Guide (combined with a few other guides on the website + google searches). I have a replica and source working, I am now trying to configure SSL. My understanding is ...
0
votes
1answer
96 views

Connect windows 2000 to sql server 2016

I have a really old piece of industrial equipment that connects from windows professional to a sql server 2008r2 on win 2008R2, not completely patched. We cannot replace the windows 2000, but would ...
0
votes
0answers
53 views

MySQL SSL Gives Warnings about big name Certificate Authorities

I have been able to setup my MySQL to use LetsEncrypt certificates with the steps below, unfortunately it is issuing warnings about official certs being self-signed (like from DigiCert, Comodo, etc...)...
0
votes
0answers
29 views

Can't connect to postgresql database with SSL using GSSAPI

With postgresql 12.4, I've got this in pg_hba.conf: hostssl all all 192.168.0.0 255.255.0.0 gss map=myrealm but whenever I try to connect with: psql 'postgresql://hostname/database?sslmode=require' ...
0
votes
0answers
227 views

postgresql server, can connect with SSL, permission denied

I installed and used a Postgresql server a while back and have been using it with Postgis. I would like to use my letsencrypt certificates with the server so i followed this article: https://medium....
0
votes
1answer
316 views

Enabling TLSv1 in postgres12 / openssl1.1.1f

After upgrading a server to postgres12 / OpenSSL 1.1.1f (Ubuntu 20.04) I got tlsv1 alert protocol version error messages from a client using an old openssl 1.0.1 library supporting only tlsv1. I ...
0
votes
0answers
25 views

Is my connection using SSL or not?

I have two MySQL 5.7 databases ([db1] 5.7.27 and [db2] 5.7.29) (n.b. db1 is Linux, db2 is Windows) I have created a basic user on db1: CREATE USER 'ssltest'@'%' IDENTIFIED BY 'ssltest'; GRANT ALL ON *....
0
votes
0answers
48 views

After enabling SSL in Oracle user must log in twice

I've enabled SSL for my Oracle 12c DB. The lsnr starts up fine and I can access it via a sqlplus / as sysdba (no password auth there, it's OS local). However, if I attempt to connect as a user which ...
0
votes
1answer
211 views

For SSL renewal procedure in Db2 LUW , DO i need to create CSR request for each instance residing in same server?

I am trying to renew my SSL certs . Stuck here if we need to have create a Certificate Signing Request for each instance residing on the same server and send it to CA who will provide us the ...
0
votes
0answers
1k views

How to turn off SSL for Postgres for remote connections?

After changing the pg_hba.conf file and setting it to 0.0.0.0/0 and editing the postgresql.conf file to listen_addresses='*', Postgres is still not accepting connections from a remote system. I think ...
0
votes
1answer
66 views

ssl with postgresql 12

I tried following the docs for the same. It says postgres.conf will have service.crt for ssl_cert_file, but it has /etc/ssl/certs/ssl-cert-snakeoil.pem and now I can't proceed with it. Any insight ...
0
votes
1answer
70 views

How to reject unvalidated SSL client connections from the MongoDB server?

I have setup a MongoDB server with a self-signed server certificate, and when I use the server validation method in Compass along with the CA certificate, it works well. However, I am still able to ...
0
votes
0answers
81 views

Encryption in transit not working in MongoDB

I am using MongoDB 4.0.6 with 3 node replica set. I am upgrading my cluster to use SSL, below are steps which i am following : 1) generated CA.pem, server.pem and client.pem file and updated in my ...
0
votes
1answer
738 views

SSL Configuration fails with a warning MySQL 8.0

Hi I am trying to set up a MySQL server 8.0.16 on RHEL 7.5. The configuration I am willing to include for this server contains SSL related options. The MySQL server is initialized but with a warning ...
0
votes
1answer
29 views

How to secure my data queried from my local MySQL server on a remote machine with root shared with untrusted entity?

I have a remote client machine put in a server center owned by an entity who must also have the root of the client machine according to industry regulations. The client machine runs a C++ program that ...
0
votes
0answers
63 views

Do I need client or server cert for mySQL master/master replication?

WE use pkitool to sign any certificate using our own CA and there are two options to sign a certificates: using --sign, which creates a client-cert Using --server, which creates a server-cert The ...
0
votes
0answers
39 views

MySQL 5.5 replication over SSL broken after upgrading OpenSSL, OS

I've got an issue where, after upgrading a replication slave from Ubuntu 14.04 to 16.04, this slave can no longer connect to its master using SSL. Setup before the upgrade: 1 master, 2 slaves, ALL ...
0
votes
1answer
160 views

SSL errors with Couchdb on Ubuntu 14.04

I am beginning to set up CouchDB on an Ubuntu 14.04 Server (yes, it expires next year) and I'm having troubles setting up SSL connections. For the moment, I don't have any CA signed certs for it, so I'...
0
votes
1answer
566 views

SSLServerHasCertificateAuthority is false but the certificate is signed by a trusted CA

I am enabling TLS/SSL encryption on a remote MongoDB instance (running on Windows Server 2012 R2). On the instance's server, devserver.external, I have created an SSL certificate. The CN on the ...
0
votes
1answer
635 views

Oracle JDBC TLS connection fails (handshake_failure) after OS upgrade

I have an Oracle Database 12.1 server running on Oracle Linux 6. Secure (TLS) connections were working fine until I decided to update the underlying operating system (yum update) and reboot the ...