firebird-test — Firebird engine testing, test flight/suite discussion/information

Re: [Firebird-test] Test will not connect to database (rather long)

[Pavel C. <pc...@ib...>]

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

Re: [Firebird-test] Test will not connect to database (rather long)

[Jeff J. - S. <J_...@MC...>]

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: fir...@li...
[mailto:fir...@li...] On Behalf Of
Philippe Makowski
Sent: Tuesday, April 08, 2008 12:27 PM
To: fir...@li...
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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Test will not connect to database (rather long)

[Philippe M. <mak...@fi...>]

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 ?

Re: [Firebird-test] Test will not connect to database (rather long)

[Jeff J. - S. <J_...@MC...>]

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: fir...@li...
[mailto:fir...@li...] On Behalf Of
Philippe Makowski
Sent: Tuesday, April 08, 2008 12:13 AM
To: fir...@li...
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 +33 (0) 561058813

Re: [Firebird-test] Test will not connect to database (rather long)

[Philippe M. <mak...@fi...>]

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 +33 (0) 561058813

Re: [Firebird-test] Test will not connect to database (rather long)

[Philippe M. <mak...@fi...>]

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 +33 (0) 561058813

Re: [Firebird-test] Test will not connect to database (rather long)

[Jeff J. - S. <J_...@MC...>]

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: fir...@li...
[mailto:fir...@li...] On Behalf Of
Philippe Makowski
Sent: Monday, April 07, 2008 09:01 AM
To: fir...@li...
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 +33 (0) 561058813



------------------------------------------------------------------------
-
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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Test will not connect to database (rather long)

[Philippe M. <mak...@fi...>]

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 +33 (0) 561058813

[Firebird-test] Test will not connect to database (rather long)

[Jeff J. - S. <J_...@MC...>]

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

 

 

Re: [Firebird-test] Exception when running test

[Philippe M. <mak...@fi...>]

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

Re: [Firebird-test] Exception when running test

[Jeff J. - S. <J_...@MC...>]

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: fir...@li...
[mailto:fir...@li...] On Behalf Of
Philippe Makowski
Sent: Wednesday, March 26, 2008 10:29 AM
To: fir...@li...
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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Exception when running test

[Philippe M. <mak...@fi...>]

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

Re: [Firebird-test] Exception when running test

[Jeff J. - S. <J_...@MC...>]

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: fir...@li...
[mailto:fir...@li...] On Behalf Of Pavel
Cisar
Sent: Thursday, March 20, 2008 10:16 AM
To: fir...@li...
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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Exception when running test

[Jeff J. - S. <J_...@MC...>]

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: fir...@li...
[mailto:fir...@li...] On Behalf Of Pavel
Cisar
Sent: Thursday, March 20, 2008 10:16 AM
To: fir...@li...
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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Exception when running test

[Pavel C. <pc...@ib...>]

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

Re: [Firebird-test] Exception when running test

[Jeff J. - S. <J_...@MC...>]

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: fir...@li...
[mailto:fir...@li...] On Behalf Of Pavel
Cisar
Sent: Thursday, March 20, 2008 08:15 AM
To: fir...@li...
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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Exception when running test

[Pavel C. <pc...@ib...>]

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

[Firebird-test] Exception when running test

[Jeff J. - S. <J_...@MC...>]

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

 

 

Re: [Firebird-test] Firebird testing tools for Windows

[Pavel C. <pc...@ib...>]

Jeff,

Jeff Jones - SHERIFFX napsal(a):
> 
> I thought I had KinterbasDB installed, but it turns out that I did not.
> When that is installed, qmedit works much better!
> 
> Again, thank you, Pavel, for your assistance.

You are welcome. You'll probably find out that qmedit (and other tools
like qareport as well) is a little bit crude tool. It was developed to
satisfy our specific needs and support our QA process (like test naming
convention, test versioning etc.), and may not fit well to your specific
needs. However, it doesn't mean we're not interested to develop it
beyond that. In fact, we would be more than happy if it would outgrow
our QA sandbox and become generally usable tool set for Firebird. We
just haven't the incentive to do so yet (you're the first one from
outside the project who seriously considers to use this tool chain). So,
feel free to give us feedback on usability of these tools, or even
better, you can cooperate with us to improve or extend them or just send
us patches.

