Exception when running test

[Jeff Jones - SHERIFFX]

Some parts of this message have been removed. Learn more about Nabble's security policy.

When I run some tests with QMTest, the following error is received:

 

<class 'pywintypes.error'>: (5, 'CreateProcess', 'Access is denied.')

And here is the traceback:

File "C:\Python25\Lib\site-packages\qm\test\target.py", line 227, in RunTest

    descriptor.Run(context, result)

  File "C:\Python25\Lib\site-packages\qm\test\database.py", line 272, in Run

    self._Execute(context, result, "Run")

  File "C:\Python25\Lib\site-packages\qm\test\database.py", line 191, in _Execute

    methobj(context, result)

  File "C:\fbtest\QMTest\fbqa.py", line 1265, in Run

    retval= self.__ExecISQLCommands()

  File "C:\fbtest\QMTest\fbqa.py", line 722, in __ExecISQLCommands

    "-password", self.user_password])

  File "C:\fbtest\QMTest\fbqa.py", line 623, in __RunProgram

    exit_status= qm_exec.Run(args, environ)

  File "C:\Python25\Lib\site-packages\qm\executable.py", line 564, in Run

    path)

  File "C:\Python25\Lib\site-packages\qm\executable.py", line 270, in Run

    child = self.Spawn(arguments, environment, dir, path, exception_pipe)

  File "C:\Python25\Lib\site-packages\qm\executable.py", line 183, in Spawn

    startupinfo)[0]

 

I have a feeling this indicates that something is wrong with my setup, not with the test itself.  Is that correct?

 

Any ideas on what I should check or do?

 

Thanks!

 

Jeff Jones

MCSO Technology Bureau

602-876-4048

 

data < information < knowledge < understanding < wisdom

 

 

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Pavel Cisar]

Jeff,

Jeff Jones - SHERIFFX napsal(a):
> When I run some tests with QMTest, the following error is received:
>
> <class 'pywintypes.error'>: (5, 'CreateProcess', 'Access is denied.')

This is important clue, qmtest haven't enough privileges to start a
process (run external program).

> And here is the traceback:
>
> File "C:\Python25\Lib\site-packages\qm\test\target.py", line 227, in RunTest
>     descriptor.Run(context, result)
>   File "C:\Python25\Lib\site-packages\qm\test\database.py", line 272, in Run
>     self._Execute(context, result, "Run")
>   File "C:\Python25\Lib\site-packages\qm\test\database.py", line 191, in _Execute
>     methobj(context, result)
>   File "C:\fbtest\QMTest\fbqa.py", line 1265, in Run
>     retval= self.__ExecISQLCommands()
>   File "C:\fbtest\QMTest\fbqa.py", line 722, in __ExecISQLCommands
>     "-password", self.user_password])

Here is application in question, ISQL, that can't be run by qmtest.

>   File "C:\fbtest\QMTest\fbqa.py", line 623, in __RunProgram
>     exit_status= qm_exec.Run(args, environ)
>   File "C:\Python25\Lib\site-packages\qm\executable.py", line 564, in Run
>     path)
>   File "C:\Python25\Lib\site-packages\qm\executable.py", line 270, in Run
>     child = self.Spawn(arguments, environment, dir, path, exception_pipe)
>   File "C:\Python25\Lib\site-packages\qm\executable.py", line 183, in Spawn
>     startupinfo)[0]
>
> I have a feeling this indicates that something is wrong with my setup,
> not with the test itself.  Is that correct?
>
> Any ideas on what I should check or do?

Check the access rights for isql.

best regards
Pavel Cisar
IBPhoenix

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Jeff Jones - SHERIFFX]

Okay, I tried one of the tests that comes with the test suite, and it
also fails.  Here is the output from qmtest:

--- TEST RESULTS
-------------------------------------------------------------

  functional.database.create.create_database_29 : ERROR  
    An exception occurred.

    qmtest.end_time:
      2008-03-20T16:44:47Z

    qmtest.exception:
     
      <class 'pywintypes.error'>: (5, 'CreateProcess', 'Access is
denied.')
     

    qmtest.start_time:
      2008-03-20T16:44:47Z

    qmtest.target:
      local

    qmtest.traceback:
     
        File "C:\Python25\Lib\site-packages\qm\test\target.py", line
227, in RunTest
          descriptor.Run(context, result)
     
        File "C:\Python25\Lib\site-packages\qm\test\database.py", line
272, in Run
          self._Execute(context, result, "Run")
     
        File "C:\Python25\Lib\site-packages\qm\test\database.py", line
191, in _Execute
          methobj(context, result)
     
        File "C:\fbtest\QMTest\fbqa.py", line 1265, in Run
          retval= self.__ExecISQLCommands()
     
        File "C:\fbtest\QMTest\fbqa.py", line 722, in __ExecISQLCommands
          "-password", self.user_password])
     
        File "C:\fbtest\QMTest\fbqa.py", line 623, in __RunProgram
          exit_status= qm_exec.Run(args, environ)
     
        File "C:\Python25\Lib\site-packages\qm\executable.py", line 564,
