Re: [firebird-support] Re: Cannot open database file in local hard disk

2018-02-21 Thread Eduardo guse...@gmail.com [firebird-support] 

Hello everybody:

Evidently, as many of you said, the problem was related to the parameter 
DatabaseAccess in firebird.conf. The strange thing is that this 
parameter was commented. So it should be the predetermined value, which 
I think is "Full". Now it is again commented and it is working. It is 
strange, but it works!


Thank you very much to everyone!!!

Another strange thing. I received some of your mails many hours later. 
For example, the mail from "Marsupilami79 marsupilam...@gmx.de" has date 
and time 20/02/2018 11:27 (am) but I received it this morning. The same 
thing happened with other mails.



 Mensaje original 
*Asunto: *Re: [firebird-support] Re: Cannot open database file in local 
hard disk

*De: *Eduardo 
*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 19:11


Good news!!!
With the tip of Neil I found a strange solution. I did the following:

Try to open a database file with IB_SQL. I couldn't.
Restart Firebird service.
Try to open a database file with IB_SQL. I couldn't.
Make a copy of the original Firebird.conf, which has the commented 
line #DatabaseAccess = Full.

In Firebird.conf, uncomment the line DatabaseAccess = Full.
Restart Firebird service.
Try to open a database file with IB_SQL. I could!
Delete the modified Firebird.conf and restore the original one, which 
has the commented line #DatabaseAccess = Full.

Restart Firebird service.
Try to open a database file with IB_SQL. I could!

Conclusion: Now I have the same Firebird.conf as an hour ago, but 
everything is working fine.



 Mensaje original 
*Asunto: *Re: [firebird-support] Re: Cannot open database file in 
local hard disk

*De: *Eduardo 
*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 16:35


As you say, that sounds to be related, but unfortunately I found that 
line commented as it is by default. Every line related with 
DatabaseAccess is commented. I even compared the whole file 
firebird.conf with the one in another computer with the same Windows 
(in which one I don't have the problem), and they are identical.


I thought of restarting Firebird anyway, but I can´t do it now 
because there are people working. I will do it later.



 Mensaje original 
*Asunto: *Re: [firebird-support] Re: Cannot open database file in 
local hard disk
*De: *'Neil Pickles' neil.pick...@csy.co.uk [firebird-support] 


*A: *
*Fecha: *20/02/2018 14:49


In your firebird.conf file, is the following line uncommented (# removed
from the start), if it is add the hash, restart Firebird and try again.

# DatabaseAccess = None

According to the notes in the default firebird.conf file having that
line enabled would mean only files referenced in aliases.conf could be
opened which sounds a lot like your problem.

# Database Paths/Directories

#

# DatabaseAccess may be None, Full or Restrict. If you choose Restrict,

# provide ';'-separated trees list, where database files are stored.

# Relative paths are treated relative to RootDirectory entry

# (see above). Default value 'Full' gives full access to all files

# on your site. To specify access to specific trees, enum all required

# paths (for Win32 this may be something like 'C:\DataBase;D:\Mirror',

# for unix - '/db;/mnt/mirrordb'). If you choose 'None', then only

# databases listed in aliases.conf can be attached.

Regards,

Neil Pickles

Technical Director

CSY House, 9-10 Chase Park, Daleside Road, Nottingham, NG2 4GT

T: 0115 911 1677 M: 07801 316711 F: 0115 959 0959

--
--

@csyretail 
www.csy.co.uk  n...@csy.co.uk


Registered in England No. 2391386, Vat No GB 520 7385 59, Registered
Address: CSY House, 9-10 Chase Park, Daleside Road, Nottingham, NG2 4GT.
Tel 0115 948 4848, Fax 0115 959 0959.

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 20 February 2018 17:36
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Cannot open database file in local
hard disk

In every computers I tried there is exactly the same version of Firebird
installed: 2.1.4.18393 32 bits.

The databases where generated with the same version of Firebird. And
remember that if I use an alias, I can open the database. The problem is
when I try to open it using the path of the database file C:\Test\...
..FDB.

I can even generate the database in the same computer (using an alias)
and then I cannot open it using the path of the database file.

 Mensaje original 
Asunto: Re: [firebird-support] Re: Cannot open database file in local
hard disk
De: 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]


A:

Re: [firebird-support] Re: Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 

Good news!!!
With the tip of Neil I found a strange solution. I did the following:

Try to open a database file with IB_SQL. I couldn't.
Restart Firebird service.
Try to open a database file with IB_SQL. I couldn't.
Make a copy of the original Firebird.conf, which has the commented line 
#DatabaseAccess = Full.

In Firebird.conf, uncomment the line DatabaseAccess = Full.
Restart Firebird service.
Try to open a database file with IB_SQL. I could!
Delete the modified Firebird.conf and restore the original one, which 
has the commented line #DatabaseAccess = Full.

Restart Firebird service.
Try to open a database file with IB_SQL. I could!

Conclusion: Now I have the same Firebird.conf as an hour ago, but 
everything is working fine.



 Mensaje original 
*Asunto: *Re: [firebird-support] Re: Cannot open database file in local 
hard disk

*De: *Eduardo 
*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 16:35


As you say, that sounds to be related, but unfortunately I found that 
line commented as it is by default. Every line related with 
DatabaseAccess is commented. I even compared the whole file 
firebird.conf with the one in another computer with the same Windows 
(in which one I don't have the problem), and they are identical.


I thought of restarting Firebird anyway, but I can´t do it now because 
there are people working. I will do it later.



 Mensaje original 
*Asunto: *Re: [firebird-support] Re: Cannot open database file in 
local hard disk
*De: *'Neil Pickles' neil.pick...@csy.co.uk [firebird-support] 


*A: *
*Fecha: *20/02/2018 14:49


In your firebird.conf file, is the following line uncommented (# removed
from the start), if it is add the hash, restart Firebird and try again.

# DatabaseAccess = None

According to the notes in the default firebird.conf file having that
line enabled would mean only files referenced in aliases.conf could be
opened which sounds a lot like your problem.

# Database Paths/Directories

#

# DatabaseAccess may be None, Full or Restrict. If you choose Restrict,

# provide ';'-separated trees list, where database files are stored.

# Relative paths are treated relative to RootDirectory entry

# (see above). Default value 'Full' gives full access to all files

# on your site. To specify access to specific trees, enum all required

# paths (for Win32 this may be something like 'C:\DataBase;D:\Mirror',

# for unix - '/db;/mnt/mirrordb'). If you choose 'None', then only

# databases listed in aliases.conf can be attached.

Regards,

Neil Pickles

Technical Director

CSY House, 9-10 Chase Park, Daleside Road, Nottingham, NG2 4GT

T: 0115 911 1677 M: 07801 316711 F: 0115 959 0959

--
--

@csyretail 
www.csy.co.uk  n...@csy.co.uk


Registered in England No. 2391386, Vat No GB 520 7385 59, Registered
Address: CSY House, 9-10 Chase Park, Daleside Road, Nottingham, NG2 4GT.
Tel 0115 948 4848, Fax 0115 959 0959.

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 20 February 2018 17:36
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Cannot open database file in local
hard disk

In every computers I tried there is exactly the same version of Firebird
installed: 2.1.4.18393 32 bits.

The databases where generated with the same version of Firebird. And
remember that if I use an alias, I can open the database. The problem is
when I try to open it using the path of the database file C:\Test\...
..FDB.

I can even generate the database in the same computer (using an alias)
and then I cannot open it using the path of the database file.

 Mensaje original 
Asunto: Re: [firebird-support] Re: Cannot open database file in local
hard disk
De: 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]


