2 Replies Latest reply: Dec 10, 2012 5:50 AM by 861120 RSS

    Unable to start extract for Mysql DB on windows

    902923
      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
          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
            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.