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
  1. user connection licenses and reconnect

    Thanks Claus, that sounds like great advice. See you soon.
  2. 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?
  3. 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?
  4. 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.
  5. 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?
  6. 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.
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  11. 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.
  12. JDBC plug-in server side

  13. 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.
  14. JDBC plug-in server side

    Hi, I'm trying to activate the JDBC plug-in on a Filemaker 12 server, but the checkbox keeps deactivating after I perform a save. Is it server compatible? I'm using the ScriptMaster plug-in on the server side without any problems, it would be nice to have this one working as well.
  15. Maybe not a good idea to continue in this thrread, but it seems closely related. We are now april 2013, the Java JRE is 7, my server is MSSQL Server 12 and the driver is sqljdbc4.jar, which seems to be the recommended driver if you're on Java 7. See http://msdn.microsoft.com/en-us/library/ms378422.aspx My testing environment is the AdventureWorks2012 database. jdbcLoadDriver( "com.microsoft.sqlserver.jdbc.SQLServerDriver" ; AW::JDBCdriver ) returns 1 -- OK jdbcOpenDatabase( "jdbc:sqlserver://;databaseName=AdventureWorks2012" ; "sa" ; "test" ; True ) returns 1 -- OK as well, trying an invalid credential nicely returns the reason in jdbcLastError Let ( myResult = jdbcPerformQuery ( "SELECT * FROM dbo.AWBuildVersion" ; "timeout=" & 5*10^3 ) ; Case ( myResult = "ERROR" ; jdbcLastError ; myResult ) ) returns java.lang.NullPointerException It seems something is broken, since I'm supposed to get a driver error in case of impoper use and not a Java error, right? My client is a Mountain Lion Mac, and the driver is untested by MS on OSX, so it seems to be a bug in the driver. Trying the same thing from Windows 7 gives no problem. The jTDS JDBC Driver is not an option anymore, since it's not supporting Java 7 and returns an java.long.UnsupportedClassVersionError wich seems to clearly indicate a problem with the JRE. I really want to use JDBC with the MSSQL server, since I want to compare the performance of inserts using the DoSQL 2 plug-in with ESS vs the scripted import through the JDBC plug-in, which I hope will run well in FMSE ( regular imports from ESS and ODBC imports don't work server side ). I know it's not 360Works their task to provide us with functioning database drivers, they just make the plug-in. But I was hoping somebody would know which JDBC driver to use, or how to work around this problem. Is it possible e.g. to have Java 6 as well installed on the Mac and have the JDBC plug-in use it? Java really gives me major headaches these days. I guess I'll just do my testing from Windows then.

Important Information

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