Admin's creds not working with backend on Postgresql

[Sarevok933219]

Hello. I'm using and testing V2 version. Trying to config with Postgres DB as backend. My config.yaml:

advanced:
  log_level: trace
  log_pretty: true
  use_ip_v6: false
core:
  listeningAddress: :8123
  externalUrl: http://localhost:8123
  admin_user: [email protected]
  admin_password: <supersecretkey>
  config_storage_path: /etc/wireguard
  import_existing: true

database:
  type: postgres
  dsn: host=postgres user=<admin> password=<superkey>a dbname=wireguard port=5432 sslmode=disable TimeZone=<localZone>
  debug: true
web:
  site_company_name: WIREGUARD VPN
  external_url: http://localhost:8123
  listening_address: :8123
  request_logging: true

auth:
  callback_url_prefix: http://localhost:8123/api/v0

Container is running up. Connection with PSQL is ok. I see tables and some information in them. My supers user is also present in dp. But then I try to start UI I get an errors:

...and can't login with my creds.

Where may be mistake? Please help.

[Sarevok93219]

The Errors Backend Connection Failure are gone (change config file: external_url: http://my_ext_ip:8123), but still can't be authorized by my admin's creds.

[viktor-zharikov]

i have that problem, and found some solve, if you use
externalUrl: http://localhost:8123 in config, you must use http://localhost:8123 in browser, NOT 127.0.0.1:8123

[Sarevok93219]

i have that problem, and found some solve, if you use externalUrl: http://localhost:8123 in config, you must use http://localhost:8123 in browser, NOT 127.0.0.1:8123

Thx. I use http://127.0.0.1:8123 in my yml file. I tried to use http://localhost:8123 instead, but it didn't help. I still can't log in. Please if You can, give me config file and what is under key auth. I don't quite understand what should be here.

auth:
  callback_url_prefix: http://127.0.0.1:8123/api/v0

my config file looks like:

advanced:
  log_level: trace
  log_pretty: true
  log_json: true
  use_ip_v6: false
  config_storage_path: /etc/wireguard

core:
  admin_user: [email protected]
  admin_password: <supersecretkey>
  import_existing: true
  self_provisioning_allowed: true

database:
  #type: sqlite
  #dsn: /app/data/keys.db
  # debug: true
  type: postgres
  dsn: host=postgres user=admin password=<admin's pass> dbname=wireguard port=5432 sslmode=disable TimeZone=Europe/Moscow
  debug: true

web:
  site_company_name: WIREGUARD VPN MYCOMPANYNAME
  external_url: http://localhost:8123
  #external_url: http://127.0.0.1:8123
  listening_address: :8123
  request_logging: true

auth:
  callback_url_prefix: http://localhost:8123/api/v0
  #callback_url_prefix: http://127.0.0.1:8123/api/v0
  #callback_url_prefix: /api/v0

[viktor-zharikov]

i have that problem, and found some solve, if you use externalUrl: http://localhost:8123 in config, you must use http://localhost:8123 in browser, NOT 127.0.0.1:8123

Thx. I use http://127.0.0.1:8123 in my yml file. I tried to use http://localhost:8123 instead, but it didn't help. I still can't log in. Please if You can, give me config file and what is under key auth. I don't quite understand what should be here.

auth:
  callback_url_prefix: http://127.0.0.1:8123/api/v0

my config file looks like:

advanced:
  log_level: trace
  log_pretty: true
  log_json: true
  use_ip_v6: false
  config_storage_path: /etc/wireguard

core:
  admin_user: [email protected]
  admin_password: <supersecretkey>
  import_existing: true
  self_provisioning_allowed: true

database:
  #type: sqlite
  #dsn: /app/data/keys.db
  # debug: true
  type: postgres
  dsn: host=postgres user=admin password=<admin's pass> dbname=wireguard port=5432 sslmode=disable TimeZone=Europe/Moscow
  debug: true

web:
  site_company_name: WIREGUARD VPN MYCOMPANYNAME
  external_url: http://localhost:8123
  #external_url: http://127.0.0.1:8123
  listening_address: :8123
  request_logging: true

auth:
  callback_url_prefix: http://localhost:8123/api/v0
  #callback_url_prefix: http://127.0.0.1:8123/api/v0
  #callback_url_prefix: /api/v0

In you example config 'external_url: http://localhost:8123' and 'callback_url_prefix: http://127.0.0.1:8123/api/v0' is different, make all url in one style, at first try to localhost, and use "Ctrl + Shift + I opens the developer tools for the browser" network tab

[Sarevok93219]

i have that problem, and found some solve, if you use externalUrl: http://localhost:8123 in config, you must use http://localhost:8123 in browser, NOT 127.0.0.1:8123

Thx. I use http://127.0.0.1:8123 in my yml file. I tried to use http://localhost:8123 instead, but it didn't help. I still can't log in. Please if You can, give me config file and what is under key auth. I don't quite understand what should be here.

auth:
  callback_url_prefix: http://127.0.0.1:8123/api/v0

my config file looks like:

advanced:
  log_level: trace
  log_pretty: true
  log_json: true
  use_ip_v6: false
  config_storage_path: /etc/wireguard

core:
  admin_user: [email protected]
  admin_password: <supersecretkey>
  import_existing: true
  self_provisioning_allowed: true

database:
  #type: sqlite
  #dsn: /app/data/keys.db
  # debug: true
  type: postgres
  dsn: host=postgres user=admin password=<admin's pass> dbname=wireguard port=5432 sslmode=disable TimeZone=Europe/Moscow
  debug: true

web:
  site_company_name: WIREGUARD VPN MYCOMPANYNAME
  external_url: http://localhost:8123
  #external_url: http://127.0.0.1:8123
  listening_address: :8123
  request_logging: true

auth:
  callback_url_prefix: http://localhost:8123/api/v0
  #callback_url_prefix: http://127.0.0.1:8123/api/v0
  #callback_url_prefix: /api/v0

In you example config 'external_url: http://localhost:8123' and 'callback_url_prefix: http://127.0.0.1:8123/api/v0' is different, make all url in one style, at first try to localhost, and use "Ctrl + Shift + I opens the developer tools for the browser" network tab

I'm not sure, but may be something wrong when interacting with backend (postgres DB)

[viktor-zharikov]

i have that problem, and found some solve, if you use externalUrl: http://localhost:8123 in config, you must use http://localhost:8123 in browser, NOT 127.0.0.1:8123

Thx. I use http://127.0.0.1:8123 in my yml file. I tried to use http://localhost:8123 instead, but it didn't help. I still can't log in. Please if You can, give me config file and what is under key auth. I don't quite understand what should be here.

auth:
  callback_url_prefix: http://127.0.0.1:8123/api/v0

my config file looks like:

advanced:
  log_level: trace
  log_pretty: true
  log_json: true
  use_ip_v6: false
  config_storage_path: /etc/wireguard

core:
  admin_user: [email protected]
  admin_password: <supersecretkey>
  import_existing: true
  self_provisioning_allowed: true

database:
  #type: sqlite
  #dsn: /app/data/keys.db
  # debug: true
  type: postgres
  dsn: host=postgres user=admin password=<admin's pass> dbname=wireguard port=5432 sslmode=disable TimeZone=Europe/Moscow
  debug: true

web:
  site_company_name: WIREGUARD VPN MYCOMPANYNAME
  external_url: http://localhost:8123
  #external_url: http://127.0.0.1:8123
  listening_address: :8123
  request_logging: true

auth:
  callback_url_prefix: http://localhost:8123/api/v0
  #callback_url_prefix: http://127.0.0.1:8123/api/v0
  #callback_url_prefix: /api/v0

In you example config 'external_url: http://localhost:8123' and 'callback_url_prefix: http://127.0.0.1:8123/api/v0' is different, make all url in one style, at first try to localhost, and use "Ctrl + Shift + I opens the developer tools for the browser" network tab

I'm not sure, but may be something wrong when interacting with backend (postgres DB)

Try to up wg with default config file, db, credentials, i am sure it's work

[Sarevok93219]

i have that problem, and found some solve, if you use externalUrl: http://localhost:8123 in config, you must use http://localhost:8123 in browser, NOT 127.0.0.1:8123

Thx. I use http://127.0.0.1:8123 in my yml file. I tried to use http://localhost:8123 instead, but it didn't help. I still can't log in. Please if You can, give me config file and what is under key auth. I don't quite understand what should be here.

auth:
  callback_url_prefix: http://127.0.0.1:8123/api/v0

my config file looks like:

advanced:
  log_level: trace
  log_pretty: true
  log_json: true
  use_ip_v6: false
  config_storage_path: /etc/wireguard

core:
  admin_user: [email protected]
  admin_password: <supersecretkey>
  import_existing: true
  self_provisioning_allowed: true

database:
  #type: sqlite
  #dsn: /app/data/keys.db
  # debug: true
  type: postgres
  dsn: host=postgres user=admin password=<admin's pass> dbname=wireguard port=5432 sslmode=disable TimeZone=Europe/Moscow
  debug: true

web:
  site_company_name: WIREGUARD VPN MYCOMPANYNAME
  external_url: http://localhost:8123
  #external_url: http://127.0.0.1:8123
  listening_address: :8123
  request_logging: true

auth:
  callback_url_prefix: http://localhost:8123/api/v0
  #callback_url_prefix: http://127.0.0.1:8123/api/v0
  #callback_url_prefix: /api/v0

In you example config 'external_url: http://localhost:8123' and 'callback_url_prefix: http://127.0.0.1:8123/api/v0' is different, make all url in one style, at first try to localhost, and use "Ctrl + Shift + I opens the developer tools for the browser" network tab

I'm not sure, but may be something wrong when interacting with backend (postgres DB)

Try to up wg with default config file, db, credentials, i am sure it's work

The task is using this product with ability to work with postgres. I have already tested V1. It works fine with MySQL backend. I don't know why v2 has such problem. I saw here another issue with similar case (may be testing version contains bugs). #198 and it is still has status "opened".

[Sarevok93219]

i have that problem, and found some solve, if you use externalUrl: http://localhost:8123 in config, you must use http://localhost:8123 in browser, NOT 127.0.0.1:8123

Thx. I use http://127.0.0.1:8123 in my yml file. I tried to use http://localhost:8123 instead, but it didn't help. I still can't log in. Please if You can, give me config file and what is under key auth. I don't quite understand what should be here.

auth:
  callback_url_prefix: http://127.0.0.1:8123/api/v0

my config file looks like:

advanced:
  log_level: trace
  log_pretty: true
  log_json: true
  use_ip_v6: false
  config_storage_path: /etc/wireguard

core:
  admin_user: [email protected]
  admin_password: <supersecretkey>
  import_existing: true
  self_provisioning_allowed: true

database:
  #type: sqlite
  #dsn: /app/data/keys.db
  # debug: true
  type: postgres
  dsn: host=postgres user=admin password=<admin's pass> dbname=wireguard port=5432 sslmode=disable TimeZone=Europe/Moscow
  debug: true

web:
  site_company_name: WIREGUARD VPN MYCOMPANYNAME
  external_url: http://localhost:8123
  #external_url: http://127.0.0.1:8123
  listening_address: :8123
  request_logging: true

auth:
  callback_url_prefix: http://localhost:8123/api/v0
  #callback_url_prefix: http://127.0.0.1:8123/api/v0
  #callback_url_prefix: /api/v0

In you example config 'external_url: http://localhost:8123' and 'callback_url_prefix: http://127.0.0.1:8123/api/v0' is different, make all url in one style, at first try to localhost, and use "Ctrl + Shift + I opens the developer tools for the browser" network tab

I'm not sure, but may be something wrong when interacting with backend (postgres DB)

Try to up wg with default config file, db, credentials, i am sure it's work

The task is using this product with ability to work with postgres. I have already tested V1. It works fine with MySQL backend. I don't know why v2 has such problem. I saw here another issue with similar case (may be testing version contains bugs). #198 and it is still has status "opened".

And You are right, if changing to default db everything is ok!!!

[h44z]

should be fixed by #231