Whenever I try to add a new record with server 7 advanced, running on a mac OSX Panther, I get an "authentication problem (mcs 607) error"...anyone have any suggestions on how to correct this?

I can search, get search results, etc., but can't create new or edit existing files.

Thanks in advance.

I assume you are using Custom Web Publishing? Check your accounts and privileges in your database. Your fmxslt or fmxml extended privilege set should be used by a privilege set and an account that allows for creating and editing records.

Martin

I checked privilege set and it has "full access" privileges. The error message gives a spcefic line number in the xls code as the error. The code was generated by using the site assistant that came with 7 advanced.

Thanks for the help.

John C. Foster

Can you show us part of this code around this line number? Thanks.

Martin

Here is a copy/paste from the error screen...

The resource http://127.0.0.1:16014/fmi/xml/FMPXMLLAYOUT.xml?-db=RFILog&-lay=Form&-view= could not be loaded because of an authentication problem

According to the Web Publishing Guide, the URL is correct.

The error comes when findrecords.xsl tries to access the layout data on your layout "Forms". There are several XSLT instructions that are interconnected:

On line 4, <?xslt-cwp-query params="-db= ...?> processing instruction defines the database and the layout to be queried.

Line 10, <xsl:include ...> includes utilities.xsl, where the variable "_query-params" is defined.

In line 15, <xsl:variable name="layout-uri" .../> a variable "layout-uri" is created with an URL that is the concatenation of your base URL (including user name and password, if you have set one), "/fmi/xml/FMPXMLLAYOUT.xml?" and a query part consisting the database, the layout and -view --> "http://127.0.0.1:16014/fmi/xml/FMPXMLLAYOUT.xml?-db=RFILog&-lay=Form&-view="

On line 16, with <xsl:variable name="valuelists" select="document($layout-uri)/fml:FMPXMLLAYOUT/fml:VALUELISTS/fml:VALUELIST"/>, a variable "valuelists" is created. First, with the XPath function document(), the query in variable "layout-uri" is executed. An XML result tree of the layout contents in FMPXMLLAYOUT grammar is returned. The remain XPath part /fml:FMPXMLLAYOUT/fml:VALUELISTS/fml:VALUELIST selects from this tree all valuelists and their values. The result stored in the variable is a XML result tree fragment of all your valuelists.

And this leads to my question:

On your layout "Forms", are there valuelists that are populated from a related database? Has this related file the same user name/password combination as your database RFILog?

Then you should check the following things:

Is port 16014 blocked by a firewall?

In http://yourhost/fmi/config , does your database occur as enabled for XSLT web publishing?

If not, add the fmxslt extended privilege set within your database and also tick it in the Full Access privilege set. To be sure, that everything works, restart the web publishing and the web server.

Martin

Martin,

Thanks for the detailed reply. Yes, there are value lists from other related databases, as well as, value lists from within this database. All of the related databases have the same privileges and show up as being shared in the list of xml and xslt within the admin pages that shows the files being shared.

When I use IWP for this database, it works correctly. I am able to add a new record, and I am able to view all of the value lists. It is only when I try the xslt format that I get the error message.

I will check the port on the firewall, I did not know about that.

Also, my username is nonexistent, or empty in other words. I only use a password. This works well in FMP6 using CDML, and works in FMP7 in IWP. I only have this issue when using the xslt pages.

Thank you,

John C. Foster

Hmm. I strongly believe it must have to do with the name-password combination, otherwise it would not have spilled out this authenthication error.

Do all the databases have the same password?

Can it be that the URL is not correct if you just use a password?

It should be like:

http://:password@localhost:16014/fmi/xml/FMPXMLLAYOUT.xml? ....

(The colon before the password is needed according to RFC 1738)

Then you should add a name to your account. Or just try once with the guest account.

Martin

Got it!

I changed the username and passords for all the files, and was able to create a new record!

Strangely enough though, none of my auto-enter calculation, nor the auto-enter lookup fields work any more. I have to change them to calculation fields to get results. Have you experienced that before?

I apprecaite your help....it lead me down the right path to fix this...thanks a millions!

John C. Foster

Let me clarify that last post....

My auto-enter fields work in IWP, but they do not work in Custom Web Publishing. If I change them to calculation fields, they work in both.

Thanks again.