Re: [firebird-support] Migrating a 2.5 server

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

Sean,

Sorry, but I thought it was in the context.

2017-02-07 12:09 GMT-03:00 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] :

>
>
> Luke
>
> > I would like to add a sub-topic in this discussion: currently, I'm using
> the
> > nbackup tool to run full/incremental backup. I'll have to update the
> Linux box
> > from CentOS 5.7 (2011) to Ubuntu 16.04 (current LTS). Considering both
> has
> > Firebird 2.5.x, is there any issue related to backup/restore the
> database file
> > in this scenario that I need to know before proceeding with the server
> > update?
>
> Create a separate thread
>
> Don't muddle an existing conversation to discuss something which is
> completely unrelated!!!
>
>
>
> Sean
> 
>



-- 
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] Migrating a 2.5 server

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

Luke

> I would like to add a sub-topic in this discussion: currently, I'm using the
> nbackup tool to run full/incremental backup. I'll have to update the Linux box
> from CentOS 5.7 (2011) to Ubuntu 16.04 (current LTS). Considering both has
> Firebird 2.5.x, is there any issue related to backup/restore the database file
> in this scenario that I need to know before proceeding with the server
> update?

Create a separate thread

Don't muddle an existing conversation to discuss something which is completely 
unrelated!!!



Sean

Re: [firebird-support] Migrating a 2.5 server

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

Hi folks,

I would like to add a sub-topic in this discussion: currently, I'm using
the nbackup tool to run full/incremental backup. I'll have to update the
Linux box from CentOS 5.7 (2011) to Ubuntu 16.04 (current LTS). Considering
both has Firebird 2.5.x, is there any issue related to backup/restore the
database file in this scenario that I need to know before proceeding with
the server update?

I usually read people here suggesting the use of gbak and rarely
suggestions to use nbackup. I have read the manual and for me nbackup is
better because I can execute full/incremental backups. Any comment here?

Em 7 de fev de 2017 06:53, "Luke Crooks l...@solentwholesale.com
[firebird-support]"  escreveu:

>
>
> Thanks Lester,
>
> Due to the TA+ Software not doing what we want completely, I have already
> written a web front end to the database which performs quickly (as
> expected) but that's from a FreeBSD client (either to Windows or FreeBSD
> Firebird server), so it must be something on the Windows (10) client end
> that is causing the slow connection to remote machines.
>
> The network architecture is over engineered for the nature of the site, I
> am even doing firebird mappings direct with Static IP's over machine names
> and still getting issues. SafeScan have provided 2 updates in the last 6
> months (to which we are using) so I imagine this must be either a Windows
> client issue or just poorly written software from SafeScan.
>
> @Dimitry
>
> I moved FireBird onto a different (dedicated SQL server) and the same
> performance issues were apparent.
>
>
> Regards,
> --
> Luke Crooks
> Solent Wholesale Carpets
> www.solentwholesale.com
>
> On Tue, Feb 7, 2017 at 9:44 AM, Lester Caine les...@lsces.co.uk
> [firebird-support]  wrote:
>
>>
>>
>> On 07/02/17 08:14, Luke Crooks l...@solentwholesale.com
>> [firebird-support] wrote:
>> > When running the 2.5 server on our Windows DC and having clients access
>> > from the local network, performance was very slow (almost unusable). We
>> > are using a safescan product (Time Attendance +) which uses a firebird
>> > database. So to combat this, I first tried serving the file locally on a
>> > machine and accessing it this way, no performance issues here.
>> >
>> > So I then had the idea that it could be that our windows server has to
>> > much load already, so I installed firebird on our onsite dedicated SQL
>> > server (this server is much quicker by comparison, 8 cores, 32GB of ram
>> > and runs postgres for us with loads of resources to spare). So I
>> > installed firebird on this SQL server (FreeBSD), configured the software
>> > to point to the new database, and yet again the performance is awful,
>> > does anyone have an idea what might be causing such slow speeds when
>> > connecting to a database locally? I can't see the firewall blocking
>> > anything and have given full access to port 3050, thanks.
>>
>> I have a similar sort of legacy product which started life on a local
>> windows box at each site and eventually progressed to running via a
>> remote Linux server with local windows clients. Some sites we had
>> problems with slow connection times, and it was invariably due to the
>> network configuration. Looking up IP addresses from machine names which
>> is not something that should be a problem, but switching those sites to
>> use static IP addresses invariably sorted things out.
>>
>> But since TA+ seems to be running as a windows client application, it
>> may be having fun with some of the more recent developments in Windows
>> OS. So what version of Windows are you running on? I would expect
>> Safescan to provide updates to cope with the M$ aspects of their product
>> since they are charging for it ;) My client interfaces moved to web
>> based 15 odd years ago to remove THAT management problem ... and
>> Firebird continues to provide a response time in the fractions of a
>> second on my systems.
>>
>> --
>> Lester Caine - G8HFL
>> -
>> Contact - http://lsces.co.uk/wiki/?page=contact
>> L.S.Caine Electronic Services - http://lsces.co.uk
>> EnquirySolve - http://enquirysolve.com/
>> Model Engineers Digital Workshop - http://medw.co.uk
>> Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
>>
>
> 
>

