Wim Decorte

  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by Wim Decorte

  1. this maybe: https://deskspace.com/ FM Studio never really produced very clean code, that is something to consider with any 'translation' layer. There is something to be said for writing the code from the ground up, using the native tools for the platform you want to go with (ASP.NET, PHP, Ruby,...)
  2. In DNS management. You keep mentioning "www." Your cert will be for "something.com" I'm assuming without the 'www', is that correct? Is it a wildcard cert? Do you want people to have a valid encrypted connection to the website www.something.com? Or are we talking about FMP connections inside the network to an FMS on a machine named someserver.something.com?
  3. That's where your process fails. You don't place the certificate into the 'correct' folder. You use the FMS admin console or the fmsadmin command line to import the certificate. That process takes are of putting the cert where it belongs. See instructions here: http://help.filemaker.com/app/answers/detail/a_id/14174 This sounds like you haven't configured the DNS properly. That's not strictly speaking part of the SSL config process which is why you won't find any instructions on it by searching for SSL help. There is also not a simple answer for this because it depends on your DNS management. If you have no idea how that works then your best bet is to find someone locally with DNS experience.
  4. Same answer. From his information I can't tell whether he is upgrading one copy or a whole set. Regardless; OP shows the same confusion as many others thinking that the new FLT licensing is the only available option, so broadening the conversation a bit is a good thing.
  5. No, you pointed out how to buy individual licenses. For more than one license but in the old concurrency model this is the link:
  6. Even for non-individual licenses you can still buy what is referred to as 'legacy licensing' based on concurrency. The new FLT licensing model is not mandatory.
  7. If your router allows, forward based on DNS names then you can just update your DNS and have all the rest fall into place. Otherwise; yes: you would have to update the port forwarding.
  8. Passing variables is something you do between scripts and has nothing to do with TOs so there is some really fundamental confusion in your mind that needs to be cleared up, otherwise you'll come up with answers that don't fit the question
  9. You can save yourself the pause by looping and waiting until the closing HTML tag appears, that way you'll know the page has loaded and you don't need to depend on an arbitrary pause.
  10. No, it is not a FM script command, it is an OS command. So you'd use it in a batch file or a VBscript or a PowerShell scriptl whatever IT is most comfortable with. In its simplest form (a batch or cmd file) it would look something like this: fmsadmin pause -y -u soliant -p testing vssadmin create shadow /For=D: fmsadmin resume -y -u soliant -p testing soliant / testing would be the FMS admin console credentials, the /For=D: specifies that the D drive should be snapshot.
  11. By design. It treats the "-" as a dash and will increment in the number that comes after.
  12. All or nothing. FMS is not VSS-aware so it is not safe to use unless the FM files are first stopped or paused; pausing can be done without disconnecting the clients, through the command line (fmsadmin pause) so it can certainly be automated. AV requirements can be met through scheduled scans that exclude the live files and by picking a schedule time that does not interfere with FMS own backups. The one thing that can not be on is 'on access' scanning. 3rd party backup that works at the file level can be made safe that way... provided that it does not run when FMS is doing its own backup. Mind the progressive backups if you are using those; you can't control when those run. You can control the interval but they will start when the db engine starts so the exact runtimes are unpredictable from one server reboot to the next.
  13. With "hosted' they probably mean that it is a virtual machine, not a physical server. Just ask; there is no shame in asking. Certainly do ask what they mean by 'hosted'. Is it a physical or virtual machine in the cloud? (Amazon AWS, Microsoft Azure,...?). If it is a cloud machine then all your client connections will become WAN instead of LAN and that could very well impact the user's experience. If you are worried about performance then make sure you have a performance baseline. Turn on the FMS stats.log on the 'logging' tab in the FMS admin console. It is off by default and tracks performance data across the 4 traditional bottlenecks (disk i/o, processor, network throughput and memory). Safe that file when you cut over to Windows. That file will give you something measurable to compare against when you do the same monitoring on the new server. Numbers don't lie. One thing that I would insist on: since you now have an 8-core machine, I would ask for the same on the new machine. That is a more important fight than the memory. The 16GB of RAM is more than enough. Don't kid yourself on the 'optimized for db performance'. The Mac Pro is no no way optimized as a database server. It's beefed up workstation with a waste of GPU power for its role as a server. Don't use this as an argument with IT, you'll lose all credit. If this is a virtual machine changes are that they are using a SAN as the disk sub-system and that it is driven off of SSDs anyway. But ask. Fitch's point about the backups is absolutely vital. FMS is not SQL Server and has different requirements for how backups are done. No 3rd party backup or Anit-virus shoud touch the live files or the backups while they are in progress. These days, Windows backups are usually done through the Windows Volume Snapshot Service and if it is a virtual machine then often through a snapshot of the whole virtual instance itself. When you restore from such a snapshot at a minimum: - the FM files will come back as 'improperly closed' because FMS did not have a chance to put the files in the proper state before the external backup was done - at worst the FM files will not open again because they will be damaged The Windows tools can be made safe by integrating them with the FMS admin command line to first pause the files and resume them afterwards. Not too difficult but requires some work with the IT department. I mentioned anit-virus: many IT departments will configure AV and insist that 'on-access' scanning is on. That can lead to all sorts of problem as the AV tries to scan the files every time FMS writes to them. That should be turned off. There is a FM knowledge base article that you can use here to give to IT.
  14. Reconsider that. There is a huge upshot in keeping field names 'standards-safe and use only a-z, A-Z, 0-9 and the underscore. The 'dot' is the delimiter between a table name and a field name in SQL for instance.
  15. You can still buy a license of FM without a subscription... But if you make a living out of it or your business gets good value from it then going with a maintenance renewal makes a lot of sense.
  16. You've mentioned that twice but it is not clear to me what you mean. Is your goal to have just one TO per base table? And if so, why? What specific problem would that solve for you? Or is an abstract notion? Abstract notions is what gets a lot of us in trouble, premature optimization, unneeded modularity,... that kind of thing.
  17. As long as you think that you will be no closer to solving this. FMS does not change the permissions on a file or change anything at all in the file. It just does not. So something else changed: - either you or someone else with full access changed the security settings of the file - either you or someone else with FMS admin console access changed the setting to allow or disallow files with no pw to be hosted - or the deployment is flawed, doesn't follow best practices and the file got damaged in the process
  18. On windows it would be a 1-line CMD file: fmsadmin list schedules -s -u ABCD -p 1234 >"c:\program files\filemaker\filemaker server\data\documents\schedules.txt" save that CMD file in the FMS scripts folder and them make a new FMS script sequence schedule that first runs the CMD file and then the import script.
  19. Virtually impossible to troubleshoot remotely if you say that all of those things are configured. Is port 80/443 also open and forwarded? If so you could test that remotely against the sample file to see if you can even get to the server.
  20. There is no change in how you access your FMS15 from the outside, it is still the same way as it was with FMS 5.5: - no firewall on Windows blocking port 5003 - no firewall on the router blocking port 5003 - port forwarding on the router on port 5003, targeting the internal static LAN IP address or DNS name of your FMS box - remote client using the WAN IP address of the router, or some DNS name that is properly mapped. You don't need port 16000 unless you also want remote access to the admin console.
  21. The other thing you can add to your sequence is run the 'fmsadmin list schedules -s' command to get a good overview of what schedules are set up, which was are enabled and their last run status.
  22. You have to work with what the 'catch' block gives back, my guess is that the 'FMProDoc' variable remains 'null'. Try another approach: after opening the file (does it open at all and just the script does not run?) then do a foreach loop through the documents, check the FullName against the file you want to target and when you find it then do the DoScript.
  23. the DoFMScript is called on object FMProDoc, but it was never set to anything. Try this instead of the line where you just open the file: FMProDoc = FMProDocs.Open("C:\\Users\\oscar\\Desktop\\helloworld.fmp12", "Admin", "");
  24. Something in your code is calling on FMP 5 which is why you have it in your task manager. Probably a reference to the old activeX library or to an .fp7 file. Does your code fall through to the catch block? And if so: what is the exception? As to the bug: not sure; I do most of my integrations directly against FMS these days or write a small ASP.NET web service to act as the intermediary.
  25. Can you post a screenshot?