Trying to communicate with a postgres database with go, preparing the statement like this:
var stmt *sql.Stmt
var err error
stmt, err = db.Prepare(selectStatement)
if err != nil {
fmt.Printf("db.Prepare error: %v\n",err)
return err
}
Throws the following error:
db.Prepare error: pq: SSL is not enabled on the server
Any solution ?
I can add more information, if needed.
7 Answers
You should establish DB connection without SSL encryption, like that:
db, err := sql.Open("postgres", "user=test password=test dbname=test sslmode=disable")
If your data source name is a url, you will do it like this:
db, err := sql.Open("postgres", "postgres://username:password@localhost/db_name?sslmode=disable")
sslmode is just added to the db url like a query parameter.
Notice, please:
This even occurs, if you have indicated a sslmode=disable, but have empty other param. For example dbname=
For example, connection string:
user=test password=test dbname=sslmode=disable will also issue this error, because dbname is empty.
To establish a connection without SSL, try
postgres://username:password@host:5432/database?sslmode=disable
This is how I got it working:
db, err := sql.Open("postgres", "postgres://{user}:{password}@{hostname}:{port}/{database-name}?sslmode=disable")
when you are using sqlx for connection to postgres try this one:
import (
""
_ ""
)
func main () {
// c is my configuration struct use your own struct instead
databseUrl := fmt.Sprintf(
"postgres://%s:%s@%s:%s/%s?sslmode=disable",
c.Postgres.User, c.Postgres.Password, c.Postgres.Host, c.Postgres.Port, c.Postgres.Name,
)
db, _ := sqlx.Open("postgres", databaseUrl)
}
You can use a Struct to pass the values or load it from Env or Config file.
Here is the solution,
package main
import (
"database/sql"
"fmt"
_ ""
"log"
)
type Config struct {
DBDriver string
DBSource string
ServerAddress string
}
func main() {
db, err := openDB()
if err != nil {
log.Printf("Databse Connection Error", err)
}
err = db.Ping()
fmt.Println("Database Conn opend")
if err != nil {
log.Printf("Error while Pinging Database")
}
}
func openDB() (*sql.DB, error) {
// Here you can populate the DB params from Env or Config file or use marshaling to fill in the values
dbParams := Config{
DBDriver: "postgres",
DBSource: "postgres://usename:password@localhost:5432/DatabaseName?sslmode=disable",
ServerAddress: "",
}
db, err := sql.Open(dbParams.DBDriver, dbParams.DBSource)
if err != nil {
fmt.Println("error", err)
return nil, err
}
return db, nil
}
