Itismike: /* MySQL Root Account */

2011-12-06T20:09:13Z

‎MySQL Root Account

New page

== Scratch Area ==
See the Discussions tab at the top for templates and known password locations.<br>
And please, feel free to make adjustments and add content!

= Template =

====Fog's user account on main FOG server====
This is a standard user account on the server. It is named 'fog'<br>
Common errors associated with this mismatched password:
<ul>
<li>FOG can't do anything</li>
<li>Unexpected, strange errors</li>
<li>...</li>
</ul>
How to modify this password:
:The location varies per operating system.
:To reset it, type this at the command line on the Main FOG server:
<pre>sudo passwd fog</pre>
'''(Click EDIT to copy the source code of this template)'''

= Known Passwords =
===Passwords on the Main FOG Server===
====TFTP Credentials====
"Other Information" > "FOG System Settings" > "TFTP Server"
<pre>FOG_TFTP_FTP_USERNAME
FOG_TFTP_FTP_PASSWORD</pre>

====MySQL Root Account====
<tt>/opt/fog/service/etc/config.php</tt>
<pre>define( "MYSQL_HOST", "localhost" );
define( "MYSQL_DATABASE", "fog" );
define( "MYSQL_USERNAME", "root" );
define( "MYSQL_PASSWORD", "SQLpassword" );
</pre>

<tt>/var/www/fog/commons/config.php</tt>
<pre>define( "MYSQL_DATABASE", "fog" );
define( "MYSQL_USERNAME", "root" );
define( "MYSQL_PASSWORD", "SQLpassword" );</pre>

NOTE: SQLpassword is usually blank if following the FOG installation instructions.

====PXE Boot Menu passwords====
See [https://sourceforge.net/projects/freeghost/forums/forum/716419/topic/3669158 this forum post]

===Passwords on Storage Nodes===
==== The storage node's management password ====
"All Current Storage Nodes" > "Edit Storage Node Definition"
<pre>Management Username:
Management Password:</pre>

To match what was in "Other Information" > "FOG System Settings" > "TFTP Server"
<pre>FOG_TFTP_FTP_USERNAME:
FOG_TFTP_FTP_PASSWORD:</pre>

Storage > Select Storage Node > Edit Storage Node Definition
<pre>Management Username: fog
Management Password: [pw of user 'fog' on the storage node]</pre>
How to reset:
From the command-line of the Storage Node:<pre>sudo passwd fog</pre>
<br>
<pre>/var/www/fog/commons/config.php
define( "TFTP_FTP_USERNAME", "fog" );
define( "TFTP_FTP_PASSWORD", "****" );</pre>

<pre>define( "STORAGE_FTP_USERNAME", "fog" );
define( "STORAGE_FTP_PASSWORD", "3b4f2a" );</pre>

<pre>define( "MYSQL_DATABASE", "fog" );
define( "MYSQL_USERNAME", "root" );
define( "MYSQL_PASSWORD", "" );</pre>

How to change:
On the node:<pre>sudo vi /var/www/fog/commons/config.php</pre>

Talk:Password Central - Revision history

Itismike: /* MySQL Root Account */