[FX.php List] Revisiting Execute XML error

[Anders Monsen]

I can't speak to whether that is trouble or not, but it was something  
I found when looking for this error via Google.

However, when going through the result array line by line I believe I  
found a possible cause.

Two of the accounts I tried had been created with the same username  
and password. When I changed the password to something different, or  
created a new account, the connection broke because I had switched the  
username and password sequence in the function. I took my  
authentication method from a MySQL solution I created a while back,  
but did not change the sequence to match the proper sequence:

	$fmConnection = new FX($serverIP, $webCompanionPort);
	$fmConnection->SetDBData($dbName, $layout');

	$fmConnection->SetDBPassword($_POST['password'],  
$_POST['username'] ); <-- hey, now it works...


Mea culpa. Since the tool mentioned above relies on a form where you  
enter the username and password, the proper sequence is correct there.  
I had the sequence correct elsewhere in the page, but this never  
cropped up in testing as I used the account and password provided to  
me, which in both cases were identical.

Thanks,
Anders

On Oct 17, 2008, at 9:11 AM, Gjermund Gusland Thorsen wrote:

> Ehh, FMWebSchool TroubleShooting Tool??
>
> That is trouble by itself AFAIK...
>
> ggt
>
> 2008/10/17 Anders Monsen <andersm at alamark.com>:
>> Well, I tried the FMWebSchool TroubleShooting Tool with the  
>> password that
>> was rejected, and it seemed to return a valid result. However, my  
>> attempts
>> to log in with new account names or altered passwords still fails,  
>> so it
>> must be in how I am logging in that causes the issue, not the  
>> version of
>> FileMaker Server.
>>
>> Anders
>>
>>
>> On Oct 16, 2008, at 5:23 PM, Gjermund Gusland Thorsen wrote:
>>
>>> New issues in 9?
>>>
>>> ggt
>>>
>>> 2008/10/16 Anders Monsen <andersm at alamark.com>:
>>>>
>>>> When changing the password to an account that works, or creating  
>>>> a new
>>>> account with the XML extended privilege set, I started getting the
>>>> "ExecuteQuery XML error: mismatched tag at line 6"
>>>>
>>>> Does the FileMaker server need to be restarted when updating an  
>>>> account
>>>> or
>>>> adding an account in order to connect? I don't seem to have that  
>>>> issue
>>>> before, although the customer just upgraded from FMSA 8 to FMSA 9.
>>>>
>>>> Thanks,
>>>> Anders Monsen
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>>>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>