Re: [firebird-support] Firebird Server on Windows 10

[Mike Ro miker...@gmail.com [firebird-support]]

Dixon, many thanks for your help.

On 11/09/2015 20:21, 'E. D. Epperson Jr' dixonepper...@gmail.com 
[firebird-support] wrote:
At work and don't have Windows 10 or FirebirdSql here, so I can't test 
my theory.  But I suspect its permissions related.
There is a new feature on the properties dialog for files in Windows 
10.  Its a checkbox to unblock a file. Right click on the 
security.fdb, select Properties and see if that option is there.
No "unblock" check box is shown for security2.fdb. I forgot to mention 
previously that I changed the security properties to Allow: Full 
Control, Modify and Write for All Applications Packages, SYSTEM and 
Administrators.


But ...


On a more radical solution, try installing your firebirdsql to a 
folder NOT in Program Files.



Yes, this solves it!

So it is definitely a permissions thing, but I haven't been able to find 
out what yet.


Thanks again, at least I am up and running now.

Re: [firebird-support] Firebird Server on Windows 10

['E. D. Epperson Jr' dixonepper...@gmail.com [firebird-support]]

At work and don't have Windows 10 or FirebirdSql here, so I can't test my
theory.  But I suspect its permissions related.
There is a new feature on the properties dialog for files in Windows 10.
Its a checkbox to unblock a file.  Right click on the security.fdb, select
Properties and see if that option is there.

On a more radical solution, try installing your firebirdsql to a folder NOT
in Program Files.

Hope this helps

Dixon

On Fri, Sep 11, 2015 at 1:59 PM, Mike Ro miker...@gmail.com
[firebird-support]  wrote:

>
>
> I am trying to install a Firebird server on a reasonably clean Windows
> 10 machine, but I am running into the gsec "cannot attach to password
> database" issue.
>
> Details are:
>
> Edition: Windows 10 Pro (64-bit system, x64 based processor)
> Firebird: SuperServer - both 32-bit and 64-bit versions attempted
>
> Full error message (64-bit version) when running gsec from a command
> prompt with administrator privileges:
>
> C:\Program Files\Firebird\Firebird_2_5\bin>gsec -user sysdba -password
> masterkey
> use gsec -? to get help
> cannot attach to password database
> unable to open database
>
> Also tried gsec with
> -database "c:\Program Files\Firebird\Firebird_2_5\security2.fdb"
> and
> -database "localhost:c:\Program Files\Firebird\Firebird_2_5\security2.fdb"
> and
> -database localhost:"c:\Program Files\Firebird\Firebird_2_5\security2.fdb"
>
> Server running as a service (tried both 32-bit and 64-bit - uninstalling
> and rebooting in between)
>
> Service appears to be running correctly.
>
> Control panel applet is not installed.
>
> FIREBIRD environment variable not set, no Firebirds in either system or
> user PATH environment variables.
>
> I have tried everything I could find on Google without joy, so thank you
> in advance for any help with this!
>
> 
>



-- 
Dixon Epperson

Re: [firebird-support] Firebird Server on Windows 10

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

On 11/09/15 21:29, Mike Ro miker...@gmail.com [firebird-support] wrote:
>> On a more radical solution, try installing your firebirdsql to a
>> folder NOT in Program Files. 
>>
> Yes, this solves it!
> 
> So it is definitely a permissions thing, but I haven't been able to find
> out what yet.

Interesting. Seems I did the right thing without knowing ...
I've always put apache, php and firebird in their ow base directory
'c:\Network' originally to get away from the proelms cayse by the
'space' in 'Program Files'. But I've obviously it a winning setup
because the W10 install just worked for me!

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

[firebird-support] Growing security2.fdb

['Neil Pickles' neil.pick...@csy.co.uk [firebird-support]]

Hello

 

Something I have noticed with Firebird v2.1 with Windows 32 & 64 bit
Superserver & Classic and is that the security2.fdb file grows
substantially and keeps on growing.

 

We use just a single user for database access.

 

I have one system at the moment where it is 50Meg but have seen it at
200 meg or 300 meg or even larger.

 

Is this a problem, should it do this, why does it do this?

 

Any ideas?

 

Cheers,

 

Neil Pickles - n...@csy.co.uk  



 

Re: [firebird-support] Growing security2.fdb

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

Hi Neil,

Run DBInfo from IBSurgeon Free tools and check what pages are there.
I suppose there are many TIPS, which indicate transactions.
Verify it with gstat -h transaction markers values.

Regards,
Alexey Kovyazin
IBSurgeon



Hello

Something I have noticed with Firebird v2.1 with Windows 32 & 64 bit 
Superserver & Classic and is that the security2.fdb file grows 
substantially and keeps on growing.


We use just a single user for database access.

I have one system at the moment where it is 50Meg but have seen it at 
200 meg or 300 meg or even larger.


Is this a problem, should it do this, why does it do this?

Any ideas?

Cheers,

Neil Pickles - n...@csy.co.uk 

[firebird-support] Firebird Server on Windows 10

[Mike Ro miker...@gmail.com [firebird-support]]

I am trying to install a Firebird server on a reasonably clean Windows 
10 machine, but I am running into the gsec "cannot attach to password 
database" issue.

Details are:

Edition: Windows 10 Pro (64-bit system, x64 based processor)
Firebird: SuperServer - both 32-bit and 64-bit versions attempted

Full error message (64-bit version) when running gsec from a command 
prompt with administrator privileges:

C:\Program Files\Firebird\Firebird_2_5\bin>gsec -user sysdba -password 
masterkey
use gsec -? to get help
cannot attach to password database
unable to open database

Also tried gsec with
-database "c:\Program Files\Firebird\Firebird_2_5\security2.fdb"
and
-database "localhost:c:\Program Files\Firebird\Firebird_2_5\security2.fdb"
and
-database localhost:"c:\Program Files\Firebird\Firebird_2_5\security2.fdb"

Server running as a service (tried both 32-bit and 64-bit - uninstalling 
and rebooting in between)

Service appears to be running correctly.

Control panel applet is not installed.

FIREBIRD environment variable not set, no Firebirds in either system or 
user PATH environment variables.

I have tried everything I could find on Google without joy, so thank you 
in advance for any help with this!