#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2009
    Posts
    10
    Rep Power
    0

    Gsec - change pass problem


    Hi

    I want to change SYSDBA pass by gsec. If DB is local there is no problem ( gsec -user SYSDBA -password masterkey -modify sysdba -pw mypass) but when DB is on other computer (i send gsec -user SYSDBA -password masterkey -database 10.0.0.81:"C:\Program Files\myprog\xyz.fdb" -modify sysdba -pw mypass ) gsec return error:

    An error occurred while attempting to modify the user record.
    invalid request BLR at offset 103
    table USERS is not defined

    Do you know what i do wrong?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Location
    Plovdiv. Bulgaria
    Posts
    226
    Rep Power
    12
    Originally Posted by kuba323
    Hi

    I want to change SYSDBA pass by gsec. If DB is local there is no problem ( gsec -user SYSDBA -password masterkey -modify sysdba -pw mypass) but when DB is on other computer (i send gsec -user SYSDBA -password masterkey -database 10.0.0.81:"C:\Program Files\myprog\xyz.fdb" -modify sysdba -pw mypass ) gsec return error:

    An error occurred while attempting to modify the user record.
    invalid request BLR at offset 103
    table USERS is not defined

    Do you know what i do wrong?
    For Firebird 2.x the users are in security2.fdb in firebird's installation directory. Not in the working databases.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2009
    Posts
    10
    Rep Power
    0
    Thank you very much

    Do you know how to take path to this file from server? It is important because i don't know where admin install firebird server.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Location
    Plovdiv. Bulgaria
    Posts
    226
    Rep Power
    12
    Originally Posted by kuba323
    Thank you very much

    Do you know how to take path to this file from server? It is important because i don't know where admin install firebird server.
    If the firebird's version is 2.x you can connect to the security database without knowing the exact path
    In this case you can use -SERVER option for the connection:

    gsec -server server_name -user sysdba -password password

    Comments on this post

    • pabloj agrees
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2009
    Posts
    10
    Rep Power
    0
    Now gsec reply is: invalid switch specified error in switch specifications
  10. #6
  11. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
  12. #7
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2010
    Posts
    1
    Rep Power
    0

    Hi,I also meet the question,Could you help me?


    I use the following statement:
    gsec -user sysdba -password masterkey -database "D:\temp\firebird database\testdb.fdb" -modify sysdba -pw macallan

    Error Message following:
    find/modify record error.
    invalid request BLR at offset 103
    table USERS is not defined

    My Firebird Version is 1.0.3

    Who will help me? Thanks a lot ahead.
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Location
    Plovdiv. Bulgaria
    Posts
    226
    Rep Power
    12
    Originally Posted by XuYangLee
    My Firebird Version is 1.0.3
    This is very, very old, unsupported version of Firebird.
    Why don't you upgrade with newer?
  16. #9
  17. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    3
    Rep Power
    0

    Newbie GSEC changing SYSDMB pw problem


    Hi, I'using Firefox 3.6.10. -Windows Vista
    Installed Firebird 2.5 (32).
    Went well, PING is OK.
    I want (first step) to change the SYSADM password.
    So I use CMD, and CD to GSEC.
    in .../bin I use gsec -user SYSDBA -pass masterkey <enter> and
    I do get a new line:
    GSEC>
    I enter:
    -user SYSDBA -pass masterkey -mo -user SYSDBA pw <new pw> and give a return.
    The result is:
    invalid switch specified
    error in switch specifications

    What I'm doing wrong?
  18. #10
  19. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    3
    Rep Power
    0

    Typo


    Oops, typo. Sorry.

    This is the command line I used:

    GSEC> -user sysdba -pass masterkey -mo -user sysdba -pw <new pw>
  20. #11
  21. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2007
    Posts
    36
    Rep Power
    8
    Your command should look like this :
    GSEC> -user sysdba -pass masterkey -mo sysdba -pw <new pw>
  22. #12
  23. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    3
    Rep Power
    0
    Originally Posted by costin_mentor
    Your command should look like this :
    GSEC> -user sysdba -pass masterkey -mo sysdba -pw <new pw>
    Thanks! Tried too often, still making the same error!

IMN logo majestic logo threadwatch logo seochat tools logo