douba1067
2019-08-10 00:32
浏览 270

与带有TLS的MySQL连接字符串的连接不良[关闭]

I am unable to connect to my MySQL database on Azure using Go. I am seeing:

API server listening at: 127.0.0.1:XXXXX
[mysql] 2019/08/09 16:42:17 packets.go:36: read tcp XXX.XXX.X.XX:XXXXX->XX.XX.XXX.XXX:1433: read: connection reset by peer
[mysql] 2019/08/09 16:42:23 packets.go:36: read tcp XXX.XXX.X.XX:XXXXX->XX.XX.XXX.XXX:1433: read: connection reset by peer
[mysql] 2019/08/09 16:42:29 packets.go:36: read tcp XXX.XXX.X.XX:XXXXX->XX.XX.XXX.XXX:1433: read: connection reset by peer
panic: driver: bad connection

goroutine 1 [running]:
db.ConnectToDB(0x134c7aa, 0x5, 0xc0000e6000, 0x9b)
    /Users/myuser/go/src/db/db-connection.go:113 +0x249
main.main()
    /Users/myuser/go/src/mydbapp/main.go:12 +0x58

I tried instructions at https://docs.microsoft.com/en-us/azure/mysql/connect-go

package db

import (
    "database/sql"
    "fmt"
    "os"

    _ "github.com/go-sql-driver/mysql"
    _ "github.com/lib/pq"
)


func ConnectToMydb() {

    mysqlInfo := fmt.Sprintf("myusername@myservernameshort:mypassword@tcp" +
    "(myservenameshort.database.windows.net:1433)/mydbname?" +
    "&allowNativePasswords=true&tls=true&timeout=30s"
)

    db, err := sql.Open("mysql", mysqlInfo)
    if err != nil {
        panic(err)
    }
    defer db.Close()

    err = db.Ping()
    if err != nil {
        panic(err)
    }

    fmt.Println("Successfully connected mydb!")
}

My JDBC equivalent connection string is as follows:

jdbc:sqlserver://myservernameshort.database.windows.net:1433;database=mydbname;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30

and that works.

The instructions at the following link were not clear if I need to go that route: https://godoc.org/github.com/go-sql-driver/mysql#RegisterTLSConfig

Please guide how I can proceed/ if you need more information/ what I could try

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douwen1929 2019-08-12 21:29
    已采纳

    The db was mssql and not mysql. My bad. The port # should have given it away

    已采纳该答案
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题