in Run
          path)
     
        File "C:\Python25\Lib\site-packages\qm\executable.py", line 270,
in Run
          child = self.Spawn(arguments, environment, dir, path,
exception_pipe)
     
        File "C:\Python25\Lib\site-packages\qm\executable.py", line 183,
in Spawn
          startupinfo)[0]
     

--- TESTS THAT DID NOT PASS
--------------------------------------------------

  functional.database.create.create_database_29 : ERROR  
    An exception occurred.


--- STATISTICS
---------------------------------------------------------------

       1        tests total
       1 (100%) tests ERROR

I am not sure what you mean by checking the access rights for isql.  How
would I do that?  What would I look for?

Any help you can provide will be appreciated.

Thanks!
 
Jeff
 
-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of Pavel
Cisar
Sent: Thursday, March 20, 2008 08:15 AM
To: firebird-test@...
Subject: Re: [Firebird-test] Exception when running test

Jeff,

Jeff Jones - SHERIFFX napsal(a):
> When I run some tests with QMTest, the following error is received:
>
> <class 'pywintypes.error'>: (5, 'CreateProcess', 'Access is denied.')

This is important clue, qmtest haven't enough privileges to start a
process (run external program).

> And here is the traceback:
>
> File "C:\Python25\Lib\site-packages\qm\test\target.py", line 227, in
RunTest
>     descriptor.Run(context, result)
>   File "C:\Python25\Lib\site-packages\qm\test\database.py", line 272,
in Run
>     self._Execute(context, result, "Run")
>   File "C:\Python25\Lib\site-packages\qm\test\database.py", line 191,
in _Execute
>     methobj(context, result)
>   File "C:\fbtest\QMTest\fbqa.py", line 1265, in Run
>     retval= self.__ExecISQLCommands()
>   File "C:\fbtest\QMTest\fbqa.py", line 722, in __ExecISQLCommands
>     "-password", self.user_password])

Here is application in question, ISQL, that can't be run by qmtest.

>   File "C:\fbtest\QMTest\fbqa.py", line 623, in __RunProgram
>     exit_status= qm_exec.Run(args, environ)
>   File "C:\Python25\Lib\site-packages\qm\executable.py", line 564, in
Run
>     path)
>   File "C:\Python25\Lib\site-packages\qm\executable.py", line 270, in
Run
>     child = self.Spawn(arguments, environment, dir, path,
exception_pipe)
>   File "C:\Python25\Lib\site-packages\qm\executable.py", line 183, in
Spawn
>     startupinfo)[0]
>
> I have a feeling this indicates that something is wrong with my setup,
> not with the test itself.  Is that correct?
>
> Any ideas on what I should check or do?

Check the access rights for isql.

best regards
Pavel Cisar
IBPhoenix

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Pavel Cisar]

Jeff Jones - SHERIFFX napsal(a):
> Okay, I tried one of the tests that comes with the test suite, and it
> also fails.  Here is the output from qmtest:

Same problem here.

> I am not sure what you mean by checking the access rights for isql.  How
> would I do that?  What would I look for?

QMTest can't spawn new process (ISQL in this case) because Windows
doesn't allow him to. It could be either because QMTest itself is
restricted to spawn processes at all or can't execute ISQL due to
insufficient OS rights. Maybe your have installed Firebird under
Administrator account but run Python (QMTest) under your user account
that has restricted access to FB installation? I never encountered such
problem under XP workstation, but if you're on Vista or W2003 Server, it
could be different thanks to UAC and its generally tightened security?

If you can execute isql manually, then the problem is in OS rights tied
to QMTest (resp. Python). You may try to assign Python executable to
some more powerful user groups (or system ones).

best regards
Pavel Cisar

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Jeff Jones - SHERIFFX]

I am still stuck!  Since I work for a law enforcement agency, we have
our computers and the network locked down pretty tight, so I thought
that perhaps the problem I have been having with qmtest has been because
of restrictions I don't even know about on my PC.

