The issue here is that the source_id is undef.
It's suppose to be set when the activation code is generated.
If you can check in the database with a request like:
select * from activation where
activation_code="9b777b6db43b9c2aeb4c484b0241f97b";
If the source_id is still undef then we will have to search deeper.
Regards
Fabrice
Le 18-11-01 à 22 h 31, Eric Koons a écrit :
Got it and done.
Below is from the packetfence.log file. This was attempting to
authorize a user request from earlier today. Unfortunately I’m VPN’d
in and only can access the admin gui and CLI, so if I need to generate
a new guest request it will have to wait until tomorrow when I’m in
the office.
Nov 01 22:28:37 -e(906) DEBUG: sudo systemctl packetfence-iptables
returned 906 (pf::services::manager::pid)
Nov 1 22:28:37 pf01 packetfence: DEBUG - sudo systemctl
packetfence-iptables returned 906
Nov 1 22:28:49 pf01 packetfence_httpd.aaa: httpd.aaa(1051) INFO:
[mac:ac:37:43:51:dd:5d] Updating locationlog from accounting request
(pf::api::handle_accounting_metadata)
Nov 1 22:29:03 pf01 packetfence_httpd.portal: httpd.portal(14842)
WARN: [mac:unknown] Unable to match MAC address to IP '10.1.4.22'
(pf::ip4log::ip2mac)
Nov 1 22:29:03 pf01 packetfence_httpd.portal: httpd.portal(14842)
WARN: [mac:unknown] Unable to match MAC address to IP '10.1.4.22'
(pf::ip4log::ip2mac)
Nov 1 22:29:03 pf01 packetfence_httpd.portal: httpd.portal(14842)
WARN: [mac:0] Unable to match MAC address to IP '10.1.4.22'
(pf::ip4log::ip2mac)
Nov 1 22:29:03 pf01 packetfence_httpd.portal: httpd.portal(14842)
WARN: [mac:0] Unable to match MAC address to IP '10.1.4.22'
(pf::ip4log::ip2mac)
Nov 1 22:29:03 pf01 packetfence_httpd.portal: httpd.portal(14842)
INFO: [mac:0] Instantiate profile SEGuestPortal
(pf::Connection::ProfileFactory::_from_profile)
Nov 1 22:29:03 pf01 packetfence_httpd.portal: httpd.portal(14842)
ERROR: [mac:0] Error while communicating with the Fingerbank
collector. 404 Not Found (pf::fingerbank::endpoint_attributes)
Nov 1 22:29:03 pf01 packetfence_httpd.portal: httpd.portal(14842)
WARN: [mac:0] Use of uninitialized value in string ne at
/usr/local/pf/lib/captiveportal/PacketFence/DynamicRouting/Application.pm
line 137.
(captiveportal::PacketFence::DynamicRouting::Application::process_fingerbank)
Nov 1 22:29:03 pf01 packetfence_httpd.portal: httpd.portal(14842)
ERROR: [mac:0] Error while communicating with the Fingerbank
collector. 404 Not Found (pf::fingerbank::update_collector_endpoint_data)
Nov 1 22:29:03 pf01 pfqueue: pfqueue(27747) ERROR: [mac:unknown]
Error while communicating with the Fingerbank collector. 404 Not Found
(pf::fingerbank::endpoint_attributes)
Nov 1 22:29:03 pf01 pfqueue: pfqueue(27747) ERROR: [mac:unknown]
Unable to fetch query arguments for Fingerbank query. Aborting.
(pf::fingerbank::process)
Nov 1 22:29:03 pf01 packetfence_httpd.portal: httpd.portal(14842)
INFO: [mac:0] [d4:f4:6f:1e:09:ec] Activation code sent to email
[email protected] <mailto:[email protected]> from [email protected]
<mailto:[email protected]> successfully verified. for activation
type: sponsor (pf::activation::validate_code)
Nov 1 22:29:03 pf01 packetfence_httpd.portal: httpd.portal(14842)
WARN: [mac:0] No active sponsor source for profile SEGuestPortal
(captiveportal::PacketFence::Controller::Activate::Email::doSponsorRegistration)
Nov 1 22:29:03 pf01 packetfence_httpd.portal: httpd.portal(14842)
WARN: [mac:0] $VAR1 = {
'contact_info' => '[email protected] <mailto:[email protected]>',
'source_id' => undef,
'activation_code' => '9b777b6db43b9c2aeb4c484b0241f97b',
'status' => 'unverified',
'carrier_email_pattern' => undef,
'carrier_id' => undef,
'tenant_id' => '1',
'pid' => '[email protected] <mailto:[email protected]>',
'code_id' => '1214',
'expiration' => '2018-11-02 14:24:50',
'type' => 'sponsor',
'portal' => 'SEGuestPortal',
'unregdate' => undef,
'mac' => 'd4:f4:6f:1e:09:ec'
};
(captiveportal::PacketFence::Controller::Activate::Email::doSponsorRegistration)
Nov 01 22:29:05 pfperl-api(1039) DEBUG: GET "/api/v1/queues/stats"
(Mojolicious::dispatch)
Nov 1 22:29:05 pf01 packetfence: DEBUG - GET "/api/v1/queues/stats"
Nov 01 22:29:05 pfperl-api(1039) DEBUG: Routing to controller
"pf::UnifiedApi::Controller::Queues" and action "stats"
(Mojolicious::Routes::_controller)
Nov 1 22:29:05 pf01 packetfence: DEBUG - Routing to controller
"pf::UnifiedApi::Controller::Queues" and action "stats"
Nov 01 22:29:05 pfperl-api(1039) DEBUG: cache get for
namespace='Default', key='HASH(0x4c5b6b8)', cache='RawMemory',
time='0ms': HIT (CHI::Driver::_log_get_result)
Nov 1 22:29:05 pf01 packetfence: DEBUG - cache get for
namespace='Default', key='HASH(0x4c5b6b8)', cache='RawMemory',
time='0ms': HIT
Nov 01 22:29:05 pfperl-api(1039) DEBUG: 200 OK (0.004026s, 248.385/s)
(Mojolicious::Controller::rendered)
Nov 1 22:29:05 pf01 packetfence: DEBUG - 200 OK (0.004026s, 248.385/s)
Nov 1 22:29:09 pf01 packetfence_httpd.aaa: httpd.aaa(1051) WARN:
[mac:4c:32:75:8e:f1:f7] Trying to match IP address with an invalid MAC
address 'undef' (pf::ip4log::mac2ip)
Nov 1 22:29:09 pf01 packetfence_httpd.aaa: httpd.aaa(1051) INFO:
[mac:4c:32:75:8e:f1:f7] Instantiate profile default
(pf::Connection::ProfileFactory::_from_profile)
Nov 01 22:29:29 pfperl-api(1038) DEBUG: GET "/api/v1/queues/stats"
(Mojolicious::dispatch)
Nov 01 22:29:29 pfperl-api(1038) DEBUG: Routing to controller
"pf::UnifiedApi::Controller::Queues" and action "stats"
(Mojolicious::Routes::_controller)
Nov 1 22:29:29 pf01 packetfence: DEBUG - GET "/api/v1/queues/stats"
Nov 1 22:29:29 pf01 packetfence: DEBUG - Routing to controller
"pf::UnifiedApi::Controller::Queues" and action "stats"
Nov 01 22:29:29 pfperl-api(1038) DEBUG: cache get for
namespace='Default', key='HASH(0x4c5b6b8)', cache='RawMemory',
time='0ms': HIT (CHI::Driver::_log_get_result)
Nov 1 22:29:29 pf01 packetfence: DEBUG - cache get for
namespace='Default', key='HASH(0x4c5b6b8)', cache='RawMemory',
time='0ms': HIT
Nov 01 22:29:29 pfperl-api(1038) DEBUG: 200 OK (0.003833s, 260.892/s)
(Mojolicious::Controller::rendered)
Nov 1 22:29:29 pf01 packetfence: DEBUG - 200 OK (0.003833s, 260.892/s)
Nov 01 22:29:34 pfperl-api(1038) DEBUG: GET "/api/v1/queues/stats"
(Mojolicious::dispatch)
Nov 1 22:29:34 pf01 packetfence: DEBUG - GET "/api/v1/queues/stats"
Nov 01 22:29:34 pfperl-api(1038) DEBUG: Routing to controller
"pf::UnifiedApi::Controller::Queues" and action "stats"
(Mojolicious::Routes::_controller)
Nov 1 22:29:34 pf01 packetfence: DEBUG - Routing to controller
"pf::UnifiedApi::Controller::Queues" and action "stats"
Nov 01 22:29:34 pfperl-api(1038) DEBUG: cache get for
namespace='Default', key='HASH(0x4c5b6b8)', cache='RawMemory',
time='0ms': HIT (CHI::Driver::_log_get_result)
Nov 1 22:29:34 pf01 packetfence: DEBUG - cache get for
namespace='Default', key='HASH(0x4c5b6b8)', cache='RawMemory',
time='0ms': HIT
Nov 01 22:29:34 pfperl-api(1038) DEBUG: 200 OK (0.00529s, 189.036/s)
(Mojolicious::Controller::rendered)
Nov 1 22:29:34 pf01 packetfence: DEBUG - 200 OK (0.00529s, 189.036/s)
Nov 01 22:29:38 -e(906) DEBUG: sudo systemctl packetfence-iptables
returned 906 (pf::services::manager::pid)
Nov 1 22:29:38 pf01 packetfence: DEBUG - sudo systemctl
packetfence-iptables returned 906
Eric Koons
Sr. Network Engineer | CCNA
Service Electric Cable TV and Communications | www.sectv.com
<http://www.sectv.com>
[email protected] <mailto:[email protected]>
Office: 610-841-8355
Mobile: 610-533-6834
Fax: 610-797-2445
On Nov 1, 2018, at 10:25 PM, Durand fabrice <[email protected]
<mailto:[email protected]>> wrote:
Put that in a file (path.diff):
diff --git
a/html/captive-portal/lib/captiveportal/PacketFence/Controller/Activate/Email.pm
b/html/captive-portal/lib/captiveportal/PacketFence/Controller/Activate/Email.pm
index 3ac0e491af..55663361e5 100644
---
a/html/captive-portal/lib/captiveportal/PacketFence/Controller/Activate/Email.pm
+++
b/html/captive-portal/lib/captiveportal/PacketFence/Controller/Activate/Email.pm
@@ -225,6 +225,8 @@ sub doSponsorRegistration : Private {
$logger->warn( "No active sponsor source for profile "
. $profile->getName
);
+ use Data::Dumper;
+ $logger->warn(Dumper $activation_record);
$self->showError($c, "No active sponsor source for this
Connection Profile.");
}
}
Then go in /usr/local/pf and do:
patch -p1 --dry-run < patch.diff
If there is no error do:
patch -p1 < patch.diff
then restart httpd.portal
Regards
Fabrice
Le 18-11-01 à 22 h 22, Eric Koons a écrit :
I attempt to run this from the command line and I get git is an
unrecognized option. Is there something I’m missing? This is CentOS.
Eric Koons
Sr. Network Engineer | CCNA
Service Electric Cable TV and Communications | www.sectv.com
<http://www.sectv.com/>
[email protected] <mailto:[email protected]>
Office: 610-841-8355
Mobile: 610-533-6834
Fax: 610-797-2445
On Nov 1, 2018, at 10:05 PM, Durand fabrice <[email protected]
<mailto:[email protected]>> wrote:
diff --git
a/html/captive-portal/lib/captiveportal/PacketFence/Controller/Activate/Email.pm
b/html/captive-portal/lib/captiveportal/PacketFence/Controller/Activate/Email.pm
index 3ac0e491af..55663361e5 100644
---
a/html/captive-portal/lib/captiveportal/PacketFence/Controller/Activate/Email.pm
+++
b/html/captive-portal/lib/captiveportal/PacketFence/Controller/Activate/Email.pm
@@ -225,6 +225,8 @@ sub doSponsorRegistration : Private {
$logger->warn( "No active sponsor source for profile "
. $profile->getName
);
+ use Data::Dumper;
+ $logger->warn(Dumper $activation_record);
$self->showError($c, "No active sponsor source for this Connection
Profile.");
}
}
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users