Private key failed

[Raymond Bell]

@Wayne-Workman So you are saying stop apache2 and try running this and see what happens?

Manually reset encryption on ALL hosts

This applies to FOG 1.3.0 where the New Client is in use and for some reason you need to manually reset the encryption for all hosts.

mysql
use fog
UPDATE hosts SET hostPubKey=“”, hostSecToken=“”, hostSecTime=“0000-00-00 00:00:00”;

[Wayne Workman]

@Raymond-Bell You don’t have to stop apache for this, and this is just to make sure the encryption on this particular host is reset.

[Raymond Bell]

@Wayne-Workman Ok so just run the

mysql
use fog
UPDATE hosts SET hostPubKey="", hostSecToken="", hostSecTime="0000-00-00 00:00:00";

[Raymond Bell]

@Wayne-Workman How do i find just this host hostPubKey so i don’t do this on all

[Wayne Workman]

@Raymond-Bell use a WHERE clause for the hostname. WHERE hostName = ‘someHostName’

[Raymond Bell]

@Wayne-Workman Like this ?

 UPDATE WHERE hostName = "LAB-IMAGE-WIN10" SET hostPubKey="", hostSecToken="", hostSecTime="0000-00-00 00:00:00";

[Wayne Workman]

@Raymond-Bell Well I normally put the WHERE clause at the very end… but that will either work or give an error. Try it.

[Raymond Bell]

@Wayne-Workman Done

mysql> UPDATE hosts SET hostPubKey="", hostSecToken="", hostSecTime="0000-00-00 00:00:00"; WHERE hostName = "LAB-IMAGE-WIN10"
Query OK, 4 rows affected (0.04 sec)
Rows matched: 804  Changed: 4  Warnings: 0

[Wayne Workman]

@Raymond-Bell said:

Query OK, 4 rows affected (0.04 sec)

4 rows affected?

Can you run this command and see what the return is?

SELECT hostID,hostName FROM hosts WHERE hostName = 'LAB-IMAGE-WIN10';

[Raymond Bell]

@Wayne-Workman

mysql> SELECT hostName,hostID from hosts where hostName = 'LAB-IMAGE-WIN10';
+-----------------+--------+
| hostName        | hostID |
+-----------------+--------+
| LAB-IMAGE-WIN10 |   1701 |
+-----------------+--------+
1 row in set (0.08 sec)

mysql>

[Wayne Workman]

@Raymond-Bell Well what does the host’s fog log say now?

[Raymond Bell]

@Wayne-Workman

------------------------------------------------------------------------------
--------------------------------Authentication--------------------------------
------------------------------------------------------------------------------
 3/29/2016 9:28 AM Client-Info Version: 0.9.12
 3/29/2016 9:28 AM Middleware::Communication URL: http://10.24.28.18/fog/management/other/ssl/srvpublic.crt
 3/29/2016 9:28 AM Data::RSA FOG Server CA cert found
 3/29/2016 9:28 AM Middleware::Authentication Cert OK
 3/29/2016 9:28 AM Middleware::Communication POST URL: http://10.24.28.18/fog/management/index.php?sub=authorize
 3/29/2016 9:28 AM Middleware::Communication Unknown Response: Private key not found
 3/29/2016 9:28 AM Service Sleeping for 120 seconds

------------------------------------------------------------------------------
--------------------------------Authentication--------------------------------
------------------------------------------------------------------------------
 3/29/2016 9:30 AM Client-Info Version: 0.9.12
 3/29/2016 9:30 AM Middleware::Communication URL: http://10.24.28.18/fog/management/other/ssl/srvpublic.crt
 3/29/2016 9:31 AM Data::RSA FOG Server CA cert found
 3/29/2016 9:31 AM Middleware::Authentication Cert OK
 3/29/2016 9:31 AM Middleware::Communication POST URL: http://10.24.28.18/fog/management/index.php?sub=authorize
 3/29/2016 9:31 AM Middleware::Communication Unknown Response: Private key not found
 3/29/2016 9:31 AM Service Sleeping for 120 seconds```

[Wayne Workman]

@Raymond-Bell Is this with just this one host or is it all hosts?

[Raymond Bell]

@Wayne-Workman This looks like it is with all host, this is from another computer

------------------------------------------------------------------------------
--------------------------------Authentication--------------------------------
------------------------------------------------------------------------------
 3/29/2016 10:30 AM Client-Info Version: 0.9.12
 3/29/2016 10:30 AM Middleware::Communication URL: http://10.24.28.18/fog/management/other/ssl/srvpublic.crt
 3/29/2016 10:30 AM Data::RSA FOG Server CA cert found
 3/29/2016 10:30 AM Middleware::Authentication Cert OK
 3/29/2016 10:30 AM Middleware::Communication POST URL: http://10.24.28.18/fog/management/index.php?sub=authorize
 3/29/2016 10:31 AM Middleware::Communication Unknown Response: Private key not found
 3/29/2016 10:31 AM Service Sleeping for 120 seconds

------------------------------------------------------------------------------
--------------------------------Authentication--------------------------------
------------------------------------------------------------------------------
 3/29/2016 10:33 AM Client-Info Version: 0.9.12
 3/29/2016 10:33 AM Middleware::Communication URL: http://10.24.28.18/fog/management/other/ssl/srvpublic.crt
 3/29/2016 10:33 AM Data::RSA FOG Server CA cert found
 3/29/2016 10:33 AM Middleware::Authentication Cert OK
 3/29/2016 10:33 AM Middleware::Communication POST URL: http://10.24.28.18/fog/management/index.php?sub=authorize
 3/29/2016 10:33 AM Middleware::Communication Unknown Response: Private key not found
 3/29/2016 10:33 AM Service Sleeping for 120 seconds

[Wayne Workman]

@Raymond-Bell What displays in a web browser if you go to:
http://10.24.28.18/fog/management/index.php?sub=authorize

When I go to that address with my fog server, it responds with this:
#!im

[Raymond Bell]

@Wayne-Workman Same
#!im

[Wayne Workman]

I’m going to ask @Tom-Elliott or @Jbob to try to make some suggestions from here. I’m not sure what’s wrong.

[Raymond Bell]

@Wayne-Workman Ok thanks
Do i need to start a new request on this?

[Tom Elliott]

@Raymond-Bell Can you get us apache error logs?

[Wayne Workman]

@Raymond-Bell There’s too much in this thread already about the issue, we can just keep it here.