[FB-Tracker] Created: (CORE-5544) Your user name and password are not defined when $ character presents in user's password

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[FB-Tracker] Created: (CORE-5544) Your user name and password are not defined when $ character presents in user's password

JIRA tracker@firebirdsql.org
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