Re: [PacketFence-users] Node search is very slow from GUI on version 11.0.0

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi Ludovic,
Now I have started getting the "Request Failed with status code 504"
message every time I search for the node. Screenshot attached. Please help
on this.

Thanks,
- Arun

On Mon, Dec 13, 2021 at 11:24 AM Arun Kangle <ak...@gm...> wrote:

> Hi Ludovic,
> Any update please?
>
> Thanks,
> - Arun
>
> On Wed, Dec 8, 2021 at 9:47 PM Arun Kangle <ak...@gm...> wrote:
>
>> PFA,
>> Thanks,
>> - Arun
>>
>> On Wed, Dec 8, 2021 at 6:31 PM Zammit, Ludovic <lu...@ak...>
>> wrote:
>>
>>> Hello Arun,
>>>
>>> Could you check in chrome developper tool how long the request takes?
>>>
>>> If you do Right click, Inspect and then Network.
>>>
>>> Take a screenshot of that, it should look like this one:
>>>
>>>
>>> Thanks,
>>>
>>> *Ludovic Zammit*
>>> *Product Support Engineer Principal*
>>> *Cell:* +1.613.670.8432
>>> Akamai Technologies - Inverse
>>> 145 Broadway
>>> Cambridge, MA 02142
>>> Connect with Us: <https://community.akamai.com>
>>> <http://blogs.akamai.com> <https://twitter.com/akamai>
>>> <http://www.facebook.com/AkamaiTechnologies>
>>> <http://www.linkedin.com/company/akamai-technologies>
>>> <http://www.youtube.com/user/akamaitechnologies?feature=results_main>
>>>
>>> On Dec 7, 2021, at 11:01 PM, Arun Kangle <ak...@gm...> wrote:
>>>
>>> Hi Ludovic,
>>> could you please update on this?
>>>
>>> Thanks,
>>> - Arun
>>>
>>> On Sun, Dec 5, 2021 at 11:19 AM Arun Kangle <ak...@gm...> wrote:
>>>
>>>> Hi Ludovic,
>>>> Any update on this?
>>>>
>>>> Thanks in advance,
>>>> - Arun
>>>>
>>>> On Fri, Dec 3, 2021 at 12:49 PM Arun Kangle <ak...@gm...> wrote:
>>>>
>>>>> Now I started getting the message "Request Failed with Status code
>>>>> 504" but i still can search users from "pfcmd" cli without any issue.
>>>>>
>>>>> Thanks,
>>>>> - Arun
>>>>>
>>>>> On Tue, Nov 30, 2021 at 7:42 AM Arun Kangle <ak...@gm...> wrote:
>>>>>
>>>>>> Hello Ludovic,
>>>>>> Any update on this please?
>>>>>>
>>>>>> Thanks,
>>>>>> - Arun
>>>>>>
>>>>>> On Tue, Nov 23, 2021 at 7:19 PM Arun Kangle <ak...@gm...>
>>>>>> wrote:
>>>>>>
>>>>>>> >>>select count(1) from node;
>>>>>>>
>>>>>>> MariaDB [(none)]> use pf
>>>>>>> Reading table information for completion of table and column names
>>>>>>> You can turn off this feature to get a quicker startup with -A
>>>>>>>
>>>>>>> Database changed
>>>>>>> MariaDB [pf]> select count(1) from node;
>>>>>>> +----------+
>>>>>>> | count(1) |
>>>>>>> +----------+
>>>>>>> |       69 |
>>>>>>> +----------+
>>>>>>> 1 row in set (0.000 sec)
>>>>>>>
>>>>>>> MariaDB [pf]>
>>>>>>>
>>>>>>> I am running it as a VM with 4 vCPU 16Gig RAM and 110GB Disk
>>>>>>>
>>>>>>> Thanks,
>>>>>>> - Arun
>>>>>>>
>>>>>>> On Tue, Nov 23, 2021 at 6:55 PM Zammit, Ludovic <lu...@ak...>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hello Arun,
>>>>>>>>
>>>>>>>> You can connect to the database and run that command:
>>>>>>>>
>>>>>>>> select count(1) from node;
>>>>>>>>
>>>>>>>> What are the specs on your servers? CPU, RAM and disk.
>>>>>>>>
>>>>>>>> Thanks,
>>>>>>>>
>>>>>>>> *Ludovic Zammit*
>>>>>>>> *Product Support Engineer Principal*
>>>>>>>> *Cell:* +1.613.670.8432
>>>>>>>> Akamai Technologies - Inverse
>>>>>>>> 145 Broadway
>>>>>>>> Cambridge, MA 02142
>>>>>>>> Connect with Us: <https://community.akamai.com/>
>>>>>>>> <http://blogs.akamai.com/>
>>>>>>>> <https://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9pQVTNfdg$>
>>>>>>>> <https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9qpinO9Ug$>
>>>>>>>> <https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9rCO-SIfQ$>
>>>>>>>> <https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9rM1iIeOw$>
>>>>>>>>
>>>>>>>> On Nov 23, 2021, at 4:55 AM, Arun Kangle <ak...@gm...> wrote:
>>>>>>>>
>>>>>>>> Hi Ludovic,
>>>>>>>> PFA screenshot. It took around 32 Seconds to search that user.
>>>>>>>>
>>>>>>>> For total count, I am getting below error:
>>>>>>>>
>>>>>>>> root@aolicnac:~# /usr/local/pf/bin/pfcmd node count all
>>>>>>>> Use of uninitialized value in join or string at
>>>>>>>> /usr/local/pf/lib_perl/lib/perl5/SQL/Abstract/Classic.pm line 1386.
>>>>>>>> nb
>>>>>>>>
>>>>>>>> On Mon, Nov 22, 2021 at 11:53 PM Zammit, Ludovic <
>>>>>>>> lu...@ak...> wrote:
>>>>>>>>
>>>>>>>>> Hello Arun,
>>>>>>>>>
>>>>>>>>> How many device you have in the database ?
>>>>>>>>>
>>>>>>>>> Can you take a screenshot of your node search ?
>>>>>>>>>
>>>>>>>>> Thanks,
>>>>>>>>>
>>>>>>>>> *Ludovic Zammit*
>>>>>>>>> *Product Support Engineer Principal*
>>>>>>>>> *Cell:* +1.613.670.8432
>>>>>>>>> Akamai Technologies - Inverse
>>>>>>>>> 145 Broadway
>>>>>>>>> Cambridge, MA 02142
>>>>>>>>> Connect with Us: <https://community.akamai.com/>
>>>>>>>>> <http://blogs.akamai.com/>
>>>>>>>>> <https://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3UfK2klThA$>
>>>>>>>>> <https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3Uf1yplVhg$>
>>>>>>>>> <https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3UfyTDbOew$>
>>>>>>>>> <https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3Uf4YbWArw$>
>>>>>>>>>
>>>>>>>>> On Nov 19, 2021, at 1:23 AM, Arun Kangle via PacketFence-users <
>>>>>>>>> pac...@li...> wrote:
>>>>>>>>>
>>>>>>>>> Hello All,
>>>>>>>>> I recently upgraded to 11.0.0 (now to 11.1.0) from 10.3.0. Upgrade
>>>>>>>>> went fine and everything else works fine but Node search has become very
>>>>>>>>> slow. The first page (row length set to 10) itself takes very long and then
>>>>>>>>> equal long time to make any other search.
>>>>>>>>>
>>>>>>>>> Search is faster from CLI using the pfcmd command.
>>>>>>>>>
>>>>>>>>> Has anyone else faced this problem? If yes, any pointers on how to
>>>>>>>>> make it fast?
>>>>>>>>>
>>>>>>>>> root@aolicnac:/usr/local/pf/bin# cat /etc/debian_version
>>>>>>>>> 11.1
>>>>>>>>> root@aolicnac:/usr/local/pf/bin# ./pfcmd version
>>>>>>>>> PacketFence 11.1.0
>>>>>>>>>
>>>>>>>>> Thanks in advance,
>>>>>>>>> - Arun
>>>>>>>>> _______________________________________________
>>>>>>>>> PacketFence-users mailing list
>>>>>>>>> Pac...@li...
>>>>>>>>>
>>>>>>>>> https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!CwoHzpvXlN9fV0uLrnxNT2yE9mFbVtRkEY47w_s_Jy7S2d8MsvI9Rd3HVEmQPA4Z$
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> <Screenshot 2021-11-23 at 3.20.39 PM.png>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>