[GH-ISSUE #3270] admin dashboard (self-hosted) #1085

Closed
opened 2026-03-16 18:30:16 +03:00 by kerem · 10 comments
Owner

Originally created by @loban-v-navek on GitHub (Aug 21, 2023).
Original GitHub issue: https://github.com/hoppscotch/hoppscotch/issues/3270

Originally assigned to: @balub on GitHub.

hi. help me please. i signed in by magic link and got it. how become admin? it's self-hosted installation. i have no problem with users page

1

Originally created by @loban-v-navek on GitHub (Aug 21, 2023). Original GitHub issue: https://github.com/hoppscotch/hoppscotch/issues/3270 Originally assigned to: @balub on GitHub. hi. help me please. i signed in by magic link and got it. how become admin? it's self-hosted installation. i have no problem with users page ![1](https://github.com/hoppscotch/hoppscotch/assets/118425382/aa096ea9-7bc9-47b5-bc6b-de78c10d1318)
kerem 2026-03-16 18:30:16 +03:00
  • closed this issue
  • added the
    self-host
    label
Author
Owner

@liyasthomas commented on GitHub (Aug 22, 2023):

Only an existing Admin can elevate a normal user to an Admin role. Ask your administrator to make yourself an Admin.

If you're already an Admin, make sure you're using the correct email ID that has Admin access to login into the Dashboard.

<!-- gh-comment-id:1687289820 --> @liyasthomas commented on GitHub (Aug 22, 2023): Only an existing Admin can elevate a normal user to an Admin role. Ask your administrator to make yourself an Admin. If you're already an Admin, make sure you're using the correct email ID that has Admin access to login into the Dashboard.
Author
Owner

@loban-v-navek commented on GitHub (Aug 22, 2023):

Only an existing Admin can elevate a normal user to an Admin role. Ask your administrator to make yourself an Admin.

If you're already an Admin, make sure you're using the correct email ID that has Admin access to login into the Dashboard.

where i must specify admin? i build this installation but i don't have admin rights)

<!-- gh-comment-id:1687456833 --> @loban-v-navek commented on GitHub (Aug 22, 2023): > Only an existing Admin can elevate a normal user to an Admin role. Ask your administrator to make yourself an Admin. > > If you're already an Admin, make sure you're using the correct email ID that has Admin access to login into the Dashboard. where i must specify admin? i build this installation but i don't have admin rights)
Author
Owner

@liyasthomas commented on GitHub (Aug 22, 2023):

The first email you used to sign in to the dashboard will have Admin privileges. Can you confirm you're using the same email to sign in to the dashboard?

<!-- gh-comment-id:1687909699 --> @liyasthomas commented on GitHub (Aug 22, 2023): The first email you used to sign in to the dashboard will have Admin privileges. Can you confirm you're using the same email to sign in to the dashboard?
Author
Owner

@loban-v-navek commented on GitHub (Aug 22, 2023):

The first email you used to sign in to the dashboard will have Admin privileges. Can you confirm you're using the same email to sign in to the dashboard?

i can't. where i can find what email it was?

<!-- gh-comment-id:1687951534 --> @loban-v-navek commented on GitHub (Aug 22, 2023): > The first email you used to sign in to the dashboard will have Admin privileges. Can you confirm you're using the same email to sign in to the dashboard? i can't. where i can find what email it was?
Author
Owner

@balub commented on GitHub (Aug 22, 2023):

@loban-v-navek, did you sign in to the hoppscotch app before you tried to log in to the admin app?

<!-- gh-comment-id:1688841841 --> @balub commented on GitHub (Aug 22, 2023): @loban-v-navek, did you sign in to the hoppscotch app before you tried to log in to the admin app?
Author
Owner

@loban-v-navek commented on GitHub (Aug 23, 2023):

@loban-v-navek, did you sign in to the hoppscotch app before you tried to log in to the admin app?

sorry but I can't answer. it was problem with magic link and may be it was hopp app before admin app

<!-- gh-comment-id:1689305775 --> @loban-v-navek commented on GitHub (Aug 23, 2023): > @loban-v-navek, did you sign in to the hoppscotch app before you tried to log in to the admin app? sorry but I can't answer. it was problem with magic link and may be it was hopp app before admin app
Author
Owner

@loban-v-navek commented on GitHub (Aug 23, 2023):

i changed some details

#-----------------------Backend Config------------------------------#
# Prisma Config
DATABASE_URL=postgresql://postgres:pass@hoppscotch-db:5432/hoppscotch

# Auth Tokens Config
JWT_SECRET="secret"
TOKEN_SALT_COMPLEXITY=10
MAGIC_LINK_TOKEN_VALIDITY= 3
REFRESH_TOKEN_VALIDITY="604800000" # Default validity is 7 days (604800000 ms) in ms
ACCESS_TOKEN_VALIDITY="86400000" # Default validity is 1 day (86400000 ms) in ms
SESSION_SECRET='secret'

# Hoppscotch App Domain Config
REDIRECT_URL="https://api.mydomain.com"
WHITELISTED_ORIGINS = "https://api.mydomain.com/graphql,https://api.mydomain.com/v1,https://api.mydomain.com,https://apiadm.mydomain.com"

# Google Auth Config
GOOGLE_CLIENT_ID="************************************************"
GOOGLE_CLIENT_SECRET="************************************************"
GOOGLE_CALLBACK_URL="http://localhost:3170/v1/auth/google/callback"
GOOGLE_SCOPE="email,profile"

# Github Auth Config
GITHUB_CLIENT_ID="************************************************"
GITHUB_CLIENT_SECRET="************************************************"
GITHUB_CALLBACK_URL="http://localhost:3170/v1/auth/github/callback"
GITHUB_SCOPE="user:email"

# Microsoft Auth Config
MICROSOFT_CLIENT_ID="************************************************"
MICROSOFT_CLIENT_SECRET="************************************************"
MICROSOFT_CALLBACK_URL="http://localhost:3170/v1/auth/microsoft/callback"
MICROSOFT_SCOPE="user.read"

# Mailer config
MAILER_SMTP_URL="smtp://hoppscotch@mydomain.com:pass@smtp.mydomain.com"
MAILER_ADDRESS_FROM='"hoppscotch mail" <hoppscotch@mydomain.com>'

# Rate Limit Config
RATE_LIMIT_TTL=60 # In seconds
RATE_LIMIT_MAX=100 # Max requests per IP


#-----------------------Frontend Config------------------------------#


# Base URLs
VITE_BASE_URL=https://api.mydomain.com
VITE_SHORTCODE_BASE_URL=https://api.mydomain.com
VITE_ADMIN_URL=https://apiadm.mydomain.com

# Backend URLs
VITE_BACKEND_GQL_URL=https://api.mydomain.com/graphql
VITE_BACKEND_WS_URL=wss://api.mydomain.com/graphql
VITE_BACKEND_API_URL=https://api.mydomain.com/v1

# Terms Of Service And Privacy Policy Links (Optional)
VITE_APP_TOS_LINK=https://docs.hoppscotch.io/support/terms
VITE_APP_PRIVACY_POLICY_LINK=https://docs.hoppscotch.io/support/privacy
<!-- gh-comment-id:1690528833 --> @loban-v-navek commented on GitHub (Aug 23, 2023): i changed some details ``` #-----------------------Backend Config------------------------------# # Prisma Config DATABASE_URL=postgresql://postgres:pass@hoppscotch-db:5432/hoppscotch # Auth Tokens Config JWT_SECRET="secret" TOKEN_SALT_COMPLEXITY=10 MAGIC_LINK_TOKEN_VALIDITY= 3 REFRESH_TOKEN_VALIDITY="604800000" # Default validity is 7 days (604800000 ms) in ms ACCESS_TOKEN_VALIDITY="86400000" # Default validity is 1 day (86400000 ms) in ms SESSION_SECRET='secret' # Hoppscotch App Domain Config REDIRECT_URL="https://api.mydomain.com" WHITELISTED_ORIGINS = "https://api.mydomain.com/graphql,https://api.mydomain.com/v1,https://api.mydomain.com,https://apiadm.mydomain.com" # Google Auth Config GOOGLE_CLIENT_ID="************************************************" GOOGLE_CLIENT_SECRET="************************************************" GOOGLE_CALLBACK_URL="http://localhost:3170/v1/auth/google/callback" GOOGLE_SCOPE="email,profile" # Github Auth Config GITHUB_CLIENT_ID="************************************************" GITHUB_CLIENT_SECRET="************************************************" GITHUB_CALLBACK_URL="http://localhost:3170/v1/auth/github/callback" GITHUB_SCOPE="user:email" # Microsoft Auth Config MICROSOFT_CLIENT_ID="************************************************" MICROSOFT_CLIENT_SECRET="************************************************" MICROSOFT_CALLBACK_URL="http://localhost:3170/v1/auth/microsoft/callback" MICROSOFT_SCOPE="user.read" # Mailer config MAILER_SMTP_URL="smtp://hoppscotch@mydomain.com:pass@smtp.mydomain.com" MAILER_ADDRESS_FROM='"hoppscotch mail" <hoppscotch@mydomain.com>' # Rate Limit Config RATE_LIMIT_TTL=60 # In seconds RATE_LIMIT_MAX=100 # Max requests per IP #-----------------------Frontend Config------------------------------# # Base URLs VITE_BASE_URL=https://api.mydomain.com VITE_SHORTCODE_BASE_URL=https://api.mydomain.com VITE_ADMIN_URL=https://apiadm.mydomain.com # Backend URLs VITE_BACKEND_GQL_URL=https://api.mydomain.com/graphql VITE_BACKEND_WS_URL=wss://api.mydomain.com/graphql VITE_BACKEND_API_URL=https://api.mydomain.com/v1 # Terms Of Service And Privacy Policy Links (Optional) VITE_APP_TOS_LINK=https://docs.hoppscotch.io/support/terms VITE_APP_PRIVACY_POLICY_LINK=https://docs.hoppscotch.io/support/privacy ```
Author
Owner

@AndrewBastin commented on GitHub (Sep 6, 2023):

@loban-v-navek if you are able to access the DB, you will be able to update the isAdmin flag in the DB to update another account to have admin access.

<!-- gh-comment-id:1708752435 --> @AndrewBastin commented on GitHub (Sep 6, 2023): @loban-v-navek if you are able to access the DB, you will be able to update the `isAdmin` flag in the DB to update another account to have admin access.
Author
Owner

@philippos86 commented on GitHub (Sep 14, 2023):

Thanks for the question and the answer.
I was facing the same issue acutally.
I hosted hopscotch locally and run it directly (Not from the Docker container).
Eventually as @AndrewBastin mentioned, I accessed my DB using pgAdmin and changed isAdmin to true.
Still wondering though if this could have been done during the first installation (assigning the admin role to the first user by defauly), or should the installer do this manually every time.

<!-- gh-comment-id:1718860830 --> @philippos86 commented on GitHub (Sep 14, 2023): Thanks for the question and the answer. I was facing the same issue acutally. I hosted hopscotch locally and run it directly (Not from the Docker container). Eventually as @AndrewBastin mentioned, I accessed my DB using pgAdmin and changed `isAdmin` to true. Still wondering though if this could have been done during the first installation (assigning the admin role to the first user by defauly), or should the installer do this manually every time.
Author
Owner

@ambouh1 commented on GitHub (Nov 30, 2024):

got the same problem! Solved now by editing the value in user table using pgadmin tool, by cliking to the column it has a check box, and it took 3 value: true, false and null. when checked , it will be true ! I never thought to go to the DB and change the flags.
All this because I did access to the frontend before !
add these steps to the documentation to be more clear :-) , like the order on how to access, a clear design schema of the product and how the components are connected, steps to configure etc....
You did a greate job!...but the steps to make it working on kubernetes needs more clarifications !
Thank you any way !

<!-- gh-comment-id:2509069298 --> @ambouh1 commented on GitHub (Nov 30, 2024): got the same problem! Solved now by editing the value in user table using pgadmin tool, by cliking to the column it has a check box, and it took 3 value: true, false and null. when checked , it will be true ! I never thought to go to the DB and change the flags. All this because I did access to the frontend before ! add these steps to the documentation to be more clear :-) , like the order on how to access, a clear design schema of the product and how the components are connected, steps to configure etc.... You did a greate job!...but the steps to make it working on kubernetes needs more clarifications ! Thank you any way !
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/hoppscotch#1085
No description provided.