A: 

Fecha: 20/02/2018 14:04



You're not switching between 32 bit and 64 bit versions of
Firebird are you?



I'm not sure exactly when the change occurred but I remember
similar issues trying to open a 32 bit generated database with a 64 bit
version of Firebird or vice versa. It's definitely okay with v2.5 but
not sure about v2.1 as it's been some time since I use v2.1 for
anything.



When you open it successfully on another computer, is it the
same bitness of Firebird, 32 bit or 64 bit?



Cheers,



Neil Pickles



From: firebird-support@yahoogroups.com [
mailto:firebird-support@yahoogroups.com]
Sent: 20 February 2018 14:05
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Cannot open database file in
local hard disk





Just a little correction to my message. Where I wrote

Re: [firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 
Yes, I tried indicating the name or IP of the server but it didn't work. 
The only way to open the databases is using an alias.



 Mensaje original 
*Asunto: *Re: [firebird-support] Cannot open database file in local hard 
disk
*De: *Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] 
<firebird-support@yahoogroups.com>

*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 12:29

Hello,

Did you try some thing like this :

IBODatabase1.Path := your GDB or FDB filename with path...;

IF SERVER_<>'' then // NAME or IP of  the server
   IBODatabase1.Server:=SERVER_ else
IBODatabase1.Server:=PC_NAME; //localhost
if not IBODatabase1.Connected then
   IBODatabase1.Connect;

(using SYSDBA and masterkey.. or user)

Best Regards,
MLCVISTA


Le ‎mardi‎ ‎20‎ ‎février‎ ‎2018‎ ‎16‎:‎09‎:‎33‎ ‎CET, Eduardo 
guse...@gmail.com [firebird-support] 
<firebird-support@yahoogroups.com> a écrit :



Thanks for your suggestion.

The user have total control of the file and the folder. I can modify 
it and even delete it. I tried moving the file to other folders and I 
tried with many FDB files. If I copy the FDB to another computer with 
Firebird, then I can open it without any problem. So the problem seems 
to be related to the computer.


I use Firebird 2.1 since many years ago and it works well. That's why 
I didn´t change it already.



 Mensaje original 
*Asunto: *[firebird-support] Cannot open database file in local hard disk
*De: *Rustam rusta...@ukr.net <mailto:rusta...@ukr.net> 
[firebird-support] <firebird-support@yahoogroups.com> 
<mailto:firebird-support@yahoogroups.com>
*A: *firebird-support@yahoogroups.com 
<mailto:firebird-support@yahoogroups.com>

*Fecha: *20/02/2018 11:09


1) Check user access rights on DB folder/file and account, under 
which Firebird server is running

2) Why you don't use latest 2.5.8 version of Firebird?




alt 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 
	Libre de virus. www.avast.com 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 



<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>





---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

[firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 

Hello:

I use Firebird 2.1 and in some computers I cannot open a database file 
which is in the local hard disk.


For example, let's suppose I have the database C:\Test\MYDATABASE.FDB 
and I try to open it with IB_SQL (from IBObjects).


If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable database".

If I modify firebird.conf creating the alias 
MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can open the 
database.


In almost every computer with any Windows version (XP, 7, 10, 2003, 
2008, 2012, 2016) I can open the database using every one of the four 
methods, but in some computers the first three methods return 
"unavailable database" and I can open the database only using an alias. 
Now I am having the problem in a computer with Windows Server 2008 R2 
Standard with Service Pack 1, but I remember having this problem in 
other computers from time to time.


Any ideas of which may be the reason? ... and the solution?

Thanks in advance. Regards

Eduardo



---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Re: Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 
As you say, that sounds to be related, but unfortunately I found that 
line commented as it is by default. Every line related with 
DatabaseAccess is commented. I even compared the whole file 
firebird.conf with the one in another computer with the same Windows (in 
which one I don't have the problem), and they are identical.


I thought of restarting Firebird anyway, but I can´t do it now because 
there are people working. I will do it later.



 Mensaje original 
*Asunto: *Re: [firebird-support] Re: Cannot open database file in local 
hard disk
*De: *'Neil Pickles' neil.pick...@csy.co.uk [firebird-support] 


*A: *
*Fecha: *20/02/2018 14:49


In your firebird.conf file, is the following line uncommented (# removed
from the start), if it is add the hash, restart Firebird and try again.

# DatabaseAccess = None

According to the notes in the default firebird.conf file having that
line enabled would mean only files referenced in aliases.conf could be
opened which sounds a lot like your problem.

# Database Paths/Directories

#

# DatabaseAccess may be None, Full or Restrict. If you choose Restrict,

# provide ';'-separated trees list, where database files are stored.

# Relative paths are treated relative to RootDirectory entry

# (see above). Default value 'Full' gives full access to all files

# on your site. To specify access to specific trees, enum all required

# paths (for Win32 this may be something like 'C:\DataBase;D:\Mirror',

# for unix - '/db;/mnt/mirrordb'). If you choose 'None', then only

# databases listed in aliases.conf can be attached.

Regards,

Neil Pickles

Technical Director

CSY House, 9-10 Chase Park, Daleside Road, Nottingham, NG2 4GT

T: 0115 911 1677 M: 07801 316711 F: 0115 959 0959

--
--

@csyretail 
www.csy.co.uk  n...@csy.co.uk


Registered in England No. 2391386, Vat No GB 520 7385 59, Registered
Address: CSY House, 9-10 Chase Park, Daleside Road, Nottingham, NG2 4GT.
Tel 0115 948 4848, Fax 0115 959 0959.

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 20 February 2018 17:36
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Cannot open database file in local
hard disk

In every computers I tried there is exactly the same version of Firebird
installed: 2.1.4.18393 32 bits.

The databases where generated with the same version of Firebird. And
remember that if I use an alias, I can open the database. The problem is
when I try to open it using the path of the database file C:\Test\...
..FDB.

I can even generate the database in the same computer (using an alias)
and then I cannot open it using the path of the database file.

 Mensaje original 
Asunto: Re: [firebird-support] Re: Cannot open database file in local
hard disk
De: 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]


A: 

Fecha: 20/02/2018 14:04



You're not switching between 32 bit and 64 bit versions of
Firebird are you?



I'm not sure exactly when the change occurred but I remember
similar issues trying to open a 32 bit generated database with a 64 bit
version of Firebird or vice versa. It's definitely okay with v2.5 but
not sure about v2.1 as it's been some time since I use v2.1 for
anything.



When you open it successfully on another computer, is it the
same bitness of Firebird, 32 bit or 64 bit?



Cheers,



Neil Pickles



From: firebird-support@yahoogroups.com [
mailto:firebird-support@yahoogroups.com]
Sent: 20 February 2018 14:05
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Cannot open database file in
local hard disk





Just a little correction to my message. Where I wrote
firebird.conf, I should have written aliases.conf.



 Mensaje original 
Asunto: Cannot open database file in local hard disk
De: Eduardo  
A: firebird-support@yahoogroups.com
Fecha: 20/02/2018 10:57

Hello:

I use Firebird 2.1 and in some computers I cannot open a
database file which is in the local hard disk.

For example, let's suppose I have the database
C:\Test\MYDATABASE.FDB and I try to open it with IB_SQL (from
IBObjects).

If I use C:\Test\MYDATABASE.FDB I get "unavailable
database".
If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get
"unavailable database".
If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB
 I get
"unavailable database".

If I modify firebird.conf creating the alias
MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can open the
database.

In almost every computer with any Windows version (XP,
7, 10, 2003, 2008, 2012, 2016) I can open the database using every one
of

Re: [firebird-support] Re: Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 
In every computers I tried there is exactly the same version of Firebird 
installed: 2.1.4.18393 32 bits.


The databases where generated with the same version of Firebird. And 
remember that if I use an alias, I can open the database. The problem is 
when I try to open it using the path of the database file C:\Test\... .FDB.


I can even generate the database in the same computer (using an alias) 
and then I cannot open it using the path of the database file.



 Mensaje original 
*Asunto: *Re: [firebird-support] Re: Cannot open database file in local 
hard disk
*De: *'Neil Pickles' neil.pick...@csy.co.uk [firebird-support] 


*A: *
*Fecha: *20/02/2018 14:04


You’re not switching between 32 bit and 64 bit versions of Firebird 
are you?


I’m not sure exactly when the change occurred but I remember similar 
issues trying to open a 32 bit generated database with a 64 bit 
version of Firebird or vice versa. It’s definitely okay with v2.5 but 
not sure about v2.1 as it’s been some time since I use v2.1 for anything.


When you open it successfully on another computer, is it the same 
bitness of Firebird, 32 bit or 64 bit?


Cheers,

*Neil Pickles*

*From:*firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com]

*Sent:* 20 February 2018 14:05
*To:* firebird-support@yahoogroups.com
*Subject:* [firebird-support] Re: Cannot open database file in local 
hard disk


Just a little correction to my message. Where I wrote firebird.conf, I 
should have written aliases.conf.


 Mensaje original 
*Asunto: *Cannot open database file in local hard disk
*De: *Eduardo  
*A: *firebird-support@yahoogroups.com 


*Fecha: *20/02/2018 10:57

Hello:

I use Firebird 2.1 and in some computers I cannot open a database
file which is in the local hard disk.

For example, let's suppose I have the database
C:\Test\MYDATABASE.FDB and I try to open it with IB_SQL (from
IBObjects).

If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable
database".
If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB
 I get
"unavailable database".

If I modify firebird.conf creating the alias
MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can
open the database.

In almost every computer with any Windows version (XP, 7, 10,
2003, 2008, 2012, 2016) I can open the database using every one of
the four methods, but in some computers the first three methods
return "unavailable database" and I can open the database only
using an alias. Now I am having the problem in a computer with
Windows Server 2008 R2 Standard with Service Pack 1, but I
remember having this problem in other computers from time to time.

Any ideas of which may be the reason? ... and the solution?

Thanks in advance. Regards

Eduardo





Libre de virus. www.avast.com 
 








---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 

Thanks for your suggestion.

The user have total control of the file and the folder. I can modify it 
and even delete it. I tried moving the file to other folders and I tried 
with many FDB files. If I copy the FDB to another computer with 
Firebird, then I can open it without any problem. So the problem seems 
to be related to the computer.


I use Firebird 2.1 since many years ago and it works well. That's why I 
didn´t change it already.



 Mensaje original 
*Asunto: *[firebird-support] Cannot open database file in local hard disk
*De: *Rustam rusta...@ukr.net [firebird-support] 


*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 11:09


1) Check user access rights on DB folder/file and account, under which 
Firebird server is running

2) Why you don't use latest 2.5.8 version of Firebird?






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

[firebird-support] Re: Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 
Just a little correction to my message. Where I wrote firebird.conf, I 
should have written aliases.conf.



 Mensaje original 
*Asunto: *Cannot open database file in local hard disk
*De: *Eduardo 
*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 10:57


Hello:

I use Firebird 2.1 and in some computers I cannot open a database file 
which is in the local hard disk.


For example, let's suppose I have the database C:\Test\MYDATABASE.FDB 
and I try to open it with IB_SQL (from IBObjects).


If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable database"..

If I modify firebird.conf creating the alias 
MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can open 
the database.


In almost every computer with any Windows version (XP, 7, 10, 2003, 
2008, 2012, 2016) I can open the database using every one of the four 
methods, but in some computers the first three methods return 
"unavailable database" and I can open the database only using an 
alias. Now I am having the problem in a computer with Windows Server 
2008 R2 Standard with Service Pack 1, but I remember having this 
problem in other computers from time to time.


Any ideas of which may be the reason? ... and the solution?

Thanks in advance. Regards

Eduardo





---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

[firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 

Hello:

I use Firebird 2.1 and in some computers I cannot open a database file 
which is in the local hard disk.


For example, let's suppose I have the database C:\Test\MYDATABASE.FDB 
and I try to open it with IB_SQL (from IBObjects).


If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable database".

If I modify firebird.conf creating the alias 
MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can open the 
database.


In almost every computer with any Windows version (XP, 7, 10, 2003, 
2008, 2012, 2016) I can open the database using every one of the four 
methods, but in some computers the first three methods return 
"unavailable database" and I can open the database only using an alias. 
Now I am having the problem in a computer with Windows Server 2008 R2 
Standard with Service Pack 1, but I remember having this problem in 
other computers from time to time.


Any ideas of which may be the reason? ... and the solution?

Thanks in advance. Regards

Eduardo



---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2016-01-01 Thread Eduardo guse...@gmail.com [firebird-support] 

I am not an expert in these subjects. I am just learning. :-)

But that's just what I understood. They recommend to disable disk write 
cache when installing SQL Server because of the potential risk of data 
loss and they also talk about enhanced caching controller systems which 
provide cache with less risk.


In my opinion it´s not easy to say if cache is good or bad. If you don´t 
have an "enhanced caching controller", then what is better? To enable or 
to disable disk cache?


Cache is very good for performance. But may be bad if "something" 
happens and there is data loss. It depends on the probability of this 
"something" to happen.


I've been using Firebird for many years in many servers with disk cache 
enabled and I don´t remember having problems.


I was just wondering if the difference in performance with disk cache 
enabled or disabled is similar in others RDBMS.


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Alexey Kovyazin a...@ib-aid.com [firebird-support] 


*Para: *firebird-support@yahoogroups.com
*Fecha: *31/12/2015 21:54


Eduardo,

Did you read this?
"Enhanced caching controller systems disable on-disk cache and provide 
a functional battery-backed caching solution."


The idea of this article that battery-backed cache solutions should be 
used, instead of drives with simple cache.
It does not tell that cache is bad, just highlights the potential risk 
of data loss if caching without BBU is used.


So, essentially you need to buy advanced disk controller and properly 
setup it - that's true.


Regards,
Alexey Kovyazin
IBSurgeon



There is an interesting (and quite long) article about SQL Server and 
disk cache in MS site.


https://support.microsoft.com/en-us/kb/234656

They talk about "enhanced caching controllers" and they say things 
like the following:


  * /- SQL Server installations are targeted at systems that provide
caching controllers. These controllers disable the on-disk caches
and provide stable media caches to satisfy SQL Server I/O
requirements./
  * /- Your SQL Server installation depends on the controller's
