Hey Fabrice,
I checked back through the logs and found this error at the time when my test
PC was rejected:
Feb 13 12:43:38 httpd.aaa(3846) ERROR: [mac:c8:5b:76:6e:34:59] radius authorize
failed with error: DBIx::Class::Storage::DBI::catch {...} (): DBI Connection
failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) at
/usr/share/perl5/vendor_perl/DBIx/Class/Storage/DBI.pm line 1492. at
/usr/local/pf/lib/fingerbank/Base/CRUD.pm line 416
(pf::api::radius_authorize)
Any ideas as to why I would lose connection to my database like that out of
nowhere? Like I said everything is fine for a few hours but then the PC gets
kicked randomly so I'm not sure what could be causing it.
Thanks,
-Mike
________________________________
From: Fabrice Durand <[email protected]>
Sent: Monday, February 13, 2017 1:54 PM
To: [email protected]
Subject: Re: [PacketFence-users] Active/Passive cluster - Slave server
rejecting user Auth
Hello Michael,
it looks that the issue is MySQL.
Can you check when it happen if it's possible to connect to the DB ?
Regards
Fabrice
Le 2017-02-13 à 13:34, Campanaro, Michael a écrit :
I have an Active/Passive cluster setup between two PF servers but have been
having an issue lately. After I register and authenticate my test PC,
everything works fine for a few hours but then randomly my connection will drop
and I am placed in the default VLAN with no internet connection. If I go to the
Audit page on the Admin gui, it shows a bunch of Access-Reject messages for my
PC even though it was previously registered and accepted earlier in the day.
I check the logs on my master server and I see nothing out of the ordinary. But
when I check the logs on my slave server I get multiple warning and error
messages. Below are some relevant log entries I'm getting on my slave server:
Packetfence.log:
Feb 13 12:42:36 httpd.aaa(3846) INFO: [mac:c8:5b:76:6e:34:59] Database
/usr/local/fingerbank/db/fingerbank_Local.db was changed or handles weren't
initialized. Creating handle. (fingerbank::DB::SQLite::build_handle)
Feb 13 12:42:36 httpd.aaa(3846) WARN: [mac:c8:5b:76:6e:34:59] Use of
uninitialized value $mysql_ver in numeric lt (<) at
/usr/share/perl5/vendor_perl/DBIx/Class/Storage/DBI/mysql.pm line 117.
(DBIx::Class::Storage::DBI::mysql::sql_maker)
Feb 13 12:42:36 httpd.aaa(3846) WARN: [mac:c8:5b:76:6e:34:59] Use of
uninitialized value $mysql_ver in numeric lt (<) at
/usr/share/perl5/vendor_perl/DBIx/Class/Storage/DBI/mysql.pm line 117.
(DBIx::Class::Storage::DBI::mysql::sql_maker)
Feb 13 12:42:36 httpd.aaa(3846) WARN: [mac:c8:5b:76:6e:34:59] Use of
uninitialized value $mysql_ver in numeric lt (<) at
/usr/share/perl5/vendor_perl/DBIx/Class/Storage/DBI/mysql.pm line 117.
(DBIx::Class::Storage::DBI::mysql::sql_maker)
Feb 13 12:42:36 httpd.aaa(3846) ERROR: [mac:c8:5b:76:6e:34:59] radius authorize
failed with error: DBIx::Class::Storage::DBI::catch {...} (): DBI Connection
failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) at
/usr/share/perl5/vendor_perl/DBIx/Class/Storage/DBI.pm line 1492. at
/usr/local/pf/lib/fingerbank/Base/CRUD.pm line 416
Radius.log:
Mon Feb 13 12:42:35 2017 : [mac:c8:5b:76:6e:34:59] Accepted user: and returned
VLAN
Mon Feb 13 12:42:36 2017 : Auth: (4) Rejected in post-auth: [c85b766e3459]
(from client pf port 9 cli c8:5b:76:6e:34:59)
Mon Feb 13 12:43:38 2017 : Info: rlm_rest (rest): Closing connection (6): Hit
idle_timeout, was idle for 65 seconds
Mon Feb 13 12:43:38 2017 : Info: rlm_rest (rest): Closing connection (5): Hit
idle_timeout, was idle for 62 seconds
Mon Feb 13 12:43:38 2017 : Info: rlm_rest (rest): Closing connection (7): Hit
idle_timeout, was idle for 62 seconds
Mon Feb 13 12:43:38 2017 : Info: rlm_rest (rest): Opening additional connection
(8), 1 of 64 pending slots used
Mon Feb 13 12:43:38 2017 : ERROR: (5) rest: ERROR: Server returned:
Mon Feb 13 12:43:38 2017 : ERROR: (5) rest: ERROR:
{"reply:PacketFence-Authorization-Status":"allow"}
It also seems that the only way I can get my test PC connected properly again
is if I reboot the slave server. But that only fixes my problem for another few
hours as this cycle keeps repeating. Any ideas as to what could be wrong?
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
PacketFence-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/packetfence-users
--
Fabrice Durand
[email protected]<mailto:[email protected]> :: +1.514.447.4918 (x135) ::
www.inverse.ca<http://www.inverse.ca>
Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence
(http://packetfence.org)
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
