Getting mysql 5 to work with alltests.py

hi,

I am a bit new to this. I am trying to run webware and python, Apache 
with mysql 5 on windows 2003.

I am trying to get the mysql to work.

But when I ran the AllTests.py, I got this error:

*======================================================================
ERROR: testBasics (UserKit.Tests.UserManagerTest.UserManagerToMiddleKitTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "UserKit\Tests\UserManagerTest.py", line 230, in setUp
    raise OSError, 'Error running: %s' % executeSqlCmd
OSError: Error running: K:/Program Files/MySQL/MySQL Server 
5.0/bin/mysql.exe --
passwd="webpy" --host="localhost" --port="3307" --user="webpy" < 
K:\Downloads\We
bware-0.9.4\Webware-0.9.4\UserKit\Tests\mk_MySQL\GeneratedSQL\Create.sql

======================================================================
ERROR: testDuplicateUser 
(UserKit.Tests.UserManagerTest.UserManagerToMiddleKitTe
st)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "UserKit\Tests\UserManagerTest.py", line 230, in setUp
    raise OSError, 'Error running: %s' % executeSqlCmd
OSError: Error running: K:/Program Files/MySQL/MySQL Server 
5.0/bin/mysql.exe --
passwd="webpy" --host="localhost" --port="3307" --user="webpy" < 
K:\Downloads\We
bware-0.9.4\Webware-0.9.4\UserKit\Tests\mk_MySQL\GeneratedSQL\Create.sql

======================================================================
ERROR: testUserAccess 
(UserKit.Tests.UserManagerTest.UserManagerToMiddleKitTest)

----------------------------------------------------------------------
Traceback (most recent call last):
  File "UserKit\Tests\UserManagerTest.py", line 230, in setUp
    raise OSError, 'Error running: %s' % executeSqlCmd
OSError: Error running: K:/Program Files/MySQL/MySQL Server 
5.0/bin/mysql.exe --
passwd="webpy" --host="localhost" --port="3307" --user="webpy" < 
K:\Downloads\We
bware-0.9.4\Webware-0.9.4\UserKit\Tests\mk_MySQL\GeneratedSQL\Create.sql

======================================================================
ERROR: testUserClass 
(UserKit.Tests.UserManagerTest.UserManagerToMiddleKitTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "UserKit\Tests\UserManagerTest.py", line 230, in setUp
    raise OSError, 'Error running: %s' % executeSqlCmd
OSError: Error running: K:/Program Files/MySQL/MySQL Server 
5.0/bin/mysql.exe --
passwd="webpy" --host="localhost" --port="3307" --user="webpy" < 
K:\Downloads\We
bware-0.9.4\Webware-0.9.4\UserKit\Tests\mk_MySQL\GeneratedSQL\Create.sql

======================================================================
ERROR: testBasics 
(UserKit.Tests.UserManagerTest.RoleUserManagerToMiddleKitTest)

----------------------------------------------------------------------
Traceback (most recent call last):
  File "UserKit\Tests\UserManagerTest.py", line 230, in setUp
    raise OSError, 'Error running: %s' % executeSqlCmd
OSError: Error running: K:/Program Files/MySQL/MySQL Server 
5.0/bin/mysql.exe --
passwd="webpy" --host="localhost" --port="3307" --user="webpy" < 
K:\Downloads\We
bware-0.9.4\Webware-0.9.4\UserKit\Tests\mk_MySQL\GeneratedSQL\Create.sql

======================================================================
ERROR: testDuplicateUser 
(UserKit.Tests.UserManagerTest.RoleUserManagerToMiddleK
itTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "UserKit\Tests\UserManagerTest.py", line 230, in setUp
    raise OSError, 'Error running: %s' % executeSqlCmd
OSError: Error running: K:/Program Files/MySQL/MySQL Server 
5.0/bin/mysql.exe --
passwd="webpy" --host="localhost" --port="3307" --user="webpy" < 
K:\Downloads\We
bware-0.9.4\Webware-0.9.4\UserKit\Tests\mk_MySQL\GeneratedSQL\Create.sql

======================================================================
ERROR: testUserAccess 
(UserKit.Tests.UserManagerTest.RoleUserManagerToMiddleKitT
est)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "UserKit\Tests\UserManagerTest.py", line 230, in setUp
    raise OSError, 'Error running: %s' % executeSqlCmd
OSError: Error running: K:/Program Files/MySQL/MySQL Server 
5.0/bin/mysql.exe --
passwd="webpy" --host="localhost" --port="3307" --user="webpy" < 
K:\Downloads\We
bware-0.9.4\Webware-0.9.4\UserKit\Tests\mk_MySQL\GeneratedSQL\Create.sql

======================================================================
ERROR: testUserClass 
(UserKit.Tests.UserManagerTest.RoleUserManagerToMiddleKitTe
st)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "UserKit\Tests\UserManagerTest.py", line 230, in setUp
    raise OSError, 'Error running: %s' % executeSqlCmd
OSError: Error running: K:/Program Files/MySQL/MySQL Server 
5.0/bin/mysql.exe --
passwd="webpy" --host="localhost" --port="3307" --user="webpy" < 
K:\Downloads\We
bware-0.9.4\Webware-0.9.4\UserKit\Tests\mk_MySQL\GeneratedSQL\Create.sql

----------------------------------------------------------------------
Ran 83 tests in 18.984s
*
My all AllTests.config is as below

*
{    # Edit this file to activate more tests

    # Turn on tests that use MySQL?
    'hasMysql': True,

    # If hasMysql is true, then these are used to connect:
    'mysqlTestInfo' : {

        # Where is MySQLdb lib located?
        # 'extraSysPath': ['/somewhere/MySQL-python-1.2.2/build/lib'],
        'extraSysPath': ['K:/Python25/Lib/site-packages/MySQLdb'],

        # Where is the MySQL client located (if not on the path)?
        # 'mysqlClient': '/usr/local/mysql/bin/mysql',
        # 'mysqlClient': 'c:/progra~1/mysql/mysqls~1.0/bin/mysql.exe',
        'mysqlClient': 'K:/Program Files/MySQL/MySQL Server 
5.0/bin/mysql.exe',

        # The name of the MySQL database to be used:
        'database': 'webpy', # Test case uses this,
        # but UserManagerTest.mkmodel/Settings.config also defines it.

        # This is passed to MySQLObjectStore():
        'DatabaseArgs': {
            'host': 'localhost',
            'port': 3307,
            'user': 'webpy', # should have all database privileges
            'passwd': 'webpy',
        },
    }
}

Anything that I missed?
Thanks...

Steven Yip
*

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

_______________________________________________
Webware-discuss mailing list
Webware-discuss-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/webware-discuss

begin:vcard
fn:Steven Yip
n:;Steven Yip
org:Neowave Sdn Bhd
adr:KM 8, Jln Cheras;;68-5-18, Jln 5/101c, Blok H, Cheras Business Center;Kuala Lumpur;Kuala Lumpur;56100;Malaysia
email;internet:yipwt-7Ua4W+ZmG5QZ+IcD6AW/[email protected]
title:Product Development
tel;work:03-91305218
url:http://www.neowave.com.my
version:2.1
end:vcard