So, I tried installing qmtest on my computer at home, also running
Windows XP.  I still have the same problem, as evidenced by the test
results below.

--- TEST RESULTS
-------------------------------------------------------------

  functional.basic.isql.isql_02                 : ERROR  
    An exception occurred.

    qmtest.end_time:
      2008-03-24T13:49:14Z

    qmtest.exception:
     
      <class 'pywintypes.error'>: (5, 'CreateProcess', 'Access is
denied.')
     

    qmtest.start_time:
      2008-03-24T13:49:07Z

    qmtest.target:
      local

    qmtest.traceback:
     
        File "C:\Python25\Lib\site-packages\qm\test\target.py", line
227, in RunTest
          descriptor.Run(context, result)
     
        File "C:\Python25\Lib\site-packages\qm\test\database.py", line
272, in Run
          self._Execute(context, result, "Run")
     
        File "C:\Python25\Lib\site-packages\qm\test\database.py", line
191, in _Execute
          methobj(context, result)
     
        File "C:\fbtest\QMTest\fbqa.py", line 1265, in Run
          retval= self.__ExecISQLCommands()
     
        File "C:\fbtest\QMTest\fbqa.py", line 722, in __ExecISQLCommands
          "-password", self.user_password])
     
        File "C:\fbtest\QMTest\fbqa.py", line 623, in __RunProgram
          exit_status= qm_exec.Run(args, environ)
     
        File "C:\Python25\Lib\site-packages\qm\executable.py", line 564,
in Run
          path)
     
        File "C:\Python25\Lib\site-packages\qm\executable.py", line 270,
in Run
          child = self.Spawn(arguments, environment, dir, path,
exception_pipe)
     
        File "C:\Python25\Lib\site-packages\qm\executable.py", line 183,
in Spawn
          startupinfo)[0]
     

--- TESTS THAT DID NOT PASS
--------------------------------------------------

  functional.basic.isql.isql_02                 : ERROR  
    An exception occurred.


--- STATISTICS
---------------------------------------------------------------

       1        tests total
       1 (100%) tests ERROR


Do you have any ideas of what to check or to try?  I really would like
to get qmtest running, because what I have seen makes me think that it
would be very useful.

Thanks!
 
Jeff
 
-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of Pavel
Cisar
Sent: Thursday, March 20, 2008 10:16 AM
To: firebird-test@...
Subject: Re: [Firebird-test] Exception when running test

Jeff Jones - SHERIFFX napsal(a):
> Okay, I tried one of the tests that comes with the test suite, and it
> also fails.  Here is the output from qmtest:

Same problem here.

> I am not sure what you mean by checking the access rights for isql.
How
> would I do that?  What would I look for?

QMTest can't spawn new process (ISQL in this case) because Windows
doesn't allow him to. It could be either because QMTest itself is
restricted to spawn processes at all or can't execute ISQL due to
insufficient OS rights. Maybe your have installed Firebird under
Administrator account but run Python (QMTest) under your user account
that has restricted access to FB installation? I never encountered such
problem under XP workstation, but if you're on Vista or W2003 Server, it
could be different thanks to UAC and its generally tightened security?

If you can execute isql manually, then the problem is in OS rights tied
to QMTest (resp. Python). You may try to assign Python executable to
some more powerful user groups (or system ones).

best regards
Pavel Cisar

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Jeff Jones - SHERIFFX]

Well, after banging my head against this problem for two days, I finally
figured out that the context file I had created was incomplete.

I had:

isql_path=C:/Program Files/Firebird/Firebird_1_5/bin/

I figured this was correct because this is the "path" to the isql.exe
file.  What I did not realize until I read the instructions more closely
was that this parameter specifies not only the path but also the
filename.  So, when I changed it to:

isql_path=C:/Program Files/Firebird/Firebird_1_5/bin/isql.exe

it started working better.  Hurrah!

However, I now have a different problem (I am your problem child, after
all!)  When trying to run one of the tests that came with the testsuite,
or running a simple test of my own, I get the following output in
qmEditor:

