call fm script from php.fx

[dmaxj]

I am having a problem calling a script from php fx. I am following the docs to the letter - at least I think so.

I am running FM6 Pro on WinXP. I am wondering if there are any privileges that I need to set on FM6 Pro in order to allow scripts to be called from the web. Any clues -

$findQuery = new FX($Server, $Port) ;

$findQuery->SetDBData("table", "layout") ;

$findQuery->SetDBPassword("pass") ;

$findQuery->AddDBParam("-script","script1") ;

Am I missing something?

[dmaxj]

Are there any settings in the FM database application that need to be addressed in order for scripts to be executed/called from PHP...

Thanks!

[Garry Claridge]

Does the User have "permission" to run Scripts from the web?

Garry

[dmaxj]

I guess not - how could I go about checking this? I do have an admin password on the whole database, but nothing is mentioned in the phpfx docs. In addition, I am able to perform finds on the database and get a result...

So, I would think that scripts would operate under the same defined privilege set.

How could I check- thanks...

[Garry Claridge]

That is probably OK.

Do the Scripts contain only "web compatible" steps?

Garry

[dmaxj]

The script contains:

Goto Layout

Perform Find

Export Records(no Dialog)

This is a stored find script that exports its results to a shared drive on the network.

[mlindal]

Back to Gary's question:

In your web security databases, do you have 'perform scripts' checked in the database table you are accessing.

Also make sure at the end you have:

$findQueryResult=$findQuery->FMFind() ;

[dmaxj]

I have been trying to enable the Web Security Databases options under Edit->Preferences->Application->PlugIns->Web Companion->Configure...

However, only the Filemaker Pro Access Privileges radio button can be selected. Please advise as to how I enable the Web Security Databases option...

Thanks

[mlindal]

You need to open the web security databases. They should be in a folder called Web Security / Databases

When you open them up the default setup is to turn All databases, and All Users to no privileges

You then create a new record where you can allow All Users Browse, and Scripts privileges. etc.