History of SetupMSSQL

Differences from version 5 to 20



@@ -1,46 +1,60 @@

-[UNDER DEVELOPMENT]
-
-You should first read ((How to install Bitweaver under IIS 5))
+You should first read How to install Bitweaver under IIS 5 ([SetupIIS]).
 
 This guide assumes (and has been tested on):
 *Windows 2000 Server
 *IIS 5.0
-*MSDE (SQL Server 2000 Desktop Edition)
-*Bitweaver 1.0.1
-*PHP 5.0.4
-
-Firstly, create a new database in Enterprise Manager (SQL Server) or another tool (MSDE does not ship with Enterprise Manager). A good, free one is [http://www.asql.biz/DbaMgr/DownLoad2k.shtm|DBA Manager 2k]. It can be called anything you like, I called mine 'BitWeaver'.
-
-Create a new login in your database with the same name as the IIS anonymous user (default is '[servername]\IUSR_[servername]'). Give that user the sysadmin server role and db_owner role on the database you just created.
+*MS-SQL Server 2000 or MS-SQL Server 2000 Desktop Edition (MSDE)
+*Bitweaver 1.0.3+
+*PHP 4.3+ or 5.0.4+
 
-Some modifications were made to the following files to get BitWeaver working:
+#((SetupIIS))
+**I had to set up IIS to use ISAPI - don't remember atm if this was a MSSQL-specific thing or just a Windows / IIS specific thing - cruggles
+#Setup PHP (with ISAPI)
+**Download the [http://www.php.net/downloads.php|PHP 4.x.x or PHP 5.x.x zip package]
+**Extract __php-x.x.x-Win32\extensions\ php_mssql.dll__ to __C:\ PHP__
+**Uncomment __extension=php_mssql.dll__ to the extensions section of __php.ini__
+**__PHP5:__ Add php5isapi.dll against ".php" to Application extension mappings
+#Setup DB
+** TIP: To set up the databases you can use Enterprise Manager (for SQL Server) or another tool (MSDE does not ship with Enterprise Manager). A good, free one is [http://www.asql.biz/DbaMgr/DownLoad2k.shtm|DBA Manager 2k]. The new SQL Server 2005 Express release can also be used, and there is a tool on the Microsoft site which allows you to browse your databases (you have to use SQL to make any changes though).
+** In ''Enterprise Manager'', right-click on the database server, and select __Properties__
+*** Change to the __Security__ tab, and change __Authentication__ to ''SQL Server and Windows''
+*** Press OK - you will be prompted to restart the SQL Server service.
+** Expand folders until you see the __Security / Logins__ folder
+*** Right-click and select __New login...__
+*** Enter database user name eg ''bitweaver''
+*** For __Authentication__, select __SQL Server Authentication__
+*** Enter a password
+*** Switch to the __Server Roles__ tab, and check the __System Administrators__ checkbox
+*** Press OK and confirm your password
+** Right-click on the __Databases__ folder and select __New Database...__
+*** Enter a __Name__ eg ''bitweaver''
+*** Press OK
+** Right-click on the newly created database, and select __New / Database User..._
+*** For __Login name__, select previously created user eg ''bitweaver''
+*** Check the __db_owner__ checkbox
+*** Press OK
+# Visit your homepage [http://localhost/bitweaver/install/install.php]
+# Follow the step and when prompted for database connection details, enter the information as created above.
+# If you are unsuccessful at installing, you may need to do the following to get it to work- cruggles:
+## Change /util/phpsniff/phpSniff.class.php line 188 HTTP_SERVER_VARS to _SERVER
+## Change /util/adodb/drivers/adodb-mssql.inc.php line 661 - 666 from:
 
-in /util/phpsniff/phpSniff.class.php, change "HTTP_SERVER_VARS" to "_SERVER" on line 188, eg:
-{CODE()}$UA = ( $pv[0] > 3 && $pv[1] > 0 ) ? $_SERVER['HTTP_USER_AGENT'] : $HTTP_SERVER_VARS['HTTP_USER_AGENT'];{CODE}
-to
-{CODE()}$UA = ( $pv[0] > 3 && $pv[1] > 0 ) ? $_SERVER['HTTP_USER_AGENT'] : $_SERVER['HTTP_USER_AGENT'];{CODE}
+{CODE()}if ($len > 4000 ) {
+ // NVARCHAR is max 4000 chars. Let's use NTEXT
+ $decl .= "@P$i NTEXT";
+} else {
+ $decl .= "@P$i NVARCHAR($len)";
+}
+$params .= "@P$i=N". (strncmp($v,"'",1)==0? $v : $this->qstr($v));{CODE}
+to:
+{CODE()}$decl .= "@P$i VARCHAR($len)";
+$params .= "@P$i=". (strncmp($v,"'",1)==0? $v : $this->qstr($v));{CODE}
+^Can this be adjusted from PHP.INI? - wolff_borg:
+; Valid range 0 - 2147483647. Default = 4096.
+;mssql.textlimit = 4096
 
+; Valid range 0 - 2147483647. Default = 4096.
+;mssql.textsize = 4096^
 
-added this below "case "mssql"" in "function convertQuery" (about line 552, /kernel/BitDb.php):
-{CODE()}
-$pQuery = preg_replace("/`/", "", $pQuery);
-$pQuery = str_replace("AS user,", "AS user_login,", $pQuery);
-$pQuery = str_replace("=? ASC", " ASC", $pQuery);
-$pQuery = str_replace("=? DESC", " DESC", $pQuery);
-break;
-{CODE}
-changed this function in /user/BitUser.php (about line 1003):
-{CODE()}function isPasswordDue() {
- $ret = FALSE;
- if( $this->isRegistered() ) {
- // get user_id to avoid NULL and zero confusion
- $query = "SELECT `user_id`, `pass_due`
- FROM `".BIT_DB_PREFIX."users_users`
- WHERE `pass_due` IS NOT NULL AND `login`=? ";
- $due = $this->GetAssoc( $query, array( (string) $this->mUserId ) );
- if( !empty( $due['user_id'] ) ) {
- $ret = $due['pass_due'] <= date("U");
- }
- }
- return $ret;
-}{CODE}
+Outstanding issues:
+*Concatenates wiki body text (assuming at 255 chars)^I think this is a general IE bug? [http://sourceforge.net/tracker/index.php?func=detail&aid=1258034&group_id=141358&atid=749176|SF#1258034] - wolff_borg^
Page History
Date/CommentUserIPVersion
28 Aug 2005 (10:31 UTC)
Added step by step instructions
Stephan Borg218.214.1.11320
Current • Source
Stephan Borg218.214.1.11318
View • Compare • Difference • Source
Stephan Borg218.214.1.11317
View • Compare • Difference • Source
Stephan Borg218.214.1.11316
View • Compare • Difference • Source
Stephan Borg218.214.1.11315
View • Compare • Difference • Source
Stephan Borg218.214.1.11314
View • Compare • Difference • Source
Chris Ruggles202.138.208.1989
View • Compare • Difference • Source
Chris Ruggles202.138.208.1985
View • Compare • Difference • Source
Chris Ruggles202.138.208.1984
View • Compare • Difference • Source
Chris Ruggles202.138.208.1981
View • Compare • Difference • Source