Comments (11)
( .. ran into mysqljs connectivity issue whilst setting up mysql 8. Will give it a try later )
from nocodb.
@ashankasr : looks like it is compatibility with mysql v8.0.
I haven;t tested it with mysql v8.0.
Could you please paste this from your mysql console
describe information_schema.VIEWS;
from nocodb.
How to solve this problem
from nocodb.
I've the same problem, any solution?
from nocodb.
@tmlzx @asllamas : could you please paste the error stack you are seeing.
I tried connecting to mysql8 on my machine and encountered following error from mysql module
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
This looks like issue in npm module mysql
- and they are resolving this issue here - mysqljs/mysql#1962. Once this is resolved I will have a look.
Note:
Mysql workbench 6.x.x had issues connecting to mysql 8 server. Had to update workbench to latest dev version 8.0.1 to connect.
from nocodb.
The error:
Generating REST APIs at the speed of your thought..
C:\Users\alex\AppData\Roaming\npm\node_modules\xmysql\node_modules\mysql\lib\protocol\Parser.js:80
throw err; // Rethrow non-MySQL errors
^
TypeError: Cannot read property 'isView' of undefined
at Xsql.iterateToCacheTables (C:\Users\alex\AppData\Roaming\npm\node_modules\xmysql\lib\xsql.js:75:74)
at Query.self.pool.query (C:\Users\alex\AppData\Roaming\npm\node_modules\xmysql\lib\xsql.js:46:14)
at Query.<anonymous> (C:\Users\alex\AppData\Roaming\npm\node_modules\xmysql\node_modules\mysql\lib\Connection.js:502:10)
at Query._callback (C:\Users\alex\AppData\Roaming\npm\node_modules\xmysql\node_modules\mysql\lib\Connection.js:468:16)
at Query.Sequence.end (C:\Users\alex\AppData\Roaming\npm\node_modules\xmysql\node_modules\mysql\lib\protocol\sequences\Sequence.js:83:24)
at Query._handleFinalResultPacket (C:\Users\alex\AppData\Roaming\npm\node_modules\xmysql\node_modules\mysql\lib\protocol\sequences\Query.js:139:8)
at Query.EofPacket (C:\Users\alex\AppData\Roaming\npm\node_modules\xmysql\node_modules\mysql\lib\protocol\sequences\Query.js:123:8)
at Protocol._parsePacket (C:\Users\alex\AppData\Roaming\npm\node_modules\xmysql\node_modules\mysql\lib\protocol\Protocol.js:278:23)
at Parser.write (C:\Users\alex\AppData\Roaming\npm\node_modules\xmysql\node_modules\mysql\lib\protocol\Parser.js:76:12)
at Protocol.write (C:\Users\alex\AppData\Roaming\npm\node_modules\xmysql\node_modules\mysql\lib\protocol\Protocol.js:38:16)
from nocodb.
@asllamas : thank you.
Could you please paste the output of the following mysql query on your machine. This will be helpful.
describe information_schema.VIEWS;
Note:
Strangely, from your and original log in this issue - it appears mysql connection was made successfully(!) and there was an issue with reading views table. However with my setup - it is failing to connect.
from nocodb.
Field,Type,Null,Key,Default,Extra
TABLE_CATALOG,varchar(64),YES,,NULL,
TABLE_SCHEMA,varchar(64),YES,,NULL,
TABLE_NAME,varchar(64),YES,,NULL,
VIEW_DEFINITION,longtext,YES,,NULL,
CHECK_OPTION,"enum('NONE','LOCAL','CASCADED')",YES,,NULL,
IS_UPDATABLE,"enum('NO','YES')",YES,,NULL,
DEFINER,varchar(93),YES,,NULL,
SECURITY_TYPE,varchar(7),YES,,NULL,
CHARACTER_SET_CLIENT,varchar(64),NO,,NULL,
COLLATION_CONNECTION,varchar(64),NO,,NULL,
from nocodb.
@asllamas: Thank you. Please check if latest version of xmysql is of any help.
There was an issue accessing isView property which was overlooked (as I am still not clear on how xmysql is able to access mysql 8)
Update or install latest xmysql (0.4.8)
npm update -g xmysql
Please let me know the result.
from nocodb.
works perfectly! , thank you
from nocodb.
Can you upgrade on docker please? Thank you!
from nocodb.
Related Issues (20)
- 🔦 Feature: Allow to set global default for interpreting `LongText` columns as Markdown ("rich text") HOT 6
- 🐛 Bug: Updating SQlite source path is not functioning as expected
- 🐛 Bug: typo in swagger response "BadReqeust" HOT 1
- 🐛 Bug: Creating a new table hangs if Default database is not visible HOT 2
- 🐛 Bug: Image display issue
- 🔦 Feature: Swap keyboard shortcut for going to first and last pages
- Executable build action fails when using latest version of sqlite3 package
- 🐛 Bug: Commenter/Viewer can enable columns in View but they show empty
- 🐛 Bug: Update Cells on a PostgresView HOT 2
- 🐛 Bug: form with default value configured for select field leads to error HOT 2
- 🐛 Bug: Roles other than superadmin don't have ability to edit own comment
- 🔦 Feature: Add a settings per projects and/or per tables for the pagination and number of rows shown
- 🐛 Bug: multi field editor option colour change HOT 2
- NocoDB random table identifier on V2 API Spec HOT 2
- 🐛 Bug: nocodb-sdk uses PUT instead of PATCH for api.dbDataTableRow.update
- The interface in the controller always redirects to the login page.
- [Question] I want to understand how you used sheet js to build you smart sheet?
- 🐛 Bug: Attachments are not actually deleted from S3 bucket when removed from cell HOT 3
- Failed to resolve entry for package "nocodb-sdk"🐛 Bug: HOT 2
- 🐛 Bug: Attachment file names have redundant file extension if MIME type extension != existing file extension HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from nocodb.