make_project fails

[linuxguru]

When trying to create a new project on a new server install (svn rev 14140) the programs build, but make_project fails with what looks alike a mysql error. This is Ubuntu 7.10, but I get the same error on Debian testing.

mysql Ver 14.12 Distrib 5.0.45, for pc-linux-gnu (i486) using readline 5.2

wxWidgets is version 2.8.4

PHP 5.2.3-1ubuntu6 (cli) (built: Oct 4 2007 23:35:54)

Server version: Apache/2.2.4 (Ubuntu) Server built: Oct 4 2007 22:47:20

Python 2.5.1

make_project output:

root@jp-laptop:/home/jp/dev/boinc/boinc/tools# ./make_project --test_app test
Creating project 'test' (short name 'test'):
   PROJECT_ROOT = /root/projects/test/
       URL_BASE = http://localhost/
  HTML_USER_URL = http://localhost/test/
   HTML_OPS_URL = http://localhost/test_ops/
        CGI_URL = http://localhost/test_cgi/
        KEY_DIR = /root/projects/test/keys/
        DB_NAME = test
        DB_HOST =

Continue? [Y/n]  y
Setting up server: creating directories

Keys don't exist in /root/projects/test/keys/; generate them? [Y/n]  y
Setting up database/home/jp/dev/boinc/boinc/py/Boinc/database.py:255: Warning: 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
  cursor.execute(query)

Traceback (most recent call last):
  File "./make_project", line 212, in <module>
    project.install_project()
  File "/home/jp/dev/boinc/boinc/py/Boinc/setup_project.py", line 518, in install_project
    drop_first = options.drop_db_first
  File "/home/jp/dev/boinc/boinc/py/Boinc/database.py", line 269, in create_database
    _execute_sql_script(cursor, os.path.join(schema_path, file))
  File "/home/jp/dev/boinc/boinc/py/Boinc/database.py", line 255, in _execute_sql_script
    cursor.execute(query)
  File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '- entity type to which this forum is attached:\n        - 0 == category (public)\n' at line 23")

./configure output:

--- Configuring BOINC 6.1.0 (Release) ---
--- Build Components: (server & client) ---
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking target system type... i686-pc-linux-gnu
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /bin/mkdir -p
checking for gawk... no
checking for mawk... mawk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for gcc... gcc
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... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking how to run the C preprocessor... gcc -E
checking whether make sets $(MAKE)... (cached) yes
checking for ranlib... ranlib
checking for ln... /bin/ln
checking whether '/bin/ln' works... yes
checking whether ln -s works... yes
checking whether 'ln -s' really works or whether I'm deluding myself... it works
checking whether gcc and cc understand -c and -o together... yes
checking for docbook2x-man... no
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking whether we are compiling for cygwin... no
checking windows.h usability... no
checking windows.h presence... no
checking for windows.h... no
checking for winsock2.h... (cached) no
checking for winsock.h... (cached) no
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking dependency style of ... none
checking for a sed that does not truncate output... /bin/sed
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for /usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking how to recognise dependent libraries... pass_all
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking how to run the C++ preprocessor... g++ -E
checking for g77... no
checking for xlf... no
checking for f77... no
checking for frt... no
checking for pgf77... no
checking for cf77... no
checking for fort77... no
checking for fl32... no
checking for af77... no
checking for xlf90... no
checking for f90... no
checking for pgf90... no
checking for pghpf... no
checking for epcf90... no
checking for gfortran... no
checking for g95... no
checking for xlf95... no
checking for f95... no
checking for fort... no
checking for ifort... no
checking for ifc... no
checking for efc... no
checking for pgf95... no
checking for lf95... no
checking for ftn... no
checking whether we are using the GNU Fortran 77 compiler... no
checking whether  accepts -g... no
checking the maximum length of command line arguments... 32768
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... (cached) ranlib
checking for strip... strip
checking if gcc static flag  works... yes
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/bin/ld) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking for shl_load... no
checking for shl_load in -ldld... no
checking for dlopen... no
checking for dlopen in -ldl... yes
checking whether a program can dlopen itself... yes
checking whether a statically linked program can dlopen itself... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
configure: creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking for g++ option to produce PIC... -fPIC
checking if g++ PIC flag -fPIC works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking for shl_load... (cached) no
checking for shl_load in -ldld... (cached) no
checking for dlopen... (cached) no
checking for dlopen in -ldl... (cached) yes
checking whether a program can dlopen itself... (cached) yes
checking whether a statically linked program can dlopen itself... (cached) yes
appending configuration tag "F77" to libtool
checking default bitness of compiler... 32
checking boinc platform... i686-pc-linux-gnu
checking alternate boinc platform... none
checking library extension... a
checking shared object extension... so
checking for mysql_config... /usr/bin/mysql_config
checking mysql libraries... -L/usr/lib/mysql -lmysqlclient
checking mysql includes... -I/usr/include/mysql -DBIG_JOINS=1
checking for windows.h... (cached) no
checking for sys/socket.h... (cached) yes
checking for socklen_t... yes
checking type of getsockopt() parameter five... socklen_t
checking for gawk... (cached) mawk
checking for curl-config... /usr/bin/curl-config
checking for the version of libcurl... 7.16.4
checking for libcurl >= version 7.15.5... yes
checking whether libcurl is usable... yes
checking for curl_free... yes
checking for openssl... yes
OpenSSL found in /usr
checking for shmget in dynamic library cygipc... no
checking for aio_fork in dynamic library aio... no
checking for dlopen in dynamic library dl... -ldl
checking for gethostbyname in static library nsl... -lnsl
checking for bind in static library socket... no
checking for bind in dynamic library socket... no
checking for gzopen in static library z... -lz
checking for md5_finish in dynamic library cups... no
checking for curl_easy_init in static library curl... -lcurl
checking for the pthreads library -lpthreads... no
checking whether pthreads work without any flags... no
checking whether pthreads work with -Kthread... no
checking whether pthreads work with -kthread... no
checking for the pthreads library -llthread... no
checking whether pthreads work with -pthread... yes
checking for joinable pthread attribute... PTHREAD_CREATE_JOINABLE
checking if more special flags are required for pthreads... no
checking for cc_r... gcc
checking for X... libraries , headers 
checking for gethostbyname... yes
checking for connect... yes
checking for remove... yes
checking for shmat... yes
checking for IceConnectionNumber in -lICE... yes
checking whether we are using the Microsoft C compiler... no
checking for windows.h... (cached) no
checking for OpenGL library... -lGL
checking for OpenGL Utility library... -lGLU
checking for main in -lXmu... yes
checking for main in -lXi... yes
checking for GLUT library... -lglut
checking gl.h usability... no
checking gl.h presence... no
checking for gl.h... no
checking glu.h usability... no
checking glu.h presence... no
checking for glu.h... no
checking glut.h usability... no
checking glut.h presence... no
checking for glut.h... no
checking glaux.h usability... no
checking glaux.h presence... no
checking for glaux.h... no
checking GL/gl.h usability... yes
checking GL/gl.h presence... yes
checking for GL/gl.h... yes
checking GL/glu.h usability... yes
checking GL/glu.h presence... yes
checking for GL/glu.h... yes
checking GL/glut.h usability... yes
checking GL/glut.h presence... yes
checking for GL/glut.h... yes
checking GL/glaux.h usability... no
checking GL/glaux.h presence... no
checking for GL/glaux.h... no
checking OpenGL/gl.h usability... no
checking OpenGL/gl.h presence... no
checking for OpenGL/gl.h... no
checking OpenGL/glu.h usability... no
checking OpenGL/glu.h presence... no
checking for OpenGL/glu.h... no
checking OpenGL/glut.h usability... no
checking OpenGL/glut.h presence... no
checking for OpenGL/glut.h... no
checking OpenGL/glaux.h usability... no
checking OpenGL/glaux.h presence... no
checking for OpenGL/glaux.h... no
checking GLUT/glut.h usability... no
checking GLUT/glut.h presence... no
checking for GLUT/glut.h... no
checking MesaGL/gl.h usability... no
checking MesaGL/gl.h presence... no
checking for MesaGL/gl.h... no
checking MesaGL/glu.h usability... no
checking MesaGL/glu.h presence... no
checking for MesaGL/glu.h... no
checking MesaGL/glut.h usability... no
checking MesaGL/glut.h presence... no
checking for MesaGL/glut.h... no
checking MesaGL/glaux.h usability... no
checking MesaGL/glaux.h presence... no
checking for MesaGL/glaux.h... no
checking for jpeg_start_compress in -ljpeg... yes
checking jpeglib.h usability... yes
checking jpeglib.h presence... yes
checking for jpeglib.h... yes
checking for dirent.h that defines DIR... yes
checking for library containing opendir... none required
checking for ANSI C header files... (cached) yes
checking for sys/wait.h that is POSIX.1 compatible... yes
checking whether time.h and sys/time.h may both be included... yes
checking return type of signal handlers... void
checking for windows.h... (cached) no
checking arpa/inet.h usability... yes
checking arpa/inet.h presence... yes
checking for arpa/inet.h... yes
checking dirent.h usability... yes
checking dirent.h presence... yes
checking for dirent.h... yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking for inttypes.h... (cached) yes
checking for stdint.h... (cached) yes
checking malloc.h usability... yes
checking malloc.h presence... yes
checking for malloc.h... yes
checking alloca.h usability... yes
checking alloca.h presence... yes
checking for alloca.h... yes
checking for memory.h... (cached) yes
checking netdb.h usability... yes
checking netdb.h presence... yes
checking for netdb.h... yes
checking netinet/in.h usability... yes
checking netinet/in.h presence... yes
checking for netinet/in.h... yes
checking netinet/tcp.h usability... yes
checking netinet/tcp.h presence... yes
checking for netinet/tcp.h... yes
checking signal.h usability... yes
checking signal.h presence... yes
checking for signal.h... yes
checking for strings.h... (cached) yes
checking sys/auxv.h usability... no
checking sys/auxv.h presence... no
checking for sys/auxv.h... no
checking sys/file.h usability... yes
checking sys/file.h presence... yes
checking for sys/file.h... yes
checking sys/ipc.h usability... yes
checking sys/ipc.h presence... yes
checking for sys/ipc.h... yes
checking sys/mount.h usability... yes
checking sys/mount.h presence... yes
checking for sys/mount.h... yes
checking sys/param.h usability... yes
checking sys/param.h presence... yes
checking for sys/param.h... yes
checking sys/resource.h usability... yes
checking sys/resource.h presence... yes
checking for sys/resource.h... yes
checking sys/select.h usability... yes
checking sys/select.h presence... yes
checking for sys/select.h... yes
checking sys/shm.h usability... yes
checking sys/shm.h presence... yes
checking for sys/shm.h... yes
checking for sys/socket.h... (cached) yes
checking for sys/stat.h... (cached) yes
checking sys/statvfs.h usability... yes
checking sys/statvfs.h presence... yes
checking for sys/statvfs.h... yes
checking sys/statfs.h usability... yes
checking sys/statfs.h presence... yes
checking for sys/statfs.h... yes
checking sys/swap.h usability... yes
checking sys/swap.h presence... yes
checking for sys/swap.h... yes
checking sys/sysctl.h usability... yes
checking sys/sysctl.h presence... yes
checking for sys/sysctl.h... yes
checking sys/systeminfo.h usability... no
checking sys/systeminfo.h presence... no
checking for sys/systeminfo.h... no
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking for sys/types.h... (cached) yes
checking sys/utsname.h usability... yes
checking sys/utsname.h presence... yes
checking for sys/utsname.h... yes
checking sys/vmmeter.h usability... no
checking sys/vmmeter.h presence... no
checking for sys/vmmeter.h... no
checking for sys/wait.h... (cached) yes
checking for unistd.h... (cached) yes
checking utmp.h usability... yes
checking utmp.h presence... yes
checking for utmp.h... yes
checking errno.h usability... yes
checking errno.h presence... yes
checking for errno.h... yes
checking procfs.h usability... no
checking procfs.h presence... no
checking for procfs.h... no
checking ieeefp.h usability... no
checking ieeefp.h presence... no
checking for ieeefp.h... no
checking for special C compiler options needed for large files... no
checking for _FILE_OFFSET_BITS value needed for large files... 64
checking whether largefile support breaks C++... no
checking standard C++ headers... yes
checking for C++ header <algorithm>... (cached) yes
checking for C++ header <bitset>... (cached) yes
checking for C++ header <cassert>... (cached) yes
checking for C++ header <cctype>... (cached) yes
checking for C++ header <cerrno>... (cached) yes
checking for C++ header <cfloat>... (cached) yes
checking for C++ header <climits>... (cached) yes
checking for C++ header <clocale>... (cached) yes
checking for C++ header <cmath>... (cached) yes
checking for C++ header <complex>... (cached) yes
checking for C++ header <csetjmp>... (cached) yes
checking for C++ header <csignal>... (cached) yes
checking for C++ header <cstdarg>... (cached) yes
checking for C++ header <cstddef>... (cached) yes
checking for C++ header <cstdio>... (cached) yes
checking for C++ header <cstdlib>... (cached) yes
checking for C++ header <cstring>... (cached) yes
checking for C++ header <ctime>... (cached) yes
checking for C++ header <deque>... (cached) yes
checking for C++ header <fstream>... (cached) yes
checking for C++ header <functional>... (cached) yes
checking for C++ header <iomanip>... (cached) yes
checking for C++ header <ios>... (cached) yes
checking for C++ header <iosfwd>... (cached) yes
checking for C++ header <iostream>... (cached) yes
checking for C++ header <istream>... (cached) yes
checking for C++ header <iterator>... (cached) yes
checking for C++ header <limits>... (cached) yes
checking for C++ header <list>... (cached) yes
checking for C++ header <locale>... (cached) yes
checking for C++ header <map>... (cached) yes
checking for C++ header <memory>... (cached) yes
checking for C++ header <numeric>... (cached) yes
checking for C++ header <ostream>... (cached) yes
checking for C++ header <queue>... (cached) yes
checking for C++ header <set>... (cached) yes
checking for C++ header <sstream>... (cached) yes
checking for C++ header <stack>... (cached) yes
checking for C++ header <stdexcept>... (cached) yes
checking for C++ header <streambuf>... (cached) yes
checking for C++ header <string>... (cached) yes
checking for C++ header <utility>... (cached) yes
checking for C++ header <valarray>... (cached) yes
checking for C++ header <vector>... (cached) yes
checking for C++ namespaces... yes
checking for min(0,0) in namespace std... yes
checking for max(0,0) in namespace std... yes
checking for transform((char *)0,(char *) 0,(char *)0,(int(*)(int))malloc) in namespace std... yes
checking for locale("") in namespace std... yes
checking whether gcc needs -traditional... no
checking for vprintf... yes
checking for _doprnt... no
checking for alloca... no
checking for _alloca... no
checking for setpriority... yes
checking for strlcpy... no
checking for strlcat... no
checking for sigaction... yes
checking for getutent... yes
checking for setutent... yes
checking for getisax... no
checking for an ANSI C-conforming const... yes
checking for size_t... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking for struct tm.tm_zone... yes
checking for wx-libs ...
checking for wx-config... /usr/bin/wx-config
checking for wxWidgets version >= 2.6.0... no
configure: WARNING:
================================================================================
WARNING: A suitable installation of wxWidgets could not be found
	 ==> building client without clientgui.

  If you add wxWidgets to your system, then this configure script will also
  configure your system to build the BOINC graphical client (clientgui).

  If wxWidgets is installed on your system, please check that wx-config is
  in the path, that the directory where wxWidgets libraries are installed
  (returned by 'wx-config --libs' command) is in LD_LIBRARY_PATH (or equivalent),
  and that wxWidgets version is 2.6.0 or above. Currently wxWidgets version
  2.6.0 (gtk based) is known to work with boinc_gui under Linux. You can
  use wx-config --version to find what version you have currently installed.

  NOTE: if building a portable client-release, you need the *static* version
  of the wx-libs installed!

  You can get wxWidgets by following the DOWNLOAD link at:
  http://www.wxwindows.org/
