#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

[bogatiy...@mail.ru]

• Linux 2.6.32-431.20.3.el6.centos.plus.i686
• MYSQL - 5.1.73-3.el6_5 i686
• HTTPD - 2.2.15-30.el6.centos i686
• PHP - 5.3.3-27.el6_5 i686
• USED SOURCES FOR BUILD - mysql-5.1.73-3.el6_5.src.rpm
• MYSQL CONFIGURE OPTIONS - Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-bugurl=http://bugzilla.redhat.com/bugzilla --enable-bootstrap --enable-shared --enable-threads=posix --enable-checking=release --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-gnu-unique-object --enable-languages=c,c++,objc,obj-c++,java,fortran,ada --enable-java-awt=gtk --disable-dssi --with-java-home=/usr/lib/jvm/java-1.5.0-gcj-1.5.0.0/jre --enable-libgcj-multifile --enable-java-maintainer-mode --with-ecj-jar=/usr/share/java/eclipse-ecj.jar --disable-libjava-multilib --with-ppl --with-cloog --with-tune=generic --with-arch=i686 --build=i686-redhat-linux

COMMANDS USED:

1. #rpm -Uvh mysql-5.1.73-3.el6_5.src.rpm
2. #yum install rpm-build cmake
3. #yum install judy protobuf libevent Judy-devel protobuf-devel libevent-devel
4. #rpmbuild -bp --target=i686 --define 'community 1' mysql.spec
5. #mysqlbug to get mysql configure options
6. #./configure ..options... && cd include && make
7. #tar -xf pinba_engine-1.0.0.tar.gz
8. #cd pinba_engine-1.0.0
9. #./configure --with-mysql=~/rpmbuild/BUILD/mysql-5.1.73 --with-event=/usr --with-judy=/usr --with-protobuf=/usr --with-libdir=/usr/lib/mysql/plugin
10. #make && make install
11. #mv /usr/local/lib/libpinba* /usr/lib/mysql/plugin
12. #mysql -uroot -p
13. #mysql>INSTALL PLUGIN pinba SONAME 'libpinba_engine.so';
14. #mysql>CREATE DATABASE pinba;quit;
15. #service mysqld restart

But when i try to import default_tables.sql I HAVE THE ERROR #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured).

I found out that this error occurs every time when you try to create, import, or delete a field type PINBA. Maybe you tell me how to fix it and where I was wrong.

[Antony Dovgal]

On 07/05/2014 08:01 AM, bogatiy...@mail.ru wrote:
> * Linux 2.6.32-431.20.3.el6.centos.plus.i686
> * MYSQL - 5.1.73-3.el6_5 i686
> * HTTPD - 2.2.15-30.el6.centos i686
> * PHP - 5.3.3-27.el6_5 i686
> * USED SOURCES FOR BUILD - mysql-5.1.73-3.el6_5.src.rpm
> * MYSQL CONFIGURE OPTIONS - Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-bugurl=http://bugzilla.redhat.com/bugzilla --enable-bootstrap --enable-shared --enable-threads=posix --enable-checking=release --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-gnu-unique-object --enable-languages=c,c++,objc,obj-c++,java,fortran,ada --enable-java-awt=gtk --disable-dssi --with-java-home=/usr/lib/jvm/java-1.5.0-gcj-1.5.0.0/jre --enable-libgcj-multifile --enable-java-maintainer-mode --with-ecj-jar=/usr/share/java/eclipse-ecj.jar --disable-libjava-multilib --with-ppl --with-cloog --with-tune=generic --with-arch=i686 --build=i686-redhat-linux
>
>
> COMMANDS USED:
>
> 1. |#rpm -Uvh |mysql-5.1.73-3.el6_5.src.rpm
> 2. |#yum install rpm-build cmake|
> 3. |#yum install judy protobuf libevent Judy-devel protobuf-devel libevent-devel|
> 4. |#rpmbuild -bp --target=i686 --define 'community 1' mysql.spec|
> 5. *#mysqlbug to get mysql configure options*
> 6. /#./configure ..options... && cd include && make/
> 7. |#tar -xf pinba_engine-1.0.0.tar.gz|
> 8. |#cd pinba_engine-1.0.0|
> 9. |#./configure --with-mysql=~/rpmbuild/BUILD/mysql-5.1.73 --with-event=/usr --with-judy=/usr --with-protobuf=/usr --with-libdir=/usr/lib/mysql/plugin|
> 10. |#make && make install|
> 11. |#mv /usr/local/lib/libpinba* /usr/lib/mysql/plugin|
> 12. |#mysql -uroot -p|
> 13. |#mysql>INSTALL PLUGIN pinba SONAME 'libpinba_engine.so';|
> 14. |#mysql>CREATE DATABASE pinba;quit;|
> 15. #service mysqld restart

>
>
> But when i try to import |default_tables.sql I HAVE THE ERROR |#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured).
>
> I found out that this error occurs every time when you try to create, import, or delete a field type PINBA. Maybe you tell me how to fix it and where I was wrong.

Are you sure the server is running?
Are you sure the configure options are identical to the options used to build the RPM packet?
What do you see in the mysql log?

--
Wbr,
Antony Dovgal
---
http://pinba.org - realtime profiling for PHP

[bogatiy...@mail.ru]

Are you sure the server is running?
Are you sure the configure options are identical to the options used to build the RPM packet?
What do you see in the mysql log?

1) Yes becouse all sites work.
2) I get configure options from "/usr/lib/mysql/mysqlbug" file used vi editor. Seems to i found my mistake. Looks like I'm not used all the configuration options from a file. All my options from file mysqlbug:

CONFIGURE_LINE = "./configure  '--build=i386-redhat-linux-gnu' '--host=i386-redhat-linux-gnu' '--target=i686-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/var/lib' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--with-readline' '--with-ssl=/usr' '--without-debug' '--enable-shared' '--with-embedded-server' '--localstatedir=/var/lib/mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-mysqld-user=mysql' '--with-extra-charsets=all' '--with-big-tables' '--with-pic' '--with-plugin-innobase' '--with-plugin-innodb_plugin' '--with-plugin-partition' '--enable-local-infile' '--enable-largefile' '--enable-thread-safe-client' '--disable-dependency-tracking' 'build_alias=i386-redhat-linux-gnu' 'host_alias=i386-redhat-linux-gnu' 'target_alias=i686-redhat-linux-gnu' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i686 -mtune=atom -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -fPIC' 'CXXFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i686 -mtune=atom -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -fPIC -felide-constructors -fno-rtti -fno-exceptions'";

3) I already cleaned log file. I try to install the "Pinba" again and if any problems stay i give you the log file.

[bogatiy...@mail.ru]

Yuuuuppeeee! I install it and all is ok. Now try to install Intaro Pinboard. The mistake with configure options. When i get full configure line from "/usr/lib/mysql/mysqlbug" and configure with it, all working. Thanks!

[Antony Dovgal]

On 07/06/2014 05:27 PM, bogatiy...@mail.ru wrote:
> Yuuuuppeeee! I install it and all is ok. Now try to install Intaro Pinboard. The mistake with configure options. When i get full configure line from "/usr/lib/mysql/mysqlbug" and configure with it, all working. Thanks!

Great!

Btw, there's also a Russian-speaking list for Pinba: pinba-e...@googlegroups.com
(Just in case you don't know about it)