Content-Type: multipart/alternative; boundary="------------000005060003050905030108" --------------000005060003050905030108 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 * --------------000005060003050905030108 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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

--------------000005060003050905030108--