Results 1 to 3 of 3

Thread: firebird

  1. #1
    Join Date
    Jun 2008
    Location
    Rural Australia
    Posts
    286

    Default firebird

    Read earlier Firebird is to become the default database for libreoffice...



    Reading http://www.firebirdsql.org/file/docu...-getstart.html


    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)

  2. #2
    Join Date
    Jun 2008
    Location
    Rural Australia
    Posts
    286

    Default Re: firebird

    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

    Code:
    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

    Code:
    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:

    Code:
    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>

  3. #3
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: firebird

    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •