Search the Community

Showing results for tags 'fms15'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Categories

  • Journal

Community Forums

  • Community Resources
    • FileMaker Pro 16 Discussions
    • FileMaker Pro 15 Discussions
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Server 15
    • FileMaker Custom SSL Certificates
    • External Server Authentication
    • Stand by Server Deployment
    • Legacy FileMaker Server Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
    • FileMaker Discussions
    • Brain Food
  • FileMaker and the Internet
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker

Categories

  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 27 results

  1. Any suggestions/limitations to hosting FMS 15 in a virtualized environment? Currently, we host a 30-40 user, 10 gig FM db on a physical server, however, p to v is being suggested by others in our organization (They're also inclined to config pooled versus static resource settings which would seem to affect the manner FMS functions) Elaborating on specific VM configurations in a Windows environment would be greatly appreciated!
  2. I'm looking for both guidance and software to assist in FileMaker Change Control. With over a 100 deployed solutions across multiple servers the process change management from dev > test > production is very labor intensive. BaseElements helps a lot but it is only one part of the puzzle. Porting the data from production > test across these solutions and then doing UAT and QA is again, labor intensive. How are others handling this? Is there some software or process documents I'm missing? I'd welcome any input to this topic. Mike
  3. I'm wrapping my head around the Standby Server feature, and there's only one aspect that I can't figure out. I use Webdirect, so I'm forwarding port 80 to the internal ip address assigned to my primary server. If that were to go down, my standby server would take over - but it's assigned a different ip address - so my router's port forwarding rules will still be pointing to the ip address of the primary server. Is this accurate? If so, is there a way around this?
  4. Hi, I am relatively new to FileMaker. I am a PHP developer currently working on a project that involves the FMS custom web publishing PHP API. I was able to successfully connect using the API, but the connection is no longer working. The error message says only "Unable to open file". My research says that this could be due to the database file not being open, or to a permissions issue. I can see in the FMS admin console that the database file is open, with "normal" status. The FMWEBDIRECT and PHP columns both have full circles, indicating that the database should be accessible through the PHP API. Both the web server and the web publishing engine are on, with green checks, and PHP is activated. I am using the same username and password that worked previously. I checked again in the database security settings and confirmed that the username and password are still correct and that the user account has the "fmphp" privelege. What else should I look for? In the web publishing error log I see entries that say: 127.0.0.1:63876 [USERNAME] - 802 563 "fmi/sml/fmresultset.xml?-db=[DB]&-lay=[LAYOUT]&-findany" Does the PHP API use the XML API? Also, here is the full var_dump() of the error object: object(FileMaker_Error)#6 (9) { ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["error_message_prefix"]=> string(0) "" ["mode"]=> int(1) ["level"]=> int(1024) ["code"]=> string(3) "802" ["message"]=> NULL ["userinfo"]=> NULL ["backtrace"]=> array(7) { [0]=> array(6) { ["file"]=> string(90) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/PEAR.php" ["line"]=> int(945) ["function"]=> string(11) "__construct" ["class"]=> string(10) "PEAR_Error" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> NULL [1]=> string(3) "802" [2]=> NULL [3]=> NULL [4]=> NULL } } [1]=> array(7) { ["file"]=> string(101) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Error.php" ["line"]=> int(52) ["function"]=> string(10) "PEAR_Error" ["class"]=> string(10) "PEAR_Error" ["object"]=> *RECURSION* ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> NULL [1]=> string(3) "802" } } [2]=> array(7) { ["file"]=> string(129) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/Parser/FMResultSet.php" ["line"]=> int(48) ["function"]=> string(15) "FileMaker_Error" ["class"]=> string(15) "FileMaker_Error" ["object"]=> *RECURSION* ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } [1]=> NULL [2]=> string(3) "802" } } [3]=> array(7) { ["file"]=> string(122) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/CommandImpl.php" ["line"]=> int(84) ["function"]=> string(5) "parse" ["class"]=> string(28) "FileMaker_Parser_FMResultSet" ["object"]=> object(FileMaker_Parser_FMResultSet)#5 (17) { ["Vcb5e100e"]=> string(3) "802" ["Vf5bf48aa"]=> array(3) { ["build"]=> string(10) "10/27/2016" ["name"]=> string(31) "FileMaker Web Publishing Engine" ["version"]=> string(10) "15.0.3.308" } ["V1ea7e575"]=> array(7) { ["database"]=> string(0) "" ["date-format"]=> string(0) "" ["layout"]=> string(0) "" ["table"]=> string(0) "" ["time-format"]=> string(0) "" ["timestamp-format"]=> string(0) "" ["total-count"]=> string(1) "0" } ["V9f81f3c0"]=> array(0) { } ["Vaae0d98d"]=> array(2) { ["count"]=> string(1) "0" ["fetch-size"]=> string(1) "0" } ["Vae581270"]=> array(0) { } ["V6e52c40b"]=> array(0) { } ["Ve13f1c92"]=> NULL ["V43432a31"]=> NULL ["V51bc3e3b"]=> NULL ["V26005321"]=> NULL ["V6468d939"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["V5431b8d4"]=> resource(28) of type (Unknown) ["V6de51026"]=> bool(false) ["_result"]=> NULL ["_layout"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(563) "" } } [4]=> array(7) { ["file"]=> string(130) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/Command/FindAnyImpl.php" ["line"]=> int(17) ["function"]=> string(10) "_getResult" ["class"]=> string(32) "FileMaker_Command_Implementation" ["object"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(563) "" } } [5]=> array(7) { ["file"]=> string(103) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Command.php" ["line"]=> int(137) ["function"]=> string(7) "execute" ["class"]=> string(40) "FileMaker_Command_FindAny_Implementation" ["object"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [6]=> array(7) { ["file"]=> string(64) "/Library/FileMaker Server/HTTPServer/htdocs/newsletter/index.php" ["line"]=> int(32) ["function"]=> string(7) "execute" ["class"]=> string(17) "FileMaker_Command" ["object"]=> object(FileMaker_Command_FindAny)#3 (1) { ["_impl"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } } ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["callback"]=> NULL } Any help would be much appreciated!
  5. For security reasons, my institution is requiring me to migrate my FMS15 solution, currently residing on a MacPro in my office, to the IT data center. Since they do not run MacOS, this includes a migration to a hosted windows server running FMS advanced. I no nothing about windows (eg: what is a hosted win server vs simple win server ???) , so I will be totally dependent on the IT staff knowing what they are doing (and they barely know FM, I narrowly escaped having them try to recreate the solution in Access for $$$$$ ...): Current Environment · FileMaker Server Advanced running on local Mac OS12.12 system. · RAID-0, Solid State Drives · 8-Core CPU · 32gb RAM · FileMaker DB is 100gb with additional storage required for temporary files and local DB backups Proposed Environment · Hosted Windows Server running FileMaker Server Advanced · 4-CPU · 16gb RAM · 1tb Storage I have many questions/concerns, but would appreciate feedback on 2 issues: 1. Backups: My understanding is that FM is adamant that no backup system can touch a “live” database file, causing potential corruption. FMS has its own internal backup mechanism, and you point it to some external drive / directory etc, where it creates backups that can then be copied/archived by a system process or third party backup system. The IT manager I am discussing this with replied the following: "Backups should not be an issue either. We've been using this model on our SQL servers and have not experienced a single issue over many years. They do their backups and we do our own as well." I don't know what the windows server system is doing for backups, but are the FM warnings about letting other backup systems touch live FM files only for 3rd party SW, and system processes are OK? Any specifics I should communicate to the IT guys? Again, I know nothing about how win or win/server does this. 2. Performance: I am obviously worried performance will take a hit, if only from networking. I am hosting a dozen related files ranging from 1-50 GB, typically 5-10 concurrent local and remote users. The proposed environment seems less optimized for DB performance - what are the key parameters I should negotiate on? My current 32gb RAM may well be more than what is needed (I don't use any web or go functions, just straight FM clients), but can I determine from the admin console logs/stats how much is really needed? My request for SSDs was immediately shot down, how much can I get from various RAID configs they may or may not agree to? Thanks for any feedback - I am so not looking forward to this...
  6. Hello, I have a filemaker server 15 advanced running on windows server 2008r2 in a local LAN network. I want to connect to server with client (filemaker 15 pro). Everything work well in the local LAN but I am unable to access to the database outside the office using internet connection and IP. I just have made the port forwarding setup (5003 and 16000) but no results. Maybe the Windows server need to be opened in some service or funcionality? Before of the server I had a simepl windows XP pc running filemaker server 5.5 and it work well also outside the lan. Thank you
  7. Quick question. I know there is a way to create a standby server for filemaker, but what happens if the worker machine fails? Is there a backup option for that? I've been hunting around and haven't found anything to address this. Does the master machine take over for the worker? Any insight? (Thanks in advance)
  8. We have had Filemaker 15 Server up and running of while but when we originally installed it was installed on port 444 (because of our router configuration). We wanted to reinstall using port 443. So I uninstalled per instructions, uninstalling, bonjour, microsoft items, java etc... Rebooted our Windows Server 2012. Ran installer and got the error message the port 443 was not open. Rand netstat -a -o from command prompt, it said Filemaker 14/ on port 443 was listening (PID 768 and 4), So used skill to kill the PID. Rebooted, still unable to install Filemaker 15, port not open. Then went into diagnostic mode, started the installer service. Installed successfully but then could not launch Filemaker server, could not even change firewall settings. So now we are restoring the server to the image backup. Would like to uninstall and reinstall again tomorrow using port 443, any hints or tips on what to check before an uninstall and reinstall. Any help would be greatly appreciated. I would call FM tech support but they are not available on the weekends.
  9. Good afternoon everyone, Some BackStory: When FMCloud was first announced, I was ecstatic; I'm all for moving towards cloud technology for my agency. I was nearly there...about to pull the trigger and start a migration scheme from my current setup into the FMCloud, but then the one big caveat was found.. "Supports custom app authentication via FileMaker user accounts only" AKA no External Authentication. But that is fine, I understand it was released for small businesses which need the scalability of AWS, but this DOES NOT work for my agency. I spent half a year moving away from filemaker user accounts, I can't go back; plus they have a Single Sign-on initiative that I'm trying to meet. But I still need to get off of my old physical towers.So my next idea is that I want to spin up an EC2 in AWS and put filemaker server on it as an alternative, but I can't find any verbiage that details how that works(or if it works) in the way that I would like. Namely, I need my AWS server to talk to Active Directory, preferably by ADFS or SAML (lesser so). So the question: Can I setup external Authentication to an Active Directory from a server being hosted on AWS that is housing FileMaker Server 15? If so, What should I make note of before diving into this? Thanks for any help and clarification someone can provide. ~Levi
  10. Hello, Stange situation here. After reinstalling FMS15 to resolve an issue, one of my FMPA clients on just one of my computers displays "connection failed" when trying connect to the available databases on the server when trying to connect with the local ip adresse. All while several other computers have no problem doing the same. The FMPA client that has the issue has no problem connect to available databases via an external ip address. I have never seen this before and can't find any meaningful information on this by googling. Would anyone have any idea what's going wrong here? The error appears to be (51) on FMS.
  11. I'm reaching the 125 database limit of filemaker server, so I need to deploy a second and was hoping I can do that on the same network and just change the default ports. But I must be missing something because I'm not able to bring up the admin console after installation. I think it has to do with a conflict on port 5003, but I'm not sure. (FYI the databases don't have to talk to each other - they are all silo'd) My question is this - is there a way to run more than one filmmaker server deployment on the same network? If not, my only thought would be to create a virtual network with my router, but I don't want to go through the trouble if I don't have to. Any advice? Thanks in advance!
  12. Hello from the UK Does anyone have a good solution for automatically copying the FileMaker backup files to something like Google Drive on Mac OS X? FMS doesn't let you set the local Google Drive folder as the backup location as it doesn't have the correct permissions (I assume). I have purchased CarbonCopyCloner (shareware) for some customers which will do it, but does anyone have a great solution to copy those files using built-in or free tools? I suspect that there is a UNIX command that will do it, but I'm not very well versed in that. Any clues would be good! Merry Christmas everyone.
  13. Hi, I just installed FMS 15 and have found that a couple of my databases won't open in FMS15 once they have been uploaded. I have tried recovering them before uploading but all to no avail. Would anyone have any ideas what might be going wrong here?
  14. I'm unsure where exactly to post this so I'll try it here. If there's a better place please move this but it seems to be the correct category. I'm looking to setup hosting for a 15 member team who will be primarily accessing the database via WebDirect. However, I'd like to connect the solution to MySQL and open up parts of the database to 50 other users via Custom Web Publishing (php). I'd appreciate any feedback on hosting companies who can handle some or all of the following: licensing, WebDirect, Custom Web Publishing and ODBC. I looked into FileMaker Cloud but it doesn't seem to be able to handle CWP. Someone mentioned today that you can go with AWS apart from Cloud and I'd love to hear feedback on that as well. Anything you guys can share on good and less than desirable solutions would be most appreciated. Feel free to recommend your own company or PM me and tell me why I'll like working with you. Thanks!
  15. Hi all, trying to schedule my first system server script and I am getting an error: Dec 2, 2016 9:35:00 AM Server Events Error 692 Schedule "fms backup to net vol" aborted; system script "fms_BackupScript.sh" returned non-zero status 12. Running mac OS Sierra FMS is running with its default user account (fmserver [I guess]) The shell script file works fine when I double click it and has all execute privileges: -rwxr-xr-x@ 2 admin staff 149 Dec 2 09:12 fms_BackupScript.sh Interesting, when I schedule this script with the admin username and password option, then I get an «Invalid account» error: Dec 2, 2016 9:54:00 AM Server Events Error 732 Schedule "fms backup to net vol" aborted; invalid account name or password. I'm puzzled. Where's the problem? Thanks for any help! Gary
  16. Hello All, Recently, my company installed FM server 15 after much begging. The database that my group uses (built in FM12)is hosted on a laptop (running FM12) and I'd like to upload it to the server using FM . I cannot figure out how do do it; there is no "Upload to Server" option, and I'd rather not do it manually. If anyone has some guidance, I'd really appreciate it...
  17. Hi everybody, Is there someone that have a licence to sell for a filemaker server 15? U can MP Thanks
  18. Hello folks Today I am tasked with showing performance metrics: We need to see how FileMaker Server responds to 300 users performing intensive tasks simultaneously. For example, finds, sorts, new record creation and so on. I have a test bed of scripts which loop and perform such tests, such as creating lots of records and populating them with dummy data, and so on. Now I just need to figure out a way to have 300 FileMaker clients perform these tests simultaneously so I can monitor server metrics. I do not have access to 300 real machines. The only case I can come up with is to use multiple Virtual Machines. Within each VM, runs a copy of FM14, FM14 Advanced, FM15, and FM15 Advanced. That is four quasi realish"clients" I can put to work running my intensive scripts simultaneously. And, ram permitting, I can have about ten such VMs, resulting in a total of 40 quasi-real client instances. Granted, this skews network latency, this is a known downside to this approach. But I need 300 anyway, not just 40, and I am out of hardware for testing. I am limited to a single Mac Pro with 128GB ram. Is there a different way to simulate 300 users performing my intensive scripts simultaneously? Do I ultimately need more hardware to create the simulation?
  19. I have a system being hosted using FMS14. I also have a duplicate database hosted for testing/exporting using FMS15. PSOS is much slower in my hands with FMS15. Both servers are physical boxes, with similar (maybe identical) specs (Cores, RAM HD Space, HD Space available) I also have a Server Side script that creates a found set, exports data to excel and emails it to a user. (This is based on https://www.skeletonkey.com/restoring-filemaker-clients-found-set-within-server-side-script/). The exports have a couple of related fields, but no unstirred calculations. Using FMS14 this has been working just fine. Using FMS15 it has been significantly slower. As a test, I exported 13,000 records from both FMS14 and FMS15. Using FMS14, it takes about 10 Seconds to recreate the found set, then 70 Seconds to create the export. Using FMS15, it takes about 20 Seconds to recreate the (same) found set, then 175 Seconds to export the data. In another series of tests, this time exporting 30,000 records (more realistic in my scenario) I found; Using FMS14, it takes about 25 Seconds to recreate the found set, then 168 Seconds to create the export. (2.5x longer to find/2x longer to export 3x records) Using FMS15, it takes about 90 Seconds to recreate the (same) found set, then 825 Seconds to export the data. 9x longer to find/11x longer to export 3x records) In the last series of tests, this time exporting 50,000 records I found; Using FMS14, it takes about 59 Seconds to recreate the found set, then 262 Seconds to create the export. (6x longer to find/4x longer to export 5x records) Using FMS15, it takes about 160 Seconds to recreate the (same) found set, then 1700 Seconds to export the data.(16x to find/24x to export 5x records) Any ideas? Anyone see similar results with PSOS on FMS15? Again, the machines are identical, the databases are identical and the scripts are identical. the only difference is FMS14 vs. FMS15. I am also letting another user pull data using ODBC. That has also gotten extremely slow using FMS15, but that is a discussion for another thread. I am not using WebD on this server. In general the FMS15 database performs find using FMP Clients. But the FMS15 functions are not very impressive. I am petrified to move my production database to FMS15, and even considering moving the test server back to FMS14. Help! TIA Jerry
  20. I keep a backup copy of my hosted solution (under OS X) in the default FMS Data/Backup folder. The backup is scheduled twice a day (noon and night) and I keep 5 versions of each copy. The solution includes nearly 100.000 pdf files in managed container fields (RC_Data_FMS folder), in total only these files take 10GB of disk space. I would like to follow the 3-2-1 backup rule so I should be storing 2 more copies of the solution, I would use a Synology NAS in the LAN, so my plan is: Keep the 2 daily copies stored in the Data/Backup folder, in the server disk (Done!) Have 2 more daily copies of the database stored in the NAS (pending) Have a progressive backup executed by night (when no users are connected), saved in a NAS folder and have that folder backed up in Dropbox or Amazon (pending) There are two issues to take in account: All the backups must run unattended, I mean without the need to log into the server. The server machine should be ready for backup just after start up. I have a limited knowledge of LAN administration and command line. So far I tried to: Sync the backup folder with the NAS using GoodSync: the software is not reliable, sometimes simply doesn't sync and their customer support is useless. I've heard of rsync a system utility that should be more reliable but I'm I don't know how to use it. Sync the NAS copy with Dropbox: Synology Cloud Sync utility is limited by the hardware, in my case 15.000 files is the maximum. To have 200.000 files syncing every day seems unrealistic Have a FMS progressive backup on a NAS shared folder: so far I haven't been able to give FMS access to the remote folder, I can't validate the filemac:/volume/folder/ path Following the steps in this article (http://www.soliantconsulting.com/blog/2012/11/filemaker-backups-network-share), set up a shell script that sends a backup to the NAS. The script -based in FMS command line- is executed by the default user and goes simply: fmsadmin BACKUP -d filemac:/volume/folder/ It doesn't work, I get "Error 732 Invalid account name or password" and I am not sure if it's the script or simply the access to the remote folder (the path is invalid for progressive backup). My questions: How can I make fmserver own a remote folder in the Synology NAS? Do I need to create the users in the NAS? how can I create a fmserver user without knowing the user password? The shell script above, for backing up to the NAS is it correct? In addition to the local backup, do you think a progressive backup in two media (the NAS and the cloud) is safe enough in case of disaster? In sum, can you help me set up a rock solid backup system for my solution?
  21. FMS15/FMP15 {{FilePath}} on my hosted files usually returns the expected fmnet:/<server.ip.address>/<myfile> Can anyone tell me why one server returns fmnet:/<server.ip.address> <server.ip.address> <server.ip.address>/<myfile> Yes, ip address three times with a return between? {{HostIPAddress}} just returns the one IP as expected
  22. I just installed FMS 15 on a Windows 2008 R2 machine - everything checked out and the install went smooth. I then purchased a Wildcard SSL certificate from Go Daddy. I generated a CSR from the FMS Admin Console and pasted the encrypted text into Go Daddy's text box to setup my SSL. Here is the problem: The CSR generated from the FMS Console set the domain as mydomain.com instead of fmpserver.mydomain.com Where does Filemaker Server Console get the information used to generate the CSR? How do I get FMS to generate a CSR with the correct sub-domain? It is a FQDN (sub) that resolves directly to the Public IP on my server. Thanks in advance for your help! Jim.
  23. I've a hosted database with a container field that contains pdf stored externally and open (not encrypted). The database has thousands of pdfs that were imported from a disk by a record-by-record script, those pdf can be seen from any fm client without problem. Now I've uploaded a pdf from a OS X clients, but the file doesn't show in Windows machines, instead I get a "file not found" message, but the files are there because they can be seen from the OS X client. I remark that the problem is only with the files that were uploaded manually using the command 'Insert PDF' from the container field contextual menu from an OS X client, all the other pdfs (imported through a script) can be seen from any client. I've seen a couple of posts about it in the forum but none of them seems to 'hit the nail'. Thanks,
  24. I think I may be trying to do something that is not possible. All I am doing is trying to do a simple, short-term test. I am updating a 20 yo solution that ran on FMS5 connected directly thru a fixed IP address. I have a dedicated Mac as my FMS15 Host. I am using FMP15 Client on different Mac. Both are behind my router. Local access to hosted files is 100%. I want to test host access via internet. I set my router IP address to fixed. My host Mac IP is fixed. I enter the router IP address in the Launch Center, I get nothing most of the time. Once or twice after an obscurely long wait I have gotten a dialog where I can enter the address again and account name and password. Still no connection success. Am I tilting at windmills here, or do I need to move the host from behind the router, or do something else that is not obvious to me? Thanks.
  25. One of our clients has an internal FM server [FMS1] running a solution that we built for them and we have a cloud based FM Server [FMS2] running another solution for them with a smaller dataset that they publish to their own clients Data is periodically pushed to and pulled from FMS2 using server schedules that run on FMS1 and trigger very simple scripts to manage the movement of data This was all running without issue whilst both servers were FMS v14 Last week the client upgraded FMS1 to FMS v15 and since that point in time the scripts have been failing when FMS1 has been trying to update data from FMS2 which is still running FMS v14 Any ideas or guidance or questions ? Cheers Harry