login community faq

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?

Thanks, mpearce

asked Mar 14 '12 at 06:45

mpearce's gravatar image

mpearce
1


Be sure you are running the correct paster app, this is the format for the command,

1
/home/<username>/webapps/<appname>/bin/paster setup-app /path/to/development.ini

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,

1
2
$ which paster
~/bin/paster

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

johns's gravatar image

johns ♦♦
345427

Your answer
If you have an answer to the above question, then use the form below. Otherwise, use the appropriate 'add new comment' button above to post your feedback.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×69
×8

Asked: Mar 14 '12 at 06:45

Seen: 712 times

Last updated: Mar 14 '12 at 18:18

Plans & prices    Sign up    Why WebFaction?    Contact us    Affiliate program    Support    Legal    Jobs    Blog    Control panel login
Powered by OSQA
© Copyright 2003-2012 Swarma Limited - WebFaction is a service of Swarma Limited