[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

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

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 of

[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

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

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

2012-09-17 Thread Mark Rotteveel
On Mon, 17 Sep 2012 17:45:22 +0300, Vasilis .. ne...@hotmail.com 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

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

[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

[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

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:

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

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 Transaction

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

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.