+ Post New Thread
Results 1 to 10 of 10
O/S Deployment Thread, Can't replicate to storage node in Technical; I'm having problems setting up my storage node and getting the replication working so that the master node copies all ...
  1. #1

    Join Date
    Apr 2010
    Location
    UK
    Posts
    7
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Can't replicate to storage node

    I'm having problems setting up my storage node and getting the replication working so that the master node copies all of its stored images across.

    I'm running ubuntu 9.10 server on the node and 9.04 desktop on the main system.

    I've got a feeling it's something to do with the MySQL on the main server having a root password but I'm no good with MySQL (this is the first time I've had to deal with it in fact). The fogreplicator.log on the main machine keeps reporting:

    Code:
    Failed to connect to database server, will try again in next iteration.
    This is my config.php from the node:

    Code:
    <?php
    define( "UPDSENDERPATH", "/usr/local/sbin/udp-sender" );
    define( "MULTICASTLOGPATH", "/opt/fog/log/multicast.log" );
    define( "MULTICASTDEVICEOUTPUT", "/dev/tty2" );
    define( "MULTICASTSLEEPTIME", 10 );
    define( "MULTICASTINTERFACE", "eth0" );
    define( "UDPSENDER_MAXWAIT", null );
    
    define( "MYSQL_HOST", "172.30.249.200" );
    define( "MYSQL_DATABASE", "fog" );
    define( "MYSQL_USERNAME", "fogstorage" );
    define( "MYSQL_PASSWORD", "31c09b" );
    
    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 );
    ?>
    If anybody can give me a pointer with this I'd be really grateful. Anything else needed to progress, let me know and I'll post any log files or config files I have.

    Thanks

  2. #2
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,235
    Thank Post
    162
    Thanked 153 Times in 138 Posts
    Rep Power
    104
    Hello,

    On MySQL have you allowed connections for any rather than just localhost for the user root?

    Cheers,

  3. #3

    Join Date
    Apr 2010
    Location
    UK
    Posts
    7
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I don't think I have. How would I check?

    Many thanks.

  4. #4
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,235
    Thank Post
    162
    Thanked 153 Times in 138 Posts
    Rep Power
    104
    If you don't have PHPMyadmin e.g., http://fogserver/phpmyadmin as a control panel...

    MySql: Give Root User Logon Permission From Any Host - How-To Geek

    You need to connect to MySQL for the above.


    If you have PHPmyadmin let me know and i'll make some screen grabs.

  5. Thanks to dwhyte85 from:

    clarknova (29th April 2010)

  6. #5

    Join Date
    Apr 2010
    Location
    UK
    Posts
    7
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I don't have phpmyadmin installed. Can I install it and access through a web interface? I'm running everything through ssh currently to interact with the server and node becuase I haven't installed a GUI.

    Ok, here's the output I'm getting from the link you provided:
    Code:
    mysql> use mysql;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    
    Database changed
    mysql> select host, user from user;
    +-----------+------------------+
    | host      | user             |
    +-----------+------------------+
    | %         | fogstorage       | 
    | 127.0.0.1 | root             | 
    | fog       | root             | 
    | localhost | debian-sys-maint | 
    | localhost | root             | 
    +-----------+------------------+
    5 rows in set (0.00 sec)
    I need to do this on the main server, is that correct?

    I'll then add this:

    update user set host=’%’ where user=’root’ and host=’fog’;
    flush privileges;

    As described in the link. Do I then need to make any changes to the config.php files on the server or node?

    Thanks again, I really appreciate your help.

  7. #6

    Join Date
    Apr 2010
    Location
    UK
    Posts
    7
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Will PHPmyadmin be useful to me? I'm way out of my depth here with PHP and MySQL. I only ever do a bit of BASH scripting usually!

    It's in the Ubuntu server repos so I can install it if you think it's going to make troubleshooting this problem easier.

  8. #7
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,235
    Thank Post
    162
    Thanked 153 Times in 138 Posts
    Rep Power
    104
    Hi clarknova,

    The first post - no you dont change the config files and just follow the guide, it makes a change on MySQL saying any IP/Host can connect with root user.

    PHPMyadmin is a cool web gui, i like it - if you know what you're doing, install it :-)

  9. #8

    Join Date
    Apr 2010
    Location
    UK
    Posts
    7
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hmm, I'm doing something wrong here:

    Code:
    mysql> update user set host=’%’ where user=’root’ and host=’fog’; flush priveleges;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '��%’ where user=’root’ and host=’fog’' at line 1
    Can you see what's wrong?

  10. #9

    Join Date
    Apr 2010
    Location
    UK
    Posts
    7
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Never mind, I think I've managed to issue those commands now (typed them instead of copy/paste - I wonder why that should make a difference!")

    So the node should now connect successfully regardless of username and password? I don't need to provide it with the root user password or something similar in the config file?

  11. #10

    Join Date
    Apr 2010
    Location
    UK
    Posts
    7
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Ok, well I've done that and still no joy.

    This is my /usr/fog/service/etc/config.php from my main server:

    Code:
    <?php
    define( "UPDSENDERPATH", "/usr/local/sbin/udp-sender" );
    define( "MULTICASTLOGPATH", "/opt/fog/log/multicast.log" );
    define( "MULTICASTDEVICEOUTPUT", "/dev/tty2" );
    define( "MULTICASTSLEEPTIME", 10 );
    define( "MULTICASTINTERFACE", "eth1" );
    define( "UDPSENDER_MAXWAIT", null );
    
    define( "MYSQL_HOST", "172.30.249.200" );
    define( "MYSQL_DATABASE", "fog" );
    define( "MYSQL_USERNAME", "root" );
    define( "MYSQL_PASSWORD", "mypassword" );
    
    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 );
    ?>

    And this is the one from my node:

    Code:
    <?php
    define( "UPDSENDERPATH", "/usr/local/sbin/udp-sender" );
    define( "MULTICASTLOGPATH", "/opt/fog/log/multicast.log" );
    define( "MULTICASTDEVICEOUTPUT", "/dev/tty2" );
    define( "MULTICASTSLEEPTIME", 10 );
    define( "MULTICASTINTERFACE", "eth1" );
    define( "UDPSENDER_MAXWAIT", null );
    
    define( "MYSQL_HOST", "172.30.249.200" );
    define( "MYSQL_DATABASE", "fog" );
    define( "MYSQL_USERNAME", "root" );
    define( "MYSQL_PASSWORD", "mypassword" );
    
    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 );
    ?>
    Should I be able to log in successfully with these config files? Do I need to change the password fields within the FOG management console for it to work?

    Apologies for what are probably silly questions and thanks again.



SHARE:
+ Post New Thread

Similar Threads

  1. Remove one server node in WSUS
    By sparkeh in forum Windows Server 2008 R2
    Replies: 0
    Last Post: 3rd February 2010, 10:01 AM
  2. How Do I Get My Domain Controllers To Replicate
    By dgrams in forum How do you do....it?
    Replies: 4
    Last Post: 31st January 2010, 05:42 PM
  3. Cluster Node Repair
    By DrPerceptron in forum Windows
    Replies: 1
    Last Post: 13th January 2009, 11:41 AM
  4. Changed password slow to replicate
    By ZeroHour in forum Windows
    Replies: 2
    Last Post: 24th October 2008, 11:05 AM
  5. Cluster Node has lost active resources
    By stu1892 in forum Windows
    Replies: 7
    Last Post: 4th August 2008, 02:48 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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