Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread Niphlod
when you set routes (probably you used the default_application) you can't distinguish from a request coming to /a/b/c/d if is a /default_app/a/b/c/d or an /application/b/c/d . default_applications means that you'd like to have /testpostgres/default/index as an actual /default_app/testpostgre

Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread BlueShadow
it was a routing issue thanks lightdot. To me it doesnt make sense that if you give the complete path its overritten by the router but well learned something new. thanks guys for all the help. On Saturday, March 9, 2013 3:59:19 PM UTC+1, LightDot wrote: > > Don't you think it's a routes issue t

Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread LightDot
Don't you think it's a routes issue then..? ;) Regards, Ales On Saturday, March 9, 2013 3:56:27 PM UTC+1, BlueShadow wrote: > > I have changed the default routes.py because I got two apps running on > that ip. So when you just use my ip it gets to another app. > > On Saturday, March 9, 2013 3:52

Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread BlueShadow
I have changed the default routes.py because I got two apps running on that ip. So when you just use my ip it gets to another app. On Saturday, March 9, 2013 3:52:15 PM UTC+1, Cliff Kachinske wrote: > > Web2py can't find your file. > > Is the path to the app > /web2py/applications/TestPostgres/

Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread Cliff Kachinske
Web2py can't find your file. Is the path to the app /web2py/applications/TestPostgres/default/index What happens if you just do http://85.214.201.75 Have you changed the default routes.py files? On Saturday, March 9, 2013 9:32:19 AM UTC-5, BlueShadow wrote: > > thats what I did: > http://85.2

Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread BlueShadow
thats what I did: http://85.214.201.75/TestPostgres/default/index the app is on my server where I got the postgres db installed On Saturday, March 9, 2013 3:08:12 PM UTC+1, LightDot wrote: > > How are you trying to access your application, what URL are you using? > > I don't think you have an erro

Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread LightDot
How are you trying to access your application, what URL are you using? I don't think you have an error anywhere really. Assuming you're doing this on the localhost and using the rocket web server that comes with web2py, try: http://127.0.0.1:8000/TestPostgres/default/index BTW, if you look at

Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread Alfonso de la Guarda
Hi... In you defaultlpy there is no exist TestPostgres function and neither a view, that's the error, you have 2 options: 1. Create one TestPostgres function (and view) 2. Change the data function to crud the database Saludos, Alfonso de la Guarda Twitter: @al

Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread Alfonso de la Guarda
Hi, Well... Lightdot is right that is nothing about postgresql in the DAL now, is more related to the app construction... if yu post your model, controller and view we can surely reproduce that and give a solution. Saludos, Alfonso de la Guarda Twitter: @alfonso

Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread BlueShadow
its the welcome app except for the DAL line. (I created a New simple application named it TestPostgres and changed the db.py: db = DAL('postgres://dbuser:testpw@localhost/testdb') ) everything else stayed the same. I created a testdb so that cant be the problem. On Saturday, March 9, 2013 2:23:3

Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread LightDot
That's a different problem. And this one is about web2py :) Do you have a function in conrollers/default.py called TestPostgres..? The easiest way to help you would be if you simply post the code (controller, view and possibly model) that's giving you problems. Regards, Ales On Saturday, March

Re: [web2py] postgres getting started ("hello world")

2013-03-09 Thread BlueShadow
Thanks Alfonso de la Guarda Reyes. I got a step further with that. psql -U dbuser -d testdb this command works now but web2py still throws an error. still this: invalid function (default/TestPostgres) which doesn't help me at all. I got no clue where to look to solve this. On Saturday, March 9,

Re: [web2py] postgres getting started ("hello world")

2013-03-08 Thread Alfonso de la Guarda
Hi, Precisely today i have send a patch to Massimo for the book https://github.com/mdipierro/web2py-book/blob/master/sources/29-web2py-english/13.markmin You can review what you need to do Saludos, Alfonso de la Guarda Twitter: @alfonsodg Redes sociales: al

Re: [web2py] postgres getting started ("hello world")

2013-03-08 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 08-03-2013 23:19, BlueShadow escreveu: > I like to change my db to postgresql. > So I installed it by the following guide: > | > # setting up secure ssh > adduser dbuser > exportEDITOR=nano > visudo > # add this to the end of the file > # dbuser A

[web2py] postgres getting started ("hello world")

2013-03-08 Thread BlueShadow
I like to change my db to postgresql. So I installed it by the following guide: # setting up secure ssh adduser dbuser export EDITOR=nano visudo # add this to the end of the file # dbuser ALL=(ALL) ALL ssh-keygen -t rsa # fill everything out correctly scp ~/.ssh/id_rsa.pub dbu...@xxx.yyy.zzz.xyz