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 <[email protected]> wrote: > Hello Ludovic, > Any update on this please? > > Thanks, > - Arun > > On Tue, Nov 23, 2021 at 7:19 PM Arun Kangle <[email protected]> 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 <[email protected]> >> 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 <[email protected]> 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 <[email protected]> >>> 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 < >>>> [email protected]> 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 >>>> [email protected] >>>> >>>> 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 [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
