[web2py] Re: How to create a front end for an external API?

2016-10-21 Thread Dave S 
On Friday, October 21, 2016 at 7:42:37 PM UTC-7, greenpoise wrote:
>
> Want to pull some data. There is no option to write, just pull data.


Do you have a representation for this data?

A couple of examples of simple data might be 

1) a list of deposits and withdrawals, which could be represented by a 
single table in a conventional database.

2) a list of locations where you've installed a vending machine

3) a series of temperature readings from a sensor


Slightly more complicated, where 1 list might point to another list for 
some information:

1a) a list of deposits and withdrawals for various accounts, with the table 
containing a reference to another table that describes the accounts.

4) a list of courses, a list of textbooks, and a list of teachers.
(A list of students would be easy to add to this example.)

5) a list of invoices, a list of shipping addresses, a list of sales tax 
rates for different jurisdictions.

6) a list of patients' prescriptions, a list of drug safety information, a 
list of patients, and a list of doctors.
(a list of insurance companies would be easy to add to this example)

7) An inventory list of shipments received and shipments sent, a list of 
items that can be ordered, a list vendors, a list of customers, and a list 
of shipping companies.

(Conventional databases are good at data that can be in lists)

If you think of these examples as patterns, does one or more of the 
patterns match the pattern of your data?
(I didn't really present many patterns, but it's after dinner so thinking 
is slow )

/dps

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: How to create a front end for an external API?

2016-10-21 Thread greenpoise 
Want to pull some data. There is no option to write, just pull data.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Login - message "invalid email" - on mobil

2016-10-21 Thread Massimo Di Pierro 
I have no idea. I do not see why login would be different from a 
smartphone. I use it all the time and it works fine. Perhaps capitalization 
of the email?


On Wednesday, 19 October 2016 07:07:24 UTC-5, Beat Kohler wrote:
>
> Hi Massimo
> Thanks for your response. But I not understand your answer. Perhaps my 
> question was not clear. Login with the email address works fine on a 
> desktop. Same URL - same login procedure on a smartphone I get the message 
> "invalid email" and this as mentioned on an pythomanywhere published 
> application.
> Regards 
> Beat
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: We do not delete posts

2016-10-21 Thread Massimo Di Pierro 
yes. new users are moderated. Usually they are approved in one day but some 
time it may take longer.

On Friday, 21 October 2016 15:54:31 UTC-5, tbon...@ucsc.edu wrote:
>
> Two days a go I posted a question about Janrain and google integration but 
> i still don't see it. Is it normal?
>
> On Monday, July 20, 2015 at 1:08:57 AM UTC-7, Massimo Di Pierro wrote:
>>
>> We never delete posts from users, unless the users ask (because they 
>> accidentally post the server password, for example). Yet first posts are 
>> moderated to avoid spam. Usually when a post is on hold for moderation it 
>> is approved within 24 hours or less.
>>
>> There are some glitches in the process. 
>> - Occasionally some posts have disappeared on their own. We attributed 
>> this to a Google glitch. It has not happened recently. 
>> - Some times Google requires moderation even for posts from people that 
>> have been whitelisted. This is not our policy and we do not know why it 
>> happens, but it does. 
>> - Some posts have erroneously been flagged as spam by moderators. We can 
>> fix this.
>> - Some times it takes longer then 24 hrs for a post to be moderated, but 
>> never more than 48 hrs.
>> These problems are very very rare.
>>
>> If your first post does not show up, then it is moderated. Just wait. Do 
>> not post 10 more copies of it. That just calls for trouble and more work 
>> for all of us. If your post does not show up in 24 hours, email me 
>> personally and I will take a look.
>>
>> We could use some more moderators, so feel free to volunteer by emailing 
>> me.
>>
>> Fun fact: 90% of spam posts are job announcements about Java.
>>
>> Massimo
>>
>>
>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Installation error

2016-10-21 Thread Massimo Di Pierro 
Please try:

web2py.exe -S welcome -P




On Friday, 21 October 2016 15:54:33 UTC-5, Saxman wrote:
>
> Hi everyone,
>
> I am totally new to python and hence web2py so please make allowances if 
> my question is somewhat basic.(No pun intended)
>
> I have unzipped web2py and ran the command  
>
> web2py.exe -S welcome
>
> as per the manual and it was run from the web2py folder.
>
> While I get the console window to load I also get the following error 
> message
>
> *WARNING:web2py:import IPython error; use default python shell*
>
> The full screen dump if it helps is 
>
> F:\web2py>web2py.exe -S welcome
> web2py Web Framework
> Created by Massimo Di Pierro, Copyright 2007-2016
> Version 2.14.6-stable+timestamp.2016.05.10.00.21.47
> Database drivers available: psycopg2, pymysql, imaplib, MySQLdb, sqlite3, 
> pyodbc
> WARNING:web2py:import IPython error; use default python shell
> Python 2.7.9 (default, Dec 10 2014, 12:24:55) [MSC v.1500 32 bit (Intel)] 
> on win32
> Type "help", "copyright", "credits" or "license" for more information.
> (InteractiveConsole)
>
> I am running win10 with all updates installed.
>
> Thank you in advance for any insight you may have
>
> regards
>
> Ian Penfold
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: db_codec for Hungarian MSSQL

