Menu
▾
▴
RE: [Phphelpdesk-help] Install / Configuration problem
|
From: Chad O. <CO...@ex...> - 2001-04-05 18:26:43
|
Thanks for your help Joe, I really appreciate it. I am almost done!
I was able to get the phphelpdesk database created and I granted all
privileges granted to user "admin" w/pass "admin"
Database changed
mysql> show tables;
+-----------------------+
| Tables_in_phphelpdesk |
+-----------------------+
| category |
| department |
| events |
| parts |
| security |
| ticket |
| ticketparts |
| tmpeid |
| tmpviewtickets |
| userdepartments |
+-----------------------+
10 rows in set (0.00 sec)
Then I created user phpadmin w/pass phpadmin:
mysql> GRANT ALL PRIVILEGES ON phphelpdesk TO phpadmin
-> IDENTIFIED BY 'phpadmin' WITH GRANT OPTION;
Query OK, 0 rows affected (0.04 sec)
**user admin and user phpadmin were created the same exact way.
Have I created the tables for this database? The documentation says to do
this, It appears to me that was done so after I got phphelpdesk.mysql
installed. Is this correct?
I must be doing something wrong here because when I go the $g_base_url
(http://www.192.168.68.230/helpdesk/) index.php does not show, I have to
click on it:
Index of /helpdesk
Name Last modified Size Description
----------------------------------------------------------------------------
----
Parent Directory 04-Apr-2001 01:53 -
COPYING 03-Apr-2001 01:27 18k
INSTALL 03-Apr-2001 01:28 3k
checkuser.inc.php 03-Apr-2001 01:26 1k
config/ 04-Apr-2001 19:18 -
connect.inc.php 03-Apr-2001 01:26 1k
cookie.inc.php 03-Apr-2001 01:26 1k
images/ 03-Apr-2001 01:26 -
index.php 03-Apr-2001 02:12 2k
logout.inc.php 03-Apr-2001 01:26 1k
permissions.inc.php 03-Apr-2001 01:26 2k
phphelpdesk.mysql 03-Apr-2001 01:27 13k
rfile.inc.php 03-Apr-2001 01:26 1k
scripts/ 03-Apr-2001 01:27 -
When I click on index.php the script seems to work fine. When I try to log
in as admin w/pass admin or phpadmin w/pass phppassword, nothing happens and
I get this error:
Warning: Failed opening 'includes/checkuser.inc.php' for inclusion
(include_path='') in /usr/local/apache/htdocs/helpdesk/index.php on line 19
This is line 19: include("includes/checkuser.inc.php");
Any help is greatly appreciated!!!
Best regards,
Chad Oblak
-----Original Message-----
From: Joe Hoot [mailto:jo...@ne...]
Sent: Tuesday, April 03, 2001 7:13 PM
To: Chad Oblak; php...@li...
Subject: Re: [Phphelpdesk-help] Install / Configuration problem
First off, you need to make sure that mysql is setup correctly or more so
that it is in your path. My notes are scattered through your message...
look below.
----- Original Message -----
From: "Chad Oblak" <CO...@ex...>
To: <php...@li...>
Sent: Tuesday, April 03, 2001 3:44 PM
Subject: [Phphelpdesk-help] Install / Configuration problem
> Hello,
>
> I am running apache_1.3.19, php-4.0.4pl1, and MySQL 3-23.34 on RH6.2 This
> machine is going to be dedicated for phphelpdesk on a internal network.
>
> everything works fine accept PHPhelpdesk. I think the problem is with
> phphelpdesk.mysql, perhaps someone can point me in the right direction.
>
nope. problem so far is that you need mysql in your path. If you installed
the rpm, I think it puts mysql executable in /usr/bin/mysql. You can
manually type the full path to it if you wish. It would be:
[root@linux helpdesk]# /usr/bin/mysql < phphelpdesk.mysql
If you don't have a root password for mysql, then that will do it. If you
do, then you need to do the -u root -p thing.
> [root@linux helpdesk]# pwd
> /usr/local/apache/htdocs/helpdesk
> [root@linux helpdesk]# ls
> COPYING INSTALL checkuser.inc.php connect.inc.php images
> logout.inc.php phphelpdesk.mysql scripts
> CVS README config cookie.inc.php index.php
> permissions.inc.php rfile.inc.php
> [root@linux helpdesk]# mysql -u root -p < phphelpdesk.mysql
> bash: mysql: command not found
> [root@linux helpdesk]# ./mysql -u root -p < phphelpdesk.mysql
> bash: ./mysql: No such file or directory
>
> 1.) Should I put phphelpdesk.mysql somewhere else?
>
wherever it is doesn't make a difference. you could put it in /usr/bin and
then do cd /usr/bin and run mysql < phphelpdesk.mysql.
>
> here is what db.conf.php and general.conf.php look like:
>
> <?php //database config
>
> $db_server = "192.168.68.230"; //database server
> location
> $db_type = "mysql"; //mysql, pgsql, oracle,
> etc..
> $db_db = "phphelpdesk.mysql"; //database to use
$db_db should be whatever you use as your database. I would suggest leaving
the default database name as phphelpdesk. This is created when you run
mysql < phphelpdesk.mysql.
> $db_username = "admin"; //username for $db_db
> $db_password = "admin"; //password for $db_db
>
>
>
> <?php //general configuration
>
> $version = ".04.4"; //Version Number
>
> $g_title = "PHPHelpdesk"; //Title of your
> helpdesk
> $g_helpdesk_email = "em...@ad..."; //Email of your helpdesk
> $g_mailservername = "mail.yourcompanys.smtpserver.com"; //SMTP Mail server
> $g_cookietimeout = "1200";
> //Timeout for cookies
> $g_refreshtime = "600"; //Refresh time for
> viewall
>
> // If you are using http://someaddress.co/phphelpdesk, then you must set
the
> // base url to "http://someaddress.com/phphelpdesk/" Notice the '/' at
the
> end
> // you must put that in there. If you are using a virtual host such as
> // http://phphelpdesk.somecompany.com, then you can just leave it empty
with
> // the quotes touching "";
> $g_base_url = "http://192.168.68.230/helpdesk";
> //base url location
>
> Thanks in advance.
>
> Best Regards,
>
> Chad Oblak
Otherwise, it should work.
send an email to php...@li... if you are still
having trouble.
Joe
|
