Thanks for your reply Dane,
For my other 2 apps hosted with Pythonanywhere, which are working fine, I
have been using this in my db.py model:
db =
DAL('mysql://aaa:[email protected]/ccc$mydbname')
My new app, however is not working with this code. I just tried the code
you posted and I get the same result as with the code above. Now working.
My new app works with SQlite on their server but, after a week of trying
just about everything, it seems impossible to properly connect to the
mysql. Needless to say I am very frustrated, I have been developing this
app for 3 month and I don't even a theory of what could possible be the
problem.
Thanks very much for your help. If you have any other ideas please let me
know.
On Monday, August 17, 2015 at 4:43:21 AM UTC+8, 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.