ability to disable the on-disk cache and to provide a stable I/O
cache./
  * /- Note: If you have any question about the caching status of
your disk drive, contact the manufacturer and obtain the
appropriate utility or jumper settings to disable write caching
operations./

You even can see a list of different HD drive types (IDE, ATA, SATA, 
SCSI) with instructions to disable disk cache. In any of them you 
will see the following phrase:


  * /- Disk caching should be disabled in order to use the drive with
SQL Server./


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in 
Windows Server 2012
*De: *Alexey Kovyazin a...@ib-aid.com [firebird-support] 


*Para: *firebird-support@yahoogroups.com
*Fecha: *31/12/2015 15:22


Hi Eduardo,

Can you please give links to these articles?

Regards,
Alexey Kovyazin
IBSurgeon




I searched in Google and found that, for instance, MS suggests not 
to install SQL Server in a domain controller, but for security 
reasons. In some articles, MS even recommends to disable disk write 
cache when installing SQL Server.


I searched information about others RDBMS and generally they 
recommend to disable disk write cache to ensure database integrity. 
This seems reasonably. That´s why I am surprised about the 
difference in performance.


Regards

Eduardo





 
	Este correo electrónico se ha enviado desde un equipo libre de virus 
y protegido por Avast.
www.avast.com 
 










---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-31 Thread Eduardo guse...@gmail.com [firebird-support] 
It seems a good idea but I am not the one who configure the server in 
this case and I am not sure if they would like to do that. But, if they 
do that, can I enable disk cache in a VM that is phisically in the same 
disk as another VM which is PDC? The disk cache belongs to the VM or the 
physical disk?


Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Louis Van Alphen lo...@nucleo.co.za [firebird-support] 


*Para: *firebird-support@yahoogroups.com 
*Fecha: *31/12/2015 10:01
What about virtual environments? If one vm on host is pdc and other vm 
is db server?


Sent from my iPhone

On 31 Dec 2015, at 2:39, "'Carlos H. Cantu' lis...@warmboot.com.br 
 [firebird-support]" 
> wrote:




	I know, but that's impossible to do on that server. So the only 
solution I found so far is to install the application in another 
computer.


But anyway I would like to understand why this is necessary in 
Firebird. It would be great if anybody knows the answers to my 
questions of my previous message.




Why do you think the problem only happens with Firebird? Use Google 
and you will find documents from Microsoft telling to not install 
MSSQL Server in PDC machines. As I said before, any write intensive 
application (like RDBMS) will suffer with no cache.








---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-31 Thread Eduardo guse...@gmail.com [firebird-support] 
There is an interesting (and quite long) article about SQL Server and 
disk cache in MS site.


https://support.microsoft.com/en-us/kb/234656

They talk about "enhanced caching controllers" and they say things like 
the following:


 * /- SQL Server installations are targeted at systems that provide
   caching controllers. These controllers disable the on-disk caches
   and provide stable media caches to satisfy SQL Server I/O requirements./
 * /- Your SQL Server installation depends on the controller's ability
   to disable the on-disk cache and to provide a stable I/O cache./
 * /- Note: If you have any question about the caching status of your
   disk drive, contact the manufacturer and obtain the appropriate
   utility or jumper settings to disable write caching operations./

You even can see a list of different HD drive types (IDE, ATA, SATA, 
SCSI) with instructions to disable disk cache. In any of them you will 
see the following phrase:


 * /- Disk caching should be disabled in order to use the drive with
   SQL Server./


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Alexey Kovyazin a...@ib-aid.com [firebird-support] 


*Para: *firebird-support@yahoogroups.com
*Fecha: *31/12/2015 15:22


Hi Eduardo,

Can you please give links to these articles?

Regards,
Alexey Kovyazin
IBSurgeon




I searched in Google and found that, for instance, MS suggests not to 
install SQL Server in a domain controller, but for security reasons. 
In some articles, MS even recommends to disable disk write cache when 
installing SQL Server.


I searched information about others RDBMS and generally they 
recommend to disable disk write cache to ensure database integrity. 
This seems reasonably. That´s why I am surprised about the difference 
in performance.


Regards

Eduardo








---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 
Thank you for the link. I read it but they don´t ensure that in a second 
disk you can enable write cache. Anyway on this server there is only one 
disk.


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] 


*Para: *firebird-support@yahoogroups.com 
*Fecha: *30/12/2015 16:58




> The other is the fact that PDC machine will always have write cache 
disabled.


It seems that this is not true for all disks attached to PDC server, 
only to boot/Windows drive.


https://social.technet.microsoft.com/Forums/windowsserver/en-US/16352eee-6bc6-4858-8642-12b2496d39ee/how-to-enable-write-caching-on-domain-controller?forum=winserverDS 




Sean






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 
I know, but that's impossible to do on that server. So the only solution 
I found so far is to install the application in another computer.


But anyway I would like to understand why this is necessary in Firebird. 
It would be great if anybody knows the answers to my questions of my 
previous message.


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *fabianoas...@gmail.com [firebird-support] 


*Para: *firebird-support@yahoogroups.com
*Fecha: *30/12/2015 11:57


Eduardo. You problem only will be solved by turning on write cache if 
possible or switching to a new cache write enabled server. Dot.

Do not change anything in your software.

Em 30/12/2015 12:15, "Eduardo guse...@gmail.com 
 [firebird-support]" 
> escreveu:


I read that disabling forced writes is not safe.

But there is something that I really don´t understand.

If I disable forced writes, then when I make commits, data goes to
the RAM of the server and afterwards, in some moment, the data
will be physically written to the database.

If I enable disk write cache, then things happen the same way. So,
what is the difference?

From what I read, I think the difference is that with disk write
cache, Windows manages when to physically write the data but, when
disabling forced writes it is not guaranteed that Windows will
physically write the data. Is this true?

Another question. Why is so different the performance with disk
write cache enabled or disabled? Is this something that happens in
every RDBMS or is just a Firebird problem?

Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in
Windows Server 2012
*De: *Ann Harrison aharri...@ibphoenix.com
 [firebird-support]


*Para: *firebird-support@yahoogroups.com



*Fecha: *29/12/2015 17:26

On Tue, Dec 29, 2015 at 2:44 PM, Macma mac...@wp.pl
 [firebird-support]
> wrote:




Do I have to change any configuration or the matter is that
if I can´t enable disk cache, there is nothing I can do to
improve the performance?


Try to disable force write on that database.


After you have a UPS installed and an aggressive backup schedule.

Good luck,

Ann




Este correo electrónico se ha enviado desde un equipo libre de
virus y protegido por Avast.
www.avast.com









---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 
No, this is not the solution. One of the firs things I do when I install 
my application is to create firewall rules for ports 3050 and 3051. In 
this case I even deactivate the firewall but nothing changed.


My english is not perfect, but I can´t write in portuguese!


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Suporte TGA Rio Verde - GO suportetga...@outlook.com 
[firebird-support] 

*Para: *firebird-support@yahoogroups.com
*Fecha: *30/12/2015 07:24
Olha aqui já tivemos esse problema. Apenas liberamos as portas do 
firebird no firewall do Windows server 2012 funcionou.
Libera as portas 3050 e 3051 tpc e udp, entrada e saída, tenho certeza 
que vai funcionar.


