Vikunja, Manual-Installation not working

Support
1

Hello All =),

Im really a beginner, and I wanted to install Vikunja without docker, just normal
the “manual-way”. I have a little ec2 srv on aws, with Ubuntu 24.04.
I did the followin:

a) created a domain
b) pointed a A record to that public IP of that SRV
c) Installed postresql, created a DB vikunja, created an user vikunja ,give user the rights on DB
d) created /opt/vikunja, downloaded the package,
e) installed vikunja there, did the basic config,
f) installed nginx
g) configured ngnix, (not sure its all right)
h) created a vikunja service, and launched it

My Problem is:

  • I got this error message on the DB
  • vikunja@vikunja ERROR: permission denied for schema public at character 28
    2024-12-19 17:54:56.561 UTC [150531] vikunja@vikunja STATEMENT: CREATE TABLE IF NOT EXISTS “public”.“migration” (“id” VARCHAR(255) NULL, “description” VARCHAR(255) NULL);

so for me , with my understanding I think I have a issue with postgresql, but im not sure which.
I did yesterday some googling and tried to figure it out (2h at least), but dont got anything working better. Im still stuck at this error message. Do you maybe know how to resolve it ?
Did I missed somthing or did something wrong ? Did I need to adjuste the rights , create a table ?
Just tell me if you need more infos about it.

thanks for any advice / help
best regards
Julien

2

Hi all,

Everything is working fine. The site is running. =)
I just have a probleme with the smtp settings, it dont likes my app password.
What is the format tu use in the config file ?

xxxx-xxxx-xxxx-xxx
or
xxxxxxxxxxxxxxxxx
or
somthing else?

best regards
Julien

3

and also found that out

xxxx xxxx xxxx xxxx is the format

4

Vikunja does not require a specific password format for the SMTP credentials. That only depends on your mail provider.

5

Yes thank you very much. I saw your post abour Google App Passwords, that
was my solutions to use Google SMTP, then my pers. PWD for my Google Email was not working and after I switched to the App Passwords, with the format xxxx xxxx xxxx xxxx , everything worked fine.

TO Update the Forum Post, here all solutions of this post:

best regards
Julien