Jump to content

Dr. Zathras

  • Posts

  • Joined

  • Last visited

About Dr. Zathras

  • Birthday 05/06/1962

Profile Information

  • Industry
  • Gender
  • Location
    Maryland, USA

FileMaker Experience

  • Skill Level
  • FM Application
    16 Client

Platform Environment

  • OS Platform
  • OS Version
    10.12 Sierra

Dr. Zathras's Achievements


Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Hello Wim, Thank you for your reply. Yes, I automatically received my new cert a week before the old one expires but my password log book is in my office and the University is in lock-down right now. Anybody found on campus without special permission would be in trouble and I doubt a request to get my serverKey.pem password would qualify. I therefore made a new serverKey.pem/CSR request to get a new certificate for which I had the necessary serverKey.pem password on hand. I did not try removing the existing cert with fmsadmin before importing the new one - thank you for the suggestion. I'll try it this evening after our users have logged off and I can work on the server. Will send an update one way or the other.
  2. It's time to renew our FMS 16 SSL certificate. I generated my certificate request, submitted the application to InCommon through our organization's portal and got back a certificate and intermediate certificate as normal. However, when I tried to import the certs and keyfile I got this error: Certificate could not be imported Config_DBServer_CertificateDialog_ErrorCOMODO RSA Organization Validation Secure Server CA I used a variant of our organization's name when I generated the cert request which I know is not an exact match to the name we used in our FMS license purchase. Does FMS perform an organization name match when importing an SSL certificate or is this a different error? Would much appreciate any insight. Thanks. Colin Hunter University of Maryland, Baltimore
  3. We're running FMS 16.0.4 on Windows Server 2012 R2 and Java 8 U181 and everything is fine. Unfortunately our IT security people want me to take Java to v8 U201 and I've been caught by Java updates breaking control of FMS in the past. Does anybody have any experience on using FMS 16.0.4 and Java v8 U201? Thanks. Colin Hunter
  4. We use WuFoo for data gathering over the web and then import the data on a nightly basis into a FMP database from an exported tab-delimited file. We've been doing this for a couple of years but WuFoo recently changed the way they encode attachments they no longer pull into the database. I had a simple script step using "Insert from URL" which read the URL from the exported WuFoo file and put the linked attachment into a container field but that no longer works and I can't figure out why. WuFoo tech support is unfamiliar with FileMaker so I'm hoping somebody here can help. An example URL is <https://umbforms.wufoo.com/cabinet/a060c9ed-3210-49e4-9882-55cebf863e8c>. If you run that from a web browser you get the downloaded file nttac_schedule.pdf but "Insert from URL" produces nothing in FM. Anybody have experience with pulling uploaded files from WuFoo knows why "Insert from URL" doesn't work with these URLs?
  5. FMS 11 is officially unsupported on OS X 10.9 but I've experienced no problems serving 40 databases to 25 FMP clients and 1 database over the web via custom web publishing from this Mac. Yes, at some point we will upgrade to a version of OS X which Apple is actively supporting and as you note we'll then need to convert our databases to FM 12 format to run on whichever version of FMS/FMP is compatible with the new OS. Not a trivial task and with everything stable and everybody happy (other than the security auditor) there have been no complaints. Nevertheless we need to be secure but we can't jump to OS X 10.12 on this server quite yet. I installed a new Apache/OpenSSL but was unable to persuade FMS 11 to see it so I'm going to follow ggt667's recommendation and go down the nginx path. His advice to leave what works running and have nginx serve as a reverse proxy to 10.0's Apache is an elegant solution but I'm somewhat out of my comfort zone with the necessary configuration steps. Hopefully I can figure it all out but may return for additional advice if I get stuck. In any case, many thanks for the replies and especially to ggt667 for suggesting a solution I would never have thought of myself. Colin
  6. I'm running FMS on OS X 10.9.5. It's serving forty databases, one of which is served to the web via custom web publishing. Everything is running smoothly but the campus security auditor is picking up a vulnerability with the old version of OpenSSL running on OS X 10.9.5's Apache. I addressed this on a different, non-FMS Mac by disabling Apple's bundled Apache and using MacPorts to install Apache2. How to do this on my FMS 11 Mac? Just getting MacPorts to install Apache2 is the first problem as port install apache2 fails with a conflicting ports message. I assume this is because the existing Apache is blocking installation of the new version but how to stop the existing one? I tried turning off web publishing in the FMS admin console but port install still fails with the familiar conflicting ports message. Even stopping the web server with Mark Banks' FMSControl didn't help. I therefore have a couple of questions: How do I stop the existing Apache so MacPorts will install Apache2? Once I have Apache2, how do I get FMS11 to use it instead of Apple's bundled Apache1? Thanks Colin
  7. That's perfect, and lightning fast to boot. If we ever meet I hope you'll allow me to buy you a beer or whatever liquid refreshment is your preference in thanks.
  8. I need to be able to standardize the contents of a field to just the characters after two letters, including the two letters. It's easier to give a few examples rather than describe the calculation: R01AR064810-01A1 -> AR064810-01A1 AR064810-01A1 -> AR064810-01A1 DA035813 -> DA035813 F32NS084680-01A1 -> NS084680-01A1 14SHSP603-01 -> SHSP603-01 T32AI007524 -> AI007524 In other words, the calculation needs to examine the text string, find the location of two letters next to each other (there will only be a single occurrence of two letters next to each other in the string), then delete everything to the left of the two letters. Is such a calculation possible in FMP 12 or 13? Thanks
  9. Thank you for your reply but I couldn't find the "Go to Related Record" command - is that in a FMP version after v13? In any case I did a work-around by creating another table with just one field and imported the calculated match field from Table B into the field in the new Table C. Since this is now a regular field it can be used to relate to the match field in Table A and I'm good to go. Importing 70,000 records from Table B takes a few minutes, even though it's just one field but it's definitely something I can live with. I now have another question regarding my calculation of the match field but it deserves a new topic. Again, thank you for your help.
  10. Thank you for your reply but when I define a relation between the two tables using the unique match field and display the match field on Table A it's empty for every record. In fact I don't get data in any related field from Table B displayed in Table A, even though there are matching fields. I now realize I missed an important fact: the Table A unique field calculation is stored but Table B is sourced via an ODBC link to an Oracle database so its unique field calculation is not stored and the relationship does not work. Is there a way to create a stored snapshot version of the unique match field in Table B or will I need a different approach?
  11. I have two tables - one is an import from an external source which contains the master data set and the other table contains hand-entered data overlapping the data in the first table. Sometimes people make mistakes entering data from the master table and sometimes they miss a record entirely. I have a calculated field in each table which is unique to each record, but which matches across the two tables. Is there a way to compare the records in Table B with the Records in Table A, and using the unique field determine which records are in Table A but are missing from Table B? We're mostly using FMP 12 but can go to 13 if necessary. Any help or general pointers how to approach this would be most welcome. Thanks
  12. Anybody find a fix for this problem? We have the exact same issue (FMP 12.0v5) with the background turning red in Preview mode in a database which suddenly started exhibiting the issue after months of trouble-free operation. Thanks, Colin
  13. We have a dual-server FMS 13 setup with FMS's web portion running on Mac OS X 10.8.5. We have a database using multiple SuperContainer web viewer fields accessed over FMS's WebDirect service. The WebDirect page uses SSL with a Geotrust primary + intermediate certificate setup at https://site-address/fmi/webd# and SuperContainer files are accessed over http://site-address:8020/. This all works very well, but with the major issue that the WebDirect page is secure but the SuperContainer fields are not. Web browsers throw up a warning that the page contains mixed secure and non-secure content and our users have to authorize the browser to display all content otherwise they don't get to see the SuperContainer fields. We need to simplify access for our users by making the entire page SSL-encrypted, so how do we get SuperContainer Server to use our Geotrust certificates and run everything over https? Thanks
  14. My wife is coming with me to the upcoming DevCon and wants to join in the fun for the Thursday evening attendee party. Does anybody plan to attend the conference but leave before the party and has an unwanted ticket? Thanks. Colin Hunter
  15. We're a university administration group currently running FMS 11 with FMP 11 desktop clients for our office users and a mixture of custom and IWP for people coming in over the campus network. It's time to upgrade to FMP 13 and we'd like to keep the local FMP 13 clients authenticating via the server's (running Windows Server 2012) Users/Groups but authenticate our web users via the campus' Shibboleth service. Has anybody any experience with Shibboleth and FMS 13, and can it be run alongside local Users/Groups authentication? Any information would be really appreciated. Thanks. Colin Hunter
  • Create New...

Important Information

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