[Webware-discuss] 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
Re: [Webware-discuss] Getting mysql 5 to work with alltests.py
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
Re: [Webware-discuss] Getting mysql 5 to work with alltests.py
Steven Yip wrote: But when I ran the AllTests.py, I got this error: Besides the problem mentioned by Seth, there was a bug in UserManagerTest - it did not work with a database password. I have just fixed that in r7158. You can download the fixed UserManagerTest.py here: http://svn.w4py.org/Webware/trunk/UserKit/Tests/UserManagerTest.py -- Chris - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Webware-discuss mailing list Webware-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/webware-discuss
[Webware-discuss] Getting mysql 5 to work with alltests.py
On Thu, 20 Dec 2007 23:15:50 +0800, Steven Yip [EMAIL PROTECTED] wrote: 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 ... * 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', ... Anything that I missed? Yes, you missed the difference between your path and the example in the comments: spaces in the path name. You should be able to wrap an extra set of quotes around it: 'mysqlClient': 'k:/Program Files/MySQL/MySQL Server 5.0/bin/mysql.exe' but if that doesn't do it, you'll have to use the short paths, as the example does. The number after the tilde can vary, so you should check them, but it probably looks like the example: 'mysqlClient': 'K:/progra~1/mysql/mysqls~1.0/bin/mysql.exe' To check it yourself, in a cmd shell, do this: dir /x k:\prog* and dir /x k:\Program Files\MySQL\My* -- Tim Roberts, [EMAIL PROTECTED] Providenza Boekelheide, Inc. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Webware-discuss mailing list Webware-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/webware-discuss
Re: [Webware-discuss] Getting mysql 5 to work with alltests.py
You can also leave the defaults 'extraSysPath': [], 'mysqlClient': 'mysql', if you put K:/Program Files/MySQL/MySQL Server 5.0/bin in your Windows PATH. -- Chris - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Webware-discuss mailing list Webware-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/webware-discuss