Interestingly, the following appears at the very top of the configure line
(with the CFLAGS and LDFLAGS defined to the same location and --with-mysql=YES
instead of the path since that is what ./configure --helps seems to imply. The
result is identical in either case)
creating cache ./config.cache
checking whether make sets ${MAKE}... yes
checking for a BSD compatible install... /usr/bin/install -c
configure: warning: Converted . to /space/kits/roxen-5.2.200-src,
If this does not work, please use an absolute path to the configure script.
checking WebServer version... 5.2.200
checking if Platform... no
updating cache ./config.cache
creating ./config.status
creating Makefile
configuring in pike/src
running /bin/sh /space/kits/roxen-5.2.200-src/pike/src/configure
--prefix=/usr/public/roxen/roxen5 --with-pcre --without-gssapi --with-mysql=YES
--cache-file=../.././config.cache
--srcdir=/space/kits/roxen-5.2.200-src/pike/src
configure: loading cache ../.././config.cache
checking for bash... no
checking whether make sets $(MAKE)... (cached) yes
checking whether make supports spaces in SHELL... ignored
/space/kits/roxen-5.2.200-src/pike/src/configure:
-I/usr/public/mysql/mysql5.5/include/: not found
However, as we see later on, it does fine mysql.h (see below) and if I take out
the CFLAGS env var, it does not find ant mysql.h
/usr/public/mysql/mysql5.5/include is definitely there. I copied the path from
the error and did an ls.
On May 5, 2012, at 1:44 PM, Chad Leigh Shire.Net LLC wrote:
>
>
> this time I got:
>
> ###################################################
> ## 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... no
> checking for winsock2.h... (cached) no
> checking for winsock.h... (cached) no
> checking for mysql.h... yes
> checking for mysql/mysql.h... no
> checking for errmsg.h... yes
> checking for mysql/errmsg.h... no
> checking for MYSQL_OPT_RECONNECT... yes
> checking for MYSQL_READ_DEFAULT_FILE... yes
> checking for MYSQL_OPT_CONNECT_TIMEOUT... yes
> checking for MYSQL_OPT_COMPRESS... yes
> checking for MYSQL_OPT_NAMED_PIPE... yes
> checking for MYSQL_INIT_COMMAND... yes
> checking for MYSQL_READ_DEFAULT_GROUP... yes
> checking for MYSQL_SET_CHARSET_DIR... yes
> checking for MYSQL_SET_CHARSET_NAME... yes
> checking for MYSQL_OPT_LOCAL_INFILE... yes
> checking for SHUTDOWN_DEFAULT... yes
> checking for library containing socket... none required
> checking for library containing gethostbyname... none required
> checking for library containing floor... 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... yes
> checking for library containing _db_doprnt_... no
> checking for library containing my_init... no
> checking for library containing compress... -lz
> checking for mysql_real_connect in libmysql... no
> checking for mysql_connect in libmysql... no
> checking for mysql_real_connect in mysqlclient... yes
> checking for mysql_get_client_version... yes
> configure: WARNING: Header version does not match library version, diabling
> module
> checking whether make sets $(MAKE)... (cached) yes
> checking for the Pike base directory... /space/kits/roxen-5.2.191-src/pike/src
> updating cache ../../../.././config.cache
> configure: creating ./config.status
> config.status: creating make_variables
> config.status: creating Makefile
> config.status: creating config.h
> 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'
> 'CFLAGS=-I/usr/public/mysql/mysql5.5/include -I/usr/public/include
> -I/usr/include -I/usr/local/include'
> 'LDFLAGS=-L/usr/public/mysql/mysql5.5/lib -L/usr/public/lib -L/usr/lib
> -L/usr/local/lib' '--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
>
> and
>
> .
> .
> .
> Mysql............... no (header/library mismatch)
> .
> .
> .
>
>
> There is only one version of mysql installed on this machine, which is a
> fresh install. There are also versions of mariadb and percona server
> installed, but they are installed in there own separate areas and none of
> them installed anything in any system areas, but only in their own separate
> areas (following a similar pattern to what you see for mysql) and none of
> them are in any of the normal system paths or the paths I specified in the
> CFLAGS and LDFLAGS
>
> Time to put on my thinking cap and figure this mystery out.
>
> Only one customer is using Roxen still, and he has said he could use PHP
> instead but I'd like to get this up and running. He can convert to PHP and
> apache on his own schedule if he wants to, or stay with Roxen.
>
> Chad
>
>
>
>>
>>
>> On May 4, 2012, at 7:59 PM, Chad Leigh Shire.Net LLC wrote:
>>
>>>
>>> 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
>>>
>>>
>>>
>>
>
