Hi, Thanks for the reply.
Issues was, as per documentation I just added DB host entry in pf.conf and while going through online help I found this link which says we need to add database name, username and password details also along with hostname and that fixed the issue. https://sourceforge.net/p/packetfence/mailman/packetfence-users/thread/49292FA8.7040606%40indosat.net.id/#msg20875401 Regards, Jitendra Gondaliya Information Technology Security Co LLC Mob : +968 94583036 From: Ludovic Zammit <[email protected]> Sent: Monday, September 14, 2020 5:20 PM To: [email protected] Cc: Jitendra Gondaliya <[email protected]> Subject: Re: [PacketFence-users] error while configuring cluster Hello, It looks like your pf db password is not correct, check in conf/pf.conf in the database section. Update your password under: Configuration > System Configuration > Database > General > Password systemctl restart packetfence-mariadb /usr/local/pf/bin/pfcmd service pf restart Thanks, Ludovic Zammit [email protected]<mailto:[email protected]> :: +1.514.447.4918 (x145) :: www.inverse.ca<http://www.inverse.ca> Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence (http://packetfence.org) On Sep 13, 2020, at 8:17 AM, Jitendra Gondaliya via PacketFence-users <[email protected]<mailto:[email protected]>> wrote: Hi Team, I am trying to form three node cluster following the instructions fromhttps://packetfence.org/doc/PacketFence_Clustering_Guide.html#_create_the_new_cluster At step 3.4.2 keepalive and radiusd-loadbalancer does not start and also in the logs I see below messages stating not able to connect to mysql but when I connect to mysql using same username/hostname and password I am able to connect to. Sep 13 13:39:37 tccpf1 packetfence: pfcmd.pl(17891) INFO: Hard expiring resource : resource::tenant_aware_array_test() (pfconfig::manager::expire) Sep 13 13:39:37 tccpf1 packetfence: pfcmd.pl(17891) INFO: Hard expiring resource : resource::tenant_aware_hash_test() (pfconfig::manager::expire) Sep 13 13:39:37 tccpf1 packetfence: pfcmd.pl(17891) INFO: Hard expiring resource : resource::unified_api_system_user() (pfconfig::manager::expire) Sep 13 13:39:38 tccpf1 packetfence: pfcmd.pl(17891) ERROR: unable to connect to database: Access denied for user 'pf'@'192.168.201.251' (using password: YES) (pf::db::db_connect) Sep 13 13:39:38 tccpf1 packetfence: pfcmd.pl(17891) ERROR: Can't connect to db (pf::security_event_config::loadSecurityEventsIntoDb) Sep 13 13:39:38 tccpf1 packetfence: pfcmd.pl(17891) ERROR: unable to connect to database: Access denied for user 'pf'@'192.168.201.251' (using password: YES) (pf::db::db_connect) Sep 13 13:39:38 tccpf1 packetfence: pfcmd.pl(17891) ERROR: Can't connect to db (pf::freeradius::freeradius_populate_nas_config) Sep 13 13:39:38 tccpf1 packetfence: pfcmd.pl(17891) ERROR: unable to connect to database: Access denied for user 'pf'@'192.168.201.251' (using password: YES) (pf::db::db_connect) Sep 13 13:39:38 tccpf1 packetfence: pfcmd.pl(17891) ERROR: Can't connect to db (pf::nodecategory::nodecategory_populate_from_config) Sep 13 13:39:38 tccpf1 packetfence: pfcmd.pl(17891) ERROR: unable to connect to database: Access denied for user 'pf'@'192.168.201.251' (using password: YES) (pf::db::db_connect) Sep 13 13:39:38 tccpf1 packetfence: pfcmd.pl(17891) ERROR: Can't connect to db to reload the survey tables (pf::Survey::reload_from_config) Sep 13 13:39:51 tccpf1 packetfence: pfcmd.pl(17899) INFO: Connecting to MySQL database (pfconfig::backend::mysql::_get_db) Sep 13 13:39:51 tccpf1 packetfence: pfcmd.pl(17899) INFO: secure redirect has been disabled since the portal certificate is a self-signed (pfconfig::namespaces::config::Pf::build_child) Sep 13 13:39:51 tccpf1 packetfence: pfcmd.pl(17899) INFO: Instantiate profile default (pf::Connection::ProfileFactory::_from_profile) Sep 13 13:39:51 tccpf1 packetfence: pfcmd.pl(17899) FATAL: unable to connect to database: Access denied for user 'pf'@'192.168.201.251' (using password: YES) at /usr/local/pf/lib/pf/dal.pm line 70. Also when I ran below command which is from “/usr/lib/systemd/system/packetfence-keepalived.service” is does not start anything /bin/perl -I/usr/local/pf/lib '-Mpf::services::manager::keepalived' -e 'pf::services::manager::keepalived->new()->generateConfig()' Regards, Jitendra Gondaliya Information Technology Security Co LLC Mob : +968 94583036 _______________________________________________ PacketFence-users mailing list [email protected]<mailto:[email protected]> https://lists.sourceforge.net/lists/listinfo/packetfence-users
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
