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
