Issue connecting to MySql DB

Rohan_P · December 4, 2018, 12:04pm

@mark-piller @staff When I try to connect to MySql DB its says Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
can anyone help me on this.
30%20PM

sergey.kuk · December 4, 2018, 12:06pm

make sure that bl-server has access to the mysql

Rohan_P · December 4, 2018, 12:08pm

how can i check that?

Rohan_P · December 4, 2018, 1:47pm

@sergey.kuk the issue was with the port. Now the db is added

Rohan_P · December 4, 2018, 1:49pm

@sergey.kuk But now its just loading.

Rohan_P · December 4, 2018, 2:25pm

@mark-piller can you help on this.

mark-piller · December 4, 2018, 2:38pm

Your request is in support queue. We have multiple customers to assist. Please be patient, all support requests are answered within 24 hours, Monday-Friday.

Regards,
Mark

Rohan_P · December 4, 2018, 2:44pm

Okay, Thank you Mark.

mark-piller · December 4, 2018, 5:08pm

Please check the “bl-server” log and see if there are any errors reported there.

Regards,
Mark

Rohan_P · December 4, 2018, 6:19pm

Thanks for the reply @mark-piller.
When I added the connection for the first time i could see the list of tables, but when I navigated to BL tab and came back to Data Management tab, I am not able to see any data it keeps loading.

Here are the logs:

Summary

bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer |
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlTables
| INFO: Crawling tables
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.TableRetriever retrieveTables
| INFO: Retrieving tables
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.TableRetriever retrieveTablesFromMetadata
| INFO: Retrieving tables for schema
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.MetadataResultSet close
| INFO: Processed 1 rows for
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlTables
| INFO: Retrieved 1 tables
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.TableColumnRetriever retrieveHiddenColumns
| INFO: No hidden table columns SQL provided
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.TableColumnRetriever retrieveColumns
| INFO: Retrieving table columns
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlTables$19
| WARNING: Foreign-keys are not being retrieved, so tables cannot be sorted using the natural sort order
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlTables$21
| INFO: Retrieving primary keys and indexes
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.IndexRetriever retrievePrimaryKeys
| INFO: Retrieving primary keys
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlTables
| INFO: Total time taken for - 00:00:00.011 hours
| - 27.3% - 00:00:00.003 -
| - 36.4% - 00:00:00.004 -
| - 0.0% - 00:00:00.000 -
| - 9.1% - 00:00:00.001 -
| - 18.2% - 00:00:00.002 -
| - 0.0% - 00:00:00.000 -
| - 0.0% - 00:00:00.000 -
| - 0.0% - 00:00:00.000 -
| - 0.0% - 00:00:00.000 -
| - 0.0% - 00:00:00.000 -
| - 9.1% - 00:00:00.001 -
| - 0.0% - 00:00:00.000 -
| - 0.0% - 00:00:00.000 -
| - 0.0% - 00:00:00.000 -
| - 0.0% - 00:00:00.000 -
|
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlRoutines
| INFO: Crawling routines
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveProcedures
| INFO: Not retrieving procedures, since this was not requested
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveFunctions
| INFO: Not retrieving functions, since this was not requested
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlRoutines
| INFO: Retrieved 0 routines
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSynonyms
| INFO: Not retrieving synonyms, since this was not requested
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSequences
| INFO: Not retrieving sequences, since this was not requested
| Tue Dec 04 15:30:40 UTC 2018 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
| Dec 04, 2018 3:30:40 PM schemacrawler.utility.SchemaCrawlerUtility buildDatabaseSpecificOverrideOptions
| INFO: Using database plugin for mysql - MySQL
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSchemas
| INFO: Crawling schemas
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaRetriever retrieveAllSchemas
| INFO: Retrieving all schemas
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaRetriever retrieveAllCatalogs
| INFO: Retrieving all catalogs
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaRetriever retrieveSchemas
| INFO: Retrieved 1 schemas
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSchemas
| INFO: Total time taken for - 00:00:00.011 hours
| -100.0% - 00:00:00.011 -
| - 0.0% - 00:00:00.000 -
|
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlDatabaseInfo
| INFO: Retrieving database information
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlDatabaseInfo$3
| INFO: Not retrieving additional database information, since this was not requested
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlDatabaseInfo
| INFO: Retrieving JDBC driver information
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlDatabaseInfo$5
| INFO: Not retrieving additional JDBC driver information, since this was not requested
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlDatabaseInfo
| INFO: Retrieving SchemaCrawler crawl information
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlDatabaseInfo
| INFO: Total time taken for - 00:00:00.002 hours
| - 50.0% - 00:00:00.001 -
| - 0.0% - 00:00:00.000 -
| - 50.0% - 00:00:00.001 -
| - 0.0% - 00:00:00.000 -
| - 0.0% - 00:00:00.000 -
|
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlColumnDataTypes
| INFO: Crawling column data types
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlColumnDataTypes$0
| INFO: Not retrieving system column data types, since this was not requested
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlColumnDataTypes$1
| INFO: Not retrieving user column data types, since this was not requested
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlColumnDataTypes
| INFO: Total time taken for - 00:00:00.006 hours
| -100.0% - 00:00:00.006 -
| - 0.0% - 00:00:00.000 -
|
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlTables
| INFO: Not retrieving tables, since this was not requested
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlRoutines
| INFO: Crawling routines
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveProcedures
| INFO: Retrieving procedures
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveProceduresFromMetadata
| INFO: Retrieving procedures for schema
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.MetadataResultSet close
| INFO: Processed 0 rows for
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveFunctions
| INFO: Retrieving functions
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveFunctionsFromMetadata
| INFO: Retrieving functions for schema
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.MetadataResultSet close
| INFO: Processed 0 rows for
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlRoutines
| INFO: Retrieved 0 routines
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSynonyms
| INFO: Not retrieving synonyms, since this was not requested
| Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSequences
| INFO: Not retrieving sequences, since this was not requested
| Tue Dec 04 15:30:43 UTC 2018 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
| Tue Dec 04 15:30:43 UTC 2018 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| Tue Dec 04 15:35:40 UTC 2018 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| Tue Dec 04 15:47:47 UTC 2018 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
| reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json

mark-piller · December 4, 2018, 6:27pm

is your installation available from the outside? Can we connect to your backendless console somehow?

Rohan_P · December 4, 2018, 6:34pm

Ya @mark-piller I will send you the link as a message.

Rohan_P · December 5, 2018, 7:01am

@mark-piller I am able to get the database data if I specify the database_name.table_name from codeless. But only the issue is when i select the database in the data management, I am not able to see the data, as i said it keeps loading.

mark-piller · December 5, 2018, 3:40pm

Rohan,

We made a fix and published an update. Please follow the instructions below to apply the update:

Stop all processes with the following command: ./backendless_stop.sh
Run the following command: /backendless_install.sh, answer all the prompts (if any)
Run the following command: /backendless_start.sh

Let me know when you’re done so I can verify the fix in your installation from our side.

Regards,
Mark

Rohan_P · December 6, 2018, 5:30am

Thank you @mark-piller, i will do it and update you about issue. But before trying i have a question, As i have created a method, will i have to redo it again if i install?

mark-piller · December 6, 2018, 5:34am

No, the update doesn’t remove any data or logic

Rohan_P · December 6, 2018, 5:40am

Thank you @mark-piller, I will try it.

Rohan_P · December 12, 2018, 12:53pm

Thank you @mark-piller I am able to see the data now.

mark-piller · December 12, 2018, 12:58pm

Thank you for confirming. How did the demo go?

Rohan_P · December 12, 2018, 1:01pm

Due to the CORS issue we were not able to give the demo.