On May 4, 2012, at 5:33 PM, Chad Leigh Shire.Net LLC wrote: > Hi > > OK. I compiled roxen webserver 5.2.191 from source. This is on FreeBSD 9 > > This is the config line I used: > > ./configure --prefix=/usr/public/roxen/roxen5 > --with-mysql=/usr/public/mysql/mysql5.5 --with-pcre --without-gssapi > > However, when I try and start up Roxen, this shows up in the debug log > > : ****************************************************** > 23:25:17 : Roxen requires MySQL support in Pike since version 2.4. > 0m 0.0s : Your Pike has been compiled without support for MySQL. > : Please install MySQL client libraries and reconfigure > : and rebuild Pike from source. > : ****************************************************** > > > I would assume that if I tell Roxen to include mysql support, and it is > building pike, that it would include the mysql support in pike? > > What can I do to see how pike was really built? This is in the config.log in > the pike/src directory > > $ /space/kits/roxen-5.2.191-src/pike/src/configure > --prefix=/usr/public/roxen/roxen5 --with-mysql=/usr/public/mysql/mysql5.5 > --with-pcre --without-gssapi --cache-file=../.././config.cache > --srcdir=/space/kits/roxen-5.2.191-src/pike/src > > > so it appears it was built that way... > > Thanks for any insight > > Chad >
Ok, so I went and rebuilt roxen. This time I paid more attention. First, I did $ setenv ALLOW_UNSUPPORTED_MYSQL after searching on "mysql-location.txt" since I saw that the startup log said that could not be found. I found a release note for a 5.0 version of Roxen that said to define that if the mysql version was different that what it was expecting. I did "./configure --prefix=/usr/public/roxen/roxen5 --with-mysql=/usr/public/mysql/mysql5.5 --with-pcre --without-gssapi" again and found the section where it talks about the Mysql module I don't see any warnings or errors: ################################################### ## Configuring module: Mysql ## Installation dir: checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... (cached) o checking whether we are using the GNU C compiler... (cached) yes checking whether /space/kits/roxen-5.2.191-src/pike/src/smartlink gcc accepts -g... (cached) yes checking for /space/kits/roxen-5.2.191-src/pike/src/smartlink gcc option to accept ANSI C... (cached) none needed checking if we are using TCC (TenDRA C Compiler)... (cached) no checking if we are using ICC (Intel C Compiler)... (cached) no checking how to run the C preprocessor... gcc -E checking for libgcc file name... (cached) /usr/lib/libgcc.a checking for Mysql directory prefix... (cached) no checking for winsock2.h... (cached) no checking for winsock.h... (cached) no checking for mysql.h... (cached) no checking for mysql/mysql.h... (cached) no checking for errmsg.h... (cached) no checking for mysql/errmsg.h... (cached) no checking for MYSQL_OPT_RECONNECT... (cached) no checking for MYSQL_READ_DEFAULT_FILE... (cached) no checking for MYSQL_OPT_CONNECT_TIMEOUT... (cached) no checking for MYSQL_OPT_COMPRESS... (cached) no checking for MYSQL_OPT_NAMED_PIPE... (cached) no checking for MYSQL_INIT_COMMAND... (cached) no checking for MYSQL_READ_DEFAULT_GROUP... (cached) no checking for MYSQL_SET_CHARSET_DIR... (cached) no checking for MYSQL_SET_CHARSET_NAME... (cached) no checking for MYSQL_OPT_LOCAL_INFILE... (cached) no checking for SHUTDOWN_DEFAULT... (cached) no checking for library containing socket... (cached) none required checking for library containing gethostbyname... (cached) none required checking for library containing floor... (cached) none required checking for egrep... (cached) grep -E checking for ANSI C header files... (cached) yes checking for sys/types.h... (cached) yes checking for sys/stat.h... (cached) yes checking for stdlib.h... (cached) yes checking for string.h... (cached) yes checking for memory.h... (cached) yes checking for strings.h... (cached) yes checking for inttypes.h... (cached) yes checking for stdint.h... (cached) yes checking for unistd.h... (cached) yes checking for pthread.h... (cached) yes checking for gnu/stubs.h... (cached) no checking for pthread_self... (cached) yes checking for library containing _db_doprnt_... (cached) no checking for library containing my_init... (cached) no checking for library containing compress... (cached) -lz checking for mysql_real_connect in libmysql... (cached) no checking for mysql_connect in libmysql... (cached) no checking for mysql_real_connect in mysqlclient... (cached) no checking for mysql_connect in mysqlclient... (cached) no checking for mysql_real_connect in mysqllib... (cached) no checking for mysql_connect in mysqllib... (cached) no checking for mysql_real_connect in mysql... (cached) no checking for mysql_connect in mysql... (cached) no checking whether make sets $(MAKE)... (cached) yes checking for the Pike base directory... /space/kits/roxen-5.2.191-src/pike/src configure: creating ./config.status config.status: creating make_variables config.status: creating Makefile config.status: creating config.h config.status: config.h is unchanged config.status: executing default commands configure: configuring in Odbc configure: running /bin/sh '/space/kits/roxen-5.2.191-src/pike/src/modules/Odbc/configure' --prefix=/usr/public/roxen/roxen5 '--prefix=/usr/public/roxen/roxen5' '--with-mysql=/usr/public/mysql/mysql5.5' '--with-pcre' '--without-gssapi' '--cache-file=../.././config.cache' '--srcdir=/space/kits/roxen-5.2.191-src/pike/src' '--cache-file=../../.././config.cache' '--srcdir=/space/kits/roxen-5.2.191-src/pike/src/modules' --cache-file=../../../.././config.cache --srcdir=/space/kits/roxen-5.2.191-src/pike/src/modules/Odbc configure: loading cache ../../../.././config.cache but at the end, in the configure summary it shows . . . Mysql............... no (dependencies failed) . . . I cannot see any errors or anything though where it shows which dependencies are failing. Chad
