FITS Compliant Web Based Helpdesk - ** RELEASED **

[Jake]

Sure thing. The 2 gifs which seem to be missing from my directory are small_tick.gif (wish I could remember where the hell I saw this now, I will have to hunt around and find out where I saw the missing icon) and calendar.gif (on the add new announcement page, seems to be looking for calendar.gif, I think it should be asking for the icon_event.gif)

The issue regarding 64bit was that the MySQL ODBC connector (3.51.16) doesnt work in 64 with IIS running in 64bit mode. According to MySQL this will be corrected in release 3.51.17, in the meantime though, I had no trouble running the helpdesk when I switched the IIS back into 32bit mode. So for now I will run IIS in 32bit until the next release of the connector.

(to switch IIS back into 32bit mode , go to Run and type>

cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1

Swap the 1 for a 0 if you need to switch IIS back into 64bit)

[ICTNUT]

@Jake: Thanks for the update.

The small_tick.gif would have been in the admin area and yes I did do a change for the calendar button so it should indeed be looking for icon_event.gif.

I will make sure that these are included in the next release.

Thanks for the 64bit update I will add it to the support section of the forum on my site.

Many Thanks again.....

[Jake]

Pleasure to help where I can

[budgester]

I'm interested in the FITS compliant claim, in what ways is this FITS compliant ?

[ICTNUT]

On the Becta FITS website they have a section covering helpdesk and in particular logging support requests. They have supplied various Excel and Word documents in order to acheive this task and what I have done is mirrored these requirements into my Helpdesk.

The guys @ BECTA that deal with the FITS side of things have been contacted in order to check the helpdesk to ensure it is fully inline with the framework and nothing has been missed out, I am awaiting feedback at the moment.

The next stage is to implement SLA Management and Escalations which will extend the coverage of the Helpdesk within the FITS framework.

[CHR1S]

Right, I have almost got it sorted. If I make a new database with a default table but same name I can get to the point where it just needs the original DB. If I either do the stop sql copy supportSQL.mdf etc I get a suspect database.

Any pointers on how to get this working with MSSQL?

Thanks

Chris

[ICTNUT]

You need to go into the SQL enterprise manager right click on the databases node and select ATTACH DATABASE.

You will then need to point to where you have put the .MDF and .LDF files that came with the helpdesk zip file, this will then work although you will need to create an SQL user to use to connect to the database.

The way you are currently doing it is incorrect.

[CHR1S]

Thanks Mr Nut I did a good old google for it and that was the solution it came up with.. should have asked first really! As you can tell im pants with SQL

[ICTNUT]

No Probs :-)

[CHR1S]

Ok, when going to site admin I get -

Active Server Pages error 'ASP 0131' 

Disallowed Parent Path 

/help/admin/default.asp, line 1 

The Include file '..\incs\functions.asp' cannot contain '..' to indicate the parent directory.

Mean anything to you?

[ICTNUT]

Take a look at this link --> http://www.opsoftware.co.uk/forum/in...opic,31.0.html

[CHR1S]

Thanks again

[f21970]

Hi there,
I've installed the Helpdesk as per instructions, but can't seem to connect to my SQL database (MS SQL Express 2005). I've created a user & given it full owner rights to the database and inserted the following lines in common.asp:
'MS SQL Connection
strCon = "driver={SQL Server};server=192.168.100.1;uid=mlh;pwd=helpdesk; Database=supportSQL"
strCon = "Provider=SQLOLEDB; Data Source=192.168.100.1; Initial Catalog=supportSQL; User ID=mlh; Password=helpdesk"
I get the following error message in IE:
Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/$mlh$/main.asp, line 28

Please can you help me!! :?

[ICTNUT]

@ f21970: You question has been answered over at http://www.opsoftware.co.uk/forum/in...msg65.html#new

[ICTNUT]

Hi All,

Just a quick on e to let you all know that the next release of the helpdesk is available for download.

users of the helpdesk that have mySQL as the backend database please ensure that you read the following -> http://www.opsoftware.co.uk/forum/in...msg98.html#new before you upgrade.

As always feedback is requested either here or via the support forums -> http://www.opsoftware.co.uk/forum/