Re: Re: [firebird-support] FB 2.5 migrate to 3.0
Dear Helen, Thanks for your advice. I will try it all with your detail steps. Best regards, James From: Helen Borrie hele...@iinet.net.au [firebird-support] Date: 2017-01-10 17:02 To: firebird-support Subject: Re: [firebird-support] FB 2.5 migrate to 3.0 > 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 am not convinced you have that authentication configured properly nor that your application is really loading the Fb3 client library. Some reality checks: 1. Make sure that you deleted the # symbol when you configured AuthServer. 2. It might be worthwhile to change the ordering of the list in AuthClient, so that Legacy_Auth appears first. 2. Get rid of SRP from the UserManager list. Make it so that Legacy_UserManager is only entry. 3. Don't forget to save firebird.conf, and to restart Firebird. 4. Put fbclient.dll in the same folder as your application. It would probably be a good idea to reboot the client machine, while you are at it, in case the old version is still loaded. > 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, bsp;User: SYSDBA Without the modifications to firebird.conf, that step operates on the SYSDBA that is configured under UserManager SRP. It will NOT work with applications connecting via Legacy_UserManager. You have to create SYSDBA for use with Legacy_UserManager. You need to use the USING PLUGIN clause, as indicated in my previous posting. > 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') > But it will not work if either (or both) 1) the application is loading the Fb 2.5 client 2) firebird.conf configuration is a mismatch with the client BTW, you are not REALLY using masterkey for your SYSDBA password, are you? HB
Re: [firebird-support] FB 2.5 migrate to 3.0
> 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 am not convinced you have that authentication configured properly nor that your application is really loading the Fb3 client library. Some reality checks: 1. Make sure that you deleted the # symbol when you configured AuthServer. 2. It might be worthwhile to change the ordering of the list in AuthClient, so that Legacy_Auth appears first. 2. Get rid of SRP from the UserManager list. Make it so that Legacy_UserManager is only entry. 3. Don't forget to save firebird.conf, and to restart Firebird. 4. Put fbclient.dll in the same folder as your application. It would probably be a good idea to reboot the client machine, while you are at it, in case the old version is still loaded. > 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, bsp;User: SYSDBA Without the modifications to firebird.conf, that step operates on the SYSDBA that is configured under UserManager SRP. It will NOT work with applications connecting via Legacy_UserManager. You have to create SYSDBA for use with Legacy_UserManager. You need to use the USING PLUGIN clause, as indicated in my previous posting. > 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') > But it will not work if either (or both) 1) the application is loading the Fb 2.5 client 2) firebird.conf configuration is a mismatch with the client BTW, you are not REALLY using masterkey for your SYSDBA password, are you? HB
RE: Re: [firebird-support] FB 2.5 migrate to 3.0
James, Check that no other fbclient.dll or gds32.dll exist on you system… Sean From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Monday, January 9, 2017 6:59 PM To: firebird-support <firebird-support@yahoogroups.com> Subject: Re: Re: [firebird-support] FB 2.5 migrate to 3.0 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 From: Helen Borrie hele...@iinet.net.au [firebird-support]<mailto:firebird-support@yahoogroups.com> Date: 2017-01-10 05:36 To: firebird-support<mailto:firebird-support@yahoogroups.com> 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 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
Re: Re: [firebird-support] FB 2.5 migrate to 3.0
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 From: Helen Borrie hele...@iinet.net.au [firebird-support] Date: 2017-01-10 05:36 To: firebird-support 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 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
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 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
Re: [firebird-support] FB 2.5 migrate to 3.0
Hi, Recompile all stored procedures and triggers in Firebird 3. Regards, Alexey Kovyazin IBSurgeon HQbird www.ib-aid.com/hqbird Dear Sir/Madam, I am trying to migrate my database from 2.5 to 3.0 now. It was tested before and worked successfully with great help from firebird community. But unfortunately, all my notes were gone with my lost laptop. Now I show all my steps 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 4. Open new database file in IBExpert, it works. 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. Connection string inside my code object dbcMain: TFDConnection Params.Strings = ( 'DriverID=FB' 'User_Name=sysdba' 'Password=masterkey') I guess that one or two steps must be missed in this procedure but I really can't recall my memory any more. Please anyone can show me what is the key point to get this new FDB file working? Thanks. Best regards, James
[firebird-support] FB 2.5 migrate to 3.0
Dear Sir/Madam, I am trying to migrate my database from 2.5 to 3.0 now. It was tested before and worked successfully with great help from firebird community. But unfortunately, all my notes were gone with my lost laptop. Now I show all my steps 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 4. Open new database file in IBExpert, it works. 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. Connection string inside my code object dbcMain: TFDConnection Params.Strings = ( 'DriverID=FB' 'User_Name=sysdba' 'Password=masterkey') I guess that one or two steps must be missed in this procedure but I really can't recall my memory any more. Please anyone can show me what is the key point to get this new FDB file working? Thanks. Best regards, James