2016-10-21 Thread Massimo Di Pierro 
web2py uses utf8 everywhere. If your database is pre-existing and not in 
utf8 than you need to convert th data.

On Friday, 21 October 2016 15:54:32 UTC-5, Gabor Nyul wrote:
>
> When I'm querying our MSSQL database (with Hungarian data in it) I have 
> strange characters instead of the Hungarian accented characters.
> I've tried to use the db_codec parameter in DAL() but there is no change.
> I've tried cp1250, latin2 without success.
>
> Any idea?
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Deploy to a VPS

2016-10-21 Thread Massimo Di Pierro 
Our recommendation is run this:
https://raw.githubusercontent.com/web2py/web2py/master/scripts/setup-web2py-nginx-uwsgi-ubuntu.sh

then copy the applications into 
/home/www-data/web2py/applications/{appname} and make is 700 for www-data.

There should be nothing else to install.

On Friday, 21 October 2016 15:54:32 UTC-5, Paolo Montrasio wrote:
>
> I'm taking over a web2py project for a customer. I looked for the common 
> way to deploy to production, read the guide of the web2py site and googled 
> for solutions. They don't apply very well to my case so I'm looking for 
> advice to start in the right way.
>
> The production server runs on a VPS. Apparently there is no deployment 
> procedure. There are many files in production with a suffixed timestamp, 
> like file.py, file.py.22may, file.py,29may. Everything hints to a fully 
> manual deployment procedure. The application/ directory is full of 
> files generated by the application to be downloaded by its users. Some are 
> in well defined directories, some are scattered all around as is the result 
> of manual test runs. You got the idea.
>
> Being new to the application I don't want to change anything until I get 
> familiar with it because I don't want to break the service, which works 
> despite the mess on the server. Still, I have to fix some pages and deploy 
> them to production. I copied everything locally and created a Vagrant 
> machine which seems to be a faithful copy of the server.
>
> I have no experience with web2py and the deployment of Python web 
> applications. I have a very good experience of working with Rails and some 
> with Node.
>
> I created a git repository from the sources copied from the server, so an 
> idea would be to git pull from the applications/app directory on the 
> server. This probably works and I did that in the past, but it's sub 
> optimal. What I'm used to do is using tools like capistrano or mina. 
> Basically they take note of the last commit installed on the server and scp 
> the updates from development to the server. No git keys on the server. They 
> also keep old versions of the application in other directories and symlink 
> current to the last one. I found a Python tool called fabistrano that 
> probably does the same https://github.com/dlapiduz/fabistrano However I 
> don't think it fits well into the web2py paradigm of having apps into the 
> applications directory. It would create directories with other names so it 
> probably needs customization. Furthermore I need to make those other files 
> survive the deployment process.
>
> Another idea would be to rsync the development environment to the 
> applications/app directory. However with all the cruft I still have in 
> development and all the files on production I'm not confident not to break 
> anything.
>
> Is there some deployment tool especially made for web2py that could help 
> me until I clean up this project? If not, I'll git pull.
>
> Thanks!
>
>  
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Hide flash message after some elapsed time instead of on click

2016-10-21 Thread Scott Hunter 
You need single-quotes around 
flash.fadeOut("slow")

Otherwise, as you have seen, it gets executed immediately instead of after 
a delay.