Desculpa mas não escrevo muito bem em inglês então escrevi em 
português mesmo.

*Adalton Batista*
(64) 3612-0066 / 3623-0646
*www.tgasistemasrv.com.br *
suportetga...@outlook.com
ryle...@gmail.com 






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 

I read that disabling forced writes is not safe.

But there is something that I really don´t understand.

If I disable forced writes, then when I make commits, data goes to the 
RAM of the server and afterwards, in some moment, the data will be 
physically written to the database.


If I enable disk write cache, then things happen the same way. So, what 
is the difference?


From what I read, I think the difference is that with disk write cache, 
Windows manages when to physically write the data but, when disabling 
forced writes it is not guaranteed that Windows will physically write 
the data. Is this true?


Another question. Why is so different the performance with disk write 
cache enabled or disabled? Is this something that happens in every RDBMS 
or is just a Firebird problem?


Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Ann Harrison aharri...@ibphoenix.com [firebird-support] 


*Para: *firebird-support@yahoogroups.com 
*Fecha: *29/12/2015 17:26
On Tue, Dec 29, 2015 at 2:44 PM, Macma mac...@wp.pl 
 [firebird-support] 
> wrote:





Do I have to change any configuration or the matter is that if I
can´t enable disk cache, there is nothing I can do to improve the
performance?


Try to disable force write on that database.


After you have a UPS installed and an aggressive backup schedule.

Good luck,

Ann





---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-25 Thread Eduardo guse...@gmail.com [firebird-support] 

OK, thank you. I understand.

I tried deinstalling 2.1.4 and installing 2.1.7. But the performance was 
the same. Nothing improved! :-(


Do I have to change any configuration or the matter is that if I can´t 
enable disk cache, there is nothing I can do to improve the performance?


Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] 
<firebird-support@yahoogroups.com>
*Para: *Eduardo guse...@gmail.com [firebird-support] 
<firebird-support@yahoogroups.com>

*Fecha: *24/12/2015 14:50


One cache problem is the one mentioned in the article, fixed in 2.1.5, 
etc.


The other is the fact that PDC machine will always have write cache 
disabled.


Carlos
www.firebirdnews.org <http://www.firebirdnews.org>- 
www.FireBase.com.br <http://www.FireBase.com.br>






Carlos:

Thank you for your answer.

I suggested to not configure the server as a domain controller but the 
person who decide this didn´t want!


I already read the article you mention and there is where I found that 
apparently upgrading to 2.1.5 will solve the problem but I was not 
sure. So if I upgrade, the performance would be similar as if disk 
cache was enabled?


I don´t understand what do you mean saying "The cache problem you are 
referring to is another thing". Are there TWO cache problems? Which is 
THE OTHER? Please, can you explain me?


Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in 
Windows Server 2012
*De: *'Carlos H. Cantu' lis...@warmboot.com.br 
<mailto:lis...@warmboot.com.br>[firebird-support] 
<firebird-support@yahoogroups.com> 
<mailto:firebird-support@yahoogroups.com>
*Para: *Eduardo guse...@gmail.com 
<mailto:guse...@gmail.com>[firebird-support] 
<firebird-support@yahoogroups.com> 
<mailto:firebird-support@yahoogroups.com>

*Fecha: *24/12/2015 12:47

Never use Firebird (or any RDBMS) in a PDC machine! Windows will 
always disable write disk cache in PDC, and it will be very bad for 
any write sensitive application, like databases (not only Firebird).


The cache problem you are referring to is another thing, and to solve 
this one, you need to upgrade to 2.1.5 (at last): 
http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html 



Carlos
www.firebirdnews.org <http://www.firebirdnews.org>- 
www.FireBase.com.br <http://www.FireBase.com.br>







Hi guys:

I have an application developped in Delphi that uses Firebird 
Superserver 2.1.4.18393.


It is installed in a Windows network. During many years, the server 
had Windows Server 2003 and everything worked fine. Some time ago they 
changed it temporarily to another PC with Windows 8.1. Everything 
worked fine.


A few days ago they installed a new server with Windows Server 2012. 
My application is working, but it works very slow. It has a log file 
and I verified that the bad performance occurs in every data base 
access, when it opens a database, when it executes any SQL, etc.


I did a little research and found that, apparently, the problem is 
related with the disk cache. In the old servers, disk cache was 
enabled but in the new one with Windows Server 2012 it is disabled 
and, as the server is configured as a domain controller, as far as I 
know, it can´t be enabled.


I read some articles about problems similar to this one and apparently 
this is a problem related with Firebird. In some articles they said 
that since version 2.1.5 this is solved. ¿Is this true?


¿Updating to 2.1.5 will solve the problem?

¿Is there something I can do to solve this without updating?

Any suggestions will be welcome!

Regards

Eduardo

	Este correo electrónico se ha enviado desde un equipo libre de virus 
y protegido por Avast.
www.avast.com 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 









	Este correo electrónico se ha enviado desde un equipo libre de virus 
y protegido por Avast.
www.avast.com 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 











---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-24 Thread Eduardo guse...@gmail.com [firebird-support] 

Carlos:

Thank you for your answer.

I suggested to not configure the server as a domain controller but the 
person who decide this didn´t want!


I already read the article you mention and there is where I found that 
apparently upgrading to 2.1.5 will solve the problem but I was not sure. 
So if I upgrade, the performance would be similar as if disk cache was 
enabled?


I don´t understand what do you mean saying "The cache problem you are 
referring to is another thing". Are there TWO cache problems? Which is 
THE OTHER? Please, can you explain me?


Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] 
<firebird-support@yahoogroups.com>
*Para: *Eduardo guse...@gmail.com [firebird-support] 
<firebird-support@yahoogroups.com>

*Fecha: *24/12/2015 12:47


Never use Firebird (or any RDBMS) in a PDC machine! Windows will 
always disable write disk cache in PDC, and it will be very bad for 
any write sensitive application, like databases (not only Firebird).


The cache problem you are referring to is another thing, and to solve 
this one, you need to upgrade to 2.1.5 (at last): 
http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html 



Carlos
www.firebirdnews.org <http://www.firebirdnews.org>- 
www.FireBase.com.br <http://www.FireBase.com.br>






Hi guys:

I have an application developped in Delphi that uses Firebird 
Superserver 2.1.4.18393.


It is installed in a Windows network. During many years, the server 
had Windows Server 2003 and everything worked fine. Some time ago they 
changed it temporarily to another PC with Windows 8.1. Everything 
worked fine.


A few days ago they installed a new server with Windows Server 2012. 
My application is working, but it works very slow. It has a log file 
and I verified that the bad performance occurs in every data base 
access, when it opens a database, when it executes any SQL, etc.


I did a little research and found that, apparently, the problem is 
related with the disk cache. In the old servers, disk cache was 
enabled but in the new one with Windows Server 2012 it is disabled 
and, as the server is configured as a domain controller, as far as I 
know, it can´t be enabled.


I read some articles about problems similar to this one and apparently 
this is a problem related with Firebird. In some articles they said 
that since version 2.1.5 this is solved. ¿Is this true?


¿Updating to 2.1.5 will solve the problem?

¿Is there something I can do to solve this without updating?

Any suggestions will be welcome!

Regards

Eduardo

	Este correo electrónico se ha enviado desde un equipo libre de virus 
