error: 'memcached_st' has no member named 'hosts'

[david]

I am trying to install version 1.1 on centos 5.4 32bit and get this error on make

Making all in src
make[1]: Entering directory `/root/memcached_functions_mysql-1.1/src'
make all-am
make[2]: Entering directory `/root/memcached_functions_mysql-1.1/src'
/bin/sh ../libtool --preserve-dup-deps --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I../include -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -I/usr/local/lib//include -g -O2 -MT servers.lo -MD -MP -MF .deps/servers.Tpo -c -o servers.lo servers.c
 gcc -DHAVE_CONFIG_H -I. -I../include -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -I/usr/local/lib//include -g -O2 -MT servers.lo -MD -MP -MF .deps/servers.Tpo -c servers.c -fPIC -DPIC -o .libs/servers.o
servers.c: In function 'memc_servers_set':
servers.c:122: error: 'memcached_st' has no member named 'hosts'
servers.c:123: error: 'memcached_st' has no member named 'hosts'
servers.c:124: error: 'memcached_st' has no member named 'hosts'
make[2]: *** [servers.lo] Error 1
make[2]: Leaving directory `/root/memcached_functions_mysql-1.1/src'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/root/memcached_functions_mysql-1.1/src'
make: *** [all-recursive] Error 1

How do you correct this error?

[Ashish Disawal (ashish-disawal)]

I had got this error when I had used "libmemcached-0.38".
When I installed "libmemcached-0.37", memcached_functions_mysql-0.8 got compiled without any error.

[Ashish Disawal (ashish-disawal)]

I got some more errors while creating the functions from 'sql/install_functions.sql'.
After a lot of trying the combination of "libmemcached-0.31" and "memcached_functions_mysql-0.8" worked for me.

[david (mailsort)]

I tried with version libmemcached-0.37 with memcached functions 1.1 and I get this error.

ERROR 1126 (HY000) at line 38: Can't open shared library 'libmemcached_functions_mysql.so' (errno: 22 /usr/lib/mysql/libmemcached_functions_mysql.so: undefined symbol: memcached_string_append)

Seems version 1.0 have same problem. In fact I am having trouble compiling in centos 64bit with the older versions as it cannot find the path of libmemcached. Perhaps some info in the readme can state what exact os is this compiling file in.

[david (mailsort)]

the above error is when attempting to finish the installation with the functions file.

[Callum Guy (callum-guy)]

I have been trying to get these functions working all week to limited success. I've been starting over with a fresh install of Centos 5.4 i386, MySQL 5.1.45 and also testing with PHP 5.3.2. As suggested i have tried to limit the versions to libmemcached-0.31/libmemcached-devel-0.31/memcached_functions_mysql-0.8 however this only enabled me to create the UDFs but not to use them. Once installed at this version i can get some return from the functions, but simply get disconnected as follows:

mysql> SELECT memc_servers_set('192.168.4.211:11211');
+-----------------------------------------+
| memc_servers_set('192.168.4.211:11211') |
+-----------------------------------------+
| 0 |
+-----------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT memc_set('mykey', 'Getting this with SELECT means all works well');
ERROR 2013 (HY000): Lost connection to MySQL server during query

Oddly enough this error was not consistent and on some occasions i can do the following before it fails:

mysql> SELECT memc_set('mykey', 'Getting this with SELECT means all works well');
+--------------------------------------------------------------------+
| memc_set('mykey', 'Getting this with SELECT means all works well') |
+--------------------------------------------------------------------+
| 20 |
+--------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT memc_get('mykey');
+-------------------+
| memc_get('mykey') |
+-------------------+
| NULL |
+-------------------+
1 row in set (0.00 sec)

I have a complete list of the packages installed along the way and the few config steps required to get to this stage if anyone is interested in reviewing the setup. I am really struggling to progress and since updating to UDFs 1.1 and libmemcached 0.38 i am now unable to use the functions at all. Please let me know if there is anything i can try to resolve these issues or provide further debug at this stage. Many thanks

[Callum Guy (callum-guy)]

sorry i meant to say that the upgrade to 1.1 and 0.38 is now meaning that i get the 'hosts' error, sorry for any confusion

[Ashish Disawal (ashish-disawal)]

MySQl 5.1.40 + libmemcached-0.34 + memcached_functions_mysql-0.9 worked for us, on Debian Lenny.
Thanks Sachin for trying it out.

[Stelios (ridd1ck-ste)]

Hello,
I Havwe the same problem,
When i try to use make i get this output:

Making all in src
make[1]: Entering directory `/home/steliosamd/memcached_functions_mysql-1.0/src'
make all-am
make[2]: Entering directory `/home/steliosamd/memcached_functions_mysql-1.0/src'
/bin/sh ../libtool --preserve-dup-deps --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I../include -I/usr/local/mysql/include -g -DUNIV_LINUX -DUNIV_LINUX -g -O2 -MT servers.lo -MD -MP -MF .deps/servers.Tpo -c -o servers.lo servers.c
 gcc -DHAVE_CONFIG_H -I. -I../include -I/usr/local/mysql/include -g -DUNIV_LINUX -DUNIV_LINUX -g -O2 -MT servers.lo -MD -MP -MF .deps/servers.Tpo -c servers.c -fPIC -DPIC -o .libs/servers.o
servers.c: In function βmemc_servers_setβ:
servers.c:121:18: error: βmemcached_stβ has no member named βhostsβ
servers.c:122:18: error: βmemcached_stβ has no member named βhostsβ
servers.c:123:18: error: βmemcached_stβ has no member named βhostsβ
make[2]: *** [servers.lo] Error 1
make[2]: Leaving directory `/home/steliosamd/memcached_functions_mysql-1.0/src'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/steliosamd/memcached_functions_mysql-1.0/src'
make: *** [all-recursive] Error 1

