Hi Kai, Thanks for the report.
I just opened an issue for that: https://github.com/inverse-inc/packetfence/issues/8587 Please fill free to add or comment. Regards Jeremy Goimard Senior Software Engineer [signature_117474225] PacketFence Sport Phone number: +1 555 183 6031 Akamai Technologies - Inverse 145 Broadway Cambridge, MA 02142 Connect with Us: [signature_1388875202]<https://community.akamai.com/> [signature_3364560605] <http://blogs.akamai.com/> [signature_2499095976] <https://twitter.com/akamai> [signature_3425345268] <http://www.facebook.com/AkamaiTechnologies> [signature_4082763092] <http://www.linkedin.com/company/akamai-technologies> [signature_1928680685] <http://www.youtube.com/user/akamaitechnologies?feature=results_main> ________________________________ From: Kai Bass (Westfalia Spielgeräte GmbH) via PacketFence-users <packetfence-users@lists.sourceforge.net> Sent: Tuesday, March 11, 2025 10:41:53 AM To: packetfence-users@lists.sourceforge.net Cc: Kai Bass (Westfalia Spielgeräte GmbH) Subject: [PacketFence-users] Access denied for user 'pf'@'localhost' Hello everyone, I recently downloaded the latest PacketFence ISO (version 14. 1). However, whenever I try to add a new role or switch, I receive an "unknown error", even though the roles and switches actually get created. The logs show ZjQcmQRYFpfptBannerStart This Message Is From an External Sender This message came from outside your organization. ZjQcmQRYFpfptBannerEnd Hello everyone, I recently downloaded the latest PacketFence ISO (version 14.1). However, whenever I try to add a new role or switch, I receive an "unknown error", even though the roles and switches actually get created. The logs show the following error: FATAL: unable to connect to database: Access denied for user 'pf'@'localhost' (using password: YES) at /usr/local/pf/lib/CHI/Driver/DBI.pm line 28. ERROR: unable to connect to database: Access denied for user 'pf'@'localhost' (using password: YES) at /usr/local/pf/lib/CHI/Driver/DBI.pm line 28. At first, I assumed the issue might be related to the password, but I verified that I'm able to successfully log in manually using the configured password for the user pf. And this command showes my password. root@packetfence:~# /usr/local/pf/bin/pfcmd pfconfig show resource::Database 'db' => 'pf', 'port' => '3306', 'host' => 'localhost', 'pass' => bless( do{\(my $o = MeinMegaGeheimesPasswort '')}, 'pf::config::crypt::string' ), 'user' => 'pf', 'unix_socket' => '/var/lib/mysql/mysql.sock' Here are the permissions currently set: MariaDB [(none)]> SHOW GRANTS FOR 'pf'@'%'; +-----------------------------------------------------------------------------------------------------------------+ | Grants for pf@% | +-----------------------------------------------------------------------------------------------------------------+ | GRANT BINLOG ADMIN ON *.* TO `pf`@`%` IDENTIFIED BY PASSWORD '*SuperMegaGeheim' | | GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `pf`.* TO `pf`@`%` | | GRANT CREATE, DROP ON `pf`.`radius_nas` TO `pf`@`%` | | GRANT SELECT ON `mysql`.`proc` TO `pf`@`%` | +-----------------------------------------------------------------------------------------------------------------+ MariaDB [(none)]> SHOW GRANTS FOR 'pf'@'localhost'; +----------------------------------------------------------------------------------------------------------------------------------------+ | Grants for pf@localhost | +----------------------------------------------------------------------------------------------------------------------------------------+ | GRANT BINLOG ADMIN ON *.* TO `pf`@`localhost` IDENTIFIED BY PASSWORD '*SuperMegaGeheim' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `pf`.* TO `pf`@`localhost` | | GRANT SELECT ON `mysql`.`proc` TO `pf`@`localhost` | | GRANT CREATE, DROP ON `pf`.`radius_nas` TO `pf`@`localhost` | +----------------------------------------------------------------------------------------------------------------------------------------+ Has anyone experienced a similar issue, or could this be related to permission configuration problems in PacketFence 14.1? Thank you very much! Best regards, Kai Bass
_______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
