Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / FileMaker Topics / July 2008

Tip: Looking for answers? Try searching our database.

FileMaker Server 8 Advanced Web Publishing Administration Console/FM     8 Crashes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Deepti - 28 Jul 2008 22:05 GMT
Hi All,
We use FM Server 8. Recently our FM databases have been crashing
often. The status in the server admin screen gets set to "Closed" thus
taking the entire site down! We have to manually log back onto the
server and then set them back to normal status on the server. We use
Filemaker 8.0v1 client and Filemaker 8.0v4 server. Both our client and
server are on the same machine, and have been so for the past couple
of years!

We checked the logs and there is a message that the database has been
damaged and needs to be recovered. We do not recover the database, we
just reopen it and it works fine! We are unable to find a reason or a
particular behavior to support the crashing of the database. Could
there be something wrong with the web publishing console? We are not
even sure if the people working on it before us have set up the "web
publishing" or not. We do not seem to have the username and password
documented anywhere!
Is there a way we know if it was set up or not? Is there a way we can
retrieve the password/username for the web publishing console?

Please HELP!

Thank you.
Deepti
iacon - 28 Jul 2008 23:35 GMT
You can retrieve the user name and password using a 3rd party app
called Filemaker Key. It costs about $50 USD.

Try using the recover function built into filemaker client. This is
the action i'd normally take if it is telling me that a database is
damaged, it can recover the file for you and will advise if there are
further issues. You won't need a user name or password to do this.

Running client and server on the same machine can be an issue, is your
client version of filemaker accessing the file via the server?
FILE>OPEN REMOTE> or is it accessing the local file? If it access the
local file this could cause the server to go down and damage the file.

Each database file manages it's web sharing, but you will need to
login to the file to check this, it is in FILE>SHARING>
Lynn Allen - 29 Jul 2008 04:17 GMT
> Try using the recover function built into filemaker client. This is
> the action i'd normally take if it is telling me that a database is
> damaged, it can recover the file for you and will advise if there are
> further issues. You won't need a user name or password to do this.

And this is the problem with taking advice from strangers on the 'net.

An additional caution here is that you must, after using the Recover
command, NEVER continue to develop on a file which has shown damage.
Recover is intended to get data out into a non-crashed clone of the
file, which you have hopefully kept squirrelled away for just this
situation. It does not in any way repair a file or return it to health.

Recover, further, examines the file for damage, and any object it finds
which does not meet its inbuilt "complete and proper" standards, it
will delete. So scripts or script steps, layout or layout objects,
field definitions, entire tables, areas of the relationship graph, etc,
will simply disappear from the file with no warning.

So in that nice long complicated script where you carefully specify the
layout and found set before performing "Delete Found Records"? Well,
let's just say Murphy will ensure the Delete All stays, but the
preliminary steps won't, and you'll be deleting a whole table, perhaps
even the wrong table. :/

If you do not have functional cloned backups of your structure, tsk.
You'll eventually end up reconstructing the whole file, as damage of
this sort, particularly if you're running Recover repeatedly, will grow
and spread. Sooner or later the whole file will pitch.

Oh, and that "3rd party app" recommended to get a password? It doesn't
crack the password, it writes over the hash string with a new hash
string for a known password. So if you think it wise to write data into
a FM file in the sensitive security area with third party apps, go
ahead. Personally, I would expect this to cause even more damage down
the road.
Signature

Lynn Allen
--
www.semiotics.com
Member Filemaker Business Alliance
Long Beach, CA

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.