im trying to install the pro version for two days now. i got around all the errors with missing packages and now im stuck at this error
bl-swarm_bl-server.1.pzwdmswiuq50@ip-172-31-29-125 | 00:11:41.364 [INFO] WaiterService |main| SQL database 'main_backendless' is not accessible. Error message: invalid database address: jdbc:mysql://bl-mysql:3306?zeroDateTimeBehavior=convertToNull&&useSSL=false&&requireSSL=false&&dumpQueriesOnException=true&&exceptionInterceptors=com.backendless.util.jdbc.ExceptionLogInterceptor&&allowPublicKeyRetrieval=true. Waiting for 3000 millis before retry...
bl-swarm_bl-server.1.pzwdmswiuq50@ip-172-31-29-125 | 00:11:44.365 [ERROR] c.b.u.j.ExceptionLogInterceptor |main| Error during SQL query execution.
bl-swarm_bl-server.1.pzwdmswiuq50@ip-172-31-29-125 | com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
some guide line is appreciated
here is backendless_status
5b8tqphh5a9x bl-swarm_bl-coderunner-java replicated 1/1 backendless/bl-coderunner-java:latest
here is backendless_status full
ID NAME IMAGE NODE DESIRED STATE CURRENT STATE ERROR PORTS
Hello @mohammad_altoiher
Thank you for trying BackendlessPro
Could you please try the following steps:
stop your installation
remove the working directory (or just leave it for now)
open the following guid GitHub - Backendless/BackendlessPro: This is a repo for the distribution of Backendless Pro - the self-hosted version of the product.
download the latest archive and unzip it, the first step of the Getting Started guide
in the second steps instead of running chmod +x *.sh try to run this one: chmod -R 777 /full/path/to/the/working/directory
go through remains steps in the Getting Started guide
Regards, Vlad
Thanks Vlad!
i don’t want to open a new thread
is there a guide on migrating my app files and servercode?
is there a guide on migrating my app files and servercode?
just try to zip, download, upload and unzip
JS code did show up
try to go to the Coding section and deploy all the Codeless models
ok deployed the services one by one and i can see them.Oops. An internal error....... We are working on it. Please try again later
where can i see that error to figure out the issue
Also Users table data is not importing and there is no error
Have you checked the import log file?
could you check what request is failing in the browser dev console?
i found one issue about an INT field but was STRING in import
16:51:02 IMPORT_DATA Importing Started.
16:51:02 IMPORT_DATA Preparing files to import
16:51:02 IMPORT_DATA Creating temporary tables
16:51:02 IMPORT_DATA Creating user's tables
16:51:02 IMPORT_DATA Preparing Users table: initializing columns.
16:51:02 IMPORT_DATA SRS ID was not provided for spatial column w 'user_location'. Default SRS ID '0' will be used.
16:51:04 IMPORT_DATA Preparing Users table: updating column related IDs.
16:51:04 IMPORT_DATA Preparing Users table: initializing relations.
16:51:04 IMPORT_DATA Checking denied and duplicate columns.
16:51:04 IMPORT_DATA Resolving related table.
16:51:04 IMPORT_DATA Getting meta-info about insetable tables.
16:51:05 IMPORT_DATA Start import table: Users
16:51:05 IMPORT_DATA Started import data from csv Users.csv
16:51:05 IMPORT_DATA Will perform Inserting or ignore (on duplicate by objectId).
16:51:05 IMPORT_DATA Reading next portion (0) of data from csv Users.csv.
16:51:05 IMPORT_DATA Created new import subtask (1) for Users.csv with 122 elements.
16:51:05 IMPORT_DATA Reading next portion (1) of data from csv Users.csv.
16:51:05 IMPORT_DATA Started import subtask (1) for Users table.
16:51:05 IMPORT_DATA Table 'Users' was imported at 0 seconds. Saved 0 records.
16:51:05 IMPORT_DATA Finish import table: Users
16:51:05 IMPORT_DATA Started restoring relations.
16:51:05 IMPORT_DATA Counting relations.
16:51:05 IMPORT_DATA Clearing user data table cache.
16:51:06 IMPORT_DATA Deleting temporary tables.
16:51:06 IMPORT_DATA Finishing pointers export.
16:51:06 IMPORT_DATA Start import pointers for table: Users
16:51:06 IMPORT_DATA Finished import of table: Users
16:51:06 IMPORT_DATA Restoring expiration tasks for DeviceRegistrations.
16:51:06 IMPORT_DATA Import finished.
still the Users table is empty
try to run the following commands:
docker ps
then find a container_id for bl-web-console and run:
docker logs container_id
2021-06-18T19:06:53.380Z - error: [API_PROXY] Received an error from ProxyServer: http://bl-server:9000 message=getaddrinfo ENOTFOUND bl-server, stack=Error: getaddrinfo ENOTFOUND bl-server
Unhandled internal error: “getaddrinfo ENOTFOUND backendless.local”
{
"method": "GET",
"url": "/591EF93F-79A6-EA6C-FF04-C92B42F34C00/console/localservices/codeless/0A99661A-2771-35EF-FFF3-CFCB839F5300/likeReplay/logic",
"params": {
"appId": "591EF93F-79A6-EA6C-FF04-C92B42F34C00"
},
"query": {},
"headers": {
"host": "backendless.local",
"user-agent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:89.0) Gecko/20100101 Firefox/89.0",
"accept": "*/*",
"accept-language": "en-US,en;q=0.5",
"accept-encoding": "gzip, deflate",
"auth-key": "ibchdsojsqvvdjktrphzwpklbgnwwzidajop",
"x-request-uid": "2728BD3B-05C8-B938-7102-6054CAD862F8",
"x-request-initiator": "console-client",
"connection": "keep-alive",
"referer": "http://backendless.local/m7l_e/bl/services/AskAroundService/likeReplay",
"cookie": "dev-auth-key=ibchdsojsqvvdjktrphzwpklbgnwwzidajop; dev-last-used-app-id=591EF93F-79A6-EA6C-FF04-C92B42F34C00; io=XSUExEJpZ3RunVerAAAB"
},
"body": {}
}
Error: getaddrinfo ENOTFOUND backendless.local
at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:64:26)
don’t i have to setup a domain name instead of backendless.local? to use it from the web.
Hi, @mohammad_altoiher
To understand in which subsystem of your problem i need information from you, will you need to show the output to such commands?
sudo grep “backendless.local” /etc/hosts
docker ps | grep bl-server
ping bl-server
no output but sudo nano /etc/hosts show this
27.0.0.1 localhost
# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
127.0.0.1 backendless.local
28d1fbee1df9 backendless/bl-server:latest "/opt/backendless/st…" 34 minutes ago Up 34 minutes (healthy) bl-swarm_bl-server.1.jf0say7cy1wl7v0u44krw8jtu
d93448a380a7 backendless/bl-server:latest "/opt/backendless/st…" 17 hours ago Up 17 hours bl-swarm_bl-taskman.1.tx5h6z6gczoglm1nq9fntuhom
Marian_Koreniuk:
ping bl-server
ping: bl-server: Name or service not known
sergey.kuk
June 23, 2021, 9:01am
18
Hello @mohammad_altoiher
Sorry for the late response. Please add the following line to etc/hosts file:
127.0.0.1 backendless.local
Its already there as i mentioned in my previous post
maybe this will help
2021-06-23T09:39:29.507Z - info:
2021-06-23T09:39:29.508Z - info: *************************************************************************************
2021-06-23T09:39:29.508Z - info: *** Backendless.Console is running, talking to API server on http://bl-server:9000
2021-06-23T09:39:29.508Z - info: *** Open http://localhost:80 in a browser to view the app.
2021-06-23T09:39:29.508Z - info: *************************************************************************************
2021-06-23T09:39:29.508Z - info:
2021-06-23T10:41:07.548Z - info: Load Console Status
2021-06-23T10:41:29.552Z - error: [INTERNAL SERVER ERROR] 5c31af9972eafa92b97d5bc754c4580f message=getaddrinfo ENOTFOUND backendless.local, stack=Error: getaddrinfo ENOTFOUND backendless.local
at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:64:26), errno=ENOTFOUND, code=ENOTFOUND, syscall=getaddrinfo, hostname=backendless.local, id=5c31af9972eafa92b97d5bc754c4580f
