Hello!
I’m a new user, so this is probably user error (bad config?), but I don’t seem to be able to see my mistake.
I manually set up Vikunja 23 on an Ubuntu 22.04 instance (Graviton based) a few days ago, and everything worked fine. I added a couple of users and 100 cards or so. Great! Since then I had to reboot the server and now it no longer works? Not sure what I’ve done wrong, but hopefully if I post my actions / config someone will be able to point out my mistake so that others might benefit from it.
wget -q -O ~/vikunja.zip https://dl.vikunja.io/vikunja/0.23.0/vikunja-v0.23.0-linux-arm64-full.zip
sudo mkdir /opt/vikunja
sudo unzip ~/vikunja.zip -d /opt/vikunja
sudo chmod +x /opt/vikunja
sudo ln -s /opt/vikunja/vikunja-v0.23.0-linux-arm64 /usr/bin/vikunja
sudo nano /opt/vikunja/config.yml
service:
JWTSecret: "<jwt-secret>"
jwtttl: 259200
jwtttllong: 2592000
unixsocket:
unixsocketmode:
publicurl: "https://todo.mydomain.com"
rootpath: "/opts/vikunja"
maxitemsperpage: 50
enablecaldav: true
motd: ""
enablelinksharing: true
enableregistration: false
enabletaskattachments: true
timezone: "Europe/London"
enabletaskcomments: true
enabletotp: true
testingtoken: ""
enableemailreminders: true
enableuserdeletion: true
maxavatarsize: 1024
demomode: false
allowiconchanges: true
customlogourl: ""
sentry:
enabled: false
dsn: "https://440eedc957d545a795c17bbaf477497c@o1047380.ingest.sentry.io/4504254983634944"
frontendenabled: false
frontenddsn: "https://85694a2d757547cbbc90cd4b55c5a18d@o1047380.ingest.sentry.io/6024480"
database:
type: "postgres"
user: "vikunja"
password: "postgres_password"
host: "localhost"
database: "vikunja"
path: ""
maxopenconnections: 100
maxidleconnections: 50
maxconnectionlifetime: 10000
sslmode: "disable"
sslcert: ""
sslkey: ""
sslrootcert: ""
tls: false
typesense:
enabled: false
url: ""
apikey: ""
redis:
enabled: true
host: "localhost:6379"
password: ""
db: 10
cors:
enable: false
origins:
- "*"
maxage: 0
mailer:
enabled: false
host: ""
port: 587
authtype: "plain"
username: "user"
password: ""
skiptlsverify: false
fromemail: "mail@vikunja"
queuelength: 100
queuetimeout: 30
forcessl: false
log:
path: "/opts/vikunja/logs"
enabled: true
level: "INFO"
databaselevel: "WARNING"
http: "stdout"
echo: "off"
events: "off"
eventslevel: "info"
mail: "off"
maillevel: "info"
ratelimit:
enabled: false
period: 60
limit: 100
store: "redis"
noauthlimit: 10
files:
basepath: "./files"
maxsize: "20MB"
migration:
todoist:
enable: false
clientid: ""
clientsecret: ""
redirecturl: "https://todo.mydomain.com/migrate/todoist"
trello:
enable: false
key: ""
redirecturl: "https://todo.mydomain.com/migrate/trello"
microsofttodo:
enable: false
clientid: ""
clientsecret: ""
redirecturl: "https://todo.mydomain.com/migrate/microsoft-todo"
avatar:
gravatarexpiration: 3600
backgrounds:
enabled: true
providers:
upload:
enabled: true
unsplash:
enabled: false
accesstoken: ""
applicationid: ""
legal:
imprinturl: ""
privacyurl: ""
keyvalue:
type: "redis"
auth:
local:
enabled: true
openid:
enabled: false
providers:
- name: ""
authurl: ""
logouturl: ""
clientid: ""
clientsecret: ""
metrics:
enabled: false
username: ""
password: ""
defaultsettings:
avatar_provider: "initials"
avatar_file_id: 0
email_reminders_enabled: false
discoverable_by_name: true
discoverable_by_email: true
overdue_tasks_reminders_enabled: true
overdue_tasks_reminders_time: "9:00"
default_project_id: 0
week_start: 1
language: "en_GB"
timezone: "Europe/London"
webhooks:
enabled: true
timoutseconds: 30
proxyurl: ""
proxypassword: ""
(I ran this through a YAML check to confirm that it’s valid, but it’s not a format that I normally use)
I installed a service:
[Unit]
Description=Vikunja
After=syslog.target
After=network.target
# Depending on how you configured Vikunja, you may want to uncomment these:
#Requires=mysql.service
#Requires=mariadb.service
Requires=postgresql.service
Requires=redis.service
[Service]
RestartSec=2s
Type=simple
WorkingDirectory=/opt/vikunja
ExecStart=/usr/bin/vikunja
Restart=always
# If you want to bind Vikunja to a port below 1024 uncomment
# the two values below
###
#CapabilityBoundingSet=CAP_NET_BIND_SERVICE
#AmbientCapabilities=CAP_NET_BIND_SERVICE
[Install]
WantedBy=multi-user.target
And set it to automatically start (which it does):
sudo systemctl enable vikunja
sudo systemctl start vikunja
Since this is a private instance, I disabled signups and added my user manually:
vikunja user create -u "paul" -e "paul@mydomain.com" -p "my_secure_password"
Which appears when I check:
vikunja user list
Lastly, I put Nginx in front of it:
server {
listen 443 ssl http2;
listen [::]:443 ssl http2;
server_name todo.mydomain.com;
include ssl.d/mydomain.com.conf;
location / {
proxy_http_version 1.1;
proxy_cache_bypass $http_upgrade;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection 'upgrade';
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
proxy_pass http://127.0.0.1:3456/;
client_max_body_size 20M;
}
}
This all worked and I used the service happily for a day. I can still start the service, and I can connect to my PostgreSQL database and see that the data is all there (including the users), but I can’t login and note that no logs have been created?
I assumed that in my intially faffing I must have started it with a slightly different config, used that and subsequently broke it when changing something slightly later - but I don’t know what?!
Manually testing it to get some debug output, it seems to be running correctly (DB and all):
sudo /usr/bin/vikunja
2024-04-05T10:42:39.617734082Z: INFO ▶ config/InitConfig 001 Using config file: /opt/vikunja/config.yml
2024-04-05T10:42:39.662818304Z: INFO ▶ migration/Migrate 05c Ran all migrations successfully.
2024-04-05T10:42:39.662927519Z: INFO ▶ models/RegisterReminderCron 05d Mailer is disabled, not sending reminders per mail
2024-04-05T10:42:39.66299416Z: INFO ▶ models/RegisterOverdueReminderCron 05e Mailer is disabled, not sending overdue per mail
2024-04-05T10:42:39.663255159Z: INFO ▶ cmd/func29 05f Vikunja version v0.23.0
⇨ http server started on [::]:3456
Visiting the login page looks fine too:
2024-04-05T10:42:43.98407609Z: WEB ▶ 1.2.3.4 GET 304 /login 7.273356ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:124.0) Gecko/20100101 Firefox/124.0
2024-04-05T10:42:44.019970183Z: WEB ▶ 1.2.3.4 GET 304 /assets/index-2pE4QXrP.js 3.913525ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:124.0) Gecko/20100101 Firefox/124.0
2024-04-05T10:42:44.02193177Z: WEB ▶ 1.2.3.4 GET 304 /assets/index-VlJ-wnF6.css 5.898619ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:124.0) Gecko/20100101 Firefox/124.0
2024-04-05T10:42:44.112283074Z: WEB ▶ 1.2.3.4 GET 200 /api/v1/info 316.415µs - Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:124.0) Gecko/20100101 Firefox/124.0
2024-04-05T10:42:44.977562079Z: WEB ▶ 1.2.3.4 GET 304 /sw.js 386.37µs - Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:124.0) Gecko/20100101 Firefox/124.0
But pressing login (with my user details - correct and loaded from Bitwarden):
2024-04-05T10:42:52.826610597Z: - ▶ echo recover.go:120 [PANIC RECOVER] interface conversion: interface {} is string, not int64 goroutine 306 [running]:
code.vikunja.io/api/pkg/routes.NewEcho.Recover.RecoverWithConfig.func1.1.1()
/srv/app/pkg/mod/github.com/labstack/echo/v4@v4.11.4/middleware/recover.go:100 +0x13c
panic({0x147d7e0?, 0x4000732cc0?})
/usr/local/go/src/runtime/panic.go:770 +0x124
code.vikunja.io/api/pkg/user.handleFailedPassword(0x400041a580)
/source/pkg/user/user.go:373 +0x434
code.vikunja.io/api/pkg/user.CheckUserCredentials(0x4000527ae0?, 0x4000177800)
/source/pkg/user/user.go:348 +0x108
code.vikunja.io/api/pkg/routes/api/v1.Login({0x43a55a0, 0x40004bc000})
/source/pkg/routes/api/v1/login.go:56 +0xa8
code.vikunja.io/api/pkg/routes.registerAPIRoutes.RateLimit.func28.1({0x43a55a0, 0x40004bc000})
/source/pkg/routes/rate_limit.go:72 +0x5a4
code.vikunja.io/api/pkg/routes.registerAPIRoutes.func1.1({0x43a55a0, 0x40004bc000})
/source/pkg/routes/routes.go:234 +0x184
github.com/labstack/echo/v4.(*Echo).add.func1({0x43a55a0, 0x40004bc000})
/srv/app/pkg/mod/github.com/labstack/echo/v4@v4.11.4/echo.go:582 +0x50
code.vikunja.io/api/pkg/routes.setupStaticFrontendFilesHandler.static.func2.1({0x43a55a0, 0x40004bc000})
/source/pkg/routes/static.go:161 +0x16c
github.com/labstack/echo/v4/middleware.GzipWithConfig.func1.1({0x43a55a0, 0x40004bc000})
/srv/app/pkg/mod/github.com/labstack/echo/v4@v4.11.4/middleware/compress.go:91 +0x238
code.vikunja.io/api/pkg/routes.NewEcho.Recover.RecoverWithConfig.func1.1({0x43a55a0, 0x40004bc000})
/srv/app/pkg/mod/github.com/labstack/echo/v4@v4.11.4/middleware/recover.go:131 +0xe8
github.com/labstack/echo/v4/middleware.LoggerWithConfig.func2.1({0x43a55a0, 0x40004bc000})
/srv/app/pkg/mod/github.com/labstack/echo/v4@v4.11.4/middleware/logger.go:126 +0xa0
github.com/labstack/echo/v4.(*Echo).ServeHTTP(0x4000392d88, {0x437ff30, 0x40001c4620}, 0x400052d0e0)
/srv/app/pkg/mod/github.com/labstack/echo/v4@v4.11.4/echo.go:669 +0x318
net/http.serverHandler.ServeHTTP({0x437c1a8?}, {0x437ff30?, 0x40001c4620?}, 0x6?)
/usr/local/go/src/net/http/server.go:3137 +0xbc
net/http.(*conn).serve(0x40004a03f0, {0x43828a0, 0x40006364e0})
/usr/local/go/src/net/http/server.go:2039 +0x508
created by net/http.(*Server).Serve in goroutine 14
/usr/local/go/src/net/http/server.go:3285 +0x3f0
goroutine 1 [chan receive]:
code.vikunja.io/api/pkg/cmd.init.func29(0x40000c3e00?, {0x161f101?, 0x4?, 0x161f105?})
/source/pkg/cmd/web.go:98 +0x158
github.com/spf13/cobra.(*Command).execute(0x4d70780, {0x400013a120, 0x0, 0x0})
/srv/app/pkg/mod/github.com/spf13/cobra@v1.8.0/command.go:987 +0x828
github.com/spf13/cobra.(*Command).ExecuteC(0x4d70780)
/srv/app/pkg/mod/github.com/spf13/cobra@v1.8.0/command.go:1115 +0x344
github.com/spf13/cobra.(*Command).Execute(...)
/srv/app/pkg/mod/github.com/spf13/cobra@v1.8.0/command.go:1039
code.vikunja.io/api/pkg/cmd.Execute()
/source/pkg/cmd/cmd.go:44 +0x24
main.main()
/source/main.go:22 +0x1c
goroutine 9 [select]:
database/sql.(*DB).connectionOpener(0x40004ce340, {0x43828d8, 0x4000462640})
/usr/local/go/src/database/sql/sql.go:1246 +0x80
created by database/sql.OpenDB in goroutine 1
/usr/local/go/src/database/sql/sql.go:824 +0x140
goroutine 11 [select]:
database/sql.(*DB).connectionCleaner(0x40004ce340, 0x0?)
/usr/local/go/src/database/sql/sql.go:1089 +0x90
created by database/sql.(*DB).startCleanerLocked in goroutine 1
/usr/local/go/src/database/sql/sql.go:1076 +0xf8
goroutine 12 [select]:
github.com/robfig/cron/v3.(*Cron).run(0x40004aa500)
/srv/app/pkg/mod/github.com/robfig/cron/v3@v3.0.1/cron.go:263 +0x920
created by github.com/robfig/cron/v3.(*Cron).Start in goroutine 1
/srv/app/pkg/mod/github.com/robfig/cron/v3@v3.0.1/cron.go:222 +0x104
goroutine 13 [chan receive]:
github.com/ThreeDotsLabs/watermill/message.(*Router).Run(0x40001c42a0, {0x4382360?, 0x4f44720?})
/srv/app/pkg/mod/github.com/!three!dots!labs/watermill@v1.3.5/message/router.go:374 +0x234
code.vikunja.io/api/pkg/events.InitEvents()
/source/pkg/events/events.go:96 +0x35c
code.vikunja.io/api/pkg/initialize.FullInit.func1()
/source/pkg/initialize/init.go:104 +0x1b4
created by code.vikunja.io/api/pkg/initialize.FullInit in gorou
2024-04-05T10:42:52.826892396Z: WEB ▶ 1.2.3.4 POST 500 /api/v1/login 170.797494ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:124.0) Gecko/20100101 Firefox/124.0
Which shows that Go is trying to incorrectly unpack something into an integer when it’s actually a string, but also potentially that somehow my password is incorrect? (it isn’t, or at least it hasn’t changed since the initial successful system use).
This is almost certainly my fault, but I’m not sure what I’ve messed up / am doing wrong… Any help is appreciated!