You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
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
That is not firebird error - you should take into an account OS shell behavior. '$' is a special character in linux shell. Take a look:
# echo n98D$kMS
n98D
Instead $kMS shell substitutes the value of variable kMS which is not set and therefore empty string.
In brief - if you want to use $ in password (or any other parameter) in unix command line put that parameter in single quotes:
# echo 'n98D$kMS'
n98D$kMS
Submitted by: Miroslav Djorov (mdjorov)
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
The text was updated successfully, but these errors were encountered: