Koozali.org: home of the SME Server
Legacy Forums => Experienced User Forum => Topic started by: ztasevski 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
-
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
-
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
-
Zoran,
Stick with oneorzero, probably the best.
hth=hope this helps
stunt
-
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
-
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?
-
-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
-
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,
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,
-
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.
-
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?
-
rather than using phpmyadmin, try using, as root from the command line
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:
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:
chown -R /home/e-smith/files/ibays/ibayname ibayowner ibaygroup
chmod -2770 /home/e-smith/files/ibays/ibayname
-
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
-
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
-
rather than using phpmyadmin, try using, as root from the command line 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:
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:
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!
-
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.
-
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.
-
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
-
Mark
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
-
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
-
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
-
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 !