y protegido por Avast.
www.avast.com 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 











---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

[firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-24 Thread Eduardo guse...@gmail.com [firebird-support] 

Hi guys:

I have an application developped in Delphi that uses Firebird 
Superserver 2.1.4.18393.


It is installed in a Windows network. During many years, the server had 
Windows Server 2003 and everything worked fine. Some time ago they 
changed it temporarily to another PC with Windows 8.1. Everything worked 
fine.


A few days ago they installed a new server with Windows Server 2012. My 
application is working, but it works very slow. It has a log file and I 
verified that the bad performance occurs in every data base access, when 
it opens a database, when it executes any SQL, etc.


I did a little research and found that, apparently, the problem is 
related with the disk cache. In the old servers, disk cache was enabled 
but in the new one with Windows Server 2012 it is disabled and, as the 
server is configured as a domain controller, as far as I know, it can´t 
be enabled.


I read some articles about problems similar to this one and apparently 
this is a problem related with Firebird. In some articles they said that 
since version 2.1.5 this is solved. ¿Is this true?


¿Updating to 2.1.5 will solve the problem?

¿Is there something I can do to solve this without updating?

Any suggestions will be welcome!

Regards

Eduardo


---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Writing to Aliases.conf in non-admin mode

2015-10-23 Thread Eduardo guse...@gmail.com [firebird-support] 
I did what (I think is what) you need many years ago. I don´t remember 
exactly the details, but this is still working. What I did was the 
following:


When my application initiates, it checks if there exists a database 
named MYAPPLICATIONCONFIGURACION.FDB. If it doesn't exist, it creates 
it. When the application creates the database, it creates 3 UDFs 
executing SQLs begining with "DECLARE EXTERNAL FUNCTION ..."


The UDFs are the following (the names are in spanish):

MMudfUbicacionDelAlias
It is called with a parameter "Alias". It opens the file aliases.conf, 
look for the alias and returns a string with the path of the database.


MMudfPudeEstablecerAlias
It is called with a parameter "Alias" and a parameter "Path". It opens 
the file aliases.conf, and adds a new line with Alias=Path.


MMudfPudeCrearDirectorio
It is called with a parameter "Directory". It creates a folder in the 
hard disk with the name indicated.


In the file aliases.conf, there is a line MYAPPLICATIONCONFIGURACION = 
C:\...\MYAPPLICATIONCONFIGURACION.FDB.



When a user wants to create a new database, the application opens the 
database MYAPPLICATIONCONFIGURACION and executes the following SQL:


SELECT MMudfPudeEstablecerAlias('Alias','Path') FROM RDB$DATABASE

This can be done using the application in the server or in any client PC 
of the newtork.


Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Writing to Aliases.conf in non-admin mode
*De: *Stefan Heymann li...@stefanheymann.de [firebird-support] 


*Para: *firebird-support@yahoogroups.com
*Fecha: *23/10/2015 12:28


Bhavbhuti,

> My application allows users to create a database and it's entry in
> aliases.conf is created by the application. This essentially is
> fine and works well in Admin mode, as soon as the same is tried to
> be done using the normal non-admin mode I am not able to update 
aliases.conf


> Question is, in normal user mode, is there a way to update
> aliases.conf using some FireBird API? or any other way?

I don't know of any method that allows this. The aliases.conf file
belongs to the administration/configuration of Firebird and that's why
it can only be modified by an administrator.

It should be possible to change to access rights (once, by an
administrator) so "everybody" can have write access to the
aliases.conf file.

Regards

Stefan






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] firebird service terminated unexpectedly

2015-09-29 Thread Eduardo guse...@gmail.com [firebird-support] 

Thank you for your answer.

May be upgrading will solve the problem but, for what you say, it is not 
sure that 2.1.7 will be the solution.


Anyway, it is strange that the same version in many other similar 
networks has no problem. Even in the same network it was working without 
problems many years till 05/2015. And it is still working in many others 
with the same version of Windows.


It would be interesting to know the reason of the problem. I searched in 
Google and found that this may be related with some hardware, a switch 
or something like this. It´s a possibility...


Does anyone know something about which may be the reason of this problem?

Regards

 Mensaje original 
*Asunto: *Re: [firebird-support] firebird service terminated unexpectedly
*De: *Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
<firebird-support@yahoogroups.com>

*Para: *<firebird-support@yahoogroups.com>
*Fecha: *29/09/2015 04:41


On Mon, 28 Sep 2015 17:51:08 -0300, "Eduardo guse...@gmail.com
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> Hello:
>
> I have an application developped in Delphi that uses Firebird
> 2.1.4.18393 SuperServer.
>
> The application is running well in many enterprises. But there is one
> place where there is a problem. They have a server with Windows and 4
> client computers with Windows. They have been using the application
> since 2011 without problems. But since May 2015, almost every day it
> happens that many times Firebird service terminates unexpectedly.
> Sometimes it happens once in a day, sometimes twice or may be more.
>
> It is not at regular times. Many times it happens at, for instance,
> 03:00am, when nobody is working and the only computer turned on is the
> server.
>
> In the Windows event viewer, each time this happens, I see an event with

> the text "Firebird Server - DefaultInstance service terminated
> unexpectedly.".
>
> In Firebird.log there are some messages that may be usefull. I copy some

> at the end of this message.
>
> Till 10 days ago, the server had Windows Server 2003. Now they changed
> the server for a new one and installed Windows Server 2008 R2 64bits.
> They changed the server just trying to solve this problem, but the
> problem is still there. Every day Firebird service terminates many
times.
>
> Any idea of which may cause Firebird service termination?

At minimum, upgrade to 2.1.7 as it there have been several crashes fixed
since 2.1.4. However I have seen a similar problem with 2.1.7 as well. You
might have no choice but to upgrade to 2.5.4 (or 2.5.5 that will be
released in the near future).

The log seems to indicate that something or someone is sending malformed
packets to the Firebird server, but given the time between its occurrence
and the actual crash, I am not sure if that is the reason. Similar 
problems

were the reason for releasing 2.5.3 Security Update. As far as I know this
fix ended up in Firebird 2.1.7 as well, but I am not sure if this is
actually the same problem.

Mark






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

[firebird-support] firebird service terminated unexpectedly

2015-09-28 Thread Eduardo guse...@gmail.com [firebird-support] 

Hello:

I have an application developped in Delphi that uses Firebird 
2.1.4.18393 SuperServer.


The application is running well in many enterprises. But there is one 
place where there is a problem. They have a server with Windows and 4 
client computers with Windows. They have been using the application 
since 2011 without problems. But since May 2015, almost every day it 
happens that many times Firebird service terminates unexpectedly. 
Sometimes it happens once in a day, sometimes twice or may be more.


It is not at regular times. Many times it happens at, for instance, 
03:00am, when nobody is working and the only computer turned on is the 
server.


In the Windows event viewer, each time this happens, I see an event with 
the text "Firebird Server - DefaultInstance service terminated 
unexpectedly.".


In Firebird.log there are some messages that may be usefull. I copy some 
at the end of this message.


Till 10 days ago, the server had Windows Server 2003. Now they changed 
the server for a new one and installed Windows Server 2008 R2 64bits. 
They changed the server just trying to solve this problem, but the 
problem is still there. Every day Firebird service terminates many times.


Any idea of which may cause Firebird service termination?

Regards

