Re: [fpc-devel] Bug in IBConnection?

2011-05-18 Thread LacaK 
this error message isc_shutdown is throw during isc_attach_database and 
so it seems, that your database is in shutdown mode
(which prevents you attach ... but I do not understand why you can 
success fuly attach using ssh?)

See http://www.firebirdnews.org/?p=234
  http://www.destructor.de/firebird/gfix.htm
Laco.


 -database /usr/path_to_database/TEST.IB shutdown
  $00488EFB
  $0048A1E1
  $00489C98

What can be causing this error?
  


___
fpc-devel maillist  -  fpc-devel@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-devel

Re: [fpc-devel] Bug in IBConnection?

2011-05-18 Thread Leonardo M . Ramé 
-- On Wed, 5/18/11, LacaK la...@zoznam.sk wrote:
 From: LacaK la...@zoznam.sk
 Subject: Re: [fpc-devel] Bug in IBConnection?
 To: FPC developers' list fpc-devel@lists.freepascal.org
 Date: Wednesday, May 18, 2011, 4:05 AM

 this error message isc_shutdown is
 throw during isc_attach_database and so it seems, that your
 database is in shutdown mode
 (which prevents you attach ... 

Thanks, I found the log firebird.log file was growing too much and consumed 
all my /var partition free space. 

 but I do not understand why you can success fuly attach using ssh?)
 See http://www.firebirdnews.org/?p=234
       http://www.destructor.de/firebird/gfix.htm
 Laco.

I don't attach trough SSH, with SSH I made a tunnel connection to my server, 
than attached from my machine to localhost on port 3050.


Leonardo M. Ramé
http://leonardorame.blogspot.com


___
fpc-devel maillist  -  fpc-devel@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-devel

[fpc-devel] Bug in IBConnection?

2011-05-17 Thread Leonardo M . Ramé 
Hi, I did an ssh tunnel to a remote server that has a Firebird 2.5 database, 
this way, my computer can connect to that database by simply pointing to 
'localhost', this works when I connect through FlameRobin, but I can't make it 
work using this simple program:

program dbtest;
{$mode objfpc}
uses
  Classes, SysUtils, IBConnection, sqldb;

var
  IBConnection1: TIBConnection;
  SQLTransaction1: TSQLTransaction;
  lSql: TSQLQuery;

begin
  IBConnection1 := TIBConnection.Create(nil);
  IBConnection1.DatabaseName := 'test';
  IBConnection1.UserName := 'SYSDBA';
  IBConnection1.Password := 'masterkey';
  IBConnection1.HostName := 'localhost';
  IBConnection1.CharSet := 'UTF8';
  IBConnection1.LoginPrompt := False;
  IBConnection1.Connected := True;
  IBConnection1.Free;
end.

When I run it, I get this exception:

An unhandled exception occurred at $00488EFB :
EIBDatabaseError :  : DoInternalConnect : 
 -database /usr/path_to_database/TEST.IB shutdown
  $00488EFB
  $0048A1E1
  $00489C98

What can be causing this error?

P.S.: I'm connecting from an Ubuntu 10.10 64bits box with libfbclient2 ver 
2.5.0.26074-0.ds4-4, and the server is a FreeBSD 8.2 64bits with Firebird 2.5. 

Thanks in advance,
Leonardo M. Ramé
http://leonardorame.blogspot.com
___
fpc-devel maillist  -  fpc-devel@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-devel