--- TEST RESULTS
-------------------------------------------------------------

  functional.database.create.create_database_29 : FAIL    
    Expected error output from ISQL does not match actual error output.

    FirebirdTest.ISQL_stderr_actual:
     
      Statement failed, SQLCODE = -924
     
      bad parameters on attach or create database
      Use CONNECT or CREATE DATABASE to specify a database
      Use CONNECT or CREATE DATABASE to specify a database
     

    FirebirdTest.ISQL_stderr_actual_stripped:
     
      Statement failed, SQLCODE = -924
      bad parameters on attach or create database
      Use CONNECT or CREATE DATABASE to specify a database
      Use CONNECT or CREATE DATABASE to specify a database
     

    FirebirdTest.ISQL_stderr_expected:
     

    FirebirdTest.ISQL_stderr_expected_stripped:
     

    FirebirdTest.ISQL_stderr_stripped_diff:
     
      + Statement failed, SQLCODE = -924
      + bad parameters on attach or create database
      + Use CONNECT or CREATE DATABASE to specify a database
      + Use CONNECT or CREATE DATABASE to specify a database
     

    qmtest.end_time:
      2008-03-26T16:57:16Z

    qmtest.start_time:
      2008-03-26T16:57:16Z

    qmtest.target:
      local

--- TESTS THAT DID NOT PASS
--------------------------------------------------

  functional.database.create.create_database_29 : FAIL    
    Expected error output from ISQL does not match actual error output.


--- STATISTICS
---------------------------------------------------------------

       1        tests total
       1 (100%) tests FAIL

It does not appear to be connecting to the database, even though the
command entered as the Python/SQL Code appears to be correct, and works
when running isql from a command window.

I have probably forgotten some simple thing in the setup, but I can't
figure it out.

Any ideas?

Thanks!
 
Jeff
 

-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of Pavel
Cisar
Sent: Thursday, March 20, 2008 10:16 AM
To: firebird-test@...
Subject: Re: [Firebird-test] Exception when running test

Jeff Jones - SHERIFFX napsal(a):
> Okay, I tried one of the tests that comes with the test suite, and it
> also fails.  Here is the output from qmtest:

Same problem here.

> I am not sure what you mean by checking the access rights for isql.
How
> would I do that?  What would I look for?

QMTest can't spawn new process (ISQL in this case) because Windows
doesn't allow him to. It could be either because QMTest itself is
restricted to spawn processes at all or can't execute ISQL due to
insufficient OS rights. Maybe your have installed Firebird under
Administrator account but run Python (QMTest) under your user account
that has restricted access to FB installation? I never encountered such
problem under XP workstation, but if you're on Vista or W2003 Server, it
could be different thanks to UAC and its generally tightened security?

If you can execute isql manually, then the problem is in OS rights tied
to QMTest (resp. Python). You may try to assign Python executable to
some more powerful user groups (or system ones).

best regards
Pavel Cisar

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Philippe Makowski]

Jeff Jones - SHERIFFX  [08-03-26 18.03] :
> I have probably forgotten some simple thing in the setup, but I can't
> figure it out.
>
> Any ideas?
>
check
temp_directory=
server_location=
database_location=

be sure that Firebird can write into database_location and temp_directory directories


-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Jeff Jones - SHERIFFX]

I tested running isql from a command window, and Firebird can indeed
create a database in the temp_directory and the database_location.  But,
it does not appear to work in qmEditor.

Perhaps I have created a test that is inherently flawed and will not run
anyway?

Could you give me the steps for creating a test that involves a Firebird
database that I could create here, just to know that I am not chasing a
phantom error?

That would be very helpful.

If I can't get this going soon, I will have to abandon qmTest/qmEdit and
continue my search for a testing tool for Firebird.  I have already
spent way too much time on this...

Thanks!
 
Jeff
 

-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of
Philippe Makowski
Sent: Wednesday, March 26, 2008 10:29 AM
To: firebird-test@...
Subject: Re: [Firebird-test] Exception when running test

Jeff Jones - SHERIFFX  [08-03-26 18.03] :
> I have probably forgotten some simple thing in the setup, but I can't
> figure it out.
>
> Any ideas?
>
check
temp_directory=
server_location=
database_location=

be sure that Firebird can write into database_location and
temp_directory directories


------------------------------------------------------------------------
-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketp
lace
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Philippe Makowski]

Jeff Jones - SHERIFFX  [08-03-26 23.09] :

> I tested running isql from a command window, and Firebird can indeed
> create a database in the temp_directory and the database_location.  But,
> it does not appear to work in qmEditor.
>
> Perhaps I have created a test that is inherently flawed and will not run
> anyway?
>
> Could you give me the steps for creating a test that involves a Firebird
> database that I could create here, just to know that I am not chasing a
> phantom error?
>

The functional.database.create.create_database_29 is a good one
it should work
you said you have Interbase on your box
perhaps is there a problem with that
try without Interbase running
and whith fbclient.dll in the directory you are when you launch test

