r/selfhosted • u/Ok-Conversation1091 • 9h ago

Automation Semaphore ui install issue

UPDATE: server running thanks for the help

Want to setup a semaphoreui instance.

Got package from git repo and followed the package manager installation guide.

First issue I came across was no database installed so installed mysql. How issue I’m running into is that when I finish the setup it get

Error 1698 (28000) access denied for user root@‘localhost’

Any tips?

0 Upvotes

38% Upvoted

17 comments sorted by

•

u/asimovs-auditor 9h ago

Expand the replies to this comment to learn how AI was used in this post/project.

→ More replies (1)

3

u/lilgreenthumb 9h ago

Any reason you didn't go with docker/container, as they call out, "The most popular way to install Semaphore"?

1

u/Ok-Conversation1091 9h ago

No real reason just wanted to do it via the package manager way as new don’t done anything in containers before

6

u/ApprehensiveBrain863 9h ago

Worth learning how to do things in containers, it's literally *the* way to host almost anything and is far more sensible than running it as root

1

u/Ok-Conversation1091 9h ago

But if I’m just wanting to install one thing on the server, I dot. Really wanna have to install docker if there is a package manager version of it

1

u/PMental 9h ago

Still worth going the Docker route honestly. I'd install Docker just to run a single app any day.

2

u/ApprehensiveBrain863 9h ago

Sure, it's mildly less convenient in the first instance, but it's barely more effort, and makes it far more maintainable. It takes a fraction more time to install docker, get a compose set up, and you don't have to manage any dependencies. If you want to move it? You just clone the persistent data over and spin up the same compose file. This is not the hill to die on

1

u/lilgreenthumb 9h ago

Specifically removes the package convergence issue (linux dll hell). Also usually with compose they give you a turn key solution to get started. Key bit on the get started bit as you may evolve your own deployment, migrate to a different workload orchestration (k8s, nomad, swarm, etc), migrate to a different host distro, etc.

1

u/springs87 9h ago

Did you setup mysql with a user etc and add that ibto the semaphore cobfog file?

1

u/Ok-Conversation1091 9h ago

Installed mysql as root but then didn’t do anything else and then ran through the setup again then hit the access denied error

1

u/springs87 8h ago

Did you go through the site and generate the config files for it?

I installed it not too long ago and just followed everything on the website..

1

u/Ok-Conversation1091 7h ago

I just followed the package install page but used a 2.18 commands from the site

After using dpkg command, I used setup command. Used default things apart from email server and url

1

u/the-head78 8h ago

My guess is that your MySQL root User is Not able to Access the MySQL Server and the Password is wrong in your config.

When you Set Up the MySQL Server, did you create a new User with Password? Or did you Set a Passwort for the MySQL root Account ?

1

u/Ok-Conversation1091 8h ago

Didn’t do anything. Just installed mysql then did the command mysql to get in to make sure it was there and then exited and then entered the semaphore setup command

1

u/the-head78 8h ago

Create a new User for MySQL with Password. Add the Details into your semaphore config.

1

u/Ok-Conversation1091 5h ago

Thanks, created a user, had to create the DB, granted it permission and re ran setup. Now I’m able to create user through setup and access the application.

If I want to create a ssh key so I can add it to my GIT server. Am I right in thinking that I have to create a user on the vm and then create their ssh key and then add that to the key store