================================================================================
       
checking for atexit in dynamic library c... -lc
checking for _Unwind_Resume in static library gcc_eh... -lgcc_eh
checking for sscanf in static library stdc++... -lstdc++
checking for sscanf in static library gcc... -lgcc
checking for sin in dynamic library m... -lm
checking for pthread_join in dynamic library pthread... -lpthread
checking for dynamic library wsock32... no
configure: creating ./config.status
config.status: creating ./version.h
config.status: creating api/Makefile
config.status: creating apps/Makefile
config.status: creating clientgui/Makefile
config.status: creating client/Makefile
config.status: creating client/win/boinc_path_config.py
config.status: creating db/Makefile
config.status: creating doc/Makefile
config.status: creating doc/manpages/Makefile
config.status: creating lib/Makefile
config.status: creating Makefile
config.status: creating py/Boinc/boinc_path_config.py
config.status: creating py/Boinc/Makefile
config.status: creating py/boinc_path_config.py
config.status: creating py/Boinc/version.py
config.status: creating py/Makefile
config.status: creating sched/boinc_path_config.py
config.status: creating sched/Makefile
config.status: creating sea/Makefile
config.status: creating test/boinc_path_config.py
config.status: creating test/Makefile
config.status: creating test/version.inc
config.status: creating tools/boinc_path_config.py
config.status: creating tools/Makefile
config.status: creating zip/Makefile
config.status: creating zip/zip/Makefile
config.status: creating zip/unzip/Makefile
config.status: creating m4/Makefile
config.status: creating config.h
config.status: config.h is unchanged
config.status: executing depfiles commands
--- Configuring BOINC 6.1.0 (Release) ---
--- Build Components: (server & client) ---