[CentOS 6.6 64bit] sys_eval and sys_exec return strange values

[mysqludf]

[CentOS 6.6 64bit] sys_eval and sys_exec return strange values

[ShakyShip]

You can try open /var/log/mysqld.log
This is my output when execute 'pwd'

mysql> select sys_exec('pwd');
+-----------------+
| sys_exec('pwd') |
+-----------------+
|               0 |
+-----------------+
1 row in set (0.01 sec)

and this from /var/log/mysqld.log

[root@db ~]# tail /var/log/mysqld.log
            s.parentNode.insertBefore(sc, s);
        })();
        _comscore.push({ c1: "2", c2: "17440561" });
        _qevents.push({ qacct: "p-c1rF4kxgLUzNc" });
    </script>
    </body>
</html>Tue Aug  4 12:24:02 WIB 2015
Tue Aug  4 12:24:04 WIB 2015
/var/lib/mysql
/var/lib/mysql

and you can try my Makefile setting if you install it from install.sh

gcc -m64 -fPIC -Wall -I/usr/include/mysql -I. -shared lib_mysqludf_sys.c -o /usr/lib64/mysql/plugin/lib_mysqludf_sys.so

[vanhiepdam]

Can you give me the way to install mysqludf
I'm using CentOS 7

[elegos]

Hello vanhiepdam,

Just compile with the provided command (gcc) and symlink the .so file in the MySQL's plugins folder. Then install it via the SQL commands

[gmarsico]

http://www.tldp.org/LDP/abs/html/exitcodes.html

[yamelyamel16]

sys_eval is returning NULL because the function is only returning int, so drop it and the create it again with the following syntax:
CREATE FUNCTION sys_eval RETURNS string SONAME 'lib_mysqludf_sys.so';

[SimoneCammarano]

sys_eval is returning NULL because the function is only returning int, so drop it and the create it again with the following syntax:
CREATE FUNCTION sys_eval RETURNS string SONAME 'lib_mysqludf_sys.so';
@yamelyamel16 you save me! Thanks a lot!