Your user name and password are not defined when $ character  presents in 
user's password
-----------------------------------------------------------------------------------------

                 Key: CORE-5544
                 URL: http://tracker.firebirdsql.org/browse/CORE-5544
             Project: Firebird Core
          Issue Type: Bug
          Components: GBAK
    Affects Versions: 2.5.7
         Environment: CentOS Linux release 7.3.1611 x64 running on  WMWare 
vSphere 8 cpu cores, 12 GB RAM
            Reporter: Miroslav Djorov


I was trying to move some clients' databases from a Windows server to new Linux 
CentOS server. I've created all DB users with their passwords with IBExpert's 
user manager.
After that I've copied backup files of clients' databases and for one of the 
databases I've got this error:

gbak: ERROR:Your user name and password are not defined. Ask your database 
administrator to set up a Firebird login.

At the same time I don't have any problems logging in with the user's name and 
password with isql-fb. I was trying to restore the databases with this command:

gbak -C -P 8192 -user XXXXX -password n98D$kMS backup.fbk database.fdb

After few tries I think that the problem is with the $ character in the 
password. I've tried some combinations with these results
Password           Result
n98D$kMS          Your user name and password are not defined...
n98DkMS            working
n98D$k               Your user name and password are not defined...
n98Dk                 working
n98D$                 working!!!
$n98D                 Error message: requires both input and output filenames
"$n98D"             Your user name and password are not defined....

At the same time on Windows, Firebird's version 2.5.7.27050 works fine

Installed packages:
firebird.x86_64                       2.5.7.27050.0-1.el7              @epel
firebird-filesystem.x86_64            2.5.7.27050.0-1.el7              @epel
firebird-libfbclient.x86_64           2.5.7.27050.0-1.el7              @epel
firebird-libfbembed.x86_64            2.5.7.27050.0-1.el7              @epel
firebird-superserver.x86_64           2.5.7.27050.0-1.el7              @epel

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to