main.go 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183
  1. package main
  2. import (
  3. "bytes"
  4. "database/sql"
  5. "fmt"
  6. "io"
  7. "io/ioutil"
  8. "os"
  9. "path"
  10. "strings"
  11. "text/template"
  12. _ "github.com/go-sql-driver/mysql"
  13. "github.com/pin/tftp"
  14. "github.com/namsral/flag"
  15. )
  16. var (
  17. workdir, sepTeplateFilePath, freepbxDb string
  18. sepTeplateFile []byte
  19. db *sql.DB
  20. )
  21. //PhoneSetting struct
  22. type PhoneSetting struct {
  23. DisplayName, PhonePassword string
  24. PhoneNumber string
  25. }
  26. //Getting phone setting from freepbx database
  27. func getPhoneSetting(filename string) (*PhoneSetting, error) {
  28. var ps PhoneSetting
  29. filename = strings.TrimSuffix(filename, ".cnf.xml")
  30. query := `
  31. SELECT userman_users.displayname, sip.data, userman_users.default_extension
  32. FROM userman_users
  33. LEFT JOIN sip
  34. ON userman_users.default_extension=sip.id AND sip.keyword='secret'
  35. WHERE userman_users.fax=?
  36. ORDER BY userman_users.default_extension
  37. LIMIT 1
  38. `
  39. err := db.QueryRow(query, filename).Scan(&ps.DisplayName, &ps.PhonePassword, &ps.PhoneNumber)
  40. if err != nil {
  41. return &ps, err
  42. }
  43. return &ps, nil
  44. }
  45. //Send file to client
  46. func sendFile(file *bytes.Buffer, rf io.ReaderFrom) error {
  47. n, err := rf.ReadFrom(file)
  48. if err != nil {
  49. fmt.Fprintf(os.Stderr, "%v\n", err)
  50. return err
  51. }
  52. fmt.Printf("%d bytes sent\n", n)
  53. return nil
  54. }
  55. //Reading file in tftp dir. If file not found, returning empty file
  56. func readFile(filename string, rf io.ReaderFrom) error {
  57. var err error
  58. buf := new(bytes.Buffer)
  59. file, err := os.Open(path.Join(workdir, filename))
  60. if err != nil {
  61. fmt.Fprintf(os.Stderr, "%v\n", err)
  62. } else {
  63. buf.ReadFrom(file)
  64. }
  65. defer file.Close()
  66. err = sendFile(buf, rf)
  67. if err != nil {
  68. fmt.Fprintf(os.Stderr, "%v\n", err)
  69. return err
  70. }
  71. return nil
  72. }
  73. //Generating phone settings file use go-template
  74. func genFile(filename string, rf io.ReaderFrom) error {
  75. var (
  76. tpl bytes.Buffer
  77. err error
  78. )
  79. p, err := getPhoneSetting(filename)
  80. if err != nil {
  81. fmt.Fprintf(os.Stderr, "%v\n", err)
  82. return err
  83. }
  84. t := template.Must(template.New("sepTeplateFile").Parse(string(sepTeplateFile)))
  85. err = t.Execute(&tpl, p)
  86. if err != nil {
  87. fmt.Fprintf(os.Stderr, "%v\n", err)
  88. return err
  89. }
  90. err = sendFile(&tpl, rf)
  91. if err != nil {
  92. fmt.Fprintf(os.Stderr, "%v\n", err)
  93. return err
  94. }
  95. return nil
  96. }
  97. //Processing file request from a tftp client
  98. func readHandler(filename string, rf io.ReaderFrom) error {
  99. raddr := rf.(tftp.OutgoingTransfer).RemoteAddr()
  100. laddr := rf.(tftp.RequestPacketInfo).LocalIP()
  101. fmt.Println("RRQ from:", raddr.String(), "To:", laddr.String(), "File:", filename)
  102. sepFile, err := path.Match("SEP*.cnf.xml", filename)
  103. if err != nil {
  104. fmt.Fprintf(os.Stderr, "%v\n", err)
  105. return err
  106. }
  107. if sepFile {
  108. genFile(filename, rf)
  109. } else {
  110. readFile(filename, rf)
  111. }
  112. return nil
  113. }
  114. //Declaring cli flags
  115. func init() {
  116. flag.StringVar(&workdir, "workdir", "/tftpboot", "Set working directory")
  117. flag.StringVar(&sepTeplateFilePath, "sep_template_file", "./sep-cisco.cnf.xml.tpl", "Set path to sep template file")
  118. flag.StringVar(&freepbxDb, "freepbx_db", "asterisk:password@tcp(127.0.0.1)/asterisk", "Set freepbx db connection string")
  119. }
  120. func main() {
  121. var err error
  122. flag.Parse()
  123. sepTeplateFile, err = ioutil.ReadFile(sepTeplateFilePath)
  124. if err != nil {
  125. fmt.Fprintf(os.Stderr, "%v\n", err)
  126. os.Exit(1)
  127. }
  128. //Connicting to db
  129. db, err = sql.Open("mysql", freepbxDb)
  130. if err != nil {
  131. fmt.Fprintf(os.Stderr, "Error on initializing database connection: %s\n", err)
  132. os.Exit(1)
  133. }
  134. //Checking db connection
  135. err = db.Ping()
  136. if err != nil {
  137. fmt.Fprintf(os.Stderr, "Error on database connection: %s\n", err)
  138. os.Exit(1)
  139. }
  140. db.SetMaxIdleConns(10)
  141. fmt.Println("Starting freepbx tftp server")
  142. s := tftp.NewServer(readHandler, nil)
  143. err = s.ListenAndServe(":69")
  144. if err != nil {
  145. fmt.Fprintf(os.Stderr, "server: %v\n", err)
  146. os.Exit(1)
  147. }
  148. }