Re: [firebird-support] Migrating a 2.5 server

[Luke Crooks l...@solentwholesale.com [firebird-support]]

Thanks Lester,

Due to the TA+ Software not doing what we want completely, I have already
written a web front end to the database which performs quickly (as
expected) but that's from a FreeBSD client (either to Windows or FreeBSD
Firebird server), so it must be something on the Windows (10) client end
that is causing the slow connection to remote machines.

The network architecture is over engineered for the nature of the site, I
am even doing firebird mappings direct with Static IP's over machine names
and still getting issues. SafeScan have provided 2 updates in the last 6
months (to which we are using) so I imagine this must be either a Windows
client issue or just poorly written software from SafeScan.

@Dimitry

I moved FireBird onto a different (dedicated SQL server) and the same
performance issues were apparent.


Regards,
--
Luke Crooks
Solent Wholesale Carpets
www.solentwholesale.com

On Tue, Feb 7, 2017 at 9:44 AM, Lester Caine les...@lsces.co.uk
[firebird-support]  wrote:

>
>
> On 07/02/17 08:14, Luke Crooks l...@solentwholesale.com
> [firebird-support] wrote:
> > When running the 2.5 server on our Windows DC and having clients access
> > from the local network, performance was very slow (almost unusable). We
> > are using a safescan product (Time Attendance +) which uses a firebird
> > database. So to combat this, I first tried serving the file locally on a
> > machine and accessing it this way, no performance issues here.
> >
> > So I then had the idea that it could be that our windows server has to
> > much load already, so I installed firebird on our onsite dedicated SQL
> > server (this server is much quicker by comparison, 8 cores, 32GB of ram
> > and runs postgres for us with loads of resources to spare). So I
> > installed firebird on this SQL server (FreeBSD), configured the software
> > to point to the new database, and yet again the performance is awful,
> > does anyone have an idea what might be causing such slow speeds when
> > connecting to a database locally? I can't see the firewall blocking
> > anything and have given full access to port 3050, thanks.
>
> I have a similar sort of legacy product which started life on a local
> windows box at each site and eventually progressed to running via a
> remote Linux server with local windows clients. Some sites we had
> problems with slow connection times, and it was invariably due to the
> network configuration. Looking up IP addresses from machine names which
> is not something that should be a problem, but switching those sites to
> use static IP addresses invariably sorted things out.
>
> But since TA+ seems to be running as a windows client application, it
> may be having fun with some of the more recent developments in Windows
> OS. So what version of Windows are you running on? I would expect
> Safescan to provide updates to cope with the M$ aspects of their product
> since they are charging for it ;) My client interfaces moved to web
> based 15 odd years ago to remove THAT management problem ... and
> Firebird continues to provide a response time in the fractions of a
> second on my systems.
>
> --
> Lester Caine - G8HFL
> -
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk
> Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
> 
>

Re: [firebird-support] Migrating a 2.5 server

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

07.02.2017 9:14, Luke Crooks l...@solentwholesale.com [firebird-support] wrote:
> When running the 2.5 server on our Windows DC and having clients access from 
> the local
> network, performance was very slow (almost unusable).

   System HDD on DC has write cache forcefully disabled. Put database to 
different HDD or, 
better yet, on different server.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Migrating a 2.5 server

[Lester Caine les...@lsces.co.uk [firebird-support]]

