Hi,
New to Unimus and really like it. Unfortunately, I forgot to write my password down to the GUI.
Using HSQL backend and would like to add another user to get access.
Following the following URL: https://wiki.unimus.net/display/UNPUB/R ... t+password
It does not say "how" to access the db to create the user.
Any help would be appreciated
[Solved] How to insert user into database via CLI
Hi,
You can use database editing tools such as DBeaver or RazorSQL - they both support HSQL.
Your database is located on-disk, by default in:
/etc/unimus/hsql
C:\ProgramData\Unimus\hsql
You can open the DB using these tools and change the user's password as described in the article.
We do NOT recommend adding another user to the DB manually - you will compromise database integrity.
(there is more to user creation than just adding a row to the SYSTEM_ACCOUNT table).
Instead reset the password to the original user and properly create new users using Unimus "User Management" menu.
You can use database editing tools such as DBeaver or RazorSQL - they both support HSQL.
Your database is located on-disk, by default in:
/etc/unimus/hsql
C:\ProgramData\Unimus\hsql
You can open the DB using these tools and change the user's password as described in the article.
We do NOT recommend adding another user to the DB manually - you will compromise database integrity.
(there is more to user creation than just adding a row to the SYSTEM_ACCOUNT table).
Instead reset the password to the original user and properly create new users using Unimus "User Management" menu.
Sorry about that - did not notice you were looking specifically for a CLI tool.
For direct CLI use, there is "hsqldb-sqltool".
It is a little painful to deal with tho.
Personally, I use the GUI tools when dealing with HSQL.
Since HSQL is a file-based database, you can just transfer the DB files to a PC with a GUI, edit the DB, and transfer the DB files back to the server. (of course Unimus needs to be shut down during this procedure)
For direct CLI use, there is "hsqldb-sqltool".
It is a little painful to deal with tho.
Personally, I use the GUI tools when dealing with HSQL.
Since HSQL is a file-based database, you can just transfer the DB files to a PC with a GUI, edit the DB, and transfer the DB files back to the server. (of course Unimus needs to be shut down during this procedure)