Is there a way to reset the login password? I can’t for the life of my find the password I set it as, but I can find a reset password option.
Unfortunately there is a way to reset it (as it creates security issues) from the MariaDB addon (you need to connect with Portainer to be able to run the commands).
However, maybe you only think you did but you have not actually changed the default password (changeme)
I have tried the default creds and it didn’t work. Thanks for the link to this. Do these commands delete the database though?
It should not delete the database but only trigger the password to reset. However, you can (and you should) do a snapshot of the addon, or even better, of the whole setup.
Sweet, already doing those daily so we are good. Thanks a bunch, I’ll give this a shot later today!
Hold on though, would I even have a NPM docker-compose directory if I didn’t install NPM with docker? Just with the add-on.
You don’t need Docker-Compose commands as you already have access to the MariaDB addon through Portainer.
Ignore the line
docker exec -it nginxproxymanager_db_1 sh and just login to Portainer and ssh into MariaDB addon. There’s one difference though, due to the fact that the database is not named npm but nginxproxymanager
A complete write-up would be:
- Login to MariaDB addon
mysql -u root -p
(press enter)
USE nginxproxymanager;
UPDATE user SET is_deleted=1;
quit
exit
-
restart NPM addon
-
login to NPM webpage
login:[email protected]
pass:changeme -
Login to MariaDB addon
mysql -u root -p
(press enter)
USE nginxproxymanager;
UPDATE user SET is_deleted=0;
quit
exit
1 Like
woah okay, this is quickly going over my head, I’ve never used Portainer so idk how to ssh into an addon from it. Maybe I should just uninstall/reinstall the addon and start over hah.
Can you SSH into an addon even if its not in a container?
It is not really difficult but I’d suggest doing these stuff in a test environment until you get the hang of it.
I don’t understand this part. Are you using something other than Home Assistant OS (formerly Hassio)?
1 Like
I think I am just confused where you said “just login to Portainer and ssh into MariaDB addon”. I now have the portainer addon intalled. But when I launch Portainer I don’t see where I can utilize ssh into the maria DB addon?
One of the icons for the container in Portainer will open a console into the container
1 Like
I don’t think its using mariadb for the DB, I do a show databases; and it doesn’t show up. What would it be using then?
NPM can also be configured with SQLite but the addon in Home Assistant OS is using MariaDB for a very long time.
Can you list your config and the versions run? (OS, HA, NPM, MariaDB)
LE: I see you posted earlier I try and make a new container from the MariaDB image Did you made a new MariaDB docker different from the default one used by HA?
1 Like
I didn’t realize that portainer hides addon containers by default so once I found that out I was able to find the correct container and it worked!
YOU ARE A LIFE SAVER!
Anyone have any clue why it is not possible to renew or create new letsencrypt certificate?
Me and two other users already reported it, but so far no response.
Existing cert renewal is timing out and new one failing with “Internal Error” 
Don’t know if I had the same issues (if you’re not using DNS challenge) however new certificates/renewals failed for me when I screwed up the 80 port forwarding rule (multiple NAT environment).
Greetings good people, can somebody explain and help me?
I read comments but still not getting it.
I have webserver on lan which i want to see from remote location on my phone on HASS
I have nabucasa and its dns name to connect to.
And i want to be able to make a reverse proxy on the other webserver on lan.
First i’m trying non ssl to check if its working and its not.
Pls help 
404: Not Found
For Source field you need an actual domain name (not an IP but something like mydomain.duckdns.org or mysubdomain.mydomain.duckdns.org if you’re also using DuckDNS so that you don’t have to deal with ISP renewing your IP).
Thank you for explanation as i am using nabucasa i didnt figure it out. Never the less i made a tutorial how to mount media folder for HASSOS. So now i dont need nginx addon
If someone neede here :
I was recently doing main router FW upgrade, so I rather went there and recreated my forwarding rules, but it didn’t help.
I described what other steps I tried in the github issue, but so far it looks like there is some issue with certbot not configuring nginx properly to serve the “acme-challenge”, so it returns 404 to Letsencrypt servers which are trying to verify the renew request.