search

zkfan / tungsten-replicator

Automatically exported from code.google.com/p/tungsten-replicator
0 stars 0 forks source link

Install missing server ID #111

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Install MySQL and test native replication - Turn off
2. Install Tungsten 2.0.4
3. run  tools/tungsten-installer --direct --master-host=db --slave-host=db3 
--master-password=P@ssw0rd --service-name=tungprod

What is the expected output?
I expect it to install.

What do you see instead?
#####################################################################
# There are errors with the values provided in the configuration file
#####################################################################
---------------------------------------------------------------------
ERROR >> Dataserver db_3306: MySQL server ID
ERROR >> > Message: Value is missing
ERROR >> > Config Key: dataservers.db_3306.repl_mysql_server_id
---------------------------------------------------------------------
ERROR >> Dataserver db3_3306: MySQL server ID
ERROR >> > Message: Value is missing
ERROR >> > Config Key: dataservers.db3_3306.repl_mysql_server_id
---------------------------------------------------------------------

What version of the product are you using? 
2.0.4

On what operating system?
CentOS 5.6 on VMware 4.1

Please provide any additional information below.
DB1 mysql> mysql -e "show global variables like 'server_id'"
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 1     |
+---------------+-------+

DB3 mysql> mysql -e "show global variables like 'server_id'"
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 2     |
+---------------+-------+

# grep ID /etc/my.cnf
server_id               = 2             # each server doing replication 
requires a unique ID

Original issue reported on code.google.com by mark.grennan on 13 Jun 2011 at 5:49

GoogleCodeExporter commented 9 years ago 
This problem happens because you have not provides username and password in 
your installation command.

--datasource-DATABASE_USER
--datasource-DATABASE_PASSWORD

Also, notice that --master-password and --slave-host are not accepted options.

Please refer to this article for some working examples:
http://datacharmer.blogspot.com/2011/06/getting-started-with-tungsten.html

Original comment by g.maxia on 13 Jun 2011 at 6:34