Re: [Firebird-devel] Dump call stack

2015-10-19 Thread Геннадий Забула 
But function captures only addresses, and you'll need to manually use
pdbs to find what functions are called.
IMO, it is better to use user-mode dumps with WinDBG to debug such problems.

On 19 October 2015 at 09:02, Геннадий Забула  wrote:
> https://msdn.microsoft.com/en-us/library/windows/desktop/bb204633(v=vs.85).aspx
>
> On 18 October 2015 at 18:39, Dimitry Sibiryakov  wrote:
>>Hello, All.
>>
>>Is there a method to dump call stack on Windows into firebird log in some 
>> useful form
>> to find out how a routine got called?
>>Igor Valchenko seems to be able to reproduce a very old problem with 
>> unexpected server
>> shutdown during BLOB operation and I would like to see where 
>> JProvider::shutdown() is
>> called from.
>>
>> --
>>WBR, SD.
>>
>> --
>> Firebird-Devel mailing list, web interface at 
>> https://lists.sourceforge.net/lists/listinfo/firebird-devel

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Dump call stack

2015-10-19 Thread Геннадий Забула 
https://msdn.microsoft.com/en-us/library/windows/desktop/bb204633(v=vs.85).aspx

On 18 October 2015 at 18:39, Dimitry Sibiryakov  wrote:
>Hello, All.
>
>Is there a method to dump call stack on Windows into firebird log in some 
> useful form
> to find out how a routine got called?
>Igor Valchenko seems to be able to reproduce a very old problem with 
> unexpected server
> shutdown during BLOB operation and I would like to see where 
> JProvider::shutdown() is
> called from.
>
> --
>WBR, SD.
>
> --
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] FB3 installation Windows Server 2012 RC2

2015-10-19 Thread Mark Rotteveel 
On 17-10-2015 16:26, JS-Ohjelmointi (J Sariola) wrote:
> Problem with Firebird 3.0.x.x in Windows Server 2012 RC2.
>
> How can I input Administrator when install haven't any effect to
> security3.fdb and when trying to connect to database with isql comes error:
>
> isql -user sysdba employee
> Statement failed, SQLSTATE = HY000
> operating system directive CreateFile failed
> -The system cannot find the path specified.
>
> I have tried with installer and snapshot. I have also tried with real
> path to database to connect.
>
> In Win7 Pro there are no problems.

Where and how did you define the employee alias?

Mark
-- 
Mark Rotteveel

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4966) Firebird installer fails on El Capitan (MacOSX 10.11)

2015-10-19 Thread Paul Beach (JIRA) 
Firebird installer fails on El Capitan (MacOSX 10.11)
-

 Key: CORE-4966
 URL: http://tracker.firebirdsql.org/browse/CORE-4966
 Project: Firebird Core
  Issue Type: Bug
  Components: Installation
Affects Versions: 2.5.4
 Environment: El Capitan - MacOSX 10.11 - Released 30th Sep 2015 
Reporter: Paul Beach


Firebird MacOSX installer fails on the latest release of OSX. Apple have 
finally deprecated the installer format we use. 
A new installer needs to be written using pkgbuild and productbuild.


installer log created by Firebird Installer.

