Aug 082012
 

Although Filemaker 9 and 10  aren’t supported on Lion and Mountain Lion anymore several of our customers still use it. As long as you upgrade from Snow Leopard everything is working as expected – even the “Open Remove” feature that is used to connect to a Filemaker Server.

The problem is, that whenever you try to reinstall Filemaker 9 Pro the required SSL Update fails to install. This happend because the OpenSSL used in this update is PPC only! After that you are still able to work on local FM databases but you are unable to connect to a remote server. The remote database list stays empty!

Luckily this problem can be easily fixed.

As far as I can tell the Filemaker application uses an SSL encrypted connection to transmit it’s data (or at least the database list 😉 ). To fix the encyption you only have to replace the certificate stored in the application bundle:

  • /…/FileMaker Pro.app/Contents/MacOS/root.pem
  • /…/FileMaker Pro.app/Contents/MacOS/server.pem

The following solutions are possible:

Obtain the certificates from a newer installation

The needed certificates are also installed by newer Filemaker versions. Just install the trail version or obtain the certificates from a different machine. To do that open the application bundle and copy the root.pem and server.pem files. To finish the surgery replace the original files (see above) in the Filemaker 9 bundle.

Download my files

To shorten the process I have uploaded my test certificates. You can also use them.

  76 Responses to “OS X: Fix Filemaker 9’s & 10’s “Open Remote” on (Mountain) Lion”

  1. Thanks this work perfectly with Filemaker pro 10 with Yosemit 10.10.5
    The server file was not there and i just added it.

  2. Wow, thank you so much for sharing this information. I know I should probably update filemaker but I really have no need to. Your post and help just saved me $$$ in upgrade costs.

  3. L.E.G.E.N.D.

  4. Saved my digital buttocks. Thank you.
    Worked on Yosemite for me!!!

  5. THANK YOU!

    Simple, worked immediately. Such a huge time savings for me, really cool of you to take the time to post this. Many thanks!

  6. Dude, you rock!!!

    Confirming, it works on FileMaker Pro 10 and Yosemite on new Mac Pro.

    Apple needs to die in a thousand fires for crap like this.

    • Neo,
      I’m considering an upgrade to yosemite–from your comment, am I to understand that you are in fact getting FM Pro 10 to run on yosemite? Thank you!

      • I have filemaker 9 running on Yosemite – after an upgrade from snow leopard – the only problem is some warning about another user on my computer sharing filemaker (not true) so I need to figure that out. My TroiURL plugin needs updating apparently too.

        • Hi Scott, I think this message pops up if another application is using port 5003. Here’s a help page outlining possible solutions. Can you try them?

          • Did try everything on that page. I even found this page that tells me what app is running on which port. Without FMP running, it says nothing is using that port. With FMPro running, FMPro is using it 🙂

            I’m running FMPro 9.0.3 on 10.10.5.

            With that said, their suggestion of “temporarily disabling extended privleges” didn’t make much sense – I turned them off, quit out and logged back end and enabled them – no difference.

            When I start up a new database and just open the application, I get no error.

            My “application” has a boot file that starts the whole system – that was made by another company and I have no access to it. Apparently THAT file has something in it that causes the problem. When I run my boot file, I get no errors. Sorry for wasting everyone’s time but there must be a script step or setting that is causing this – one that I don’t have access too (long story).

  7. Hi Florian, I’m having the same problem (FM9 can’t see remote file) but on a Windows 8.1 PC…do your test certificates only work on a Mac?

    • Hi Keith, to be honest I don’t have a clue. However my gut tells me there is another problem. Have you tried reinstalling FMP9?

  8. THANK YOU! I am so glad I rediscovered your solution. God Bless You!! 🙂

  9. Thank you so much for this. I h*te Apple and how they kill their programs, forcing us to buy new software that we don’t need. You just saved me a lot of pain!

  10. Just worked fine for a FM10 on a Mac OSX 10.9.5 Mavericks.
    I get a copy of the root.pem and server.pem from my old MacOS X 10.5.8 and Tadaa !
    🙂

    Thanks a lot. I was blocked on that problem since a few weeks.

    Apple is making me becoming more and more allergic to new system versions….

  11. Florian, thank you so much for this. I used your certificates and am now able to open a shared file using FMP 10.0v3 on Mavericks (the host is FMP 11 on Mavericks).

    The only mention of certificates I can find on the FileMaker website refers only to FileMaker Server, and has something to do with dates – not very helpful.

    Trying to share the other way round is less successful, probably because I’m running into the “…because another user…” issue. Ah well, that’s less important. You are a star.

  12. Thank you so much, it was so frustrating having no indication why until the new installation circumstance was flagged.
    The fix worked with Filemaker 10 Advanced on Mavericks.

  13. My Filemaker keeps saying this: “Filemaker cannot share files because another user is already sharing files using Filemaker Pro on this Computer” I tried the reinstalling the update and the SSL update and replacing with the root.pem & server.pem files. I am running Mavericks 10.9.4 using Filemaker Pro 9.0v.3. Any Ideas?

  14. Worked for me on 9.0v3 with 10.9.3 Mavericks. Thank you very much. Used your certificates. Interestingly, the SSL Fix for 9.0v3 from FileMaker claimed to install successfully, but it sure didn’t work! Your certificates did. Thanks again.

    • Hi Christian,
      Im trying to install filemaker pro 9 on a Mavericks, but no success. I get the error “Some of the files that are needed are either damaged…”.
      Is there a trick?
      Thank you

  15. Wow! Florian! You are our hero! We have been searching for days to find out why our Hosted/shared files are not seen on the second computer. …. Nowhere does Filemaker Corp (as far as could find) have a clear solution to this common problem. But thank heavens I found your site and solution.

    It works perfectly going between a FMP 11 host (with Mac OS 10.6.8) and a FMP 10 second computer with Mavericks.

    Problem Solved. There is a place for you in heaven!
    Thank you,
    Stephen

  16. Thank you a lot for that hint. Works for me on Mavericks now 🙂

  17. Thank you so much for posting this. Saved me time at a client once again.

  18. As stated before: this trick works on Mavericks as well. Thanks a lot for posting it !

  19. Super. Vielen Dank für den guten Tipp!
    Greatfull” TX for the hint!

  20. Servus Florian,
    I have a Snow Leopard Power Book with fm Pro 10 and a Maverick iMac also with fm Pro 10. I want to remote open a fm solution from the PB hosted on the iMac, but the lokal host window stays empty. Is this generally possible with this versions?

    I also get a note from the iMac, that it’s not possible to share data as another user within the system is sharing them. However this notice comes also when not connected to a network. Any idea would help.

    Thanks in advance.

    • Hi Uller,

      This article should solve your first problem!
      However I’m not sure how to solve your second. Does this happen with all databases?

  21. I have filemaker 10 and 4 computers sharing when we updated to mavericks we can’t see the host do we need try the pen files from fm12 on all seats a

  22. I just read your fix for running FMP 9 on Mountain Lion with great interest. As FMP9 is largely intended for PPC, and Rosetta was eliminated after Snow Leopard, would the same certificate trick work with the even older FMP6 on Mountain Lion?

  23. […] This trick still works for Mavericks! Check it out here. […]

  24. Many thanks, Florian, your advice and trick worked for us too… Cheers from New Zealand!

  25. Thanks Florian! Couldn’t figure out why I couldn’t get Filemaker 9 to open the database on the company server–did a quick search and found your site. Now it works! Thanks again.

  26. Thank you so much for posting this. Saved a lot of headaches for the company I work for.

  27. Goodmorning Florian ,
    I have the same problem with Filemaher to share with another iMac.
    I cannot find the certificate files in the application bundle .Where do i have to look ?
    I hope you will help me.
    Greetings from Rob (Netherlands)

    • Hello Rob,

      Do the following:
      – Open a new Finder window
      – Press: [Shift] + [Command] + [G] => there should be a new window
      – enter the following
      /Applications/FileMak and press [Tab] (the path should expand)
      – then append
      FileMaker Pro.app/Contents/MacOS
      – the folder containing the two certificates should be open.

      • Hello Florian ,
        It works perfect now.Thank you very very much.
        When you were a woman I would kiss you
        A lot of greetings from Holland .
        Rob de Jong

  28. I have not been able to get FMP 10 to work since i upgraded from 10.6.8 to 10.8.3. The FMP startup screen will come up for a second or two but will then go away and nothing happens. I installed a trial copy of FMP 12, but as everyone else in the office is on FMP 10 in can’t modify files to ones that will be incompatible. I reinstalled my copy of FMP 10 from the disk and that didn’t help. Any ideas?

  29. You save me! Thank You!

  30. But it doesn´t work on 10.0.8 :-((
    When I try to start the program I get the following error message: “Some of the files needed are either damaged or not installed. Run the installer to fix the problem.”
    I ran the installer again, but there will be no difference.

    • Hi Kent,

      Several people already reported this problem. Maybe you could try to use an ESD installer or upgrade to at least FMP10. “Guy” reported that he had no problems after upgrading.

  31. Many, many thanks for your tip and files! They worked perfectly for me. I’d been frustrated trying to get Filemaker to work on my new Macbook and this solved the problem in seconds. Much appreciated!

  32. Many thanks for that very helpful post!
    Kind regards from Switzerland.

  33. It works fine, except with some web viewer sources (not with all of them); then, sometimes, but not always, it crashes again …
    THIS problem is not solved by the replacement of root.pem & server.pem

    But I can handle this.

    • I realized, that web viewer crashes happen only with websites where heavy javascript movements proceed.
      So I changed from web viewer representation in a FMP field to an ordinary URL-link for the page representation in the external browser.
      That eliminates the problem, of course.

  34. Finally got back to it. It works perfectly with your certificates. Thanks a million!

  35. I have an 20.5″ iMac with sytem 10.8.2, I have tried to install both Filemaker Pro 9.0v1 and Filemaker Pro Advanced 9.0v3 from the install discs which I have. When trying to run, both programs give me the same message. “Some of the files that are needed are either damaged or have not been installed. Please run the installer to correct this problem.” I am trying to upgrade from old G4 computers to iMacs without getting all new software. Can I install an older operating system to maintain my Filemaker programs? Was not expecting this. I have another Imac arriving this week. Had to put the g4 back into operation for Monday. Thanks – charlie

    • Hi Charlie,

      – This sounds very strange. I have successfully installed several Filemaker 9 versions (ranging from Filemaker 9.0 to 9.0v3) on Mac OS X 10.8.
      Can you obtain another installer? Maybe request it from Filemaker, Inc?

      – No, it is generally not possible to downgrade new Macs to older Mac OS versions as the old operating systems do not have drivers for the new hardware.
      However sometimes it’s possible to downgrade ONE system version. But that would not help either, as the same problems occur on Lion (10.7)

      I personally think it is rather impossible to upgrade from G4 computers to brand new one’s. They use a completely different type of processor (PPC vs. Intel) and run a (at least) three generations younger operation system.

      • thanks for your reply. I found my FileMaker Pro 10 install disk and installed it on the same computer. This version runs. The two local hosts show up under Hosts under Open Remote File. But no available files come up when I click on either one. Could this be a certificate issue as explained above. Or am I maybe doing something else wrong.

        • Hi Charlie,

          Yep! That sounds like the certificate issue. Just download my demo certificates and install them.
          I did the same a few days ago. It looks like FM10 is also affected by this “bug”.

          Cheers

          • I have a similar problem to the one Charlie seems to have gotten around: I have a full version FMP 9.0v3 install disc (not upgrade, though I do have FMP 7). Installing on an iMac w/Mountain Lion seems to complete ‘successfully’ until I actually try to open the application and get the “Some of the files that are needed are either damaged or have not been installed..” message. Sorry if I’m missing something you guys have already spelled out (I’d wager I am) but I’ve tried a few different things and I still can’t even get past being able to open the program. Thanks!

          • Hello Steve,

            That sounds very strange!
            Do you have the chance to obtain a different install disc? Maybe it’s broken?

            As I told Charlie already, I installed several FMP9 versions on ML without any problems. Therefore I think it could be related to the media.

          • I had the same problem with the “Some of the files that are needed are either damaged or have not been installed..” message. I also had to use FM10 instead of FM9. I wonder whether this is something to do with preferences lying around, outside of the program folder, which came from a previous 10.7 system… I deleted FM9 completely, and re-installed it, but that did not solve the problem.
            @Florian: How did you install FM9 on OS X 10.8? Was any part of the user account copied over from a previous system, or was everything installed from scratch on the new 10.8 system?
            With FM10, I just had the remote hosts problem – and found this post, which solved it perfectly: thanks again!

          • Hello,

            I always used the ESD version to install FMP9 on Mac OS 10.8. I used this method to get it running on both, migrated and clean installs. Therefore I think it might be related to the type of install image… But I’m not quite sure yet as I only have access to our ESD version.

            But I’m glad you fixed it!

    • There’s a possible fix here:

      http://help.filemaker.com/app/answers

      Except that it didn’t work for me (on OS X 10.9 using a brand new FMPv9 Advanced upgrade disk). Had several attempts and also tried after installing the 9.0v3 update but still get the same error message: “Some of the files that are needed are either damaged or have not been installed. Please run the installer to correct this problem.”

      I have FMPv10 running on a different Mac under 10.9 without any (so far) known problems, though.

  36. Florian,

    Thank you so much for the suggestions

    I have a slightly different problem. I have Filemaker Pro 9.0.3, totally uninstalled, then re-installed on a iMac running Mountain Lion.On opening the db file, I was getting the error message, “Filemaker cannot share files because another user is already sharing files using Filemaker Pro on this computer.”

    My package MacOS folder only had a root.pem, though I copied both of your files into it. That made the opening error go away, but Filemaker still quits when I try to start up Instant Web Publishing to test that I can see the db file from a browser.

    By the way, I have an old laptop running 10.6.8 (Snow Leopard), and it successfully starts up Instant Web Publishing.

    Any thoughts?

    • Hallo Eileen,

      Great that I could help 😉

      I have sent you an eMail regarding your other problem! We have to investigate that further.

  37. Now running Mac OS10.8.2 and have been using Filemaker Pro 9 on a Mac Powerbook. Any suggestions on how to install FMP 8.5 (plus v 9 upgrade) in Mountain Lion? According to blog above, it says “…as long as you upgrade from Snow Leopard”. I have tried to install FMP 8.5 on Mountain Lion and it of course gives me the Application icon with the slash thru it. Do I need to load Snow Leopard on my Macbook Pro in order
    to make this work?

    • Hello Patrick,

      I’m not quite sure if I got your point.
      Don’t you have an installer for FMP9?
      If you have, just install it and update it to the last version (v3) which you can obtain here: http://www.filemaker.com/support/downloads/downloads_prev_versions.html

      After that it should work quite well on Mountain Lion expect for server connection. To fix them follow the instructions above.

    • When the Filemaker Pro 9 upgrade installer is looking for qualifying products and doesn’t find one, it will bring up a window asking for you qualifying Filemaker key.

      Enter your 8.5 key here, and then Filemaker 9 will install. Then run the upgrade.

      I’m in the same scenario, so I’m hoping to see this work!

  38. Worked perfectly. You da man. Thank you.

  39. Thanks, this saved my day! Works perfectly!

  40. You saved my day! Only I could not find the files (server.pem and root.pem) necessary to replace with the search function until I learned about application bundles. So I clicked on the filmaker pro app in the Applications folder pushing the ctrl-key and selected Paketinhalt zeigen (in Englisch I asume show bundle?) Then the finder showed all the files inside the application bundle. Ther is a folder MacOS and there i replaced the files server.pem and root.pem and from then on I could access to the Filemaker server again.
    Thanks.

  41. I try it and it’s work fine on my old filemaker, thanks !

  42. You just saved me having to downgrade a computer I just gifted to my girlfriend. Thanks a million!!

  43. Amazing to have found you and your research. Well done! Really appreciate your efforts with this post. They just saved my client.

    Thank you.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)