Koozali.org: home of the SME Server

help desk ticket system

Offline treyh

  • ****
  • 116
  • +0/-0
    • http://www.wilnet1.com
help desk ticket system
« Reply #15 on: March 23, 2005, 06:23:11 PM »
Quote from: "kmccarn"
Well - I'd like to get this to work - but I can't seem to get past the user stuff in mysql. (at leat that's the failure message I get)

I get connection to database failed from the setup script.

I have created new databases - new users - nothing helps.

Any thoughts ??


I'm pretty sure I know what the problem is. I should had been more descriptive in setting permissions in the MYSQL database but I was out of time. Here is the setup for the databases

1. go to https://yourserveripordomain/phpmyadmin
2. Login with the admin account of your sme box
3. on the right hand side click "Privileges"
4. Click add New user
5. Here is the information for the user
username = ticketmanager (can be whatever you want)
host = leave blank
password = type in the password you want

Under Global Privileges check all boxes.
Then click add user

6. Scroll down and you'll see "Database-specific privileges"....and then it will say "Add privileges on the following database", in that drop down box select MYSQL

7. on the next screen check all privileges and then click go

8. then go back to the http://yourserverdomainorip/osticket/setup.php and enter the user, pass, and mysql for the database in the setup wizard.

If that still doesn't work then let me know. you can email me at treyh@wilnet1.com if you want.
Trey - Network Specialist......

wallyrp

help desk ticket system
« Reply #16 on: March 23, 2005, 08:15:19 PM »
Good Afternoon,

It looks like the chmod 777 was only to the one file, config.php, that was located in the osticket folder. I'm looking for screenshots on this product as I'm looking to go to something else next year. I guess I'll just download it and look at it.

I've looked at oneorzero and liked the knowledge base portion of it. The one I'm using right now is phphelpdesk which is just downright simple to operate but is going nowhere in development.

Offline treyh

  • ****
  • 116
  • +0/-0
    • http://www.wilnet1.com
screenshots
« Reply #17 on: March 23, 2005, 08:29:27 PM »
here is a screenshot I found for everyone

http://www.nexcess.net/hosting/support/tutorials/osticket/1.2.5/osticket7.gif

If you want to see more, you can google "osticket" in the images section
Trey - Network Specialist......

oniedae

I installed phpmyadmin like you posted....
« Reply #18 on: March 24, 2005, 06:14:26 AM »
I can load it into my browser but after I choose an option like privleges (any option will give the same results) the following page that lods up has no graphics and no links will work (mac safari) or I get an error that "The specified server could not be found" (mac ie)

Offline kmccarn

  • ****
  • 112
  • +0/-0
help desk ticket system
« Reply #19 on: March 24, 2005, 02:02:18 PM »
The mysql instructions helped. I have it working.

THANKS !!

Now - have you gotten the automail working ??

If so - how ?

 :roll:
Kevin in WV 8-)......

Offline treyh

  • ****
  • 116
  • +0/-0
    • http://www.wilnet1.com
Re: I installed phpmyadmin like you posted....
« Reply #20 on: March 24, 2005, 03:01:26 PM »
Quote from: "oniedae"
I can load it into my browser but after I choose an option like privleges (any option will give the same results) the following page that lods up has no graphics and no links will work (mac safari) or I get an error that "The specified server could not be found" (mac ie)


I would assume that you're installing osticket on an sme 6.0 box and trying to access it by using a MAC with Safari and IE as browsers.

I don't know how compatible mac is with osticket. I just browsed thru www.osticket.com and didn't find anything. You might try posting here

http://www.osticket.com/forums/
Trey - Network Specialist......

Offline treyh

  • ****
  • 116
  • +0/-0
    • http://www.wilnet1.com
help desk ticket system
« Reply #21 on: March 24, 2005, 03:05:27 PM »
Quote from: "kmccarn"
The mysql instructions helped. I have it working.

THANKS !!

Now - have you gotten the automail working ??

If so - how ?

 :roll:


I would assume by "automail" you mean receiving email when a ticket is opened/closed by the user who opens it and also an email telling a tech there is a new message.

If that's what you mean then I have it working. It should be a simple setup. Login in as admin and go to mail messages. Enter the correct email addresses and edit the subject if you want.

 :pint: :pint: :pint:
Trey - Network Specialist......

g00s3m4n

help desk ticket system
« Reply #22 on: March 25, 2005, 04:50:26 PM »
hello all..

i have been snowed under at the office. am i correct in asuming that everyone got osticket working ok?

Offline kmccarn

  • ****
  • 112
  • +0/-0
help desk ticket system
« Reply #23 on: March 25, 2005, 09:51:29 PM »
Well - almost....

I am still trying to get the automail.pl or some other form of automatic ticket generation/response working.

Admitedly - I haven't spent a great deal of time on it.

 :-o
Kevin in WV 8-)......

Offline kmccarn

  • ****
  • 112
  • +0/-0
help desk ticket system
« Reply #24 on: March 28, 2005, 02:56:43 PM »
For anyone interested....

I finally achieved full functionality.

users can send an email to: support@mydomain.com from anywhere - and a ticket is generated - an alert is sent to the admin group - and a response is sent to the requester.

I used the automail.php method and the crontab manager add-in for SME.

 :-D
Kevin in WV 8-)......