[prev in list] [next in list] [prev in thread] [next in thread]
List: packetfence-users
Subject: Re: [PacketFence-users] Node search is very slow from GUI on version 11.0.0
From: Arun Kangle via PacketFence-users <packetfence-users () lists ! sourceforge ! net>
Date: 2021-12-15 15:19:07
Message-ID: CAJR9SLF-MTtjKfQ-3dtcpQYL32OT5LSZr4cyStXJYcYOHfqX+Q () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Thanks a lot James. It worked. searches are blazing fast now.
- Arun
On Wed, Dec 15, 2021 at 7:47 PM Rouzier, James <jarouzie@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" <luzammi@akamai.com>
> *Cc: *Arun Kangle <akangle@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 <akangle@gmail.com> wrote:
>
> Hi Ludovic,
>
> Any update please?
>
>
>
> Thanks,
>
> - Arun
>
>
>
> On Wed, Dec 8, 2021 at 9:47 PM Arun Kangle <akangle@gmail.com> wrote:
>
> PFA,
>
> Thanks,
>
> - Arun
>
>
>
> On Wed, Dec 8, 2021 at 6:31 PM Zammit, Ludovic <luzammi@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:17192219 \
> 80826545898&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=r \
> esults_main__;!!GjvTz_vk!GsGPbgY1el1no3ouSWeG-lcz4LNwr-Qj_UXqYEsR9ZnGcXxWeuje1jrOrJRkKxdowA$>
>
>
>
> On Dec 7, 2021, at 11:01 PM, Arun Kangle <akangle@gmail.com> wrote:
>
>
>
> Hi Ludovic,
>
> could you please update on this?
>
>
>
> Thanks,
>
> - Arun
>
>
>
> On Sun, Dec 5, 2021 at 11:19 AM Arun Kangle <akangle@gmail.com> wrote:
>
> Hi Ludovic,
>
> Any update on this?
>
>
>
> Thanks in advance,
>
> - Arun
>
>
>
> On Fri, Dec 3, 2021 at 12:49 PM Arun Kangle <akangle@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 <akangle@gmail.com> wrote:
>
> Hello Ludovic,
>
> Any update on this please?
>
>
>
> Thanks,
>
> - Arun
>
>
>
> On Tue, Nov 23, 2021 at 7:19 PM Arun Kangle <akangle@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 <luzammi@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=r \
> esults_main__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9rM1iIeOw$>
>
>
>
> On Nov 23, 2021, at 4:55 AM, Arun Kangle <akangle@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 <luzammi@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=r \
> esults_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/packetfenc \
> e-users__;!!GjvTz_vk!CwoHzpvXlN9fV0uLrnxNT2yE9mFbVtRkEY47w_s_Jy7S2d8MsvI9Rd3HVEmQPA4Z$>
>
>
>
> <Screenshot 2021-11-23 at 3.20.39 PM.png>
>
>
>
>
>
>
[Attachment #5 (text/html)]
<div dir="ltr">Thanks a lot James. It worked. searches are blazing fast \
now.<div><br></div><div>- Arun</div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Wed, Dec 15, 2021 at 7:47 PM Rouzier, James <<a \
href="mailto:jarouzie@akamai.com">jarouzie@akamai.com</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-US" style="overflow-wrap: break-word;">
<div class="gmail-m_6518540582995783489WordSection1">
<p class="gmail-m_6518540582995783489MsoPlainText">Hi Arun,<br>
<br>
There is fix for this.<u></u><u></u></p>
<p class="gmail-m_6518540582995783489MsoPlainText">However it requires you to apply a \
patch manually as it cannot be applied through maintenance.<br> Since it requires an \
update to the database.<u></u><u></u></p> <p \
class="gmail-m_6518540582995783489MsoPlainText"><br> Copy the attached file \
node-online-query.patch to all of your servers to the PacketFence directory \
/usr/local/pf/<br> <br>
Then on each of your servers run the following commands<br>
cd /usr/local/pf/<u></u><u></u></p>
<p class="gmail-m_6518540582995783489MsoPlainText">patch -p1 < \
node-online-query.patch<u></u><u></u></p> <p \
class="gmail-m_6518540582995783489MsoPlainText">systemctl restart \
packetfence-pfperl-api<u></u><u></u></p> <p \
class="gmail-m_6518540582995783489MsoPlainText"><u></u> <u></u></p> <p \
class="gmail-m_6518540582995783489MsoPlainText"><br> Then run the following command \
on only one of your servers.<br> <br>
<u></u><u></u></p>
<p class="gmail-m_6518540582995783489MsoPlainText">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);"<u></u><u></u></p> <p class="MsoNormal"><br>
Let me know if this helps<br>
<br>
James<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt \
solid rgb(181,196,223);padding:3pt 0in 0in"> <p class="MsoNormal"><b><span \
style="font-size:12pt;color:black">From: </span></b><span \
style="font-size:12pt;color:black">Arun Kangle via PacketFence-users <<a \
href="mailto:packetfence-users@lists.sourceforge.net" \
target="_blank">packetfence-users@lists.sourceforge.net</a>><br> <b>Reply-To: \
</b>"<a href="mailto:packetfence-users@lists.sourceforge.net" \
target="_blank">packetfence-users@lists.sourceforge.net</a>" <<a \
href="mailto:packetfence-users@lists.sourceforge.net" \
target="_blank">packetfence-users@lists.sourceforge.net</a>><br> <b>Date: \
</b>Wednesday, December 15, 2021 at 8:49 AM<br> <b>To: </b>"Zammit, \
Ludovic" <<a href="mailto:luzammi@akamai.com" \
target="_blank">luzammi@akamai.com</a>><br> <b>Cc: </b>Arun Kangle <<a \
href="mailto:akangle@gmail.com" target="_blank">akangle@gmail.com</a>>, "<a \
href="mailto:packetfence-users@lists.sourceforge.net" \
target="_blank">packetfence-users@lists.sourceforge.net</a>" <<a \
href="mailto:packetfence-users@lists.sourceforge.net" \
target="_blank">packetfence-users@lists.sourceforge.net</a>><br> <b>Subject: \
</b>Re: [PacketFence-users] Node search is very slow from GUI on version \
11.0.0<u></u><u></u></span></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Hi Ludovic, <u></u><u></u></p>
<div>
<p class="MsoNormal">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.<u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">- Arun<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Mon, Dec 13, 2021 at 11:24 AM Arun Kangle <<a \
href="mailto:akangle@gmail.com" target="_blank">akangle@gmail.com</a>> \
wrote:<u></u><u></u></p> </div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt \
solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"> \
<div> <p class="MsoNormal">Hi Ludovic, <u></u><u></u></p>
<div>
<p class="MsoNormal">Any update please?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">- Arun<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Wed, Dec 8, 2021 at 9:47 PM Arun Kangle <<a \
href="mailto:akangle@gmail.com" target="_blank">akangle@gmail.com</a>> \
wrote:<u></u><u></u></p> </div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt \
solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"> \
<div> <p class="MsoNormal">PFA, <u></u><u></u></p>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">- Arun<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Wed, Dec 8, 2021 at 6:31 PM Zammit, Ludovic <<a \
href="mailto:luzammi@akamai.com" target="_blank">luzammi@akamai.com</a>> \
wrote:<u></u><u></u></p> </div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt \
solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"> \
<div> <p class="MsoNormal">Hello Arun, <u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Could you check in chrome developper tool how long the request \
takes?<u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">If you do Right click, Inspect and then \
Network.<u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Take a screenshot of that, it should look like this \
one:<u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><a \
href="https://mail.google.com/mail/?ui=2&ik=ab2ae5bb7a&attid=0.1&permmsgid \
=msg-f:1719221980826545898&th=17dbe7486135aeea&view=fimg&fur=ip&permms \
gid=msg-f:1719221980826545898&sz=s0-l75-ft&attbid=ANGjdJ-Fiu5FKnErWyXX9IdCVRU3 \
AZYyX4nqjHjnkWi5mZ9xc-h8gGi3NrXcCxXb52Ym58Es_47SRVY-Bc9ov8R1WP0DeU8DptCpLmdxXLsVHz9HvcHfIASAqVf_uBc&disp=emb&zw" \
target="_blank">PastedGraphic-1.tiff</a><u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<table border="0" cellspacing="0" cellpadding="0" width="360" style="width:3.75in">
<tbody>
<tr style="height:7.5pt">
<td colspan="3" valign="bottom" style="padding:0in 0in 4.5pt;height:7.5pt">
<p class="MsoNormal"><strong><span \
style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(0,153,204)">Ludovic \
Zammit</span></strong><span \
style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(0,153,204)"><br> \
</span><strong><span \
style="font-size:9pt;font-family:Arial,sans-serif;color:rgb(102,102,102)">Product \
Support Engineer Principal</span></strong><span \
style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(0,153,204)"><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td colspan="3" valign="bottom" style="padding:0in 0in 4.5pt">
<p class="MsoNormal"><span style="border:1pt solid windowtext;padding:0in"><img \
border="0" width="32" height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1045" alt="Image removed by \
sender."></span><u></u><u></u></p> </td>
</tr>
<tr>
<td colspan="2" valign="top" \
style="border-top:none;border-right:none;border-left:none;border-bottom:1pt solid \
rgb(143,145,148);padding:0in"> </td>
<td style="padding:0in"></td>
</tr>
<tr style="height:3.75pt">
<td valign="top" style="padding:4.5pt 0in 0in;height:3.75pt">
<p class="MsoNormal"><strong><span \
style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(51,51,51)">Cell:</span></strong><span \
style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(51,51,51)"> \
+1.613.670.8432</span><u></u><u></u></p> </td>
<td style="padding:4.5pt 0in 0in;height:3.75pt">
<p class="MsoNormal"><span \
style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(51,51,51)">Akamai \
Technologies - Inverse<br> 145 Broadway<br>
Cambridge, MA 02142</span><u></u><u></u></p>
</td>
<td style="padding:0in;height:3.75pt"></td>
</tr>
<tr style="height:5.25pt">
<td colspan="2" valign="top" style="background:white;padding:0in;height:5.25pt">
</td>
<td style="padding:0in;height:5.25pt"></td>
</tr>
<tr style="height:3.75pt">
<td width="148" style="width:111pt;padding:7.5pt 0in 0in;height:3.75pt">
<p class="MsoNormal"><span \
style="font-family:Arial,sans-serif;color:rgb(102,102,102)">Connect with \
Us:<u></u><u></u></span></p> </td>
<td width="222" style="width:166.5pt;padding:7.5pt 0in 0in 0.75pt;height:3.75pt">
<p class="MsoNormal"><a href="https://community.akamai.com/" target="_blank"><span \
style="color:windowtext;text-decoration:none"><span style="color:blue;border:1pt \
solid windowtext;padding:0in"><img border="0" width="32" height="32" style="width: \
0.3333in; height: 0.3333in;" id="gmail-m_6518540582995783489_x0000_i1044" alt="Image \
removed by sender."></span></span></a><a href="http://blogs.akamai.com/" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1043" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__https:/twitter.com/akamai__;!!GjvTz_vk!GsGPbgY1el1no3ouSWeG-lcz4LNwr-Qj_UXqYEsR9ZnGcXxWeuje1jrOrJTiEMBxlA$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1042" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__http:/www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!GsGPbgY1el1no3ouSWeG-lcz4LNwr-Qj_UXqYEsR9ZnGcXxWeuje1jrOrJQPXIsprQ$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1041" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__http:/www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!GsGPbgY1el1no3ouSWeG-lcz4LNwr-Qj_UXqYEsR9ZnGcXxWeuje1jrOrJSOO3d0fQ$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1040" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__http:/www.youtube.com/user/akamaitechnologies?featur \
e=results_main__;!!GjvTz_vk!GsGPbgY1el1no3ouSWeG-lcz4LNwr-Qj_UXqYEsR9ZnGcXxWeuje1jrOrJRkKxdowA$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1039" alt="Image removed by \
sender."></span></span></a><u></u><u></u></p> </td>
<td style="padding:0in;height:3.75pt"></td>
</tr>
</tbody>
</table>
</div>
<div>
<p class="MsoNormal"><span style="color:white"><br>
<br>
</span><u></u><u></u></p>
<blockquote style="margin-top:5pt;margin-bottom:5pt">
<div>
<p class="MsoNormal">On Dec 7, 2021, at 11:01 PM, Arun Kangle <<a \
href="mailto:akangle@gmail.com" target="_blank">akangle@gmail.com</a>> \
wrote:<u></u><u></u></p> </div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">Hi Ludovic,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">could you please update on this?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">- Arun<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Sun, Dec 5, 2021 at 11:19 AM Arun Kangle <<a \
href="mailto:akangle@gmail.com" target="_blank">akangle@gmail.com</a>> \
wrote:<u></u><u></u></p> </div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt \
solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"> \
<div> <p class="MsoNormal">Hi Ludovic, <u></u><u></u></p>
<div>
<p class="MsoNormal">Any update on this?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks in advance,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">- Arun<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Fri, Dec 3, 2021 at 12:49 PM Arun Kangle <<a \
href="mailto:akangle@gmail.com" target="_blank">akangle@gmail.com</a>> \
wrote:<u></u><u></u></p> </div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt \
solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"> \
<div> <p class="MsoNormal">Now I started getting the message "Request Failed \
with Status code 504" but i still can search users from "pfcmd" cli \
without any issue. <u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">- Arun<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Tue, Nov 30, 2021 at 7:42 AM Arun Kangle <<a \
href="mailto:akangle@gmail.com" target="_blank">akangle@gmail.com</a>> \
wrote:<u></u><u></u></p> </div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt \
solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"> \
<div> <p class="MsoNormal">Hello Ludovic, <u></u><u></u></p>
<div>
<p class="MsoNormal">Any update on this please?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">- Arun<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Tue, Nov 23, 2021 at 7:19 PM Arun Kangle <<a \
href="mailto:akangle@gmail.com" target="_blank">akangle@gmail.com</a>> \
wrote:<u></u><u></u></p> </div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt \
solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"> \
<div> <div>
<p class="MsoNormal">>>>select count(1) from node;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal">MariaDB [(none)]> use pf<br>
Reading table information for completion of table and column names<br>
You can turn off this feature to get a quicker startup with -A<br>
<br>
Database changed<br>
MariaDB [pf]> select count(1) from node;<br>
+----------+<br>
> count(1) |<br>
+----------+<br>
> 69 |<br>
+----------+<br>
1 row in set (0.000 sec)<br>
<br>
MariaDB [pf]><u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I am running it as a VM with 4 vCPU 16Gig RAM and 110GB \
Disk<u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">- Arun<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Tue, Nov 23, 2021 at 6:55 PM Zammit, Ludovic <<a \
href="mailto:luzammi@akamai.com" target="_blank">luzammi@akamai.com</a>> \
wrote:<u></u><u></u></p> </div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt \
solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"> \
<div> <p class="MsoNormal">Hello Arun, <u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">You can connect to the database and run that \
command:<u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">select count(1) from node;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">What are the specs on your servers? CPU, RAM and \
disk.<u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<table border="0" cellspacing="0" cellpadding="0" width="360" style="width:3.75in">
<tbody>
<tr style="height:7.5pt">
<td colspan="3" valign="bottom" style="padding:0in 0in 4.5pt;height:7.5pt">
<p class="MsoNormal"><strong><span \
style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(0,153,204)">Ludovic \
Zammit</span></strong><span \
style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(0,153,204)"><br> \
</span><strong><span \
style="font-size:9pt;font-family:Arial,sans-serif;color:rgb(102,102,102)">Product \
Support Engineer Principal</span></strong><span \
style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(0,153,204)"><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td colspan="3" valign="bottom" style="padding:0in 0in 4.5pt">
<p class="MsoNormal"><span style="border:1pt solid windowtext;padding:0in"><img \
border="0" width="32" height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1038" alt="Image removed by \
sender."></span><u></u><u></u></p> </td>
</tr>
<tr>
<td colspan="2" valign="top" \
style="border-top:none;border-right:none;border-left:none;border-bottom:1pt solid \
rgb(143,145,148);padding:0in"> </td>
<td style="padding:0in"></td>
</tr>
<tr style="height:3.75pt">
<td valign="top" style="padding:4.5pt 0in 0in;height:3.75pt">
<p class="MsoNormal"><strong><span \
style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(51,51,51)">Cell:</span></strong><span \
style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(51,51,51)"> \
+1.613.670.8432</span><u></u><u></u></p> </td>
<td style="padding:4.5pt 0in 0in;height:3.75pt">
<p class="MsoNormal"><span \
style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(51,51,51)">Akamai \
Technologies - Inverse<br> 145 Broadway<br>
Cambridge, MA 02142</span><u></u><u></u></p>
</td>
<td style="padding:0in;height:3.75pt"></td>
</tr>
<tr style="height:5.25pt">
<td colspan="2" valign="top" style="background:white;padding:0in;height:5.25pt">
</td>
<td style="padding:0in;height:5.25pt"></td>
</tr>
<tr style="height:3.75pt">
<td width="148" style="width:111pt;padding:7.5pt 0in 0in;height:3.75pt">
<p class="MsoNormal"><span \
style="font-family:Arial,sans-serif;color:rgb(102,102,102)">Connect with \
Us:<u></u><u></u></span></p> </td>
<td width="222" style="width:166.5pt;padding:7.5pt 0in 0in 0.75pt;height:3.75pt">
<p class="MsoNormal"><a href="https://community.akamai.com/" target="_blank"><span \
style="color:windowtext;text-decoration:none"><span style="color:blue;border:1pt \
solid windowtext;padding:0in"><img border="0" width="32" height="32" style="width: \
0.3333in; height: 0.3333in;" id="gmail-m_6518540582995783489_x0000_i1037" alt="Image \
removed by sender."></span></span></a><a href="http://blogs.akamai.com/" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1036" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__https:/twitter.com/akamai__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9pQVTNfdg$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1035" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__http:/www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9qpinO9Ug$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1034" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__http:/www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9rCO-SIfQ$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1033" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__http:/www.youtube.com/user/akamaitechnologies?featur \
e=results_main__;!!GjvTz_vk!AZoO76_2vQqb0uOBPnre8x7JSySxppIHZVDWWt6-wJyzwRkWJZwdC9rM1iIeOw$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1032" alt="Image removed by \
sender."></span></span></a><u></u><u></u></p> </td>
<td style="padding:0in;height:3.75pt"></td>
</tr>
</tbody>
</table>
</div>
<div>
<p class="MsoNormal"><span style="color:white"><br>
<br>
</span><u></u><u></u></p>
<blockquote style="margin-top:5pt;margin-bottom:5pt">
<div>
<p class="MsoNormal">On Nov 23, 2021, at 4:55 AM, Arun Kangle <<a \
href="mailto:akangle@gmail.com" target="_blank">akangle@gmail.com</a>> \
wrote:<u></u><u></u></p> </div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">Hi Ludovic, <u></u><u></u></p>
<div>
<p class="MsoNormal">PFA screenshot. It took around 32 Seconds to search that \
user.<u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">For total count, I am getting below error:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">root@aolicnac:~# /usr/local/pf/bin/pfcmd node count all<br>
Use of uninitialized value in join or string at \
/usr/local/pf/lib_perl/lib/perl5/SQL/Abstract/Classic.pm line 1386.<br> \
nb<u></u><u></u></p> </div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Mon, Nov 22, 2021 at 11:53 PM Zammit, Ludovic <<a \
href="mailto:luzammi@akamai.com" target="_blank">luzammi@akamai.com</a>> \
wrote:<u></u><u></u></p> </div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt \
solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"> \
<div> <p class="MsoNormal">Hello Arun, <u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">How many device you have in the database ?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Can you take a screenshot of your node search \
?<u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<table border="0" cellspacing="0" cellpadding="0" width="360" style="width:3.75in">
<tbody>
<tr style="height:7.5pt">
<td colspan="3" valign="bottom" style="padding:0in 0in 4.5pt;height:7.5pt">
<p class="MsoNormal"><strong><span \
style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(0,153,204)">Ludovic \
Zammit</span></strong><span \
style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(0,153,204)"><br> \
</span><strong><span \
style="font-size:9pt;font-family:Arial,sans-serif;color:rgb(102,102,102)">Product \
Support Engineer Principal</span></strong><span \
style="font-size:10.5pt;font-family:Arial,sans-serif;color:rgb(0,153,204)"><u></u><u></u></span></p>
</td>
</tr>
<tr>
<td colspan="3" valign="bottom" style="padding:0in 0in 4.5pt">
<p class="MsoNormal"><span style="border:1pt solid windowtext;padding:0in"><img \
border="0" width="32" height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1031" alt="Image removed by \
sender."></span><u></u><u></u></p> </td>
</tr>
<tr>
<td colspan="2" valign="top" \
style="border-top:none;border-right:none;border-left:none;border-bottom:1pt solid \
rgb(143,145,148);padding:0in"> </td>
<td style="padding:0in"></td>
</tr>
<tr style="height:3.75pt">
<td valign="top" style="padding:4.5pt 0in 0in;height:3.75pt">
<p class="MsoNormal"><strong><span \
style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(51,51,51)">Cell:</span></strong><span \
style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(51,51,51)"> \
+1.613.670.8432</span><u></u><u></u></p> </td>
<td style="padding:4.5pt 0in 0in;height:3.75pt">
<p class="MsoNormal"><span \
style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(51,51,51)">Akamai \
Technologies - Inverse<br> 145 Broadway<br>
Cambridge, MA 02142</span><u></u><u></u></p>
</td>
<td style="padding:0in;height:3.75pt"></td>
</tr>
<tr style="height:5.25pt">
<td colspan="2" valign="top" style="background:white;padding:0in;height:5.25pt">
</td>
<td style="padding:0in;height:5.25pt"></td>
</tr>
<tr style="height:3.75pt">
<td width="148" style="width:111pt;padding:7.5pt 0in 0in;height:3.75pt">
<p class="MsoNormal"><span \
style="font-family:Arial,sans-serif;color:rgb(102,102,102)">Connect with \
Us:<u></u><u></u></span></p> </td>
<td width="222" style="width:166.5pt;padding:7.5pt 0in 0in 0.75pt;height:3.75pt">
<p class="MsoNormal"><a href="https://community.akamai.com/" target="_blank"><span \
style="color:windowtext;text-decoration:none"><span style="color:blue;border:1pt \
solid windowtext;padding:0in"><img border="0" width="32" height="32" style="width: \
0.3333in; height: 0.3333in;" id="gmail-m_6518540582995783489_x0000_i1030" alt="Image \
removed by sender."></span></span></a><a href="http://blogs.akamai.com/" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1029" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__https:/twitter.com/akamai__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3UfK2klThA$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1028" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__http:/www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3Uf1yplVhg$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1027" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__http:/www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3UfyTDbOew$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1026" alt="Image removed by \
sender."></span></span></a><a \
href="https://urldefense.com/v3/__http:/www.youtube.com/user/akamaitechnologies?featur \
e=results_main__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3Uf4YbWArw$" \
target="_blank"><span style="color:windowtext;text-decoration:none"><span \
style="color:blue;border:1pt solid windowtext;padding:0in"><img border="0" width="32" \
height="32" style="width: 0.3333in; height: 0.3333in;" \
id="gmail-m_6518540582995783489_x0000_i1025" alt="Image removed by \
sender."></span></span></a><u></u><u></u></p> </td>
<td style="padding:0in;height:3.75pt"></td>
</tr>
</tbody>
</table>
</div>
<div>
<p class="MsoNormal"><span style="color:white"><br>
<br>
</span><u></u><u></u></p>
<blockquote style="margin-top:5pt;margin-bottom:5pt">
<div>
<p class="MsoNormal">On Nov 19, 2021, at 1:23 AM, Arun Kangle via PacketFence-users \
<<a href="mailto:packetfence-users@lists.sourceforge.net" \
target="_blank">packetfence-users@lists.sourceforge.net</a>> \
wrote:<u></u><u></u></p> </div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">Hello All,<u></u><u></u></p>
<div>
<p class="MsoNormal">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.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Search is faster from CLI using the pfcmd \
command.<u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Has anyone else faced this problem? If yes, any pointers on how \
to make it fast?<u></u><u></u></p> </div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">root@aolicnac:/usr/local/pf/bin# cat /etc/debian_version<br>
11.1<br>
root@aolicnac:/usr/local/pf/bin# ./pfcmd version<br>
PacketFence 11.1.0<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks in advance,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">- Arun<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
PacketFence-users mailing list<br>
<a href="mailto:PacketFence-users@lists.sourceforge.net" \
target="_blank">PacketFence-users@lists.sourceforge.net</a><br> <a \
href="https://urldefense.com/v3/__https:/lists.sourceforge.net/lists/listinfo/packetfe \
nce-users__;!!GjvTz_vk!CwoHzpvXlN9fV0uLrnxNT2yE9mFbVtRkEY47w_s_Jy7S2d8MsvI9Rd3HVEmQPA4Z$" \
target="_blank">https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listin \
fo/packetfence-users__;!!GjvTz_vk!CwoHzpvXlN9fV0uLrnxNT2yE9mFbVtRkEY47w_s_Jy7S2d8MsvI9Rd3HVEmQPA4Z$</a>
<u></u><u></u></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><Screenshot 2021-11-23 at 3.20.39 \
PM.png><u></u><u></u></p> </div>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</div>
</blockquote></div>
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic