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.zipI 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.
21 Replies
12559 Views