[web2py] Ticket Issued: Unrecoverable

2012-01-31 Thread Likit
I have seen several posts about this problem. I just had the problem and solved it. However, none of the several posts I read had the answer that applied in my case. I did not read ALL of the posts mentioning this problem so some of them may have had an applicable answer. If you are a linux noo

[web2py] Ticket Issued: Unrecoverable

2012-01-31 Thread Likit
I have seen several posts about this problem. I just had the problem and solved it. However, none of the several posts I read had the answer that applied in my case. I did not read ALL of the posts mentioning this problem so some of them may have had an applicable answer. If you are a linux noo

[web2py] Re: permissions problems on ubuntu 11.10

2012-01-19 Thread Likit
nothing should be in www except "sites" built primarily of static html files. Generally linode has been a very good experience and ubuntu is legions better than xampp, of course. On Jan 19, 3:02 pm, Likit wrote: > I thought this was going to be easy.  Boy, was I wrong.  Lots of goo

[web2py] permissions problems on ubuntu 11.10

2012-01-19 Thread Likit
I thought this was going to be easy. Boy, was I wrong. Lots of good documentation for ubuntu 11.10 from both ubuntu and linode. I got apache, ssl, mysql, php, mod_wsgi, and phpmyadmin working perfectly first time, no stumbles. But, then I tried to make the mods to httpd.conf (really, its includ

[web2py] Re: examples app doesn't run on apache

2012-01-15 Thread Likit
I am starting simple: - develop locally on xampp/mysql; try things out on rocket/sqlite if I can't figure something out - move to SuSELinux server in my office and access across lan - move to linode probably on centos for the real world after things really, really work I commented out caching deco

[web2py] Re: what triggers a db migration

2012-01-15 Thread Likit
Thanks, all. This is closed. I am progressing to more deployment complexity: locally develop on xampp with apache and mysql; occasionally run rocket/sqlite if I can't figure things out move things to SuSE server in my office and access behind firewall on own network move things to Linode (probabl

[web2py] Re: migration not working

2012-01-14 Thread Likit
ABLE and DELETE joke_id__tmp > > On Jan 14, 10:02 pm, Likit wrote: > > > > > > > > > I am trying to use the many-2-many DAL syntax suggested by the manual > > and the examples.  In this approach, a field name is associated with a > > TABLE name. &g

[web2py] Re: what triggers a db migration

2012-01-14 Thread Likit
The manual is pretty explicit about this although it simplifies a bit. The manual says it looks at the existing tables (actually looks at the physical file or looks at the most recent definition in sql.log?). I think that the time stamps also matter. Not clear what timestamp is being compared to

[web2py] what triggers a db migration

2012-01-14 Thread Likit
I had a db for which I changed the model. This correctly caused a migration. Either web2py or MySQL hung. This has sort of diminished my confidence in migrations. I realize it is a great thing, but only if/when it works. Believe me I am experimenting with a really trivial example with 3 tables

[web2py] migration not working

2012-01-14 Thread Likit
I am trying to use the many-2-many DAL syntax suggested by the manual and the examples. In this approach, a field name is associated with a TABLE name. I have not been able to get this to work with MySQL. So, I have used the more conventional approach of using an integer field to hold the key va

[web2py] Re: examples app doesn't run on apache

2012-01-14 Thread Likit
One other bit of information: everything works as expected with Rocket server (using port 8000).

[web2py] Re: examples app doesn't run on apache

2012-01-14 Thread Likit
Still no solution to this. I would really like not having to switch between Rocket and Apache each time I want to look at the help or examples. Error 503 is Apache saying that the server can't respond to the client. In the Apache error log, I have the following when I attempt to access help or r

[web2py] Re: Is it me or what?

2012-01-13 Thread Likit
Nice. Randomly noticed that the all bands/against me link is brokent... On Jan 12, 11:48 pm, Annet wrote: > Hi, > > > Thanks for pointing that out, this is probably a stupid question, but > > where do I change the metadata author? > > In previous versions of web2py this was the way to set meta

[web2py] Re: examples app doesn't run on apache

2012-01-12 Thread Likit
is a 4G machine. Although when I run xampp I also have mysql running, which is not the case with rocket. So, maybe I just run out of RAM. I am still digging. I'll try to turn off caching--as a test--globally for web2py. On Jan 12, 10:09 am, Likit wrote: > Here is the returned page whe

[web2py] Re: examples app doesn't run on apache

2012-01-12 Thread Likit
is a 4G machine. Although when I run xampp I also have mysql running, which is not the case with rocket. So, maybe I just run out of RAM. I am still digging. I'll try to turn off caching--as a test--globally for web2py. On Jan 12, 10:09 am, Likit wrote: > Here is the returned page whe

[web2py] Re: why won't web2py create the databases

2012-01-12 Thread Likit
Thanks for the replies. I deleted the tables themselves--not in app/databases but from the mysql dir where they are kept. I then use phpmyadmin to create an empty d-b, as required when using mysql. (Yes, I read the db chapter on the web2py book.) I don't believe you are seeing a period in the db

[web2py] Re: don't understand forms processing

2012-01-12 Thread Likit
I had another problem accessing the examples with my apache config (separate thread). Under rocket server I could see those examples. Yes, I think the products or dog registration examples illustrate what I need. On Jan 12, 4:33 am, stefaan wrote: > Have you looked here?http://web2py.com/examples

[web2py] Re: examples app doesn't run on apache

2012-01-12 Thread Likit
Here is the returned page when clicking on the help button in the extreme upper right corner of the admin page: Service unavailable! The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later. If you think this is a server er

[web2py] Re: web2py fails when mysql tables already exist

2012-01-12 Thread Likit
So, all of the above problems appear to be related to some sort of corruption that resulted in the default.py controller. I noticed that in the traceback it would be shown with 2 additional lines that I did not enter. I did not see these in any external editor. I had previously backed up the appl

[web2py] examples app doesn't run on apache

2012-01-12 Thread Likit
I guess I could learn a lot from the examples. It's what they are there for. But, when run with mod_wsgi and apache, you get service unavailable--which really doesn't make a lot of sense on localhost, does it? It appears to work on rocket. But, when I navigate to the actual examples, I get the

[web2py] don't understand forms processing

2012-01-12 Thread Likit
I really don't get the use of {{form}} in views. It's really too opaque. The form=crud and form=SQLFORM really only do trivial cases involving a single table. What I want to do is just create an html input form in the view with a submit action. When the http request comes back with variables

[web2py] web2py fails when mysql tables already exist

2012-01-11 Thread Likit
web2py has failed when the authuser table already exists. Well, ideally the auth tables are meant to persist. I thought the DAL created tables if they DON'T exist. I guess I am getting really tired of the unbearable fragility of web2py. Just pretty bush league, I guess. Here is the traceback:

[web2py] Re: why won't web2py create the databases

2012-01-11 Thread Likit
I mean, why won't web2py create the tables through its famous DAL. I have created the database directly in mysql. On Jan 11, 8:44 pm, Likit wrote: > I guess I like SQL better than frameworks. SQL is a query language for > DDL and DML that is well documented and completely

[web2py] why won't web2py create the databases

2012-01-11 Thread Likit
I guess I like SQL better than frameworks. SQL is a query language for DDL and DML that is well documented and completely explicitly. Frameworks are opaque and invent a new syntax subject to ambiguities of parens, square braces, curly braces, dotted names, sometimes tablenames being implicit, somet

[web2py] Re: Can't configure web2py with apache via xampp

2012-01-08 Thread Likit
I solved this. Dumb error. Still the doc's aren't great. Error was that ifmodule for ssl section has an include that brings in a virtualhost for port 443. I was doing it twice. Fixed that and apache runs. Web2py runs behind apache. Now my problem is that I can't get to the admin pages via ap

[web2py] Can't configure web2py with apache via xampp

2012-01-07 Thread Likit
Nothing I am doing works. None of the web pages have answers. I am not confident in the web2py book, which contains many errors. The problem appears to be that web2py insists that the admin pages are accessed via ssl for the login but doesn't require (of course) ssl for the ordinary applicati