Running Firebird as an application (C:\FB21\bin\fbserver.exe -a) on a XP box I have no
problem inside the qmEditor
and for example a :
C:\FB21\QA\fb210w>python c:/python24/scripts/qmtest.py run -C c:/fb21/qa/context
2.txt functional.database.create.create_database_09

give correct results


here my context file :

temp_directory=C:\FB21\db\
server_location=127.0.0.1/3040:
database_location=C:\FB21\db\
suite_database_location=C:\FB21\QA\testsuite\fdb\
backup_location=C:\FB21\QA\testsuite\fbk\
files_location=C:\FB21\QA\testsuite\files\
isc4_path=C:\FB21\security2.fdb
user_name=SYSDBA
user_password=masterkey
isql_path=C:\FB21\bin\isql.exe
gsec_path=C:\FB21\bin\gsec.exe
gstat_path=C:\FB21\bin\gstat.exe
gbak_path=C:\FB21\bin\gbak.exe
nbackup_path=C:\FB21\bin\nbackup.exe
gfix_path=C:\FB21\bin\gfix.exe
gpre_path=C:\FB21\bin\gpre.exe
database_name=bugs.fdb




-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Jeff Jones - SHERIFFX]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Dear all,

 

If you have been following the saga of getting qmTest working for me, you will know that I have been at this for more than a week.  I don't want to give up on it yet, because I think this would be a good solution for what we need.  So, if anyone can offer advice, suggestions, or whacks on the side of the head, I am ready.

 

I want to describe what I am doing with qmTest and qmEditor so that you may be able to see where I have gone wrong, or you may be able to suggest things to try that have not already been suggested.

 

I was running Firebird 1.5 as a service, but Philippe suggested running it as an application, so I made that change.

 

My context file:

 

temp_directory=C:\fbtest\temp\

server_location=127.0.0.1/3040:

database_location=C:\fbtest\temp\

suite_database_location=C:\fbtest\fdb\

backup_location=C:\fbtest\fbk\

files_location=C:\fbtest\files\

isc4_path=C:\Program Files\Firebird\Firebird_1_5\security.fdb

user_name=SYSDBA

user_password=masterkey

isql_path=C:\Program Files\Firebird\Firebird_1_5\bin\isql.exe

gsec_path=C:\Program Files\Firebird\Firebird_1_5\bin\gsec.exe

gstat_path=C:\Program Files\Firebird\Firebird_1_5\bin\gstat.exe

gbak_path=C:\Program Files\Firebird\Firebird_1_5\bin\gbak.exe

#nbackup_path=C:\Program Files\Firebird\Firebird_1_5\bin\

gfix_path=C:\Program Files\Firebird\Firebird_1_5\bin\gfix.exe

gpre_path=C:\Program Files\Firebird\Firebird_1_5\bin\gpre.exe

database_name=test.fdb

 

The fbclient.dll file is in the c:\fbtest directory.

 

 

My batch file to launch qmEdit:

 

cd..

cd /fbtest

qmedit.py

 

This does launch qmEditor successfully.

 

 

In qmEditor, select the New Test button.

 

Test ID:  oj.local.database.table_create

Test File:  oj.local.database.table_create

Target Version:  1.5.4

Target Platform:  Windows

 

On Identification page:

Title:  Create a table

Bug/Issue ID:  <blank>

Author:  jonesj

 

On Database page:

Database Creation Method:  Restore From Backup

Database Name / DSN:  ojlocal.fdb

Database Path property:  database_location

SQL Dialect:  3

Character Set:  NONE

Page Size:  8192

User Name:  SYSDBA

User Password:  masterkey

Backup File:  ojlocal.fbk

 

On Initialisation page:  NO CHANGES

 

On Test page:  NO CHANGES

 

On Finalisation page:  Drop Database is checked

 

 

 

After saving the test, I run it, and it passes.  (I checked that the database is actually being restored from the backup, and that is working correctly.)  I expect this, since it is not trying to do anything unusual.  What I really want to do is create a table in the database.  So ...

 

On the Test page, I select the Python / SQL code tab.

Statement Type and Result:  SQL: String

And the value is:

 

CREATE TABLE MYTEST (ID INTEGER, MYNAME VARCHAR(50));

 

 

After saving the test again, I run it.  Here is the QMTest Output:

 

