Koozali.org: home of the SME Server

oneorzero helpdesk software

ztasevski

oneorzero helpdesk software
« on: May 24, 2005, 01:28:20 AM »
hi,

anyone got oneorzero going successfully on sme 6.0 ? http://www.oneorzero.com/

have not had much success with it. It bombs out at the install after the database creation. There's a few posts about people having a touchdown with it but no howto for it ?

Zoran

Offline Franco

  • *
  • 1,171
  • +0/-0
    • http://contribs.org
oneorzero helpdesk software
« Reply #1 on: May 24, 2005, 04:11:22 AM »
You should have no problem installing it:
-create an ibay and enable dynamic content
-install the phpmyadmin contribs and load the sql file from it on the database you created for oneorzero.
-create user and give it the proper permissions
-then go to http://yourserver/oneorzerodirectory/utilities/setup_server.php and confirm settings
-follow the instructions accepting the agreement and creating the admin user
-rm the utilies directory and you should be good.

hth

ztasevski

oneorzero helpdesk software
« Reply #2 on: May 24, 2005, 04:21:58 AM »
hi hth,

thanks for your reply..

will give the phpadmin approach a shot and report back. we were just following the native oneorzero docs !

any other helpdesk packages you'd recommend ??

zoran

Offline Franco

  • *
  • 1,171
  • +0/-0
    • http://contribs.org
oneorzero helpdesk software
« Reply #3 on: May 24, 2005, 04:42:50 AM »
Zoran,
Stick with oneorzero, probably the best.

hth=hope this helps

stunt

ztasevski

oneorzero helpdesk software
« Reply #4 on: May 24, 2005, 05:02:57 AM »
hi stunt,

out all of the ones we tested it seems the best of the bunch...we've checked out some the commercial ones as well and they don't even offer half the features oneorzero offers - i guess that's open source :-D

thanks for the advice again !

Zoran

Offline markehle

  • ***
  • 125
  • +0/-0
oneorzero helpdesk software
« Reply #5 on: May 24, 2005, 06:12:26 PM »
I have installed oneorzero in an ibay and it seems to run fine, but I cannot logout. When I try to, it comes back with a login screen, the kind that comes up in a little popup window. It says, 'Site: helpdesk' and 'Realm: Server Manager'. When I log in with my oneorzero admin account, it then goes to a 'page cannot be found' screen, and the url is

'http://helpdesk/common/logout.php'

I can go back and everything still works, like I am still logged on.

I have it set up with my DNS server that you just type in helpdesk and it takes you to the oneorzero ibay.

The files are in the ibay html folder, and when I set up the thing, I told it that there was no alias, and the server DNS name was helpdesk.

Any ideas?

ztasevski

oneorzero helpdesk software
« Reply #6 on: May 25, 2005, 12:05:36 AM »
Quote from: "stuntshell"

-install the phpmyadmin contribs and load the sql file from it on the database you created for oneorzero.
-create user and give it the proper permissions
-then go to http://yourserver/oneorzerodirectory/utilities/setup_server.php and confirm settings


hi stunt,

installed and working  :-D  it was the phpmyadmin console that got me there as the user i had setup did not have the correct permissions for the mysql database ! Another thing to be aware of is browser security settings. If you permissions are too tight it will not display the error/s when logging into http://yourserver/oneorzerodirectory/utilities/setup_server.php

thank you again for your help !

markehle> just a thought had a similar issue when setting up the server i left the hostname as "localhost" and when accessing it through the client pc i was getting 'page cannot be found' because the client pc was accessing it its own web server etc..could it be dns ? have you attempted accessing the page directly ?

Zoran

Offline treyh

  • ***
  • 116
  • +0/-0
    • http://www.wilnet1.com
error message
« Reply #7 on: May 27, 2005, 12:00:20 AM »
Invalid query: Table 'mysql.ooz_themes' doesn't exist

I'm using phpmyadmin and set everything as you said. That is what I get when trying to browse to

http://content/helpdesk/common/index.php
Trey - Network Specialist......

Offline Franco

  • *
  • 1,171
  • +0/-0
    • http://contribs.org
oneorzero helpdesk software
« Reply #8 on: May 27, 2005, 05:57:46 AM »
Trey,
The sql file must be corrupted, this usually happens in situations where you download and uncompress using Windows and then move files to the server. Best thing to do is drop the database and remove the directories/files, wget and untar (tar -xvfz) where you want it, then install as usual creating the database then importing the sql file into the created database, and proceed with install.

hth,

Offline treyh

  • ***
  • 116
  • +0/-0
    • http://www.wilnet1.com
