[FX.php List] Revisiting Execute XML error

[Anders Monsen]

Chris,

No, I think it was just habit on my part that caused me to slip up  
here. I did not know about the SetDBUserPass() function, though. I may  
start using this in the future. I think what threw me with this error  
is that it was not very clear that the sequence was the issue. Instead  
I thought it related to the migration from Server 8 to 9.

Thanks,
Anders

On Oct 17, 2008, at 9:51 AM, Chris Hansen wrote:

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