Hi Mike, I think you need to put your create_engine() (I use global_connect() ) in __call__() of lib/base.py because SQLAlchemy needs that to be called per request not only on server load.
Let me know if that doesn't work. Cheers, James [EMAIL PROTECTED] wrote: > I followed your directions to get my pylons app running through > dispatch.fcgi. Everything started up nicely but I can't for the life of > me get SQLAlchemy to work. > > I have the create_engine call in the app_globals module and the table > schema objects in a separate module that I include in my controllers. > > This works fine with the paster server but when I use apache/fastCGI > the first time it tries to connect to the db i get: > > 'NoneType' object has no attribute 'connect' in sqlalchemy.pool:273. > > I've tried moving the create_engine call in various places but to no > avail. > > Any help on getting sqlalchemy working with this fastcgi setup would be > much appreciated. > > Thanks, > Mike > > James Gardner wrote: > >> Hi all, >> >> Just to let you know I've added a tutorial on how to setup Pylons in a >> production environment using Apache, FastCGI and mod_rewrite. >> >> Any comments/changes, let me know! >> >> http://pylonshq.com/project/pylonshq/wiki/FastCGI >> >> Cheers, >> >> James >> > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