best regards
Pavel Cisar
IBPhoenix

Re: [Firebird-test] Firebird testing tools for Windows

[Jeff J. - S. <J_...@MC...>]

Okay, now I feel silly!

I thought I had KinterbasDB installed, but it turns out that I did not.
When that is installed, qmedit works much better!

Again, thank you, Pavel, for your assistance.

Jeff
 
-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of Pavel
Cisar
Sent: Wednesday, March 19, 2008 02:41 PM
To: fir...@li...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff Jones - SHERIFFX napsal(a):
> Hey!  I just tried this with Internet Explorer 7 and it worked!
> 
> Why would it not work with Mozilla Firefox?  Is there a setting I need
> to check?  I would rather use Firefox...

It works with Firefox for me (and always was). Maybe some FF plugin you
have installed? Or you have JavaScript disabled in FF?

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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Firebird testing tools for Windows

[Jeff J. - S. <J_...@MC...>]

I checked the setup for Firefox and JavaScript is enabled, but this
still will not work.  It does work with IE 7, so I will just use that
for now.

Next problem:  I cannot get qmedit to run for me.  I tried running it
from a command window, and here are the results:

---
C:\fbtest>qmedit.py
Traceback (most recent call last):
  File "c:\SVNRepository\qmedit\qmedit.py", line 51, in <module>
    app = qmEditApp(False)
  File "C:\Python25\Lib\site-packages\wx-2.8-msw-unicode\wx\_core.py",
line 7936
, in __init__
    wx.App.__init__(self, redirect, filename, useBestVisual,
clearSigInt)
  File "C:\Python25\Lib\site-packages\wx-2.8-msw-unicode\wx\_core.py",
line 7836
, in __init__
    self._BootstrapApp()
  File "C:\Python25\Lib\site-packages\wx-2.8-msw-unicode\wx\_core.py",
line 7433
, in _BootstrapApp
    return _core_.PyApp__BootstrapApp(*args, **kwargs)
  File "c:\SVNRepository\qmedit\qmedit.py", line 38, in OnInit
    self.model = qmedit_model.qmDatabaseWrapper()
  File "C:\SVNRepository\qmedit\qmedit_model.py", line 59, in __init__
    self._setDatabase(databasePath)
  File "C:\SVNRepository\qmedit\qmedit_model.py", line 70, in
_setDatabase
 
self.testmap.setdefault(self.db.GetItem('test',t).GetArguments()['test_i
d'],
[]).append(t)
  File "C:\Python25\Lib\site-packages\qm\test\database.py", line 941, in
GetItem

    Database.SUITE : self.GetSuite } [kind] (item_id)
  File "C:\Python25\Lib\site-packages\qm\test\file_database.py", line
58, in Get
Test
    return self._GetTestFromPath(test_id, os.path.normpath(path))
  File "C:\Python25\Lib\site-packages\qm\test\classes\xml_database.py",
line 69,
 in _GetTestFromPath
    raise TestFileError, message
qm.test.classes.xml_database.TestFileError: A problem occurred while
loading the
 XML test file "functional.arno.indexes.lower_bound_asc_02_segments_01":
Exception '<type 'exceptions.ImportError'>' : 'No module named
kinterbasdb'

  File "C:\Python25\Lib\site-packages\qm\test\base.py", line 230, in
get_extensi
on_class_from_directory
    path + sys.path)

  File "C:\Python25\Lib\site-packages\qm\common.py", line 363, in
load_class
    module = load_module(module_name, search_path, load_path)

  File "C:\Python25\Lib\site-packages\qm\common.py", line 309, in
load_module
    module = imp.load_module(name, file, file_name, description)

  File "C:\fbtest\QMTest\fbqa.py", line 38, in <module>
    import sys, os, string, re, difflib, kinterbasdb as kdb, struct,
