Can you run the MySQL command it is using manually from a prompt?
K:/Program Files/MySQL/MySQL Server 5.0/bin/mysql.exe --passwd="webpy"
--host="localhost" --port="3307" --user="webpy"
The normal port MySQL binds to is 3306 but I know (at least on Linux) if
you specify "localhost" instead of 127.0.0.1 it will use pipes instead
of TCP so the port doesn't even matter. Not sure how it is on Windows.
-Seth
On Thu, 2007-12-20 at 23:15 +0800, Steven Yip wrote:
> 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 email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
-------------------------------------------------------------------------
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
