for now it works i don't know why (i have insttalled mysql connector but i don't think this is the reason) after a reboot (2 in fact) it is now ok thank you again for your help
Le mercredi 22 avril 2020 14:49:58 UTC+2, Jim S a écrit : > > I am using MySQL 8 on my development box. I'm running 5.7 on production > servers. > > But, version 8 is working fine for me. I too had issues when I first > installed version 8, but it wasn't with web2py connecting to it. My > problems had more to do with interchanging data between version 5.7 and 8 > and the way data exports and imports performed. > > To the original post. > > Have you seen this? > > > https://stackoverflow.com/questions/45368336/error-keyerror-255-when-executing-pymysql-connect > > Can you possibly update pymysql on your system? I'm wondering if you have > an older version. > > -Jim > > On Wednesday, April 22, 2020 at 2:16:36 AM UTC-5, Kevin Keller wrote: >> >> 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/2e75612e-69b4-4739-837c-38d5776ce37d%40googlegroups.com.
