Local server

[malc-c]

Hi all, first post and a total newbie to PHP and SQL Server, so be gentile with me

I'm looking at using the helpdesk software in a small organisation with a few PC's on a LAN. As they don't have the funds for a full blown sql server I'm looking at using one PC as the host for the database and what will become in effect a local intranet.

I'm testing this out on my home PC and have installed SQL server and created a default database which is in the default location C:\Program Files\Microsoft SQL Server\MSSQL\Data

I've created a folder on a different drive which will contain the html and other files for the intranet ( F:\test server ) and have extracted the files contained in the download to this folder.

However now I'm stuck as the info in the readme.htm document deals with using a 3rd party host for the database and the more traditional hosting of a website on a remote server. All attempts to point the Helpdesk to the database in the location above fails, and my lack of experience with PHP means I can't see what's wrong.

The current settings are

Code: Select all

/* Website settings */IT Helpdesk";
$hesk_settings['site_url']="http://localhost/test";

/* Help desk settings */
$hesk_settings['hesk_url']="http://localhost/test";
$hesk_settings['hesk_title']="My company support system";
$hesk_settings['max_listings']="15";
$hesk_settings['language']="english";
$hesk_settings['print_font_size']="12";
$hesk_settings['debug_mode']="0";

/* Contacts */
$hesk_settings['support_mail']="support@mywebsite.com";
$hesk_settings['webmaster_mail']="webmaster@mywebsite.com";
$hesk_settings['noreply_mail']="NOREPLY@mywebsite.com";

/* Server info */
$hesk_settings['server_path']   =   "C:\Program Files\Microsoft SQL Server\MSSQL\Data";

/* Database settings */
$hesk_settings['database_host']  =   "localhost";
$hesk_settings['database_name']  =   "Helpdesk";
$hesk_settings['database_user']  =   "guest";
$hesk_settings['database_pass']  =   "password";

Any pointers would be most welcome

Cheers

Malcolm

[Klemen]

Hi,

Since you don't have MySQL locally you are probably having problems with

Code: Select all

$hesk_settings['database_host']  =   "localhost"; 

Your database host most likely isn't "localhost", try with IP:port of the PC that has MySQL installed, for example:

"example.com:3307"
or
"127.0.0.1:3307"

Of course you need to enter the IP/domain of the host computer (not the above ones) and the correct port (3307 is the default one I think).

You can create a test script like this:

Code: Select all

<?php
// we connect to localhost at port 3307
$link = mysql_connect('127.0.0.1:3307', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

(Don't forget to change the IP, user and password to your own).

Once you get the above script working ("Connected successfully") you will have the correct info to use with Hesk (or any other script you run that needs MySQL).

[malc-c]

Many thanks for the reply.

I'll try the changes you suggest and will post back if I still have any problems

Thanks

Malcolm

[Josh]

Are you using MS SQL? Will the script work with that?

The easiest way to make this help desk script work using a Windows server or PC is to install WAMP (windows/apache/Myql/php). Installing the separate services is a pain and can be difficult to configure correctly on IIS.

Since it's intranet, security shouldn't be a big issue. Install WAMP and create a database through phpmyadmin. Easy as pie and everything (including the database) can reside on the PC you have set up as the server.

I just installed WAMP for the first time and it's worked like a charm for our internal web site.

If you have IIS already installed on the PC, you'll have to change either the WAMP or IIS http listen port (80) to something else. If you want to go with WAMP for example, change the default port in IIS to 8080. That way the default web page will use the Apache service on port 80.

Hope this helps.

http://www.wampserver.com/en/

[malc-c]

Hi Josh,

Thanks for the tip.

Since my original post, I spent hours trawling the web for possible answers, or alternative solutions to the task, and have found an excellent web based helpdesk solution that is totally free and also offers more than a simple ticket solution. Have a look at (REMOVED)

The point for me was that it needs no knowledge of scripting, and customisation is done through simple text boxes or HTML. Its also simple to install and more importian, simple for the end users to use.

Many thanks to you and Klemen for the assistance here, just sorry that its a little too late on this occasion

Best regards

Malcolm

[Klemen]

Glad to hear you got something else working, but please don't advertise other scripts here. I spend too much time providing support to allow that

[malc-c]

Sorry !

But its not a script, its an actual program

Maybe I should of put it in my signature as per Josh's