I'm happy you got it working. -Jim
On Wed, Apr 22, 2020 at 1:39 PM L c <[email protected]> wrote: > oh i forgot i have hollowed your advice, updating pymysql > thanks again > > Le mercredi 22 avril 2020 20:38:09 UTC+2, L c a écrit : >> >> 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 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/fac6cef8-6c0d-463c-be1c-0a5bab4f2e93%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/fac6cef8-6c0d-463c-be1c-0a5bab4f2e93%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/CAERBpoA_dX1SSHZ13QnWaqMKatUNDVBU_CNte8Oi2fiP%2Bwj7NQ%40mail.gmail.com.
