Store is not creating

[knightkronos]

Hello I am trying to use this lib but there is a problem when it tries to create the http_sessions table it says the following error:
"Unable to create http_sessions table in the database".

I tried to find on google a possible solution that for some reason any of the people who had used this lib in the past and had the same issue, but unfortunately I could not find any solution at all.

My SQLUrl is the following:
"postgres://IGToolUserDB:password@x.x.x.x:x/IGToolDB?sslmode=verify-full"

[antonlindstrom]

Hi @knightkronos ! This is a problem that the database cannot be created, do you have the permissions to create the http_sessions database?

What happens if you try to run the following manually in the database?

CREATE TABLE IF NOT EXISTS http_sessions (
          id BIGSERIAL PRIMARY KEY,
          key BYTEA,
          data BYTEA,
          created_on TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
          modified_on TIMESTAMPTZ,
          expires_on TIMESTAMPTZ);