Hello Michael,
there is probably some logs from mysql, also can you check the status
tab on the admin gui and check the graph related to the DB.
You will probably be able to see if there is something wrong from the graph.
Regards
Fabrice
Le 2017-02-13 à 14:29, Campanaro, Michael a écrit :
>
> 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]
>> 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
--
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
