Jump to content

Unable to connect to server


botony269
 Share

This topic is 2507 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Let me start with a question. Do either or both the hosted and mobile databases have to be on a server, FMS13? I ask because I have made all the modifications as set out in the documentation to both my hosted and mobile databases and tried syncing both locally and when both are on the server. I have also checked the path to the hosted version on the mobile.

Whatever I do I always get, when I try to sync, 'Unable to connect to server'

Any suggestions would be gratefully received

Many thanks

Tony

 

 

Link to comment
Share on other sites

Tony --

 

Ideally, the hosted database will be on FileMaker Server 13 (which allows EasySync to use the new "Perform Script on Server" script step), and the mobile database should be on either a workstation or iOS device. In other words, the two databases should really be on two separate machines.

 

I hope this helps. If you continue to run into problems, let me know.

 

Thanks!

 

-- Tim

Link to comment
Share on other sites

Thanks Tim

I now have the hosted database on Filemaker Server 13 and the mobile database on my iPhone. I can see both the server and hosted database on the iPhone  but still have the problem I still get the message 'Unable to connect to the server' when trying to sync from my iPhone.

Any further suggestions?

Many thanks

Tony

Link to comment
Share on other sites

I would check to be sure that you really can connect to the server from Go. See if you can open the hosted file directly from Go.

 

If not, then the problem isn't with EasySync. It could be a firewall issue, a connection issue in general, etc.

 

-- Tim

Link to comment
Share on other sites

Tony --

 

Sorry for the delay. I'm at DevCon this week.

 

Here's a suggestion: On the mobile side, in the EasySync Settings script, adjust the $$max_push_segment_size setting. Try lowering a bit, and then try syncing again. The smaller payload segments might help, especially if you have a slow and/or unreliable connection.

 

-- Tim

Link to comment
Share on other sites

Tony --

 

Try doing a very small sync, with just a few records, and see if that works.

 

If not, then it is likely some sort of communication problem between your iPhone and the Server.

 

Sorry for the delay - I'm on my way back from DevCon (still).

 

-- Tim

Link to comment
Share on other sites

Tim

Thanks for your patience, I think I am getting there although I have hit a new problem:

Pull error

An error occurred when attempting to process the pulled payload (Error code: 106)

As far as I am aware Error code 106 = Table missing. Is this a table the system is expecting to me to ask to be updated or something else. In the relationship graph I have included all table have new data when I use the database in the field

Many thanks again

Tony

Link to comment
Share on other sites

Ok. Make absolutely sure that the table names are the same, and then check all of the relationships between the EasySync_Payload_Details table occurrence and the "ES_" table occurrences to be sure that the "Allow creation of records in this table via this relationship" is checked (on the "ES_" side of the relationships.

 

I hope this helps. If you need further assistance, contact me directly and we can discuss rates, availability, etc. 

 

-- Tim

Link to comment
Share on other sites

  • 1 month later...

Trent --

 

Here are a few things to double-check:

 

• On the mobile side, make sure that the external data source to the hosted database has been set properly.

• From the mobile device, confirm that you can reach the hosted database.

• And I'm assuming that the hosted database is being hosted with FMS 13.

 

-- Tim

Link to comment
Share on other sites

Thanks for your quick response Tim, and also thank you for developing this, it's really fantastic!

 

anyhow,

  • The data source is set properly, and followed each of the script-on-server changes to a T... i believe
  • and I can access the mother database via filemaker go and pro, so I assume the scripts can as well (do I need to remove any security from the mother database that may be set, e.g. logins?)
  • The mother database is being hosted on an AWS virtual windows server running FMS13

 

if you need any screenshots of my table structure or anything, I will be glad to oblige, it's only three tables at this point.

 

Once again, you are truly awesome for providing support for this. You're my savior!

 

As a side note, I'd actually like to make this a one way sync, as in simply sync-up. to do so do I just use ES_PUSH_ in lieu of ES_?

Link to comment
Share on other sites

Trent --

 

If the hosted database is password protected, then you'll want to make sure that you're mobile database is protected by an account / password combo that matches one in the hosted database. That might be the problem. If not, let me know the specific error that you are getting.

 

And yes, you can configure EasySync to do "push-only" syncs. To indicate that a table should be pushed (but not pulled), use the "ES_PUSH_" prefix.

 

-- Tim

Link to comment
Share on other sites

yes I have connected via the iPad using the GO app and it connects just fine. 

 

So its definitely an issue in my setup, I'd assume.

 

 

i'm no longer allowed to make another post until the 14th after this one, 

 

My email is trentmw(at)me(DotCom)

 

 

Additionally, I notice that when the sync is occurring, it shows a found set of records with 0/0 records. do you think the find script is messed up?

Link to comment
Share on other sites

Ok... When you attempt to sync, at what stage of the sync is the connection to the hosted database failing? Is it during the "ping" phase?

 

You may want to go through the scripts and confirm that all calls to the hosted database, via the Perform Script on Server script step, are set properly.

 

-- Tim

Link to comment
Share on other sites

So the problem isn't that the mobile database can't connect to the hosted database. It's that the payload being sent by the mobile database isn't being received properly by the hosted database. 

 

In the "Push Payload" script, make sure that the calls to the "Receive Payload from Client" are wired up properly. Assuming that you're using Perform Script on Server, then you want to be sure that it is pointed to the script in the hosted database correctly.

 

Also, if you get this error again, check the EasySync table in the hosted database. If the payload is being sent and received properly, then you should see a payload segment record in the table. (You might want to set the $$delete_payloads option in the hosted database to "None" during testing so that you can see payloads that have been received.)

 

- Tim

Link to comment
Share on other sites

holy crap! i found the reason why! 

There was no table associated with the easysync_payloads layout

it seems to be working now! I'm super excited and overjoyed.. I wish I was joking.

 

 

I do have an additional question now, and I promise it's my last :)

Is it possible to have a setup where I have two buttons:

one to do a full sync with a certain database, and then another to do only a push with a different database?

 

I have a store that has 3 specialists that need to have an in-sync database, and then 10 other stores that have only one. -- those never need to do a full sync.

however I want to have data from all the stores in my master database.

 

 

I added a second external datasourse and I duplicated the scripts, would I just remove any references to the pull portions in the push-only functionality?

Link to comment
Share on other sites

"Is it possible to have a setup where I have two buttons:

one to do a full sync with a certain database, and then another to do only a push with a different database?"

 

I suppose it could be done, but not without a considerable amount of customization to EasySync.

 

Also, remember that EasySync supports both "push-only" and "pull-only" tables. To indicate that a table is to be pushed from a mobile device, but not pulled, use an "ES_PUSH_" prefix for the table occurrence's name. (Use an "ES_PULL_" prefix for the opposite.)

 

-- Tim

Link to comment
Share on other sites

This topic is 2507 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.