jdbc连接postgresql报错 ERROR:

最新推荐文章于 2024-02-05 13:28:53 发布
最新推荐文章于 2024-02-05 13:28:53 发布
阅读量1.8k 收藏
点赞数
原文链接：https://blog.csdn.net/hesperis/article/details/106691659
版权

场景:

项目中有一块功能是检测数据库连接的,测试完到现场报出连接postgresql测试失败的情况;

然鹅,我的代码里边通用函数连接都是通过用户密码验证的.这里出现了SSL的报错;难道是服务端配置强制要求证书验证?

而且测试环境中是可以正常连接的.那我们就先对比一下现场环境和测试环境的服务端配置好了;

处理过程:

1.对比测试环境和现场环境;

登录测试环境postgresql所在的服务器用户, psql

登录成功, show config_file;

退出psql,查看配置; cat /var/lib/pgsql/data/postgresql.conf | grep ssl

我们可以看到ssl相关配置都注释掉的;也就是说测试环境的配置是不支持ssl证书验证的;

那我们看看现场环境; wtf,现场同事说data目录下没有配置文件;他们安装这个postgresql是通过一个drdb的工具安装的;百度一波只有drbd,线索断了啊!

  1. 查资料尝试:

网上有文章支持,这个报错有可能是ssl版本/协议不对导致的; 查 openssl version

ssl版本一模一样.

病急乱投医,检查数据库版本; select “version”();

postgres版本一模一样.

僵住了.

查下官方文档.关于ssl的说明;

ssl证书验证高安全性的策略的话是需要在服务端和客户端配置证书,sslmode的级别是在verify-ca和verify-full;

大胆猜测一下,当服务端不设置ssl认证时(测试环境),

客户端可以不做sslmode配置;当服务端设置了ssl认证时,客户端连接就需要说明自己的sslmode了.目测为需要配置sslmode=disable,

3.做测试代码测试;

package com.springboot.demo.testDemo.pgjdbc;

import java.sql.Connection;
import java.sql.DriverManager;

/**

  • @Date 2020/6/10 16:44
  • @Author zhang.fanlc
  • @Description
    **/
    public class PgJDBC {
    public static void main(String[] args) {
    String url = “jdbc:postgresql://[ip]:[port]/[dbName]?sslmode=disable”;
    String driver = “org.postgresql.Driver”;
    String user = “test”;
    String pass = “test”;
    try {
    Class.forName(driver);
    System.out.println(“开始连接…!”);
    Connection conn = DriverManager.getConnection(url,user,pass);
    if(conn != null){
    System.out.println(“连接成功!”);
    }
    }catch(Exception e){
    e.printStackTrace();
    }
    }
    }
    把PgJDBC.java拷贝到现场环境;
    vi PgJDBC.java, 去掉 package声明;
    设置依赖,vi setEnv.sh ,export CLASSPATH=.:/home/cmspmn/lib/postgresql-42.2.8.jar:,保存,./setEnv.sh,执行;

javac PgJDBC.java

java PgJDBC

