no idea ?
Le mercredi 22 avril 2020 02:12:43 UTC+2, L c a écrit :
>
> 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/30d22d25-6b1c-4aaa-9d32-9d6bed96a29e%40googlegroups.com.
