Hi,
I am trying to use the normal mysql integration, and I'm running into a few issues along the way. Note that I am using Solaris.
1) mysql.so is not available with default installation mysql.so>: ld.so.1: ser: fatal: /usr/local/lib/ser/modules/mysql.so: open failed: No such file or directory
2) modules/mysql is not built with default Makefile sip_router/Makefile: exclude_modules contains mysql
3) when I add mysql to the Makefile and do a "make modules" there is a compilation error within mysql and the .so is not produced (see "Compile errors" below).
Do I need to somehow specify where the mysql header-files and libraries can be found? How do I go about doing this?
Any help is appreciated... Thanks Alex Rootham Blueslice Networks
Compile errors ----
make[1]: Entering directory `/home/alex/foreignCvs/ser/sip_router/modules/mysql' cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory In file included from dbase.c:39: con_mysql.h:33:25: warning: mysql/mysql.h: No such file or directory In file included from dbase.c:40: db_val.h:31:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory db_val.c:31:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory db_row.c:30:25: warning: mysql/mysql.h: No such file or directory In file included from db_row.c:35: db_val.h:31:25: warning: mysql/mysql.h: No such file or directory In file included from db_row.c:36: con_mysql.h:33:25: warning: mysql/mysql.h: No such file or directory make[1]: Entering directory `/home/alex/foreignCvs/ser/sip_router/modules/mysql' cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory In file included from dbase.c:39: con_mysql.h:33:25: warning: mysql/mysql.h: No such file or directory In file included from dbase.c:40: db_val.h:31:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory db_val.c:31:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory db_row.c:30:25: warning: mysql/mysql.h: No such file or directory In file included from db_row.c:35: db_val.h:31:25: warning: mysql/mysql.h: No such file or directory In file included from db_row.c:36: con_mysql.h:33:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory db_res.c:31:25: warning: mysql/mysql.h: No such file or directory In file included from db_res.c:36: con_mysql.h:33:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory make[1]: Leaving directory `/home/alex/foreignCvs/ser/sip_router/modules/mysql' make[1]: Entering directory `/home/alex/foreignCvs/ser/sip_router/modules/mysql' gcc -fPIC -DPIC -g -O9 -funroll-loops -Wall -mcpu=ultrasparc -mtune=ultrasparc -DNAME='"ser"' -DVERSION='"0.8.14-2"' -DARCH='"sparc64"' -DOS='"solaris"' -DCOMPILER='"gcc 3.1"' -D__CPU_sparc64 -D__OS_solaris -DCFG_DIR='"/usr/local/etc/ser/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_TCP -DDISABLE_NAGLE -DF_MALLOC -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DHAVE_GETIPNODEBYNAME -DHAVE_SYS_SOCKIO_H -DHAVE_SCHED_YIELD -I/usr/local/include -I/usr/local/include/mysql -I/usr/local/mysql/include -I/usr/pkg/include -c db_con.c -o db_con.o cc1: warning: changing search order for system directory "/usr/local/include" cc1: warning: as it has already been specified as a non-system directory gcc -fPIC -DPIC -g -O9 -funroll-loops -Wall -mcpu=ultrasparc -mtune=ultrasparc -DNAME='"ser"' -DVERSION='"0.8.14-2"' -DARCH='"sparc64"' -DOS='"solaris"' -DCOMPILER='"gcc 3.1"' -D__CPU_sparc64 -D__OS_solaris -DCFG_DIR='"/usr/local/etc/ser/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_TCP -DDISABLE_NAGLE -DF_MALLOC -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DHAVE_GETIPNODEBYNAME -DHAVE_SYS_SOCKIO_H -DHAVE_SCHED_YIELD -I/usr/local/include -I/usr/local/include/mysql -I/usr/local/mysql/include -I/usr/pkg/include -c db_mod.c -o db_mod.o cc1: warning: changing search order for system directory "/usr/local/include" cc1: warning: as it has already been specified as a non-system directory gcc -fPIC -DPIC -g -O9 -funroll-loops -Wall -mcpu=ultrasparc -mtune=ultrasparc -DNAME='"ser"' -DVERSION='"0.8.14-2"' -DARCH='"sparc64"' -DOS='"solaris"' -DCOMPILER='"gcc 3.1"' -D__CPU_sparc64 -D__OS_solaris -DCFG_DIR='"/usr/local/etc/ser/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_TCP -DDISABLE_NAGLE -DF_MALLOC -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DHAVE_GETIPNODEBYNAME -DHAVE_SYS_SOCKIO_H -DHAVE_SCHED_YIELD -I/usr/local/include -I/usr/local/include/mysql -I/usr/local/mysql/include -I/usr/pkg/include -c db_res.c -o db_res.o cc1: warning: changing search order for system directory "/usr/local/include" cc1: warning: as it has already been specified as a non-system directory db_res.c:31:25: mysql/mysql.h: No such file or directory In file included from db_res.c:36: con_mysql.h:33:25: mysql/mysql.h: No such file or directory In file included from db_res.c:36: con_mysql.h:39: parse error before "MYSQL_RES" con_mysql.h:39: warning: no semicolon at end of struct or union con_mysql.h:40: warning: type defaults to `int' in declaration of `con' con_mysql.h:40: warning: data definition has no type or storage class con_mysql.h:41: parse error before "row" con_mysql.h:41: warning: type defaults to `int' in declaration of `row' con_mysql.h:41: warning: data definition has no type or storage class db_res.c: In function `get_columns': db_res.c:45: `MYSQL_FIELD' undeclared (first use in this function) db_res.c:45: (Each undeclared identifier is reported only once db_res.c:45: for each function it appears in.) db_res.c:45: `fields' undeclared (first use in this function) db_res.c:52: warning: implicit declaration of function `mysql_field_count' db_res.c:52: dereferencing pointer to incomplete type db_res.c:73: warning: implicit declaration of function `mysql_fetch_fields' db_res.c:73: dereferencing pointer to incomplete type db_res.c:77: `FIELD_TYPE_TINY' undeclared (first use in this function) db_res.c:78: `FIELD_TYPE_SHORT' undeclared (first use in this function) db_res.c:79: `FIELD_TYPE_LONG' undeclared (first use in this function) db_res.c:80: `FIELD_TYPE_INT24' undeclared (first use in this function) db_res.c:81: `FIELD_TYPE_TIMESTAMP' undeclared (first use in this function) db_res.c:85: `FIELD_TYPE_FLOAT' undeclared (first use in this function) db_res.c:86: `FIELD_TYPE_DOUBLE' undeclared (first use in this function) db_res.c:90: `FIELD_TYPE_DATETIME' undeclared (first use in this function) db_res.c:94: `FIELD_TYPE_BLOB' undeclared (first use in this function) db_res.c:95: `FIELD_TYPE_TINY_BLOB' undeclared (first use in this function) db_res.c:96: `FIELD_TYPE_MEDIUM_BLOB' undeclared (first use in this function) db_res.c:97: `FIELD_TYPE_LONG_BLOB' undeclared (first use in this function) db_res.c:101: `FIELD_TYPE_SET' undeclared (first use in this function) db_res.c: In function `convert_rows': db_res.c:146: warning: implicit declaration of function `mysql_num_rows' db_res.c:146: dereferencing pointer to incomplete type db_res.c:159: dereferencing pointer to incomplete type db_res.c:159: warning: implicit declaration of function `mysql_fetch_row' db_res.c:159: dereferencing pointer to incomplete type db_res.c:160: dereferencing pointer to incomplete type db_res.c:161: warning: implicit declaration of function `mysql_error' db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type make[1]: *** [db_res.o] Error 1 make[1]: Leaving directory `/home/alex/foreignCvs/ser/sip_router/modules/mysql'
Hi Alex,
yes, you have to remove mysql module from exclude_modules list. You get these compilation errors because you don't have installed the development files for mysql client. On linux, the package name is "libmysqlclient-dev"; i'm not sure on Solaris.
Best regards, Marian Dumitru
Alex Rootham wrote:
Hi,
I am trying to use the normal mysql integration, and I'm running into a few issues along the way. Note that I am using Solaris.
- mysql.so is not available with default installation
mysql.so>: ld.so.1: ser: fatal: /usr/local/lib/ser/modules/mysql.so: open failed: No such file or directory
- modules/mysql is not built with default Makefile
sip_router/Makefile: exclude_modules contains mysql
- when I add mysql to the Makefile and do a "make modules" there is a
compilation error within mysql and the .so is not produced (see "Compile errors" below).
Do I need to somehow specify where the mysql header-files and libraries can be found? How do I go about doing this?
Any help is appreciated... Thanks Alex Rootham Blueslice Networks
Compile errors ----
make[1]: Entering directory `/home/alex/foreignCvs/ser/sip_router/modules/mysql' cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory In file included from dbase.c:39: con_mysql.h:33:25: warning: mysql/mysql.h: No such file or directory In file included from dbase.c:40: db_val.h:31:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory db_val.c:31:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory db_row.c:30:25: warning: mysql/mysql.h: No such file or directory In file included from db_row.c:35: db_val.h:31:25: warning: mysql/mysql.h: No such file or directory In file included from db_row.c:36: con_mysql.h:33:25: warning: mysql/mysql.h: No such file or directory make[1]: Entering directory `/home/alex/foreignCvs/ser/sip_router/modules/mysql' cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory In file included from dbase.c:39: con_mysql.h:33:25: warning: mysql/mysql.h: No such file or directory In file included from dbase.c:40: db_val.h:31:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory db_val.c:31:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory db_row.c:30:25: warning: mysql/mysql.h: No such file or directory In file included from db_row.c:35: db_val.h:31:25: warning: mysql/mysql.h: No such file or directory In file included from db_row.c:36: con_mysql.h:33:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory db_res.c:31:25: warning: mysql/mysql.h: No such file or directory In file included from db_res.c:36: con_mysql.h:33:25: warning: mysql/mysql.h: No such file or directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory cpp0: warning: changing search order for system directory "/usr/local/include" cpp0: warning: as it has already been specified as a non-system directory make[1]: Leaving directory `/home/alex/foreignCvs/ser/sip_router/modules/mysql' make[1]: Entering directory `/home/alex/foreignCvs/ser/sip_router/modules/mysql' gcc -fPIC -DPIC -g -O9 -funroll-loops -Wall -mcpu=ultrasparc -mtune=ultrasparc -DNAME='"ser"' -DVERSION='"0.8.14-2"' -DARCH='"sparc64"' -DOS='"solaris"' -DCOMPILER='"gcc 3.1"' -D__CPU_sparc64 -D__OS_solaris -DCFG_DIR='"/usr/local/etc/ser/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_TCP -DDISABLE_NAGLE -DF_MALLOC -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DHAVE_GETIPNODEBYNAME -DHAVE_SYS_SOCKIO_H -DHAVE_SCHED_YIELD -I/usr/local/include -I/usr/local/include/mysql -I/usr/local/mysql/include -I/usr/pkg/include -c db_con.c -o db_con.o cc1: warning: changing search order for system directory "/usr/local/include" cc1: warning: as it has already been specified as a non-system directory gcc -fPIC -DPIC -g -O9 -funroll-loops -Wall -mcpu=ultrasparc -mtune=ultrasparc -DNAME='"ser"' -DVERSION='"0.8.14-2"' -DARCH='"sparc64"' -DOS='"solaris"' -DCOMPILER='"gcc 3.1"' -D__CPU_sparc64 -D__OS_solaris -DCFG_DIR='"/usr/local/etc/ser/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_TCP -DDISABLE_NAGLE -DF_MALLOC -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DHAVE_GETIPNODEBYNAME -DHAVE_SYS_SOCKIO_H -DHAVE_SCHED_YIELD -I/usr/local/include -I/usr/local/include/mysql -I/usr/local/mysql/include -I/usr/pkg/include -c db_mod.c -o db_mod.o cc1: warning: changing search order for system directory "/usr/local/include" cc1: warning: as it has already been specified as a non-system directory gcc -fPIC -DPIC -g -O9 -funroll-loops -Wall -mcpu=ultrasparc -mtune=ultrasparc -DNAME='"ser"' -DVERSION='"0.8.14-2"' -DARCH='"sparc64"' -DOS='"solaris"' -DCOMPILER='"gcc 3.1"' -D__CPU_sparc64 -D__OS_solaris -DCFG_DIR='"/usr/local/etc/ser/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_TCP -DDISABLE_NAGLE -DF_MALLOC -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DHAVE_GETIPNODEBYNAME -DHAVE_SYS_SOCKIO_H -DHAVE_SCHED_YIELD -I/usr/local/include -I/usr/local/include/mysql -I/usr/local/mysql/include -I/usr/pkg/include -c db_res.c -o db_res.o cc1: warning: changing search order for system directory "/usr/local/include" cc1: warning: as it has already been specified as a non-system directory db_res.c:31:25: mysql/mysql.h: No such file or directory In file included from db_res.c:36: con_mysql.h:33:25: mysql/mysql.h: No such file or directory In file included from db_res.c:36: con_mysql.h:39: parse error before "MYSQL_RES" con_mysql.h:39: warning: no semicolon at end of struct or union con_mysql.h:40: warning: type defaults to `int' in declaration of `con' con_mysql.h:40: warning: data definition has no type or storage class con_mysql.h:41: parse error before "row" con_mysql.h:41: warning: type defaults to `int' in declaration of `row' con_mysql.h:41: warning: data definition has no type or storage class db_res.c: In function `get_columns': db_res.c:45: `MYSQL_FIELD' undeclared (first use in this function) db_res.c:45: (Each undeclared identifier is reported only once db_res.c:45: for each function it appears in.) db_res.c:45: `fields' undeclared (first use in this function) db_res.c:52: warning: implicit declaration of function `mysql_field_count' db_res.c:52: dereferencing pointer to incomplete type db_res.c:73: warning: implicit declaration of function `mysql_fetch_fields' db_res.c:73: dereferencing pointer to incomplete type db_res.c:77: `FIELD_TYPE_TINY' undeclared (first use in this function) db_res.c:78: `FIELD_TYPE_SHORT' undeclared (first use in this function) db_res.c:79: `FIELD_TYPE_LONG' undeclared (first use in this function) db_res.c:80: `FIELD_TYPE_INT24' undeclared (first use in this function) db_res.c:81: `FIELD_TYPE_TIMESTAMP' undeclared (first use in this function) db_res.c:85: `FIELD_TYPE_FLOAT' undeclared (first use in this function) db_res.c:86: `FIELD_TYPE_DOUBLE' undeclared (first use in this function) db_res.c:90: `FIELD_TYPE_DATETIME' undeclared (first use in this function) db_res.c:94: `FIELD_TYPE_BLOB' undeclared (first use in this function) db_res.c:95: `FIELD_TYPE_TINY_BLOB' undeclared (first use in this function) db_res.c:96: `FIELD_TYPE_MEDIUM_BLOB' undeclared (first use in this function) db_res.c:97: `FIELD_TYPE_LONG_BLOB' undeclared (first use in this function) db_res.c:101: `FIELD_TYPE_SET' undeclared (first use in this function) db_res.c: In function `convert_rows': db_res.c:146: warning: implicit declaration of function `mysql_num_rows' db_res.c:146: dereferencing pointer to incomplete type db_res.c:159: dereferencing pointer to incomplete type db_res.c:159: warning: implicit declaration of function `mysql_fetch_row' db_res.c:159: dereferencing pointer to incomplete type db_res.c:160: dereferencing pointer to incomplete type db_res.c:161: warning: implicit declaration of function `mysql_error' db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type db_res.c:161: dereferencing pointer to incomplete type make[1]: *** [db_res.o] Error 1 make[1]: Leaving directory `/home/alex/foreignCvs/ser/sip_router/modules/mysql'
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Alex Rootham -
Marian Dumitru