can't install pinba on mysql 5.5.16

[Nafania]

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]

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]

# 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]

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]

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]

Please check the neighboring thread:
http://groups.google.com/group/pinba-engine/browse_thread/thread/7cd4c839c0c80450

[Nafania]

Big thanks. Now all works fine.
Thanks for very usefull extension.

[Antony Dovgal]

On 09/26/2011 02:32 PM, Nafania wrote:
> Big thanks. Now all works fine.
> Thanks for very usefull extension.

You're welcome =)

[Nafania]

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]

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]

I continues this topic in russian group
https://groups.google.com/forum/#!topic/pinba-engine-ru/mQDa18eup-c