immudb icon indicating copy to clipboard operation
immudb copied to clipboard

postgresql connot be connected

Open amrosdevops opened this issue 2 years ago • 1 comments

I am trying to connect postgresql port 5432 using pgAdmin/DBeaver but not connected I got this error in pgAdmin

**'ServerManager' object has no attribute 'user_info'**

The server is running successfully with default values

immudb-v1.2.2-windows-amd64.exe
 _                               _ _
(_)                             | | |
 _ _ __ ___  _ __ ___  _   _  __| | |__
| | '_ ` _ \| '_ ` _ \| | | |/ _` | '_ \
| | | | | | | | | | | | |_| | (_| | |_) |
|_|_| |_| |_|_| |_| |_|\__,_|\__,_|_.__/

immudb 1.2.2
Commit  : 89c3e3e8a4293909421d23025d7a26bb04b35a5e
Built by: [email protected]
Built at: Tue, 18 Jan 2022 17:27:58 +03
================ Config ================
Data dir         : ./data
Address          : 0.0.0.0:3322
Metrics address  : 0.0.0.0:9497/metrics
Config file      : configs/immudb.toml
Max recv msg size: 33554432
Auth enabled     : true
Dev mode         : false
Default database : defaultdb
Maintenance mode : false
Synced mode      : true
----------------------------------------
Superadmin default credentials
   Username      : immudb
   Password      : immudb
========================================

immudb  2022/03/21 11:22:44 INFO: Opening database 'systemdb' {replica = false}...
immudb  2022/03/21 11:22:44 INFO: Reading snapshot at 'data\systemdb\index\commit'...
immudb  2022/03/21 11:22:44 INFO: Successfully read snapshot at 'data\systemdb\index\commit'
immudb  2022/03/21 11:22:44 INFO: Indexing in progress at 'data\systemdb'
immudb  2022/03/21 11:22:44 INFO: Binary Linking up to date at 'data\systemdb'
immudb  2022/03/21 11:22:44 INFO: Database 'systemdb' {replica = false} successfully opened
immudb  2022/03/21 11:22:44 INFO: Loading SQL Engine for database 'systemdb' {replica = false}...
immudb  2022/03/21 11:22:44 INFO: Opening database 'defaultdb' {replica = false}...
immudb  2022/03/21 11:22:44 INFO: Flushing index 'data\systemdb\index'...
immudb  2022/03/21 11:22:44 INFO: Flushing not needed at 'data\systemdb\index'
immudb  2022/03/21 11:22:44 INFO: SQL Engine ready for database 'systemdb' {replica = false}
immudb  2022/03/21 11:22:44 INFO: Reading snapshot at 'data\defaultdb\index\commit'...
immudb  2022/03/21 11:22:44 INFO: Successfully read snapshot at 'data\defaultdb\index\commit'
immudb  2022/03/21 11:22:44 INFO: Indexing in progress at 'data\defaultdb'
immudb  2022/03/21 11:22:44 INFO: Binary Linking up to date at 'data\defaultdb'
immudb  2022/03/21 11:22:44 INFO: Database 'defaultdb' {replica = false} successfully opened
immudb  2022/03/21 11:22:44 INFO: Loading SQL Engine for database 'defaultdb' {replica = false}...
immudb  2022/03/21 11:22:44 INFO: Flushing index 'data\defaultdb\index'...
immudb  2022/03/21 11:22:44 INFO: Flushing not needed at 'data\defaultdb\index'
immudb  2022/03/21 11:22:44 INFO: pgsl server is running at port 5432
immudb  2022/03/21 11:22:44 INFO: SQL Engine ready for database 'defaultdb' {replica = false}
immudb  2022/03/21 11:22:44 INFO: Webconsole enabled: 0.0.0.0:8080
immudb  2022/03/21 11:22:44 INFO: Web API server enabled on 0.0.0.0:8080/api (http)
You can now use immuadmin and immuclient CLIs to login with the immudb superadmin user and start using immudb.

note the psql from CLI is connecting succesfully

could you help me to get success connection from pgAdmin or DBeaver

amrosdevops avatar Mar 21 '22 08:03 amrosdevops

Hi @amrosdevops, at the moment connection over pgsql wire protocol is limited to queries that are not involving catalog or internal data (like user_info in your case). More work is needed here in order to expose catalog and increase immudb integration capability with third party software

mmeloni avatar Mar 22 '22 11:03 mmeloni