Jump to content

Peter Wagemans

  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Peter Wagemans

  • Rank
    just passing through

Profile Information

  • Title
  • Gender
  • Location

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    High Windows

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Peter Wagemans

    oauth suddenly broken this morning

    I used Onyx to rebuild launchservices and caches. It was probably launchservices that was broken, since Onyx asked me where FileMaker was using the typical AppleScript dialog, it was in the list, and it was running, so the db was probably corrupted somehow. Problem solved.
  2. I try to login this morning with google authentication, and the login dialog does not go away. All the rest is standard: Safari comes to the foreground, asks if it can authenticate, I click the OK button. But nothing happens. I tried restarting FileMaker restarting Safari relogin to Google account another browser ( Vivaldi ) restarting the Mac throwing away com.filemaker.client.advanced12.plist I tried on my old MacBook ( I switched to a new one recently ) and there everything works correctly. Next thing I will try is to start throwing away caches, but I wonder: did anyone experience this already? How did you solve it? Please do not tell me I have to reinstall my Mac...:-)
  3. Peter Wagemans

    user connection licenses and reconnect

    Thanks Claus, that sounds like great advice. See you soon.
  4. Hi people, A customer is complaining about his FileMaker Pro 16 application acting up: when brought back from the background, the application requires the address of the server, even when the customer is actually logged in to the server. The customer took a screen shot of this, and the application window is clearly visible behind the nagging dialog. Clearly again a FileMaker problem, but I'm not going that way anymore, since I have to make a living as well. I was just wondering what could be done to avoid the disconnect, and on reconnect, how to help FileMaker a bit reconnecting. The first thing I was wondering about, was App Nap. There's a FileMaker help article here: using-filemaker-networking-on-mac-os-x-with-app-nap-enabled but the last edit is in 2015 and it covers only until 2013. The second google link FMP v14 and App Napp on the FileMaker Community web site seems to confirm that it is still an issue in v14. Why did FileMaker stop editing the article then? Apple has removed the check box option from the "Get Info" window of the application, one way of enabling/disabling it today is to use the excellent Onyx freeware application. But that switches App Nap system wide, not on application level. I'm wondering if it should be off or on, the customer uses the latest MacBook with Sierra. The second thing is the password linking mechanism that seems broken as well on reconnect. You open File A, file A needs file B and FileMaker internally passes the credentials used to open File A, to open File B. Unfortunately this doesn't seem to happen on reconnect, and FileMaker asks for the password of File B, with no option to save the password, although this option is set in the file preferences. I made the customer open File B directly, and save the password to the keychain. At least this *should* lessen the annoyances he is facing today. Does anybody have any insights to add here?
  5. Yesterday, I tried to move a script that creates a PDF ( and mails it ) to a server side script, as the "save records as PDF" script step is now supported in server side scripts. It did not work correctly, and generated an error 800 (file could not be created on disk) in the server log. Rather generic error. I changed the script to point to a blank layout instead. No more error. A nice blank PDF was created. I put a text box with "test" in it on the layout, Arial 12 point. -> error 800 I removed the text box and put a png graphic on the layout -> OK I put a text box in a font that I was sure of the server did not have -> OK! I tried this several times, 2 several fonts, and the results and errors were consistent. So if during the PDF creation, the server replaces the font reference by its own replacement font reference, it is able to save as PDF. If a reference lik "Arial" is used, it fails and the server reports the generic error that it can not create the file on disk (800). I'm using MacOS 10.12.4 as client and Window Server 2012R2 as the server. Maybe there is a cross platform issue here? As always, more testing is required. Can anyone confirm similar issues? Any workarounds that are known? Any thoughts and insights?
  6. Peter Wagemans

    Zulu configuration questions

    Bonjour Pierre, Interesting link! I'm going to take my time examining this some more, it seems like a good solution in a lot of situations, and not only for Zulu. Zulu 2 is definitely an improvement over v1, but I can't help it, it gives me the shivers. Zulu always gives me the feeling it can break any moment, and leave me stranded with problems I'm not qualified to handle.
  7. Hi forum, I am upgrading a customer with a FMS 13 setup with Zulu 1 on port 8080 to a FMS 15 with Zulu 2. It was already a problematic setup, as the FileMaker Server runs concurrently with an OSX Server. Hence the 8080 port to keep away from OSX Server hijacking port 80 all the time. The new FMS 15 is installed on port 85/2443 to keep away from the OSX Server web ports. Great. We wanted to keep Zulu on 8080 though, because then we wouldn't have to change the deployment on every machine. Installing Zulu 2, there is no option to choose the ports. It just configures to port 80. I would really like to have Zulu listen on port 8080 and talk to FMS over port 85. I tried modifying the context.xml, but that didn't do anything. For the moment, I have done a custom install using the old TomCat 7 instance listening on 8080, and a ProxyPass instruction on the OSX server, which is very ugly. But it works. What is the best way to do this?
  8. Peter Wagemans

    fmsadmin commands from administrator group

    Hi Steven, Thank you for your answer. If the CLI does not work remotely, why does it need credentials for certain operations? You can stop and restart server processes without any password, but you cannot list any open files without providing superadmin credentials. Maybe it is fmsadmin that has to enter the modern Server era. It is still a part of FileMaker Server and is not marked as an obsolete part. It should work correctly or at least consistently. Maybe you should have a look at the latest OSX and Windows Servers to see how much IT administation has to be done through the CLI...:-) things that we were able to do through a GUI in previous versions. I am not in favour of a CLI only adminstration either, but please do not judge so easily.
  9. Hi, I have a simple question about the fmsadmin command. Does it recognise the credentials of an administrator group? I could not find this in the documentation. It would be a real bummer if fmsadmin is ignoring those, and I have a first impression it is NOT working.
  10. Peter Wagemans

    SQL Create table in a FM file

    Yes, you can't ( no pun intended ). A calculation has a datatype as described above. But there is currently no way to create a calculation field through SQL.
  11. Let's face it. If you have a security consious customer and a large development with different security groups, external authentication, IOS, webdirect, XML and php access, encryption, SSL, firewall setup and whatever I'm forgetting here, you kinda lose track. FileMaker has no conventient way of immediately letting me assign security to an object ( a field, a layout or a script ) when I create it, so there's an additional danger of creating security holes if you are not submitting yourself to the regular ritual of reviewing security after a chunk of development. FileMaker security interface is not bad, but sometimes a bit awkward to use, leaving room for errors. One has to systematically review every security group for layout access, field access and script access, instead of doing this centered from the objects themselves. Having a pessimistic approach to security will not solve this, but results in bug reports of people ( if they care to do so ) not able to access newly made objects. Your security holes are plugged, but your development quality would suffer. It looks to me that regularly reviewing the security properties of a development is a required ritual, and some kind of database system is required that can update itself with a feed from the database and indicate newly created objects, so I can systematically assign the correct security features, and apply them in the development itself. If some security group's privileges change over time, I should be able to get a check list to see what I should change in the FileMaker security dialogs. This database would document how the security should be set in the database. I'm not looking to reinvent the wheel, so I DO NOT want to have an alternative security system in FileMaker. I just want a FileMaker database where I can sytematically document security on all levels. I'm wondering if anybody has ever made such a thing. I'm faced with developing it, and if there is a product available, I could probably cut development cost.
  12. Had the same issue recently, and don't know what caused it to function again. I fiddled here and there, would like to know the scientific approach.
  13. Peter Wagemans

    64bit for Server

    I'm getting curious as well. ScriptMaster works great on the server, but only for FMSE and IWP. If FileMaker continues their move to 64-bit on the server, soon my solutions will break.
  14. Peter Wagemans

    JDBC plug-in server side

  15. BTW, I just tested the imports with the 360Works JDBC plug-in. When I use the queries with the jdbcXmlImportUrl function, the imports are blazing fast, but there's a few problems I ran into. 1. I have to hardcode all the imports, but this can be overcome, it's just a hassle 2. The MSSQL JDBC driver is not working correctly on OSX, but this can be overcome, the imports have to run on the server side, and that's a windows machine 3. The JDBC plug-in does not activate on the server. This is a show stopper. I posted a question on the 360Works subforum, maybe they can fix it.

Important Information

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