API how to autorize ?

[l00f00]

I made a api key with administrator capabilities, but cannot authenticate sending this post request:

curl -s -X POST "http://*************:8080/api/jsonrpc" \
  -H "x-api-key: lt_7lMBL7CkiE0ZXOOijTYrWNQxSnlxNYYe_wFhnzBXA06JFk85weRZGXGt7lOc7ImH3" \
  -H "Content-Type: application/json" \
  -d '{
    "method": "leantime.rpc.tickets.addTicket",
    "jsonrpc": "2.0",
    "id": "1",
    "params": {
      "headline": "Nuovo To-Do via API",
      "type": "task",
      "description": "Creato con curl",
      "projectId": "PROJECT_ID",
      "status": "new"
    }
  }'
{"error":"Unauthorized"}

i sent:
curl -X POST "http://*************:8080/api/jsonrpc" -H "x-api-key: lt_7lMBL7CkiE0ZXOOijTYrWNQxSnlxNYYe_wFhnzBXA06JFk85weRZGXGt7lOc7ImH3" -H "Content-Type: application/json" -d "{\"method\":\"leantime.rpc.tickets.getTickets\",\"jsonrpc\":\"2.0\",\"id\":\"1\",\"params\":{\"projectId\":\"1\"}}"

i get:
{"error":"Unauthorized"}

API Key is fresh shows no expiry
Do i have to set any .env variable to use the api ?

Any hint?

[marcelfolaron]

Hm, no this looks correct and should work.
Do you see any errors in your logs (storage/logs)?
Are you running the latest version of Leantime?
Are you running any type of proxy that could strip headers before it makes it to leantime?

[l00f00]

Title: UI fails with {"error":"Invalid API Key"} after some time running

Description:
This issue seems related to some background jobs (possibly cron).

Two days ago, after this error appeared when entering the main page:

{"error":"Invalid API Key"}

I deleted the container, set up a new environment, and worked on it the whole day without problems. Everything ran smooth as butter.

Yesterday the same error occurred again:

{"error":"Invalid API Key"}

So I did a docker compose down, started a fresh environment, and was able to finish my work.

This morning the same error showed up again:

{"error":"Invalid API Key"}

There are no logs in compose no console errors in browser, UI is completely unavailable.

[l00f00]

i got access to the storage/logs, and found a related error: : Base table or view not found: 1146 Table 'leantime.zp_user' doesn't exist in /var/www/html/app/Domain/Install/Repositories/Install.php:163 at 2025-09-24 05:59:17.

see attached:

leantime error.txt

[l00f00]

@marcelfolaron related to Leantime/leantime#3119 ?

[marcelfolaron]

Did you have to go through a new installation?
Is the mysql container volume mounted? That sounds like the volume or data disappeared after a container restart. With that said, someone else is having an issue with the mcp server giving the same error message. Let me debug the auth flow for api calls and see if I can find anything.

[l00f00]

Yes, I destroyed the container and started over, ran through the installation and set up a new board all three times.

[l00f00]

Did you have to go through a new installation? Is the mysql container volume mounted? That sounds like the volume or data disappeared after a container restart. With that said, someone else is having an issue with the mcp server giving the same error message. Let me debug the auth flow for api calls and see if I can find anything.

Is the issue cited above confirmed as related ?

[marcelfolaron]

I am still checking. I'll get back to you on that today.

[l00f00]

Hi again, i see my integration works flawlessly with the online cloud, i made a trial tier just to test. How is it going ?