Koozali.org: home of the SME Server

oneorzero helpdesk software

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 !