enterprise-support team mailing list archive

[Milind Srivastava <milindsrivastava05@xxxxxxxxx>]

Public bug reported:

[root@pa-db4-qa mydumper-0.5.2]#pwd
/home/dbteam/software
[root@pa-db4-qa software]# ls -lrth
total 3.3G
-rw-r--r-- 1 root      root       35K Nov 19  2012 mydumper-0.5.2.tar.gz
drwxr-xr-x 4 root      root      4.0K Jul 24 06:03 mydumper-0.5.2
[root@pa-db4-qa software]#cd mydumper-0.5.2
[root@pa-db4-qa mydumper-0.5.2]#pwd
/home/dbteam/software/mydumper-0.5.2
[root@pa-db4-qa mydumper-0.5.2]# ls -lrth
total 120K
-rw-r--r-- 1 root root 1.1K Nov 19  2012 server_detect.h
-rw-r--r-- 1 root root 1.6K Nov 19  2012 server_detect.c
-rw-r--r-- 1 root root 2.3K Nov 19  2012 README
-rw-r--r-- 1 root root 1.3K Nov 19  2012 myloader.h
-rw-r--r-- 1 root root  13K Nov 19  2012 myloader.c
-rw-r--r-- 1 root root 1.7K Nov 19  2012 mydumper.h
-rw-r--r-- 1 root root  44K Nov 19  2012 mydumper.c
-rw-r--r-- 1 root root  339 Nov 19  2012 g_unix_signal.h
-rw-r--r-- 1 root root 3.6K Nov 19  2012 g_unix_signal.c
-rw-r--r-- 1 root root   76 Nov 19  2012 config.h.in
-rw-r--r-- 1 root root 2.1K Nov 19  2012 common.h
-rw-r--r-- 1 root root 2.1K Nov 19  2012 CMakeLists.txt
-rw-r--r-- 1 root root 1.3K Nov 19  2012 binlog.h
-rw-r--r-- 1 root root 8.0K Nov 19  2012 binlog.c
drwxr-xr-x 3 root root 4.0K Jul 24 06:03 cmake
drwxr-xr-x 4 root root 4.0K Jul 24 06:03 docs
[root@pa-db4-qa mydumper-0.5.2]#           
cmake . -DCMAKE_INSTALL_PREFIX=/home/dbteam/software/mydumper-0.5.2/

-- The C compiler identification is GNU
-- The CXX compiler identification is GNU
-- Check for working C compiler: /usr/bin/gcc
-- Check for working C compiler: /usr/bin/gcc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Using mysql-config: /usr/bin/mysql_config
-- Found MySQL: /usr/include/mysql, /usr/lib64/mysql/libmysqlclient_r.so;/usr/lib64/libz.so;/usr/lib64/libpthread.so;/usr/lib64/libcrypt.so;/usr/lib64/libnsl.so;/usr/lib64/libm.so;/usr/lib64/libpthread.so;/usr/lib64/libssl.so;/usr/lib64/libcrypto.so
-- Found ZLIB: /usr/lib64/libz.so
-- checking for one of the modules 'glib-2.0'
--   found glib-2.0, version 2.26.1
-- checking for one of the modules 'gthread-2.0'
--   found gthread-2.0, version 2.26.1
-- checking for module 'libpcre'
--   found libpcre, version 7.8
-- Found PCRE: /usr/include

WARNINGUnable to find Sphinx documentation generator
-- ------------------------------------------------
-- MYSQL_CONFIG = /usr/bin/mysql_config
-- CMAKE_INSTALL_PREFIX = /home/dbteam/software/mydumper-0.5.2/
-- BUILD_DOCS = ON
-- RUN_CPPCHECK = OFF
-- Change a values with: cmake -D<Variable>=<Value>
-- ------------------------------------------------
-- 
-- Configuring done
-- Generating done
-- Build files have been written to: /home/dbteam/software/mydumper-0.5.2
[root@pa-db4-qa mydumper-0.5.2]# make install
Scanning dependencies of target mydumper
[ 20%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o
[ 40%] Building C object CMakeFiles/mydumper.dir/binlog.c.o
[ 60%] Building C object CMakeFiles/mydumper.dir/server_detect.c.o
[ 80%] Building C object CMakeFiles/mydumper.dir/g_unix_signal.c.o
Linking C executable mydumper
[ 80%] Built target mydumper
Scanning dependencies of target myloader
[100%] Building C object CMakeFiles/myloader.dir/myloader.c.o
Linking C executable myloader
[100%] Built target myloader
Install the project...
-- Install configuration: ""
-- Installing: /usr/local/bin/mydumper
-- Removed runtime path from "/usr/local/bin/mydumper"
-- Installing: /usr/local/bin/myloader
-- Removed runtime path from "/usr/local/bin/myloader"
[root@pa-db4-qa mydumper-0.5.2]#  cd bin
[root@pa-db4-qa bin]# ./mydumper -o /dbdunps/mydumper/ -r 100000 -c -e -m -u root -p -h 10.10.2.24 --port=3306 --database=test -t 4

** (mydumper:12619): CRITICAL **: Error connecting to database: Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(2)


-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[root@pa-db4-qa bin]#            mysql_config
Usage: /usr/lib64/mysql/mysql_config [OPTIONS]
Options:
        --cflags         [-I/usr/include/mysql  -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -fPIC   -DUNIV_LINUX -DUNIV_LINUX]
        --include        [-I/usr/include/mysql]
        --libs           [-rdynamic -L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lssl -lcrypto]
        --libs_r         [-rdynamic -L/usr/lib64/mysql -lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm -lpthread -lssl -lcrypto]
        --plugindir      [/usr/lib64/mysql/plugin]
        --socket         [/var/lib/mysql/mysql.sock]
        --port           [0]
        --version        [5.1.73]
        --libmysqld-libs [-rdynamic -L/usr/lib64/mysql -lmysqld -ldl -lz -lpthread -lcrypt -lnsl -lm -lpthread -lrt -lssl -lcrypto]

Hi there, Please help me out I am unable to connect to mydumper.
Everytime I fire dump command it gives me above mentioned error. I am a
new user of mydumper. Please tell me how this issue can be solved.????
On this Linux Box I have one instance of mysql and two instances of
percona server please tell me how could i connect to percona server for
logical backup using mydumper.

Using Linux 2.6.32-358.18.1.el6.x86_64 #1 SMP Wed Aug 28 17:19:38 UTC
2013 x86_64 x86_64 x86_64 GNU/Linux  (RHEL)

** Affects: mydumper
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1353861

Title:
  Unable to connect to Percona Server from socket.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mydumper/+bug/1353861/+subscriptions