Changeset 1219
- Timestamp:
- 02/19/08 19:19:21 (10 months ago)
- Files:
-
- 1.8.3/branches/devel/CHANGES.183 (modified) (1 diff)
- 1.8.3/branches/devel/README.SQL (modified) (5 diffs)
- 1.8.3/branches/devel/configure (modified) (13 diffs)
- 1.8.3/branches/devel/configure.in (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
1.8.3/branches/devel/CHANGES.183
r1215 r1219 30 30 particular action list. This and associated commands inspired 31 31 by [Rhost]. 32 * New configure option --disable-sql to turn off checks for all supported 33 SQL servers. 32 34 33 35 Commands: 1.8.3/branches/devel/README.SQL
r873 r1219 5 5 6 6 As of version 1.7.7p32, PennMUSH includes functions and commands that 7 can access SQL databases. Currently, the following databases are 7 can access SQL databases. Currently, the following databases are 8 8 supported: 9 9 … … 12 12 * Sqlite v3 (from 1.8.3p2) 13 13 14 This document explains how to use (or avoid) SQL with PennMUSH, and covers15 the following issues:14 This document explains how to use (or avoid) SQL with PennMUSH, and 15 covers the following issues: 16 16 17 17 I. Compiling with or without SQL … … 22 22 23 23 In general, Configure attempts to detect all support sql client 24 libraries on the host, and will link with all of them, permitting 25 you to select which platform you want at runtime. You can selectively 26 prevent linking with client libraries that are present on your 27 system, as well; this is described below. 24 libraries on the host, and will link with all of them, permitting you 25 to select which platform you want at runtime. You can selectively 26 prevent linking with client libraries that are present on your system, 27 by passing configure a --without-FOO option. --disable-sql turns off 28 all checks for SQL servers. 28 29 29 30 I.a. MySQL 30 31 31 32 The configure script distributed with PennMUSH automatically detects 32 the MySQL client library via the presence of the mysql_config program, 33 which will tell configure where needed headers and libraries are. 33 the MySQL client library via the presence of the mysql_config 34 program, which will tell configure where needed headers and 35 libraries are. 34 36 35 37 If you want to avoid linking these libraries on systems where they 36 38 are present, pass the --without-mysql switch to configure. 37 39 38 If you installed Mysql from a binary package (e.g. rpm or apt), 39 you should be sure that your system also has the development40 package(usuallyl mysql-dev or mysql-devel).40 If you installed Mysql from a binary package (e.g. rpm or apt), you 41 should be sure that your system also has the development package 42 (usuallyl mysql-dev or mysql-devel). 41 43 42 44 If you think you have mysql libraries and header files but configure 43 isn't finding them, they may be in an unusual location on your system,44 with mysql_config not in your default path.45 Find its location ('where mysql_config' if the program works for you,46 'find / -name mysql_config' otherwise, and call configure with45 isn't finding them, they may be in an unusual location on your 46 system, with mysql_config not in your default path. Find its 47 location ('where mysql_config' if the program works for you, 'find / 48 -name mysql_config' otherwise, and call configure with 47 49 --with-mysql=/path/to/mysql_config 48 50 … … 57 59 58 60 If you installed PostgresQL from a binary package (e.g. rpm or apt), 59 you should be sure that your system also has the development 60 package(usually postgresql-dev, or libpq or similar)61 you should be sure that your system also has the development package 62 (usually postgresql-dev, or libpq or similar) 61 63 62 If you think you have postgresql libraries and header files but configure63 isn't finding them, they may be in an unusual location on your system,64 with pg_config not in your default path.65 Find its location ('where pg_config' if the program works for you,66 'find / -name pg_config' otherwise, and call configure with64 If you think you have postgresql libraries and header files but 65 configure isn't finding them, they may be in an unusual location on 66 your system, with pg_config not in your default path. Find its 67 location ('where pg_config' if the program works for you, 'find / 68 -name pg_config' otherwise, and call configure with 67 69 --with-postgresql=/path/to/pg_config 68 70 69 71 I.c Sqlite 70 72 71 The configure script distrubted with PennMUSH looks for sqlite3 headers 72 and libraries in /usr, /usr/local and /opt. If it's somewhere else on 73 your system, call configure with --with-sqlite3=/path/to/sqlite3 73 The configure script distrubted with PennMUSH looks for sqlite3 74 headers and libraries in /usr, /usr/local and /opt. If it's 75 somewhere else on your system, call configure with 76 --with-sqlite3=/path/to/sqlite3 77 78 If you want to avoid linking with sqlite on systems where it is 79 present, pass the --without-sqlite3 switch to configure. 74 80 75 The path is the directory that contains the hdrs/ and lib/ directories76 that hold the sqlite3 headers and library respectively.81 The path is the directory that contains the hdrs/ and lib/ 82 directories that hold the sqlite3 headers and library respectively. 77 83 78 84 II. Mush configuration overview … … 82 88 sql_platform provides the name of the SQL database server software 83 89 that will be used for connections. It current takes one of four 84 values: "disabled" (no SQL), "mysql", "postgresql", or "sqlite3". 90 values: "disabled" (no SQL), "mysql", "postgresql", or "sqlite3". 85 91 If not specified, it defaults to disabled. 86 92 87 sql_host gives the name of the host running the SQL server. 88 It defaults to 127.0.0.1, which makes a TCP connection to the89 local host. The keyword "localhost" instead makes a domain socket90 (Unix) or named pipe (Windows) connection under MySQL.91 You can also specify an alternate port by setting sql_host to92 hostname:port(e.g. 127.0.0.1:5444).93 sql_host gives the name of the host running the SQL server. It 94 defaults to 127.0.0.1, which makes a TCP connection to the local 95 host. The keyword "localhost" instead makes a domain socket (Unix) 96 or named pipe (Windows) connection under MySQL. You can also 97 specify an alternate port by setting sql_host to hostname:port 98 (e.g. 127.0.0.1:5444). 93 99 94 sql_database gives the name of the database that contains the 95 MUSH'stables. This must be specified and there is no default.100 sql_database gives the name of the database that contains the MUSH's 101 tables. This must be specified and there is no default. 96 102 97 103 sql_username provides a username to connect to the SQL server 98 with. If no specified, a null username will be used, which many 99 SQLservers treat as "the user running this (pennmush) process".104 with. If no specified, a null username will be used, which many SQL 105 servers treat as "the user running this (pennmush) process". 100 106 101 sql_password provides the password for the user. It defaults to 102 nopassword.107 sql_password provides the password for the user. It defaults to no 108 password. 103 109 104 For sqlite3, which uses a local file instead of connected to a database 105 server, sql_database gives the name of the database file, sql_host must 106 be localhost, and the username and password are currently ignored. 110 For sqlite3, which uses a local file instead of connected to a 111 database server, sql_database gives the name of the database file, 112 sql_host must be localhost, and the username and password are 113 currently ignored. 107 114 108 115 III. SQL setup tips 109 116 110 117 You will have to set up the appropriate database on the SQL server, 111 and username permitted to perform operations in that database, 112 and apassword for that username. This is a platform-specific process.118 and username permitted to perform operations in that database, and a 119 password for that username. This is a platform-specific process. 113 120 114 121 A. MySQL platform 1.8.3/branches/devel/configure
r1195 r1219 1283 1283 --disable-FEATURE do not include FEATURE (same as --enable-FEATURE=no) 1284 1284 --enable-FEATURE[=ARG] include FEATURE [ARG=yes] 1285 --disable-sql Don't use SQL support 1285 1286 --disable-ipv6 Don't use IPv6 networking 1286 1287 --disable-nls Don't use message-translation … … 3281 3282 3282 3283 3284 3283 3285 # Extract the first word of "perl", so it can be a program name with args. 3284 3286 set dummy perl; ac_word=$2 … … 3321 3323 3322 3324 3325 if test "${PERL+set}" != "set"; then 3326 { { echo "$as_me:$LINENO: error: perl is required to build and run PennMUSH" >&5 3327 echo "$as_me: error: perl is required to build and run PennMUSH" >&2;} 3328 { (exit 1); exit 1; }; } 3329 fi 3330 3323 3331 # Extract the first word of "test", so it can be a program name with args. 3324 3332 set dummy test; ac_word=$2 … … 3441 3449 3442 3450 3443 # AC_PATH_PROG(EXPAND, expand)3444 3451 # Extract the first word of "indent", so it can be a program name with args. 3445 3452 set dummy indent; ac_word=$2 … … 3608 3615 # maybe use them instead? 3609 3616 if test $DEFAULT_CFLAGS = yes; then 3610 if test " x$GDB" != x; then3611 if test " x$ac_cv_c_compiler_gnu" = xyes; then3617 if test "${GDB+set}" = "set"; then 3618 if test "${ac_cv_c_compiler_gnu+set}" = "set"; then 3612 3619 CFLAGS="-ggdb $CFLAGS -W -Wall -pedantic -Wno-comment" 3613 3620 else … … 3685 3692 3686 3693 3687 if test $build_os = darwin -a $build_cpu = powerpc; then 3694 case "${build_cpu}-${build_os}" in 3695 powerpc*-darwin*) 3688 3696 3689 3697 … … 3731 3739 echo "${ECHO_T}yes" >&6; } 3732 3740 3733 CFLAGS="$CFLAGS -mdynamic-no-pic"3741 CFLAGS="$CFLAGS -mdynamic-no-pic" 3734 3742 3735 3743 … … 3751 3759 3752 3760 3753 fi 3754 3755 3756 if test " x$CTAGS" = x -a "x$EXCTAGS" != x; then3761 ;; 3762 esac 3763 3764 if test "${CTAGS+set}" != "set" -a "${EXCTAGS+set}" = "set"; then 3757 3765 CTAGS=$EXCTAGS 3758 3766 fi 3759 3767 3760 if test " x$ETAGS" = x -a "x$EXCTAGS" != x; then3768 if test "${ETAGS+set}" != "set" -a "${EXCTAGS+set}" = "set"; then 3761 3769 ETAGS="$EXCTAGS -e" 3762 3770 fi … … 3802 3810 3803 3811 3804 if test " x$UPTIME" != x; then3812 if test "${UPTIME+set}" = "set"; then 3805 3813 cat >>confdefs.h <<\_ACEOF 3806 3814 #define HAVE_UPTIME 1 … … 3854 3862 3855 3863 3856 if test " x$SENDMAIL" != x; then3864 if test "${SENDMAIL+set}" = "set"; then 3857 3865 cat >>confdefs.h <<\_ACEOF 3858 3866 #define HAVE_SENDMAIL 1 … … 12197 12205 12198 12206 12199 if test " no$PCRE_LIBS" != "no"; then12207 if test "${PCRE_LIBS+set}" = "set"; then 12200 12208 cat >>confdefs.h <<\_ACEOF 12201 12209 #define HAVE_PCRE 1 … … 12206 12214 ### Databases 12207 12215 12216 # Check whether --enable-sql was given. 12217 if test "${enable_sql+set}" = set; then 12218 enableval=$enable_sql; enable_sql=$enableval 12219 else 12220 enable_Sql=yes 12221 fi 12222 12223 12224 if test $enable_sql = yes; then 12225 { echo "$as_me:$LINENO: Looking for supported SQL servers" >&5 12226 echo "$as_me: Looking for supported SQL servers" >&6;} 12208 12227 12209 12228 … … 12643 12662 fi 12644 12663 12664 else 12665 { echo "$as_me:$LINENO: Skipping SQL server checks" >&5 12666 echo "$as_me: Skipping SQL server checks" >&6;} 12667 fi 12645 12668 12646 12669 ### Functions 1.8.3/branches/devel/configure.in
r1207 r1219 70 70 ], []) 71 71 ;; 72 csac72 esac 73 73 74 74 if test "${CTAGS+set}" != "set" -a "${EXCTAGS+set}" = "set"; then … … 177 177 ### Databases 178 178 179 AC_ARG_ENABLE(sql, AS_HELP_STRING([--disable-sql], 180 [Don't use SQL support]), enable_sql=$enableval, enable_Sql=yes) 181 182 if test $enable_sql = yes; then 183 AC_MSG_NOTICE([Looking for supported SQL servers]) 179 184 AX_LIB_MYSQL() 180 185 AX_LIB_POSTGRESQL() 181 186 AX_LIB_SQLITE3() 187 else 188 AC_MSG_NOTICE([Skipping SQL server checks]) 189 fi 182 190 183 191 ### Functions
