Without restarting the database restart, my server load spikes up and pf
screams to a halt.
Radius accounting is now working. Didn't touch a thing. I think it just
needed a week of information to start displaying data.
This is what the mysqlreport looks like before mysql is restarted (When the
server load is high):
__ Key _________________________________________________________________
Buffer used 5.00k of 16.00M %Used: 0.03
Current 2.92M %Usage: 18.27
Write hit 0.00%
Read hit 90.74%
__ Questions ___________________________________________________________
Total 159.71k 2.3/s
QC Hits 101.16k 1.5/s %Total: 63.34
DMS 56.27k 0.8/s 35.23
Com_ 16.46k 0.2/s 10.31
-Unknown 14.86k 0.2/s 9.31
COM_QUIT 680 0.0/s 0.43
Slow 500 ms 404 0.0/s 0.25 %DMS: 0.72 Log: ON
DMS 56.27k 0.8/s 35.23
SELECT 35.19k 0.5/s 22.04 62.55
UPDATE 13.45k 0.2/s 8.42 23.90
INSERT 7.47k 0.1/s 4.67 13.27
REPLACE 118 0.0/s 0.07 0.21
DELETE 45 0.0/s 0.03 0.08
Com_ 16.46k 0.2/s 10.31
admin_comma 6.82k 0.1/s 4.27
show_status 6.81k 0.1/s 4.27
call_proced 2.35k 0.0/s 1.47
__ SELECT and Sort _____________________________________________________
Scan 9.84k 0.1/s %SELECT: 27.96
Range 1.91k 0.0/s 5.42
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 417 0.0/s
Sort range 3.69k 0.1/s
Sort mrg pass 0 0/s
__ Query Cache _________________________________________________________
Memory usage 874.05k of 16.00M %Used: 5.33
Block Fragmnt 25.05%
Hits 101.16k 1.5/s
Inserts 28.74k 0.4/s
Insrt:Prune 28.74k:1 0.4/s
Hit:Insert 3.52:1
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 80.65k 1.2/s
__ Tables ______________________________________________________________
Open 111 of 400 %Cache: 27.75
Opened 118 0.0/s
__ Connections _________________________________________________________
Max used 68 of 151 %Max: 45.03
Total 688 0.0/s
__ Created Temp ________________________________________________________
Disk table 78 0.0/s
Table 7.44k 0.1/s Size: 16.0M
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 53
Cached 7 of 8 %Hit: 79.36
Created 142 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 12 0.0/s
Connects 2 0.0/s
__ Bytes _______________________________________________________________
Sent 144.60M 2.1k/s
Received 50.56M 741.8/s
__ InnoDB Buffer Pool __________________________________________________
Usage 38.41M of 127.98M %Used: 30.01
Read hit 100.00%
Pages
Free 5.73k %Total: 69.99
Data 2.36k 28.84 %Drty: 9.53
Misc 96 1.17
Latched 0 0.00
Reads 433.98M 6.4k/s
From file 1.99k 0.0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 173.42k 2.5/s
Flushes 76.95k 1.1/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 2.16k 0.0/s
Writes 102.65k 1.5/s
fsync 28.72k 0.4/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 209 0.0/s
Read 2.15k 0.0/s
Written 76.95k 1.1/s
Rows
Deleted 280 0.0/s
Inserted 7.47k 0.1/s
Read 135.52M 2.0k/s
Updated 13.24k 0.2/s
My pfdhcplistener log is going nuts during this time. I have several lines
per second. This is all within a second:
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched IP '10.129.100.87' to
MAC address '00:17:f2:39:51:f8' using OMAPI (pf::iplog::ip2mac)
Oct 16 10:18:32 pfdhcplistener(8571) INFO: 00:17:f2:39:51:f8 requested an
IP with the following informations: last_dhcp = 2015-10-16
10:18:31,computername = ,dhcp_fingerprint =
1,3,6,15,119,95,252,44,46,47,dhcp_vendor = (main::listen_dhcp)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: DHCPACK from 10.128.100.254
(00:66:01:32:00:05) to host 00:16:cb:b3:30:5a (10.129.100.88) for 5 seconds
(main::parse_dhcp_ack)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched MAC '00:16:cb:b3:30:5a'
to IP address '10.129.100.88' using OMAPI (pf::iplog::mac2ip)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched IP '10.129.100.88' to
MAC address '00:16:cb:b3:30:5a' using OMAPI (pf::iplog::ip2mac)
Oct 16 10:18:32 pfdhcplistener(8571) INFO: 04:0c:ce:1b:28:11 requested an
IP with the following informations: last_dhcp = 2015-10-16
10:18:32,computername = ,dhcp_fingerprint =
1,3,6,15,119,95,252,44,46,dhcp_vendor = (main::listen_dhcp)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: DHCPACK from 10.128.100.254
(00:66:01:32:00:05) to host 04:0c:ce:1b:28:11 (10.129.100.74) for 5 seconds
(main::parse_dhcp_ack)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched MAC '04:0c:ce:1b:28:11'
to IP address '10.129.100.74' using OMAPI (pf::iplog::mac2ip)
Oct 16 10:18:32 pfdhcplistener(8571) INFO: 00:16:cb:b3:1f:7e requested an
IP with the following informations: last_dhcp = 2015-10-16
10:18:32,computername = ,dhcp_fingerprint =
1,3,6,15,119,95,252,44,46,47,dhcp_vendor = (main::listen_dhcp)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched IP '10.129.100.74' to
MAC address '04:0c:ce:1b:28:11' using OMAPI (pf::iplog::ip2mac)
Oct 16 10:18:32 pfdhcplistener(8571) INFO: 00:26:08:fe:23:9c requested an
IP with the following informations: last_dhcp = 2015-10-16
10:18:32,computername = ,dhcp_fingerprint =
1,3,6,15,119,95,252,44,46,47,dhcp_vendor = (main::listen_dhcp)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: DHCPACK from 10.128.100.254
(00:66:01:32:00:05) to host 00:16:cb:b3:1f:7e (10.129.100.38) for 5 seconds
(main::parse_dhcp_ack)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched MAC '00:16:cb:b3:1f:7e'
to IP address '10.129.100.38' using OMAPI (pf::iplog::mac2ip)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched IP '10.129.100.38' to
MAC address '00:16:cb:b3:1f:7e' using OMAPI (pf::iplog::ip2mac)
Oct 16 10:18:32 pfdhcplistener(8571) INFO: 00:23:12:25:de:2e requested an
IP with the following informations: last_dhcp = 2015-10-16
10:18:32,computername = ,dhcp_fingerprint =
1,3,6,15,119,95,252,44,46,47,dhcp_vendor = (main::listen_dhcp)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: DHCPACK from 10.128.100.254
(00:66:01:32:00:05) to host a0:02:dc:b7:73:f9 (10.129.100.33) for 5 seconds
(main::parse_dhcp_ack)
Oct 16 10:18:32 pfdhcplistener(8571) INFO: 04:0c:ce:1a:a5:d1 requested an
IP with the following informations: last_dhcp = 2015-10-16
10:18:32,computername = ,dhcp_fingerprint =
1,3,6,15,119,95,252,44,46,dhcp_vendor = (main::listen_dhcp)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched MAC 'a0:02:dc:b7:73:f9'
to IP address '10.129.100.33' using OMAPI (pf::iplog::mac2ip)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched IP '10.129.100.33' to
MAC address 'a0:02:dc:b7:73:f9' using OMAPI (pf::iplog::ip2mac)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: DHCPACK from 10.128.100.254
(00:66:01:32:00:05) to host 00:23:12:25:de:2e (10.129.100.73) for 5 seconds
(main::parse_dhcp_ack)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched MAC '00:23:12:25:de:2e'
to IP address '10.129.100.73' using OMAPI (pf::iplog::mac2ip)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched IP '10.129.100.73' to
MAC address '00:23:12:25:de:2e' using OMAPI (pf::iplog::ip2mac)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: DHCPACK from 10.128.100.254
(00:66:01:32:00:05) to host 00:26:08:fe:23:9c (10.129.100.71) for 5 seconds
(main::parse_dhcp_ack)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched MAC '00:26:08:fe:23:9c'
to IP address '10.129.100.71' using OMAPI (pf::iplog::mac2ip)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched IP '10.129.100.71' to
MAC address '00:26:08:fe:23:9c' using OMAPI (pf::iplog::ip2mac)
Oct 16 10:18:32 pfdhcplistener(8571) INFO: 00:26:08:fc:ef:2b requested an
IP with the following informations: last_dhcp = 2015-10-16
10:18:32,computername = Class12a14-15,dhcp_fingerprint =
1,3,6,15,119,95,252,44,46,47,dhcp_vendor = (main::listen_dhcp)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: DHCPACK from 10.128.100.254
(00:66:01:32:00:05) to host 00:17:f2:39:51:f8 (10.129.100.87) for 5 seconds
(main::parse_dhcp_ack)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched MAC '00:17:f2:39:51:f8'
to IP address '10.129.100.87' using OMAPI (pf::iplog::mac2ip)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched IP '10.129.100.87' to
MAC address '00:17:f2:39:51:f8' using OMAPI (pf::iplog::ip2mac)
Oct 16 10:18:32 pfdhcplistener(8571) INFO: 00:26:08:fc:ef:2b requested an
IP with the following informations: last_dhcp = 2015-10-16
10:18:32,computername = Class12a14-15,dhcp_fingerprint =
1,3,6,15,119,95,252,44,46,47,dhcp_vendor = (main::listen_dhcp)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: DHCPACK from 10.128.100.254
(00:66:01:32:00:05) to host 00:16:cb:b3:30:5a (10.129.100.88) for 5 seconds
(main::parse_dhcp_ack)
Oct 16 10:18:32 pfdhcplistener(8567) INFO: Matched MAC '00:16:cb:b3:30:5a'
to IP address '10.129.100.88' using OMAPI (pf::iplog::mac2ip)
Oct 16 10:18:32 pfdhcplistener(8571) INFO: 00:26:08:fc:ef:2b requested an
IP with the following informations: last_dhcp = 2015-10-16
10:18:32,computername = Class12a14-15,dhcp_fingerprint =
1,3,6,15,119,95,252,44,46,47,dhcp_vendor = (main::listen_dhcp)
Is that normal?
Thanks for the help.
On Fri, Oct 16, 2015 at 9:56 AM, Louis Munro <[email protected]> wrote:
> Which issue exactly?
>
> If we are talking about pfdhcplistener stopping when you restart the
> database that is considered normal behaviour.
> MySQL is not a PF managed service.
> Services that depend on it may stop if they can’t connect to the database.
> That is an unfortunate fact of life.
>
> You should always check the status of all services after a database
> restart.
> Database restarts should be few and far between anyway.
>
> Regards,
> --
> Louis Munro
> [email protected] :: www.inverse.ca
> +1.514.447.4918 x125 :: +1 (866) 353-6153 x125
> Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (
> www.packetfence.org)
>
> On Oct 15, 2015, at 15:03 , Chris Abel <[email protected]> wrote:
>
> I'm still having this issue. Should I start a bug report?
>
>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
--
IMPORTANT NOTICE: This message and any attachments are solely for the
intended recipient and may contain confidential information, which is, or
may be, legally privileged or otherwise protected by law from further
disclosure. If you are not the intended recipient, any disclosure, copying,
use, or distribution of the information included in this email and any
attachments is prohibited. If you have received this communication in
error, please notify the sender by reply email and immediately and
permanently delete this email and any attachments.
------------------------------------------------------------------------------
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
