Thanks for your reply Massimo, yes, I have a couple of web2py apps with
Pythonanywhere for about a year now and I had no problems with them.
However, it seems impossible to correctly connect my new app to mysql on
Pythonanywhere I am giving up on this because I have been trying for over a
week and I am not getting anywhere. I have been going back and forth with
their support on their forum but we can't find an answer.
The app is up on their server and works fine with sqlite but not with mysql.
On Monday, August 17, 2015 at 6:50:03 AM UTC+8, Massimo Di Pierro wrote:
>
> I would talk to them. They are very supporting. Anyway that said. You can
> use any hosting you want. I use Python Anywhere, Digital Ocean, Google App
> Engine, and Google Managed VM (with Docker) for different projects.
>
> On Sunday, 16 August 2015 15:43:21 UTC-5, DaneW wrote:
>>
>> I've been using PythonAnywhere happily for over 2 years. The database
>> (now with over 12m records) has worked perfectly under SQLite and later
>> MySQL - although I do get error 1226 about exceeding max_user_connections
>> every so often.
>>
>> In the db.py model I have db =
>> DAL('mysql://aaa:[email protected]/ccc$db1',pool_size=0,lazy_tables=True,check_reserved=['all'])
>>
>> - where aaa is my user name, bbb is my MySQL password and ccc$db1 is my
>> database name.
>>
>> I used to have pool_size=1 but in the light of Annet's suggestion I've
>> changed it to 0 and it seems to be working ok. Also PythonAnywhere are
>> saying that recent infrastructure changes mean that we should alter
>> mysql.server to *yourusername*.mysql.pythonanywhere-services.com but
>> that results in my website crashing immediately so I've left it as it used
>> to be for the time being.
>>
>>
>>>
>>>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
