Re: FW: [firebird-support] firebird 3.0 - Segmentation fault (core dumped)

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

Dear Paul,

Thanks for your advice but unfortunately, I already uninstalled firebird and 
tried to reinstall it again.
All old folfers are deleted.

After firebird installed, it can work in Ubuntu with isql, but can't be 
accessed from other PC.
I am working on it now.

Best regards,

James
 
From: Paul Beach
Date: 2017-09-14 00:40
To: mallee@gmail.com
Subject: FW: RE: [firebird-support] firebird 3.0 - Segmentation fault (core 
dumped)
 
 
-Original Message-
From: Paul Beach [mailto:pbe...@mail.ibphoenix.com]
Sent: 13 September 2017 16:34
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] firebird 3.0 - Segmentation fault (core
dumped)
 
 
 
<>
 
Take a look at the firebird.log and see if that gives you any more 
information
 
Paul
 

[firebird-support] firebird 3.0 - Segmentation fault (core dumped)

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

Hello everyone,

Today when I started to run my application and try to connect with DB server, 
but it failed.

I checked in server side and did these steps:
1. RUN isql-fb and try to CONNECT database, but it gives error "Segmentation 
fault (core dumped)".
2. Restart firebird server and check its status by "service --status-all", it 
shows firebird3.0 is running.

OS: Ubuntu 17.04
Firebird: 3.0.2.32703

Please give any advice.
Thanks in advance.

Best regards,

James

Re: RE: [firebird-support] remote connection disconnection

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

Thanks for Thomas and Dimitry!

I will try to change DummyPacketInterval to 60 tomorrow and to see what it will 
go on.



Best regards,

James
 
From: Thomas Kragh t...@uvdata.dk [firebird-support]
Date: 2017-06-01 00:03
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] remote connection disconnection
  
It is normal for firewalls to kill tcp connections that are idle for some 
period of time. This has nothing to do with DNS. 
You could adjust this idle period in your firewall, however it impossible to 
control the firewall of clients. 
 
A solution is to use a disconnected model or send dummy requests from the 
applications to keep the connection active. 
Perhaps this link https://www.ibphoenix.com/resources/documents/how_to/doc_104 
from a quick search provides another solution. 
 
 
From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Wednesday, May 31, 2017 15:48
To: firebird-support 
Subject: [firebird-support] remote connection disconnection
 
  
Dear sir/madam,
 
I am testing Firebird 3.0 in Ubuntu as DB Server.
When application connects DB inside same network, everything works fine.
When application connects DB through Internet (using Dynu DDNS service), 
connection may lose if there is not operation after period.
 
I have checked firebird.conf and still not sure which parameter can avoid this 
issue.
Or this issue is caused from Ubuntu ddclient DDNS service?
 
Please give any advice to help me.
Thanks.
 
 
Best regards,
 
James

Venlig hilsen

Thomas Kragh, Udvikler


A part of KMD 

Stigsborgvej 60, 9400 Nørresundby
E-mail t...@uvdata.dk  Web www.uvdata.dk
Telefon +45 72287030

Vi gør opmærksom på, at denne e-mail kan indeholde fortrolig information. Hvis 
du ved en fejltagelse modtager e-mailen, beder vi dig venligst informere 
afsender om fejlen ved at bruge svarfunktionen. Samtidig beder vi dig slette 
e-mailen i dit system uden at videresende eller kopiere den. Selvom e-mailen og 
ethvert vedhæftet bilag efter vores overbevisning er fri for virus og andre 
fejl, som kan påvirke computeren eller it-systemet, hvori den modtages og 
læses, åbnes den på modtagerens eget ansvar. Vi påtager os ikke noget ansvar 
for tab og skade, som er opstået i forbindelse med at modtage og bruge 
e-mailen. 
Please note that this message may contain confidential information. If you have 
received this message by mistake, please inform the sender of the mistake by 
sending a reply, then delete the message from your system without making, 
distributing or retaining any copies of it. Although we believe that the 
message and any attachments are free from viruses and other errors that might 
affect the computer or it-system where it is received and read, the recipient 
opens the message at his or her own risk. We assume no responsibility for any 
loss or damage arising from the receipt or use of this message.

[firebird-support] remote connection disconnection

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

Dear sir/madam,

I am testing Firebird 3.0 in Ubuntu as DB Server.
When application connects DB inside same network, everything works fine.
When application connects DB through Internet (using Dynu DDNS service), 
connection may lose if there is not operation after period.

I have checked firebird.conf and still not sure which parameter can avoid this 
issue.
Or this issue is caused from Ubuntu ddclient DDNS service?

Please give any advice to help me.
Thanks.


Best regards,

James

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

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

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: 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

[firebird-support] FB 2.5 migrate to 3.0

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

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