3 Replies Latest reply on May 5, 2016 7:55 AM by Mike_Mitchell

    Duplicate users on server and fmsadmin user/pass

    AdamSnyder_1

      This morning our FileMaker Server 14 had over 40 connections.  Each user was duplicated 5-7 times in the activity list!  Every time someone would access the server it would create another connection but not release the other connections for that user.

       

      I tried to disconnect all users and close the databases, but each time I would disconnect the users they would just pop back into the list.  Attempts to close all databases via the admin console didn't work either.  they all just said "closing" and never closed.

       

      Tried using "fmsadmin close -f" but it then prompted me to enter the user and password, which it didn't accept.   Why doesn't fmsadmin accept my admin password for the computer?  Is there a way to reset the password?  It must be a different one than the admin console login or the computer admin login?

       

      I just had to force the computer to restart, which I know is bad for the databases, but we had no choice.  This is the 2nd time this has happened this week.

        • 1. Re: Duplicate users on server and fmsadmin user/pass
          Mike_Mitchell

          Questions:

           

          1) What kind of "computer" are you running this on? A desktop workstation, or a server?

          2) What OS?

          3) What kind of network do you have? How is it configured?

           

          We've seen this issue before, and it had to do with a bad DNS server that was confusing FileMaker Server when attempting to make / break connections. My first instinct, therefore, is to suspect network issues.

           

          The password it's needing is the one for the admin console.

          • 2. Re: Duplicate users on server and fmsadmin user/pass
            AdamSnyder_1

            1.)  Mac Pro Late 2013 , 3.7 Ghz Quad core Xeon E5, 12GB RAM

             

            2.) Mac OS X 10.10.5.

             

            3.) Not 100% sure about all network details, but I use the cisco ASDM for ASA to configure our cisco router/firewall, and there is a juniper ethernet switch.  I can get the exact cisco model number when I get into the office later this morning.

             

            When you say a bad dns server, I'm not sure which one you mean...  I'm using openDNS as the dns server in system preferences on the Mac Pro that hosts filemaker.  We also have a mac mini server that is our open directory server and it's running a dns, but only locally for the lan, so I doubt it's that one...

             

            Thanks for the details on the fmsadmin login, I was using the user name it showed in parenthesis in the console prompt instead of the admin console user name.

            • 3. Re: Duplicate users on server and fmsadmin user/pass
              Mike_Mitchell

              I'm not particularly concerned about the specific router model. If the DNS server gets confused, then FileMaker can't resolve the connections, which is why they hang. I'm really not an expert on network / DNS configurations (maybe one of the other forum members more familiar with server configuration, like maybe wimdecorte or taylorsharpe, can chime in).

               

              Is there any way you can do some network analytics and figure out if you're getting a lot of dropped packets on port 5003 between the clients and the server?