I'm having great difficulty accessing a PostgreSQL database from my Turbogears application. Normally when I create a Turbogears application one of the required steps is to run 'paster setup-app development.ini' which creates database tables (as specified in bootstrap.py), however when I create an application via the WebFaction control panel there is no option to initiate this process. And when I try to run the 'paster setup-app' command from a ssh shell I get:
DistributionNotFound: Not Found: tg.devtools....etc.
I understood that if I edit the database section in development.ini correctly (which I'm sure I have) then the database should be accessible from my program, even if I add the tables manually via phpPgAdmin, but alas I keep getting:
OperationalError: (OperationalError) no such table: tg_user u'SELECT tg_user.password AS tg_user_password,......etc.
Anyone else have this problem?
asked Mar 14 '12 at 06:45
Be sure you are running the correct paster app, this is the format for the command,
Where 'username' and 'appname' are the user and app name and /path/to.development.ini is the path to development.ini if not in the current working directory.
I checked your user account and there is a paster app in ~/bin/ and it is the default,
I also could only find 1 app with a development.ini and it appeared to be working.
You may submit a support ticket if you would like us to look and reply directly.
answered Mar 14 '12 at 18:18