History of SetupMSSQL

Version 17

SetupMSSQL

Instructions on how to setup BitWeaver on Microsoft SQL Server

Created by: Stephan Borg, Last modification: 12 Aug 2005 (21:54 UTC) by Stephan Borg
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.3+
  • PHP 5.0.4+

  1. 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
  2. Setup PHP (with ISAPI)
    • Download the PHP 4.4.0 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
  3. 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 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).
  4. Add login IUSR_<servername> and make sysadmin (server role)
  5. Create a database, it can be called anything you like, you are prompted for this during installation
  6. Add IUSR_ as db_owner role on that database
  7. Extract bitweaver 1.0.3 files
  8. Change /util/phpsniff/phpSniff.class.php line 188 HTTP_SERVER_VARS to _SERVER
  9. Change /util/adodb/drivers/adodb-mssql.inc.php line 661 - 666 from:

{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


Outstanding issues:
  • Concatenates wiki body text (assuming at 255 chars)
I think this is a general IE bug? SF#1258034 - wolff_borg
</servername>
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