Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-23 Thread L c
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 > > wrote: > >> oh i forgot i have hollowed your advice, updating pymysql >> thanks again >> >> Le mercredi 22 avril

Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-22 Thread Jim Steil
I'm happy you got it working. -Jim On Wed, Apr 22, 2020 at 1:39 PM L c 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 >>

Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-22 Thread L c
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 ag

Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-22 Thread 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 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.

Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-22 Thread 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

Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-22 Thread Kevin Keller
I think there is an issue with web2py not supporting mysql version 8 and above. On Wed, 22 Apr 2020, 03:20 Jim S, 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

Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-21 Thread 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 On Tues

Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-21 Thread L c
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 > > db

Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-21 Thread 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("

Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-21 Thread L c
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 > > wrote: > >> New server >> same app >> same credentials >> thank you >> >> >> Le mardi 21 avril 2020 22:04:43 UTC+2, Jim S a

Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-21 Thread Jim Steil
Is the DB on a separate server from the web application? Jim On Tue, Apr 21, 2020, 5:59 PM L c 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'

[web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-21 Thread 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) Le mercredi 22 avril 2020 00:59:12 UTC+2, L c a écrit : > > New server > same app > same credentials > thank you > > > Le mardi 21 avril 2020 22:04:4

[web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-21 Thread L c
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,

[web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-21 Thread 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 On Tuesday, April 21, 2020 at 2:30:15 PM UTC-5, L c wrote: > > Failure to connect, tried 5 times: > Traceback (most recent call l

[web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-21 Thread L c
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 = s

[web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-21 Thread L c
x# 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 registere