cgi, types


The "fbqa.FirebirdTest" extension class could not be loaded.

C:\fbtest>
---

Any ideas on why this is not working?

Your help has been very valuable to me.  I appreciate the time you have
taken.

Thanks!
 
Jeff
 

-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of Pavel
Cisar
Sent: Wednesday, March 19, 2008 02:41 PM
To: fir...@li...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff Jones - SHERIFFX napsal(a):
> Hey!  I just tried this with Internet Explorer 7 and it worked!
> 
> Why would it not work with Mozilla Firefox?  Is there a setting I need
> to check?  I would rather use Firefox...

It works with Firefox for me (and always was). Maybe some FF plugin you
have installed? Or you have JavaScript disabled in FF?

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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Firebird testing tools for Windows

[Pavel C. <pc...@ib...>]

Jeff Jones - SHERIFFX napsal(a):
> Hey!  I just tried this with Internet Explorer 7 and it worked!
> 
> Why would it not work with Mozilla Firefox?  Is there a setting I need
> to check?  I would rather use Firefox...

It works with Firefox for me (and always was). Maybe some FF plugin you
have installed? Or you have JavaScript disabled in FF?

best regards
Pavel Cisar
IBPhoenix

Re: [Firebird-test] Firebird testing tools for Windows

[Jeff J. - S. <J_...@MC...>]

Hey!  I just tried this with Internet Explorer 7 and it worked!

Why would it not work with Mozilla Firefox?  Is there a setting I need
to check?  I would rather use Firefox...

Thanks!
 
Jeff
 

-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of Pavel
Cisar
Sent: Wednesday, March 19, 2008 01:10 PM
To: fir...@li...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff,

Jeff Jones - SHERIFFX napsal(a):
> 
> Thank you very much for your assistance.  It has gotten me closer to
my
> goal (I think).
> 
> However, I still am unable to successfully run the qmtest gui.  I will
> try to describe all that I have done.
> 
> I have installed ActivePython, the PyWin32 extensions, wxPython
> (Unicode), KinterbasDB, QMTest, and the Subversion client.
> 
> The /Python25/ and /Python25/scripts/ directories are both in the
PATH.

So far so good.

> I used qadbm to create my test database at c:/fbtest/, and it
> successfully copied the tests from your test suite.