https://www.wenjuan.com/z/ammINfa
https://www.wenjuan.com/d/ammINfa
https://www.wenjuan.com/s/ammINfa
https://www.wenjuan.com/t/ammINfa
https://www.wenjuan.com/z/RZzeYjj
https://www.wenjuan.com/d/RZzeYjj
https://www.wenjuan.com/s/RZzeYjj
https://www.wenjuan.com/t/RZzeYjj
https://www.wenjuan.com/z/f2m63mv
https://www.wenjuan.com/d/f2m63mv
https://www.wenjuan.com/s/f2m63mv
https://www.wenjuan.com/t/f2m63mv
https://www.wenjuan.com/z/FBNVfel
https://www.wenjuan.com/d/FBNVfel
https://www.wenjuan.com/s/FBNVfel
https://www.wenjuan.com/t/FBNVfel
https://www.wenjuan.com/z/ZvIjUbM
https://www.wenjuan.com/d/ZvIjUbM
https://www.wenjuan.com/s/ZvIjUbM
https://www.wenjuan.com/t/ZvIjUbM
https://www.wenjuan.com/z/aa2URn8
https://www.wenjuan.com/d/aa2URn8
https://www.wenjuan.com/s/aa2URn8
https://www.wenjuan.com/t/aa2URn8
https://www.wenjuan.com/z/Y3qIR3l
https://www.wenjuan.com/d/Y3qIR3l
https://www.wenjuan.com/s/Y3qIR3l
https://www.wenjuan.com/t/Y3qIR3l
https://www.wenjuan.com/z/MJFr6nA
https://www.wenjuan.com/d/MJFr6nA
https://www.wenjuan.com/s/MJFr6nA
https://www.wenjuan.com/t/MJFr6nA
https://www.wenjuan.com/z/JJF3m2C
https://www.wenjuan.com/d/JJF3m2C
https://www.wenjuan.com/s/JJF3m2C
https://www.wenjuan.com/t/JJF3m2C
https://www.wenjuan.com/z/jm226vV
https://www.wenjuan.com/d/jm226vV
https://www.wenjuan.com/s/jm226vV
https://www.wenjuan.com/t/jm226vV
https://www.wenjuan.com/z/73ua22G
https://www.wenjuan.com/d/73ua22G
https://www.wenjuan.com/s/73ua22G
https://www.wenjuan.com/t/73ua22G
https://www.wenjuan.com/z/vMfIJvv
https://www.wenjuan.com/d/vMfIJvv
https://www.wenjuan.com/s/vMfIJvv
https://www.wenjuan.com/t/vMfIJvv
https://www.wenjuan.com/z/6Rb6Vb2
https://www.wenjuan.com/d/6Rb6Vb2
https://www.wenjuan.com/s/6Rb6Vb2
https://www.wenjuan.com/t/6Rb6Vb2
https://www.wenjuan.com/z/Nfiqyy9
https://www.wenjuan.com/d/Nfiqyy9
https://www.wenjuan.com/s/Nfiqyy9
https://www.wenjuan.com/t/Nfiqyy9
https://www.wenjuan.com/z/mYzqeyH
https://www.wenjuan.com/d/mYzqeyH
https://www.wenjuan.com/s/mYzqeyH
https://www.wenjuan.com/t/mYzqeyH
https://www.wenjuan.com/z/nAruue8
https://www.wenjuan.com/d/nAruue8
https://www.wenjuan.com/s/nAruue8
https://www.wenjuan.com/t/nAruue8
https://www.wenjuan.com/z/3YBZNb0
https://www.wenjuan.com/d/3YBZNb0
https://www.wenjuan.com/s/3YBZNb0
https://www.wenjuan.com/t/3YBZNb0
https://www.wenjuan.com/z/aYnU7n7
https://www.wenjuan.com/d/aYnU7n7
https://www.wenjuan.com/s/aYnU7n7
https://www.wenjuan.com/t/aYnU7n7
https://www.wenjuan.com/z/An6nIv6
https://www.wenjuan.com/d/An6nIv6
https://www.wenjuan.com/s/An6nIv6
https://www.wenjuan.com/t/An6nIv6
https://www.wenjuan.com/z/r6VfEnk
https://www.wenjuan.com/d/r6VfEnk
https://www.wenjuan.com/s/r6VfEnk
https://www.wenjuan.com/t/r6VfEnk
https://www.wenjuan.com/z/IRJ7Bf
https://www.wenjuan.com/d/IRJ7Bf
https://www.wenjuan.com/s/IRJ7Bf
https://www.wenjuan.com/t/IRJ7Bf
https://www.wenjuan.com/z/FBviiiZ
https://www.wenjuan.com/d/FBviiiZ
https://www.wenjuan.com/s/FBviiiZ
https://www.wenjuan.com/t/FBviiiZ
https://www.wenjuan.com/z/N7RZR3
https://www.wenjuan.com/d/N7RZR3
https://www.wenjuan.com/s/N7RZR3
https://www.wenjuan.com/t/N7RZR3
https://www.wenjuan.com/z/zIRjQrV
https://www.wenjuan.com/d/zIRjQrV
https://www.wenjuan.com/s/zIRjQrV
https://www.wenjuan.com/t/zIRjQrV
https://www.wenjuan.com/z/NzYNnq
https://www.wenjuan.com/d/NzYNnq
https://www.wenjuan.com/s/NzYNnq
https://www.wenjuan.com/t/NzYNnq
https://www.wenjuan.com/z/N7fymir
https://www.wenjuan.com/d/N7fymir
https://www.wenjuan.com/s/N7fymir
https://www.wenjuan.com/t/N7fymir
https://www.wenjuan.com/z/iQfUbmy
https://www.wenjuan.com/d/iQfUbmy
https://www.wenjuan.com/s/iQfUbmy
https://www.wenjuan.com/t/iQfUbmy
https://www.wenjuan.com/z/N7NrQvy
https://www.wenjuan.com/d/N7NrQvy
https://www.wenjuan.com/s/N7NrQvy
https://www.wenjuan.com/t/N7NrQvy
https://www.wenjuan.com/z/euiuIvM
https://www.wenjuan.com/d/euiuIvM
https://www.wenjuan.com/s/euiuIvM
https://www.wenjuan.com/t/euiuIvM
https://www.wenjuan.com/z/ZZ7fUvU
https://www.wenjuan.com/d/ZZ7fUvU
https://www.wenjuan.com/s/ZZ7fUvU
https://www.wenjuan.com/t/ZZ7fUvU
https://www.wenjuan.com/z/fiMrUn1
https://www.wenjuan.com/d/fiMrUn1
https://www.wenjuan.com/s/fiMrUn1
https://www.wenjuan.com/t/fiMrUn1
https://www.wenjuan.com/z/iq6bUby
https://www.wenjuan.com/d/iq6bUby
https://www.wenjuan.com/s/iq6bUby
https://www.wenjuan.com/t/iq6bUby
https://www.wenjuan.com/z/JNv2AnH
https://www.wenjuan.com/d/JNv2AnH
https://www.wenjuan.com/s/JNv2AnH
https://www.wenjuan.com/t/JNv2AnH
https://www.wenjuan.com/z/UvUvqe7
https://www.wenjuan.com/d/UvUvqe7
https://www.wenjuan.com/s/UvUvqe7
https://www.wenjuan.com/t/UvUvqe7
https://www.wenjuan.com/z/FBvqee
https://www.wenjuan.com/d/FBvqee
https://www.wenjuan.com/s/FBvqee
https://www.wenjuan.com/t/FBvqee
https://www.wenjuan.com/z/FrqQzaV
https://www.wenjuan.com/d/FrqQzaV
https://www.wenjuan.com/s/FrqQzaV
https://www.wenjuan.com/t/FrqQzaV
https://www.wenjuan.com/z/eQjAZnK
https://www.wenjuan.com/d/eQjAZnK
https://www.wenjuan.com/s/eQjAZnK
https://www.wenjuan.com/t/eQjAZnK
https://www.wenjuan.com/z/zABnUzL
https://www.wenjuan.com/d/zABnUzL
https://www.wenjuan.com/s/zABnUzL
https://www.wenjuan.com/t/zABnUzL
https://www.wenjuan.com/z/fmAFf2a
https://www.wenjuan.com/d/fmAFf2a
https://www.wenjuan.com/s/fmAFf2a
https://www.wenjuan.com/t/fmAFf2a
https://www.wenjuan.com/z/AVJrEf
https://www.wenjuan.com/d/AVJrEf
https://www.wenjuan.com/s/AVJrEf
https://www.wenjuan.com/t/AVJrEf
https://www.wenjuan.com/z/63yeUbH
https://www.wenjuan.com/d/63yeUbH
https://www.wenjuan.com/s/63yeUbH
https://www.wenjuan.com/t/63yeUbH
https://www.wenjuan.com/z/AfQBBjP
https://www.wenjuan.com/d/AfQBBjP
https://www.wenjuan.com/s/AfQBBjP
https://www.wenjuan.com/t/AfQBBjP
https://www.wenjuan.com/z/NvmMNnv
https://www.wenjuan.com/d/NvmMNnv
https://www.wenjuan.com/s/NvmMNnv
https://www.wenjuan.com/t/NvmMNnv
https://www.wenjuan.com/z/q2Qr2yD
https://www.wenjuan.com/d/q2Qr2yD
https://www.wenjuan.com/s/q2Qr2yD
https://www.wenjuan.com/t/q2Qr2yD
https://www.wenjuan.com/z/qQrqmm
https://www.wenjuan.com/d/qQrqmm
https://www.wenjuan.com/s/qQrqmm
https://www.wenjuan.com/t/qQrqmm
https://www.wenjuan.com/z/bqU7Bnn
https://www.wenjuan.com/d/bqU7Bnn
https://www.wenjuan.com/s/bqU7Bnn
https://www.wenjuan.com/t/bqU7Bnn
https://www.wenjuan.com/z/FRR7jeC
https://www.wenjuan.com/d/FRR7jeC
https://www.wenjuan.com/s/FRR7jeC
https://www.wenjuan.com/t/FRR7jeC
https://www.wenjuan.com/z/qEv6nyh
https://www.wenjuan.com/d/qEv6nyh
https://www.wenjuan.com/s/qEv6nyh
https://www.wenjuan.com/t/qEv6nyh
https://www.wenjuan.com/z/QRFBBb1
https://www.wenjuan.com/d/QRFBBb1
https://www.wenjuan.com/s/QRFBBb1
https://www.wenjuan.com/t/QRFBBb1
https://www.wenjuan.com/z/z2M3Mn5
https://www.wenjuan.com/d/z2M3Mn5
https://www.wenjuan.com/s/z2M3Mn5
https://www.wenjuan.com/t/z2M3Mn5
https://www.wenjuan.com/z/qAVbmaz
https://www.wenjuan.com/d/qAVbmaz
https://www.wenjuan.com/s/qAVbmaz
https://www.wenjuan.com/t/qAVbmaz
https://www.wenjuan.com/z/JZNbUr4
https://www.wenjuan.com/d/JZNbUr4
https://www.wenjuan.com/s/JZNbUr4
https://www.wenjuan.com/t/JZNbUr4
https://www.wenjuan.com/z/NZbe2q
https://www.wenjuan.com/d/NZbe2q
https://www.wenjuan.com/s/NZbe2q
https://www.wenjuan.com/t/NZbe2q
https://www.wenjuan.com/z/6ZZNrmA
https://www.wenjuan.com/d/6ZZNrmA
https://www.wenjuan.com/s/6ZZNrmA
https://www.wenjuan.com/t/6ZZNrmA
https://www.wenjuan.com/z/fQNZ3yx
https://www.wenjuan.com/d/fQNZ3yx
https://www.wenjuan.com/s/fQNZ3yx
https://www.wenjuan.com/t/fQNZ3yx
https://www.wenjuan.com/z/NjUjmmF
https://www.wenjuan.com/d/NjUjmmF
https://www.wenjuan.com/s/NjUjmmF
https://www.wenjuan.com/t/NjUjmmF
https://www.wenjuan.com/z/aayyAza
https://www.wenjuan.com/d/aayyAza
https://www.wenjuan.com/s/aayyAza
https://www.wenjuan.com/t/aayyAza
https://www.wenjuan.com/z/aE3AniP
https://www.wenjuan.com/d/aE3AniP
https://www.wenjuan.com/s/aE3AniP
https://www.wenjuan.com/t/aE3AniP
https://www.wenjuan.com/z/eqqQvuO
https://www.wenjuan.com/d/eqqQvuO
https://www.wenjuan.com/s/eqqQvuO
https://www.wenjuan.com/t/eqqQvuO
https://www.wenjuan.com/z/mAZrmmP
https://www.wenjuan.com/d/mAZrmmP
https://www.wenjuan.com/s/mAZrmmP
https://www.wenjuan.com/t/mAZrmmP
https://www.wenjuan.com/z/uAFZNj8
https://www.wenjuan.com/d/uAFZNj8
https://www.wenjuan.com/s/uAFZNj8
https://www.wenjuan.com/t/uAFZNj8
https://www.wenjuan.com/z/Q3am6vF
https://www.wenjuan.com/d/Q3am6vF
https://www.wenjuan.com/s/Q3am6vF
https://www.wenjuan.com/t/Q3am6vF
https://www.wenjuan.com/z/NZbmIr
https://www.wenjuan.com/d/NZbmIr
https://www.wenjuan.com/s/NZbmIr
https://www.wenjuan.com/t/NZbmIr
https://www.wenjuan.com/z/zqqmu2
https://www.wenjuan.com/d/zqqmu2
https://www.wenjuan.com/s/zqqmu2
https://www.wenjuan.com/t/zqqmu2
https://www.wenjuan.com/z/ZBbquyP
https://www.wenjuan.com/d/ZBbquyP
https://www.wenjuan.com/s/ZBbquyP
https://www.wenjuan.com/t/ZBbquyP
https://www.wenjuan.com/z/32euaqQ
https://www.wenjuan.com/d/32euaqQ
https://www.wenjuan.com/s/32euaqQ
https://www.wenjuan.com/t/32euaqQ
https://www.wenjuan.com/z/V3U7Jfe
https://www.wenjuan.com/d/V3U7Jfe
https://www.wenjuan.com/s/V3U7Jfe
https://www.wenjuan.com/t/V3U7Jfe
https://www.wenjuan.com/z/eEBNBzJ
https://www.wenjuan.com/d/eEBNBzJ
https://www.wenjuan.com/s/eEBNBzJ
https://www.wenjuan.com/t/eEBNBzJ
https://www.wenjuan.com/z/UnuQb2sa
https://www.wenjuan.com/d/UnuQb2sa
https://www.wenjuan.com/s/UnuQb2sa
https://www.wenjuan.com/t/UnuQb2sa
https://www.wenjuan.com/z/n6jMryB
https://www.wenjuan.com/d/n6jMryB
https://www.wenjuan.com/s/n6jMryB
https://www.wenjuan.com/t/n6jMryB
https://www.wenjuan.com/z/QrInEbL
https://www.wenjuan.com/d/QrInEbL
https://www.wenjuan.com/s/QrInEbL
https://www.wenjuan.com/t/QrInEbL
https://www.wenjuan.com/z/rmAveia
https://www.wenjuan.com/d/rmAveia
https://www.wenjuan.com/s/rmAveia
https://www.wenjuan.com/t/rmAveia
https://www.wenjuan.com/z/322y6zG
https://www.wenjuan.com/d/322y6zG
https://www.wenjuan.com/s/322y6zG
https://www.wenjuan.com/t/322y6zG
https://www.wenjuan.com/z/uqMv6vC
https://www.wenjuan.com/d/uqMv6vC
https://www.wenjuan.com/s/uqMv6vC
https://www.wenjuan.com/t/uqMv6vC
https://www.wenjuan.com/z/F7zE7rE
https://www.wenjuan.com/d/F7zE7rE
https://www.wenjuan.com/s/F7zE7rE
https://www.wenjuan.com/t/F7zE7rE
https://www.wenjuan.com/z/B7JRz2f
https://www.wenjuan.com/d/B7JRz2f
https://www.wenjuan.com/s/B7JRz2f
https://www.wenjuan.com/t/B7JRz2f
https://www.wenjuan.com/z/RnAzi2c
https://www.wenjuan.com/d/RnAzi2c
https://www.wenjuan.com/s/RnAzi2c
https://www.wenjuan.com/t/RnAzi2c
https://www.wenjuan.com/z/bI73Qz8
https://www.wenjuan.com/d/bI73Qz8
https://www.wenjuan.com/s/bI73Qz8
https://www.wenjuan.com/t/bI73Qz8
https://www.wenjuan.com/z/zM3iQ3Qf
https://www.wenjuan.com/d/zM3iQ3Qf
https://www.wenjuan.com/s/zM3iQ3Qf
https://www.wenjuan.com/t/zM3iQ3Qf
https://www.wenjuan.com/z/JJbIVrI
https://www.wenjuan.com/d/JJbIVrI
https://www.wenjuan.com/s/JJbIVrI
https://www.wenjuan.com/t/JJbIVrI
https://www.wenjuan.com/z/JR322yS
https://www.wenjuan.com/d/JR322yS
https://www.wenjuan.com/s/JR322yS
https://www.wenjuan.com/t/JR322yS
https://www.wenjuan.com/z/zQzYFv3
https://www.wenjuan.com/d/zQzYFv3
https://www.wenjuan.com/s/zQzYFv3
https://www.wenjuan.com/t/zQzYFv3
https://www.wenjuan.com/z/VbqQVnf
https://www.wenjuan.com/d/VbqQVnf
https://www.wenjuan.com/s/VbqQVnf
https://www.wenjuan.com/t/VbqQVnf
https://www.wenjuan.com/z/uiAzMvT
https://www.wenjuan.com/d/uiAzMvT
https://www.wenjuan.com/s/uiAzMvT
https://www.wenjuan.com/t/uiAzMvT
https://www.wenjuan.com/z/EnmuMfL
https://www.wenjuan.com/d/EnmuMfL
https://www.wenjuan.com/s/EnmuMfL
https://www.wenjuan.com/t/EnmuMfL
https://www.wenjuan.com/z/FVfmiyN
https://www.wenjuan.com/d/FVfmiyN
https://www.wenjuan.com/s/FVfmiyN
https://www.wenjuan.com/t/FVfmiyN
https://www.wenjuan.com/z/ZbEnaqW
https://www.wenjuan.com/d/ZbEnaqW
https://www.wenjuan.com/s/ZbEnaqW
https://www.wenjuan.com/t/ZbEnaqW
https://www.wenjuan.com/z/3URV3iL
https://www.wenjuan.com/d/3URV3iL
https://www.wenjuan.com/s/3URV3iL
https://www.wenjuan.com/t/3URV3iL
https://www.wenjuan.com/z/qe6RnuA
https://www.wenjuan.com/d/qe6RnuA
https://www.wenjuan.com/s/qe6RnuA
https://www.wenjuan.com/t/qe6RnuA
https://www.wenjuan.com/z/bYVJZ3g
https://www.wenjuan.com/d/bYVJZ3g
https://www.wenjuan.com/s/bYVJZ3g
https://www.wenjuan.com/t/bYVJZ3g
https://www.wenjuan.com/z/n63EFjY
https://www.wenjuan.com/d/n63EFjY
https://www.wenjuan.com/s/n63EFjY
https://www.wenjuan.com/t/n63EFjY
https://www.wenjuan.com/z/imqa6nR
https://www.wenjuan.com/d/imqa6nR
https://www.wenjuan.com/s/imqa6nR
https://www.wenjuan.com/t/imqa6nR
https://www.wenjuan.com/z/m6JrMj0
https://www.wenjuan.com/d/m6JrMj0
https://www.wenjuan.com/s/m6JrMj0
https://www.wenjuan.com/t/m6JrMj0
https://www.wenjuan.com/z/jYfM32X
https://www.wenjuan.com/d/jYfM32X
https://www.wenjuan.com/s/jYfM32X
https://www.wenjuan.com/t/jYfM32X
https://www.wenjuan.com/z/bI3Ez2
https://www.wenjuan.com/d/bI3Ez2
https://www.wenjuan.com/s/bI3Ez2
https://www.wenjuan.com/t/bI3Ez2
https://www.wenjuan.com/z/RNR732
https://www.wenjuan.com/d/RNR732
https://www.wenjuan.com/s/RNR732
https://www.wenjuan.com/t/RNR732
https://www.wenjuan.com/z/IfEvqq
https://www.wenjuan.com/d/IfEvqq
https://www.wenjuan.com/s/IfEvqq
https://www.wenjuan.com/t/IfEvqq
https://www.wenjuan.com/z/3Ir6zu1
https://www.wenjuan.com/d/3Ir6zu1
https://www.wenjuan.com/s/3Ir6zu1
https://www.wenjuan.com/t/3Ir6zu1
https://www.wenjuan.com/z/ziAjIbV
https://www.wenjuan.com/d/ziAjIbV
https://www.wenjuan.com/s/ziAjIbV
https://www.wenjuan.com/t/ziAjIbV
https://www.wenjuan.com/z/UJVfmy
https://www.wenjuan.com/d/UJVfmy
https://www.wenjuan.com/s/UJVfmy
https://www.wenjuan.com/t/UJVfmy
https://www.wenjuan.com/z/m2AbEju
https://www.wenjuan.com/d/m2AbEju
https://www.wenjuan.com/s/m2AbEju
https://www.wenjuan.com/t/m2AbEju
https://www.wenjuan.com/z/UFRb2uu
https://www.wenjuan.com/d/UFRb2uu
https://www.wenjuan.com/s/UFRb2uu
https://www.wenjuan.com/t/UFRb2uu
https://www.wenjuan.com/z/6R3Yb2z
https://www.wenjuan.com/d/6R3Yb2z
https://www.wenjuan.com/s/6R3Yb2z
https://www.wenjuan.com/t/6R3Yb2z
https://www.wenjuan.com/z/nqQVfag
https://www.wenjuan.com/d/nqQVfag
https://www.wenjuan.com/s/nqQVfag
https://www.wenjuan.com/t/nqQVfag
https://www.wenjuan.com/z/bAZ3iey
https://www.wenjuan.com/d/bAZ3iey
https://www.wenjuan.com/s/bAZ3iey
https://www.wenjuan.com/t/bAZ3iey
https://www.wenjuan.com/z/eUz2QnX
https://www.wenjuan.com/d/eUz2QnX
https://www.wenjuan.com/s/eUz2QnX
https://www.wenjuan.com/t/eUz2QnX
https://www.wenjuan.com/z/2UjeUvt
https://www.wenjuan.com/d/2UjeUvt
https://www.wenjuan.com/s/2UjeUvt
https://www.wenjuan.com/t/2UjeUvt
https://www.wenjuan.com/z/Mn2Ivam
https://www.wenjuan.com/d/Mn2Ivam
https://www.wenjuan.com/s/Mn2Ivam
https://www.wenjuan.com/t/Mn2Ivam
https://www.wenjuan.com/z/rUNrUbB
https://www.wenjuan.com/d/rUNrUbB
https://www.wenjuan.com/s/rUNrUbB
https://www.wenjuan.com/t/rUNrUbB
https://www.wenjuan.com/z/Bbq22y5
https://www.wenjuan.com/d/Bbq22y5
https://www.wenjuan.com/s/Bbq22y5
https://www.wenjuan.com/t/Bbq22y5
https://www.wenjuan.com/z/yeIfi20
https://www.wenjuan.com/d/yeIfi20
https://www.wenjuan.com/s/yeIfi20
https://www.wenjuan.com/t/yeIfi20
https://www.wenjuan.com/z/yaMJvaJ
https://www.wenjuan.com/d/yaMJvaJ
https://www.wenjuan.com/s/yaMJvaJ
https://www.wenjuan.com/t/yaMJvaJ
https://www.wenjuan.com/z/yIzmMbI
https://www.wenjuan.com/d/yIzmMbI
https://www.wenjuan.com/s/yIzmMbI
https://www.wenjuan.com/t/yIzmMbI
https://www.wenjuan.com/z/Zb2emm
https://www.wenjuan.com/d/Zb2emm
https://www.wenjuan.com/s/Zb2emm
https://www.wenjuan.com/t/Zb2emm
https://www.wenjuan.com/z/M32Mnqu
https://www.wenjuan.com/d/M32Mnqu
https://www.wenjuan.com/s/M32Mnqu
https://www.wenjuan.com/t/M32Mnqu
https://www.wenjuan.com/z/Mzqmyi1
https://www.wenjuan.com/d/Mzqmyi1
https://www.wenjuan.com/s/Mzqmyi1
https://www.wenjuan.com/t/Mzqmyi1
https://www.wenjuan.com/z/eInMva8
https://www.wenjuan.com/d/eInMva8
https://www.wenjuan.com/s/eInMva8
https://www.wenjuan.com/t/eInMva8
https://www.wenjuan.com/z/bmY73yK
https://www.wenjuan.com/d/bmY73yK
https://www.wenjuan.com/s/bmY73yK
https://www.wenjuan.com/t/bmY73yK
https://www.wenjuan.com/z/bEF3Aj0
https://www.wenjuan.com/d/bEF3Aj0
https://www.wenjuan.com/s/bEF3Aj0
https://www.wenjuan.com/t/bEF3Aj0
https://www.wenjuan.com/z/E3y22yz
https://www.wenjuan.com/d/E3y22yz
https://www.wenjuan.com/s/E3y22yz
https://www.wenjuan.com/t/E3y22yz
https://www.wenjuan.com/z/BNf6Vv1
https://www.wenjuan.com/d/BNf6Vv1
https://www.wenjuan.com/s/BNf6Vv1
https://www.wenjuan.com/t/BNf6Vv1
https://www.wenjuan.com/z/6vU36zP
https://www.wenjuan.com/d/6vU36zP
https://www.wenjuan.com/s/6vU36zP
https://www.wenjuan.com/t/6vU36zP
https://www.wenjuan.com/z/ZvMvuae
https://www.wenjuan.com/d/ZvMvuae
https://www.wenjuan.com/s/ZvMvuae
https://www.wenjuan.com/t/ZvMvuae
https://www.wenjuan.com/z/nuqURjS
https://www.wenjuan.com/d/nuqURjS
https://www.wenjuan.com/s/nuqURjS
https://www.wenjuan.com/t/nuqURjS
https://www.wenjuan.com/z/vMF3eu1
https://www.wenjuan.com/d/vMF3eu1
https://www.wenjuan.com/s/vMF3eu1
https://www.wenjuan.com/t/vMF3eu1
https://www.wenjuan.com/z/RfAFraI
https://www.wenjuan.com/d/RfAFraI
https://www.wenjuan.com/s/RfAFraI
https://www.wenjuan.com/t/RfAFraI
https://www.wenjuan.com/z/MZFFruS
https://www.wenjuan.com/d/MZFFruS
https://www.wenjuan.com/s/MZFFruS
https://www.wenjuan.com/t/MZFFruS
https://www.wenjuan.com/z/rMRbMv9
https://www.wenjuan.com/d/rMRbMv9
https://www.wenjuan.com/s/rMRbMv9
https://www.wenjuan.com/t/rMRbMv9
https://www.wenjuan.com/z/77BbEfu
https://www.wenjuan.com/d/77BbEfu
https://www.wenjuan.com/s/77BbEfu
https://www.wenjuan.com/t/77BbEfu
https://www.wenjuan.com/z/NrUfQvo
https://www.wenjuan.com/d/NrUfQvo
https://www.wenjuan.com/s/NrUfQvo
https://www.wenjuan.com/t/NrUfQvo
https://www.wenjuan.com/z/Q3Qz6vR
https://www.wenjuan.com/d/Q3Qz6vR
https://www.wenjuan.com/s/Q3Qz6vR
https://www.wenjuan.com/t/Q3Qz6vR
https://www.wenjuan.com/z/jAZNjiW
https://www.wenjuan.com/d/jAZNjiW
https://www.wenjuan.com/s/jAZNjiW
https://www.wenjuan.com/t/jAZNjiW
https://www.wenjuan.com/z/zYrYFba
https://www.wenjuan.com/d/zYrYFba
https://www.wenjuan.com/s/zYrYFba
https://www.wenjuan.com/t/zYrYFba
https://www.wenjuan.com/z/ieuaIfK
https://www.wenjuan.com/d/ieuaIfK
https://www.wenjuan.com/s/ieuaIfK
https://www.wenjuan.com/t/ieuaIfK
https://www.wenjuan.com/z/ji6vqan
https://www.wenjuan.com/d/ji6vqan
https://www.wenjuan.com/s/ji6vqan
https://www.wenjuan.com/t/ji6vqan
https://www.wenjuan.com/z/bieaei
https://www.wenjuan.com/d/bieaei
https://www.wenjuan.com/s/bieaei
https://www.wenjuan.com/t/bieaei
https://www.wenjuan.com/z/qUr2ErE
https://www.wenjuan.com/d/qUr2ErE
https://www.wenjuan.com/s/qUr2ErE
https://www.wenjuan.com/t/qUr2ErE
https://www.wenjuan.com/z/iERny2z
https://www.wenjuan.com/d/iERny2z
https://www.wenjuan.com/s/iERny2z
https://www.wenjuan.com/t/iERny2z
https://www.wenjuan.com/z/uAFZrmD
https://www.wenjuan.com/d/uAFZrmD
https://www.wenjuan.com/s/uAFZrmD
https://www.wenjuan.com/t/uAFZrmD
https://www.wenjuan.com/z/b6rEjqa
https://www.wenjuan.com/d/b6rEjqa
https://www.wenjuan.com/s/b6rEjqa
https://www.wenjuan.com/t/b6rEjqa
https://www.wenjuan.com/z/MvAFF3f
https://www.wenjuan.com/d/MvAFF3f
https://www.wenjuan.com/s/MvAFF3f
https://www.wenjuan.com/t/MvAFF3f
https://www.wenjuan.com/z/VJnYBzb
https://www.wenjuan.com/d/VJnYBzb
https://www.wenjuan.com/s/VJnYBzb
https://www.wenjuan.com/t/VJnYBzb
https://www.wenjuan.com/z/zYrIBrP
https://www.wenjuan.com/d/zYrIBrP
https://www.wenjuan.com/s/zYrIBrP
https://www.wenjuan.com/t/zYrIBrP
https://www.wenjuan.com/z/ZzABvqh
https://www.wenjuan.com/d/ZzABvqh
https://www.wenjuan.com/s/ZzABvqh
https://www.wenjuan.com/t/ZzABvqh
https://www.wenjuan.com/z/EreQN3g
https://www.wenjuan.com/d/EreQN3g
https://www.wenjuan.com/s/EreQN3g
https://www.wenjuan.com/t/EreQN3g
https://www.wenjuan.com/z/63A3mey
https://www.wenjuan.com/d/63A3mey
https://www.wenjuan.com/s/63A3mey
https://www.wenjuan.com/t/63A3mey
https://www.wenjuan.com/z/rQ7jEz
https://www.wenjuan.com/d/rQ7jEz
https://www.wenjuan.com/s/rQ7jEz
https://www.wenjuan.com/t/rQ7jEz
https://www.wenjuan.com/z/367zIfJ
https://www.wenjuan.com/d/367zIfJ
https://www.wenjuan.com/s/367zIfJ
https://www.wenjuan.com/t/367zIfJ
https://www.wenjuan.com/z/VZJrYr5
https://www.wenjuan.com/d/VZJrYr5
https://www.wenjuan.com/s/VZJrYr5
https://www.wenjuan.com/t/VZJrYr5
https://www.wenjuan.com/z/vuy6n2W
https://www.wenjuan.com/d/vuy6n2W
https://www.wenjuan.com/s/vuy6n2W
https://www.wenjuan.com/t/vuy6n2W
https://www.wenjuan.com/z/2iaa2uK
https://www.wenjuan.com/d/2iaa2uK
https://www.wenjuan.com/s/2iaa2uK
https://www.wenjuan.com/t/2iaa2uK
https://www.wenjuan.com/z/3uEvu2g
https://www.wenjuan.com/d/3uEvu2g
https://www.wenjuan.com/s/3uEvu2g
https://www.wenjuan.com/t/3uEvu2g
https://www.wenjuan.com/z/vQfEzmu
https://www.wenjuan.com/d/vQfEzmu
https://www.wenjuan.com/s/vQfEzmu
https://www.wenjuan.com/t/vQfEzmu
https://www.wenjuan.com/z/FbUJJjL
https://www.wenjuan.com/d/FbUJJjL
https://www.wenjuan.com/s/FbUJJjL
https://www.wenjuan.com/t/FbUJJjL
https://www.wenjuan.com/z/YNRrU3
https://www.wenjuan.com/d/YNRrU3
https://www.wenjuan.com/s/YNRrU3
https://www.wenjuan.com/t/YNRrU3
https://www.wenjuan.com/z/MfYBJn0
https://www.wenjuan.com/d/MfYBJn0
https://www.wenjuan.com/s/MfYBJn0
https://www.wenjuan.com/t/MfYBJn0
https://www.wenjuan.com/z/6FN7Bf
https://www.wenjuan.com/d/6FN7Bf
https://www.wenjuan.com/s/6FN7Bf
https://www.wenjuan.com/t/6FN7Bf
https://www.wenjuan.com/z/ER7vyyy
https://www.wenjuan.com/d/ER7vyyy
https://www.wenjuan.com/s/ER7vyyy
https://www.wenjuan.com/t/ER7vyyy
https://www.wenjuan.com/z/reEBfqT
https://www.wenjuan.com/d/reEBfqT
https://www.wenjuan.com/s/reEBfqT
https://www.wenjuan.com/t/reEBfqT
https://www.wenjuan.com/z/jUfIZb6
https://www.wenjuan.com/d/jUfIZb6
https://www.wenjuan.com/s/jUfIZb6
https://www.wenjuan.com/t/jUfIZb6
https://www.wenjuan.com/z/ERBVzuC
https://www.wenjuan.com/d/ERBVzuC
https://www.wenjuan.com/s/ERBVzuC
https://www.wenjuan.com/t/ERBVzuC
https://www.wenjuan.com/z/vqyMZzv
https://www.wenjuan.com/d/vqyMZzv
https://www.wenjuan.com/s/vqyMZzv
https://www.wenjuan.com/t/vqyMZzv
https://www.wenjuan.com/z/QNny6n9
https://www.wenjuan.com/d/QNny6n9
https://www.wenjuan.com/s/QNny6n9
https://www.wenjuan.com/t/QNny6n9
https://www.wenjuan.com/z/Zjm6R3p
https://www.wenjuan.com/d/Zjm6R3p
https://www.wenjuan.com/s/Zjm6R3p
https://www.wenjuan.com/t/Zjm6R3p
https://www.wenjuan.com/z/EVzUniB
https://www.wenjuan.com/d/EVzUniB
https://www.wenjuan.com/s/EVzUniB
https://www.wenjuan.com/t/EVzUniB
https://www.wenjuan.com/z/b2uuU3Y
https://www.wenjuan.com/d/b2uuU3Y
https://www.wenjuan.com/s/b2uuU3Y
https://www.wenjuan.com/t/b2uuU3Y
https://www.wenjuan.com/z/aIZzm2L
https://www.wenjuan.com/d/aIZzm2L
https://www.wenjuan.com/s/aIZzm2L
https://www.wenjuan.com/t/aIZzm2L
https://www.wenjuan.com/z/yIBnQr
https://www.wenjuan.com/d/yIBnQr
https://www.wenjuan.com/s/yIBnQr
https://www.wenjuan.com/t/yIBnQr
https://www.wenjuan.com/z/ZzA3q2Q
https://www.wenjuan.com/d/ZzA3q2Q
https://www.wenjuan.com/s/ZzA3q2Q
https://www.wenjuan.com/t/ZzA3q2Q
https://www.wenjuan.com/z/VN3yUvk
https://www.wenjuan.com/d/VN3yUvk
https://www.wenjuan.com/s/VN3yUvk
https://www.wenjuan.com/t/VN3yUvk
https://www.wenjuan.com/z/eMrYn29
https://www.wenjuan.com/d/eMrYn29
https://www.wenjuan.com/s/eMrYn29
https://www.wenjuan.com/t/eMrYn29
https://www.wenjuan.com/z/ZRrmAjK
https://www.wenjuan.com/d/ZRrmAjK
https://www.wenjuan.com/s/ZRrmAjK
https://www.wenjuan.com/t/ZRrmAjK
https://www.wenjuan.com/z/6Fve6ry
https://www.wenjuan.com/d/6Fve6ry
https://www.wenjuan.com/s/6Fve6ry
https://www.wenjuan.com/t/6Fve6ry
https://www.wenjuan.com/z/fmyeqa2
https://www.wenjuan.com/d/fmyeqa2
https://www.wenjuan.com/s/fmyeqa2
https://www.wenjuan.com/t/fmyeqa2
https://www.wenjuan.com/z/rqMNriX
https://www.wenjuan.com/d/rqMNriX
https://www.wenjuan.com/s/rqMNriX
https://www.wenjuan.com/t/rqMNriX
https://www.wenjuan.com/z/biQ7BfS
https://www.wenjuan.com/d/biQ7BfS
https://www.wenjuan.com/s/biQ7BfS
https://www.wenjuan.com/t/biQ7BfS
https://www.wenjuan.com/z/jIzmYrW
https://www.wenjuan.com/d/jIzmYrW
https://www.wenjuan.com/s/jIzmYrW
https://www.wenjuan.com/t/jIzmYrW
https://www.wenjuan.com/z/BZNfYzn
https://www.wenjuan.com/d/BZNfYzn
https://www.wenjuan.com/s/BZNfYzn
https://www.wenjuan.com/t/BZNfYzn
https://www.wenjuan.com/z/YRvYn2
https://www.wenjuan.com/d/YRvYn2
https://www.wenjuan.com/s/YRvYn2
https://www.wenjuan.com/t/YRvYn2
https://www.wenjuan.com/z/ZVbyEj
https://www.wenjuan.com/d/ZVbyEj
https://www.wenjuan.com/s/ZVbyEj
https://www.wenjuan.com/t/ZVbyEj
https://www.wenjuan.com/z/qmaa63x
https://www.wenjuan.com/d/qmaa63x
https://www.wenjuan.com/s/qmaa63x
https://www.wenjuan.com/t/qmaa63x
https://www.wenjuan.com/z/UfAnMvv
https://www.wenjuan.com/d/UfAnMvv
https://www.wenjuan.com/s/UfAnMvv
https://www.wenjuan.com/t/UfAnMvv
https://www.wenjuan.com/z/IRVZZz
https://www.wenjuan.com/d/IRVZZz
https://www.wenjuan.com/s/IRVZZz
https://www.wenjuan.com/t/IRVZZz
https://www.wenjuan.com/z/RV7zIbU
https://www.wenjuan.com/d/RV7zIbU
https://www.wenjuan.com/s/RV7zIbU
https://www.wenjuan.com/t/RV7zIbU
https://www.wenjuan.com/z/AvueMvl
https://www.wenjuan.com/d/AvueMvl
https://www.wenjuan.com/s/AvueMvl
https://www.wenjuan.com/t/AvueMvl
https://www.wenjuan.com/z/IBz6fuW
https://www.wenjuan.com/d/IBz6fuW
https://www.wenjuan.com/s/IBz6fuW
https://www.wenjuan.com/t/IBz6fuW
https://www.wenjuan.com/z/maUFNvF
https://www.wenjuan.com/d/maUFNvF
https://www.wenjuan.com/s/maUFNvF
https://www.wenjuan.com/t/maUFNvF
https://www.wenjuan.com/z/mmQv2ih
https://www.wenjuan.com/d/mmQv2ih
https://www.wenjuan.com/s/mmQv2ih
https://www.wenjuan.com/t/mmQv2ih
https://www.wenjuan.com/z/EFjQ3u
https://www.wenjuan.com/d/EFjQ3u
https://www.wenjuan.com/s/EFjQ3u
https://www.wenjuan.com/t/EFjQ3u
https://www.wenjuan.com/z/rAZjia
https://www.wenjuan.com/d/rAZjia
https://www.wenjuan.com/s/rAZjia
https://www.wenjuan.com/t/rAZjia
https://www.wenjuan.com/z/Qbei2mA
https://www.wenjuan.com/d/Qbei2mA
https://www.wenjuan.com/s/Qbei2mA
https://www.wenjuan.com/t/Qbei2mA
https://www.wenjuan.com/z/QFBjUrO
https://www.wenjuan.com/d/QFBjUrO
https://www.wenjuan.com/s/QFBjUrO
https://www.wenjuan.com/t/QFBjUrO
https://www.wenjuan.com/z/677fam7
https://www.wenjuan.com/d/677fam7
https://www.wenjuan.com/s/677fam7
https://www.wenjuan.com/t/677fam7
https://www.wenjuan.com/z/IVRfiy
https://www.wenjuan.com/d/IVRfiy
https://www.wenjuan.com/s/IVRfiy
https://www.wenjuan.com/t/IVRfiy
https://www.wenjuan.com/z/7jM3Qvx
https://www.wenjuan.com/d/7jM3Qvx
https://www.wenjuan.com/s/7jM3Qvx
https://www.wenjuan.com/t/7jM3Qvx
https://www.wenjuan.com/z/RrQfQrp
https://www.wenjuan.com/d/RrQfQrp
https://www.wenjuan.com/s/RrQfQrp
https://www.wenjuan.com/t/RrQfQrp
https://www.wenjuan.com/z/uyMfYj1
https://www.wenjuan.com/d/uyMfYj1
https://www.wenjuan.com/s/uyMfYj1
https://www.wenjuan.com/t/uyMfYj1
https://www.wenjuan.com/z/BNbE3m
https://www.wenjuan.com/d/BNbE3m
https://www.wenjuan.com/s/BNbE3m
https://www.wenjuan.com/t/BNbE3m
https://www.wenjuan.com/z/MnyAnu7
https://www.wenjuan.com/d/MnyAnu7
https://www.wenjuan.com/s/MnyAnu7
https://www.wenjuan.com/t/MnyAnu7
https://www.wenjuan.com/z/F7beUbV
https://www.wenjuan.com/d/F7beUbV
https://www.wenjuan.com/s/F7beUbV
https://www.wenjuan.com/t/F7beUbV
https://www.wenjuan.com/z/qAJBvql
https://www.wenjuan.com/d/qAJBvql
https://www.wenjuan.com/s/qAJBvql
https://www.wenjuan.com/t/qAJBvql
https://www.wenjuan.com/z/Nn2Qnic
https://www.wenjuan.com/d/Nn2Qnic
https://www.wenjuan.com/s/Nn2Qnic
https://www.wenjuan.com/t/Nn2Qnic
https://www.wenjuan.com/z/nEBvYv7
https://www.wenjuan.com/d/nEBvYv7
https://www.wenjuan.com/s/nEBvYv7
https://www.wenjuan.com/t/nEBvYv7
https://www.wenjuan.com/z/Z7FjYvv
https://www.wenjuan.com/d/Z7FjYvv
https://www.wenjuan.com/s/Z7FjYvv
https://www.wenjuan.com/t/Z7FjYvv
https://www.wenjuan.com/z/vuY7nyB
https://www.wenjuan.com/d/vuY7nyB
https://www.wenjuan.com/s/vuY7nyB
https://www.wenjuan.com/t/vuY7nyB
https://www.wenjuan.com/z/7ju2Aj1
https://www.wenjuan.com/d/7ju2Aj1
https://www.wenjuan.com/s/7ju2Aj1
https://www.wenjuan.com/t/7ju2Aj1
https://www.wenjuan.com/z/RNvueaL
https://www.wenjuan.com/d/RNvueaL
https://www.wenjuan.com/s/RNvueaL
https://www.wenjuan.com/t/RNvueaL
https://www.wenjuan.com/z/vaIjEbg
https://www.wenjuan.com/d/vaIjEbg
https://www.wenjuan.com/s/vaIjEbg
https://www.wenjuan.com/t/vaIjEbg
https://www.wenjuan.com/z/6zqayek
https://www.wenjuan.com/d/6zqayek
https://www.wenjuan.com/s/6zqayek
https://www.wenjuan.com/t/6zqayek
https://www.wenjuan.com/z/uiuAfqB
https://www.wenjuan.com/d/uiuAfqB
https://www.wenjuan.com/s/uiuAfqB
https://www.wenjuan.com/t/uiuAfqB
https://www.wenjuan.com/z/e2MNzyp
https://www.wenjuan.com/d/e2MNzyp
https://www.wenjuan.com/s/e2MNzyp
https://www.wenjuan.com/t/e2MNzyp
https://www.wenjuan.com/z/uqUnii
https://www.wenjuan.com/d/uqUnii
https://www.wenjuan.com/s/uqUnii
https://www.wenjuan.com/t/uqUnii
https://www.wenjuan.com/z/I3qiQvI
https://www.wenjuan.com/d/I3qiQvI
https://www.wenjuan.com/s/I3qiQvI
https://www.wenjuan.com/t/I3qiQvI
https://www.wenjuan.com/z/B7RBf2n
https://www.wenjuan.com/d/B7RBf2n
https://www.wenjuan.com/s/B7RBf2n
https://www.wenjuan.com/t/B7RBf2n
https://www.wenjuan.com/z/BBVfu2H
https://www.wenjuan.com/d/BBVfu2H
https://www.wenjuan.com/s/BBVfu2H
https://www.wenjuan.com/t/BBVfu2H
https://www.wenjuan.com/z/beyMveS
https://www.wenjuan.com/d/beyMveS
https://www.wenjuan.com/s/beyMveS
https://www.wenjuan.com/t/beyMveS
https://www.wenjuan.com/z/vqUfEjz
https://www.wenjuan.com/d/vqUfEjz
https://www.wenjuan.com/s/vqUfEjz
https://www.wenjuan.com/t/vqUfEjz
https://www.wenjuan.com/z/yuauU3Y
https://www.wenjuan.com/d/yuauU3Y
https://www.wenjuan.com/s/yuauU3Y
https://www.wenjuan.com/t/yuauU3Y
https://www.wenjuan.com/z/FneAfyI
https://www.wenjuan.com/d/FneAfyI
https://www.wenjuan.com/s/FneAfyI
https://www.wenjuan.com/t/FneAfyI
https://www.wenjuan.com/z/qY3Uvig
https://www.wenjuan.com/d/qY3Uvig
https://www.wenjuan.com/s/qY3Uvig
https://www.wenjuan.com/t/qY3Uvig
https://www.wenjuan.com/z/6f2E7z
https://www.wenjuan.com/d/6f2E7z
https://www.wenjuan.com/s/6f2E7z
https://www.wenjuan.com/t/6f2E7z
https://www.wenjuan.com/z/jy6rqed
https://www.wenjuan.com/d/jy6rqed
https://www.wenjuan.com/s/jy6rqed
https://www.wenjuan.com/t/jy6rqed
https://www.wenjuan.com/z/Nv2e2me
https://www.wenjuan.com/d/Nv2e2me
https://www.wenjuan.com/s/Nv2e2me
https://www.wenjuan.com/t/Nv2e2me
https://www.wenjuan.com/z/FbaAvma
https://www.wenjuan.com/d/FbaAvma
https://www.wenjuan.com/s/FbaAvma
https://www.wenjuan.com/t/FbaAvma
https://www.wenjuan.com/z/YzMzea0
https://www.wenjuan.com/d/YzMzea0
https://www.wenjuan.com/s/YzMzea0
https://www.wenjuan.com/t/YzMzea0
https://www.wenjuan.com/z/bmmQJr
https://www.wenjuan.com/d/bmmQJr
https://www.wenjuan.com/s/bmmQJr
https://www.wenjuan.com/t/bmmQJr
https://www.wenjuan.com/z/mM3eYzV
https://www.wenjuan.com/d/mM3eYzV
https://www.wenjuan.com/s/mM3eYzV
https://www.wenjuan.com/t/mM3eYzV
https://www.wenjuan.com/z/FFR7vak
https://www.wenjuan.com/d/FFR7vak
https://www.wenjuan.com/s/FFR7vak
https://www.wenjuan.com/t/FFR7vak
https://www.wenjuan.com/z/YvQVJzh
https://www.wenjuan.com/d/YvQVJzh
https://www.wenjuan.com/s/YvQVJzh
https://www.wenjuan.com/t/YvQVJzh
https://www.wenjuan.com/z/3aQFrug
https://www.wenjuan.com/d/3aQFrug
https://www.wenjuan.com/s/3aQFrug
https://www.wenjuan.com/t/3aQFrug
https://www.wenjuan.com/z/fmEZNft
https://www.wenjuan.com/d/fmEZNft
https://www.wenjuan.com/s/fmEZNft
https://www.wenjuan.com/t/fmEZNft
https://www.wenjuan.com/z/eQ7BFzw
https://www.wenjuan.com/d/eQ7BFzw
https://www.wenjuan.com/s/eQ7BFzw
https://www.wenjuan.com/t/eQ7BFzw
https://www.wenjuan.com/z/3Uv6zyc
https://www.wenjuan.com/d/3Uv6zyc
https://www.wenjuan.com/s/3Uv6zyc
https://www.wenjuan.com/t/3Uv6zyc
https://www.wenjuan.com/z/vau6fuy
https://www.wenjuan.com/d/vau6fuy
https://www.wenjuan.com/s/vau6fuy
https://www.wenjuan.com/t/vau6fuy
https://www.wenjuan.com/z/aMvUniE
https://www.wenjuan.com/d/aMvUniE
https://www.wenjuan.com/s/aMvUniE
https://www.wenjuan.com/t/aMvUniE
https://www.wenjuan.com/z/UnayMv8
https://www.wenjuan.com/d/UnayMv8
https://www.wenjuan.com/s/UnayMv8
https://www.wenjuan.com/t/UnayMv8
https://www.wenjuan.com/z/ARNZNnK
https://www.wenjuan.com/d/ARNZNnK
https://www.wenjuan.com/s/ARNZNnK
https://www.wenjuan.com/t/ARNZNnK
https://www.wenjuan.com/z/QneIFj5
https://www.wenjuan.com/d/QneIFj5
https://www.wenjuan.com/s/QneIFj5
https://www.wenjuan.com/t/QneIFj5
https://www.wenjuan.com/z/fENnqyP
https://www.wenjuan.com/d/fENnqyP
https://www.wenjuan.com/s/fENnqyP
https://www.wenjuan.com/t/fENnqyP
https://www.wenjuan.com/z/biqyMrQ
https://www.wenjuan.com/d/biqyMrQ
https://www.wenjuan.com/s/biqyMrQ
https://www.wenjuan.com/t/biqyMrQ
https://www.wenjuan.com/z/2INJZjp
https://www.wenjuan.com/d/2INJZjp
https://www.wenjuan.com/s/2INJZjp
https://www.wenjuan.com/t/2INJZjp
https://www.wenjuan.com/z/BFr6Rrs
https://www.wenjuan.com/d/BFr6Rrs
https://www.wenjuan.com/s/BFr6Rrs
https://www.wenjuan.com/t/BFr6Rrs
https://www.wenjuan.com/z/mAJNRju
https://www.wenjuan.com/d/mAJNRju
https://www.wenjuan.com/s/mAJNRju
https://www.wenjuan.com/t/mAJNRju
https://www.wenjuan.com/z/JrmUJzC
https://www.wenjuan.com/d/JrmUJzC
https://www.wenjuan.com/s/JrmUJzC
https://www.wenjuan.com/t/JrmUJzC
https://www.wenjuan.com/z/M3qA3e
https://www.wenjuan.com/d/M3qA3e
https://www.wenjuan.com/s/M3qA3e
https://www.wenjuan.com/t/M3qA3e
https://www.wenjuan.com/z/MFnqamR
https://www.wenjuan.com/d/MFnqamR
https://www.wenjuan.com/s/MFnqamR
https://www.wenjuan.com/t/MFnqamR
https://www.wenjuan.com/z/by6Fn2l
https://www.wenjuan.com/d/by6Fn2l
https://www.wenjuan.com/s/by6Fn2l
https://www.wenjuan.com/t/by6Fn2l
https://www.wenjuan.com/z/iUfu2am
https://www.wenjuan.com/d/iUfu2am
https://www.wenjuan.com/s/iUfu2am
https://www.wenjuan.com/t/iUfu2am
https://www.wenjuan.com/z/RNvaQnH
https://www.wenjuan.com/d/RNvaQnH
https://www.wenjuan.com/s/RNvaQnH
https://www.wenjuan.com/t/RNvaQnH
https://www.wenjuan.com/z/y26NRzS
https://www.wenjuan.com/d/y26NRzS
https://www.wenjuan.com/s/y26NRzS
https://www.wenjuan.com/t/y26NRzS
https://www.wenjuan.com/z/Z3AjMnG
https://www.wenjuan.com/d/Z3AjMnG
https://www.wenjuan.com/s/Z3AjMnG
https://www.wenjuan.com/t/Z3AjMnG
https://www.wenjuan.com/z/NJnea26
https://www.wenjuan.com/d/NJnea26
https://www.wenjuan.com/s/NJnea26
https://www.wenjuan.com/t/NJnea26
https://www.wenjuan.com/z/VrqUjem
https://www.wenjuan.com/d/VrqUjem
https://www.wenjuan.com/s/VrqUjem
https://www.wenjuan.com/t/VrqUjem
https://www.wenjuan.com/z/n6FFR3
https://www.wenjuan.com/d/n6FFR3
https://www.wenjuan.com/s/n6FFR3
https://www.wenjuan.com/t/n6FFR3
https://www.wenjuan.com/z/eiQB7zx
https://www.wenjuan.com/d/eiQB7zx
https://www.wenjuan.com/s/eiQB7zx
https://www.wenjuan.com/t/eiQB7zx
https://www.wenjuan.com/z/3Y7R73
https://www.wenjuan.com/d/3Y7R73
https://www.wenjuan.com/s/3Y7R73
https://blog.csdn.net/astala_vista/article/details/106688479
https://blog.csdn.net/astala_vista/article/details/106688594
https://blog.csdn.net/beifang01/article/details/106688826
https://blog.csdn.net/beifang01/article/details/106688977
https://blog.csdn.net/Hjskjd898/article/details/106689084
https://blog.csdn.net/Hjskjd898/article/details/106689112
https://blog.csdn.net/sinat_36220051/article/details/106689195
https://blog.csdn.net/sinat_36220051/article/details/106689220
https://blog.csdn.net/daiyun132/article/details/106689362
https://blog.csdn.net/daiyun132/article/details/106689405
https://blog.csdn.net/BHdream/article/details/106689587
https://blog.csdn.net/BHdream/article/details/106689721
https://blog.csdn.net/weixin_47220020/article/details/106689811
https://blog.csdn.net/weixin_47220020/article/details/106689864
https://blog.csdn.net/kldsifbwasfsa0/article/details/106690061
https://blog.csdn.net/kldsifbwasfsa0/article/details/106690079
https://blog.csdn.net/u011466227/article/details/106690270
https://blog.csdn.net/u011466227/article/details/106690314
https://blog.csdn.net/winterBaba/article/details/106690416
https://blog.csdn.net/winterBaba/article/details/106690547
https://blog.csdn.net/mark1122/article/details/106690675
https://blog.csdn.net/mark1122/article/details/106690693
https://blog.csdn.net/weixin_47927365/article/details/106691062
https://blog.csdn.net/weixin_47927365/article/details/106691098
https://blog.csdn.net/u012300832/article/details/106691284
https://blog.csdn.net/u012300832/article/details/106691501
https://blog.csdn.net/hesperis/article/details/106691659

