if i try to create a new app with that it does not work, why ?? i don't
know first time it happens. mysql-server well installed , with sqlite it
works fine ... i don't know what to do , thank you again for your help
dbun = DAL('mysql://root:mypwd@localhost:3306/4test', pool_size=0)
#dbun = DAL("sqlite://storage.sqlite")
dbun.define_table('personnel',
Field('login', type = 'string' , length = 25 ),
Field('nom', type = 'string' , length = 20 ),
migrate=True)
Le mercredi 22 avril 2020 02:05:33 UTC+2, L c a écrit :
>
> No
>
> Le mercredi 22 avril 2020 01:41:39 UTC+2, Jim S a écrit :
>>
>> Is the DB on a separate server from the web application?
>>
>> Jim
>>
>>
>> On Tue, Apr 21, 2020, 5:59 PM L c <[email protected]> wrote:
>>
>>> New server
>>> same app
>>> same credentials
>>> thank you
>>>
>>>
>>> Le mardi 21 avril 2020 22:04:43 UTC+2, Jim S a écrit :
>>>>
>>>> Is this all running on the same machine?
>>>>
>>>> I'm assuming you haven't changed your app at all, the database server
>>>> is just new. Correct? Same credentials apply?
>>>>
>>>> -Jim
>>>>
>>>> On Tuesday, April 21, 2020 at 2:30:15 PM UTC-5, L c wrote:
>>>>>
>>>>> <type 'exceptions.RuntimeError'> Failure to connect, tried 5 times:
>>>>> Traceback (most recent call last): File
>>>>> "/home/www-data/web2py/gluon/packages/dal/pydal/base.py", line 457, in
>>>>> __init__ self._adapter = adapter(**kwargs) File
>>>>> "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/__init__.py",
>>>>> line
>>>>> 39, in __call__ obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
>>>>> File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py",
>>>>> line 369, in __init__ super(SQLAdapter, self).__init__(*args, **kwargs)
>>>>> File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py",
>>>>> line 53, in __init__ self.reconnect() File
>>>>> "/home/www-data/web2py/gluon/packages/dal/pydal/connection.py", line 154,
>>>>> in reconnect self.connection = self.connector() File
>>>>> "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/mysql.py", line
>>>>> 51, in connector return self.driver.connect(**self.driver_args) File
>>>>> "/home/www-data/web2py/gluon/contrib/pymysql/__init__.py", line 90, in
>>>>> Connect return Connection(*args, **kwargs) File
>>>>> "/home/www-data/web2py/gluon/contrib/pymysql/connections.py", line 688,
>>>>> in
>>>>> __init__ self.connect() File
>>>>> "/home/www-data/web2py/gluon/contrib/pymysql/connections.py", line 905,
>>>>> in
>>>>> connect self._get_server_information() File
>>>>> "/home/www-data/web2py/gluon/contrib/pymysql/connections.py", line 1231,
>>>>> in
>>>>> _get_server_information self.server_charset = charset_by_id(lang).name
>>>>> File
>>>>> "/home/www-data/web2py/gluon/contrib/pymysql/charset.py", line 38, in
>>>>> by_id
>>>>> return self._by_id[id] KeyError: 255
>>>>>
>>>>> Le mardi 21 avril 2020 17:37:56 UTC+2, L c a écrit :
>>>>>>
>>>>>> Hello,
>>>>>> I cannot access to a mysql database, il am sure the login/pwd are ok,
>>>>>> tested on command line
>>>>>> On my old sever it was ok, no pb and now impossible :(
>>>>>> Have you an idea ?
>>>>>> thank you
>>>>>>
>>>>> --
>>> 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/EzI9i_62aSo/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> [email protected].
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/web2py/93626f3b-6e42-4520-9cac-d24577798a3b%40googlegroups.com
>>>
>>> <https://groups.google.com/d/msgid/web2py/93626f3b-6e42-4520-9cac-d24577798a3b%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>>
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/375e46bd-fe89-41dd-9244-4c110201a4f1%40googlegroups.com.
