+ Post New Thread
Results 1 to 4 of 4
O/S Deployment Thread, Fog v0.27 installation problem on Ubuntu 9.04 server in Technical; Hi guys, I'm trying to setup Fog v0.27 on Ubuntu 9.04 server. Here are the steps I took. 1. Downloaded ...
  1. #1

    Join Date
    Mar 2009
    Location
    Calgary
    Posts
    6
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Fog v0.27 installation problem on Ubuntu 9.04 server

    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.
    Last edited by ZeroHour; 6th October 2009 at 04:13 PM.

  2. #2
    clarky2k3's Avatar
    Join Date
    Nov 2007
    Location
    Northumberland
    Posts
    318
    Thank Post
    35
    Thanked 47 Times in 39 Posts
    Rep Power
    24
    You need to set the mysql username to root in /opt/fog/service/etc

    define( "MYSQL_USERNAME", "root" );
    Last edited by clarky2k3; 27th August 2009 at 06:33 PM.

  3. Thanks to clarky2k3 from:

    coolgeekone (27th August 2009)

  4. #3
    theibm's Avatar
    Join Date
    Oct 2009
    Location
    Dunedin NZ
    Posts
    1
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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.

  5. Thanks to theibm from:

    pnlrogue1 (18th December 2009)

  6. #4
    pnlrogue1's Avatar
    Join Date
    Jul 2008
    Location
    Edinburgh, Scotland
    Posts
    72
    Thank Post
    37
    Thanked 5 Times in 3 Posts
    Rep Power
    13
    You're a star! Thanks!

SHARE:
+ Post New Thread

Similar Threads

  1. [Fog] FOG problem
    By Jed in forum O/S Deployment
    Replies: 32
    Last Post: 21st September 2011, 01:13 PM
  2. [Fog] Expanding fog server
    By reggiep in forum O/S Deployment
    Replies: 20
    Last Post: 28th January 2010, 11:49 AM
  3. [Fog] DHCP/PXE problem
    By danboid in forum O/S Deployment
    Replies: 3
    Last Post: 18th August 2009, 01:58 PM
  4. Proxy on Ubuntu for Fog
    By rocknrollstar in forum *nix
    Replies: 15
    Last Post: 20th May 2009, 04:04 PM
  5. [Fog] Fog server
    By clarky2k3 in forum O/S Deployment
    Replies: 7
    Last Post: 15th April 2009, 12:26 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •