Bigace 2.7 on a windows server?

[Dragonslayer]

Does Bigace run on a windows iis server with SQL express??

anyone have experience with bigace on iis?

[Kevin]

It tried it once, but I couldn't get it up and running...

The problem was (a while ago, tried it with Version 2.4) that the PHP implementation used in IIS doesn't declare some variables with are there in Apache (see http://koivi.com/apache-iis-php-server-array.php). I implemented a workaround for 2.6, but I never had the chance to test it...

What will not work for sure, is the URL Rewriting, because the rule defniitions are completely different from the ones that BIGACE ship by default.

If you have a chance to test, let me know how it goes on - you know I will support you with that!

[Dragonslayer]

today we run bigace on an old pc running ClarkConnect (apache, php, mysql, etc (linux based))

we have resently bought a network scanning software for a sharp-mx7101 kopier.. and that software requires an IIS server and an SQL database, SQL Express recommended.
Thats the reason for the new server...
is bigace tested with SQL express? or should i skip that and jump directly to mysql?

its an intranet type server so security is not an issue

[Kevin]

Better use MySQL, I don't believe that you will get BIGACE up using SQLExpress.
You would need to customize the installer and tell BIGACE to use AdoDB with SQLExpress, and I am not sure if that would work. Search is MySQL based... no better not

IIS could work if the code I integrated is working as it should. But as I said, untested... The installer should work though.

Probably I will setup an IIS the next weeks and test it, but I am sure you need it quicker, so go ahead and let me know how it works.

[Dragonslayer]

Im still waiting for one the HDDs and some extra memmory for the New server.. so i havent started installing winows yet..
i guess the stuff i comming next week

[Dragonslayer]

i started installing today
i followed this guide to install and configure PHP 5 http://peterguy.com/php/install_IIS6.html
and it was succuess (i think- atleast phpinfo was working nice)
(it shows connection to MySQL server via mysqli)
MySQL was real easy to install

i started with the Bigace_2.7_beta.zip from the nightly build page
extracted the zip and install.php file to my webroot folder.
when browsing to install.php i noticed that the second install path did not have any / or \ in it
and then the files wont extract

Code:

Errors:
Could not create directory: C:\Inetpub\wwwroot/addon/
Could not create directory: C:\Inetpub\wwwroot/addon/FCKeditor/
Could not open file for writing: C:\Inetpub\wwwroot/addon/FCKeditor/_upgrade.html
Could not create directory: C:\Inetpub\wwwroot/addon/
Could not create directory: C:\Inetpub\wwwroot/addon/FCKeditor/
Could not open file for writing: C:\Inetpub\wwwroot/addon/FCKeditor/_whatsnew_history.html
Could not create directory: C:\Inetpub\wwwroot/addon/
Could not create directory: C:\Inetpub\wwwroot/addon/FCKeditor/
Could not create directory: C:\Inetpub\wwwroot/addon/FCKeditor/editor/
Could not create directory: C:\Inetpub\wwwroot/addon/FCKeditor/editor/css/
Could not create directory: C:\Inetpub\wwwroot/addon/FCKeditor/editor/css/behaviors/
Could not open file for writing: C:\Inetpub\wwwroot/addon/FCKeditor/editor/css/behaviors/disablehandles.htc
Could not create directory: C:\Inetpub\wwwroot/addon/

etc
so i did an manual extract

Code:

Errors:
Could not open file for writing: C:\Inetpub\wwwroot/addon/FCKeditor/_upgrade.html
Could not open file for writing: C:\Inetpub\wwwroot/addon/FCKeditor/_whatsnew_history.html
Could not open file for writing: C:\Inetpub\wwwroot/addon/FCKeditor/editor/css/behaviors/disablehandles.htc
Could not open file for writing: C:\Inetpub\wwwroot/addon/FCKeditor/editor/css/behaviors/showtableborders.htc
Could not open file for writing: C:\Inetpub\wwwroot/addon/FCKeditor/editor/css/fck_editorarea.css
Could not open file for writing: C:\Inetpub\wwwroot/addon/FCKeditor/editor/css/fck_internal.css

