Thank you again, i was feeling alone . Le mercredi 22 avril 2020 21:11:44 UTC+2, Jim S a écrit : > > I'm happy you got it working. > > -Jim > > On Wed, Apr 22, 2020 at 1:39 PM L c <[email protected] <javascript:>> > 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] <javascript:>. >> 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/da28f9b3-dec4-4e80-8eb4-6a2f6435d994%40googlegroups.com.
