[FX.php List] Revisiting Execute XML error

[Chris Hansen]

Anders,

SetDBPassword() has the parameters reversed for historical reasons  
(since prior to FM7, FileMaker only used passwords...)  If you'd like  
a function with a more traditional order, try SetDBUserPass().  I  
really need to get some more example code in the distribution...  HTH

--Chris

On Oct 17, 2008, at 8:28 AM, Anders Monsen wrote:

> 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
>>
>>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>