MS-excel not accepting postgresql server certificateExporting data to excelConnect to Postgresql 9.2 from...
Why is Bernie Sanders maximum accepted donation on actblue $5600?
Will linear voltage regulator step up current?
Boss asked me to sign a resignation paper without a date on it along with my new contract
Why do we divide Permutations to get to Combinations?
How can a kingdom keep the secret of a missing monarch from the public?
How to write painful torture scenes without being over-the-top
Build ASCII Podiums
Is there a way to pause a running process on Linux systems and resume later?
Can you wish for more wishes from an Efreeti bound to service via an Efreeti Bottle?
Discouraging missile alpha strikes
80-bit collision resistence because of 80-bit x87 registers?
Do error bars on probabilities have any meaning?
How to encircle section of matrix in LaTeX?
Face Value of SOFR futures
Where can I educate myself on D&D universe lore, specifically on vampires and supernatural monsters?
Sauna: Wood does not feel so hot
Which was the first story to feature space elevators?
How does the income of your target audience matter for logo design?
How to know if I am a 'Real Developer'
Have the conservatives lost the working majority and if so, what does this mean?
multiple null checks in Java8
How to achieve physical gender equality?
Why does finding small effects in large studies indicate publication bias?
Is it ethical to apply for a job on someone's behalf?
MS-excel not accepting postgresql server certificate
Exporting data to excelConnect to Postgresql 9.2 from Eclipse Data Tools PlatformSQL Server error importing an Excel sheetHow does MS SQL Server authenticate MSDTC connections when using SSPI?Server Doesn't Listen Error when connecting to PostgreSQL from ClientPostgreSQL Client Certificate TLS errorLinking between SQL Server and ExcelHow To Setup/Enable SSL IN PostgreSQL with openSSL in Windows
I am trying to connect my MS-excel to postgresql 9.6
Firstly, It gave me error that it does not have the required library. So I downloaded ngpsql.
After that, it gave me error that it cannot accept the server certificate.
DataSource.Error: TlsClientStream.ClientAlertException:
CertificateUnknown: Server certificate was not accepted. Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.
So, I performed the following steps.
1 - Got the postgres server certificate (/etc/ssl/certs/ssl-cert-snakeoil.pem) and converted it into .crt file.
2 - copied it to my windows and installed the certificate on my windows using this page
http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm
3 - It says import was successful.
But still I keep getting the same error. It says that the server name is not mentioned in the certificate.
How to make a correct server certificate?
postgresql excel
asked Nov 10 '17 at 6:32
luv.preetluv.preet
1205
bumped to the homepage by Community♦ 4 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am trying to connect my MS-excel to postgresql 9.6
Firstly, It gave me error that it does not have the required library. So I downloaded ngpsql.
After that, it gave me error that it cannot accept the server certificate.
DataSource.Error: TlsClientStream.ClientAlertException:
CertificateUnknown: Server certificate was not accepted. Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.
So, I performed the following steps.
1 - Got the postgres server certificate (/etc/ssl/certs/ssl-cert-snakeoil.pem) and converted it into .crt file.
2 - copied it to my windows and installed the certificate on my windows using this page
http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm
3 - It says import was successful.
But still I keep getting the same error. It says that the server name is not mentioned in the certificate.
How to make a correct server certificate?
postgresql excel
asked Nov 10 '17 at 6:32
luv.preetluv.preet
1205
bumped to the homepage by Community♦ 4 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am trying to connect my MS-excel to postgresql 9.6
Firstly, It gave me error that it does not have the required library. So I downloaded ngpsql.
After that, it gave me error that it cannot accept the server certificate.
DataSource.Error: TlsClientStream.ClientAlertException:
CertificateUnknown: Server certificate was not accepted. Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.
So, I performed the following steps.
1 - Got the postgres server certificate (/etc/ssl/certs/ssl-cert-snakeoil.pem) and converted it into .crt file.
2 - copied it to my windows and installed the certificate on my windows using this page
http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm
3 - It says import was successful.
But still I keep getting the same error. It says that the server name is not mentioned in the certificate.
How to make a correct server certificate?
postgresql excel
asked Nov 10 '17 at 6:32
luv.preetluv.preet
1205
I am trying to connect my MS-excel to postgresql 9.6
Firstly, It gave me error that it does not have the required library. So I downloaded ngpsql.
After that, it gave me error that it cannot accept the server certificate.
DataSource.Error: TlsClientStream.ClientAlertException:
CertificateUnknown: Server certificate was not accepted. Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.
So, I performed the following steps.
1 - Got the postgres server certificate (/etc/ssl/certs/ssl-cert-snakeoil.pem) and converted it into .crt file.
2 - copied it to my windows and installed the certificate on my windows using this page
http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm
3 - It says import was successful.
But still I keep getting the same error. It says that the server name is not mentioned in the certificate.
How to make a correct server certificate?
postgresql excel
postgresql excel
asked Nov 10 '17 at 6:32
luv.preetluv.preet
1205
asked Nov 10 '17 at 6:32
luv.preetluv.preet
1205
asked Nov 10 '17 at 6:32
luv.preetluv.preet
1205
asked Nov 10 '17 at 6:32
luv.preetluv.preet
1205
asked Nov 10 '17 at 6:32
luv.preetluv.preet
1205
1205
bumped to the homepage by Community♦ 4 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 4 hours ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The snakeoil.pem probably doesn't have the right hostname. Try https://www.sslshopper.com/certificate-decoder.html
answered May 4 '18 at 15:15
Pål DrivekleppPål Driveklepp
1
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f190614%2fms-excel-not-accepting-postgresql-server-certificate%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The snakeoil.pem probably doesn't have the right hostname. Try https://www.sslshopper.com/certificate-decoder.html
answered May 4 '18 at 15:15
Pål DrivekleppPål Driveklepp
1
add a comment |
The snakeoil.pem probably doesn't have the right hostname. Try https://www.sslshopper.com/certificate-decoder.html
answered May 4 '18 at 15:15
Pål DrivekleppPål Driveklepp
1
add a comment |
The snakeoil.pem probably doesn't have the right hostname. Try https://www.sslshopper.com/certificate-decoder.html
answered May 4 '18 at 15:15
Pål DrivekleppPål Driveklepp
1
The snakeoil.pem probably doesn't have the right hostname. Try https://www.sslshopper.com/certificate-decoder.html
answered May 4 '18 at 15:15
Pål DrivekleppPål Driveklepp
1
answered May 4 '18 at 15:15
Pål DrivekleppPål Driveklepp
1
answered May 4 '18 at 15:15
Pål DrivekleppPål Driveklepp
1
answered May 4 '18 at 15:15
Pål DrivekleppPål Driveklepp
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f190614%2fms-excel-not-accepting-postgresql-server-certificate%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
