[Fog] Fog v0.27 installation problem on Ubuntu 9.04 server

[coolgeekone]

Hi guys,
I'm trying to setup Fog v0.27 on Ubuntu 9.04 server. Here are the steps I took.

1. Downloaded and installed Ubuntu 9.04 Server on a spare box, choose LAMP and SSH server options during setup.
2. Downloaded Fog v0.27 from here Download FOG - A Free Cloning Solution from SourceForge.net
3. I am trying to follow the wiki, FOGUserGuide - FOGWiki, ran sudo ./installfog.sh


We are about to install MySQL Server on
this server, if MySQL isn't installed already
you will be prompted for a root password. If
you don't leave it blank you will need to change
it in the config.php file located at:

/var/www/fog/commons/config.php

Press enter to acknowledge this message.

4. I press enter
5. The script finishes without any errors.

Setup complete!

You still need to install/update your database schema.
This can be done by opening a web browser and going to:

http://192.168.1.20/fog/management

Default User:
Username: fog
Password: password
6. I launch Firefox and navigate to http://192.168.1.20/fog/management and get the following error message.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /var/www/fog/management/index.php on line 47
Unable to connect to Database

I did not set a Mysql database password during the installation, I couldn't choose a password, just was informed that it is blank.

Here is my config.php from /opt/fog/service/etc

define( "MYSQL_DATABASE", "fog" );
define( "MYSQL_USERNAME", "" );
define( "MYSQL_PASSWORD", "" );

define( "LOGMAXSIZE", "1000000" );

define( "REPLICATORLOGPATH", "/opt/fog/log/fogreplicator.log" );
define( "REPLICATORDEVICEOUTPUT", "/dev/tty3" );
define( "REPLICATORSLEEPTIME", 600 );
define( "REPLICATORIFCONFIG", "/sbin/ifconfig" );
define( "SCHEDULERLOGPATH", "/opt/fog/log/fogscheduler.log" );
define( "SCHEDULERDEVICEOUTPUT", "/dev/tty4" );
define( "SCHEDULERWEBROOT", "/var/www/fog" );
define( "SCHEDULERSLEEPTIME", 60 );
?>

Here is config.php from /var/www/fog/commons

<?php
/*
* FOG is a computer imaging solution.
* Copyright (C) 2007 Chuck Syperski & Jian Zhang
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*
*/

define( "IS_INCLUDED", true );
define( "TFTP_HOST", "192.168.1.20" );
define( "TFTP_FTP_USERNAME", "fog" );
define( "TFTP_FTP_PASSWORD", "305955023a73b981bafdb59541e54a32" );
define( "TFTP_PXE_CONFIG_DIR", "/tftpboot/pxelinux.cfg/" );
define( "TFTP_PXE_KERNEL_DIR", "/tftpboot/fog/kernel/" );
define( "PXE_KERNEL", "fog/kernel/bzImage" );
define( "PXE_KERNEL_RAMDISK", 127000 );
define( "USE_SLOPPY_NAME_LOOKUPS", "1");
define( "MEMTEST_KERNEL", "fog/memtest/memtest" );
define( "PXE_IMAGE", "fog/images/init.gz" );
define( "PXE_IMAGE_DNSADDRESS", "" );
define( "STORAGE_HOST", "192.168.1.20" );
define( "STORAGE_FTP_USERNAME", "fog" );
define( "STORAGE_FTP_PASSWORD", "305955023a73b981bafdb59541e54a32" );
define( "STORAGE_DATADIR", "/images/" );
define( "STORAGE_DATADIR_UPLOAD", "/images/dev/" );
define( "STORAGE_BANDWIDTHPATH", "/fog/status/bandwidth.php" );
define( "CLONEMETHOD", "ntfsclone" ); // valid values partimage, ntfsclone
define( "UPLOADRESIZEPCT", 5 );
define( "WEB_HOST", "192.168.1.20" );
define( "WEB_ROOT", "/fog/" );
define( "WOL_HOST", "192.168.1.20" );
define( "WOL_PATH", "/fog/wol/wol.php" );
define( "WOL_INTERFACE", "eth0" );
define( "SNAPINDIR", "/opt/fog/snapins/" );
define( "QUEUESIZE", "10" );
define( "CHECKIN_TIMEOUT", 600 );
define( "MYSQL_HOST", "localhost" );
define( "MYSQL_DATABASE", "fog" );
define( "MYSQL_USERNAME", "root" );
define( "MYSQL_PASSWORD", "" );
define( "USER_MINPASSLENGTH", 4 );
define( "USER_VALIDPASSCHARS", "1234567890ABCDEFGHIJKLMNOPQRSTUVWZXYabcdefghijklm nopqrstuvwxyz$
define( "NFS_ETH_MONITOR", "eth0" );
define("UDPCAST_INTERFACE","eth0");
define("UDPCAST_STARTINGPORT", 63100 ); // Must be an $
define("FOG_MULTICAST_MAX_SESSIONS", 64 );
define( "FOG_JPGRAPH_VERSION", "2.3" );
define( "FOG_REPORT_DIR", "./reports/" );
define( "FOG_THEME", "blackeye/blackeye.css" );
define( "FOG_UPLOADIGNOREPAGEHIBER", "1" );
define( "FOG_VERSION", "0.27" );
define( "FOG_SCHEMA", 19);
?>


Any thoughts?

Thanks.

[clarky2k3]

You need to set the mysql username to root in /opt/fog/service/etc

define( "MYSQL_USERNAME", "root" );

[theibm]

Had the FOG issue: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /var/www/fog/management/index.php

This is caused by the FOG PHP session looking to connect to 'localhost', the correct password is not being passed causing the failure. Not having time to research the exact fix I found the following is a quick solution.....

Before trying to open the FOG management webpage
Install PHPMYADMIN (this makes database management easy)
Open //localhost/phpmyadmin
Create a new user and give them ALL permissions for ALL HOSTS (basically they should be the same as ROOT
Check the user is there and the permissions are set correctly.
Go into the PERMISSIONS tab and remove the password for ROOT under localhost & 127.0.0.1
Open the FOG webmanagement page
Set up the users in FOG
Go back to PHPMyAdmin and make sure FOG has been added as a database. You will need to log on as the 'new user' above
Reset the root password to something secure (as per pre install???)
Open the FOG database
Go to Permissions and BLANK the root password for localhost & 127.0.0.1

That should solve the issue.

[pnlrogue1]

You're a star! Thanks!