d1rtym0nk3y / mysql-udf-http Goto Github PK

The general description doesn't work on debian  /ubuntu system. here is some 
adjustment:

1, depandencies:
mysql-server
libmysqlclient-dev (mysql_config is in this package)

make sure you are root and run 
apt-get install mysql-server
apt-get install libmysqlclient-dev


then go with following step author specified

echo "/var/lib/mysql" > /etc/ld.so.conf.d/mysql.conf
/sbin/ldconfig
wget http://mysql-udf-http.googlecode.com/files/mysql-udf-http-1.0.tar.gz
tar zxvf mysql-udf-http-1.0.tar.gz
cd mysql-udf-http-1.0/
./configure --prefix=/var/lib/mysql --with-mysql=/usr/bin/mysql_config
make && make install

Have tested this on Debian and Redhat and it compiles and installs with no 
problems. However on Suse Linux Enterprise Server 10 or 11 (running SP1), it 
does not compile.

Configure runs fine but Make fails with the following output:

cd . && /bin/sh /root/Downloads/mysql-udf-http-1.0/config/missing --run 
aclocal-1.10
 cd . && /bin/sh /root/Downloads/mysql-udf-http-1.0/config/missing --run automake-1.10 --gnu
src/Makefile.am:5: bad characters in variable name `mysql-udf-http_la_SOURCES'
src/Makefile.am:6: bad characters in variable name `mysql-udf-http_la_LDFLAGS'
src/Makefile.am:7: bad characters in variable name `mysql-udf-http_la_LIBADD'
src/Makefile.am:4: `mysql-udf-http.la' is not a standard libtool library name
src/Makefile.am:4: did you mean `libmysql-udf-http.la'?
src/Makefile.am:5: variable `mysql-udf-http_la_SOURCES' is defined but no 
program or
src/Makefile.am:5: library has `mysql-udf-http_la' as canonic name (possible 
typo)
src/Makefile.am:7: variable `mysql-udf-http_la_LIBADD' is defined but no 
program or
src/Makefile.am:7: library has `mysql-udf-http_la' as canonic name (possible 
typo)
src/Makefile.am:6: variable `mysql-udf-http_la_LDFLAGS' is defined but no 
program or
src/Makefile.am:6: library has `mysql-udf-http_la' as canonic name (possible 
typo)
Makefile.am: required file `./INSTALL' not found
Makefile.am:   `automake --add-missing' can install `INSTALL'
Makefile.am: required file `./NEWS' not found
Makefile.am: required file `./AUTHORS' not found
Makefile.am: required file `./ChangeLog' not found
Makefile.am: required file `./COPYING' not found
Makefile.am:   `automake --add-missing' can install `COPYING'
make: *** [Makefile.in] Error 1

I have not tested OpenSUSE or SLES 12

What steps will reproduce the problem?
1. i use http_put to send a json_object in after insert trigger
2. if it cannot reach ip mysql crash with signal 11
3.

What is the expected output? What do you see instead?
Mysql crash so i cannot see anything

What version of the product are you using? On what operating system?
Last version 1.0 http and json

Please provide any additional information below.

I am trying to compile this for windows as i have mysql installed on windows.
I have added the .c and .h files from the download to my project , i am using 
dev c++ for this.

I have also included mysql and curl include files but the project doesnt 
compile properly.

Can you guys compile a windows based dll version for the same ? It will be of 
great help.

Thanks !!

Hi

I would like to get the http_get work in the mysql installed in windows pc. May 
you please help me 

When specifying an unknown host, a segmentation fault occurs:
mysql> select http_get('http://example.invalid/');
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> 

The mysql error log says "mysqld got signal 11 ;"


After some debugging I found that in that case result->res ist still NULL after 
curl_easy_perform. The error is caused by 
strcopy(res->result, "")


The attached mysql-udf-http.c resolves the issue.

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?


Please provide any additional information below.

What steps will reproduce the problem?
1. Calling any of the http_* functions on a closed server port


What is the expected output? What do you see instead?

  Something that a continue handler could be set for. 
  The mysql connection gets aborted.

What version of the product are you using? On what operating system?
  mysql-udf-http-1.0
  Ubuntu 12.04
  mysql  Ver 14.14 Distrib 5.5.34, for debian-linux-gnu (x86_64) 
    using readline 6.2

Please provide any additional information below.

  mysql  Ver 14.14 Distrib 5.5.34, for debian-linux-gnu (x86_64) 
    using readline 6.2

  Maybe there is a continue handler line that could fix this, but if 
  there is its not documented nor aparent from the code.