Questions tagged [ssl]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
75 views

[ODBC SQL Server Driver][DBNETLIB] SSL Security Error - Windows 2003 App Server to Remote SQL Server 2022 Connection

We have migrated the application databases from an old SQL Server 2000 instance running on Windows 2003 to a new SQL Server 2022 instance running on Windows 2022. The application tier has a number of ...
Fza's user avatar
  • 652
0 votes
0 answers
14 views

Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave

I have a requirement Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave . On Master & slave host ssl is enabled . also i have followed ...
Uday Raj Gupta's user avatar
2 votes
1 answer
155 views

Explanation of Mysql SSL connection for users created with "REQUIRE SSL"

I'm trying to understand the working of SSL while trying to connect to a MySQL server (via mysql-connector-python). I have MySQL (v5.7) and I have 2 users. One (root) is the default user and the other ...
Jim isaac's user avatar
  • 123
0 votes
0 answers
9 views

How can I enable server certificate verification when connecting to a remote host, but not when connecting via localhost?

When I add ssl-verify-server-cert to a [client-mariadb] section in the configuration files, the client correctly verifies the server certificate when connecting to a remote MariaDB instance. When ...
Nick Lockheart's user avatar
0 votes
0 answers
16 views

How can I get more verbose TLS certificate errors with MariaDB?

When attempting to connect to MariaDB from a remote client (command line on another server), I get the rather unhelpful: ERROR 1045 (28000): Access denied for user 'myuser'@'mydomain.com' (using ...
Nick Lockheart's user avatar
0 votes
0 answers
10 views

What is the Strategy for Rotating MySQL 5.7 certs with Active/Passive Pool?

Aside from migrating while we upgrade to 8.0, which is an option, what have people done workflow/strategy to rollout and rotate MySQL SSL credentials with zero downtime?
JShean's user avatar
  • 169
0 votes
0 answers
22 views

MySQL 8.1 does not let me login to my client after I disabled the SSL

I was facing some issues in my project due to the SSL being enabled so I followed the instructions given in other stack exchange questions to edit my my.ini file and add (# Disable SSL) skip_ssl but ...
Ujjwal's user avatar
  • 1
0 votes
0 answers
59 views

JDBC connection to MariaDB over SSL/TLS

I have an application that I'm trying to connect to MariaDB with a JDBC driver over SSL. I have set the following parameters in the custom.cnf of my MariaDB server: ssl_ca=/certs/ca-cert.pem ssl_cert=/...
D Edwards's user avatar
0 votes
0 answers
56 views

SSL-mode without CA-cert?

I am on DigitalOcean managed databases and they allow to download a CA cert for connecting securely. I am new to this. In TablePlus I can set SSL-mode to required and still connect without any cert. ...
Matt Welander's user avatar
1 vote
1 answer
45 views

Unknown, Un-encryted Connections [duplicate]

We have SSL enabled on our SQL servers and our monitoring tool is alerting that there are unencrypted connections. The check that monitors this runs every minute and uses the following query to check: ...
SE1986's user avatar
  • 1,908
2 votes
2 answers
248 views

The server did not preserve SSL encryption during a recovery attempt, connection recovery is not possible

We are starting to get the error message The server did not preserve SSL encryption during a recovery attempt, connection recovery is not possible from our MS SQL Server 2019 15.0.4298.1 instance. We ...
til_b's user avatar
  • 587
0 votes
1 answer
524 views

Does server SSL certificate update require SQL Service restart

This seems like such a basic question but I'm not finding it anywhere else on the site so apologies in advance if this is a repeat. Some co-workers and I are trying to determine if a restart of the ...
inkswamp's user avatar
0 votes
1 answer
277 views

Unable to start MySQL with SSL support

I've generated a handful of certificates for my MySQL 8.0.30 (mysql-server.x86_64 8.0.30-1.module+el8.6.0+16523+5cb0e868 @rhel-8-for-x86_64-appstream-rpms) on RHEL 8.7 and I'm running into an issue... ...
Kevin Huntly's user avatar
0 votes
0 answers
46 views

PhpMyAdmin doesn't encrypted on login

I have server on DO. I already use ssl https. On url showing my ssl was running but when I login to my phpmyadmin, why login information showing without encrypted? I also add $cfg['ForceSSL'] = true; ...
Eve's user avatar
  • 1
0 votes
1 answer
280 views

Is there a way for mongodb clients to connect to mongodb server (SSL/TLS enabled) without client certificates?

I am trying to setup a MongoDB with SSL/TLS enabled. I'm just wondering is there a way for clients to connect to my mongodb server without having a client certificate that would not compromise the ...
JRA's user avatar
  • 129
0 votes
0 answers
69 views

SQL Server Reporting Services (SSRS) running on an Amazon RDS for SQL Server Certificate Question

We're attempting a POC using an Amazon RDS for SQL Server instance as our SSRS backend and the question came up whether or not we can use our own certificates instead of the default RDS CA. Haven't ...
Nate H's user avatar
  • 31
1 vote
1 answer
328 views

How to automatically add TLS certificates to Oracle wallets?

When accessing external webservices via HTTPS via the Oracle database you need to add the corresponding certificate to a database wallet to prevent a certificate validation error. When one creates an ...
WayneNani's user avatar
  • 113
0 votes
0 answers
744 views

PostgreSQL connection accepted without providing SSL certificates

Hopefully someone might be able to shed a light on this problem. I've configured two servers, both of them have the same problem. I've implemented SSL configuration, on PostgreSQL 11.18, I have ...
David Salas's user avatar
1 vote
1 answer
79 views

Does cassandra support CN and FQDN verification (node-to-node ssl)?

I have a question regardless cassandra node-to-node ssl encryption. Currently I test node-to-node ssl. I set up self-signed certs with CN test-node-1.example.com which is the same as FQDN of the ...
blacky's user avatar
  • 11
4 votes
1 answer
932 views

Is SQL Server affected by OpenSSL 3.0 Vulnerabilities: CVE 2022-3786 and CVE 2022-3602

I am trying to establish whether SQL Server is affected by the recently discovered OpenSSL vulnerabilities. For example, are SQL Servers that are using TLS/Certificates to encrypt connections between ...
steve's user avatar
  • 47
1 vote
1 answer
1k views

MySQL Server Cannot Verify SSL Certificate

I'm trying to configure a mysql server for secure remote connections over TCP/IP using SSL. The server mysql runs on has a domain name associated with it which i have requested a certificate for from ...
meshachviktor's user avatar
0 votes
1 answer
2k views

Postgres SSL client certificate - database server CA failed to start

I want to configure SSL so that clients can only require certificate signed by root CA ca.crt, then every client must use their issued e.g. cert postgresql.crt, key postgresql.key and password to ...
themsay's user avatar
0 votes
1 answer
142 views

How to create certificate request with "not after" parameter for Db2 SSL/TLS?

I have configured Db2 v11.5.7.0 on Linux/x64 to use SSL/TLS protocol and Db2 client can successfully connect to Db2 server using SSL/TLS. Now I would like to test certificate renewal. I need to create ...
folow's user avatar
  • 325
-1 votes
1 answer
613 views

Proper way to setup oracle database for TCPS SSL in local machine

I am using oracle database 12c and would like to setup TCP SSL connection to be able to connect using the same machine where the database is hosted. So, connection would be from database machine to ...
Generalex's user avatar
1 vote
1 answer
10k views

How to connecto DBeaver with Db2 using SSL self-signed certificate?

On Db2 v11.5.7.0 Linux/x86 server I have configured SSL using self-signed certificate following official IBM documentation https://www.ibm.com/docs/en/db2/11.5?topic=transit-tls-configuration-db2 I ...
folow's user avatar
  • 325
0 votes
1 answer
380 views

Failing to enable TCPS on Oracle 11

I have added the following settings to my Oracle 11 server (Bolded text is the change)- sqlnet.ora- SQLNET.AUTHENTICATION_SERVICES = (**TCPS,** NTS) listener.ora- SID_LIST_LISTENER = (SID_LIST = ...
user3073180's user avatar
0 votes
1 answer
2k views

postgres: could not access directory "C:/opt/PostgreSql/14/data": Permission denied

Importantly: This is on Windows 10 and Postgres 14 (for newbies, Postgres is also known as PostgreSQL), with Cygwin providing the CLI. On a fully functional, up and running, and apparently perfectly ...
Richard T's user avatar
  • 219
1 vote
1 answer
85 views

SSL Encryption for Kafka Pipelines

Any [SingleStore] users out there? For enabling SSL encryption (only) for Kafka pipelines, we created the pipeline like below: CREATE PIPELINE `kafka_ssl` AS LOAD DATA KAFKA '<kafka-host>:<...
Matt Brown's user avatar
0 votes
1 answer
97 views

Does manual failover of availability group bind an SSL certificate?

I'm trying to find the least intrusive way to bind a new SSL certificate to an Always On Availability Group 3-node cluster. After applying the new certificate, a message appears that SQL Server will ...
jrdevdba's user avatar
  • 288
0 votes
0 answers
317 views

Generate MySQL/MariaDB SSL certificates from my wildcard certificate (*.mycompany.com)

I'm configuring a series of MariaDB servers with SSL protection. I was able to do it creating different self-signed certificates, as everybody can do just following some of the multiple tutorials you ...
Gonzalo Cao's user avatar
3 votes
1 answer
138 views

Is an SSL Certificate Authority Chain "Secret"

We've recently signed up to use MariaDB's SkySQL package, however are new to the use of SSL Certificate Chains when connecting (having only really used SSH tunnels in the past). We have the key which ...
IQJWSB0DLT's user avatar
0 votes
1 answer
1k views

How do I configure DB2 on Windows with SSL so that I can connect via ODBC?

DB2 11.5 running on Windows Server 2016 Standard SQL Server 14.0.3430.2 I'm able to set up ODBC with some DB2 databases, but when the DB2 database is secured with an SSL certificate, which they call ...
mightycpa's user avatar
1 vote
1 answer
623 views

Should a client connecting to a server via a unix-socket be encrypted?

Does a client connection need encryption if the only connection option is via unix socket? e.g. my.cnf [mysqld] socket = /run/mysqld/mysqld.sock I'm considering these options, but I'd prefer not to ...
Jeff's user avatar
  • 143
2 votes
1 answer
1k views

SQL Server Profiler - Client unable to establish connection

Spanking brand-new installations of: Visual Studio 2022 Community (VS) SQL Server 2019 Dev (SQL) SQL Server Management Studio v18.10 (SSMS) There are no other Visual Studio or SQL Server instances ...
David Rogers's user avatar
2 votes
2 answers
3k views

After installing a new SSL certificate, my MSSQL server is no longer able to be restarted

I installed a SSL certificate using a pfx file, taking the hash and putting it inside the certificate key of SuperSocketNetLib, I restarted the MSSQL server using the MSSQL Management Tool, and upon ...
Sayaman's user avatar
  • 201
0 votes
3 answers
2k views

Setup Secure LDAP over SSL/TLS (LDAPS) for PostgreSQL

Haven’t had much luck while trying several ways to implement LDAPS for PostgreSQL. pg_hba.conf hostssl all +test_ldap 0.0.0.0/0 ldap ldapserver=dc2.ad.foobar.com ldapport=636 ldapscheme=ldaps ldaptls=...
roman95's user avatar
  • 11
0 votes
1 answer
1k 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 ...
mosfeta's user avatar
0 votes
1 answer
105 views

Can SQL server verify client with SSL cert, that tries to connect to it?

Pretty sure that it's stupid question, but still would be very happy to get answer or some explanation or point to the documentation. Right now I'm configuring SSL connection to PostgreSQL server with ...
Sergio's user avatar
  • 103
1 vote
0 answers
150 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 ...
Pham's user avatar
  • 11
0 votes
0 answers
915 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 ...
James's user avatar
  • 103
0 votes
1 answer
297 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 ...
Bix's user avatar
  • 113
1 vote
1 answer
93 views

SQL Server Secure and Unsecure Traffic Configuration Help

I have a SQL Server 2017 instance that I have configured to listen on multiple ports 1433 and 1234. I would like to know if its possible to have one port (1234) accept only secure connections while ...
deadLock's user avatar
  • 388
0 votes
1 answer
475 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 ...
Luc Bonjean's user avatar
1 vote
1 answer
794 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=...
roAl's user avatar
  • 11
1 vote
1 answer
2k 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 ...
Denis's user avatar
  • 125
1 vote
1 answer
8k views

Can we enable tls 1.0 on MSSQL Server 2019 on database level? if yes then how?

i am running sql server 2019 on Linux box and trying to connect using a Windows server 2016 client, how can we enable TLS 1.0 for SQL Server 2019 on the Database/instance level. TIA.
user avatar
0 votes
1 answer
1k 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 ...
clamp's user avatar
  • 101
0 votes
0 answers
592 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 *....
IGGt's user avatar
  • 2,086
1 vote
1 answer
296 views

SQL Server - Why am I getting TCP connections without sessions?

I enabled SSL with Forced Encryption enabled, using a self-signed certificate. Then I've set up automated monitoring to detect not secured connections (seems redundant, I know, but bear with me here), ...
Eitan Blumin's user avatar
0 votes
1 answer
2k views

psql command, how to enforce certificate check?

I have created a cockroachdb v20.1.0 cluster based on this: https://www.cockroachlabs.com/docs/stable/deploy-cockroachdb-on-premises.html I have also created a test user like this: CREATE USER test ...
nagylzs's user avatar
  • 411

1
2 3 4 5