Re: [Phphelpdesk-help] Install / Configuration problem

[Joe H. <jo...@ne...>]

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