This discussion is archived
2 Replies Latest reply: Dec 10, 2012 3:50 AM by 861120 RSS

Unable to start extract for Mysql DB on windows

902923 Newbie
Currently Being Moderated
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
  • 1. Re: Unable to start extract for Mysql DB on windows
    902923 Newbie
    Currently Being Moderated
    Hi Experts,

    I can able to connect mysql db from GGSCI with dboption test@<ip address>, useris ogg, Password ****


    But,

    after configuring extract process and start , getting below error ,


    2012-12-04 23:00:12 ERROR OGG-00146 VAM function VAMInitialize returned unexpected result: error 600 - VAM Client Report <CAUSE OF FAILURE : Failed to conne
    ct to mysql database
    WHEN FAILED : While initializing mysql context
    WHERE FAILED : MySQLBinLog Reader Module
    CONTEXT OF FAILURE : No Information Available!>.

    2012-12-04 23:00:12 ERROR OGG-01668 PROCESS ABENDING.

    please help on this to resolve.
  • 2. Re: Unable to start extract for Mysql DB on windows
    861120 Explorer
    Currently Being Moderated
    Hi ...

    Please check if the mysql_home variable is ok:

    MYSQL_HOME=<MySQL bin location>


    To locate the configuration file, Extract checks the MYSQL_HOME environment variable: If MYSQL_HOME is set, Extract uses the configuration file in the specified directory. If MYSQL_HOME is not set, Extract queries the information_schema.global_variables table to determine the MySQL installation directory.

    More details: http://docs.oracle.com/cd/E35209_01/doc.1121/e27289.pdf

    Try it and put here your experiences.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points