--- TEST RESULTS -------------------------------------------------------------

 

  oj.local.database.table_create                : FAIL   

    Expected error output from ISQL does not match actual error output.

 

    FirebirdTest.ISQL_stderr_actual:

     

      Statement failed, SQLCODE = -924

     

      bad parameters on attach or create database

      Use CONNECT or CREATE DATABASE to specify a database

      Use CONNECT or CREATE DATABASE to specify a database

     

 

    FirebirdTest.ISQL_stderr_actual_stripped:

     

      Statement failed, SQLCODE = -924

      bad parameters on attach or create database

      Use CONNECT or CREATE DATABASE to specify a database

      Use CONNECT or CREATE DATABASE to specify a database

     

 

    FirebirdTest.ISQL_stderr_expected:

     

 

    FirebirdTest.ISQL_stderr_expected_stripped:

     

 

    FirebirdTest.ISQL_stderr_stripped_diff:

     

      + Statement failed, SQLCODE = -924

      + bad parameters on attach or create database

      + Use CONNECT or CREATE DATABASE to specify a database

      + Use CONNECT or CREATE DATABASE to specify a database

     

 

    qmtest.end_time:

      2008-03-27T22:36:15Z

 

    qmtest.start_time:

      2008-03-27T22:36:09Z

 

    qmtest.target:

      local

 

--- TESTS THAT DID NOT PASS --------------------------------------------------

 

  oj.local.database.table_create                : FAIL   

    Expected error output from ISQL does not match actual error output.

 

 

--- STATISTICS ---------------------------------------------------------------

 

       1        tests total

       1 (100%) tests FAIL

 

 

So, why would this fail?  Do I need to connect to the database first?  Okay, lets try that.

 

 

On the Test page, and the Python / SQL code tab, delete the previous command, and enter:

 

CONNECT '127.0.0.1/3040:C:\fbtest\temp\ojlocal.fdb' user 'SYSDBA' password 'masterkey';

 

 

Save and run, and this is the QMTest Output:

 

--- TEST RESULTS -------------------------------------------------------------

 

  oj.local.database.table_create                : FAIL   

    Expected error output from ISQL does not match actual error output.

 

    FirebirdTest.ISQL_stderr_actual:

     

      Statement failed, SQLCODE = -924

     

      bad parameters on attach or create database

      Use CONNECT or CREATE DATABASE to specify a database

      Statement failed, SQLCODE = -924

     

      bad parameters on attach or create database

      

 

    FirebirdTest.ISQL_stderr_actual_stripped:

     

      Statement failed, SQLCODE = -924

      bad parameters on attach or create database

      Use CONNECT or CREATE DATABASE to specify a database

      Statement failed, SQLCODE = -924

      bad parameters on attach or create database

     

 

    FirebirdTest.ISQL_stderr_expected:

     

 

    FirebirdTest.ISQL_stderr_expected_stripped:

     

 

    FirebirdTest.ISQL_stderr_stripped_diff:

     

      + Statement failed, SQLCODE = -924

      + bad parameters on attach or create database

      + Use CONNECT or CREATE DATABASE to specify a database

      + Statement failed, SQLCODE = -924

      + bad parameters on attach or create database

     

 

    qmtest.end_time:

      2008-03-27T22:39:44Z

 

    qmtest.start_time:

      2008-03-27T22:39:39Z

 

    qmtest.target:

      local

 

--- TESTS THAT DID NOT PASS --------------------------------------------------

 

  oj.local.database.table_create                : FAIL   

    Expected error output from ISQL does not match actual error output.

 

 

--- STATISTICS ---------------------------------------------------------------

 

       1        tests total

       1 (100%) tests FAIL

 

 

Everything I do seems to keep coming back to this:  the test portion is not connecting to the database.

 

What can I do?  I am at a loss to know what else to try.  The solution seems tantalizingly close, but it's not there yet!

 

Please, if you can help me figure out what I need to do to get qmTest working for me, I will be deeply grateful.

 

 

Thanks!

 

Jeff Jones

 

 

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Philippe Makowski]

Jeff Jones - SHERIFFX  [08-03-28 00.04] :
> Please, if you can help me figure out what I need to do to get qmTest
> working for me, I will be deeply grateful.
>
Send us your test (.qmt file)


--
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel [phone]



-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Jeff Jones - SHERIFFX]

I have attached two tests.  The first is from the test suite, and the
second is one that I created.  I hope they can help you figure this
puzzle out!

Thanks!
 
Jeff
 
-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of
Philippe Makowski
Sent: Monday, April 07, 2008 09:01 AM
To: firebird-test@...
Subject: Re: [Firebird-test] Test will not connect to database (rather
long)

