Read earlier Firebird is to become the default database for libreoffice…
Reading Getting Started with Firebird
noticed under : **gsec Security Administrator **it stating:
It is a good idea to change the SYSDBA password, because the default is so well-known. To change it, we modify the SYSDBA account using the following command:
GSEC> modify SYSDBA -pw newpasswd
then
**Warning**
Editor note: Only the first 8 characters of a password are meaningful. Hence, for example, a password like 'password01' is authenticated to be identical to 'password02'.
If install to openSUSE 13.1 (Gnome/KDE) will Firebird accept and use our existing default passwords for root and users, or will these need be added to Firebird ?
Will it clash, work separate to, or just replace existing MariaDB ?
13.1 VERSION=“13.1 (Bottle)” (Gnome)
1. Not resolved Warnings to change master password.
**
2. Not resolved Warnings re firebird password lengths.**
Need avoid problems with longer user names and passwords.
In YaST “User and Group Administration” modify to add Firebird to my Additional GROUP list.
Found the test database employee.fdb
paulparker@linux-30s5:~> sudo find / | grep -i 'firebird' | grep -i 'employee'
root's password:
find: ‘/run/user/1003/gvfs’: Permission denied
find: ‘/var/run/user/1003/gvfs’: Permission denied
**/usr/lib64/firebird/sample/employee.fdb**
paulparker@linux-30s5:~>
and here
paulparker@linux-30s5:~> cat /etc/firebird/aliases.conf
# ------------------------------
# List of known database aliases
# ------------------------------
#
# Example Database:
#
**employee.fdb = /usr/lib64/firebird/sample/employee.fdb
employee = /usr/lib64/firebird/sample/employee.fdb
**
#
# Live Databases:
#
paulparker@linux-30s5:~>
**Need allow user to administer employee.fdb **
Need allow user to access the data within employee.fdb
Need enable employee.fdb to be viewed as LibreOffice spreadsheet (F4) Data Sources.
Logged in as root user the command gsec shows:
GSEC> **help**
gsec utility - maintains user password database
command line usage:
gsec <options> ... ] <command> <parameter> ... ]
interactive usage:
gsec <options> ... ]
GSEC>
<command> <parameter> ... ]
available options:
-user <database administrator name>
-password <database administrator password>
-fetch_password <file to fetch password from>
-role <database administrator SQL role name>
-trusted (use trusted authentication)
-database <database to manage>
-z
available commands:
adding a new user:
add <name> <parameter> ... ]
deleting a current user:
delete <name>
displaying all users:
display
displaying one user:
display <name>
modifying a user's parameters:
modify <name> <parameter> <parameter> ... ]
changing admins mapping to RDB$ADMIN role in security database:
mapping {set|drop}
help:
? (interactive only)
help
displaying version number:
z (interactive only)
quit interactive session:
quit (interactive only)
available parameters:
-pw <password>
-uid <uid>
-gid <uid>
-fname <firstname>
-mname <middlename>
-lname <lastname>
-admin {yes|no}
GSEC>
On 2014-08-16 04:56, paulparker wrote:
>
> Read earlier Firebird is to become the default database for
> libreoffice…
…
> Will it clash, work separate to, or just replace existing MariaDB ?
I don’t see why. LO has to be able to work with about any database type
that can be installed in Linux, they can not limit themselves to a
single one. It would be shooting their own, removing support for many
installations already done with different databases.
It is a different thing choosing a default one.
–
Cheers / Saludos,
Carlos E. R.
(from 13.1 x86_64 “Bottle” at Telcontar)