Eduardo

--

_Firebird.log_

SERVER (Client)Mon Sep 28 09:03:16 2015
XNET error: Server shutdown detected


SERVER (Server)Mon Sep 28 11:23:30 2015
*** DUMP ***


SERVER (Server)Mon Sep 28 11:23:30 2015
Fatal exception during clumplet dump: Invalid clumplet buffer 
structure: spb in service attach should begin with isc_spb_version1 or 
isc_spb_version



SERVER (Server)Mon Sep 28 11:23:30 2015
Plain dump starting with offset 983: 
GksPJENZNIDEigHQSgHlBaxYtdNhDVTXEZwEJubMj



SERVER (Server)Mon Sep 28 11:23:30 2015
Database: unknown, SERVER/process_packet
Invalid clumplet buffer structure: buffer end before end of 
clumplet - clumplet too long



SERVER (Server)Mon Sep 28 12:10:37 2015
*** DUMP ***


SERVER (Server)Mon Sep 28 12:10:37 2015
Fatal exception during clumplet dump: Invalid clumplet buffer 
structure: spb in service attach should begin with isc_spb_version1 or 
isc_spb_version



SERVER (Server)Mon Sep 28 12:10:37 2015
Plain dump starting with offset 965: 
eacLvKmymBXVTdwXcxSlcnBkqndimqhDqsLzBEjhvhPJPUECuKFdaPfzUFv



SERVER (Server)Mon Sep 28 12:10:37 2015
Database: unknown, SERVER/process_packet
Invalid clumplet buffer structure: buffer end before end of 
clumplet - clumplet too long



SERVER (Server)Mon Sep 28 12:19:17 2015
INET/inet_error: read errno = 10054


SERVER (Client)Mon Sep 28 12:20:56 2015
XNET error: Server shutdown detected


SERVER (Server)Mon Sep 28 14:29:51 2015
*** DUMP ***


SERVER (Server)Mon Sep 28 14:29:51 2015
Fatal exception during clumplet dump: Invalid clumplet buffer 
structure: spb in service attach should begin with isc_spb_version1 or 
isc_spb_version



SERVER (Server)Mon Sep 28 14:29:51 2015
Plain dump starting with offset 866: 
kjdTvwFtjygUYsGFuXXmYkgPvVRBTveCkjHwSEhjsFQmoCyqYJXVuf



SERVER (Server)Mon Sep 28 14:29:54 2015
INET/inet_error: read errno = 10054


SERVER (Server)Mon Sep 28 14:38:12 2015
INET/inet_error: read errno = 10054


SERVER (Client)Mon Sep 28 14:40:54 2015
XNET error: Server shutdown detected



---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Unlock record

2015-02-16 Thread Eduardo guse...@gmail.com [firebird-support] 
I am still trying to find a way to unlock a record when the PC that 
locked it (using SELECT ... WITH LOCK) hanged...


I thought the following:

The user who executed the SELECT ... WITH LOCK started a transaction. 
When his PC hanged, this transaction remains active.


Is there a way to identify this transaction and rollback it? May be 
deleting or modifying something in a MON$ table or in another way?


 Mensaje original 
*Asunto: *Re: [firebird-support] Unlock record
*De: *Eduardo guse...@gmail.com
*Para: *firebird-support@yahoogroups.com
*Fecha: *02/02/2015 17:28

Thank you for your answer.

I agree with you. Firebird should allow for all/any attachment to be 
deleted.


Closing the application to unlock the record is not the solution I am 
looking for. My problem is when there are many users using the 
application, then one of them hangs his PC with a record locked and 
then the only way to unlock it, is to tell every user to close the 
application and reinitiate Firebird service which is a very 
uncomfortable solution.


 Mensaje original 
*Asunto: *Re: [firebird-support] Unlock record
*De: *'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] 
firebird-support@yahoogroups.com
*Para: *firebird-support@yahoogroups.com 
firebird-support@yahoogroups.com

*Fecha: *02/02/2015 14:49


Eduardo,

 I add some information to my previous mail. When I try to delete 
the record

 of MON$ATTACHMENTS, the complete message I got is the following:

 SQL ERROR CODE:-817

 SQL ERROR MESSAGE:
 The insert, update, delete, ddl or authorization statement cannot
  be executed because the transaction is inquiry only

It seems that monitoring table functions do not allow for read-only 
attachments to be deleted/killed.


Very interesting.

1- The fact that the WITH LOCK option was used makes what otherwise 
should be a simple SELECT statement much more significant, but the 
message suggest that read-only statements should be ignored (although 
supported WITH LOCK is very uncommon usage, so may not have been 
considered)


2- IMO, the functionality should allow for all/any attachment to be 
deleted. The purpose of the feature is to all such attachments to be 
managed in such a fashion -- there should be no restrictions.


 Any other idea to unlock a record?

Close have your application commit transaction or close your application.

Sean








---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
http://www.avast.com

Re: [firebird-support] Unlock record

2015-02-02 Thread Eduardo guse...@gmail.com [firebird-support] 

Thank you for your answer.

I agree with you. Firebird should allow for all/any attachment to be 
deleted.


Closing the application to unlock the record is not the solution I am 
looking for. My problem is when there are many users using the 
application, then one of them hangs his PC with a record locked and 
then the only way to unlock it, is to tell every user to close the 
application and reinitiate Firebird service which is a very 
uncomfortable solution.


 Mensaje original 
*Asunto: *Re: [firebird-support] Unlock record
*De: *'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] 
firebird-support@yahoogroups.com

*Para: *firebird-support@yahoogroups.com firebird-support@yahoogroups.com
*Fecha: *02/02/2015 14:49


Eduardo,

 I add some information to my previous mail. When I try to delete the 
record

 of MON$ATTACHMENTS, the complete message I got is the following:

 SQL ERROR CODE:-817

 SQL ERROR MESSAGE:
 The insert, update, delete, ddl or authorization statement cannot
  be executed because the transaction is inquiry only

It seems that monitoring table functions do not allow for read-only 
attachments to be deleted/killed.


Very interesting.

1- The fact that the WITH LOCK option was used makes what otherwise 
should be a simple SELECT statement much more significant, but the 
message suggest that read-only statements should be ignored (although 
supported WITH LOCK is very uncommon usage, so may not have been 
considered)


2- IMO, the functionality should allow for all/any attachment to be 
deleted. The purpose of the feature is to all such attachments to be 
managed in such a fashion -- there should be no restrictions.


 Any other idea to unlock a record?

Close have your application commit transaction or close your application.

Sean






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
http://www.avast.com

Re: [firebird-support] Unlock record

2015-02-02 Thread Eduardo guse...@gmail.com [firebird-support] 
I add some information to my previous mail. When I try to delete the 
record of MON$ATTACHMENTS, the complete message I got is the following:


SQL ERROR CODE:-817

SQL ERROR MESSAGE:
The insert, update, delete, ddl or authorization statement cannot
 be executed because the transaction is inquiry only

Any other idea to unlock a record?

 Mensaje original 
*Asunto: *Re: [firebird-support] Unlock record
*De: *Eduardo guse...@gmail.com
*Para: *firebird-support@yahoogroups.com
*Fecha: *26/01/2015 00:10

I tried what you said doing the following:

- Opened my application.
- Executed the option which locks a record (executes a SELECT * FROM 
TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK).

