emqx_auth_pgsql.schema 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134
  1. %%-*- mode: erlang -*-
  2. %% emqx_auth_pgsl config mapping
  3. {mapping, "auth.pgsql.server", "emqx_auth_pgsql.server", [
  4. {default, {"127.0.0.1", 5432}},
  5. {datatype, [integer, ip, string]}
  6. ]}.
  7. {mapping, "auth.pgsql.pool", "emqx_auth_pgsql.server", [
  8. {default, 8},
  9. {datatype, integer}
  10. ]}.
  11. {mapping, "auth.pgsql.database", "emqx_auth_pgsql.server", [
  12. {datatype, string}
  13. ]}.
  14. {mapping, "auth.pgsql.username", "emqx_auth_pgsql.server", [
  15. {default, ""},
  16. {datatype, string}
  17. ]}.
  18. {mapping, "auth.pgsql.password", "emqx_auth_pgsql.server", [
  19. {default, ""},
  20. {datatype, string}
  21. ]}.
  22. {mapping, "auth.pgsql.encoding", "emqx_auth_pgsql.server", [
  23. {default, utf8},
  24. {datatype, atom}
  25. ]}.
  26. {mapping, "auth.pgsql.ssl", "emqx_auth_pgsql.server", [
  27. {default, false},
  28. {datatype, {enum, [true, false]}}
  29. ]}.
  30. {mapping, "auth.pgsql.ssl.tls_versions", "emqx_auth_pgsql.server", [
  31. {default, "tlsv1.2"},
  32. {datatype, string}
  33. ]}.
  34. {mapping, "auth.pgsql.ssl_opts.keyfile", "emqx_auth_pgsql.server", [
  35. {datatype, string}
  36. ]}.
  37. {mapping, "auth.pgsql.ssl_opts.certfile", "emqx_auth_pgsql.server", [
  38. {datatype, string}
  39. ]}.
  40. {mapping, "auth.pgsql.ssl_opts.cacertfile", "emqx_auth_pgsql.server", [
  41. {datatype, string}
  42. ]}.
  43. {translation, "emqx_auth_pgsql.server", fun(Conf) ->
  44. {PgHost, PgPort} =
  45. case cuttlefish:conf_get("auth.pgsql.server", Conf) of
  46. {Ip, Port} -> {Ip, Port};
  47. S -> case string:tokens(S, ":") of
  48. [Domain] -> {Domain, 5432};
  49. [Domain, Port] -> {Domain, list_to_integer(Port)}
  50. end
  51. end,
  52. Pool = cuttlefish:conf_get("auth.pgsql.pool", Conf),
  53. Username = cuttlefish:conf_get("auth.pgsql.username", Conf),
  54. Passwd = cuttlefish:conf_get("auth.pgsql.password", Conf, ""),
  55. DB = cuttlefish:conf_get("auth.pgsql.database", Conf),
  56. Encoding = cuttlefish:conf_get("auth.pgsql.encoding", Conf),
  57. Ssl = cuttlefish:conf_get("auth.pgsql.ssl", Conf),
  58. SslVersions = [list_to_atom(Value)
  59. ||Value <- string:tokens(cuttlefish:conf_get("auth.pgsql.ssl.tls_versions", Conf), " ,")],
  60. Filter = fun(Opts) -> [{K, V} || {K, V} <- Opts, V =/= undefined] end,
  61. SslOpts = fun(Prefix) ->
  62. Filter([{keyfile, cuttlefish:conf_get(Prefix ++ ".keyfile", Conf, undefined)},
  63. {certfile, cuttlefish:conf_get(Prefix ++ ".certfile", Conf, undefined)},
  64. {cacertfile, cuttlefish:conf_get(Prefix ++ ".cacertfile", Conf, undefined)}])
  65. end,
  66. TempHost = case inet:parse_address(PgHost) of
  67. {ok, IpAddr} ->
  68. IpAddr;
  69. _ ->
  70. PgHost
  71. end,
  72. [{pool_size, Pool},
  73. {auto_reconnect, 1},
  74. {host, TempHost},
  75. {port, PgPort},
  76. {username, Username},
  77. {password, Passwd},
  78. {database, DB},
  79. {encoding, Encoding},
  80. {ssl, Ssl},
  81. {ssl_opts,[{versions, SslVersions}] ++ SslOpts("auth.pgsql.ssl_opts")}]
  82. end}.
  83. {mapping, "auth.pgsql.auth_query", "emqx_auth_pgsql.auth_query", [
  84. {datatype, string}
  85. ]}.
  86. {mapping, "auth.pgsql.password_hash", "emqx_auth_pgsql.password_hash", [
  87. {datatype, string}
  88. ]}.
  89. {mapping, "auth.pgsql.pbkdf2_macfun", "emqx_auth_pgsql.pbkdf2_macfun", [
  90. {datatype, atom}
  91. ]}.
  92. {mapping, "auth.pgsql.pbkdf2_iterations", "emqx_auth_pgsql.pbkdf2_iterations", [
  93. {datatype, integer}
  94. ]}.
  95. {mapping, "auth.pgsql.pbkdf2_dklen", "emqx_auth_pgsql.pbkdf2_dklen", [
  96. {datatype, integer}
  97. ]}.
  98. {mapping, "auth.pgsql.super_query", "emqx_auth_pgsql.super_query", [
  99. {datatype, string}
  100. ]}.
  101. {mapping, "auth.pgsql.acl_query", "emqx_auth_pgsql.acl_query", [
  102. {datatype, string}
  103. ]}.
  104. {translation, "emqx_auth_pgsql.password_hash", fun(Conf) ->
  105. HashValue = cuttlefish:conf_get("auth.pgsql.password_hash", Conf),
  106. case string:tokens(HashValue, ",") of
  107. [Hash] -> list_to_atom(Hash);
  108. [Prefix, Suffix] -> {list_to_atom(Prefix), list_to_atom(Suffix)};
  109. [Hash, MacFun, Iterations, Dklen] -> {list_to_atom(Hash), list_to_atom(MacFun), list_to_integer(Iterations), list_to_integer(Dklen)};
  110. _ -> plain
  111. end
  112. end}.