debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

[L c]

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

[L c]

xxxxx# mysql -h localhost -u usertest -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 420
Server version: 8.0.19 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

mysql> use 4test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables
    -> ;
+-----------------+
| Tables_in_4test |
+-----------------+
| personnel       |
+-----------------+
1 row in set (0,00 sec)

[L c]

<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 :

[Jim S]

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

[L c]

New server

same app

same credentials

thank you

[L c]

if i test with a new app, new bdd a simple one it does not work :( (credentials are good, port 3306 open .. checked by command line or phpmyadmin)

[Jim Steil]

Is the DB on a separate server from the web application?

Jim

--
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 web2py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/93626f3b-6e42-4520-9cac-d24577798a3b%40googlegroups.com.

[L c]

No

To unsubscribe from this group and all its topics, send an email to web...@googlegroups.com.

[L c]

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)

[L c]

no idea ?

[Jim S]

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

[Kevin Keller]

I think there is an issue with web2py not supporting mysql version 8 and above.

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+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/42b76488-0f21-4e02-898b-4f4fc8d68d3b%40googlegroups.com.

[Jim S]

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

To unsubscribe from this group and stop receiving emails from it, send an email to web...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/42b76488-0f21-4e02-898b-4f4fc8d68d3b%40googlegroups.com.

[L c]

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

[L c]

oh i forgot i have hollowed your advice, updating pymysql

thanks again

[Jim Steil]

I'm happy you got it working.

-Jim

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/fac6cef8-6c0d-463c-be1c-0a5bab4f2e93%40googlegroups.com.

[L c]

Thank you again, i was feeling alone .

To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/fac6cef8-6c0d-463c-be1c-0a5bab4f2e93%40googlegroups.com.