In your second post above you're connecting to mysql with user usertest and
a password.
In you web2py example you're connecting with user root.
I'm guessing that is not the issue but can you confirm that you're using
the same user and password connecting via mysql and via web2py?
-Jim
On Tuesday, April 21, 2020 at 7:59:52 PM UTC-5, L c wrote:
>
> 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 <lcham...@gmail.com> 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
>>>>> web...@googlegroups.com.
>>>>> 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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/42b76488-0f21-4e02-898b-4f4fc8d68d3b%40googlegroups.com.
