Support Topics Documentation Slack YouTube Blog

Issue connecting to MySql DB


(Rohan P) #1

@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 Kukurudzyak) #2

make sure that bl-server has access to the mysql


(Rohan P) #3

how can i check that?


(Rohan P) #4

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


(Rohan P) #5

@sergey.kuk But now its just loading.


(Rohan P) #6

@mark-piller can you help on this.


(Mark Piller) #7

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) #8

Okay, Thank you Mark.


(Mark Piller) #9

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

Regards,
Mark


(Rohan P) #10

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 | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlTables
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Crawling tables
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.TableRetriever retrieveTables
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving tables
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.TableRetriever retrieveTablesFromMetadata
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving tables for schema
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.MetadataResultSet close
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Processed 1 rows for
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlTables
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieved 1 tables
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.TableColumnRetriever retrieveHiddenColumns
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: No hidden table columns SQL provided
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.TableColumnRetriever retrieveColumns
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving table columns
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlTables$19
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | WARNING: Foreign-keys are not being retrieved, so tables cannot be sorted using the natural sort order
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlTables$21
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving primary keys and indexes
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.IndexRetriever retrievePrimaryKeys
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving primary keys
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlTables
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Total time taken for - 00:00:00.011 hours
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 27.3% - 00:00:00.003 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 36.4% - 00:00:00.004 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 9.1% - 00:00:00.001 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 18.2% - 00:00:00.002 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 9.1% - 00:00:00.001 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer |
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlRoutines
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Crawling routines
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveProcedures
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Not retrieving procedures, since this was not requested
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveFunctions
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Not retrieving functions, since this was not requested
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlRoutines
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieved 0 routines
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSynonyms
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Not retrieving synonyms, since this was not requested
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSequences
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Not retrieving sequences, since this was not requested
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | 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.
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.utility.SchemaCrawlerUtility buildDatabaseSpecificOverrideOptions
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Using database plugin for mysql - MySQL
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSchemas
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Crawling schemas
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaRetriever retrieveAllSchemas
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving all schemas
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaRetriever retrieveAllCatalogs
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving all catalogs
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaRetriever retrieveSchemas
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieved 1 schemas
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSchemas
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Total time taken for - 00:00:00.011 hours
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | -100.0% - 00:00:00.011 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer |
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlDatabaseInfo
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving database information
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlDatabaseInfo$3
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Not retrieving additional database information, since this was not requested
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlDatabaseInfo
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving JDBC driver information
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlDatabaseInfo$5
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Not retrieving additional JDBC driver information, since this was not requested
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlDatabaseInfo
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving SchemaCrawler crawl information
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlDatabaseInfo
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Total time taken for - 00:00:00.002 hours
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 50.0% - 00:00:00.001 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 50.0% - 00:00:00.001 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer |
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlColumnDataTypes
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Crawling column data types
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlColumnDataTypes$0
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Not retrieving system column data types, since this was not requested
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler lambda$crawlColumnDataTypes$1
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Not retrieving user column data types, since this was not requested
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlColumnDataTypes
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Total time taken for - 00:00:00.006 hours
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | -100.0% - 00:00:00.006 -
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | - 0.0% - 00:00:00.000 -
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
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Not retrieving tables, since this was not requested
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlRoutines
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Crawling routines
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveProcedures
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving procedures
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveProceduresFromMetadata
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving procedures for schema
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.MetadataResultSet close
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Processed 0 rows for
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveFunctions
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving functions
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.RoutineRetriever retrieveFunctionsFromMetadata
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieving functions for schema
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.MetadataResultSet close
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Processed 0 rows for
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlRoutines
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Retrieved 0 routines
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSynonyms
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Not retrieving synonyms, since this was not requested
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | Dec 04, 2018 3:30:40 PM schemacrawler.crawl.SchemaCrawler crawlSequences
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | INFO: Not retrieving sequences, since this was not requested
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | 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.
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | 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.
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | 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.
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | 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.
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json
bl-swarm_bl-server.1.qhuycn7jkw9c@BackendLessServer | reading from /opt/backendless/repo/69b3e8a0-a38c-125e-ff7b-c57c223b4700/files/servercode/CODELESS/getDataFromMysql/PRODUCTION/6A386236-05EC-2DD6-FF7D-F5306E7BB800.json


(Mark Piller) #11

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


(Rohan P) #12

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


(Rohan P) #13

@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) #14

Rohan,

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

  1. Stop all processes with the following command: ./backendless_stop.sh
  2. Run the following command: /backendless_install.sh, answer all the prompts (if any)
  3. 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) #15

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) #16

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


(Rohan P) #17

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


(Rohan P) #18


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


(Mark Piller) #19

Thank you for confirming. How did the demo go?


(Rohan P) #20

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