https://www.wenjuan.com/t/3Y7R73
https://www.wenjuan.com/z/NfEFbu
https://www.wenjuan.com/d/NfEFbu
https://www.wenjuan.com/s/NfEFbu
https://www.wenjuan.com/t/NfEFbu
https://www.wenjuan.com/z/UFreaaE
https://www.wenjuan.com/d/UFreaaE
https://www.wenjuan.com/s/UFreaaE
https://www.wenjuan.com/t/UFreaaE
https://www.wenjuan.com/z/3iyIZra
https://www.wenjuan.com/d/3iyIZra
https://www.wenjuan.com/s/3iyIZra
https://www.wenjuan.com/t/3iyIZra
https://www.wenjuan.com/z/iiE7fm6
https://www.wenjuan.com/d/iiE7fm6
https://www.wenjuan.com/s/iiE7fm6
https://www.wenjuan.com/t/iiE7fm6
https://www.wenjuan.com/z/UVjYvyA
https://www.wenjuan.com/d/UVjYvyA
https://www.wenjuan.com/s/UVjYvyA
https://www.wenjuan.com/t/UVjYvyA
https://www.wenjuan.com/z/ZNRFVbj
https://www.wenjuan.com/d/ZNRFVbj
https://www.wenjuan.com/s/ZNRFVbj
https://www.wenjuan.com/t/ZNRFVbj
https://www.wenjuan.com/z/yEZvQj
https://www.wenjuan.com/d/yEZvQj
https://www.wenjuan.com/s/yEZvQj
https://www.wenjuan.com/t/yEZvQj
https://www.wenjuan.com/z/qEbaUzc
https://www.wenjuan.com/d/qEbaUzc
https://www.wenjuan.com/s/qEbaUzc
https://www.wenjuan.com/t/qEbaUzc
https://www.wenjuan.com/z/6BJZVvf
https://www.wenjuan.com/d/6BJZVvf
https://www.wenjuan.com/s/6BJZVvf
https://www.wenjuan.com/t/6BJZVvf
https://www.wenjuan.com/z/BfInei6
https://www.wenjuan.com/d/BfInei6
https://www.wenjuan.com/s/BfInei6
https://www.wenjuan.com/t/BfInei6