On Tuesday, October 18, 2016 at 9:35:30 AM UTC-4, Marc Smith wrote:
>
> Hi, 
>
> I'm relatively new to JS but the strange quote character at the 
> beginning (I thought it was a back-tick, but doesn't appear it is) and 
> single quote at the end in that line don't look right to me -- is that 
> correct? I tried the code with Jim's change of using ".w2p_flash" but 
> it still doesn't work for me. 
>
> This is what the block of JS from web2py.js looks like currently: 
> --snip-- 
>/*helper for flash messages*/ 
>flash: function(message, status) { 
>  var flash = $('.w2p_flash'); 
>  web2py.hide_flash(); 
>  flash.html(message).addClass(status); 
>  if(flash.html()) flash.append('  
> ').slideDown(); 
>}, 
>hide_flash: function() { 
>  $('.w2p_flash').fadeOut(0).html(''); 
>}, 
> --snip-- 
>
> I tried adding this line: 
> setTimeout(flash.fadeOut("slow"),5000); 
>
> But the message fades in and out in about a second, and in Chrome's 
> developer panel, I see a "(program):1 Uncaught SyntaxError: Unexpected 
> identifier" error. 
>
> Any help would be greatly appreciated. 
>
>
> --Marc 
>
> On Wed, Jul 13, 2016 at 6:41 PM, Jim Brouzoulis 
>  wrote: 
> > Thank you very much for your help! (...and sorry for the late reply) 
> > 
> > It didn't work at first but then I noticed a typo: the class should be 
> > '.w2p_flash'. 
> > 
> > Regards 
> > // Jim 
> > 
> > 
> > Den måndag 11 juli 2016 kl. 10:49:08 UTC+2 skrev Massimiliano: 
> >> 
> >> Hi Jim, 
> >> I’m doing it in this way: 
> >> 
> >> Edit static/web2py.js search for /*helper for flash messages*/ 
> >> 
> >> and add this command: 
> >> 
> >> setTimeout(‘jQuery(".flash").fadeOut("slow")',5000); 
> >> 
> >> just after: 
> >> 
> >> if (flash.html()) flash.append('  
> >> ').slideDown(); 
> >> 
> >> Adjust 5000 that stands for 5 secods to your needs. 
> >> 
> >> 
> >> On Thu, Jul 7, 2016 at 6:00 PM, Jim Brouzoulis  
>
> >> wrote: 
> >>> 
> >>> Hi everyone, 
> >>> 
> >>> Can I easily customise the web2py.js file to automatically hide/fade 
> out 
> >>> the flash message after some given time (like a few seconds) instead 
> of 
> >>> clicking on it? If so, how? 
> >>> I have a feeling that the solution is probably not that complicated 
> but 
> >>> my js-skills aren't very impressive :) 
> >>> 
> >>> Regards 
> >>> // Jim 
> >>> 
> >>> -- 
> >>> Resources: 
> >>> - http://web2py.com 
> >>> - http://web2py.com/book (Documentation) 
> >>> - http://github.com/web2py/web2py (Source code) 
> >>> - https://code.google.com/p/web2py/issues/list (Report Issues) 
> >>> --- 
> >>> You received this message because you are subscribed to the Google 
> Groups 
> >>> "web2py-users" group. 
> >>> To unsubscribe from this group and stop receiving emails from it, send 
> an 
> >>> email to web2py+un...@googlegroups.com. 
> >>> For more options, visit https://groups.google.com/d/optout. 
> >> 
> >> 
> >> 
> >> 
> >> -- 
> >> Massimiliano 
> > 
> > -- 
> > Resources: 
> > - http://web2py.com 
> > - http://web2py.com/book (Documentation) 
> > - http://github.com/web2py/web2py (Source code) 
> > - https://code.google.com/p/web2py/issues/list (Report Issues) 
> > --- 
> > You received this message because you are subscribed to the Google 
> Groups 
> > "web2py-users" group. 
> > To unsubscribe from this group and stop receiving emails from it, send 
> an 
> > email to web2py+un...@googlegroups.com . 
> > For more options, visit https://groups.google.com/d/optout. 
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: use jquery mobile with image upload functionality in web2py - is a hack is necessary?

2016-10-21 Thread Johnny Lupino 
Hi,

It's been some time after you had posted your problem, but I found out 
another way of fixing it, since I could not find "//event.preventDefault(); 
" anymore. 
Anyway, to make it possible to submit a form using jqmobile plugin , I only 
needed to add an extra attribute to my form - which is data-ajax='false'.
In controller e.g default.py , after your form definition add:
form['data-ajax]'='false' and it should work.
I'm sure you know it by now, but it is always good to share 
knowledge/experience.
ATB,
Archie

On Friday, October 3, 2014 at 6:59:13 PM UTC+2, Rob Paire wrote:
>
> Hello all, 
> I am working on an app using web2py and the jquery.mobile plug-in which I 
> upgraded from v1.3.1 to v1.3.2. So far everything is working fine except 
> for the image upload feature. I managed to solve the problem and enable the 
> upload, but I had to hack the jquery.mobile-1.3.2.js source to make it 
> work. I am making this post in order to share my experience. 
>
> Here is the situation: when the view to do the upload includes the normal 
> layout file everything works as expected. However, when using the 
> plugin_jqmobile/layout.html, the upload fails with the jquery.mobile 
> message "Error Loading Page" - in short the web2py callback fails. The 
> record does not get inserted, neither does the response.flash error message 
> appear. A couple of long sessions with javascript debugger and reading //
> api.jquery.com/submit eventually led me to suspect event.preventDefault() 
> was causing the error. Indeed it was true, when I commented out that line 
> of code, the upload was successful. Below is the modified code snippet from 
> jquery.mobile-1.3.2.js (this problem also exists in jqm v1.3.1)
>
> //bind to form submit events, handle with Ajax
> $.mobile.document.delegate( "form", "submit", function( event ) {
> var formData = getAjaxFormData( $( this ) );
>
> if ( formData ) {
> $.mobile.changePage( formData.url, formData.options );
> //event.preventDefault();  //turned this off to enable web2py callbacks 
> }
> });
>
> I am going to proceed with further testing. If there is a better solution, 
> please let me know. Thank you.
>
> In my controller I have the following standard code:
> form = SQLFORM(db.documnt)
> if form.accepts(request, session):
> response.flash = 'form accepted:'+str(form.vars.id)
> make_thumbnail(db.documnt,form.vars.id,(175,175))
> elif form.errors:
> response.flash = 'form has errors...'
> return dict(form=form)
>
> And the associated view:
>   {{#extend 'layout.html'}}
>   {{extend 'plugin_jqmobile/layout.html'}}
>
> 
> {{=form}}
> 
>
>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Installation error

2016-10-21 Thread Ian Penfold 
Hi everyone,

I am totally new to python and hence web2py so please make allowances if my 
question is somewhat basic.(No pun intended)

I have unzipped web2py and ran the command  

web2py.exe -S welcome

as per the manual and it was run from the web2py folder.

While I get the console window to load I also get the following error 
message

*WARNING:web2py:import IPython error; use default python shell*

The full screen dump if it helps is 

F:\web2py>web2py.exe -S welcome
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2016
Version 2.14.6-stable+timestamp.2016.05.10.00.21.47
Database drivers available: psycopg2, pymysql, imaplib, MySQLdb, sqlite3, 
pyodbc
WARNING:web2py:import IPython error; use default python shell
Python 2.7.9 (default, Dec 10 2014, 12:24:55) [MSC v.1500 32 bit (Intel)] 
on win32
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)

I am running win10 with all updates installed.

Thank you in advance for any insight you may have

regards

Ian Penfold

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] UnicodeDecodeError: 'utf8' codec can't decode byte 0xed in position 14: invalid continuation byte

2016-10-21 Thread Gabor Nyul 
I have an MSSQL database with data stored in Hungarian charset.
I've tried to use the DataTables example from here:
http://www.web2pyslices.com/slice/show/2052/using-datatablesnet-with-web2py-for-ultra-fast-grid-display
 
but I'v got this error.

UnicodeDecodeError: 'utf8' codec can't decode byte 0xed in position 14: invalid 
continuation byte

The database request went well, I can see the returned data although 
already unicode encoded in the error ticket.
Here is the beginning of the returned data where you can see the accented 
character escapes : ((self=, 
o=[{'ARAMNEM_NEV': 'nincs villamos\xedtva', )

The view is almost exactly the same as in the link of slice above.

Controller:
def index():
import json
res = json.dumps(db.executesql('select * from bd_aramnemek', as_dict = 
True))
return dict(results=XML(res))

What should I do to get back the native chars stored in the DB?

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] db_codec for Hungarian MSSQL

2016-10-21 Thread Gabor Nyul 
When I'm querying our MSSQL database (with Hungarian data in it) I have 
strange characters instead of the Hungarian accented characters.
I've tried to use the db_codec parameter in DAL() but there is no change.
I've tried cp1250, latin2 without success.

Any idea?

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: We do not delete posts

2016-10-21 Thread tbonato 
Two days a go I posted a question about Janrain and google integration but 
i still don't see it. Is it normal?

On Monday, July 20, 2015 at 1:08:57 AM UTC-7, Massimo Di Pierro wrote:
>
> We never delete posts from users, unless the users ask (because they 
> accidentally post the server password, for example). Yet first posts are 
> moderated to avoid spam. Usually when a post is on hold for moderation it 
> is approved within 24 hours or less.
>
> There are some glitches in the process. 
> - Occasionally some posts have disappeared on their own. We attributed 
> this to a Google glitch. It has not happened recently. 
> - Some times Google requires moderation even for posts from people that 
> have been whitelisted. This is not our policy and we do not know why it 
> happens, but it does. 
> - Some posts have erroneously been flagged as spam by moderators. We can 
> fix this.
> - Some times it takes longer then 24 hrs for a post to be moderated, but 
> never more than 48 hrs.
> These problems are very very rare.
>
> If your first post does not show up, then it is moderated. Just wait. Do 
> not post 10 more copies of it. That just calls for trouble and more work 
> for all of us. If your post does not show up in 24 hours, email me 
> personally and I will take a look.
>
> We could use some more moderators, so feel free to volunteer by emailing 
> me.
>
> Fun fact: 90% of spam posts are job announcements about Java.
>
> Massimo
>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] unicode error

2016-10-21 Thread Gabor Nyul 
I wanted to implement the datatable.net sample (
http://www.web2pyslices.com/slice/show/2052/using-datatablesnet-with-web2py-for-ultra-fast-grid-display)
 
in my app.
The controller is dead simple:
def index():
import json
res = json.dumps(db.executesql('select * from bd_aramnemek', as_dict = 
True))
return dict(results=XML(res))

The view is almost the same as in the example linked above.
My database is MSSQL.

According to the error ticket the data is returned well, but nothing is 
showed an an error is thrown
Here is a beginning of the data returned (self=, o=[{'ARAMNEM_NEV': 'nincs villamos\xedtva',...) where you can see 
the encoded data.

The problem is that all my data have  Hungarian local characters 

How to solve this issue?

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Google+ not showing up when using Janrain

2016-10-21 Thread tbonato 
Hello, I am using Janrain for my login integration. In Janrain I've 
selected Google+, Facebook and Twitter but only Facebook and Twitter are 
displayed in the web2py page. 
Is this a bug? 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Deploy to a VPS

2016-10-21 Thread Paolo Montrasio 
I'm taking over a web2py project for a customer. I looked for the common 
way to deploy to production, read the guide of the web2py site and googled 
for solutions. They don't apply very well to my case so I'm looking for 
advice to start in the right way.

The production server runs on a VPS. Apparently there is no deployment 
procedure. There are many files in production with a suffixed timestamp, 
like file.py, file.py.22may, file.py,29may. Everything hints to a fully 
manual deployment procedure. The application/ directory is full of 
files generated by the application to be downloaded by its users. Some are 
in well defined directories, some are scattered all around as is the result 
of manual test runs. You got the idea.

Being new to the application I don't want to change anything until I get 
familiar with it because I don't want to break the service, which works 
despite the mess on the server. Still, I have to fix some pages and deploy 
them to production. I copied everything locally and created a Vagrant 
machine which seems to be a faithful copy of the server.

I have no experience with web2py and the deployment of Python web 
applications. I have a very good experience of working with Rails and some 
with Node.

I created a git repository from the sources copied from the server, so an 
idea would be to git pull from the applications/app directory on the 
server. This probably works and I did that in the past, but it's sub 
optimal. What I'm used to do is using tools like capistrano or mina. 
Basically they take note of the last commit installed on the server and scp 
the updates from development to the server. No git keys on the server. They 
also keep old versions of the application in other directories and symlink 
current to the last one. I found a Python tool called fabistrano that 
probably does the same https://github.com/dlapiduz/fabistrano However I 
don't think it fits well into the web2py paradigm of having apps into the 
applications directory. It would create directories with other names so it 
probably needs customization. Furthermore I need to make those other files 
survive the deployment process.

Another idea would be to rsync the development environment to the 
applications/app directory. However with all the cruft I still have in 
development and all the files on production I'm not confident not to break 
anything.

Is there some deployment tool especially made for web2py that could help me 
until I clean up this project? If not, I'll git pull.

Thanks!

 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] is someone interested in delivering the following training in Thailand?

2016-10-21 Thread bianjiangyan 


Hi,

We are looking for a trainer to deliver the following training course:

WEB2PY in Bangkok Thainland,
Please find the details below:

Training reference link: 
http://tha.nobleprog.com/web-development-web2py-course

Training date: from 01-11-2016 to 04-11-2016

Training location: Bangkok,Thailand

The number of delegate: 1
 

Would you be interested in delievering this training in Bangkok?

What is your daily rate?

 
If you are interested in preparing for and delivering this training or know 
someone who can, please get back to us by replying to this email.

Please include your inclusive daily rate and availability.

Contact way: enquir...@nobleprog.com

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Randomly stuck web2py

2016-10-21 Thread Wasim Baig 
Been using web2py for sometime now, thank you all for making life so easy.

We use stock web2py src on debian 8, with Rocket and mysql and start them 
in screen.

Frequently my web2py process get stuck. Ctrl-C won't kill it, we end up 
Ctrl-Z it, and then kill -9 pid.

For example, 

root 13387  0.8  0.4 1131328 156496 pts/63 Sl+  Oct18   7:12 python2.7 
web2py.py -d /var/run/web2py_localhost_8000.pid -a XXX 
--interfaces=127.0.0.1:8000 
root 13421  0.0  0.4 1109424 143336 pts/8  Sl   Oct18   0:39 python2.7 
web2py.py -d /var/run/web2py_8000.pid -a XXX 
--interfaces=148.251.132.230:8000:/etc/ssl/private/batuni_pk.key:/etc/ssl/private/batuni_pk.crt
 
--ca-cert=/etc/ssl/private/AddTrustExternalCARoot.crt 
--ca-cert=/etc/ssl/private/COMODORSAAddTrustCA.crt 
--ca-cert=/etc/ssl/private/COMODORSADomainValidationSecureServerCA.crt 
--ca-cert=/etc/ssl/private/batuni_pk.ca-bundle


Of these two processes, the one on localhost continues to respond fine, but 
the one on public IP was stuck.
Nothing in the logs that I can see point to a problem. 

What can I do to troubleshoot this?

-wasim 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Grid export csv

2016-10-21 Thread Bartosz Baranowski 
Niphlod,

I am using latest web2py and pydal from master branches. Any idea where is 
the fix? Could you please direct me to the commit?

W dniu środa, 3 sierpnia 2016 12:51:56 UTC-7 użytkownik Niphlod napisał:
>
> should be already fixed on master, anyway if you're in a hurry, set 
> entity_quoring=False on the DAL line to make it work again (long story 
> short, DAL now quotes everything by default and not every cog in the wheel 
> was expecting that)
>
> On Monday, August 1, 2016 at 1:51:54 PM UTC+2, Kostas M wrote:
>>
>> I have the same problem with the CSV, HTML, TSV export buttons. The 
>> Ticket for the CSV is pasted below. The problem at least with the csv 
>> export button seems to be with the REGEX_TABLE_DOT_FIELD. Normally, this 
>> constant is defined in regex.py as:
>>
>> REGEX_TABLE_DOT_FIELD = re.compile('^(\w+)\.([^.]+)$')
>>
>> and previous web2py versions used it.
>>
>> However, now it takes the REGEX_TABLE_DOT_FIELD definition from the 
>> base.py:
>>
>> obj.REGEX_TABLE_DOT_FIELD = re.compile(
>> r'^' + quot % regex_ent + r'\.' + quot % regex_ent + r'$')
>>
>>
>> which is a totally different regex and it doesn't match with the table 
>> field names...
>>
>>
>> Ticket ID 
>>
>> 127.0.0.1.2016-08-01.14-36-35.a05a56c8-5b22-42c3-a3e3-385322b5f0fe
>>  Version 
>> web2py™ Version 2.14.5-stable+timestamp.2016.04.14.03.26.16 
>> Python Python 2.7.6: /home/kmouts/Envs/prolims2_venv/bin/python2.7 
>> (prefix: /home/kmouts/Envs/prolims2_venv) Traceback 
>>
>> 1.
>> 2.
>> 3.
>> 4.
>> 5.
>> 6.
>> 7.
>> 8.
>> 9.
>> 10.
>> 11.
>> 12.
>> 13.
>> 14.
>> 15.
>> 16.
>> 17.
>> 18.
>> 19.
>> 20.
>> 21.
>> 22.
>>
>> Traceback (most recent call last):
>>   File "/home/kmouts/PycharmProjects/prolims2/web2py/gluon/restricted.py", 
>> line 227, in restricted
>> exec ccode in environment
>>   File 
>> "/home/kmouts/PycharmProjects/prolims2/web2py/applications/prolims2/controllers/muser.py"
>>  , 
>> line 187, in 
>>   File "/home/kmouts/PycharmProjects/prolims2/web2py/gluon/globals.py", line 
>> 417, in 
>> self._caller = lambda f: f()
>>   File "/home/kmouts/PycharmProjects/prolims2/web2py/gluon/tools.py", line 
>> 4258, in f
>> return action(*a, **b)
>>   File 
>> "/home/kmouts/PycharmProjects/prolims2/web2py/applications/prolims2/controllers/muser.py"
>>  , 
>> line 49, in my_analyses
>> exportclasses=dict(csv_with_hidden_cols=False, 
>> tsv_with_hidden_cols=False)
>>   File "/home/kmouts/PycharmProjects/prolims2/web2py/gluon/sqlhtml.py", line 
>> 3102, in smartgrid
>> user_signature=user_signature, **kwargs)
>>   File "/home/kmouts/PycharmProjects/prolims2/web2py/gluon/sqlhtml.py", line 
>> 2473, in grid
>> raise HTTP(200, oExp.export(), **response.headers)
>>   File "/home/kmouts/PycharmProjects/prolims2/web2py/gluon/sqlhtml.py", line 
>> 3514, in export
>> self.rows.export_to_csv_file(s, represent=True)
>>   File 
>> "/home/kmouts/Envs/prolims2_venv/local/lib/python2.7/site-packages/pydal/objects.py",
>>  line 2446, in export_to_csv_file
>> row.append(record._extra[col])
>>   File 
>> "/home/kmouts/Envs/prolims2_venv/local/lib/python2.7/site-packages/pydal/objects.py",
>>  line 91, in __getattr__
>> raise AttributeError
>> AttributeError
>>
>>
>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: represent list:reference

2016-10-21 Thread Leonel Câmara 
First you are getting the error because.
db.publicaciones.autores.represent is not defined so it is None and hence 
not callable.

That said. Here's a generic represent function you can use with 
list:reference fields.

def represent_listref(table, *fields):
def represent(values):
result = []
if values is None:
return None
for value in values:
v = db[table][value]
rendered = {'id': value}
for field in fields:
represent = db[table][field].represent
rendered[field] = represent(v[field]) if represent else v[
field]
result.append(rendered)
return result
return represent



The way to use it is in the model set it as represent


db.define_table('publicaciones',
 Field('titulo'),
 Field('descripcion', 'text', label='Descripción'),
 Field('autores', 'list:reference db.personas',
requires= IS_IN_DB(db, 'personas.id', '%(nombres)s %(apellidos)s', 
multiple=True), represent=represent_listref('personas', 'nombres', 
'apellidos')),
 format='%(titulo)s')

Then in your controller, you need to render the rows.

lista_publicaciones = list(db(db.publicaciones.tipo == tipo).select(orderby 
=~ db.publicaciones.fecha).render())

Now in your view for each "publicacione" in autores you will have a list of 
dicts with the fields nombres and apellidos as well as the id which my 
implementation of represent_listref always adds.




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Deployment question

2016-10-21 Thread Jim S 
Started looking in to this issue again today and found this: 
 
http://stackoverflow.com/questions/19439190/segmentation-fault-while-using-pandas-in-uwsgi

I took the advice of Roberto and removed the --limit-as in 
/etc/uwsgi/web2py.ini - and now it seems to work find.  I am clueless as to 
what is going on here, but am really hoping that I've found a solution. 
 Will report back if I have more news.

-Jim


On Wednesday, August 17, 2016 at 4:25:19 PM UTC-5, Jim S wrote:
>
> Thanks Dave
>
> While my stated question was specific to haproxy, I'm really speaking in 
> more general terms as to whether or not the rocket server would be 
> sufficient behind ANY load balancer.  I know I could have setup nginx as 
> the load balancer, but haproxy was really quite simple.
>
> I'm going to read through you link, thank you for that.
>
> -Jim
>
>
> On Wed, Aug 17, 2016 at 4:04 PM, Dave S  wrote:
>
>>
>>
>> On Wednesday, August 17, 2016 at 1:15:58 PM UTC-7, Jim S wrote:
>>>
>>> Anyone else have thoughts on why I shouldn't use the rocket webserver 
>>> behind haproxy?
>>>
>>>
>> Well, before today I didn't know anything about haproxy, but it seems to 
>> have a good reputation as a load balancer.  So it should take care of 
>> scaling.
>> I haven't yet found out about its security features.
>>
>> This page gives haproxy high marks from actual users, but most of the 
>> posts go back several years.  The most recent post
>> provides an update of nginx's capabilities as of about a year ago.
>> > https://www.quora.com/Which-software-load-balancer-is-better-HAProxy-or-nginx
>> >
>>
>> /dps
>>  
>>
>> -- 
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> --- 
>> You received this message because you are subscribed to a topic in the 
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit 
>> https://groups.google.com/d/topic/web2py/MTOjl8gPuTk/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to 
>> web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Web2py freezing

2016-10-21 Thread piero crisci 
I just checked error logs and i got this:

[Fri Oct 21 18:02:28.797956 2016] [wsgi:warn] [pid 4676:tid 436] mod_wsgi: 
Compiled for Python/2.7.9+.
[Fri Oct 21 18:02:28.798955 2016] [wsgi:warn] [pid 4676:tid 436] mod_wsgi: 
Runtime using Python/2.7.9.
[Fri Oct 21 18:02:28.799957 2016] [mpm_winnt:notice] [pid 4676:tid 436] 
AH00455: Apache/2.4.18 (Win64) mod_wsgi/4.4.6 Python/2.7.9 configured -- 
resuming normal operations
[Fri Oct 21 18:02:28.799957 2016] [mpm_winnt:notice] [pid 4676:tid 436] 
AH00456: Apache Lounge VC14 Server built: Dec  9 2015 11:13:29
[Fri Oct 21 18:02:28.799957 2016] [core:notice] [pid 4676:tid 436] AH00094: 
Command line: 'C:\\Apache24\\bin\\httpd.exe -d C:/Apache24'
[Fri Oct 21 18:02:28.799957 2016] [mpm_winnt:notice] [pid 4676:tid 436] 
AH00418: Parent: Created child process 620
[Fri Oct 21 18:02:29.050971 2016] [wsgi:warn] [pid 620:tid 320] mod_wsgi: 
Compiled for Python/2.7.9+.
[Fri Oct 21 18:02:29.051971 2016] [wsgi:warn] [pid 620:tid 320] mod_wsgi: 
Runtime using Python/2.7.9.
[Fri Oct 21 18:02:29.083973 2016] [mpm_winnt:notice] [pid 620:tid 320] 
AH00354: Child: Starting 250 worker threads.
[Fri Oct 21 18:02:57.639608 2016] [wsgi:error] [pid 620:tid 2416] No 
handlers could be found for logger "web2py"
Debugging i got just this error:
(OS 64)The specified network name is no longer available. : AH00341: 
winnt_accept: Asynchronous AcceptEx failed. 

Can' t understand why app is freezing. I just thinking is somenthing due to 
sessions or too much ajax calls




Il giorno venerdì 21 ottobre 2016 12:47:48 UTC+2, 黄祥 ha scritto:
>
> perhaps its easier to give the error log rather than just the 
> configuration, learn from a lot of discussion in this forum apache is not 
> recommended
>
> best regards,
> stifan
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: A new and easier way to test your apps

2016-10-21 Thread Pierre 
I managed to register Homer Simpson but he can't login..it is 
sad...:(

did you or someone else manage to login anybody with webclient  and a 
correct email address ?


Homer's "resurrection" seems tricky so I leave it for now 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: the request value run well in terminal too like in browser

2016-10-21 Thread 黄祥 
yes, that what i face too.
first : the same request might have the different value, e.g. 
request.folder in web browser return 
/Users/test/site/web2py/applications/test/ yet in terminal return 
 applications/test/
second : the storage dict is not fully covered in terminal e.g. request.env 
in this value in browser, there is a value for server_software, but no 
value in terminal

so i take the it general (use python module e.g. os or something else) and 
have the same value for both side (terminal & browser).
e.g.
*models/db.py*
environment_base = (os.uname()[1] != myconf.get(myconf_env + '_' + 
'environment.server_name') ) or \
  (request.env.web2py_path != myconf.get(myconf_env + '_' + 
'environment.web2py_path') ) or \
  (request.application != myconf.get(myconf_env + '_' + 
'environment.application') )

best regards,
stifan

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Web2py freezing

2016-10-21 Thread 黄祥 
perhaps its easier to give the error log rather than just the 
configuration, learn from a lot of discussion in this forum apache is not 
recommended

best regards,
stifan

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Web2py freezing

2016-10-21 Thread piero crisci 
Hello i am having problems with my web2py configuration using APACHE WSCGI 

I am using this configuration:
 - Windows Server 2012 R2
 - Mysql 5.7
 - Python 2.7.9
 - Apache 2.4

With more of 10 connection the application is freezing. I am not having 
answer  from the web server and all is stopped.
I m not sure why this is happening.

Anyone can help? 
If more info are needed let me Know

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
#
# This is the main Apache HTTP server configuration file.  It contains the
# configuration directives that give the server its instructions.
# See  for detailed information.
# In particular, see 
# 
# for a discussion of each configuration directive.
#
# Do NOT simply read the instructions in here without understanding
# what they do.  They're here only as hints or reminders.  If you are unsure
# consult the online docs. You have been warned.  
#
# Configuration and logfile names: If the filenames you specify for many
# of the server's control files begin with "/" (or "drive:/" for Win32), the
# server will use that explicit path.  If the filenames do *not* begin
# with "/", the value of ServerRoot is prepended -- so "logs/access_log"
# with ServerRoot set to "/usr/local/apache2" will be interpreted by the
# server as "/usr/local/apache2/logs/access_log", whereas "/logs/access_log" 
# will be interpreted as '/logs/access_log'.
#
# NOTE: Where filenames are specified, you must use forward slashes
# instead of backslashes (e.g., "c:/apache" instead of "c:\apache").
# If a drive letter is omitted, the drive on which httpd.exe is located
# will be used by default.  It is recommended that you always supply
# an explicit drive letter in absolute paths to avoid confusion.

#
# ServerRoot: The top of the directory tree under which the server's
# configuration, error, and log files are kept.
#
# Do not add a slash at the end of the directory path.  If you point
# ServerRoot at a non-local disk, be sure to specify a local disk on the
# Mutex directive, if file-based mutexes are used.  If you wish to share the
# same ServerRoot for multiple httpd daemons, you will need to change at
# least PidFile.
#
ServerRoot "c:/Apache24"

#
# Mutex: Allows you to set the mutex mechanism and mutex file directory
# for individual mutexes, or change the global defaults
#
# Uncomment and change the directory if mutexes are file-based and the default
# mutex file directory is not on a local disk or is not appropriate for some
# other reason.
#
# Mutex default:logs

#
# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the 
# directive.
#
# Change this to Listen on specific IP addresses as shown below to 
# prevent Apache from glomming onto all bound IP addresses.
#
#Listen 12.34.56.78:80
Listen 80
Listen 443
#
# Dynamic Shared Object (DSO) Support
#
# To be able to use the functionality of a module which was built as a DSO you
# have to place corresponding `LoadModule' lines at this location so the
# directives contained in it are actually available _before_ they are used.
# Statically compiled modules (those listed by `httpd -l') do not need
# to be loaded here.
#
# Example:
# LoadModule foo_module modules/mod_foo.so
#
LoadModule access_compat_module modules/mod_access_compat.so
LoadModule actions_module modules/mod_actions.so
LoadModule alias_module modules/mod_alias.so
LoadModule allowmethods_module modules/mod_allowmethods.so
LoadModule asis_module modules/mod_asis.so
LoadModule auth_basic_module modules/mod_auth_basic.so
#LoadModule auth_digest_module modules/mod_auth_digest.so
#LoadModule auth_form_module modules/mod_auth_form.so
#LoadModule authn_anon_module modules/mod_authn_anon.so
LoadModule authn_core_module modules/mod_authn_core.so
#LoadModule authn_dbd_module modules/mod_authn_dbd.so
#LoadModule authn_dbm_module modules/mod_authn_dbm.so
LoadModule authn_file_module modules/mod_authn_file.so
#LoadModule authn_socache_module modules/mod_authn_socache.so
#LoadModule authnz_fcgi_module modules/mod_authnz_fcgi.so
#LoadModule authnz_ldap_module modules/mod_authnz_ldap.so
LoadModule authz_core_module modules/mod_authz_core.so
#LoadModule authz_dbd_module modules/mod_authz_dbd.so
#LoadModule authz_dbm_module modules/mod_authz_dbm.so
LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_host_module modules/mod_authz_host.so
#LoadModule authz_owner_module modules/mod_authz_owner.so
LoadModule