- Opened the database with IB_SQL.
- Identified the record of MON$ATTACHMENTS table associated with my 
application.

- Try to delete this record.
- I got the error message operation not supported.

Am I doing something wrong or I must do some other thing before 
deleting that record?



 Mensaje original 
*Asunto: *Re: [firebird-support] Unlock record
*De: *Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no 
[firebird-support] firebird-support@yahoogroups.com
*Para: *firebird-support@yahoogroups.com 
firebird-support@yahoogroups.com

*Fecha: *24/01/2015 11:50


I saw the same as you, and made the following test:

- Opened my application.
- Executed the option which locks a record (executes a SELECT * FROM 
TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK).

- Opened the database with IB_SQL.
- Looked in table MON$STATEMENTS. I found many records. Many of them 
with MON$SQL_TEXT null. Only one of them had MON$TIMESTAMP not null.

- I deleted the only record with MON$TIMESTAMP not null.
- I opened another instance of IB_SQL and verified that the record I 
locked at the first step was still locked.


Am I undestanding something wrong or this doesn´t work?

Another idea to manually unlock a record?

Regards

Eduardo

Finally got temporary access to a computer and can confirm that 
deleting from mon$statements is not enough when using WITH LOCK (I 
never use WITH LOCK myself). However, I did get access to this record 
(using Fb 2.5) by deleting from MON$ATTACHMENTS. There may or may not 
be other, less intrusive ways to get such access, though I failed 
when I tried MON$TRANSACTIONS.


Set








---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
http://www.avast.com

Re: [firebird-support] Unlock record

2015-01-25 Thread Eduardo guse...@gmail.com [firebird-support] 

I tried what you said doing the following:

- Opened my application.
- Executed the option which locks a record (executes a SELECT * FROM 
TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK).

- Opened the database with IB_SQL.
- Identified the record of MON$ATTACHMENTS table associated with my 
application.

- Try to delete this record.
- I got the error message operation not supported.

Am I doing something wrong or I must do some other thing before deleting 
that record?



 Mensaje original 
*Asunto: *Re: [firebird-support] Unlock record
*De: *Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no 
[firebird-support] firebird-support@yahoogroups.com

*Para: *firebird-support@yahoogroups.com firebird-support@yahoogroups.com
*Fecha: *24/01/2015 11:50


I saw the same as you, and made the following test:

- Opened my application.
- Executed the option which locks a record (executes a SELECT * FROM 
TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK).

- Opened the database with IB_SQL.
- Looked in table MON$STATEMENTS. I found many records. Many of them 
with MON$SQL_TEXT null. Only one of them had MON$TIMESTAMP not null.

- I deleted the only record with MON$TIMESTAMP not null.
- I opened another instance of IB_SQL and verified that the record I 
locked at the first step was still locked.


Am I undestanding something wrong or this doesn´t work?

Another idea to manually unlock a record?

Regards

Eduardo

Finally got temporary access to a computer and can confirm that 
deleting from mon$statements is not enough when using WITH LOCK (I 
never use WITH LOCK myself). However, I did get access to this record 
(using Fb 2.5) by deleting from MON$ATTACHMENTS. There may or may not 
be other, less intrusive ways to get such access, though I failed when 
I tried MON$TRANSACTIONS.


Set






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
http://www.avast.com

Re: [firebird-support] I don´t receive my messages

2015-01-21 Thread Eduardo guse...@gmail.com [firebird-support] 
I searched it and found that, as some of you said, it's how gmail works. 
It is explained in gmail support site:


https://support.google.com/mail/answer/6588?hl=en

Thanks for those who answered.

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] I don´t receive my messages
*De: *Carlos Tré ceus...@gmail.com [firebird-support] 
firebird-support@yahoogroups.com

*Para: *firebird-support@yahoogroups.com
*Fecha: *20/01/2015 17:10



I've learned that this is a gmail thing, it has to do with the way 
they process list messages. I may be wrong, but I believe there isn't 
much one can do about it.


Best,
Carlos


On 20/01/2015 17:49, Eduardo guse...@gmail.com [firebird-support] wrote:

Hello:

Yesterday I sent an e-mail to the list but I didn´t receive it. I 
received other mails from the list but didn´t receive my own message.


Today I received an answer to my message and I sent a new mail. Again 
I didn´t received my own message.


I am subscribed since many years ago but I recently changed my e-mail 
address. May be this is the reason? I have just sent an e-mail to 
firebird-support-subscr...@yahoogroups.com but received an answer 
saying I am already a member of this group and my request will not be 
processed.


What may be the problem (and the solution)?

Regards

Eduardo


http://www.avast.com/   

El software de antivirus Avast ha analizado este correo electrónico 
en busca de virus.

www.avast.com http://www.avast.com/









---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
http://www.avast.com

Re: SV: [firebird-support] Unlock record

2015-01-20 Thread Eduardo guse...@gmail.com [firebird-support] 
I looked in a database, and in MON$STATEMENTS tabla I have the following 
fields:


MON$STATEMENT_ID
MON$ATTACHMENT_ID
MON$TRANSACTION_ID
MON$STATE
MON$TIMESTAMP
MON$SQL_TEXT
MON$STAT_ID

How can I detect which is the record I have to delete to unlock my 
record? This is the only table I have to modify?


Eduardo

 Mensaje original 
*Asunto: *SV: [firebird-support] Unlock record
*De: *Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no 
[firebird-support] firebird-support@yahoogroups.com

*Para: *firebird-support@yahoogroups.com firebird-support@yahoogroups.com
*Fecha: *20/01/2015 06:43


 May be I can modify or delete some record in any MON$ table or do 
some other thing?


I typically locate and delete records from MON$STATEMENTS. Mind you, 
that is 2.5 and typically when I have a long-running query. Don't know 
whether deleting from this table is possible or safe with 2.1 or 
sensible WITH LOCK.


HTH,

Set






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
http://www.avast.com

[firebird-support] I don´t receive my messages

2015-01-20 Thread Eduardo guse...@gmail.com [firebird-support] 

Hello:

Yesterday I sent an e-mail to the list but I didn´t receive it. I 
received other mails from the list but didn´t receive my own message.


Today I received an answer to my message and I sent a new mail. Again I 
didn´t received my own message.


I am subscribed since many years ago but I recently changed my e-mail 
address. May be this is the reason? I have just sent an e-mail to 
firebird-support-subscr...@yahoogroups.com but received an answer saying 
I am already a member of this group and my request will not be processed.


What may be the problem (and the solution)?

Regards

Eduardo


---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
http://www.avast.com

[firebird-support] Unlock record

2015-01-19 Thread Eduardo guse...@gmail.com [firebird-support] 

Hello:

I have an application in Delphi that uses Firebird 2.1 SuperServer. For 
some operations I use a SELECT like the following:


SELECT * FROM TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK

As you can see, I use WITH LOCK to lock the record. Then, when the 
application executes a commit or a rollback, the record unlocks.


Sometimes happens that a user PC hangs and then the record remains 
locked. Then, the only solution I found is to tell every user to close 
the application and reinitiate Firebird service.


Is there a way to unlock the record without reinitiating Firebird service?

I usually use IB_SQL to manage Firebird databases. May be I can modify 
or delete some record in any MON$ table or do some other thing? Is this 
possible?


Regards

Eduardo


---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
http://www.avast.com