Jump to content

Dr. Zathras

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Dr. Zathras

  • Rank
  • 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
  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 sugg
  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 purc
  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 i
  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 ca
  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
  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 lette
  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 matc
  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 mat
  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 u
  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
  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. C
  • Create New...

Important Information

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