douguo6472 2019-03-11 21:51
浏览 212

使用SSL进入MySQL-意外的EOF

I'm using the Go MySQL driver as part of a project. Recently, there was a need to enable SSL on the MySQL database I am connecting to. I have two servers that are configured with TLSv1.1. On one server, I am able connect successfully, but on the other I am getting unexpected EOF from the library.

I tried setting MaxIdleConnections to 0 as described in Golang MySQL error - packets.go:33: unexpected EOF, but no luck. Prior to enabling SSL, connections to the server were working. There are other apps not written in Go that are able to connect successfully using the same credentials.

When my app runs, the ping command fails immediately. The MySQL server logs are saying bad handshake. Is there something off with my connection code below, or is there a database setting that could be refusing to connect with skip-verify?

import (
    "database/sql"
    "io/ioutil"
    "strings"
    "text/template"

    log "github.com/sirupsen/logrus"
    // Import runtime for MySQL
    mysql "github.com/go-sql-driver/mysql"
)

type DatabaseConnection struct {
    Hostname string
    Port     int
    Database string
    Username string
    Password string
}

func CreateSSLConnection(db *DatabaseConnection) (*sql.DB, error) {
    templateString := `{{.Username}}:{{.Password}}@{{.Hostname}}:{{.Port}}/{{.Database}}?tls=skip-verify`

    conn, err := connectToDatabase("mysql", templateString, db)

    // error: "unexpected EOF"
    err = conn.Ping()
    return conn, err
}

func connectToDatabase(databaseType string, connectionTemplateString string, db *DatabaseConnection) (*sql.DB, error) {
    connectionTemplate := template.Must(template.New("connectionString").Parse(connectionTemplateString))
    builder := strings.Builder{}

    err := connectionTemplate.Execute(&builder, db)
    if err != nil {
        log.WithFields(log.Fields{
            "template": connectionTemplateString,
            "error":    err,
        }).Error("Failed to create connection string")
        return nil, err
    }

    return sql.Open(databaseType, builder.String())
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 matlab数字图像处理频率域滤波
    • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
    • ¥15 ELGamal和paillier计算效率谁快?
    • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
    • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
    • ¥15 Arcgis相交分析无法绘制一个或多个图形
    • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
    • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
    • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
    • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误