• jetlinkscommunity启动报错 PostgreSQL数据库连接异常及解决方法


    使用:java -jar jetlinks-standalone.jar
    运行项目出现如下问题:

    Caused by: org.springframework.dao.PermissionDeniedDataAccessException: Open R2DBC Connection; Ident authentication failed for user "postgres"; nested exception is io.r2dbc.postgresql.ExceptionFactory$PostgresqlAuthenticationFailure: [2for user "postgres"
    

    原因:postgresql数据库连接异常
    host all all 127.0.0.1/32 peer
    修改为
    host all all 127.0.0.1/32 md5

    这一条:host all all 0.0.0.0/0 password
    主要是解决测试时候远程连接问题,任何客户端在任何ip都可以连接

    
    # TYPE  DATABASE        USER            ADDRESS                 METHOD
    # "local" is for Unix domain socket connections only
    local   all             all                                     peer
    # IPv4 local connections:
    host    all             all             127.0.0.1/32            md5
    # IPv6 local connections:
    host    all             all             ::1/128                 ident
    # Allow replication connections from localhost, by a user with the
    # replication privilege.
    local   replication     all                                     peer
    host    replication     all             127.0.0.1/32            ident
    host    replication     all             ::1/128                 ident
    host    all             all             0.0.0.0/0               password
    
    
  • 相关阅读:
    orbis 链接 .a的问题
    程序的循环结构
    程序分支控制
    字符类型及常用的函数
    数字数据类型
    基础练习
    了解计算机
    python基础练习
    markdown基本使用
    jupyterhub
  • 原文地址:https://www.cnblogs.com/InternetJava/p/15731297.html
Copyright © 2020-2023  润新知