On 07/02/17 08:14, Luke Crooks l...@solentwholesale.com
[firebird-support] wrote:
> When running the 2.5 server on our Windows DC and having clients access
> from the local network, performance was very slow (almost unusable). We
> are using a safescan product (Time Attendance +) which uses a firebird
> database. So to combat this, I first tried serving the file locally on a
> machine and accessing it this way, no performance issues here.
> 
> So I then had the idea that it could be that our windows server has to
> much load already, so I installed firebird on our onsite dedicated SQL
> server (this server is much quicker by comparison, 8 cores, 32GB of ram
> and runs postgres for us with loads of resources to spare). So I
> installed firebird on this SQL server (FreeBSD), configured the software
> to point to the new database, and yet again the performance is awful,
> does anyone have an idea what might be causing such slow speeds when
> connecting to a database locally? I can't see the firewall blocking
> anything and have given full access to port 3050, thanks.

I have a similar sort of legacy product which started life on a local
windows box at each site and eventually progressed to running via a
remote Linux server with local windows clients. Some sites we had
problems with slow connection times, and it was invariably due to the
network configuration. Looking up IP addresses from machine names which
is not something that should be a problem, but switching those sites to
use static IP addresses invariably sorted things out.

But since TA+ seems to be running as a windows client application, it
may be having fun with some of the more recent developments in Windows
OS. So what version of Windows are you running on? I would expect
Safescan to provide updates to cope with the M$ aspects of their product
since they are charging for it ;) My client interfaces moved to web
based 15 odd years ago to remove THAT management problem ... and
Firebird continues to provide a response time in the fractions of a
second on my systems.

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

Re: [firebird-support] Migrating a 2.5 server

[Luke Crooks l...@solentwholesale.com [firebird-support]]

Thanks everyone, I needed to make the file transportable.

Separate question...

When running the 2.5 server on our Windows DC and having clients access
from the local network, performance was very slow (almost unusable). We are
using a safescan product (Time Attendance +) which uses a firebird
database. So to combat this, I first tried serving the file locally on a
machine and accessing it this way, no performance issues here.

So I then had the idea that it could be that our windows server has to much
load already, so I installed firebird on our onsite dedicated SQL server
(this server is much quicker by comparison, 8 cores, 32GB of ram and runs
postgres for us with loads of resources to spare). So I installed firebird
on this SQL server (FreeBSD), configured the software to point to the new
database, and yet again the performance is awful, does anyone have an idea
what might be causing such slow speeds when connecting to a database
locally? I can't see the firewall blocking anything and have given full
access to port 3050, thanks.


Regards,
--
Luke Crooks
Solent Wholesale Carpets
www.solentwholesale.com

On Mon, Feb 6, 2017 at 8:17 PM, 'Ismael L. Donis Garcia' sli...@natio.co.cu
[firebird-support] <firebird-support@yahoogroups.com> wrote:

>
>
> 
> In Windows
>
> gbak -b -t -user SYSDBA -pas adminpassword C:\database\database.fdb
> database.fbk
>
> In Linux
>
> gbak -c -user SYSDBA -pas adminpassword 
> /var/lib/firebird/2.5/data/database.fbk
> /var/lib/firebird/2.5/data/database.fdb
>
>
> Saludos
> 
> | ISMAEL |
> 
>
>
> - Original Message -
> *From:* Luke Crooks l...@solentwholesale.com [firebird-support]
> <l...@solentwholesale.com+[firebird-support]>
> *To:* firebird-support@yahoogroups.com
> *Sent:* Monday, February 06, 2017 6:24 AM
> *Subject:* [firebird-support] Migrating a 2.5 server
>
>
>
> So currently I have firebird 2.5 installed and running on Windows, working
> fine but performance is a bit slow.
>
> I have installed 2.5 on Ubuntu, and I can connect to the current database
> with ISQL easily:
>
> connect "192.168.155.112:C:\database\database.FDB" user 'SYSDBA' password 
> 'adminpassword';
>
> So I stopped the firebird services on the Windows server, copied the file
> to the Ubuntu server, and in isql tried to run:
>
> SQL> connect "localhost:/var/lib/firebird/2.5/data/database.FDB" user 
> 'SYSDBA' password 'adminpassword';
> Statement failed, SQLSTATE = m
> file /var/lib/firebird/2.5/data/database.FDB is not a valid database
>
> Note I have so far tried:
>
> ~$ sudo adduser `id -un` firebird
> [sudo] password for luke:
> The user `luke' is already a member of `firebird'.
>
> As well as
>
> # chown firebird /var/lib/firebird/2.5/data/database.fdb
>
> With no luck, if anyone has any idea as to why I might be getting this
> error, I would be very grateful :)
>
> I am not sure if Super or Classic was used on Windows, however I have
> tried using both on Ubuntu with the same error message. Windows server
> version 2.5.6, same version on Linux
>
> Regards,
> --
> Luke Crooks
>
> 
>

