[FX.php List] FMS 10 setting up XML returns sometimes empty record sets, and sometimes fields and data working

[Leo R. Lundgren]

I used tcpdump to sniff the traffic coming from the server in relation  
to the find command issued by my FM PHP API.

I do not know what's causing this, as it's only happened twice and I  
haven't been able to reproduce it in any way. So far my efforts have  
been mostly concentrated around isolating the issue and trying to see  
a pattern in when/why it "solves itself".
My feeling so far about this is that it's a problem with something  
relating to permissions, since that is what I've been affecting as the  
only thing, the times it's happened to me. Of course it could come  
from external circumstances such as disk problems on the server, but  
since the data we can't see over XML/WPE *does* show in FM itself, the  
data is really there. And once we poke the privileges a bit (or  
possible the WPE, considering your experiences) it starts working, at  
least for me.

Well, I'm kind of waiting for it to happen again, to see where that  
takes us.


19 okt 2009 kl. 16.05 skrev Gjermund Gusland Thorsen:

> Well php I know somewhat well, FMS logs are not that easily accessible
> or debugable...
>
> Any clue to what might go wrong? Would sniffing the WPE reveal the
> actual problem? tshark and perhaps netcat to see what is going on?
>
> ggt
>
> 2009/10/19 Leo R. Lundgren <leo at finalresort.org>:
>> Well, the times I've had these problems, it's been with FM PHP API,  
>> so I
>> don't think it's a problem with the PHP part.
>>
>> I recall checking the XML output from a problematic search, and  
>> indeed the
>> actual data stream said that there were no record. This means the  
>> problem is
>> upstreams and not on the PHP side of the solution.
>>
>>
>> 19 okt 2009 kl. 15.56 skrev Gjermund Gusland Thorsen:
>>
>>> The sad thing though... is that fmphp works :-(...
>>>
>>> ggt
>>>
>>> 2009/10/19 Gjermund Gusland Thorsen <ggt667 at gmail.com>:
>>>>
>>>> Yes, they are in FM, on the web I even try to use FMFindAny, in  
>>>> FX and
>>>> -findany using curl on commandline.
>>>>
>>>> This time around saving privs did not make a difference :-(
>>>>
>>>> ggt
>>>>
>>>> 2009/10/19 Leo R. Lundgren <leo at finalresort.org>:
>>>>>
>>>>> Have you looked in the database using the normal FM GUI, and seen
>>>>> whether
>>>>> the records that you cannot find via XML are visible in the  
>>>>> database
>>>>> like
>>>>> they should?
>>>>>
>>>>> 19 okt 2009 kl. 15.51 skrev Gjermund Gusland Thorsen:
>>>>>
>>>>>> My experience with this on this one server is that it works for  
>>>>>> about
>>>>>> 50 queries then starts serving _ONE_ blank record.
>>>>>>
>>>>>> And it does not matter whether you set privs again or relaunching
>>>>>> WPE...
>>>>>>
>>>>>> ggt
>>>>>>
>>>>>> 19 okt 2009 kl. 15.44 skrev Leo R. Lundgren:
>>>>>>
>>>>>>> Do you mean that relaunching WPE (by disabling IWP for that  
>>>>>>> database
>>>>>>> in
>>>>>>> the databases pane in FM Admin?) gives the same effect as  
>>>>>>> "touching"
>>>>>>> the
>>>>>>> permissions, i.e that the records start being visible again,  
>>>>>>> but only
>>>>>>> for a
>>>>>>> little while?
>>>>>>>
>>>>>>> The last time this happened for me was a while ago and before  
>>>>>>> that it
>>>>>>> was
>>>>>>> a while ago as well. It doesn't happen very often, it's  
>>>>>>> measured in a
>>>>>>> number
>>>>>>> of months between times. Overall I think it's happened only  
>>>>>>> two times
>>>>>>> for
>>>>>>> something that's been running for a couple of years.
>>>>>>>
>>>>>>> That being said, it might still have happened at times when  
>>>>>>> neither I
>>>>>>> nor
>>>>>>> the client was looking. But considering that I haven't been  
>>>>>>> able to
>>>>>>> get rid
>>>>>>> of the problem without taking action, after a few hours of  
>>>>>>> almost
>>>>>>> fruitless
>>>>>>> debugging, it feels more likely that it hasn't happened  
>>>>>>> without us
>>>>>>> noticing
>>>>>>> it.
>>>>>>>
>>>>>>> 19 okt 2009 kl. 15.33 skrev Gjermund Gusland Thorsen:
>>>>>>>
>>>>>>>> You are right, this works.
>>>>>>>>
>>>>>>>> I will give you feed back on whether or not it stays like  
>>>>>>>> this, I
>>>>>>>> mean
>>>>>>>> relaunching WPE gives the same effect for a while.
>>>>>>>>
>>>>>>>> tia,
>>>>>>>> ggt
>>>>>>>>
>>>>>>>> 2009/10/19 Leo R. Lundgren <leo at finalresort.org>:
>>>>>>>>>
>>>>>>>>> 19 okt 2009 kl. 14.56 skrev Gjermund Gusland Thorsen:
>>>>>>>>>
>>>>>>>>>> Anyone experienced this?
>>>>>>>>>>
>>>>>>>>>> http://pastebin.com/f7d504cc4
>>>>>>>>>>
>>>>>>>>>> foundCount = 0
>>>>>>>>>> ErrorCode = 0 and not 401...
>>>>>>>>>>
>>>>>>>>>> all fields are supposedly empty.
>>>>>>>>>
>>>>>>>>> Hi,
>>>>>>>>>
>>>>>>>>> Before I delve into explaining my similar experiences, do  
>>>>>>>>> you still
>>>>>>>>> have the
>>>>>>>>> same problem? If so, does it help if you go into the  
>>>>>>>>> permissions for
>>>>>>>>> the
>>>>>>>>> user/group that the user belongs to, and change something,  
>>>>>>>>> so that
>>>>>>>>> the
>>>>>>>>> privileges are updated. Note that I don't mean you must change
>>>>>>>>> something
>>>>>>>>> that actually matters, do whatever little change is needed  
>>>>>>>>> to be
>>>>>>>>> able
>>>>>>>>> to
>>>>>>>>> "OK" and save the new permissions, then change it back to  
>>>>>>>>> what it
>>>>>>>>> originally
>>>>>>>>> was. Just to see if the problem goes away when the  
>>>>>>>>> permissions are
>>>>>>>>> definately updated at least once.
>>>>>
>>>>>
>>>>> -|
>>>>>
>>>>> _______________________________________________
>>>>> 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



-|