Just to be sure, you did CREATE and then COPY, right? The qadbm.py tools
is very old (one from my first Python tools) and haven't very intuitive
interface (guess I'll rewrite it soon). The CREATE command creates the
destination directory and copies the QMTest subdirectory there. This
subdirectory in fact makes it a test database for QMTest. It contains
some configuration files and our extension classes for QMTest. The COPY
command just copies test files around.

> In the test directory is a context file (context.txt).  Here are the
> contents of this file:
> 
> ---
> temp_directory=c:/fbtest/temp/
> server_location=localhost/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"
> gsec_path="C:/Program Files/Firebird/Firebird_1_5/bin/gsec"
> gstat_path="C:/Program Files/Firebird/Firebird_1_5/bin/gstat"
> gbak_path="C:/Program Files/Firebird/Firebird_1_5/bin/gbak"
> #nbackup_path="C:/Program Files/Firebird/Firebird_1_5/bin/nbackup"
> gfix_path="C:/Program Files/Firebird/Firebird_1_5/bin/gfix"
> gpre_path="C:/Program Files/Firebird/Firebird_1_5/bin/gpre"
> ---
>
> Does this look okay?  (I do have Firebird running on port 3040,
because
> Interbase is running on port 3050.  Also, I don't know if the values
for
> the paths need to have the double quotes around them, even though they
> have a space embedded in them.  What do you think?)

Paths with spaces doesn't need to be escaped / enclosed in double
quotes. I'm not sure now whether they can hurt or not, but it should
definitely work without them. The server_location is correct.

Important thing: The qadbm tool doesn't copies support files like
databases or backup files when you create a working test database! It
somehow makes sense as they're shared. So you should point your context
entries for suite_database_location, backup_location and files_location
to directories where they really reside (in your SVN repository
checkout).

> Also in the c:/fbtest/ directory is a .bat file with which I want to
run
> the GUI.  Here are its contents:
> 
> ---
> cd..
> cd /fbtest
> qmtest.py gui -C context.txt
> ---
> 
> When I double-click this file, a command window opens, then my browser
> (Mozilla Firefox) opens, it waits for a few seconds, then displays the
> "Page cannot be displayed" message.  The address in the browser's
> address line is:
> 
> http://127.0.0.1:1330/test/dir
> 
> It seems like I'm getting close, but still no success.  Any
suggestions?

Well, something went wrong half-way through QMTest initialization. The
best way to find out what's wrong is to run this bat file from command
prompt. Just open the new console window, switch to your test database
directory and run the bat file from there. QMTest will prints all
messages to console, and this way it wouldn't close on you.

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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Firebird testing tools for Windows

[Jeff J. - S. <J_...@MC...>]

Pavel,

I tried running the .bat file from the command window, and the behavior
is the same.  The only thing that shows up in the command window is:

QMTest running at http://127.0.0.1:1421/test/dir

It seems like there ought to be more output, but nothing appears.  The
browser stays open, and the command window does not close, and does not
return to the C: prompt.

Thanks for staying with me, I really appreciate it.

Jeff
 

-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of Pavel
Cisar
Sent: Wednesday, March 19, 2008 01:10 PM
To: fir...@li...
Subject: Re: [Firebird-test] Firebird testing tools for Windows

Jeff,

Jeff Jones - SHERIFFX napsal(a):
> 
> Thank you very much for your assistance.  It has gotten me closer to
my
> goal (I think).
> 
> However, I still am unable to successfully run the qmtest gui.  I will
> try to describe all that I have done.
> 
> I have installed ActivePython, the PyWin32 extensions, wxPython
> (Unicode), KinterbasDB, QMTest, and the Subversion client.
> 
> The /Python25/ and /Python25/scripts/ directories are both in the
PATH.

So far so good.

> I used qadbm to create my test database at c:/fbtest/, and it
> successfully copied the tests from your test suite.

Just to be sure, you did CREATE and then COPY, right? The qadbm.py tools
is very old (one from my first Python tools) and haven't very intuitive
interface (guess I'll rewrite it soon). The CREATE command creates the
destination directory and copies the QMTest subdirectory there. This
subdirectory in fact makes it a test database for QMTest. It contains
some configuration files and our extension classes for QMTest. The COPY
command just copies test files around.

> In the test directory is a context file (context.txt).  Here are the
> contents of this file:
> 
> ---
> temp_directory=c:/fbtest/temp/
> server_location=localhost/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"
> gsec_path="C:/Program Files/Firebird/Firebird_1_5/bin/gsec"
> gstat_path="C:/Program Files/Firebird/Firebird_1_5/bin/gstat"
> gbak_path="C:/Program Files/Firebird/Firebird_1_5/bin/gbak"
> #nbackup_path="C:/Program Files/Firebird/Firebird_1_5/bin/nbackup"
> gfix_path="C:/Program Files/Firebird/Firebird_1_5/bin/gfix"
> gpre_path="C:/Program Files/Firebird/Firebird_1_5/bin/gpre"
> ---
>
> Does this look okay?  (I do have Firebird running on port 3040,
because
> Interbase is running on port 3050.  Also, I don't know if the values
for
> the paths need to have the double quotes around them, even though they
> have a space embedded in them.  What do you think?)

Paths with spaces doesn't need to be escaped / enclosed in double
quotes. I'm not sure now whether they can hurt or not, but it should
definitely work without them. The server_location is correct.

Important thing: The qadbm tool doesn't copies support files like
databases or backup files when you create a working test database! It
somehow makes sense as they're shared. So you should point your context
entries for suite_database_location, backup_location and files_location
to directories where they really reside (in your SVN repository
checkout).

> Also in the c:/fbtest/ directory is a .bat file with which I want to
run
> the GUI.  Here are its contents:
> 
> ---
> cd..
> cd /fbtest
> qmtest.py gui -C context.txt
> ---
> 
> When I double-click this file, a command window opens, then my browser
> (Mozilla Firefox) opens, it waits for a few seconds, then displays the
> "Page cannot be displayed" message.  The address in the browser's
> address line is:
> 
> http://127.0.0.1:1330/test/dir
> 
> It seems like I'm getting close, but still no success.  Any
suggestions?

Well, something went wrong half-way through QMTest initialization. The
best way to find out what's wrong is to run this bat file from command
prompt. Just open the new console window, switch to your test database
directory and run the bat file from there. QMTest will prints all
messages to console, and this way it wouldn't close on you.

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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Firebird testing tools for Windows

[Pavel C. <pc...@ib...>]

Jeff,

Jeff Jones - SHERIFFX napsal(a):
> 
> Thank you very much for your assistance.  It has gotten me closer to my
> goal (I think).
> 
> However, I still am unable to successfully run the qmtest gui.  I will
> try to describe all that I have done.
> 
> I have installed ActivePython, the PyWin32 extensions, wxPython
> (Unicode), KinterbasDB, QMTest, and the Subversion client.
> 
> The /Python25/ and /Python25/scripts/ directories are both in the PATH.

So far so good.

> I used qadbm to create my test database at c:/fbtest/, and it
> successfully copied the tests from your test suite.

Just to be sure, you did CREATE and then COPY, right? The qadbm.py tools
is very old (one from my first Python tools) and haven't very intuitive
interface (guess I'll rewrite it soon). The CREATE command creates the
destination directory and copies the QMTest subdirectory there. This
subdirectory in fact makes it a test database for QMTest. It contains
some configuration files and our extension classes for QMTest. The COPY
command just copies test files around.

> In the test directory is a context file (context.txt).  Here are the
> contents of this file:
> 
> ---
> temp_directory=c:/fbtest/temp/
> server_location=localhost/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"
> gsec_path="C:/Program Files/Firebird/Firebird_1_5/bin/gsec"
> gstat_path="C:/Program Files/Firebird/Firebird_1_5/bin/gstat"
> gbak_path="C:/Program Files/Firebird/Firebird_1_5/bin/gbak"
> #nbackup_path="C:/Program Files/Firebird/Firebird_1_5/bin/nbackup"
> gfix_path="C:/Program Files/Firebird/Firebird_1_5/bin/gfix"
> gpre_path="C:/Program Files/Firebird/Firebird_1_5/bin/gpre"
> ---
>
> Does this look okay?  (I do have Firebird running on port 3040, because
> Interbase is running on port 3050.  Also, I don't know if the values for
> the paths need to have the double quotes around them, even though they
> have a space embedded in them.  What do you think?)

Paths with spaces doesn't need to be escaped / enclosed in double
quotes. I'm not sure now whether they can hurt or not, but it should
definitely work without them. The server_location is correct.

Important thing: The qadbm tool doesn't copies support files like
databases or backup files when you create a working test database! It
somehow makes sense as they're shared. So you should point your context
entries for suite_database_location, backup_location and files_location
to directories where they really reside (in your SVN repository checkout).

> Also in the c:/fbtest/ directory is a .bat file with which I want to run
> the GUI.  Here are its contents:
> 
> ---
> cd..
> cd /fbtest
> qmtest.py gui -C context.txt
> ---
> 
> When I double-click this file, a command window opens, then my browser
> (Mozilla Firefox) opens, it waits for a few seconds, then displays the
> "Page cannot be displayed" message.  The address in the browser's
> address line is:
> 
> http://127.0.0.1:1330/test/dir
> 
> It seems like I'm getting close, but still no success.  Any suggestions?

Well, something went wrong half-way through QMTest initialization. The
best way to find out what's wrong is to run this bat file from command
prompt. Just open the new console window, switch to your test database
directory and run the bat file from there. QMTest will prints all
messages to console, and this way it wouldn't close on you.

best regards
Pavel Cisar
IBPhoenix