Hi,

We have FM server 11 advanced installed on Windows 2008 Standard R2 server with IIS7. We want to access the FM database from PHP using external authentication. Here are setup we have done

1. Created groups and users on computer. Associated users and groups

2. Created accounts in fp7 file hosted on fmserver for group names created in step 1.

3. Enabled the FM server to allow client authentication by external accounts.

We can access the fp7 database from FM pro with external authentication (users created in step1). But when we run php page, which access same database with same user credentials, it gives error - 22: unknown error.

Are we missing any settings? What all configurations we should check?

Thanks in advance.

You will not get Single Sign On with this arrangement, but the Accounts should still authenticate. Is PHP calling a credentials entry box for you?

Let me make an inquiry here and see what I can discover.

Steven

Hi Steven,

PHP page is not calling credentials entry box. I am passing the login credentials (username/password) as parameters to database connection call using FM php API.

here is php code-

require_once("FileMaker.php");

$connection =& new FileMaker($database ="DBFilename");

$connection->setProperty('hostspec', 'localhost');

$connection->setProperty('username', 'test');

$connection->setProperty('password', 'test');

//Search the database .

$srch = $connection->newFindAllCommand('webConnection');

$result = $srch->execute();

if (FileMaker::isError($resultDeposit))

{

echo "error code ".$result->getCode();

echo "error ".$result->getErrorString();

}

else

{

$records = $result->getRecords();

$record = $records[0];

echo "".$record->getField('field1')."
";

}

here is reference link we followed (windows setup) - http://www.soliantconsulting.com/blog/2009/02/using-local-os-accounts-for-filemaker-external-authentication/

Thank you

I simply don't see how this would work. But contact Soliant and ask them maybe. They are clever lads and they may have a way to do this.

Steven