Jeff Jones - SHERIFFX  [08-03-28 00.04] :
> Please, if you can help me figure out what I need to do to get qmTest
> working for me, I will be deeply grateful.
>
Send us your test (.qmt file)


--
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel [phone]



------------------------------------------------------------------------
-
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/j
avaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test



-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Philippe Makowski]

Jeff Jones - SHERIFFX  [08-04-08 00.07] :
> I have attached two tests.  The first is from the test suite, and the
> second is one that I created.  I hope they can help you figure this
> puzzle out!
>
Why sending me the create_database_09 ?
I know this test ;)

and what do you wanted to do with your test ?
restore a db, and check if you can create a table in this db ?


--
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel [phone]



-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Philippe Makowski]

here the test file ok
(restore from fbk)

check your context values
and to be sure, use the test platform on a box where only 1 Firebird instance is running
(and no Interbase)


--
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel [phone]



<?xml version="1.0" ?><!DOCTYPE extension  PUBLIC '-//QM/2.4/Extension//EN'  'http://www.codesourcery.com/qm/dtds/2.4/-//qm/2.4/extension//en.dtd'><extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Restore From Backup</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>
       COUNT
============
           1

</text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>jonesj</text></argument><argument name="page_size"><enumeral>8192</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text>ojlocal.fbk</text></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>1.5</text></argument><argument name="description"><text/></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text/></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>ojlocal.fdb</text></argument><argument name="isql_script"><text/></argument><argument name="source_code"><text>select count(*) from rdb$database;
</text></argument><argument name="test_id"><text>oj.local.database.table_create</text></argument><argument name="target_platform"><text>Windows</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>Create a table</text></argument><argument name="drop_db"><enumeral>false</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Jeff Jones - SHERIFFX]

Philippe,

I created the test I sent to you simply to make sure that the qmTest
system works on my system.  So, I made it fairly simple and unlikely to
fail, IF the system is working correctly.

Unfortunately, it does not seem to make a connection using isql.  That
is what I am trying to figure out.

I have run this on a virtual machine where Firebird is installed and
running as a service, and almost nothing else is installed (especially
not Interbase!), still with no success.

I have checked my context file (and Pavel did, also) and it appears to
be fine.

Any ideas you may have about what to try next will be welcome.

If you wanted to send me a fairly benign test that connects to a
database with isql, and that works for you, I will be glad to try it out
here.

Thanks!
 
Jeff
 
-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of
Philippe Makowski
Sent: Tuesday, April 08, 2008 12:13 AM
To: firebird-test@...
Subject: Re: [Firebird-test] Test will not connect to database (rather
long)

here the test file ok
(restore from fbk)

check your context values
and to be sure, use the test platform on a box where only 1 Firebird
instance is running
(and no Interbase)


--
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel [phone]



-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Philippe Makowski]

Jeff Jones - SHERIFFX  [08-04-08 19.06] :
> If you wanted to send me a fairly benign test that connects to a
> database with isql, and that works for you, I will be glad to try it out
> here.
that's what I did
did you not saw the file ?


-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Jeff Jones - SHERIFFX]

Philippe,

I apologize for not replying sooner, but I have had to concentrate on
other things for a while.  Now I can return to testing.

Yes, I tried the file you sent, and I still get the same result.  It
appears that qmTest is not making a connection to the database before
trying to run my test.  Does it connect automatically?  Or do I need to
include a CONNECT statement?  I don't remember any tests in the suite
that had a CONNECT statement, but I could be wrong about that.

Also, I am testing with Firebird 1.5, not version 2.x.  Could this have
a bearing on my problem?

Another thing I found is that qmTest apparently restricts the size of
the database you can restore to less that 5Mb.  If the resulting file
you try to restore is larger than that, the results page will not be
displayed.  Is there a way to change that limit?  Or the timeout limit?

I appreciate your help, and I want to assure you that I would really
like to get this working for me.  Not only to help me, but also to help
you and Pavel with making the package more reliable and user-friendly.

Thanks!
 
Jeff
 
-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of
Philippe Makowski
Sent: Tuesday, April 08, 2008 12:27 PM
To: firebird-test@...
Subject: Re: [Firebird-test] Test will not connect to database (rather
long)

Jeff Jones - SHERIFFX  [08-04-08 19.06] :
> If you wanted to send me a fairly benign test that connects to a
> database with isql, and that works for you, I will be glad to try it
out
> here.
that's what I did
did you not saw the file ?


------------------------------------------------------------------------
-
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/j
avaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Pavel Cisar]

Hi Jeff,

I'm sorry for late answer, but I haven't enough time to dig deep into
your problem till now.

