FileMaker Server v7 - v11

Hi all, in regards to this Post, I tried another way of doing it.. I have an Applescript that takes value of a field, then uses the "do shell script" command to generate a txt file on the HD, then another "do shell script" to change line endings from CR to LF, where the output goes to another directory. This works just fine when ran from FMP, but I need to make this Server sided, in order to have the resulted file to be updated on a schedule.. here is what I have so far: file script is:(based on this example copy cell "PROFESSIONNELS INTER::CalendarName" of current record to fileName copy cell "PROFESSIONNELS INTER::tout ensem…

OK, this is really odd. My MBP recently went in for service and I deauthorized by FM9A and installed it and activated it on my home iMac (OSX 10.5.4, FMA 9.0v3). Firewall set to allow "All incoming connections." I maintain several solutions hosted by a 3rd party hoster who has them on a couple different servers. I am unable to access two of those servers at all. As a Favorite host, when I select that server, nothing shows up, when usually all the files do (including my own). Other users (my clients) can see the files, just not me. Customer service at the hosting company has been great, but ultimately unhelpful. The host maintains a handful of ser…

Hi All, We have FMSA7 running on a mac and this server hosts many databases. Suddenly, when we tried to login into the FileMaker Server Admin and when we were prompted to enter the password, the application was not accepting the password. But we feel that the password is correct. All the databases are still being served but we are unable to launch the FileMaker Server Admin application. We went to the unix shell and tried to execute the fmsadmin -v command and we were asked to enter the password. At the command level, the password was accepted and all the server info was displayed. Has anyone encountered a similar problem and how did you resolve this situation. A…

Hi all, We're trying to open up the admin console in FMS9, newly installed on a new G5 tower. OSX, 10.5.5 2x3.2 GHz Quad-Core Intel Xeon 4GB 800 MHz DDR2 FB-DIMM Each time we get a error message, with a cryptic message: Error: Unexpected exception: java.lang.reflect.InvocationTargetException And that's it. Nothing else to help us along. Any ideas?

I have web publishing turned OFF on FM Server 9.0.3 and as a result the server e-mails me the following message several times per day: Subject: FMServer ERROR wpe1 FileMaker Server 9.0.3.325 on FMServer.local reported... FileMaker Server 9.0.3.325 on FMServer.local reported the following event: Wed Mar 12 12:08:23 PDT 2008 FMS ERROR wpe1 Some problems were detected in the WPE COMPONENT: COMPONENT IS NOT RESPONDING. FileMaker Server automatically sent you this email. Contact the administrator if you no longer want to receive these notifications. If I turn web publishing ON, the notifications stop. I've looked in the Admin Console for the setting which w…

I am trying to load the FMS9 that I got from the TechNet membership onto to Windows Vista Ultimate. I uninstalled everything and try starting the admin console and keeping getting the same error "The Database Server is not available. To edit Server Deployment, please start the database server first." I read similar post, but the ones I found related to Mac OS. Any help is appreciated. Best

I have read many many posts regarding Admin Console's flakiness when trying to properly administer a Mac server running FMSA9 advanced. The only way I have managed to get it to work properly is by re-installing FMSA on the server every time Admin Console starts to misbehave. Today I had a power failure and my Mac server re-started itself. All FM files being served OK via IWP. But, once again, Admin Console now tells me that the DB server isn't running (when it is!), so I can't use it to do very much. Proper Shutdowns and managed Restarts etc on the server don't help. I haven't re-installed FMSA but once again it looks as 'though I will have to (for the n'th time!). I'…

My custumised homepages from filemaker pro 9 adv dont work for server. how can i custumize it?

I'm in the process of setting up a FileMaker Server v9. (At this point it is a trial, but will be converted to a "real" one in a week or two.) However, I have run into what looks like a bug with the Upload Database Assistant. I try to go through the assistant, but when I select a database to upload (or simply create a subfolder), the "Next" button is always grayed out. (So, I can't get to the next step.) I've been able to work around this problem by manually creating the folders, and copying the databases to the server, but this seems like a pretty basic thing to not work. Any ideas?

Just a reminder that a week from today, September 26th, will be End of Life for all FIleMaker 7 products including FileMaker Server 7. Steven

Hi all, One of my clients wants to move up from the Mac Mini they're using as a dedicated FMS box. My question is, which is the best Mac machine they can buy to boost their server's speed? Specifically, will FMS benefit from two chips as opposed to just one? We are planning to purchase the Mac Pro tower, with two 3.0GHz Quad-Core Intel Xeon chips. Just want to know if buying the two-chip setup is indeed significantly better than just getting the one chip -- and upping the RAM instead. All ideas, advice, vastly appreciated.

(I couldn't find an answer to my question after perusing the threads in this forum so I apologize if this question has been answered already and I missed it.) Howdy, all: I'm biting the bullet and have purchased FM 9.0x Server and FM Web School's FM Studio, and am now gathering opinions as to which Microsoft Server 2008 flavor should I purchase to use with them: Standard or Web? As an FM Pro developer, I want to be best able to assist my customers when installing and using my solution, so I'm leaning a little bit toward the Standard Edition. However, since the solution will be accessed via the Web in many cases then maybe the Web version will do? *puzzled l…

Hi all, I have four databases that I need to share with 3 users on a local intranet. I do not want to use web publishing as it is messing up my layouts. If I buy a filemaker server licence, do I also need to buy individual licences for each client or are they included in the price? I thought about just hosting the database files on the file server and buying clients but will there then be connection problems? Your advice is appreciated. Kind Regards Rich

I currently have a script that involves finding some records, saving as a pdf file then emailing it. I am running this script via a schedule on FMS9 . The only script line that is not server friendly is 'save as PDF (no dialog)' which is a shame as I have to use a plugin to trigger the script on a client PC (which does work but is a little clunky and temporarily disrupts work on the clients pc while the script is running) I could understand it not working if I was not ticking 'perform without dialog' option. Does anyone know if there is a plugin that would run on the server that can save a pdf file. Thanks

We've created a database that is shared via the Filemaker IWP (I assume thats the web browser interface) -- but it requires a username/password to access it. We'd really like to set it up so anyone can view it without having to enter a password. Where are the options to enter/edit usernames and passwords for filemaker? Also, bizarrely, the database requires a username & password to open it remotley ... none of our other databases do! Any clues or links to the documentation about user access controls with sharing?

[color:gray]I work with Fm since FilemakerPlus but have never done web-publishing nor web-server. I'm willing to learn everything that is needed. As a volunteer I help a school. Please advice me on the problem. This is the problem. Each teacher does or plans a number of projects and activities with his students during the year. I want a database so that every teacher can see on the web what the other teachers do and check what each class will do. [color:gray]1) [color:blue]Do I need Filemaker Server ? [color:gray]2) Teachers will be asked to send a [color:blue]form to me. The form for the teachers must be absolutely (sorry) idiot-proof and suitable for Windows. Last…

Hi All, I am new here to the forum as well as administering a filemaker server. My company is running a filemaker 8.0V4 server that hosts a dozen or so databases. Recently we remotes started recieveing and error that says host capacity exceeded. FM Server is set to 250 connections; at most, I get 45 clients connected in at any one time. Users who are connected in can continue to work with no issue; users trying to connect in can not. At the moment the only fix is a reboot. In the application log, i get a generic slsocket54 error quite a bit. The socket error occurs regularly, even when users can connect in. Has any one seen this?? With that for the mom…

Hi, I am running a simple update script from the FMServer Scheduler. It finds some records and tries to do a Replace. Runs fine from FMPro. Here is the error in the event.log: scripting error (301) at "Invoices Update Quote Forecasts : Replace Field Contents". 2008-09-08 12:10:40.974 -0800 Is "Replace" not a valid command to be run from the server? I can't find a document on running FM Scripts from Server. Also, it is frustrating because I don't get an error email when there was an error running the script.... Any help is appreciated. I still have my robot machine running other scripts the old way so maybe will just move this one bac…

I have a shared account with Dreamhost. Any way to install FMS on Dreamhost's server? What about just putting the FM database file on the server and opening it from any workstation with FM installed? Can more than one person use the file at once, or do I need FM Server installed to do that? Thanks.

On September 26th 2008, after over four years of service, FileMaker, Inc. will end support for FileMaker® Pro 7, FileMaker® Pro 7 Advanced, FileMaker® Server 7, and FileMaker® Server 7 Advanced. All the 7 version products will be officially End of Life (EOL). [http://www.filemakeroffer.com/vlupgrade/] In keeping with that EOL policy, FM Forums will be making some changes in its structure and number of subforums: We have created a new subforum in the legacy version section for questions related to FileMaker Server 7 and FileMaker Server 7 Advanced. Click Here. We will combine the existing Server and Server Advanced subforums into one single one for que…

I have been having problems that I at first thought were with the server itself, but now it appears are just with the Admin Console. My configuration: Macintosh 1.8GHz PowerPC G5 2.5 GB RAM OS 10.4.11 (Tiger) FMSA 9.0.3.325 Apache 1.3 PHP 5.2.4 It will be going along just fine but when I need to restart the computer for routine maintenance, more times than not I run into trouble. I go into the Admin Console and stop both the Database Server and the Web Publishing Engine. After both are shut down, I do the necessary maintenance and restart the computer. FMS is configured to start with the computer. After it is fully up, I start the Admin Consol…

I have over 80 files in my FM server and i would like to do the backup for everyday. Once the system doing backup, some of the file has error message. However, the file which has error message are also can be done for backup Anyone knows what is the happening? Here is the error message:- > 2008-08-22 12:40:00.331 +0800 Warning 156 GRFM-Server9Adv Schedule "A05 > Friday" aborted; the destination "filemac:/GR XServerFM/Library/FileMaker > Server/Data/Backups/Friday/" is not writable. > 2008-08-22 12:40:00.284 +0800 Error 494 GRFM-Server9Adv Backup aborted. > Invalid backup destination: "filemac:/GR XServerFM/Library/FileMaker > …

When setting up a schedule on FMS 9 to run a FM script the process completes without trouble (seemingly). The schedule however does not run. When I go the the command line and use: fmsadmin list schedules The schedule I have created has an ID number of 0. In the command line using: fmsadmin run schedule 0 I get this response: Error: 10600 Any ideas? Thanks, Drew

We had a demo recently by a rep from WorldSync of their product SyncDek. I think it is a pretty cool tool that we may have more uses for than we thought. What I am curious about is if there are any other tools out there that have the same functionality? As of right now, we would only be syncing two(or more) filemaker databases. I did a search, and WorldSync is the only one that comes up. Not that there is anything against WorldSync, but if we are going to spend that kind of money, we would like to be as well informed as we possibly can about all the options. Thanks in Advance. ~Mark

I am trying to get a filemaker script step to work correctly as part of a filemaker schedule. The script step is set web viewer [go to URL...] The url being used 'activate' a RSS service outside of filemaker. This script step is web-compatible and thus is able, in theory, to be run as part of a server schedule activated script. The script works as a standalone script within a filemaker client. Because the schedule runs as a session on the server I tested the URL by pasting it into a browser on the server. This worked. So there is no blocking of the URL on the server either. Is this script step really compatible with filemaker server schedules? Any help…

I've a script to export records from a hosted database. The question is I want that script to run automatically by itself at night, so I want to store the exported file on the same server where FMS is running. I don't know how to specify the export path. If I specify the same as the database containing the script I get the following error: "filename.fp7" could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk. I just have been able to export into the client machine... Btw: I am in a Windows XP pro LAN. Any idea? Thanks in advance

Just upgraded a server (G5, 4G Ram) to Leopard. Was running FM Server 7.0 in OSX 10.4 just fine (only about 10 files). After installing Leopard and when trying to open FM server to administer the files, got the message "Connection Failure" - Could not connect to FileMaker Server (localhost)" (127.0.0.1). Only option is "OK" and then it closes FM Server. Upgraded FM Server to 8.0.2 and got the same error. Still can't host the files in FM Server as a result. Is Leopard incompatible with versions prior to Server 9, or is there some network setting that may have been reset during Leopard install? Help, please!

Hi FMSers System: Win Server 2003 FMS 9 Adv (latest version v3) We have several FMS Adv. in different networks (in-House, Clients etc.) in use and they work just fine. We can start the console from the local machine(s), but connecting to the Admin Console from a remote computer is not possible (quite a while now). Acutally it's not even possible to get a connection by entering another address than "localhost" oder "127.0.0.1". Connecting to http://IP-of-Server:16000/ results in a HTTP Error 403 (by TomCat). There was no change on the firewalls, whatsover the ports are open. The fact that we get a Tomcat-Error (not the IIS-Error-Page) means, t…

In FMP9 is there a way for an administrator to create accounts with passwords and have these pushed to all computers on an FMP Server network? And can we script this so we can provide the administrator with our own interface and record the accounts and passwords in a table located on the server? Yes, I recognize there is a potential security hazard in doing so. However the downside is minimal and reasonable if access to the server room is sufficiently limited (as it should be in any case). The upside is considerable; we can script our own more powerful privilege system than FMP provides natively. With such a system we can provide administrators the option to make ch…

I have 3 files that were reported as having a consistency check failure in the event log when Fm9 Server ran the Scheduled Backup. I can open and use them but I am worried they are corrupted. FM Article 6509 says I can use "Recover" in FM9. Does anyone know if FM9 Recover has been updated and now usable for a true recovery? Here is the exact error log description: Schedule "FM9 Hourly Snapshots" consistency check failed on backup of database "Invoices". (805) Thanks, I don't want to go through a long recovery process if the new Recover works.

I'm setting up a new Xserve with two ethernet ports. I come from a world where computers have only one ethernet port so this is new to me. I have both plugged into my switch and both are configured manually (i.e. two static IP addresses). As I understand it, the switch handles the network load balancing so there is no probably no way to configure Mac OS X to pretend that I'm on a single NIC with a single IP address. SO, my question is, which IP address should I use for my opener file's data reference? I'm guessing it's just the first one, but I've got two to choose from. (And any gems of knowledge regarding network load balancing you want to impart would…

If any records are busy in a given found set, Server will not allow a delete of that found set. Is there a way to identify those busy records and except them from the found set to be deleted? [FM8.5, FMS8, 30 node Mac network] Any clues about this are greatly appreciated. ~Dennis

Hi guys seems like a really obvious question but is the only way to get a standalone option to access the same database to use FMServer?? Any other possible solutions would be appreciated. Thanks Stuart

Please help!! I added mod_ssl to Apache 1.3.41 on my workstation, where I am running with Filemaker Pro Server (test version). When I did the initial update, I seemed to be able to serve either http or https just fine. However, when I rebooted, the updated Apache won't start (Segmentation Fault). I then went back to the original version of Apache and even though Apache starts, I can no longer serve on my localhost. I can't even get to localhost/fmi/config. I obviously broke something, but have no clue where to look (I checked the web, but to no avail). Any help would be appreciated!!! I am at a standstill with testing any of my systems right now.

have problem with Admin Console, Whenever i try to click on admin console it wont start and it will give me this error message tabase server is not available to edit server deploying please start database server first. I have tryed to download all the patchs i need from filemaker website, that did not help i tryed to do clean installation also that did not help, i have checked jave temp files i have deleted the temp file of java that did not help aswell... Please anyone can help please

Hi, I have took over IT on this company that uses filemaker as their main databases. Server 2003 has filemaker 9 server running. Other 8 work stations were using filemaker 5 and 6. In order for me to host fp5 databases, I had them upgrade all to filemaker 7. Database conversion went well. But ran into little problem. No passwords were given to anyone. Basically they were logging in as guests. I do not know how previous IT guy set the privileges up, I know he did not do good job. So I had to purchase passware's filemaker key to retrieve the password and gave them usernames and passwords. Previous IT guy gave all guest full access before. So I have set the guests users to …

Hi, I have a Mac G4 Cube (remember those?) with 500mb of RAM running a developer version of FileMaker Pro Server 7. Not ideal, but it works okay for my purposes. I now want to upgrade to a full version of FileMaker Pro Server 9 so I'm going to need new hardware, but I'd like to wait until September before buying new Mac hardware. So my questions is: if I buy FileMaker Pro Server 9 now would the installer let me install on my current system, just so I can get familiar with running with Server 9 or will the installer refuse to install on such a machine? Thanks in advance for any advice, Pat

With the implementation of server side scripting, I decided to fully normalize my tables and run nightly scripts to update local "index" columns. Users have the choice of a faster search against last night's index vs. a (frequently painfully) slower search against live data. I've run into a problem when the data is located in an external source. When the script is run by FMS the result for data from an external source is a blank field, but when I run the script via either IWP or the PHP API it will grab and set the appropriate data as long as the external source is on the same Filemaker server (even if the external source is an ODBC link to a MySQL table). If th…

I have just upgraded from Server 7 to 9 (actually demo version to see if I want to). Two major problems came about, can't configure the Web server for PHP and disconnect from server often. As you can guess, the later is more important. What seems to be happening is after 5 min. it stops the Filemaker server. I am running Windows server 2003. If I go into services, it says it is still running. But when I open the Admin Console, it shows it is off. I have to start it and then go open all databases. Is this a "trial" limitation?

The server box shows the correct time. But the Admin Console shows one hour early. My question is ... where does Admin Console get its time? The system date/time has not been changed; nothing else has happened on this box - it was opened, files were served and the time is wrong. Anyone have this happen? Of course I can unserve the files and re-serve and it might fix itself. But even if it does, that wouldn't answer the question of how the time could have been off and that is why I want to know where it grabs the time from. I would have assumed it would use its own OS date/time, right?

We have an issue where every now and then IWP becomes unavailable. I've confirmed the following: -All services are running -Databases are accessible When this happens, we've tried restarting necessary services. Usually, we have to reboot the server and everything is okay. We also modified the registry according to FM. http://support.microsoft.com/kb/149532/EN-US/ Anyone have a similar issue?

Who is responsible for setting the date/timestamp on files that are served ... FMS or the operating system? The reason I ask is that, when files are unserved (and there has been data changed) the date/timestamps should update with the time the files are closed, right? Sometimes they don't update - they can be an hour to four hours earlier even though, when reviewing the data, the modification timestamps verify that the data was actually changed. So when the Admin Console locks up (quits responding) and we have to close services (won't even respond to command line prompts), many times the file timestamps are hours off! That is why I'm asking who is responsible …

I have my application hosted on 'Filemaker server 9 advanced'. I am accessing this using FM 9 client machine. I want to save a copy of this database. but this option is disabled when we open any database file from remote. Is there any option to save this DB?

For some reason our FileMaker Web Publishing engine keeps stopping. I try to restart it through the Web Admin Console but it does not get it going again. It works sometimes after I reboot the computer...but hours later when I check it from my browser it tells me that Web Publishing has stopped again. I have reinstalled the Web Publishing Engine twice (using the latest available update) but I keep running into the same problem. Does anyone know what could be causing this problem?

I have a new laptop that isn't connecting to my server like its predecessor, the exact same model. MacBook Pro running Leopard 10.5.4. The Server is running FMS 9 under OS-X Server 10.4.11. On the Server machine I can launch the Admin Console just like always. But on my laptop, I get an error that begins with this General text in the Java Web Start: An error occurred while launching/running the application. Category: Invalid Argument Error Could not load file/URL specified: file://localhost/Users/[my user name]/Library/Caches/Java/cache/javaws/http/[my ip address]/P16000/AMadmin_console_webstart.jnlp I suspect there is something I need …

Hello all, Running OSX Server 10.5.4 with all of the latest updates. Just installed FIlemaker Server Advanced. Everything during installation seems to have gone normally. When loading the server admin web page, it downloads a file, then that file launches Java, as it was designed to do. Java throws up a certificate warning, as expected. After Java launches, we get the error "The Database Server is not available. To edit server deployment, please start the Database Server first". Now, I've already googled that phrase and found an post on this site about that same error. The solution presented there did not work. I've tried removing and reinstalling FM Serv…

I haven't had to login for months and cannot remember the password for this. Is there a workaround? Thanks.

How do I retrieve a backup of my data file in FMS 9? I tried to re-upload the backup onto the existing file and got all kinds of error messages. What's the secret to retrieving the files? TIA Al

This is my first real experience administering a db with Server. I'm working with Server 9 on a Mac Mini. I understand I should not edit the db "schema" while the db is being served. Does "schema" cover anything else besides field definitions and the relationship graph (ie everything under Manage Database....)? What about the other "Manage..." like Scripts, Custom Menus, Custom Functions, Value Lists, External Data Sources, Accounts & Privileges? Layouts? What is meant by the db "not being served"? Does that mean I simply need to close (pause?) the db via Server and then open it with my FM9A or do I need to shutdown Server itself? What procedure…

Hi, everyone. im upgrading to FM9 server, and i just can´t figure out how to publish my database on the web, if i try in my network: http://192.168.1.190/fmi/iwp/res/iwp_home.html i can see it, but how do i get it on web, i had FM8 server, and the way i accessed was : http://factoria.tzo.com:16080/fmi/iwp/res/iwp_auth.html could anyone, get me a clue? thanks!

ID Name Model Number Price Created At Created By <?php echo $rows; ?>

Hi Guyz, I need help, I have been using Filemaker Advanced V9 for some time and previous versions. But I have never used the Filemaker Server and wanted to increase my knowledge skills and even purchase filemaker server. I have downloaded the trial version of Filemaker Server 9. I have installed it using (no-ip) I have also open ports 5003, 16000 & 16001. If I open the client "Filemaker Advanced V9" on the same machine, I can see the file which is being hosted by the server. Works great. Now If I open another laptop and try to connect using Filemaker Advanced 9 Via the no-ip address I don't get any file's hosted by the server. I have even tried to…

this is a single machine deployment when I try to deploy the web component, it fails with error: "could not get a list of webservers from the specified worker machine"I am using FM server 9 with the lasted updates 3.236 Windows 2003 standard, sp2.

I have many computers in lan and a filemaker server running IWP in intranet. All computers are connected to the internet trought a router (especific gateway) Is it possible to connect to my iwp database using a computer connected to internet thats is outside this lan. If yes how?

I dont why, ive already tried with the / in the end and still not valid what might it be?

I have a very curious tale to tell. At 19:11 on 15th July, FMS 9 launched a server-side script that appeared to execute successfully. However, no further scripts were launched after that time (and they should be every 5 minutes). The solution was used throughout the day on 16th July. The users of the solution reported that it functioned fine. (The server-side scripts perform non-vital tasks so their failure went unnoticed). At 17:00 on the 16th July, it was noticed that fmserverd was using 99% of the CPU constantly - a symptom that we have noticed before, of a server-side script being stuck in a loop. All clients disconnected from the solution, and we …

I have a client (far away), who wants to limit WAN access to the hosted files, to only a couple of top-level privilege sets. He is not using Active Directory, though he is on Windows, using Server 9 (I believe). I am not much experienced with this kind of Server management. He especially wants to block LAN users from going home and accessing the files from home. I don't particularly see this as a big problem myself, as the users have fairly limited access; no Export, Editing only menu set, etc.. Anyway, if Active Directory is the only viable option, then perhaps we should use it; but I'd rather not, because I cannot go there to set up or fix it, and he may not …

Just ran into a nasty situation. Without knowing it, a db file on our FMserver 9 corrupted, 10 days ago. Then yesterday the server needed to be restarted, and that is when we notice the db would not open. We would like to add a check for this in the future and one way I was thinking was to schedule the server to close and open all files each night. That was if the file doesn't open we can catch it sooner. I can see in the Admin console there is an option to run a system-level script. - Has anyone does this on a Mac server? - Preferred script would be close and open files.

I have my Admin for files set to Full Access and the Fmapp option is set in the Extended Privileges. I've compared settings in two files that appear to be identical, yet with one I can perform remote maintenance and with the others I can not (Layout mode grayed, etc.). Any ideas? Thanks.

Is there any problem with having two databases opened remotely at the same time (they're both on a FM Server)?

Okay, pulling my hair out here... I have setup the AutoUpdate feature of FMS 9. I followed a tutorial by Geoff Coffee which carefully explained how configure the server and plugins for deployment. I created the scripts necessary and I keep getting a "-5" error which means that the file cannot be downloaded into the local extensions folder. Oh yeah, this is an all Windows environment. The FM server is on a Windows 2003 box. I have tested from multiple clients with the same result. I have searched FMI's KB resource and poured through the server documentation, but am coming up dry. Any help would be greatly appreciated.

I have an import script that I am trying to run with Filemaker Server. When I try to perform the script server side it says "script step not supported" in the event viewer. Can importing be performed as a server script step? Thanks

We moved to a new server box, installing FMS 9 and updaters to 9.0v3. We served the files and all seems fine. Except when we open the Sharing, we see this in all the files and then everyone is disconnected. What the?

We just installed FileMaker Pro Advance 9 on Windows 2008 Server standard edition , and we are not able to connect into the shared FileMaker files from the remote FMPRO 9 clients on MAC or WinXP systems. The Share FileMaker Network has been enabled. Is there a port that we need to open on Windows 2008 server? Or there is a setting that I missed in FileMaker Pro Advance? Thanks for any help. : A

MY BAD, HIT POST BEFORE I REALIZED WHERE I WAS. Hello, My issue is that when opening FM via remote connection (or recent also), it is extremely slow to open and I get a message that the program is "not responding". After a minute or two, it will finally open. I do have a script set up to open several related files also. Any help or insight would be appreciated. thanks LJ

I want to set up https on FMP Server and set up the Security (under Configure) to secure connections with FMP Server. However, when I look at the Security Guide, it tells me to check the documentation that came with the Web Server!!! There wasn't any!!! I have looked on the web, but can only see Apache-SSL. Do I need to get this in order to do what I want or is there another way? Can someone point me in the right direction, please! Also, how do certificates work in this instance?

I tried to make the title say it all, b/c I've been searching forever. I got thru the instillation of FM 9 server only to be stuck on the admin console start screen. I see that ports 1600 and 1601 have to be open to get past this screen, well I have a G4 mac in the closet with firewall off- currently sharing the database on our local network (via FMP8) but after installing FM server 9 finished I get the endless "Please wait while the Admin Server starts" screen. The G4 connects to an old Netgear switch. I port scanned the G4 from another mac and port 1600 is not open. when I try to go to the switch's ip address via browser I get an unable to connect. I …

Is there a way to edit sharing (IWP and FMNetwork) once the file is being served? Thanks

Hi there! I am desperately trying to make a backup to a location different than the server itself. The Filemaker server is running on Mac OSX; the file & print server I want to back up to is running on Windows. I've tried everything I think: starting with "filewin:/" starting with "file:///" starting with "/" I can access the folder I want to copy to from Finder, so there shouldn't be a connection problem. I've tried using the filepath based on Safari, the filepath and the server path specified in the Finder information, etc. I ALWAYS end the filepath with a slash, so the problem can't be there. What am I doing wrong? Any ideas? I…

We just moved our FMS to new hardware, and the old FMS ip address shows up in our FMPro 9 Quick Start. Is there a way to clear the old info in the Quick Start. Thanks in advance. Sorry if this post doesn't actually belong in the FM Server forum. It just seemed appropriate since only those using a FM Server might have had this experience before.

I'm not really experienced with Filemaker Server, but i'm planning to complete a large project with it, but i'm still uncertain about what it's really capable of. Could Filemaker Server 9 Advanced be used to make something like this (using the php publishing, i'm thinking) http://www.leginfo.ca.gov/bilinfo.html

Hello, When I start the admin console, I have this message data base server : ODBC/JDBC off And when I try to launch the data base server, nothing changes. On the log file "Event.log", I have this message that comes from time to time : "Another copy of FM Server is already working with this installation code". But I can't find that other server running. Strange because it has worked fine for a while. I am using FMS9 on Mac OSX 10.4.11 PPC G4. Thnaks for your help

I'm unsure whether to post in ScriptMaker or here ... We are firing scripts from FM Server and two scripts have been fired at once within FileMaker. I know this because of the overlap of resulting records which were created (I can show everyone if they wish to see the proof of such an overlap). My question is ... shouldn't FM Server finish one script before starting another? Each of the two scripts in question fire their own sub-scripts. But it is my understanding that one script (including all of its sub-scripts) should finish before the next script can even start. But that is not what is happening. And the two scripts firing together is causing problems f…

Hi there, I'd like to schedule a daily disconnection of all users from the database using the FMSAdmin, I'm running FMPro 8.5 Server on our Windows 2003 machine and on the surface it seems like an easy task. According to the manual the command for such an action is simply fmsadmin disconnect client with no client ID specified it should disconnect all users right? I've also added a two minute delay and a message just in case someone's still running FM at 3.00 AM. also a confirmation prompt as well thus: fmsadmin disconnect client -m "Regular Maintenence Scheduled - You have two minutes til termination" -w 120 -y apparently no client ID is needed if I wi…

I only seem to be able to connect to console via 10.3 machine. Get an error or nothing happens if i use 10.5.4. The FMserver 9.0.3.325 is on Mac G5 10.5.4 server

We just added a static ip address for our fm server. When I go to a networked computer, I can see the hosts name, but I do not see any of the available files. I am sure it is just a matter of changing a setting, but since I didn't set up the server, I am lost.

does anyone know of any good php-base websites, developed with filemaker server 9 advanced?

I am working my way through the FileMaker training series, and I can't seem to get a .sh script to execute on a schedule. It runs just fine when I run it from the terminal, manually, but when I select it to be scheduled, it doesn't appear to run, even though it sends an email saying it was run successfully. I have given my .sh file executable permission, and the first line in my file says #!/bin/sh. Any idea what I could be doing wrong? Thanks..

I'm trying to setup a 3 server test enviornment. My FMSA9 and WPE server's are located on-site and my web server is located off-site. When I go into the Deployment Configuration and I select 3 machines and then I get to the drop downs where I'm suppose to fill in the domain of my web server and web publishing engine I can't seem to make that work. The WPE part is working fine but when I put in my web server's domain and hit Lookup I get the following error: Worker Lookup: Error encountered while doing lookup. Any information on what's going on here would be greatly appreciated. We do have a firewall here in-house but I've given the FMSA9 Quick Start …

I set up daily backups in FileMaker Server Admin. They are all enabled. Path is validated. They are to go in folders like the default "backups" folder on the server, but each folder is named for the day it's backed up ("MonBU" "TueBU" etc.) "Allow Schedules To Run" is checked under Action. The schedules do not run, even if I click "Run Now" under Action. Why won't they backup schedules run? What's really weird is that some of them ran on Jun 20, but never again. Thanks.

I'm running Job Pro Central on Filemaker Server 9 (and clients are using Filemaker Pro 9). Job Pro Central runs perfectly for users within the LAN... however, it is UNGODLY slow loading remotely. My situation: Office in Chicago 10 users Office in Mexico 5-7 users I want the office in Mexico to efficiently and effectively access Job Pro Central... but... hosting it on Filemaker Server is just the wrong way of doing it. Here's the problem. Chicago office is all Mac. Mexico office is a mixed environment of Mac/PC Multiple users connect to the database simultaneously so PCAnyWhere and Timbuktu are out of the question. I don't have the r…

I have a scheduled backup that runs fine on Server 7 (OS is Tiger). I also have a scheduled task to run a script (I've tried both shell and Applescript) shortly thereafter that copies the backed up database files to a file server elsewhere on our campus. The scripts have the recommended executable bits set, owner and group are set to fmserver and fmsadmin. The scripts run just fine from the command line, and the transfer of data takes about 30 seconds. On the server, at the scheduled time, the server log indicates that the script was run and completed, but nothing happens. No data transfer, nothing. I've tried a very simple shell script that just cre…

Recently upgraded FMS to a new faster server. I run FMS9A with 11 databases hosted with two of them being around 19GB. The rest under 100MBs. On the server it's self I have both FM9 and FM8 clients running separate scripts all the time. The system seems to run fine, until the backup starts at 2am, then it slows to a point that 2-3 users can not work until it finishes. I turned verify off, which changed the back-up time from 2 hours plus to 27 minutes. Watching the activity monitor, the cpu load does not make much of a difference. But it seems that when the disk reads/writes are being done by FM, it causes a slow down. The Wait time/Calls goes way up. If I do a manual…

I have FileMaker Server 9 running on a Windows 2003 Server machine. The application is accessed completely through php/html pages using the FileMaker API for PHP. I recently began getting complaints that it was running so slowly, it was unusable. Looking into it, i've noticed that the process fmswpc.exe is using between 90 and 100% of my server's CPU. Has anyone else had this problem? Even if i have only one user sending requests, that process will still hit around 70%. What is this process? what causes it to eat so many resources? Is there anything I can do?

Hi, I am hoping someone can help me out. We are running FMSA 9 on a Windows 2003 platform. Our database includes a container field which we would like to hold images. We would like the images in the field to be file references only, to save space and performance. We wish to place the original images themselves, in a folder on the same server. How do we get the image to appear in the container field in the database? I think this has to do with the filepaths, but I am not sure. Any advice would be most appreciated. Thanks!!

Hi, I just hooked up another computer in my office. I am running Filemaker Server 9. I cannot see the hosted file from the newly connected PC. If I open the file on the server machine (not using FMS), I can open it using Filemaker Network Sharing. I have disabled all firewalls. see diagram here: http://www.gliffy.com/publish/1458138/ any ideas? please help! thanks in advance. I have racked my brain on this for the last 5 hours! -Kevin

Brought into a project here at work cleaning up some FileMaker databases. One issue right now is several of us run FileMaker Pro 9 from a system using Terminal Services (Win2003) Any time we open a database, a nice little window pops up stating: "FileMaker cannot share files because another user is already using FileMaker Pro on this computer" Is there any way to make that not pop up? It gets annoying clicking it how ever many times to open a database.

I have a bunch of FileMaker files, each with its own specific users and security settings (examples: a single file for Ordering, a single file for Tracking Property, a single file for Customers to view the property they have checked out to them). All of the files share the pertinent information so there isn't any redundancy. I want all of my different users to enter my FileMaker solution through a single FileMaker file that I've created just as a menu screen to all of the different files. From there, the users can select what they need to do (make an order, view property, etc), which will open a separate FileMaker file. The problem: when a user opens FileMaker Pr…

ok, a friend has an old site, just called me as he setup filemaker, put a bunch of his clients in, products, etc. now wants it on the web. I have been a web/php developer for 6+ years now, and lost, well not really started yet. I installed the demo of fm9, even started looking at the tut video's, but before I even venture, can someone answer these basic q's. Normally (using mysql, mssql, oracle, postgres,etc) I would make my page, do my db connect, hand code the queries, put data in arrays(the normal stuff), is this possible in fm? I haven't found where I simply say, connect with this string, or do this, etc I see hours of tutorial video's, but I haven't …

I've inherited an existing FM7 setup. All the user passwords are OK, but nobody knows the password for the admin console, and it is apparently different from the Admin user in the database. Is there a way to reset it without reinstalling? Running on W2K3. Thanks.

My appolgies if this has been asked/posted before. I am looking at implementing a FM9 Server Advanced to serve about 25 lan users and IWP access, with probably 30-40 concurrent web users (casual lookups and nominal data entry.) About 20 databases with 600k records total, dos file sizes are about 8 gig total. I will be (or I will be contracting out) converting/migrating several legacy qbasic and clipper dos based programs (gee, every do that before?) into fm9 server advanced. Since the original programs are dos based they run like lightening on modern servers. Remote uses access via Terminal Servers connected through VPNS. The lan users are connecte…

Hi, I am new to Filemaker. I have just installed Server Advanced 9.1 R2 for Mac OS X and applied the 9.0.3.326 update. When I start launch the Admin Console I get the following: "The Database Server is not available. To edit server deployment, please start the Database Server first." When I press restart I get the following: Unable to start the database server. Please contact your system administrator for assistance." I am running fully updated Leopard on a Macbook. I have seen this error elsewhere on the forum but nothing seems to apply. Can anyone help? Many thanks, Keith Hulse

Hi everyone, I am working on a file management system for FMP 9. I like to keep all Jpeg / PDF / Text files on a drive connected to my Filemaker server computer accessible to all users of my FMP database. I like my users to pick a file name from a list and view it within my database, maybe in a Web viewer ? Any recommendations how to accomplish this ? I have been keeping the files within FMP, but the DB is getting too big and bulky. Any experience with this ? Thank you in advance. Xoomaster

Hi all, looking at upgrading our system from 2-Macs (G5's) running OS 10.3.9 Server (with Web Publishing) and OS 10.3.9 running FileMaker Server 7 Advanced. I will be upgrading the Mac's to OS 10.5 first then I want to upgrade my Filemaker software to 9.X. I am currently using CWP with XSLT/XML. I searched the FileMaker site for a 9.0 Web Publishing Installation Guide to see what was involved but did not find one. It looks like they are moving to support PHP in this version. Anyone out there that has experienced this migration route and might offer some thoughts on avoiding unnecessary "pain" here would be much appreciated. Thanks..........Ray

Hello: Is there a way that we can update the computers everytime an update is out for FM9, at the station, from the Advanced Server 9 . Right now I have to go to each PC and update. I would like to do this via remote if possible. As we continue to sell this becomes a service time problem. Thank you

Hi, We have an ongoing issue with one of our clients as follows. They are a running a solution built by us consisting of 53 files in the FileMaker Pro 7 file format. They are running FileMaker Server 8.0v4, with FileMaker Pro 8.5v2 clients. The FileMaker Server platform has the following specifications: Hardware: Intel Xeon CPU, E5320 @ 1.86GHz (Dual Quad Core), 4 GB RAM, 300GB Hard Disk Drive 10,000RPM Software: Windows Server 2003 R2, Standard Edition, Service Pack 2 (dedicated FileMaker Server) Configuration: Database Cache: 200MB (maximum indicated is 800MB). Flushing the Database Cache: Every 1 minute The FileMaker Clie…

Hi, Is there any script step or function in file Maker which grabs the logged in user name when the FileMaker application is hosted on the FileMaker server. Pushkraj

I am currently revisiting the problem of installing FMSA9 in a two machine configuration. These are both brand new XServes running Mac OS X Server 10.5.3, with FMSA 9.0.3.326. My last attempt at this (way back in January) was abandoned after it became clear that we were using under-spec machines and we rolled back to FMSA8. Originally we attempted to install the webserver/wpe on the DMZ and FM Server on the LAN, with all ports on the firewall open between the two machines and no internal firewalls running. The only other service on the FM Server is Open Directory, while the webserver is also running Apache 2.2 and AFP. The installation appeared to go smoothly e…

Hi there, I'm hoping you bright sparks can help, and that this is the correct forum to post this to - I suspect our issue may be ODBC-related at core, but the symptom is primarily centered around the fmserver process. Sorry this is a long post, I want to provide as much background as possible as it may help someone to recognise the problem. However I'll try and keep my questions at the end to the point based on the research I've already done. First a bit of background: We are running FMS8.0v4 Advanced on a Windows Server 2003 (SP2) box. A number of FM clients (max 10) could be connected via FM clients at any one time. Additionally the database serves as a d…

I have two dbs that are related. When I open both bds locally via FMA9, there is no problem. But when I open the same files in 'remote' via FSA9 which is on the same machine, FMA9 says that the files are already being used, which is not the case. Strangely, when I open the same files via FSA9 on another machine, all is well. Naturally, I cannot open FM on the host server machine and have the server running. Any ideas?