Holy cow - MS SQL Server recorder creates tables in Master DB

Development
1

hi guys,
As per title really - just enabled sql server for recorder and it appears that the required tables are created in the Master DB - which is…well…bad lol

Is there a way to specify a different DB as part of the connection details or similar?

2

I think the DB_NAME is missing in the docs connection string.
mssql+pymssql://user:pass@SERVER_IP/?charset=utf8
should be
mssql+pymssql://user:pass@SERVER_IP/DB_NAME?charset=utf8

3

Looks like you want to set the db_url variable.

db_url: mysql://user:password@SERVER_IP/DB_NAME
4

Well, you probably should also check why the HA database user was able to create the tables in the master DB in the first place. Ideally your HA database user would only be able to create tables in the HA database.

1 Like