Can you help me?

Thanks.

[Callum Guy (callum-guy)]

Take a look at the new MySQL - it has (will have) Memcache integrated from
source :)

http://www.mysql.com/news-and-events/on-demand-webinars/display-od-665.html

______________________________

Callum Guy
Developer

X-on
Framlingham Technology Centre
Station Road, Framlingham,
Suffolk, IP13 9EZ

T 0333 332 0116
E <email address hidden>

X-on is a trading name of Storacall Technology Ltd a limited company
registered in England and Wales
Registered Office : Avaland House, 110 London Road, Apsley, Hemel
Hempstead, Herts, HP3 9SD
Company Registration No. 2578478

This email has been sent from X-on.The contents and attachments are
confidential to the sender and the intended addressees.If the message
is received by anyone other than the addressee please return the
message to the sender by replying to it and then delete the message
from
your computer without copying or disclosing the contents to
anyone.Opinions, conclusions and statements of intent in this email
are those of
the sender and do not bind X-on unless confirmed by authorised
representatives independently of this message.While best endeavours
have
been taken to avoid transmission of viruses, it is the responsibility
of the recipient to scan for these.Please note emails sent to and from
X-on
are routinely monitored for record keeping and quality control, to
ensure regulatory compliance and prevent unauthorised use of our
systems.

       Please consider the environment before printing this email.

On 22 December 2011 14:53, Stelios <email address hidden> wrote:

> Hello,
> I Havwe the same problem,
> When i try to use make i get this output:
>
> Making all in src
> make[1]: Entering directory
> `/home/steliosamd/memcached_functions_mysql-1.0/src'
> make all-am
> make[2]: Entering directory
> `/home/steliosamd/memcached_functions_mysql-1.0/src'
> /bin/sh ../libtool --preserve-dup-deps --tag=CC --mode=compile gcc
> -DHAVE_CONFIG_H -I. -I../include -I/usr/local/mysql/include -g
> -DUNIV_LINUX -DUNIV_LINUX -g -O2 -MT servers.lo -MD -MP -MF
> .deps/servers.Tpo -c -o servers.lo servers.c
> gcc -DHAVE_CONFIG_H -I. -I../include -I/usr/local/mysql/include -g
> -DUNIV_LINUX -DUNIV_LINUX -g -O2 -MT servers.lo -MD -MP -MF
> .deps/servers.Tpo -c servers.c -fPIC -DPIC -o .libs/servers.o
> servers.c: In function βmemc_servers_setβ:
> servers.c:121:18: error: βmemcached_stβ has no member named βhostsβ
> servers.c:122:18: error: βmemcached_stβ has no member named βhostsβ
> servers.c:123:18: error: βmemcached_stβ has no member named βhostsβ
> make[2]: *** [servers.lo] Error 1
> make[2]: Leaving directory
> `/home/steliosamd/memcached_functions_mysql-1.0/src'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory
> `/home/steliosamd/memcached_functions_mysql-1.0/src'
> make: *** [all-recursive] Error 1
>
>
> Can you help me?
>
> Thanks.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/522242
>
> Title:
> error: 'memcached_st' has no member named 'hosts'
>
> Status in Memcached Functions for MySQL:
> New
>
> Bug description:
> I am trying to install version 1.1 on centos 5.4 32bit and get this
> e...