search

antedebaas / Viesti-Reports

DMARC & SMTP-TLS Reports processor and visualizer and BIMI file hoster
https://docs.viestireports.com/
GNU Affero General Public License v3.0
82 stars 16 forks source link

Setup process requires creation of admin user - NOT Working #89

Closed wege2003 closed 6 months ago

wege2003 commented 6 months ago

Hi everyone,

in the setup process the admin user is asked to create, but this does not work in the current version, you are always redirected to the error page after the creation. But the user isnt in the database also. Can you fix this or how can I access the application logs?

Screenshot: image

Screenshot 2: image

Thanks, Greets Michael

wege2003 commented 6 months ago

It seems to be something with the database, because when i create manually the user it shows up in the db with the correct id. Screenshot: image

But in the setup process it can create my user:

2024-05-08 19:26:08.751 UTC [441] ERROR:  null value in column "id" of relation "users" violates not-null constraint
2024-05-08 19:26:08.751 UTC [441] DETAIL:  Failing row contains (null, __redacte-email__, ["ROLE_ADMIN"], __redacred-pw-hash__, t).

Please fix that.

Thanks!

antedebaas commented 6 months ago

I’ll look into this, what database type are you using?

wege2003 commented 6 months ago

i am using postresql, but it happens with mysql also

antedebaas commented 6 months ago

i could not replicate it on mysql but the postgres databse was indeed wrong. this should be fixed in 1.12.2 let me know if you still encounter problems.

wege2003 commented 6 months ago

now it is working fine, DMARC reports are loading, and the mailbox check is also working. The user creation works also fine.

Thanks, for the fix!