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......

Offline treyh

  • ***
  • 116
  • +0/-0
    • http://www.wilnet1.com
last troubleshooting
« Reply #15 on: June 01, 2005, 05:56:36 AM »
Hello Everyone,

I've removed all ibays relating to onezero and all installation/configuration files. I'm going to start completely fresh.

Here are the steps and my results:
1. I decided to use the Primary Ibay
**I have an internal site I use on the primary ibay already. This will not cause
a conflict since my internal site is in the folder of "helpdesk" and the oneorzero
site is under the folder of "ozh16_final". The user can simply click on either or for
the time being.

1a.I did...
wget http://internap.dl.sourceforge.net/sourceforge/oneorzero/ozh16_final.zip
I unzipped the ozh16_final.zip and it created the ozh16_final directory.

2. I went to phpmyadmin https://myserver.com/phpmyadmin

   a. created a new table called 'newtable'
   b. created user of 'treyh' and gave full access to the mysql and newtable databases
   c. once again I want to note that I've done this about 10 other time to try out other helpdesk software
      so my error is not with this step. Thats why I was brief.

3. I browsed to http://myserver.com/ozh16_final/utilities/setup_server.php
   a. localhost = localhost
   b. One Or Zero Web Alias (One Or Zero Directory) = ozh16_final
   c. Maximum Attachment Size (Mb) = 16
   d. Attachment Directory = attachments
   e. Database Type = MYSQL
   f. MySQL Host Name (if applicable) = localhost
   g. MySQL Username (if applicable) = treyh
   h. MySQL Password (if applicable) = ******** (didn't want to show my password)
   i. MySQL Database Name (if applicable) = mysql
   j. One Or Zero Tablename Prefix (not applicable for SQLite) = ooz_
   k. SQLite Database Filename (if applicable) = blank
   l. submitted changes

4. tried to browse to http://myserver.com/ozh16_final and got
"Invalid query: Table 'mysql.ooz_themes' doesn't exist"

5. Just to verify it's not a permission problem here is what I did. It's not the right way but it was the fastest check.

   a. set all directory and files to chmod 777
   b. just wanted to remind you that this server never touches the internet (besides when I downloaded the oneorzero files, and will never touch it again)
   c. same problem, left permissions this way for troubleshooting purposes
   d. please don't give me a lecture on not to use chmod 777 unless that is what is causing my problems.

6. I saw this but couldn't try it because there was no *.sql file in the oneorzero directory
=============
rather than using phpmyadmin, try using, as root from the command line
Code:
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:
mysql -f -uusername -ppassword databasename < sqlfile.sql
==============

I know my sql and phpmyadmin are fine because I can install a different helpdesk program, which uses php and mysql and it works fine. I can remove it and put another one in and then it works fine. Any help on this will be greatly appreciated.
Trey - Network Specialist......

wallyrp

oneorzero helpdesk software
« Reply #16 on: June 01, 2005, 03:48:36 PM »
Good Morning,

I just finished installing One'or'Zero with minor difficulty. Here's a mini how-to, will attempt to brush it up later.

1. Download from the link above that Trey posted.
2. Create an Information Bay named oneorzero. Group: Everyone - Access: Write=group,Read=everyone - Public Access: Internet (no password) - Dynamic Content: Enabled
3. Unzip the file you downloaded. It will be located in a folder named ozh16_final. You can unzip this in your root folder for now.
4. Let's do a chmod at this time for grins. chmod -R 777 ozh16_final/
5. Change into ozh16_final and move everything to /home/e-smith/files/ibays/oneorzero/html
6. Now let's go into mysql. Type mysql and then the following command: create database oneorzero; grant all privileges on oneorzero.* to username@localhost identified by 'passwordhereinthequotes';
7. For grins, you can go into phpmyadmin and make sure that everything is correct with the privileges.
8. Follow the rest of the installation manual in regards to the setup and configuration of oneorzero.
9. After your done with the initial configuration, make sure you chmod the appropriate files and folders to what the manual states. I personally chmod'ed the whole html folder to 775 and then went into the html folder to chmod the folders that needed a different setting to what the manual stated.
10. After all configuration is done, make sure that you remove the utilities folder to prevent anymore configuration changes to your setup.

Let me know if this works for anyone from scratch. If there are any other ideas or clarifications needed, let me know so I can include those in this how-to.

Offline treyh

  • ***
  • 116
  • +0/-0
    • http://www.wilnet1.com
same problem
« Reply #17 on: June 01, 2005, 05:39:45 PM »
Hello,

I followed ur "howto" perfectly wally with the same outcome.  :pint:  :pint:

I'm going to completely reload sme tonight and start completely fresh.

If it doesn't work then I'm going to give up lol.

Invalid query: Table 'oneorzero.ooz_themes' doesn't exist
Trey - Network Specialist......

ztasevski

oneorzero helpdesk software
« Reply #18 on: June 02, 2005, 12:08:34 AM »
Mark
Quote


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


Hi Mark,

Did you get a resolution on the logging out issue you were having?

I actually put oneorzero s/ware onto another server (server only more) with another server on the network doing DNS and I am getting exactly the same problem as you described.

Zoran

Offline vincentmeek

  • *
  • 29
  • +0/-0
    • Triple Point Solutions
oneorzero helpdesk software
« Reply #19 on: June 04, 2005, 07:01:20 PM »
Howto worked fine for me. SME 6.0.01 in server mode only.  Works with SMEPLUS script installed first.  Would not work with fresh install.

Has anyone got this working with ldap

 :-D
Vincent Meek
Network Consultant

tbcomputing

oneorzero helpdesk software
« Reply #20 on: June 19, 2005, 10:24:37 PM »
Hi

Installed fine - having logout problem as stated before:

The requested URL /common//logout.php was not found on this server.

6.0.01 server/gateway om Proliant 2500 2x Pentium Pro, 1gig ram.

Only none standard is SMTPauth to authorise outgoing mail to my ISP.

Any ideas?

Tony

ztasevski

oneorzero helpdesk software
« Reply #21 on: June 20, 2005, 12:12:52 AM »
hi,

i had the logging out feature working perfectly then setup the oneorzero to run from the root of the ibay and the logging out stopped working. I bet it will work if you put the following parameter in the setup of the server it'll work as mentioned by treyh:

One Or Zero Web Alias (One Or Zero Directory) = ozh16_final

Give it a shot and post your findings please !