Re: [firebird-support] fb_sort error

2012-09-17 Thread Thomas Steinmaurer
Hello, > Strange stuff from firebird I am hoping to get some insight on...please bear > with me while I describe the problem! > > I've run into a problem with a firebird installation that is using a 3rd > party report viewer to display crystal reports from a firebird db on client > PCs...this i

Re: [firebird-support] Periodic database slowdown - troubleshooting steps?

2012-09-17 Thread Thomas Steinmaurer
Hello Bob, >>> 1): The most obvious thing according to the header page is a very > large >>> gap between the oldest active transaction and the next transaction. > This >>> means, you have a long-running/stuck transaction. If you are lucky, > you >>> can go into the MON$TRANSACTIONS table and check

[firebird-support] fb_sort error

2012-09-17 Thread rolling_thudner
Strange stuff from firebird I am hoping to get some insight on...please bear with me while I describe the problem! I've run into a problem with a firebird installation that is using a 3rd party report viewer to display crystal reports from a firebird db on client PCs...this is a windows environ

RE: [firebird-support] Periodic database slowdown - troubleshooting steps?

2012-09-17 Thread Bob Murdoch
Thomas - -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer >> 1): The most obvious thing according to the header page is a very large >> gap between the oldest active transaction and the next transaction.

RE: [firebird-support] Periodic database slowdown - troubleshooting steps?

2012-09-17 Thread Bob Murdoch
Alexey - >> Alexey Kovyazin [mailto:a...@ib-aid.com] >> Seems like you do correct things, but do you check that sweep is really successful? >> >> Look at the transactions' markers log in IBTM (IBSurgeon Transaction Monitor), gathered from Profitmed >> database (120Gb, 400 clients, 2mln trans

Re: [firebird-support] Number of instances of firebird

2012-09-17 Thread Helen Borrie
At 05:34 AM 18/09/2012, John Wilk wrote: >Hi all I have a client who has software wich runs a test in which the software >collects data. What my client would like to do is be able to store each >test's data in an independent database located on a network share. Not on a network share...that is

Re: [firebird-support] Periodic database slowdown - troubleshooting steps?

2012-09-17 Thread Alexey Kovyazin
Hello Bob, > currently at 90GB. We have sweep disabled, and each night run gbak, > gfix --sweep, as well as reindex all tables via a script. > Seems like you do correct things, but do you check that sweep is really successful? Look at the transactions' markers log in IBTM (IBSurgeon Transactio

Re: [firebird-support] Periodic database slowdown - troubleshooting steps?

2012-09-17 Thread Thomas Steinmaurer
Hi Bob, > I have an FB 2.1.5 Classic server running on a Windows 2003 server, > with a single hard drive for the operating system, and a 3 disk raid 5 > array for the database. We have one database on this machine, which > is a dialect 1 database that was started on IB6.0 many years ago, > curren

RE: [firebird-support] Membership provider, hash passwords, login

2012-09-17 Thread Vasilis ..
Thanks Paul, it worked! To: firebird-support@yahoogroups.com From: paul.mer...@almexa.ro Date: Mon, 17 Sep 2012 21:50:02 +0300 Subject: Re: [firebird-support] Membership provider, hash passwords, login On 2012.09.17 5:45 PM, Vasilis .. wrote: >

[firebird-support] Number of instances of firebird

2012-09-17 Thread John Wilk
Hi all I have a client who has software wich runs a test in which the software collects data.  What my client would like to do is be able to store each test's data in an independent database located on a network share.  This is a little beyound me and something I had never really thought about i

Re: [firebird-support] Membership provider, hash passwords, login

2012-09-17 Thread Mercea Paul
On 2012.09.17 5:45 PM, Vasilis .. wrote: > > > > Greets, anyone has come up with this problem: In a ASP.NET website i > develop, using the membership provider and having hashed passwords in > the database the user cannot login If i change the password storage to > "clear" the login works fine.

[firebird-support] Survey on Jaybird

2012-09-17 Thread Mark Rotteveel
The Jaybird team would like to invite developers and users of Jaybird to fill out a survey on your use of Jaybird (Firebird JDBC driver). You can find the survey at http://infopoll.net/live/surveys/s36021.htm. The results of the survey will be used to decide where to focus development of the up

[firebird-support] Install Firebird 2.5.2 CS i386 RC1 in they Debian squeeze

2012-09-17 Thread Ismael L. Donis Garcia
I am trying to install Firebird 2.5.2 CS i386 RC1 in they Debian squeeze, but it does not start. And I do not see the cause of the problem. Has somebody had this problem? Best Regards. = || ISMAEL || =

Re: [firebird-support] Membership provider, hash passwords, login

2012-09-17 Thread Mark Rotteveel
On Mon, 17 Sep 2012 17:45:22 +0300, "Vasilis .." wrote: > Greets, anyone has come up with this problem: In a ASP.NET website i > develop, using the membership provider and having hashed passwords in the > database the user cannot login If i change the password storage to "clear" > the login works

Re: [firebird-support] Can non-sysdba really alter users?

2012-09-17 Thread Thomas Steinmaurer
> On 2012-09-17 13:07, Thomas Steinmaurer wrote: > >> Perhaps it might be related to CORE-3398, but I'm not sure. Any chance >> to give 2.5.1 or 2.5.2 RC1 a try? > > Thomas, > > Thanks a lot for the suggestion. Looks like there's something wrong with > my security2.fdb (it was upgraded from previou

[firebird-support] Membership provider, hash passwords, login

2012-09-17 Thread Vasilis ..
Greets, anyone has come up with this problem: In a ASP.NET website i develop, using the membership provider and having hashed passwords in the database the user cannot login If i change the password storage to "clear" the login works fine. Any idea how to solve this or is it a known bug? Than

[firebird-support] Periodic database slowdown - troubleshooting steps?

2012-09-17 Thread Bob Murdoch
I have an FB 2.1.5 Classic server running on a Windows 2003 server, with a single hard drive for the operating system, and a 3 disk raid 5 array for the database. We have one database on this machine, which is a dialect 1 database that was started on IB6.0 many years ago, currently at 90GB. We ha

Re: [firebird-support] Can non-sysdba really alter users?

2012-09-17 Thread Tomasz Tyrakowski
On 2012-09-17 13:07, Thomas Steinmaurer wrote: > Perhaps it might be related to CORE-3398, but I'm not sure. Any chance > to give 2.5.1 or 2.5.2 RC1 a try? Thomas, Thanks a lot for the suggestion. Looks like there's something wrong with my security2.fdb (it was upgraded from previous versions o

Re: [firebird-support] Can non-sysdba really alter users?

2012-09-17 Thread Thomas Steinmaurer
Hello Tomasz, > I'd be very grateful if someone could repeat the scenario described > below and confirm I'm not daydreaming (should take about 1 minute). I've > tested it on FB 2.5.0.26074 CS (Linux 32 and 64 bit). > > According to > > http://www.firebirdsql.org/refdocs/langrefupd25-security-sql-u

[firebird-support] Can non-sysdba really alter users?

2012-09-17 Thread Tomasz Tyrakowski
Hello, I'd be very grateful if someone could repeat the scenario described below and confirm I'm not daydreaming (should take about 1 minute). I've tested it on FB 2.5.0.26074 CS (Linux 32 and 64 bit). According to http://www.firebirdsql.org/refdocs/langrefupd25-security-sql-user-mgmt.html an