error: failed to initialize database, got error dial tcp :0: connectex: The requested address is not valid in its context

huangapple go评论132阅读模式
英文:

error: failed to initialize database, got error dial tcp :0: connectex: The requested address is not valid in its context

问题

我正在尝试使用Go语言创建一个API,但是遇到了一个错误。如何解决这个问题?我将发布错误文本。

错误信息如下:
错误:初始化数据库失败,出现错误 dial tcp :0: connectex: 请求的地址在其上下文中无效

  1. 初始化数据库失败,出现错误 dial tcp :0: connectex: 请求的地址在其上下文中无效。
  2. panic: DB错误:dial tcp :0: connectex: 请求的地址在其上下文中无效。
  3. goroutine 1 [running]:
  4. ToDoList-Server/model.DBConnection()
  5. C:/Users/81804/enviroment/todo/ToDoList-Server/model/db.go:21 +0x225
  6. main.main()
  7. C:/Users/81804/enviroment/todo/ToDoList-Server/main.go:10 +0x2a
  1. package model
  2. import (
  3. "database/sql"
  4. "fmt"
  5. "os"
  6. _ "github.com/go-sql-driver/mysql"
  7. "gorm.io/driver/mysql"
  8. "gorm.io/gorm"
  9. )
  10. var db *gorm.DB
  11. // DBConnection函数用于连接数据库并创建表
  12. func DBConnection() *sql.DB {
  13. dsn := GetDBConfig()
  14. var err error
  15. db, err = gorm.Open(mysql.Open(dsn), &gorm.Config{})
  16. if err != nil {
  17. panic(fmt.Errorf("DB错误:%w", err))
  18. }
  19. CreateTable(db)
  20. sqlDB, err := db.DB()
  21. if err != nil {
  22. panic(fmt.Errorf("DB错误:%w", err))
  23. }
  24. return sqlDB
  25. }
  26. // 获取数据库配置信息
  27. func GetDBConfig() string {
  28. user := os.Getenv("DB_USERNAME")
  29. password := os.Getenv("DB_PASSWORD")
  30. hostname := os.Getenv("DB_HOSTNAME")
  31. port := os.Getenv("DB_PORT")
  32. dbname := os.Getenv("DB_DBNAME")
  33. dsn := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s", user, password, hostname, port, dbname) + "?charset=utf8mb4&parseTime=True&loc=Local"
  34. return dsn
  35. }
  36. // 创建Task表
  37. func CreateTable(db *gorm.DB) {
  38. db.AutoMigrate(&Task{})
  39. }

希望这能帮到你解决问题!

英文:

I am trying to create an API in go language, but I get an error. How can this be resolved? I will post the error text.
error: failed to initialize database, got error dial tcp :0: connectex: The requested address is not valid in its context

  1. failed to initialize database, got error dial tcp :0: connectex: The requested address is not valid in its context.
  2. panic: DB Error: dial tcp :0: connectex: The requested address is not valid in its context.
  3. goroutine 1 [running]:
  4. ToDoList-Server/model.DBConnection()
  5. C:/Users/81804/enviroment/todo/ToDoList-Server/model/db.go:21 +0x225
  6. main.main()
  7. C:/Users/81804/enviroment/todo/ToDoList-Server/main.go:10 +0x2a
  1. package model
  2. import (
  3. "database/sql"
  4. "fmt"
  5. "os"
  6. _ "github.com/go-sql-driver/mysql"
  7. "gorm.io/driver/mysql"
  8. "gorm.io/gorm"
  9. )
  10. var db *gorm.DB
  11. // DB接続とテーブルを作成する
  12. func DBConnection() *sql.DB {
  13. dsn := GetDBConfig()
  14. var err error
  15. db, err = gorm.Open(mysql.Open(dsn), &gorm.Config{})
  16. if err != nil {
  17. panic(fmt.Errorf("DB Error: %w", err))
  18. }
  19. CreateTable(db)
  20. sqlDB, err := db.DB()
  21. if err != nil {
  22. panic(fmt.Errorf("DB Error: %w", err))
  23. }
  24. return sqlDB
  25. }
  26. // DBのdsnを取得する
  27. func GetDBConfig() string {
  28. user := os.Getenv("DB_USERNAME")
  29. password := os.Getenv("DB_PASSWORD")
  30. hostname := os.Getenv("DB_HOSTNAME")
  31. port := os.Getenv("DB_PORT")
  32. dbname := os.Getenv("DB_DBNAME")
  33. dsn := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s", user, password, hostname, port, dbname) + "?charset=utf8mb4&parseTime=True&loc=Local"
  34. return dsn
  35. }
  36. // Task型のテーブルを作成する
  37. func CreateTable(db *gorm.DB) {
  38. db.AutoMigrate(&Task{})
  39. }

答案1

得分: 2

请尝试按照以下方式格式化您的 DSN 字符串:

  1. dsn := fmt.Sprintf("host=%s user=%s password=%s dbname=%s post=%s", hostname, user, password, dbname, port)
英文:

try to format your dsn string as follows:

  1. dsn := fmt.Sprintf("host=%s user=%s password=%s dbname=%s post=%s", hostname, user, password, dbname, port)

huangapple
  • 本文由 发表于 2022年6月22日 08:38:11
  • 转载请务必保留本文链接:https://go.coder-hub.com/72708471.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定