etc
i guess i have some permissions issue
Since this is an INTRANET server i gave IUSR_<servername> modify permissions om my webroot folder... and the install.php would countinue
(this setting would also allow the installscript to extract the zip file from the beginning)
All green dots exept "Magic Quotes GPC" and "Apache Header"
Click next and fill in MySQL data ... select "not possible" at Rewrite and .htaccess
Database Created (checked with MySQL-Front)
click next and then i got a http 500

[Kevin]

so the installer crashes before the community installation screens comes up?
did you check if the php/mysql connection works (for example using phpmyadmin)?
the 500 might be a critical php problem.
create a info.php with phpinfo() inside and check that the mysql extension is loaded.

[Dragonslayer]

Removed all files... Deleted database, rebooted and started all over...
it never finished extration.. so i did it manually again
Then the installation went fine!

I now have Bigace running on IIS 6 ... are there any problems that i should look for?

[Dragonslayer]

one of the first errors

Code:

ID 28
Namespace system
Datum 06.10.2009 15:02:55
Level Error
Fil  
Rad  
Användarnamn 1
Meddelande Could not find translation: itemMenu, se, C:\Inetpub\wwwroot/system/admin/plugins//
Stacktrace

But this also shows up on my SunServer .. so this is not related to IIS

[Kevin]

Great feedback. Kudos!
Seems the initial extraction doesn't work on a couple of servers. Has nothing to do with windows as I guess.

I have no idea how url rewrinting is handled inside IIS, probably the rules are quite different than these for apache.
But still the rules for BIGACE are almost identical to many other systems out there, so we could try to find one for IIS and adopt it. If you want to test it, tell me which CGI you are using for rewriting and I'll have a look.

Created a Wiki page, currently with less information
http://wiki.bigace.de/bigace:administration:iis

It would be great, if we could keep all important information about that issue there...

We had that error before, should have been fixed already - damned Forum search should know about it.

[Dragonslayer]

IIS has no rewriting as stock... But i found this plugin
http://www.helicontech.com/isapi_rewrite/
it claims to use same syntax as apache mod_rewrite
they have two versions.. one professional and one lite ..
the lite version is freeware but dont support proxy and multiple site configurations.. (.htaccess)

Lite version limitation
Lite and Full versions of ISAPI_Rewrite shares the same rewriting engine and source code. But Lite version does not support per-site configurations and all relative features. Only global rules are processed. In addition Lite version does not include proxying engine. The following directives are not supported in the Lite version: RewriteProxy, EnableRewrite, DisableRewrite, EnableConfig, DisableConfig, CacheClockRate. The following flags are not supported in the Lite version: P - proxy.

[Kevin]

Then give it a shot and see what happens

[Dragonslayer]

it worked  
but with slightly other rewrite rules

Code:

RewriteEngine On
## enabling rewrite.log
RewriteLogLevel 9
## enabling error.log
LogLevel debug

RewriteBase /

## Old style URLs, before BIGACE 2.4. Full URLs require complete rewriting
RewriteRule ^bigace/([^/]+)/([^/]+)/(.*)$ /public/index.php?cmd=$1&id=$2&name=$3 [NC,QSA]

## Probably a permalink with a unique URL
#RewriteRule ^bigace/(.*)$ /public/index.php?id=$1 [NC,QSA]

## If none of the above applied, this was probably a normal filesystem call.
## But if the file or directory does not exist, treat it as permalink
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule (.*) /public/index.php?id=$1 [QSA]

The lite version is configured via a server global httpd.conf text file
the "pro" version can use .htaccess files
i have only tested the lite version

[Kevin]

WOW!!!!

So you have a proper bigace installation with rewrite rules on iis - thats fantastic!
I'll add the info at the wiki page - I am really excited - thanks for the work and feedback

Oh, could you probably create a short list with the technical details - software versions and stuff like that.