Hi Maybe your connection string is "mysql://....". Using pymysql with sqlalchemy, connection string must be "mysql+pymysql://...."
Cheers 2012/5/29 Learner <[email protected]> > Hi Atsushi, > > Thanks. I installed PyMySQL now and modified setup.py to include > pymysql library. But Pyramid is still looking for "MysqlDB" module. > May be I am missing something? Please excuse my novice skills > > Log trace > > (pyramid) D:\learner\python\pyramid\projects\tutorial>pserve > development.ini --reload > Starting subprocess with file monitor > Traceback (most recent call last): > File "D:\learner\python\pyramid\Scripts\pserve-script.py", line 8, > in <module> > load_entry_point('pyramid==1.3.2', 'console_scripts', 'pserve')() > File "D:\learner\python\pyramid\lib\site-packages\pyramid-1.3.2- > py2.7.egg\pyramid\scripts\pserve.py", line 47, in main > return command.run() > File "D:\learner\python\pyramid\lib\site-packages\pyramid-1.3.2- > py2.7.egg\pyramid\scripts\pserve.py", line 290, in run > relative_to=base, global_conf=vars) > File "D:\learner\python\pyramid\lib\site-packages\pyramid-1.3.2- > py2.7.egg\pyramid\scripts\pserve.py", line 318, in loadapp > return loadapp(app_spec, name=name, relative_to=relative_to, **kw) > File "D:\learner\python\pyramid\lib\site-packages\pastedeploy-1.5.0- > py2.7.egg\paste\deploy\loadwsgi.py", line 247, in loadapp > return loadobj(APP, uri, name=name, **kw) > File "D:\learner\python\pyramid\lib\site-packages\pastedeploy-1.5.0- > py2.7.egg\paste\deploy\loadwsgi.py", line 272, in loadobj > return context.create() > File "D:\learner\python\pyramid\lib\site-packages\pastedeploy-1.5.0- > py2.7.egg\paste\deploy\loadwsgi.py", line 710, in create > return self.object_type.invoke(self) > File "D:\learner\python\pyramid\lib\site-packages\pastedeploy-1.5.0- > py2.7.egg\paste\deploy\loadwsgi.py", line 146, in invoke > return fix_call(context.object, context.global_conf, > **context.local_conf) > File "D:\learner\python\pyramid\lib\site-packages\pastedeploy-1.5.0- > py2.7.egg\paste\deploy\util.py", line 56, in fix_call > val = callable(*args, **kw) > File "d:\learner\python\pyramid\projects\tutorial\tutorial > \__init__.py", line 9, in main > engine = engine_from_config(settings, 'sqlalchemy.') > File "build\bdist.win32\egg\sqlalchemy\engine\__init__.py", line > 354, in engine_from_config > File "build\bdist.win32\egg\sqlalchemy\engine\__init__.py", line > 336, in create_engine > File "build\bdist.win32\egg\sqlalchemy\engine\strategies.py", line > 64, in create > File "build\bdist.win32\egg\sqlalchemy\connectors\mysqldb.py", line > 52, in dbapi > ImportError: No module named MySQLdb > > > Any response is much appreciated > > cheers > -bkumar > > On May 28, 7:29 am, Atsushi Odagiri <[email protected]> wrote: > > Hi > > > > I'm using PyMySQL for MySQL Driver. > > It's pure python, so you don't need compile that. > > > > Cheers > > > > 2012/5/28 Chris Lambacher <[email protected]> > > > > > > > > > > > > > > > > > > > > > It looks like it is going to try to build MySQL-python from c source. > The > > > error may be because of a missing compiler or maybe the MySQL header > file > > > or .lib file is missing. > > > > > Seehttp:// > stackoverflow.com/questions/645943/mysql-for-python-in-windowsforinstructionson > getting MySQL-python for windows installed on your > > > system. Note, if you are working against a virtualenv (you are if you > are > > > following the tutorial), you can easy_install the downloaded exe > installer > > > to get it in your virtualenv. > > > > > -Chris > > > > > On Sunday, May 27, 2012, Learner wrote: > > > > >> Hello All, > > > > >> I just started learning Pyramid & Python together. Pyramid > > >> documentation is amazing, step by step instructions are really > > >> helpful for a basic learner like me. > > > > >> I created a simple Pyramid (SqlAlchemy) application using > > > > >>http://docs.pylonsproject.org/projects/pyramid/en/1.3-branch/tutorial. > .. > > >> documentation. Now I want to switch from SqlLite to MySql. So I made > > >> below changes to my application > > >> development.ini > > >> ---------------------- > > >> sqlalchemy.url = mysql://root:welcome@localhost/deals > > > > >> Added python-mysql to setup.py > > >> ----------------------------------------------- > > >> requires = [ > > >> 'pyramid', > > >> 'mysql-python', > > >> 'SQLAlchemy', > > >> 'transaction', > > >> 'pyramid_tm', > > >> 'pyramid_debugtoolbar', > > >> 'zope.sqlalchemy', > > >> 'waitress', > > >> ] > > > > >> Now when I try to install the application using "python setup.py > > >> develop", I get "error: The system cannot find the file specified" > > >> error. > > >> I tried copying mysql dll file to python bin directory thinking mysql > > >> is not accessible from python & searched on the web but no luck. > > > > >> Any help is much appreciated. Thanks for your time. > > > > >> Complete execution details > > >> (pyramid) D:\learner\python\pyramid\projects\tutorial>python setup.py > > >> develop > > >> running develop > > >> running egg_info > > >> writing requirements to tutorial.egg-info\requires.txt > > >> writing tutorial.egg-info\PKG-INFO > > >> writing top-level names to tutorial.egg-info\top_level.txt > > >> writing dependency_links to tutorial.egg-info\dependency_links.txt > > >> writing entry points to tutorial.egg-info\entry_points.txt > > >> reading manifest file 'tutorial.egg-info\SOURCES.txt' > > >> reading manifest template 'MANIFEST.in' > > >> warning: no files found matching '*.rst' > > >> warning: no files found matching '*.jpg' under directory 'tutorial' > > >> warning: no files found matching '*.txt' under directory 'tutorial' > > >> warning: no files found matching '*.mak' under directory 'tutorial' > > >> warning: no files found matching '*.mako' under directory 'tutorial' > > >> warning: no files found matching '*.js' under directory 'tutorial' > > >> warning: no files found matching '*.html' under directory 'tutorial' > > >> warning: no files found matching '*.xml' under directory 'tutorial' > > >> writing manifest file 'tutorial.egg-info\SOURCES.txt' > > >> running build_ext > > >> Creating d:\learner\python\pyramid\lib\site-packages\tutorial.egg-link > > >> (link to .) > > >> tutorial 0.0 is already the active version in easy-install.pth > > >> Installing initialize_tutorial_db-script.py script to > D:\learner\python > > >> \pyramid\Scripts > > >> Installing initialize_tutorial_db.exe script to D:\learner\python > > >> \pyramid\Scripts > > >> Installing initialize_tutorial_db.exe.manifest script to D:\learner > > >> \python\pyramid\Scripts > > > > >> Installed d:\learner\python\pyramid\projects\tutorial > > >> Processing dependencies for tutorial==0.0 > > >> Searching for mysql-python > > >> Readinghttp://pypi.python.org/simple/mysql-python/ > > >> Readinghttp://sourceforge.net/projects/mysql-python/ > > >> Readinghttp://sourceforge.net/projects/mysql-python > > >> Best match: MySQL-python 1.2.3 > > >> Downloading > > >>http://download.sourceforge.net/sourceforge/mysql-python/MySQL-python. > .. > > >> Processing MySQL-python-1.2.3.tar.gz > > >> Running MySQL-python-1.2.3\setup.py -q bdist_egg --dist-dir c:\users > > >> > \learner\appdata\local\temp\easy_install-klhsdv\MySQL-python-1.2.3\egg- > > >> dist-tmp-whnjbg > > >> error: The system cannot find the file specified > > > > >> cheers > > > > >> Completed > > > > >> -- > > >> You received this message because you are subscribed to the Google > Groups > > >> "pylons-discuss" group. > > >> To post to this group, send email to [email protected]. > > >> To unsubscribe from this group, send email to > > >> [email protected]. > > >> For more options, visit this group at > > >>http://groups.google.com/group/pylons-discuss?hl=en. > > > > > -- > > > Christopher Lambacher > > > [email protected] > > > > > -- > > > You received this message because you are subscribed to the Google > Groups > > > "pylons-discuss" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]. > > > For more options, visit this group at > > >http://groups.google.com/group/pylons-discuss?hl=en. > > > > -- > > /* > > Atsushi Odagirihttp://blog.aodag.jp > > mailto:[email protected] > > */ > > -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/pylons-discuss?hl=en. > > -- /* Atsushi Odagiri http://blog.aodag.jp mailto:[email protected] */ -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en.
