[GH-ISSUE #1291] Connection Refused

kerem commented

2026-02-26 06:35:31 +03:00

Owner

Originally created by @yankieddl on GitHub (Aug 6, 2021).
Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/1291

hi
i keep getting below error for JC21

[Global ] › ✖ error connect ECONNREFUSED 172.18.0.3:3306

whichever DB variant I try, I'm getting the same result:

connect ECONNREFUSED 172.18.0.2:3306

i am using raspberry pi 4

pls advise

Originally created by @yankieddl on GitHub (Aug 6, 2021). Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/1291 hi i keep getting below error for JC21 [Global ] › ✖ error connect ECONNREFUSED 172.18.0.3:3306 whichever DB variant I try, I'm getting the same result: connect ECONNREFUSED 172.18.0.2:3306 i am using raspberry pi 4 pls advise

kerem closed this issue

2026-02-26 06:35:31 +03:00

kerem commented

2026-02-26 06:35:31 +03:00

Author

Owner

@jc21 commented on GitHub (Aug 7, 2021):

Your mysql server is not running so you'll need to inspect the logs for that container.

Alternatively, use the sqlite database option.

@jc21 commented on GitHub (Aug 7, 2021): Your mysql server is not running so you'll need to inspect the logs for that container. Alternatively, use the sqlite database option.

kerem commented

2026-02-26 06:35:31 +03:00

Author

Owner

@yankieddl commented on GitHub (Aug 7, 2021):

Thanks. Can you pls guid how to install sqlite db on the existing installation for raspberry pi 4.

I am new to linux and trying to learn. Sorry if i hav askd a weird question. FYI maria db works fine on raspberry pi 4. Just the jc21 proxy manager giving trouble.

@yankieddl commented on GitHub (Aug 7, 2021): Thanks. Can you pls guid how to install sqlite db on the existing installation for raspberry pi 4. I am new to linux and trying to learn. Sorry if i hav askd a weird question. FYI maria db works fine on raspberry pi 4. Just the jc21 proxy manager giving trouble.

kerem commented

2026-02-26 06:35:31 +03:00

Author

Owner

@chaptergy commented on GitHub (Aug 7, 2021):

The docker-compose files in the setup instructions contain all information you need. You just need to remove the DB_MYSQL_... environment variables and add the DB_SQLITE_FILE variable.

@chaptergy commented on GitHub (Aug 7, 2021): The docker-compose files in the [setup instructions](https://nginxproxymanager.com/setup/) contain all information you need. You just need to remove the `DB_MYSQL_...` environment variables and add the `DB_SQLITE_FILE` variable.

kerem commented

2026-02-26 06:35:31 +03:00

Author

Owner

@yankieddl commented on GitHub (Aug 7, 2021):

thanks.

the suggestions you gave me to use sql-lite worked and is working well.

🙏🙏

On Sat, Aug 7, 2021 at 12:04 PM chaptergy @.***> wrote:

The docker-compose files in the setup instructions
https://nginxproxymanager.com/setup/ contain all information you need.
You just need to remove the DB_MYSQL_... environment variables and add
the DB_SQLITE_FILE variable.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/jc21/nginx-proxy-manager/issues/1291#issuecomment-894622276,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AJSI5M3JIZ55CL3FJTJL77DT3TSKNANCNFSM5BVSVN4A
.

@yankieddl commented on GitHub (Aug 7, 2021): thanks. the suggestions you gave me to use sql-lite worked and is working well. 🙏🙏 On Sat, Aug 7, 2021 at 12:04 PM chaptergy ***@***.***> wrote: > The docker-compose files in the setup instructions > <https://nginxproxymanager.com/setup/> contain all information you need. > You just need to remove the DB_MYSQL_... environment variables and add > the DB_SQLITE_FILE variable. > > — > You are receiving this because you authored the thread. > Reply to this email directly, view it on GitHub > <https://github.com/jc21/nginx-proxy-manager/issues/1291#issuecomment-894622276>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AJSI5M3JIZ55CL3FJTJL77DT3TSKNANCNFSM5BVSVN4A> > . >

kerem commented

2026-02-26 06:35:31 +03:00

Author

Owner

@yankieddl commented on GitHub (Aug 8, 2021):

Good Day again

after setting username and password on nginx i logged out and tried to
login using new email and password but couldnt login.

is there a way to reset password.

pls advise.

thanks

On Sat, Aug 7, 2021 at 9:50 PM Yankie ddl @.***> wrote:

thanks.

the suggestions you gave me to use sql-lite worked and is working well.

🙏🙏

On Sat, Aug 7, 2021 at 12:04 PM chaptergy @.***>
wrote:

The docker-compose files in the setup instructions
https://nginxproxymanager.com/setup/ contain all information you need.
You just need to remove the DB_MYSQL_... environment variables and add
the DB_SQLITE_FILE variable.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/jc21/nginx-proxy-manager/issues/1291#issuecomment-894622276,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AJSI5M3JIZ55CL3FJTJL77DT3TSKNANCNFSM5BVSVN4A
.

@yankieddl commented on GitHub (Aug 8, 2021): Good Day again after setting username and password on nginx i logged out and tried to login using new email and password but couldnt login. is there a way to reset password. pls advise. thanks On Sat, Aug 7, 2021 at 9:50 PM Yankie ddl ***@***.***> wrote: > thanks. > > the suggestions you gave me to use sql-lite worked and is working well. > > 🙏🙏 > > On Sat, Aug 7, 2021 at 12:04 PM chaptergy ***@***.***> > wrote: > >> The docker-compose files in the setup instructions >> <https://nginxproxymanager.com/setup/> contain all information you need. >> You just need to remove the DB_MYSQL_... environment variables and add >> the DB_SQLITE_FILE variable. >> >> — >> You are receiving this because you authored the thread. >> Reply to this email directly, view it on GitHub >> <https://github.com/jc21/nginx-proxy-manager/issues/1291#issuecomment-894622276>, >> or unsubscribe >> <https://github.com/notifications/unsubscribe-auth/AJSI5M3JIZ55CL3FJTJL77DT3TSKNANCNFSM5BVSVN4A> >> . >> >

kerem commented

2026-02-26 06:35:31 +03:00

Author

Owner

@chaptergy commented on GitHub (Aug 8, 2021):

See https://github.com/jc21/nginx-proxy-manager/issues/230. More specifically https://github.com/jc21/nginx-proxy-manager/issues/230#issuecomment-815078355.

@chaptergy commented on GitHub (Aug 8, 2021): See https://github.com/jc21/nginx-proxy-manager/issues/230. More specifically https://github.com/jc21/nginx-proxy-manager/issues/230#issuecomment-815078355.

kerem commented

2026-02-26 06:35:31 +03:00

Author

Owner

@yankieddl commented on GitHub (Aug 8, 2021):

thanks for prompt response.

apologize again. i am not used to the terminology. how do i connect to
database and run the script UPDATE user SET is_deleted=1;?

thanks

On Sun, Aug 8, 2021 at 3:06 PM chaptergy @.***> wrote:

See #230 https://github.com/jc21/nginx-proxy-manager/issues/230. Maybe
your password contained a hash (#), don't add a hash to the password (
#1120 https://github.com/jc21/nginx-proxy-manager/issues/1120).

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/jc21/nginx-proxy-manager/issues/1291#issuecomment-894780621,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AJSI5M2SVFHEG5KV6CLH6R3T3ZQK3ANCNFSM5BVSVN4A
.

@yankieddl commented on GitHub (Aug 8, 2021): thanks for prompt response. apologize again. i am not used to the terminology. how do i connect to database and run the script UPDATE user SET is_deleted=1;? thanks On Sun, Aug 8, 2021 at 3:06 PM chaptergy ***@***.***> wrote: > See #230 <https://github.com/jc21/nginx-proxy-manager/issues/230>. Maybe > your password contained a hash (#), don't add a hash to the password ( > #1120 <https://github.com/jc21/nginx-proxy-manager/issues/1120>). > > — > You are receiving this because you authored the thread. > Reply to this email directly, view it on GitHub > <https://github.com/jc21/nginx-proxy-manager/issues/1291#issuecomment-894780621>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AJSI5M2SVFHEG5KV6CLH6R3T3ZQK3ANCNFSM5BVSVN4A> > . >

kerem commented

2026-02-26 06:35:31 +03:00

Author

Owner

@chaptergy commented on GitHub (Aug 8, 2021):

I have changed my comment to include a link to a specific comment which explains step by step what to do.

@chaptergy commented on GitHub (Aug 8, 2021): I have changed my comment to include a link to a specific comment which explains step by step what to do.

kerem commented

2026-02-26 06:35:31 +03:00

Author

Owner

@yankieddl commented on GitHub (Aug 8, 2021):

thanks.

after first command it asked me enter root password. i tried all but none
works. it keeps giving me following error. pls note i am using sqlite and
not MYSQL

$ sudo docker exec -it nginx_db_1 sh
/ # mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/run/mysqld/mysqld.sock' (2)
/ #

On Sun, Aug 8, 2021 at 4:08 PM chaptergy @.***> wrote:

I have changed my comment to include a link to a specific comment which
explains step by step what to do.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/jc21/nginx-proxy-manager/issues/1291#issuecomment-894787931,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AJSI5MY6JHL4ULPGPTOSONDT3ZXTBANCNFSM5BVSVN4A
.

@yankieddl commented on GitHub (Aug 8, 2021): thanks. after first command it asked me enter root password. i tried all but none works. it keeps giving me following error. pls note i am using sqlite and not MYSQL *$ sudo docker exec -it nginx_db_1 sh* */ # mysql -u root -p* *Enter password:* *ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)* */ #* On Sun, Aug 8, 2021 at 4:08 PM chaptergy ***@***.***> wrote: > I have changed my comment to include a link to a specific comment which > explains step by step what to do. > > — > You are receiving this because you authored the thread. > Reply to this email directly, view it on GitHub > <https://github.com/jc21/nginx-proxy-manager/issues/1291#issuecomment-894787931>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AJSI5MY6JHL4ULPGPTOSONDT3ZXTBANCNFSM5BVSVN4A> > . >

kerem commented

2026-02-26 06:35:31 +03:00

Author

Owner

@chaptergy commented on GitHub (Aug 8, 2021):

I forgot that you are using the sqlite file, not the mysql database. You don't even need the mysql container anymore, you can remove it from the docker-compose.
You will have to edit the database file you specified in the docker-compose using a tool like SQLite Browser. Change to the user table, and set is_deleted to 1. Then follow step 2 and 3, and at the end, set it to 0 again.
If you haven't done much yet it might be easier to just delete the containers and the volumes and just start again.

@chaptergy commented on GitHub (Aug 8, 2021): I forgot that you are using the sqlite file, not the mysql database. You don't even need the mysql container anymore, you can remove it from the docker-compose. You will have to edit the database file you specified in the docker-compose using a tool like [SQLite Browser](https://sqlitebrowser.org/). Change to the `user` table, and set `is_deleted` to `1`. Then follow step 2 and 3, and at the end, set it to `0` again. If you haven't done much yet it might be easier to just delete the containers and the volumes and just start again.

kerem commented

2026-02-26 06:35:31 +03:00

Author

Owner

@jc21 commented on GitHub (Aug 8, 2021):

I can also recommend using litecli for connecting to sqlite db's.

@jc21 commented on GitHub (Aug 8, 2021): I can also recommend using [litecli](https://github.com/dbcli/litecli) for connecting to sqlite db's.

kerem referenced this issue

2026-02-26 07:38:56 +03:00

[PR #1036] [MERGED] Allows hostname instead of ip for streams #3341

Rows
Columns

[GH-ISSUE #1291] Connection Refused #1036