Hi Ludovic, Any update on this? Thanks in advance, - Arun
On Fri, Dec 3, 2021 at 12:49 PM Arun Kangle <[email protected]> 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 <[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
