Re: [firebird-support] FB 2.5 migrate to 3.0

[Helen Borrie hele...@iinet.net.au [firebird-support]]

> 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

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

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 
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]
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: Re: [firebird-support] FB 2.5 migrate to 3.0

[James mallee....@gmail.com [firebird-support]]

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

[Helen Borrie hele...@iinet.net.au [firebird-support]]

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

[firebird-support] About nbackup and incremental

[Leandro Melo de Sales leandromsa...@gmail.com [firebird-support]]

Hi,


Operating system: Linux CentOS 5.7
NBackup: Physical Backup Manager version LI-V2.5.2.26540 Firebird 2.5


Scenario: I'm using nbackup and my plan is to run a full backup (-B 0)
every month and a daily backup with -B 1, replacing the previous 1-level
backup everyday. My customer don't generate to much data to have multiples
2-level backup so that I want to avoid many incremental files.


Question: with one 0-level and one 1-level (everyday), is it enough to
restore the database? I read that 1-level accumulates the difference since
last 0-level backup, is that correct?


Thanks,
Leandro.

[firebird-support] Updating Firebird version and database compatibility issue

[Leandro Melo de Sales leandromsa...@gmail.com [firebird-support]]

Hi folks,


Scenario: My customer has a Linux CentOS 5.7 with Firebird TCP/IP server
version LI-V2.5.2.26540 Firebird 2.5. I want to update his Linux server to
Ubuntu latest version. My customer uses a third-party application called
ProDoctor that connects to the server.


Question: is there any compatibility issues if I do the Linux update?


Thanks,
Leandro.


-- 
PhD. Leandro Melo de Sales
Institute of Computing (IC) at Federal University of Alagoas (UFAL), Brazil
Pervasive and Mobile Computing Laboratory (COMPELab.org / IC)






"The warrior is strong in loyalty, intensity, determination, initiative,
persistence, courage and willpower. The warrior is light in the soul,
self-trust and compassion. The warrior is often called to take the front
when other cowardly make a step backwards. There are warriors on the
battlefields and in everyday life."

Re: [firebird-support] FB 2.5 migrate to 3.0

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

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