Hello Anthony,
You will have to reset the mysql password for pf:
if you have the root access then:
mysql -uroot -p
GRANT SELECT,INSERT,UPDATE,DELETE,EXECUTE,LOCK TABLES ON pf.* TO pf@'%'
IDENTIFIED BY 'packet';
GRANT SELECT,INSERT,UPDATE,DELETE,EXECUTE,LOCK TABLES ON pf.* TO
pf@'localhost' IDENTIFIED BY 'packet';
FLUSH PRIVILEGES;
If you don't have the root password then:
Start mysqld with this parameter:
--skip-grant-tables
Connect with the root user (without password)
UPDATE mysql.user SET Password=PASSWORD('packetfence') WHERE User='root';
GRANT SELECT,INSERT,UPDATE,DELETE,EXECUTE,LOCK TABLES ON pf.* TO pf@'%'
IDENTIFIED BY 'packet';
GRANT SELECT,INSERT,UPDATE,DELETE,EXECUTE,LOCK TABLES ON pf.* TO
pf@'localhost' IDENTIFIED BY 'packet';
FLUSH PRIVILEGES;
Regards
Fabrice
Le 2016-02-04 19:54, Blackman Anthony a écrit :
The DB is not running.
I tried the commads above. It prompts for password when i enter pf or
space or anything is get the following.
[root@pfptwifinyc /]# service packetfence status
service|shouldBeStarted|pid
carbon-cache|1|0
carbon-relay|1|0
collectd|1|0
dhcpd|1|0
haproxy|0|0
httpd.aaa|1|0
httpd.admin|1|4501
httpd.graphite|1|0
httpd.portal|1|0
httpd.proxy|0|0
httpd.webservices|1|0
iptables|1|0
keepalived|0|0
p0f|1|0
pfbandwidthd|1|0
pfdetect||0
pfdhcplistener_eth0.490|1|0
pfdhcplistener_eth0.480|1|0
pfdhcplistener_eth0|1|0
pfdns|1|0
pfmon|1|0
pfqueue|1|0
pfsetvlan|0|0
radiusd-acct|1|0
radiusd|1|0
radsniff3|1|0
redis_queue|1|0
snmptrapd|0|0
snort|0|0
statsd|1|0
suricata|0|0
[root@pfptwifinyc /]# mysql -p -u pf pf
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
[root@pfptwifinyc /]# service mysqld start
Starting mysqld: [ OK ]
[root@pfptwifinyc /]# mysql -p -u pf pf
Enter password:
ERROR 1045 (28000): Access denied for user 'pf'@'localhost' (using
password: YES)
[root@pfptwifinyc /]# mysql -p -u pf pf
Enter password:
ERROR 1045 (28000): Access denied for user 'pf'@'localhost' (using
password: YES)
[root@pfptwifinyc /]# mysql -p -u pf pf
Enter password:
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'pf'
[root@pfptwifinyc /]# service mysqld stop
Stopping mysqld: [ OK ]
[
This is what i tried and how it worked.
On Thursday, February 4, 2016 6:25 PM, Louis Munro <[email protected]>
wrote:
> On Feb 4, 2016, at 18:22 , Louis Munro <[email protected]
<mailto:[email protected]>> wrote:
>
> Is the database actually running?
>
And if it is running, can you login with the following?
mysql -p -u pf pf
[will prompt for password]
--
Louis Munro
[email protected] <mailto:[email protected]> :: www.inverse.ca
+1.514.447.4918 x125 :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
PacketFence-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
