search

FusionAuth / fusionauth-issues

FusionAuth issue submission project
https://fusionauth.io
90 stars 12 forks source link

Silent Mode fails trying to make database with user having dash in name #2644

Open JoshTheHero opened 4 months ago

JoshTheHero commented 4 months ago

Silent Mode fails trying to make database with user having dash in name

Description

When Silent Mode in Fusion Auth tries to create a database, if the user name has a dash in it it will throw an error about the '-'.

Observed versions

1.48.3

Steps to reproduce

  1. Create database user in FusionAuth config with "-", ala admin-fusionauth
  2. Enable Silent Mode
  3. Run FusionAuth without a database so Silent Mode will create one

Expected behavior

Silent Mode should be able to handle a user despite the dash when having to make a database.

Community guidelines

All issues filed in this repository must abide by the FusionAuth community guidelines.

Additional context

Assuming the script Silent Mode follows to make a database has issues with some special characters.

2024-01-29T02:22:01.000+00:00 2024-01-29 02:22:01 UTC:10.30.50.79(60664):admin-fusionauth@fusionauth:[9910]:DETAIL: Key (typname, typnamespace)=(test_create_table, 2200) already exists.

2024-01-29T02:22:01.000+00:00 2024-01-29 02:22:01 UTC:10.30.50.79(60664):admin-fusionauth@fusionauth:[9910]:STATEMENT: CREATE TABLE test_create_table(id INT)

2024-01-29T02:22:01.000+00:00 2024-01-29 02:22:01 UTC:10.30.50.79(60676):admin-fusionauth@postgres:[9915]:ERROR: syntax error at or near "-" at character 12