Re: [firebird-support] Migrating a 2.5 server

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

In Windows


gbak -b -t -user SYSDBA -pas adminpassword C:\database\database.fdb database.fbk


In Linux


gbak -c -user SYSDBA -pas adminpassword /var/lib/firebird/2.5/data/database.fbk 
/var/lib/firebird/2.5/data/database.fdb




Saludos

| ISMAEL |



  - Original Message -
  From: Luke Crooks l...@solentwholesale.com [firebird-support]
  To: firebird-support@yahoogroups.com
  Sent: Monday, February 06, 2017 6:24 AM
  Subject: [firebird-support] Migrating a 2.5 server







  So currently I have firebird 2.5 installed and running on Windows, working 
fine but performance is a bit slow.


  I have installed 2.5 on Ubuntu, and I can connect to the current database 
with ISQL easily:


connect "192.168.155.112:C:\database\database.FDB" user 'SYSDBA' password 
'adminpassword';
So I stopped the firebird services on the Windows server, copied the file to 
the Ubuntu server, and in isql tried to run:


SQL> connect "localhost:/var/lib/firebird/2.5/data/database.FDB" user 'SYSDBA' 
password 'adminpassword';
Statement failed, SQLSTATE = m
file /var/lib/firebird/2.5/data/database.FDB is not a valid database
Note I have so far tried:


~$ sudo adduser `id -un` firebird
[sudo] password for luke:
The user `luke' is already a member of `firebird'.
As well as


# chown firebird /var/lib/firebird/2.5/data/database.fdb
With no luck, if anyone has any idea as to why I might be getting this error, I 
would be very grateful :)


  I am not sure if Super or Classic was used on Windows, however I have tried 
using both on Ubuntu with the same error message. Windows server version 2.5.6, 
same version on Linux






  Regards,
  --
  Luke Crooks








  

Re: [firebird-support] Migrating a 2.5 server

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

Tuesday, February 7, 2017, 9:35:55 AM, I wrote:

> 1. 'SQLSTATE = m' is not a valid error message in Firebird. You should
> be seeing a 5-character alphanumeric code where the 'm' is. Other
> DBMS's  use the same name for their SQL command-line apps so make sure
> you are running isql from the same location as the binary.

I forgot to remind you to preface the isql command with dot-slash if
you're running it from the binary directory.  If you don't, you're
going to get MySQL's isql regardless.

H.

Re: [firebird-support] Migrating a 2.5 server

['Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]]

[firebird-support] Migrating a 2.5 server

[Luke Crooks l...@solentwholesale.com [firebird-support]]

So currently I have firebird 2.5 installed and running on Windows, working
fine but performance is a bit slow.


I have installed 2.5 on Ubuntu, and I can connect to the current database
with ISQL easily:


connect "192.168.155.112:C:\database\database.FDB" user 'SYSDBA'
password 'adminpassword';


So I stopped the firebird services on the Windows server, copied the file
to the Ubuntu server, and in isql tried to run:


SQL> connect "localhost:/var/lib/firebird/2.5/data/database.FDB" user
'SYSDBA' password 'adminpassword';
Statement failed, SQLSTATE = m
file /var/lib/firebird/2.5/data/database.FDB is not a valid database


Note I have so far tried:


~$ sudo adduser `id -un` firebird
[sudo] password for luke:
The user `luke' is already a member of `firebird'.


As well as


# chown firebird /var/lib/firebird/2.5/data/database.fdb


With no luck, if anyone has any idea as to why I might be getting this
error, I would be very grateful :)


I am not sure if Super or Classic was used on Windows, however I have tried
using both on Ubuntu with the same error message. Windows server version
2.5.6, same version on Linux


Regards,
--
Luke Crooks