Sep 23 16:30:02 mac-mbp Installer[66897]: LSExceptions [0x7f93d9603070] loaded
Sep 23 16:30:02 mac-mbp Installer[66897]: @(#)PROGRAM:Install  
PROJECT:Install-1000
Sep 23 16:30:02 mac-mbp Installer[66897]: @(#)PROGRAM:Installer  
PROJECT:Installer-853
Sep 23 16:30:02 mac-mbp Installer[66897]: Hardware: MacBookPro9,1 @ 2.60 GHz (x 
8), 8192 MB RAM
Sep 23 16:30:02 mac-mbp Installer[66897]: Running OS Build: Mac OS X 10.11.1 
(15B17c)
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
TMPDIR=/var/folders/z1/c5tfsznx0ts_cdbdhww69qrmgn/T/
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
FS_TRASHER_SOCKET=/private/tmp/com.apple.launchd.9wJ4tCTvtL/ListeningSocket
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
__CF_USER_TEXT_ENCODING=0x1F5:0x0:0x0
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: HOME=/Users/macuser
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: SHELL=/bin/bash
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
Apple_PubSub_Socket_Render=/private/tmp/com.apple.launchd.OR4quis6LU/Render
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
SSH_AUTH_SOCK=/private/tmp/com.apple.launchd.j4vOrTOuXP/Listeners
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
PATH=/usr/bin:/bin:/usr/sbin:/sbin
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: LOGNAME=macuser
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: 
XPC_SERVICE_NAME=com.apple.installer.78432
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: USER=macuser
Sep 23 16:30:02 mac-mbp Installer[66897]: Env: XPC_FLAGS=0x0
Sep 23 16:30:02 mac-mbp Installer[66897]: Firebird Database  Installation Log
Sep 23 16:30:02 mac-mbp Installer[66897]: Opened from: 
/Users/macuser/Downloads/FirebirdCS-2.5.4-26856-x86_64.pkg
Sep 23 16:30:03 mac-mbp Installer[66897]: Top component package 
/Users/macuser/Downloads/FirebirdCS-2.5.4-26856-x86_64.pkg not found or 
understood: treat as unsigned
Sep 23 16:30:13 mac-mbp Installer[66897]: LSExceptions [0x7f93d9603070] unloaded
Sep 23 16:30:35 mac-mbp Installer[66897]: InstallerStatusNotifications plugin 
loaded
Sep 23 16:30:43 mac-mbp Installer[66897]: Administrator authorization granted.
Sep 23 16:30:43 mac-mbp Installer[66897]: 

Sep 23 16:30:43 mac-mbp Installer[66897]: User picked Standard Install
Sep 23 16:30:43 mac-mbp Installer[66897]: Choices selected for installation:
Sep 23 16:30:43 mac-mbp Installer[66897]: Upgrade: "Firebird Database"
Sep 23 16:30:43 mac-mbp Installer[66897]: 
FirebirdCS-2.5.4-26856-x86_64.pkg : org.firebirdsql.Firebird : 2.5.0.2.5
Sep 23 16:30:43 mac-mbp Installer[66897]: 

Sep 23 16:30:43 mac-mbp Installer[66897]: It took 0.00 seconds to summarize the 
package selections.
Sep 23 16:30:43 mac-mbp Installer[66897]: -[IFPKGDerivedDocument 
sortedPackageLocations]: result = (
"file://localhost"
)
Sep 23 16:30:43 mac-mbp Installer[66897]: -[IFDInstallController(Private) 
_buildInstallPlanReturningError:]: location = file://localhost
Sep 23 16:30:43 mac-mbp Installer[66897]: -[IFDInstallController(Private) 
_buildInstallPlanReturningError:]: 
file://localhost/Users/macuser/Downloads/FirebirdCS-2.5.4-26856-x86_64.pkg
Sep 23 16:30:43 mac-mbp Installer[66897]: Set authorization level to root for 
session
Sep 23 16:30:43 mac-mbp Installer[66897]: Administrator authorization granted.
Sep 23 16:30:43 mac-mbp Installer[66897]: Package 
file://localhost/Users/macuser/Downloads/FirebirdCS-2.5.4-26856-x86_64.pkg not 
supported by PK
Sep 23 16:30:43 mac-mbp Installer[66897]: Unable to use PK session due to 
incompatible packages. Terminating.
Sep 23 16:30:43 mac-mbp Installer[66897]: Install failed: The Installer could 
not install the software because there was no software found to install.
Sep 23 16:30:43 mac-mbp Installer[66897]: IFDInstallController D94322A0 state = 
8
Sep 23 16:30:43 mac-mbp Installer[66897]: Displaying 'Install Failed' UI.
Sep 23 16:30:43 mac-mbp Installer[66897]: 'Install Failed' UI displayed 
message:'The Installer could not install the software.

The Installer could not install the software because there was no software 
found to install.'. 



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one

Re: [Firebird-devel] Dump call stack

2015-10-19 Thread Vlad Khorsun 
18.10.2015 18:39, Dimitry Sibiryakov wrote:
> Hello, All.
>
> Is there a method to dump call stack on Windows into firebird log in some 
> useful form
> to find out how a routine got called?

   It is bad idea, believe me. Better idea is to provide dump of process memory:

   
https://msdn.microsoft.com/en-us/library/windows/desktop/ms680369%28v=vs.85%29.aspx

Hope it helps,
Vlad

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Dump call stack

2015-10-19 Thread Vlad Khorsun 
19.10.2015 17:30, Dimitry Sibiryakov wrote:
> 19.10.2015 16:03, Vlad Khorsun wrote:
>>It is bad idea, believe me. Better idea is to provide dump of process 
>> memory:
>
> Taing into account that "MiniDumpWriteDump may not produce a valid stack 
> trace for the
> calling thread", it is better to use both.

   As you wish. I used MiniDumpWriteDump() many times with success.

Regards,
Vlad

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Dump call stack

2015-10-19 Thread Dimitry Sibiryakov 
19.10.2015 16:03, Vlad Khorsun wrote:
>   It is bad idea, believe me. Better idea is to provide dump of process 
> memory:

   Taing into account that "MiniDumpWriteDump may not produce a valid stack 
trace for the 
calling thread", it is better to use both.

-- 
   WBR, SD.

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Firebird 3 - Embedded deployment - Secure database login

2015-10-19 Thread Thomas Steinmaurer 
Hello,

with Firebird 3, what are the capabilities to disallow unwanted users to 
open my database?

I thought perhaps preparing a database pointing to itself as security 
database might be an option (MON$DATABASE.MON$SEC_DATABASE=Self), but 
this database then still can be opened by an embedded connection without 
troubles.


Thanks,
Thomas

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Firebird 2.5.4 - Trace API - CREATE TRIGGER not captured including RDB$GET_CONTEXT

2015-10-19 Thread Thomas Steinmaurer 
Hello,

I'm using Firebird 2.5.4 x86 on Windows 7.

A simple table:

CREATE TABLE T1
(
ID INTEGER NOT NULL,
CONSTRAINT PK_T1 PRIMARY KEY (ID)
);


The following trace configuration:


   enabled true
   log_connections true
   log_transactions true
   log_statement_finish true
   print_plan true
   print_perf true
   exclude_filter %RDB$%
   time_threshold 0
   max_sql_length 2048




Starting a trace session with the above configuration via 
fbtracemgr.exe, e.g.:

fbtracemgr.exe -se localhost/3050:service_mgr -start -name tourism_cmd 
-config tourism_trace.conf -user tourism -password tourism

When I run the following CREATE TRIGGER DDL statement:

CREATE TRIGGER TRI_T1 FOR T1 BEFORE DELETE position 32767 AS
BEGIN
-- EXECUTE PROCEDURE P_1 (RDB$GET_CONTEXT('SYSTEM', 'ISOLATION_LEVEL'));
END;


The statement isn't captured from the trace session.

If I remove the RDB$GET_CONTEXT part, e.g.:

CREATE TRIGGER TRI_T1 FOR T1 BEFORE DELETE position 32767 AS
BEGIN
-- EXECUTE PROCEDURE P_1 ();
END;

or remove the commented line entirely:

CREATE TRIGGER TRI_T1 FOR T1 BEFORE DELETE position 32767 AS
BEGIN
END;


Then both cases are captured from the trace session.

Doesn't look right to me. Is this a known issue?

Thanks,
Thomas

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4967) Replace all messages related to database file (path) existense with ENGLISH text

2015-10-19 Thread Pavel Zotov (JIRA) 
Replace all messages related to database file (path) existense with ENGLISH text


 Key: CORE-4967
 URL: http://tracker.firebirdsql.org/browse/CORE-4967
 Project: Firebird Core
  Issue Type: Bug
Reporter: Pavel Zotov


Suppose that we issue 'CREATE DATABASE' with specifying database file that 
already exists.

1. Attempting to create database on 2.5, client - also 2.5:

echo create database 'localhost/3249:C:\MIX\firebird\QA\fbt-repo\tmp\e25.FDB' 
user 'SYSDBA' password 'masterke'; | C:\MIX\firebird\fb25Cs\bin\isql -q

STDOUT:
===
SQL> SQL> 

STDERR:

Statement failed, SQLSTATE = 08001
I/O error during "open" operation for file 
"localhost/3249:C:\MIX\firebird\QA\fbt-repo\tmp\e25.FDB"
-database or file exists


2. Attempting to create database on 3.0, client - also 3.0:

echo create database 'localhost/3329:C:\MIX\firebird\QA\fbt-repo\tmp\e30.FDB' 
user 'SYSDBA' password 'masterke'; | C:\MIX\firebird\fb30Cs\isql -q

STDOUT: nope (empty).


STDERR:

Statement failed, SQLSTATE = 08001
I/O error during "CreateFile (create)" operation for file 
"C:\MIX\FIREBIRD\QA\FBT-REPO\TMP\E30.FDB"
-Error while trying to create file
-Файл существует.  // message in national charset of  my Windows locale.

Is it possible to remove *TOTALLY* any messages in non-ascii form from fbclient 
3.x ?

PS. Yes, I know that this request is likely duplicate of several other ones. 
Sorry, but can`t understand at all why non-ascii messages appear at console 
and, furthermore, why language for the same case differ in 2.5 and 3.0.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

   

--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 3 - Embedded deployment - Secure database login

2015-10-19 Thread Dmitry Yemanov 
20.10.2015 00:18, Thomas Steinmaurer wrote:
>
> with Firebird 3, what are the capabilities to disallow unwanted users to
> open my database?
>
> I thought perhaps preparing a database pointing to itself as security
> database might be an option (MON$DATABASE.MON$SEC_DATABASE=Self), but
> this database then still can be opened by an embedded connection without
> troubles.

Embedded connections do not authenticate users, this is by design. The 
only protection for distributed databases is a database encryption.


Dmitry


--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel