Posts in 2021
-
Most votes on postgresql questions 2
May 01, 2021 in FAQ
Most votes on postgresql questions 2. #11 Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails #12 Can't find the 'libpq-fe.h header when trying to install pg gem #13 PostgreSQL error: Fatal: role "username" does not exist #14 psql: FATAL: database "<user>" does not exist #15 Creating a copy of a database in PostgreSQL #16 Difference between text and varchar (character varying) #17 How to drop a PostgreSQL database if there are active connections to it? #18 Insert, on duplicate update in PostgreSQL? #19 postgres: upgrade a user to be a superuser? #20 How to import CSV file data into a PostgreSQL table?
Read all the top votes questions and answers in a single page. #11: Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails (Score: 859) Created: 2013-09-06 Last updated: 2018-12-10 Tags: …
-
Most votes on postgresql questions 10
May 01, 2021 in FAQ
Most votes on postgresql questions 10. #91 How to change a PG column to NULLABLE TRUE? #92 How can I add a column that doesn't allow nulls in a Postgresql database? #93 You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application #94 How to create User/Database in script for Docker Postgres #95 Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib #96 List columns with indexes in PostgreSQL #97 PostgreSQL: Give all permissions to a user on a PostgreSQL database #98 Adding a new value to an existing ENUM Type #99 How to list table foreign keys #100 Use email address as primary key?
Read all the top votes questions and answers in a single page. #91: How to change a PG column to NULLABLE TRUE? (Score: 267) Created: 2011-01-27 Last updated: 2016-03-29 Tags: sql, postgresql, nullable How can I accomplish this using Postgres? …
-
Most votes on postgresql questions 1
May 01, 2021 in FAQ
Most votes on postgresql questions 1. #1 PostgreSQL: Show tables in PostgreSQL #2 PostgreSQL "DESCRIBE TABLE" #3 How to exit from PostgreSQL command line utility: psql #4 Select first row in each GROUP BY group? #5 How can I drop all the tables in a PostgreSQL database? #6 PostgreSQL: How to change PostgreSQL user password? #7 How to switch databases in psql? #8 PostgreSQL: Which version of PostgreSQL am I running? #9 How can I start PostgreSQL server on Mac OS X? #10 Save PL/pgSQL output from PostgreSQL to a CSV file
Read all the top votes questions and answers in a single page. #1: PostgreSQL: Show tables in PostgreSQL (Score: 2026) Created: 2009-04-20 Last updated: 2020-05-31 Tags: postgresql What’s the equivalent to show tables (from MySQL) in …
-
Most votes on openssl questions 9
May 01, 2021 in FAQ
Most votes on openssl questions 9. #81 Unable to establish SSL connection, how do I fix my SSL cert? #82 Python Requests requests.exceptions.SSLError: [Errno 8] _ssl.c:504: EOF occurred in violation of protocol #83 "verify error:num=20" when connecting to gateway.sandbox.push.apple.com #84 gem install fails with openssl failure #85 Enter export password to generate a P12 certificate #86 How to upgrade OpenSSL in CentOS 6.5 / Linux / Unix from source? #87 Rails 3 - no such file to load – openssl #88 PEM_read_bio_PrivateKey() returns NULL in ECB mode only #89 Why is Ruby unable to verify an SSL certificate? #90 Does .pem file contain both private and public keys?
Read all the top votes questions and answers in a single page. #81: Unable to establish SSL connection, how do I fix my SSL cert? (Score: 62) Created: 2013-03-01 Last updated: 2017-01-26 Tags: apache, ssl, openssl, wget I’m trying to wget to my …
-
Most votes on openssl questions 8
May 01, 2021 in FAQ
Most votes on openssl questions 8. #71 How to resolve the "EVP_DecryptFInal_ex: bad decrypt" during file decryption #72 Generate sha256 with OpenSSL and C++ #73 How to Check Subject Alternative Names for a SSL/TLS Certificate? #74 Why is there a handshake failure when trying to run TLS over TLS with this code? #75 Building Python with SSL support in non-standard location #76 OpenSSL Command to check if a server is presenting a certificate #77 openssl hangs and does not exit #78 ImportError: cannot import name HTTPSHandler using PIP #79 How to revoke an openssl certificate when you don't have the certificate #80 RSA: Get exponent and modulus given a public key
Read all the top votes questions and answers in a single page. #71: How to resolve the "EVP_DecryptFInal_ex: bad decrypt" during file decryption (Score: 68) Created: 2015-12-16 Last updated: 2015-12-16 Tags: c, encryption, openssl I have …
-
Most votes on openssl questions 7
May 01, 2021 in FAQ
Most votes on openssl questions 7. #61 OpenSSL: unable to verify the first certificate for Experian URL #62 openssl s_client using a proxy #63 How to fix "unable to write 'random state' " in openssl #64 Use of Initialization Vector in openssl_encrypt #65 How to save public key from a certificate in .pem format #66 How to compile .c file with OpenSSL includes? #67 How to convert .pem into .key? #68 How to display the Subject Alternative Name of a certificate? #69 Export a PKCS#12 file without an export password? #70 How to determine SSL cert expire date from the cert file itself(.p12)
Read all the top votes questions and answers in a single page. #61: OpenSSL: unable to verify the first certificate for Experian URL (Score: 80) Created: 2011-09-28 Tags: ssl, certificate, openssl I am trying to verify an SSL connection to Experian …
-
Most votes on openssl questions 6
May 01, 2021 in FAQ
Most votes on openssl questions 6. #51 is it possible making openssl skipping the country/common name prompts? #52 Python AttributeError: 'module' object has no attribute 'SSL_ST_INIT' #53 Generating cryptographically secure tokens #54 OpenSSL hangs during PKCS12 export with "Loading 'screen' into random state" #55 Creating self signed certificate for domain and subdomains - NET::ERR_CERT_COMMON_NAME_INVALID #56 Update OpenSSL on OS X with Homebrew #57 How to read .pem file to get private and public key #58 Programmatically Create X509 Certificate using OpenSSL #59 OpenSSL Verify return code: 20 (unable to get local issuer certificate) #60 How to encrypt a large file in openssl using public key
Read all the top votes questions and answers in a single page. #51: is it possible making openssl skipping the country/common name prompts? (Score: 85) Created: 2011-11-10 Tags: openssl Is there a way to make openssl skiping the prompts such as …
-
Most votes on openssl questions 5
May 01, 2021 in FAQ
Most votes on openssl questions 5. #41 How can I transform between the two styles of public key format, one "BEGIN RSA PUBLIC KEY", the other is "BEGIN PUBLIC KEY" #42 What is the purpose of the -nodes argument in openssl? #43 OpenSSL: PEM routines:PEM_read_bio:no start line:pem_lib.c:703:Expecting: TRUSTED CERTIFICATE #44 Unable to load Private Key. (PEM routines:PEM_read_bio:no start line:pem_lib.c:648:Expecting: ANY PRIVATE KEY) #45 SSL Error: unable to get local issuer certificate #46 How to convert a private key to an RSA private key? #47 certificate verify failed: unable to get local issuer certificate #48 Authentication failed because remote party has closed the transport stream #49 "Public key certificate and private key doesn't match" when using Godaddy issued certificate #50 Running Openssl from a bash script on windows - Subject does not start with '/'
Read all the top votes questions and answers in a single page. #41: How can I transform between the two styles of public key format, one "BEGIN RSA PUBLIC KEY", the other is "BEGIN PUBLIC KEY" (Score: 114) Created: 2013-08-04 Last …
-
Most votes on openssl questions 4
May 01, 2021 in FAQ
Most votes on openssl questions 4. #31 Proper use of the HsOpenSSL API to implement a TLS Server #32 How to extract public key using OpenSSL? #33 Converting pfx to pem using openssl #34 OpenSSL and error in reading openssl.conf file #35 You must enable the openssl extension to download files via https #36 Convert NSData to String? #37 How can I generate a self-signed certificate with SubjectAltName using OpenSSL? #38 SSL: error:0B080074:x509 certificate routines:X509_check_private_key:key values mismatch #39 How to generate an openSSL key using a passphrase from the command line? #40 Load RSA public key from file
Read all the top votes questions and answers in a single page. #31: Proper use of the HsOpenSSL API to implement a TLS Server (Score: 141) Created: 2011-11-23 Last updated: 2012-07-13 Tags: haskell, openssl, ssl I’m trying to figure out how to …
-
Most votes on openssl questions 3
May 01, 2021 in FAQ
Most votes on openssl questions 3. #21 How do you test a public/private DSA keypair? #22 Convert pem key to ssh-rsa format #23 CMake not able to find OpenSSL library #24 create a trusted self-signed SSL cert for localhost (for use with Express/Node) #25 Can't open config file: /usr/local/ssl/openssl.cnf on Windows #26 Unable to find the wrapper "https" - did you forget to enable it when you configured PHP? #27 Homebrew refusing to link OpenSSL #28 Verify a certificate chain using openssl verify #29 How to install OpenSSL in windows 10? #30 Converting a Java Keystore into PEM Format
Read all the top votes questions and answers in a single page. #21: How do you test a public/private DSA keypair? (Score: 173) Created: 2008-11-08 Last updated: 2020-07-23 Tags: encryption, ssl, openssl, key Is there an easy way to verify that a …