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]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
--
Fabrice Durand
[email protected] :: +1.514.447.4918 (x135) :: 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
