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/375e46bd-fe89-41dd-9244-4c110201a4f1%40googlegroups.com.