can't connect with dbeaver postgres - can connect with psql

[joshuascottpaul]

can't connect with dbeaver postgres - can connect with psql

dbeaver config: localhost, 5432, nc_timebilling.db

error:
can't connect with dbeaver postgres - no databases found on the server

works:
$ psql --host localhost nc_timebilling.db

[benbjohnson]

Thanks for the bug report. Do you see any activity in the postlite log?

[joshuascottpaul]

when i connect with psql
$ psql --host localhost nc_timebilling.db
psql (14.2, server 13.0.0)
Type "help" for help.

nc_timebilling.db=>

$ postlite -data-dir /Users/jpaul/Desktop
listening on :5432
connection accepted: 127.0.0.1:53331
received ssl request message: &pgproto3.SSLRequest{}
received startup message: &pgproto3.StartupMessage{ProtocolVersion:0x30000, Parameters:map[string]string{"application_name":"psql", "client_encoding":"UTF8", "database":"nc_timebilling.db", "user":"jpaul"}}

when i connect with dbeaver

$ postlite -data-dir /Users/jpaul/Desktop
listening on :5432
connection accepted: 127.0.0.1:53313
received ssl request message: &pgproto3.SSLRequest{}
received startup message: &pgproto3.StartupMessage{ProtocolVersion:0x30000, Parameters:map[string]string{"DateStyle":"ISO", "TimeZone":"America/Vancouver", "client_encoding":"UTF8", "database":"nc_timebilling.db", "extra_float_digits":"2", "user":"jpaul"}}
[recv] &pgproto3.Parse{Name:"", Query:"SET extra_float_digits = 3", ParameterOIDs:[]uint32(nil)}
query rewrite: SELECT 'SET'
[recv(p)] &pgproto3.Bind{DestinationPortal:"", PreparedStatement:"", ParameterFormatCodes:[]int16(nil), Parameters:[][]uint8(nil), ResultFormatCodes:[]int16{}}
[recv(p)] &pgproto3.Execute{Portal:"", MaxRows:0x1}
[recv] &pgproto3.Sync{}
[recv] &pgproto3.Parse{Name:"", Query:"SET application_name = 'PostgreSQL JDBC Driver'", ParameterOIDs:[]uint32(nil)}
query rewrite: SELECT 'SET'
[recv(p)] &pgproto3.Bind{DestinationPortal:"", PreparedStatement:"", ParameterFormatCodes:[]int16(nil), Parameters:[][]uint8(nil), ResultFormatCodes:[]int16{}}
[recv(p)] &pgproto3.Execute{Portal:"", MaxRows:0x1}
[recv] &pgproto3.Sync{}
[recv] &pgproto3.Parse{Name:"", Query:"SET application_name = 'DBeaver 22.0.2 - Read PostgreSQL database list'", ParameterOIDs:[]uint32(nil)}
query rewrite: SELECT 'SET'
[recv(p)] &pgproto3.Bind{DestinationPortal:"", PreparedStatement:"", ParameterFormatCodes:[]int16(nil), Parameters:[][]uint8(nil), ResultFormatCodes:[]int16{}}
[recv(p)] &pgproto3.Execute{Portal:"", MaxRows:0x1}
[recv] &pgproto3.Sync{}
[recv] &pgproto3.Parse{Name:"", Query:"SELECT db.oid,db.* FROM pg_catalog.pg_database db WHERE 1 = 1 AND datallowconn AND NOT datistemplate OR db.datname =$1\nORDER BY db.datname", ParameterOIDs:[]uint32{0x413}}
[recv(p)] &pgproto3.Bind{DestinationPortal:"", PreparedStatement:"", ParameterFormatCodes:[]int16{0}, Parameters:[][]uint8{[]uint8{0x6e, 0x63, 0x5f, 0x74, 0x69, 0x6d, 0x65, 0x62, 0x69, 0x6c, 0x6c, 0x69, 0x6e, 0x67, 0x2e, 0x64, 0x62}}, ResultFormatCodes:[]int16{}}
[recv(p)] &pgproto3.Describe{ObjectType:0x50, Name:""}
[recv(p)] &pgproto3.Execute{Portal:"", MaxRows:0x0}
[recv] &pgproto3.Sync{}
[recv] &pgproto3.Terminate{}
connection closed: 127.0.0.1:53313
^CSIGINT received, shutting down
accept tcp [::]:5432: use of closed network connection