QUESTION: How can I see all databases in the MSSQL server?

[luisxkimo]

Details:
I see that with the last versions of DB Gate, its needed new environment variable with default database name: DATABASE_connName.

For example, if I use "master" as default, then in the list of databases I cannot see the other created databases in the server, but exists because I can run queries on the other databases.

Version Information [might be relevant to your issue]

Screenshot [if appropriate]:

Additional info
Nothing

[janproch]

It is not neccessary to specify database name with DATABASE_ environment variable. When you omit this variable, you will see all databases in DbGate interface.

[luisxkimo]

Hi @janproch ,

Thanks for the quick reply. The thing is when we not use this variable, we se an error on the web:

And if we put the mouse over it says: "The config.options.database must be of type string"

Here is the log of the container:

Using connections from ENV variables:
[
  {
    "_id": "***",
    "engine": "mssql@dbgate-plugin-mssql",
    "server": "***",
    "user": "***",
    "password": "***",
    "port": "1433",
    "useDatabaseUrl": false,
    "defaultDatabase": null,
    "singleDatabase": false,
    "displayName": "***"
  }
]
Calling init controller for controller /connections
Creating directory /root/dbgate-data
Calling init controller for controller /config
Calling init controller for controller /scheduler
Creating directory /root/dbgate-data/files
Creating directory /root/dbgate-data/run
DbGate API listening on port 3000
....

[janproch]

Intereseting, I am testing it now and it works.

Did it work in past? The only change in last version is using debian docker image instead of alpine, because of SQLite. But I tested it on both images, and it works.

Does it work with alpine image?
image: dbgate/dbgate:alpine

[janproch]

OK, I replicated it just now

[luisxkimo]

Tested right now with dbgate:alpine and still not works

[janproch]

It should be fixed in newest BETA (few minutes old), in both alkine and debian image. I have replicated it with version from yesterday (it occured only when MSSQL run also in docker container, when connecting to MSSQL running under windows it worked)

Sorry for confustion.

[janproch]

Fixed in 4.7.1

Thanks for reporting

[luisxkimo]

Thanks so much for the quick fix @janproch