Thanks a lot James. It worked. searches are blazing fast now. - Arun
On Wed, Dec 15, 2021 at 7:47 PM Rouzier, James <jarou...@akamai.com> wrote: > Hi Arun, > > There is fix for this. > > However it requires you to apply a patch manually as it cannot be applied > through maintenance. > Since it requires an update to the database. > > > Copy the attached file node-online-query.patch to all of your servers to > the PacketFence directory /usr/local/pf/ > > Then on each of your servers run the following commands > cd /usr/local/pf/ > > patch -p1 < node-online-query.patch > > systemctl restart packetfence-pfperl-api > > > > > Then run the following command on only one of your servers. > > mysql -uroot -p pf -e "ALTER TABLE bandwidth_accounting DROP INDEX IF > EXISTS bandwidth_accounting_tenant_id_mac, ADD INDEX > bandwidth_accounting_tenant_id_mac_last_updated (tenant_id, mac, > last_updated);" > > > Let me know if this helps > > James > > > > *From: *Arun Kangle via PacketFence-users < > packetfence-users@lists.sourceforge.net> > *Reply-To: *"packetfence-users@lists.sourceforge.net" < > packetfence-users@lists.sourceforge.net> > *Date: *Wednesday, December 15, 2021 at 8:49 AM > *To: *"Zammit, Ludovic" <luza...@akamai.com> > *Cc: *Arun Kangle <akan...@gmail.com>, " > packetfence-users@lists.sourceforge.net" < > packetfence-users@lists.sourceforge.net> > *Subject: *Re: [PacketFence-users] Node search is very slow from GUI on > version 11.0.0 > > > > 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 <akan...@gmail.com> wrote: > > Hi Ludovic, > > Any update please? > > > > Thanks, > > - Arun > > > > On Wed, Dec 8, 2021 at 9:47 PM Arun Kangle <akan...@gmail.com> wrote: > > PFA, > > Thanks, > > - Arun > > > > On Wed, Dec 8, 2021 at 6:31 PM Zammit, Ludovic <luza...@akamai.com> 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: > > > > PastedGraphic-1.tiff > <https://mail.google.com/mail/?ui=2&ik=ab2ae5bb7a&attid=0.1&permmsgid=msg-f:1719221980826545898&th=17dbe7486135aeea&view=fimg&fur=ip&permmsgid=msg-f:1719221980826545898&sz=s0-l75-ft&attbid=ANGjdJ-Fiu5FKnErWyXX9IdCVRU3AZYyX4nqjHjnkWi5mZ9xc-h8gGi3NrXcCxXb52Ym58Es_47SRVY-Bc9ov8R1WP0DeU8DptCpLmdxXLsVHz9HvcHfIASAqVf_uBc&disp=emb&zw> > > > > Thanks, > > > > *Ludovic Zammit* > *Product Support Engineer Principal* > > [image: Image removed by sender.] > > *Cell:* +1.613.670.8432 > > Akamai Technologies - Inverse > 145 Broadway > Cambridge, MA 02142 > > Connect with Us: > > [image: Image removed by sender.] <https://community.akamai.com/>[image: > Image removed by sender.] <http://blogs.akamai.com/>[image: Image removed > by sender.] > <https://urldefense.com/v3/__https:/twitter.com/akamai__;!!GjvTz_vk!GsGPbgY1el1no3ouSWeG-lcz4LNwr-Qj_UXqYEsR9ZnGcXxWeuje1jrOrJTiEMBxlA$>[image: > Image removed by sender.] > <https://urldefense.com/v3/__http:/www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!GsGPbgY1el1no3ouSWeG-lcz4LNwr-Qj_UXqYEsR9ZnGcXxWeuje1jrOrJQPXIsprQ$>[image: > Image removed by sender.] > <https://urldefense.com/v3/__http:/www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!GsGPbgY1el1no3ouSWeG-lcz4LNwr-Qj_UXqYEsR9ZnGcXxWeuje1jrOrJSOO3d0fQ$>[image: > Image removed by sender.] > <https://urldefense.com/v3/__http:/www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!GsGPbgY1el1no3ouSWeG-lcz4LNwr-Qj_UXqYEsR9ZnGcXxWeuje1jrOrJRkKxdowA$> > > > > On Dec 7, 2021, at 11:01 PM, Arun Kangle <akan...@gmail.com> wrote: > > > > 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* > > [image: Image removed by sender.] > > *Cell:* +1.613.670.8432 > > Akamai Technologies - Inverse > 145 Broadway > Cambridge, MA 02142 > > Connect with Us: > > [image: Image removed by sender.] <https://community.akamai.com/>[image: > Image removed by sender.] <http://blogs.akamai.com/>[image: Image removed > by sender.] > <https://urldefense.com/v3/__https:/twitter.com/akamai__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9pQVTNfdg$>[image: > Image removed by sender.] > <https://urldefense.com/v3/__http:/www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9qpinO9Ug$>[image: > Image removed by sender.] > <https://urldefense.com/v3/__http:/www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9rCO-SIfQ$>[image: > Image removed by sender.] > <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 <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* > > [image: Image removed by sender.] > > *Cell:* +1.613.670.8432 > > Akamai Technologies - Inverse > 145 Broadway > Cambridge, MA 02142 > > Connect with Us: > > [image: Image removed by sender.] <https://community.akamai.com/>[image: > Image removed by sender.] <http://blogs.akamai.com/>[image: Image removed > by sender.] > <https://urldefense.com/v3/__https:/twitter.com/akamai__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3UfK2klThA$>[image: > Image removed by sender.] > <https://urldefense.com/v3/__http:/www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3Uf1yplVhg$>[image: > Image removed by sender.] > <https://urldefense.com/v3/__http:/www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3UfyTDbOew$>[image: > Image removed by sender.] > <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$ > <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
