# Failed to open ./data/temp.db
**URL:** https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301
**Category:** Dashboard
**Created:** [28 May 2025 06:58 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301 "2025-05-28T06:58:45Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@ColaJin](https://discourse.nodered.org/u/ColaJin)
#### Post date: [28 May 2025 06:58 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301/1 "2025-05-28T06:58:45Z")
in my environment，i import project ,nodejs directory has node.exe，data directory has two db documents(temp.db、test.db) , i config node find "./data/temp.db" can execute，but test.db appears error failed to open "./data/test.db"，so i change config "../data/test.db" is working；
in others environment ../data/test.db、./testdb both not working
absolute directory is working，how to debug
---
### Author:  [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)
#### Post date: [28 May 2025 07:15 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301/2 "2025-05-28T07:15:10Z")
You may need to post part of your `settings.js` file which shows what paths are shared.
---
### Author:  [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)
#### Post date: [28 May 2025 07:47 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301/4 "2025-05-28T07:47:45Z")
Oh, sorry, some other details:
O/S being used
NR version
---
### Author:  [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)
#### Post date: [28 May 2025 07:59 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301/6 "2025-05-28T07:59:04Z")
Ah, windoze.......
Not my area. I'd better step back and let others help you.
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [28 May 2025 08:06 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301/7 "2025-05-28T08:06:42Z")
> [@ColaJin](#):
>
> ```auto
> console.log('Loading settings from:', __dirname);
> process.env.PATH = `${process.env.PATH};`+__dirname+'\\lib';
> process.env.PATH = `${process.env.PATH};`+__dirname+'\\lib\\ias';
>
> console.log('process env PATH:',process.env.PATH);
>
> const newPath = __dirname;
> try {
> process.chdir(newPath);
>
> } catch (err) {
> console.error('修改工作路径失败:', err.message);
> }
>
> ```
None of this is really necessary.
Since `data` is relative to the settings.js, you should be able to specify a relative path `data/test.db` in the SQL node.
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [28 May 2025 08:36 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301/9 "2025-05-28T08:36:30Z")
> [@ColaJin](#):
>
> data/tes.db
if that is what you entered, then there is no surprise.
if you really entered `data/test.db` then something else is amiss.
did you remove your extra code in settings.js `process.chdir(newPath);` and restart node-red?.
If you add a simple flow `inject -> exec -> debug` and put `cd` in the command, what do you get when inject is operated?
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [28 May 2025 09:03 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301/11 "2025-05-28T09:03:02Z")
You say:
> [@ColaJin](#):
>
> failed to open data/test.db
Then you say:
> [@ColaJin](#):
>
> test.db can use tool access
so I cannot really understand what you are saying.
Maybe you have a lock on the database. try closing any database management applications. try restarting the computer.
also, check you have not got more than one db config node configured for the same database (you have 2 database files, there should only be 2 configs in the dropdown)
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [28 May 2025 09:21 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301/14 "2025-05-28T09:21:38Z")
I'm sorry but you are changing things and only reporting small parts of info making it very difficult to help.
1. show me the files in `data` dir
2. show me the output of `cd` using the flow I suggested above
3. show me the settings in the 2 configs.
- 1 should have `data/test.db`
- 2 should have `data/temp.db`
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [28 May 2025 09:30 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301/18 "2025-05-28T09:30:02Z")
> [@Steve-Mcl](#):
>
> - show me the output of `cd` using the flow I suggested above
> [@ColaJin](#):
>
> not understand
Do this ↓
> [@Steve-Mcl](#):
>
> add a simple flow `inject -> exec -> debug` and put `cd` in the command, what do you get when inject is operated?
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [28 May 2025 09:32 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301/19 "2025-05-28T09:32:05Z")
> [@Steve-Mcl](#):
>
> show me the settings in the 2 configs.
>
> - 1 should have `data/test.db`
> - 2 should have `data/temp.db`
## THERE SHOULD BE 2 CONFIGS for 2 DATABASE CONNECTIONS
Select 1st one then click edit
Select 2nd one then click edit
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [28 June 2025 11:45 UTC](https://discourse.nodered.org/t/failed-to-open-data-temp-db/97301/24 "2025-06-28T11:45:40Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.