Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Connecting to server waited endlessly #22

Open
chang-chao opened this issue Apr 22, 2016 · 2 comments
Open

Connecting to server waited endlessly #22

chang-chao opened this issue Apr 22, 2016 · 2 comments
Assignees

Comments

@chang-chao
Copy link

I'm running com.github.pgasync.impl.AuthenticationTest.shouldThrowExceptionOnInvalidCredentials()
junit test on the master,with minor changes of the host to a remote server (posgresql 8.4) in my LAN .
and the test freezes waiting for something.

Please see the attached packet capture.

capture.zip

@alaisi alaisi self-assigned this Apr 22, 2016
@chang-chao
Copy link
Author

It seemes that it has something to do with the implementation of
com.github.pgasync.impl.DatabaseRule.createPoolBuilder(int),which set the ssl property to true.When ssl is set to false,the test passed.

@chang-chao
Copy link
Author

chang-chao commented Apr 22, 2016

This is output of pg_config,which says that when postgresql is compiled,ssl is not enabled.
Which means that postgres is compiled without the ssl enabled but ssl property of ConnectionPoolBuilder is set to true in the client by mistake,connecting to db can last for a long time without any error.

C:\Program Files\PostgreSQL\9.4\bin>pg_config.exe
BINDIR = C:/PROGRA~1/POSTGR~1/9.4/bin
DOCDIR = C:/PROGRA~1/POSTGR~1/9.4/doc
HTMLDIR = C:/PROGRA~1/POSTGR~1/9.4/doc
INCLUDEDIR = C:/PROGRA~1/POSTGR~1/9.4/include
PKGINCLUDEDIR = C:/PROGRA~1/POSTGR~1/9.4/include
INCLUDEDIR-SERVER = C:/PROGRA~1/POSTGR~1/9.4/include/server
LIBDIR = C:/PROGRA~1/POSTGR~1/9.4/lib
PKGLIBDIR = C:/PROGRA~1/POSTGR~1/9.4/lib
LOCALEDIR = C:/PROGRA~1/POSTGR~1/9.4/share/locale
MANDIR = C:/Program Files/PostgreSQL/9.4/man
SHAREDIR = C:/PROGRA~1/POSTGR~1/9.4/share
SYSCONFDIR = C:/Program Files/PostgreSQL/9.4/etc
PGXS = C:/Program Files/PostgreSQL/9.4/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = --enable-thread-safety --enable-integer-datetimes --enable-nls --with-ldap --with-ossp-uuid --with-libxml --with-libxslt --with-tcl --with-perl --with-python
VERSION = PostgreSQL 9.4.5

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants