[Webware-discuss] Getting mysql 5 to work with alltests.py

Thu, 20 Dec 2007 07:16:03 -0800 

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
*

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:[EMAIL PROTECTED]
title:Product Development
tel;work:03-91305218
url:http://www.neowave.com.my
version:2.1
end:vcard


-------------------------------------------------------------------------
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/webware-discuss






















					Reply via email to