1. I can't reproduce your problem, although I tried very hard.
2. I think that I have solved it anyway :-)

It seems that certain Windows XP boxes have trouble with unicode. I have
failed to pinpoint it down to exact configuration, hence the vague
description, but it's for real. Anything older than WinXP can fail
miserably with unicode, but XP and newer should work just fine (and
mostly do) except when they don't. It seems that your Windows have
problem passing unicode strings as parameters for spawned process. The
solution should be simple, just call encode method on all parameter
values passed to __RunProgram in __ExecISQLCommandsBlind and
__ExecISQLCommands. Example:

    def __ExecISQLCommandsBlind(self):
        try:
            stdout, stderr=
self.__RunProgram(self.isql_script.encode('utf-8'),[self.__context["isql_path"],
                self.__dsn,
                "-user",     self.user_name,
                "-password", self.user_password])


change to:

    def __ExecISQLCommandsBlind(self):
        try:
            stdout, stderr=
self.__RunProgram(self.isql_script.encode('utf-8'),[self.__context["isql_path"],
                self.__dsn,
                "-user",     self.user_name.encode(),
                "-password", self.user_password.encode()])

This should encode parameters to ASCII by default. You can pass the
charset name to the encode if you want something else.

best regards
Pavel Cisar
IBPhoenix

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Jeff Jones - SHERIFFX]

Hey!  I found the problem!

In fbqa.py, here is the call to __RunProgram call in
__ExecISQLCommandsBlind:

stdout, stderr=
self.__RunProgram(self.isql_script.encode('utf-8'),[self.__context["isql
_path"],
                self.__dsn,
                "-user",     self.user_name,
                "-password", self.user_password])

And here is the call in __ExecISQLCommands:

stdout, stderr=
self.__RunProgram(self.source_code.encode('utf-8'),[self.__context["isql
_path"],
                self.__dsn,
                "-ch",       self.character_set,
                "-user",     self.user_name,
                "-password", self.user_password])

When I commented out the "-ch" parameter in the second call, my test
worked.  I don't quite understand why, but I am not going to question it
just yet.

Can you tell my why this would work?

Jeff
 
-----Original Message-----
From: firebird-test-bounces@...
[mailto:firebird-test-bounces@...] On Behalf Of Pavel
Cisar
Sent: Monday, April 14, 2008 08:56 AM
To: firebird-test@...
Subject: Re: [Firebird-test] Test will not connect to database (rather
long)

Hi Jeff,

I'm sorry for late answer, but I haven't enough time to dig deep into
your problem till now.

1. I can't reproduce your problem, although I tried very hard.
2. I think that I have solved it anyway :-)

It seems that certain Windows XP boxes have trouble with unicode. I have
failed to pinpoint it down to exact configuration, hence the vague
description, but it's for real. Anything older than WinXP can fail
miserably with unicode, but XP and newer should work just fine (and
mostly do) except when they don't. It seems that your Windows have
problem passing unicode strings as parameters for spawned process. The
solution should be simple, just call encode method on all parameter
values passed to __RunProgram in __ExecISQLCommandsBlind and
__ExecISQLCommands. Example:

    def __ExecISQLCommandsBlind(self):
        try:
            stdout, stderr=
self.__RunProgram(self.isql_script.encode('utf-8'),[self.__context["isql
_path"],
                self.__dsn,
                "-user",     self.user_name,
                "-password", self.user_password])


change to:

    def __ExecISQLCommandsBlind(self):
        try:
            stdout, stderr=
self.__RunProgram(self.isql_script.encode('utf-8'),[self.__context["isql
_path"],
                self.__dsn,
                "-user",     self.user_name.encode(),
                "-password", self.user_password.encode()])

This should encode parameters to ASCII by default. You can pass the
charset name to the encode if you want something else.

best regards
Pavel Cisar
IBPhoenix

------------------------------------------------------------------------
-
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/j
avaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Leyne, Sean]

 

> And here is the call in __ExecISQLCommands:
>
> stdout, stderr=
> self.__RunProgram(self.source_code.encode('utf-8'),[self.__con
> text["isql
> _path"],
>                 self.__dsn,
>                 "-ch",       self.character_set,
>                 "-user",     self.user_name,
>                 "-password", self.user_password])
>
> When I commented out the "-ch" parameter in the second call,
> my test worked.  I don't quite understand why, but I am not
> going to question it just yet.
>
> Can you tell my why this would work?

What version of FB are you trying to connect to/test with?


Sean

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test