On May 4, 2012, at 9:51 PM, H. William Welliver III wrote:
> Chad,
>
> If you look closely at the log, you'll note that it has a lot of items that
> are marked as (cached). That's a pretty common thing, and it means that it
> didn't bother to recheck because it thinks it already knows the answer. You
> should remove all of the config.cache entries and try again:
>
> find . -name config.cache -exec rm -f {} \;
>
> Hopefully that will force the configure process to actually look again.
Hi
OK, I did this and removed all the cache files for config.
I re-ran the config
./configure --prefix=/usr/public/roxen/roxen5
--with-mysql=/usr/public/mysql/mysql5.5 --with-pcre --without-gssapi
and mysql IS in that location.
base# ls -al /usr/public/mysql/mysql5.5
total 45
drwxr-xr-x 13 root wheel 19 May 4 17:06 .
drwxr-xr-x 3 root wheel 3 Mar 23 02:30 ..
-rw-r--r-- 1 root wheel 17987 Mar 2 19:44 COPYING
-rw-r--r-- 1 root wheel 7604 Mar 2 19:44 INSTALL-BINARY
-rw-r--r-- 1 root wheel 2552 Mar 2 19:44 README
drwxr-xr-x 2 root wheel 42 Mar 23 02:30 bin
lrwxr-xr-x 1 root wheel 21 May 4 17:05 data -> /usr/local/mysql/data
drwxr-xr-x 4 root wheel 4 Mar 23 02:30 data.dist
drwxr-xr-x 2 root wheel 6 Mar 23 02:30 docs
drwxr-xr-x 3 root wheel 37 Mar 23 02:30 include
drwxr-xr-x 3 root wheel 10 Mar 23 02:30 lib
drwxr-xr-x 4 root wheel 4 Mar 23 02:30 man
lrwxr-xr-x 1 root wheel 27 May 4 17:06 my.cnf ->
/usr/local/mysql/var/my.cnf
drwxr-xr-x 10 root wheel 22 Mar 23 02:30 mysql-test
drwxr-xr-x 2 root wheel 3 Mar 23 02:30 scripts
drwxr-xr-x 27 root wheel 32 Mar 23 02:30 share
drwxr-xr-x 4 root wheel 30 Mar 23 02:30 sql-bench
drwxr-xr-x 2 root wheel 16 Mar 23 02:30 support-files
lrwxr-xr-x 1 root wheel 20 May 4 17:06 var -> /usr/local/mysql/var
base#
But config is not finding it (you can see it does not find mysql.h)
###################################################
## 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... no
checking for mysql/mysql.h... no
checking for errmsg.h... no
checking for mysql/errmsg.h... no
checking for MYSQL_OPT_RECONNECT... no
checking for MYSQL_READ_DEFAULT_FILE... no
checking for MYSQL_OPT_CONNECT_TIMEOUT... no
checking for MYSQL_OPT_COMPRESS... no
checking for MYSQL_OPT_NAMED_PIPE... no
checking for MYSQL_INIT_COMMAND... no
checking for MYSQL_READ_DEFAULT_GROUP... no
checking for MYSQL_SET_CHARSET_DIR... no
checking for MYSQL_SET_CHARSET_NAME... no
checking for MYSQL_OPT_LOCAL_INFILE... no
checking for SHUTDOWN_DEFAULT... no
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... no
checking for mysql_connect in mysqlclient... no
checking for mysql_real_connect in mysqllib... no
checking for mysql_connect in mysqllib... no
checking for mysql_real_connect in mysql... no
checking for mysql_connect in mysql... no
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: 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
###################################################
so
I decided to do this
% setenv CFLAGS "-I/usr/public/mysql/mysql5.5/include -I/usr/public/include
-I/usr/include -I/usr/local/include"
% setenv LDFLAGS "-L/usr/public/mysql/mysql5.5/lib -L/usr/public/lib -L/usr/lib
-L/usr/local/lib
and rerun the same configure line after removing cache files
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
>>
>>
>>
>
