missing database name in .env file on Adonis Lucid Postgres project

[Clement-Mchar]

Extension Version

v2.1.1

OS and Version

Windows 11 x64

VS Code Version

1.98.2

Database name and Version

psql 16.3

Steps to reproduce

1. launch VsCode
2. download devdb extension
3. profit. Wait, actually no, got an error message "missing database name in .env file"
4. take a look at .env file, see "DB_DATABASE" with the correct value written
5. refresh, still not working
6. restart extension, still not working
7. restart vscode, typescript server, still not working
8. go "????" 😆

Expected behavior

Since provided infos were correct I expected it to find my db name and make the magic of zero-config feature operate, but it doesn't. I took a look at the env-parser file for adonis project and it seems like my .env config is correct, so idk

Screenshots

Additional context

I tried to use .devdbrc but it doesnt seem to work either 😄

[PedroSoutoDev]

+1

Any news on this? Thank you.

[damms005]

Can you upgrade to v2.4.1 and confirm this is now fixed?

[Clement-Mchar]

Can you upgrade to v2.4.1 and confirm this is now fixed?

it is not, sir

error message has changed, though.

[damms005]

@Clement-Mchar Can you share the content of the DevDb output? Ensure to redact any sensitive parts. See example below:

[Init] Getting available providers... 
[Init] Checking provider: Laravel Local SQLite (default) 
[Init] Checking provider: SQLite Database File Picker 
[Init] Checking provider: Config File 
[Init] Checking provider: Laravel Mysql (with Sail support) 
[Init] Checking provider: Laravel PostgreSQL 
[Init] Checking provider: DDEV - MySQL 
[Postgres DDEV] Not a DDEV project
[Init] Checking provider: DDEV - PostgreSQL 
[Postgres DDEV] Not a DDEV project
[Init] Checking provider: Adonis MySQL (Lucid ORM) 
[Adonis env file parser] Fetching connection details from .env file. Laravel connection:  mysql
[Init] Checking provider: Adonis PostgreSQL (Lucid ORM) 
[Init] Laravel Local SQLite (default) useable in workspace: no 
[Init] SQLite Database File Picker useable in workspace: yes 
[Init] Laravel Mysql (with Sail support) useable in workspace: no 
[Init] Laravel PostgreSQL useable in workspace: no 
[Init] DDEV - MySQL useable in workspace: no 
[Init] DDEV - PostgreSQL useable in workspace: no 
[Init] Adonis PostgreSQL (Lucid ORM) useable in workspace: no 
[Adonis env file parser] Laravel/mysql2 connection details: host=127.0.0.1, username=***, database=*** 
[Adonis env file parser] Laravel/mysql2 connection details: 127.0.0.1 3306 *** ***
[Connector - Adonis env file parser] Attempting to connect to database: dialect=mysql2, host=127.0.0.1, port=3306, username=***, database=*** 
[Init] Config File useable in workspace: no 
[Init] Adonis MySQL (Lucid ORM) useable in workspace: yes 
[Init] Available providers: SQLite Database File Picker, Adonis MySQL (Lucid ORM) 

[Clement-Mchar]

this is weird. I am relatively new to this so maybe I skipped a step idk
I may be wrong but yet I think I have my adonis database config file right ?

[damms005]

From the screenshot you share, it seems your adonis app in a sub-folder in the workspace, BLM_BCK. DevDb doesnt currntly support nested workspaces. Your adonis app needs to be in the root folder for Adonis zero-config to work.

If you must have your adonis app in BLM_BCK subfolder, consider using DevDb config file instead

[Clement-Mchar]

I knew it ! Adding this .devdbrc file where it belongs. Thank you sir !

Edit : works like a charm.

[damms005]

Glad it worked for you @Clement-Mchar !

@PedroSoutoDev any luck?

[PedroSoutoDev]

Glad it worked for you @Clement-Mchar !

@PedroSoutoDev any luck?

Fixed! Thank you so much 👍