Subject Re: Re: [firebird-support] FB 2.5 migrate to 3.0
Author James
Post date 2017-01-09T23:59:18Z
Dear Helen,

Thanks for your answer. I think I got help from you also during last time migration test. :-)
I tested it with your advice but it still doesn't work.
I would like to test it with a fresh installation of FB 3.0 later.

I should make my description more clear for my steps.

0. First of all, all applications are running in Windows 7. FB x32 versions are used for testing.
1. Use gbak (FB 2.5) to backup Firebird 2.5 database file.
2. Use gbak (FB 3.0) to restore backuped FBK file to a new database file.
3. Use isql, to run: SQL> alter user sysdba set password 'masterkey';
respond: Database: myimport, User: SYSDBA
4. Open new database file in IBExpert with FB 3.0 client library (fbclient.dll), it works.
5. Run my own applicatoin with FB 3.0 client library which works with FB2.5 client library, error message shows below:
[FireDAC][Phys][FB]Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

********************************
Connection string inside my code
********************************
  object dbcMain: TFDConnection
    Params.Strings = (
      'DriverID=FB'
      'User_Name=sysdba'
      'Password=masterkey')
********************************


Best regards,

James
 
Date: 2017-01-10 05:36
Subject: Re: [firebird-support] FB 2.5 migrate to 3.0
 

Saturday, January 7, 2017, 3:02:03 PM, James wrote:

> I am trying to migrate my database from 2.5 to 3.0 now.

> Now I show all my steps&nbs p;I have done for migration procedure.

> 1. Use gbak (FB 2.5) to backup Firebird 2.5 database file.
> 2. Use gbak (FB 3.0) to restore backuped FBK file to a new database file.
> 3. Use isql, to run: SQL> alter user sysdba set password 'masterkey';
> respond: Database: myimport, User: SYSDBA

This alters the user SYSDBA under the default UserManager, which is
SRP....

> 4. Open new database file in IBExpert, it works.

IBExpert is apparently using the new client library. You don't say
what platform you are on but, if it is Windows, the client library is
fbclient.dll. On Linux, it is libfbclient.so.

> 5. Run my own applicatoin which works with FB2.5, error message shows below:
> [FireDAC][Phys][FB]Your user name and password are not defined. Ask
> your database administrator to set up a Firebird login.

If your application is connecting via the v.2.5 client library then it
doesn't know about SRP. You'll need to go back to isql and create the
SYSDBA user for the Legacy_UserManager plug-in, viz.,

CREATE USER sysdba PASSWORD 'masterke' USING PLUGIN Legacy_UserManager;

Also look at firebird.conf, to make sure that Legacy_UserManager is
available. This will probably mean changing from the default
settings, if you did not do that previously:

AuthServer = Srp, Legacy_Auth

UserManager = Legacy_UserManager

Don't forget to stop and restart the Firebird server to enable your
config changes.

On the other hand, if you want your application to use the new
security features, make sure that it is loading the FB3 client
library. If the app is 32-bit, you will need the 32-bit client, even
if your server is running 64-bit Firebird.

HB