Connect to a database via SSH tunnel

sshtunnel.go

// Package internal ...
package internal

import (
	"fmt"
	"github.com/go-sql-driver/mysql"
	"golang.org/x/crypto/ssh"
	"net"
)

type ViaSSHDialer struct {
	client *ssh.Client
}

func (self *ViaSSHDialer) Dial(addr string) (net.Conn, error) {
	return self.client.Dial("tcp", addr)
}

type SSHTunnelConfig struct {
	Host     string
	User     string
	Password string
	Port     uint
}

// SetupSSHTunnel Register a custom network named "mysql+tcp"
func SetupSSHTunnel(tunnelConf *SSHTunnelConfig) error {
	sshConfig := &ssh.ClientConfig{
		User: tunnelConf.User,
		HostKeyCallback: ssh.InsecureIgnoreHostKey(),
		Auth: []ssh.AuthMethod{
			ssh.PasswordCallback(func() (string, error) {
				return tunnelConf.Password, nil
			}),
		},
	}
	sshcon, err := ssh.Dial("tcp", fmt.Sprintf("%s:%d", tunnelConf.Host, tunnelConf.Port), sshConfig)
	if err != nil {
		return err
	}
	mysql.RegisterDial("mysql+tcp", (&ViaSSHDialer{sshcon}).Dial)
	return nil
}

sshtunnel_application.go

package main

import (
	// ...
)

type MySqlConfig struct {
	Dsn             string
	MaxIdleConns    int
	MaxOpenConns    int
	ConnMaxLifetime int
	SSHTunnel       *internal.SSHTunnelConfig
}

mysqlConf := new(MySqlConfig)
// ... set configurations

if mysqlConf.SSHTunnel != nil {
  if err = internal.SetupSSHTunnel(mysqlConf.SSHTunnel); err != nil {
    log.Fatal(err)
  }
}

// for traditional and direct connection, Dsn is like: user:pass@tcp(127.0.0.1:3306)/dbname?charset=utf8mb4&parseTime=True&loc=Local
// for connection connected through SSH tunnel, Dsn is like: user:pass@mysql+tcp(127.0.0.1:3306)/dbname?charset=utf8mb4&parseTime=True&loc=Local
conn, err := gorm.Open(gormMySQL.Open(mysqlConf.Dsn), &gorm.Config{
  Logger: logger.Default.LogMode(logger.Info),
})

this doesnt work

this doesnt work

could you provide detailed error message?