Hi Ludovic, could you please update on this? Thanks, - Arun
On Sun, Dec 5, 2021 at 11:19 AM Arun Kangle <akan...@gmail.com> wrote: > Hi Ludovic, > Any update on this? > > Thanks in advance, > - Arun > > On Fri, Dec 3, 2021 at 12:49 PM Arun Kangle <akan...@gmail.com> 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 <akan...@gmail.com> wrote: >> >>> Hello Ludovic, >>> Any update on this please? >>> >>> Thanks, >>> - Arun >>> >>> On Tue, Nov 23, 2021 at 7:19 PM Arun Kangle <akan...@gmail.com> 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 <luza...@akamai.com> >>>> 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://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 Nov 23, 2021, at 4:55 AM, Arun Kangle <akan...@gmail.com> 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 <luza...@akamai.com> >>>>> 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 < >>>>>> packetfence-users@lists.sourceforge.net> 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 >>>>>> PacketFence-users@lists.sourceforge.net >>>>>> >>>>>> 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> >>>>> >>>>> >>>>>
_______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
