can't install pinba on mysql 5.5.16

348 views
Skip to first unread message

Nafania

unread,
Sep 23, 2011, 5:26:10 PM9/23/11
to pinba-...@googlegroups.com
CentOS release 5.7 (Final)

cd pinba_engine-0.0.6
./configure --with-mysql=/usr
...
checking for MySQL source code... /usr
checking for MySQL version >= 5.1... configure: error: MySQL 5.1+ is required

# mysql -V
mysql  Ver 14.14 Distrib 5.5.16, for Linux (x86_64) using readline 5.1

what can i do to install pinba?

Antony Dovgal

unread,
Sep 24, 2011, 7:39:25 AM9/24/11
to pinba-...@googlegroups.com
On 09/24/2011 01:26 AM, Nafania wrote:
> CentOS release 5.7 (Final)
>
> cd pinba_engine-0.0.6
>
> ./configure --with-mysql=/usr
>
> ...
> checking for MySQL source code... /usr
> checking for MySQL version>= 5.1... configure: error: MySQL 5.1+ is
> required

Did you really put MySQL *sources* into /usr ?

> # mysql -V
> mysql Ver 14.14 Distrib 5.5.16, for Linux (x86_64) using readline 5.1
>
> what can i do to install pinba?

You can start with this:
http://pinba.org/wiki/Manual:Installation#Installation_requirements

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

Nafania

unread,
Sep 25, 2011, 4:48:04 AM9/25/11
to Pinba Engine development list
# ls /usr/include/mysql
decimal.h m_ctype.h my_attribute.h my_config_x86_64.h
my_getopt.h my_net.h mysql_com.h mysql_embed.h
mysql_version.h plugin_audit.h sql_common.h sslopt-longopts.h
errmsg.h m_string.h my_compiler.h my_dbug.h
my_global.h my_pthread.h mysqld_ername.h mysql.h
my_sys.h plugin_ftparser.h sql_state.h sslopt-vars.h
keycache.h my_alloc.h my_config.h my_dir.h
my_list.h mysql mysqld_error.h mysql_time.h
my_xml.h plugin.h sslopt-case.h typelib.h

Antony Dovgal

unread,
Sep 25, 2011, 6:53:14 AM9/25/11
to pinba-...@googlegroups.com
On 09/25/2011 12:48 PM, Nafania wrote:
> # ls /usr/include/mysql
> decimal.h m_ctype.h my_attribute.h my_config_x86_64.h
> my_getopt.h my_net.h mysql_com.h mysql_embed.h
> mysql_version.h plugin_audit.h sql_common.h sslopt-longopts.h
> errmsg.h m_string.h my_compiler.h my_dbug.h
> my_global.h my_pthread.h mysqld_ername.h mysql.h
> my_sys.h plugin_ftparser.h sql_state.h sslopt-vars.h
> keycache.h my_alloc.h my_config.h my_dir.h
> my_list.h mysql mysqld_error.h mysql_time.h
> my_xml.h plugin.h sslopt-case.h typelib.h

Right, that's MySQL headers.
Don't you see any difference between sources and headers?

Nafania

unread,
Sep 26, 2011, 5:03:04 AM9/26/11
to pinba-...@googlegroups.com
Big thanks for your help. I'm not a profi at linux and some things can't understand right.
Now i have configure and make pinba succefully (I think), but i have another problem.

mysql> INSTALL PLUGIN pinba SONAME 'libpinba_engine.so';
ERROR 1126 (HY000): Can't open shared library '/usr/lib64/mysql/plugin/libpinba_engine.so' (errno: 2 undefined symbol: _db_enter_)

what this mean? What should i do?

Antony Dovgal

unread,
Sep 26, 2011, 5:18:47 AM9/26/11
to pinba-...@googlegroups.com

Nafania

unread,
Sep 26, 2011, 6:32:41 AM9/26/11
to pinba-...@googlegroups.com
Big thanks. Now all works fine.
Thanks for very usefull extension.

Antony Dovgal

unread,
Sep 26, 2011, 6:38:25 AM9/26/11
to pinba-...@googlegroups.com
On 09/26/2011 02:32 PM, Nafania wrote:
> Big thanks. Now all works fine.
> Thanks for very usefull extension.

You're welcome =)

Nafania

unread,
Sep 26, 2011, 3:51:07 PM9/26/11
to pinba-...@googlegroups.com
Not fine as i think.
Extension and engine are loaded sucefully (no errors from mysql or php).
Extension is enabled in php (as see in phpinfo());
Engine enabled too (as see at netstat).
But all mysql tables are empty.

I dont' try timers yet, but is this a correct behavior?
Are tables must be empty?

Antony Dovgal

unread,
Sep 27, 2011, 1:29:40 AM9/27/11
to pinba-...@googlegroups.com
On 09/26/2011 11:51 PM, Nafania wrote:
> Not fine as i think.
> Extension and engine are loaded sucefully (no errors from mysql or php).
> Extension is enabled in php (as see in phpinfo());
> Engine enabled too (as see at netstat).
> But all mysql tables are empty.

Show me what you see with `SHOW CREATE TABLE request`, for example.



> I dont' try timers yet, but is this a correct behavior?
> Are tables must be empty?

Their contents is dynamic, so if you have any requests incoming (do you? you didn't specify this),
you should see some data in the tables, too.

Nafania

unread,
Sep 27, 2011, 4:06:31 AM9/27/11
to Pinba Engine development list
I continues this topic in russian group
https://groups.google.com/forum/#!topic/pinba-engine-ru/mQDa18eup-c
Reply all
Reply to author
Forward
0 new messages