Is it safe (from the perspective of queries syntax or stability) to use MySQLdb in web2py (DAL), or is it better to use it "manually" as an import and use raw SQL for accessing MySQL 3? If have found this url showing the changes needed http://code.google.com/p/web2py/source/diff?spec=svnfc75444ca55590835b4d0dc0e6c06a85e3f282a8&r=fc75444ca55590835b4d0dc0e6c06a85e3f282a8&format=side&path=/gluon/dal.py
On Saturday, March 3, 2012 9:06:41 PM UTC+1, Alan Etkin wrote: > > If web2py uses pymysql, then it should not work with version 3: > > (pymysql) Requirements > > Python 2.4 or higher > > http://www.python.org/ > 2.6 is the primary test environment. > > MySQL 4.1 or higher > > protocol41 support, experimental 4.0 support > > With some modifications, it should be possible to accept another > library in the MySQL adpater. For example, PostgreSQL adpater now > accepts two optional db interface libraries specified in the db uri. > > On 3 mar, 13:52, Ralo Tannahill <[email protected]> wrote: > > Hello all > > > > I'm new to python and web2py, and I'm evaluating them to make new > > developments accessing legacy databases (MSSQL 2000, MySQL 3 and MySQL 5 > ). > > I've tried the connection strings shown in the web2py book, but I can > > connect only to MySQL 5. > > > > - The error connecting to MySQL 3 is "access denied for user > > @databaseServer (using password: NO)", because no username or password > is > > passed to the server . > > Is it a problem with pymysql? Searching in google, I found the python > > module "MySQLdb" and with that module I can connect to both MySQL 3 and > 5. > > Could I configure web2py to use MySQLdb instead of pymysql? > > > > - The error connecting to MSSQL says that I don't specify a DSN or > driver > > > > I am using CENTOS 6 (64bits) + python 2.6 + apache + mod_wsgi > > I'd appreciate any help, thanks in advance