爆炸;sslmode=disable不起作用;

爆炸;sslmode=allow;不起作用;

投降投降.放弃挣扎;请教领导,领导说这个sslmode应该和ssl底层的验证机制匹配的,文档讲的定义不是很准确;让我用sslmode=requir配置再搞一次;

不得不佩服;

解决方式:

在jdbc连接代码的url后增加sslmode=requir;

like this

connUrl = “jdbc:postgresql://” + dsIp + “:” + dsPort + “/” + dsName + “?sslmode=require”;

问题虽然解决,但是无法探究服务端的配置和客户端sslmode的关系和影响;这波很亏;

长城不独埋剑骨,吾辈书生亦有拳

hesperis
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
CodeSmith8.0.1连接PostgreSQL报错问题解决
10-11
CodeSmith8.0.1连接PostgreSQL会报错，缺少对应的Npgsql.dll，文件中包含3个DLL和使用说明，以及给出PostgreSQL的连接字符串示例，本人亲测有效。
navicat 连接PostgreSQL报错
08-11
navicat 连接PostgreSQL报错：ERROR: SSL connection is required by the database system
PostgreSQL-JDBC-驱动加载-初始化
最新发布
Java程序员的知识博客
02-05 1889
除非不使用标准的PostgreSQL™ JDBC API扩展，否则不应导入org.postgresql包。
Navicat连接postgreSQL 报错error：column找不到，亲测是Navicat版本不够，下载12版本有用-附件资源
03-02
Navicat连接postgreSQL 报错error：column找不到，亲测是Navicat版本不够，下载12版本有用-附件资源
Java使用JDBC连接postgresql数据库示例
08-26
主要介绍了Java使用JDBC连接postgresql数据库,结合实例形式分析了jdbc连接postgresql数据库及数值插入、更新、查询等相关操作技巧,需要的朋友可以参考下
WindowsXP 安装 PostgreSQL 8.4.2 数据库
xiahouchunhong的博客
09-26 136
在软件行业，软件工程师们只要谈起免费数据库，很多程序员首先想到的肯定就是MySQL了，的确MySQL目前已经应用在全球的很多领域中，尤其是网站架设方面。但是，实际上功能最强大、特性最丰富和最复杂的免费数据库应该是PostgreSQL。它的很多特性正是当今许多商业数据库例如Oracle、DB2等的前身。 作为程序员，了解新知识，拓宽新领域，很有必要多多学习。我就研究了一点PostgreSQ...
jdbc连接Postgresql出错
Smoozer的博客
07-13 4589
错误信息：org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres" 用jdbc连接Postgresql数据库时经常出现这个错误，然而用pgAdmin 3是可以正确连接 的，表明用户名和密码都是正确的。     这主要是由于用户密码认证方式引起的，Postgres
JDBC 连接 PostgreSQL
m0_50163856的博客
09-13 4561
驱动依赖 org.postgresql postgresql 42.2.19 JDBC操作 Class.forName("org.postgresql.Driver"); String url = "jdbc:postgresql://172.18.9.114:5432/postgres"; String username = "pgdba"; String password = "pgdba"; //在表spatial_ref_sys中，从第1开始，回去10条数据 String
数据库链接报错init datasource error, url:.....
weixin_43803387的博客
10-13 1万+
init datasource error, url:.....数据库链接报错
init datasource error, url: jdbc:mysql://localhost:3306/test 解决办法
段占彪的博客
12-13 1万+
问题描述 今天启动项目突然抛出如下错误信息： [16:14:32.735][ERROR][com.alibaba.druid.pool.DruidDataSource][main] init datasource error, url: jdbc:mysql://localhost:3306/test com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet sen
解决jdbc连接数据库ssl报错问题
hjh2025hzkjdxkyb的博客
08-10 234
在连接的数据库名字后添加?useSSL=false即可。
org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"
热门推荐
好巧~我看到你了
05-10 2万+
在写这个的时候遇到这个异常，首先说明这个不是你的sql代码错误，这是一个简单的转化问题 org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" 位置：1025 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExec...
Jmeter 4.0连接postgresql数据库
louniuous的博客
10-21 2731
网上很多Jmeter连接postgresql数据的资料，大多是2.0和3.0的。这里是4.0的。因为是自己一步步从坑里迈出来的内容会比较详细。适合新手学习。 1、Jmeter连接postgresql数据库是需要jar包的。而且该包的版本与JDK的版本要对应。注意不是与Jmeter的版本对应。三者对应关系如下： Jmeter JDK postgresql驱动包 postgres...
Java导入shapefile到postgis,提升geotools导入效率
XiaoCai
02-24 2640
使用Java导入shapefile到postgis中，小菜一般采用geotools的方式导入。 代码如下： /** * @author xiaocai * @DescInfo * @创建时间：2020/11/24 * @类职责描述：Shapefile文件 **/ public class DataItemShapefile{ public DataItemShapefile() { } @Override public boolean inputData2Da
Hive集成关系型数据库（MySQL、PostgreSQL）
L
09-29 3032
本文主要目的是基于HDP2.6.3集群，搭建Hive与PostgreSQL数据库集成，以便能够在Hive中直接对PostgreSQL进行较为复杂的查询，比如条件查询，查询排序，分组统计查询，模糊查询，关联查询等。为了更好的完成最终集成环境搭建，做了一些其他有益的集成测试，比如基于hive-jdbc-handler-2.3.6.jar版本集成MySQL数据库等。 H...
漏洞修复系列-如何升级linux系统Upgrade to PostgreSQL JDBC Driver version 42.2.27, 42.3.8, 42.4.3, 42.5.1, or late
tangdou369098655的博客
09-23 814
PostgreSQL JDBC Driver that is 42.2.x prior to 42.2.27, 42.3.x prior to 42.3.8, 42.4.x prior to 42.4.3 or 42.5.x prior to 42.5.1. It is, therefore, affected by an information disclosure vulnerability.
java与pgsql_jdbc连接java和postgresql出错解决办法
weixin_39990250的博客
02-26 1787
jdbc连接java和postgresql出错我从官方下得驱动postgresql-8.1-408.jdbc3.jar,我选得对应得版本(eclipse3.2+pgsql8.1)然后j2sdk路径设置都正确,我把驱动放在%JAVA_HOME%/bin中,为了防止找不到我又把驱动copy到%JAVA_HOME%/jre/lib/ext中.然后运行代码:import java.lang.*;imp...
JDBC连接PostgreSQL数据库的若干问题
给永远比拿愉快
09-17 7812
首先给出一个示例：
jdbc postgresql mysql_jdbc无法连接postgresql数据库
weixin_31992501的博客
01-28 1173
使用jdbc连接postgresql数据库时报错如下：org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:### Error querying database. Cause: org.springframework.jdb...
PostgreSQL [ERROR: invalid byte sequence for encoding
06-09
你可以尝试通过执行以下命令来更改PostgreSQL的编码格式： ``` ALTER DATABASE your_database_name SET client_encoding TO 'utf8'; ``` 注意，这将更改整个数据库的编码格式，因此你需要谨慎操作。如果你只想...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值