GoldenGate

Hi,

I have installed Mysql database on windows machine, also installed GoldenGate

and i have edited the my.cnf (C:\Program Files\MySQL\MySQL Server 5.5) file with below entries,

log-bin="C:\Program Files\MySQL\MySQL Server 5.5\test-bin.log"

max_binlog_size=4096

binlog_format=row

and restarted the mysql service then add the mgr prm and created extract process.

while trying to connect the mysql db from ggsci getting below error message

GGSCI (PC) 29> dblogin sourcedb test, userid root
Password:


2012-12-04 15:05:04 WARNING OGG-00769 MySQL Login failed: . SQL error (2003).
Can't connect to MySQL server on 'localhost' (10061).
ERROR: Failed to connect to MySQL database engine for HOST localhost, DATABASE t
est, USER root, PORT 3306.

also Unable to start the extract process



edit params exta


extract exta

dboptions host localhost, connectionport 3306

sourcedb test, userid root, password *****

exttrail E:\ogg_mysql\dirdat\ea

table test.*;

tried with exact hostname and localhost also but no luck.


but i can able to connect the mysql through command prompt

C:\Users\>mysql -u root test -p

Enter password: ******

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.28-log MySQL Community Server (GPL)

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Edited by: 899920 on Dec 4, 2012 1:44 AM