ur probably right
« Reply #9 on: May 27, 2005, 07:18:38 AM »
Hello,

Thanks for the response but I didn't download and uncompress the zip file using windows. I did a wget *****.zip and then unzipped.

I think that it was just a corrupt file. I will download it again tomorrow and try again. If that doesn't work then I will R&R phpmyadmin.
Trey - Network Specialist......

Offline treyh

  • ***
  • 116
  • +0/-0
    • http://www.wilnet1.com
not working
« Reply #10 on: May 27, 2005, 03:28:27 PM »
Hello Everyone,

I R&R both oneorzero and phpmyadmin. I'm not new with mysql and phpmyadmin, I've never had any problems before.

I still get the same error:
Invalid query: Table 'newtable.ooz_themes' doesn't exist

Here are my steps:
1. created new ibay for oneorzero named 'helpdesk'
2. wget and unziped the ozh16_final.zip
3. set permissions
4. created new database named 'newtable'
5. set permissions via phpmyadmin
6. browsed to http://myserver/helpdesk/ozh16_final/utilities/setup_server.php
7. set everything up correctly (i chose mysql database)
8. saved
9. when it didn't work, applied the patches
10. repated step 7
11. when It didn't work switched the database to mysql
12. when that didnt work I looked in phpmyadmin
13. oneorzero should have automatically created all the tables. But it didn't.
14. deleted the utilities directory, still didn't work

any ideas?
Trey - Network Specialist......

Offline jahlewis

  • *
  • 151
  • +0/-0
    • http://www.arachnerd.com/
oneorzero helpdesk software
« Reply #11 on: May 27, 2005, 04:34:46 PM »
rather than using phpmyadmin, try using, as root from the command line
Code: [Select]
mysql_setpermission

It walks you through setting up a DB and assigning user access.

then from the command line, use the following command to import the sql into the above db (replacing the generic info with your info of course:
Code: [Select]
mysql -f -uusername -ppassword databasename < sqlfile.sql

What permissions are you using in the ibay?  Best results can be gotten by using the follwoing command:
Code: [Select]
chown -R /home/e-smith/files/ibays/ibayname ibayowner ibaygroup
chmod -2770 /home/e-smith/files/ibays/ibayname
............

Offline markehle

  • ***
  • 125
  • +0/-0
oneorzero helpdesk software
« Reply #12 on: May 27, 2005, 05:33:48 PM »
Quote from: "ztasevski"
Quote from: "stuntshell"

markehle> just a thought had a similar issue when setting up the server i left the hostname as "localhost" and when accessing it through the client pc i was getting 'page cannot be found' because the client pc was accessing it its own web server etc..could it be dns ? have you attempted accessing the page directly ?

Zoran


You are right - It must be some sort of DNS issue. I took the helpdesk entry out of my DNS server, and reconfigured oneorzero to use the IP and it works fine.

I am using an SME 6.01 box for dns and my oneorzero is on another SME box running 6.5. How do I set up the DNS so that my users just have to type 'helpdesk' to get to oneorzero?  

Thanks -

Mark

ztasevski

oneorzero helpdesk software
« Reply #13 on: May 30, 2005, 03:30:48 PM »
hi mark,

the best thing to do is setup a domain called helpdesk.yourdomain.local on you dns server and then just point your users to access it via http://helpdesk.yourdomain.local if you get the primary ibay just do a html file that does a refresh after 2 seconds and diverts http://helpdesk to http://helpdesk.yourdomain.local

Just remeber that if the DND server knows what http://heldepsk is ..it does not mean your destination webserver will automatically know what the target domain is !

Zoran

Offline treyh

  • ***
  • 116
  • +0/-0
    • http://www.wilnet1.com
out of time
« Reply #14 on: May 31, 2005, 11:04:51 PM »
Quote from: "jahlewis"
rather than using phpmyadmin, try using, as root from the command line
Code: [Select]
mysql_setpermission

It walks you through setting up a DB and assigning user access.

then from the command line, use the following command to import the sql into the above db (replacing the generic info with your info of course:
Code: [Select]
mysql -f -uusername -ppassword databasename < sqlfile.sql

What permissions are you using in the ibay?  Best results can be gotten by using the follwoing command:
Code: [Select]
chown -R /home/e-smith/files/ibays/ibayname ibayowner ibaygroup
chmod -2770 /home/e-smith/files/ibays/ibayname


Sorry for my delay in response, I haven't had time to try it. I've been very busy but I'm going to try it tonight as I got off work an hourly early!
Trey - Network Specialist......