I think there is an issue with web2py not supporting mysql version 8 and above.
On Wed, 22 Apr 2020, 03:20 Jim S, <[email protected]> wrote: > 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 <[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/42b76488-0f21-4e02-898b-4f4fc8d68d3b%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/42b76488-0f21-4e02-898b-4f4fc8d68d3b%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/CADHCKLQH66dP0e8yxm_mguGQ7HVGLcFFJTUnD%3DZmByBv%2BjC7dg%40mail.gmail.com.
