I'm trying to run SqueezeBox Server 7.4 on a QNAP TS-509 (x86) using the CPAN tarball.
Normally it would mean using the QNAP SSOTS package to provide a suitable environment but the current package doesn't support SBS 7.4. I am leaving SC 7.3 as a functioning package so I've set up 7.4 to run as a seperate instance which I invoke with the slimserver daemon. The 7.4 tarball source code contains some useful scripts which give suggestions for solving problems if the daemon fails to start SBS. In my case the scripts tell me that some modules require compiling - DBD::mysql EV XML::Parser::Expat HTML::Parser JSON::XS Digest::SHA1 YAML::Syck GD Sub::Name. One of the scripts, build-perl-modules.pl, also suggests additional libraries that may be required to build missing modules. The QNAP 'ipkg' package has allowed me to download and install most of the missing libraries and so far I've been able to build all of the modules - except for DBD::mysql. DBD::mysql requires MySQL development libraries (e.g. libmysqlclient) and as far as I can tell, there are none available through 'ipkg'. The TS-509 has a module libmysqlclient.so.15.0.0 but the build script either won't/can't use it or something else is needed. 'perl Makefile' builds without a problem but 'make' produces a whole bucket load of errors and just bomb's out. i686-unknown-linux-gnu-gcc -c -I/opt/lib/perl5/site_perl/5.10.0/i686-linux/auto/DBI -I/opt/include -I/opt/cross-project/x86/sys-root/usr/include -I/opt/cross-project/x86/sys-root/include -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fexpensive-optimizations -fomit-frame-pointer -O2 -DVERSION=\"4.012\" -DXS_VERSION=\"4.012\" -fexpensive-optimizations -fomit-frame-pointer "-I/opt/lib/perl5/5.10.0/i686-linux/CORE" dbdimp.c In file included from dbdimp.c:20: dbdimp.h:22:49: error: mysql.h: No such file or directory dbdimp.h:23:45: error: mysqld_error.h: No such file or directory dbdimp.h:25:49: error: errmsg.h: No such file or directory In file included from dbdimp.c:20: dbdimp.h:144: error: expected specifier-qualifier-list before 'MYSQL' dbdimp.h:236: error: expected specifier-qualifier-list before 'MYSQL_RES' In file included from dbdimp.c:20: dbdimp.h:293: error: expected ')' before '*' token dbdimp.h:296: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'mysql_st_internal_execute' dbdimp.h:328: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token dbdimp.c:408: error: expected ')' before '*' token dbdimp.c:635: error: 'FIELD_TYPE_VAR_STRING' undeclared here (not in a function) dbdimp.c:645: error: 'FIELD_TYPE_DECIMAL' undeclared here (not in a function) dbdimp.c:655: error: 'FIELD_TYPE_TINY' undeclared here (not in a function) dbdimp.c:665: error: 'FIELD_TYPE_SHORT' undeclared here (not in a function) dbdimp.c:675: error: 'FIELD_TYPE_LONG' undeclared here (not in a function) dbdimp.c:685: error: 'FIELD_TYPE_FLOAT' undeclared here (not in a function) dbdimp.c:695: error: 'FIELD_TYPE_DOUBLE' undeclared here (not in a function) dbdimp.c:718: error: 'FIELD_TYPE_TIMESTAMP' undeclared here (not in a function) dbdimp.c:728: error: 'FIELD_TYPE_LONGLONG' undeclared here (not in a function) dbdimp.c:738: error: 'FIELD_TYPE_INT24' undeclared here (not in a function) dbdimp.c:748: error: 'FIELD_TYPE_DATE' undeclared here (not in a function) dbdimp.c:758: error: 'FIELD_TYPE_TIME' undeclared here (not in a function) dbdimp.c:768: error: 'FIELD_TYPE_DATETIME' undeclared here (not in a function) dbdimp.c:778: error: 'FIELD_TYPE_YEAR' undeclared here (not in a function) dbdimp.c:788: error: 'FIELD_TYPE_NEWDATE' undeclared here (not in a function) dbdimp.c:798: error: 'FIELD_TYPE_ENUM' undeclared here (not in a function) dbdimp.c:808: error: 'FIELD_TYPE_SET' undeclared here (not in a function) dbdimp.c:818: error: 'FIELD_TYPE_BLOB' undeclared here (not in a function) dbdimp.c:828: error: 'FIELD_TYPE_TINY_BLOB' undeclared here (not in a function) dbdimp.c:838: error: 'FIELD_TYPE_MEDIUM_BLOB' undeclared here (not in a function) dbdimp.c:848: error: 'FIELD_TYPE_LONG_BLOB' undeclared here (not in a function) dbdimp.c:858: error: 'FIELD_TYPE_STRING' undeclared here (not in a function) dbdimp.c:1325: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token dbdimp.c: In function 'my_login': dbdimp.c:1785: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:1786: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:1786: error: 'MYSQL' undeclared (first use in this function) dbdimp.c:1786: error: (Each undeclared identifier is reported only once dbdimp.c:1786: error: for each function it appears in.) dbdimp.c:1786: warning: comparison between pointer and integer dbdimp.c:1786: error: invalid operands to binary / dbdimp.c:1786: error: invalid operands to binary > dbdimp.c:1786: error: expected expression before ')' token dbdimp.c:1786: error: invalid operands to binary * dbdimp.c:1788: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c: In function 'mysql_db_login': dbdimp.c:1825: error: 'imp_dbh_t' has no member named 'stats' dbdimp.c:1825: error: request for member 'auto_reconnects_ok' in something not a structure or union dbdimp.c:1826: error: 'imp_dbh_t' has no member named 'stats' dbdimp.c:1826: error: request for member 'auto_reconnects_failed' in something not a structure or union dbdimp.c:1827: error: 'imp_dbh_t' has no member named 'bind_type_guessing' dbdimp.c:1828: error: 'imp_dbh_t' has no member named 'has_transactions' dbdimp.c:1830: error: 'imp_dbh_t' has no member named 'auto_reconnect' dbdimp.c:1839: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:1840: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:1840: warning: passing argument 3 of 'mysql_dr_error' makes pointer from integer without a cast dbdimp.c: In function 'mysql_db_commit': dbdimp.c:1877: error: 'imp_dbh_t' has no member named 'has_transactions' dbdimp.c:1880: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:1885: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:1885: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:1886: warning: passing argument 3 of 'mysql_dr_error' makes pointer from integer without a cast dbdimp.c: In function 'mysql_db_rollback': dbdimp.c:1905: error: 'imp_dbh_t' has no member named 'has_transactions' dbdimp.c:1908: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:1913: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:1914: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:1914: warning: passing argument 3 of 'mysql_dr_error' makes pointer from integer without a cast dbdimp.c: In function 'mysql_db_disconnect': dbdimp.c:1951: error: 'imp_dbh_t' has no member named 'pmysql' SNIP....... lots of other errors like this. dbdimp.c:4158: error: 'imp_sth_t' has no member named 'use_mysql_use_result' dbdimp.c:4162: error: 'imp_sth_t' has no member named 'warning_count' dbdimp.c:4174: error: 'imp_sth_t' has no member named 'result' dbdimp.c:4174: warning: passing argument 3 of 'mysql_st_FETCH_internal' makes integer from pointer without a cast dbdimp.c:4174: error: too many arguments to function 'mysql_st_FETCH_internal' dbdimp.c: In function 'mysql_bind_ph': dbdimp.c:4298: error: 'imp_sth_t' has no member named 'params' dbdimp.c:4298: warning: passing argument 1 of 'bind_param' from incompatible pointer type dbdimp.c: In function 'mysql_db_reconnect': dbdimp.c:4420: error: 'MYSQL' undeclared (first use in this function) dbdimp.c:4420: error: expected ';' before 'save_socket' dbdimp.c:4430: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:4430: error: 'CR_SERVER_GONE_ERROR' undeclared (first use in this function) dbdimp.c:4430: warning: comparison between pointer and integer dbdimp.c:4434: error: 'imp_dbh_t' has no member named 'auto_reconnect' dbdimp.c:4448: error: 'save_socket' undeclared (first use in this function) dbdimp.c:4448: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:4449: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:4449: warning: passing argument 3 of 'memcpy' makes integer from pointer without a cast dbdimp.c:4450: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:4450: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:4450: warning: passing argument 1 of 'memset' discards qualifiers from pointer target type dbdimp.c:4458: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:4458: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:4459: warning: passing argument 3 of 'mysql_dr_error' makes pointer from integer without a cast dbdimp.c:4460: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:4460: warning: passing argument 1 of 'memcpy' discards qualifiers from pointer target type dbdimp.c:4460: warning: passing argument 3 of 'memcpy' makes integer from pointer without a cast dbdimp.c:4461: error: 'imp_dbh_t' has no member named 'stats' dbdimp.c:4461: error: request for member 'auto_reconnects_failed' in something not a structure or union dbdimp.c:4461: error: lvalue required as increment operand dbdimp.c:4470: error: 'imp_dbh_t' has no member named 'stats' dbdimp.c:4470: error: request for member 'auto_reconnects_ok' in something not a structure or union dbdimp.c:4470: error: lvalue required as increment operand dbdimp.c: In function 'mysql_db_quote': dbdimp.c:4630: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c: In function 'mysql_db_last_insert_id': dbdimp.c:4653: error: 'imp_dbh_t' has no member named 'pmysql' dbdimp.c:4653: warning: passing argument 1 of 'Perl_sv_2mortal' makes pointer from integer without a cast make: *** [dbdimp.o] Error 1 Anyone have any idea's on this other than 'just give up'? Thanks Bob -- bobertuk 1 x Duet - SC 7.3.4 - SSOTS v3.18 1 x Boom Lavry DA-10 DAC QNAP TS-509 3.1.1 build 0812T Starfish Pre-amp : Based on NAIM Heavily modified NAIM NAP 250 Power-amp Behringer DEQ2496 Linn Isobarik DMS ------------------------------------------------------------------------ bobertuk's Profile: http://forums.slimdevices.com/member.php?userid=30376 View this thread: http://forums.slimdevices.com/showthread.php?t=66970 _______________________________________________ unix mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/unix
