From: alister a. <ali...@ut...> - 2001-11-05 22:24:55
|
Hi, Are you sure PHP is compiled with MySQL support? Read the error message - it's not telling you about an Apache problem, it's telling you about a connectivity problem between connect.inc.php and MySQL. On Debian, I ran: apt-get install php-mysql and restarted services - this worked for me. Alister At 03:39 AM 11/6/2001, Mitchell K. Smith wrote: >Greetings. I need some help getting the helpdesk setup. > >In the INSTALL file there were no instructions for setting up the Apache >directives for the helpdesk. >Everything else seemed to go okay including setting up mysql. > >I modified my httpd.conf file like so: > ><VirtualHost 172.31.1.32> > >DocumentRoot /websites/helpdesk >ServerName helpdesk >ServerAdmin mk...@pa... > ><Directory /websites/helpdesk> >AllowOverride None >order allow,deny >allow from all ></Directory> > >ErrorLog /websites/helpdesk/logs/errors.log >CustomLog /websites/helpdesk/logs/access.log combined > ></VirtualHost> > >When I browse to http://helpdesk I get the following error: > >Fatal error: Call to undefined function: mysql_connect() in >/websites/helpdesk/includes/connect.inc.php on line 10 > >My general.conf.php looks like this: > ><snip> > >/* > If you are using http://someaddress.com/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 = ""; //base url location > >// you HAVE to set your domain name here, with no HTTP: >// or / at the end or anything... >$g_domain = "helpdesk"; > >// this is the path from the last part of the $g_base_url >// parameter. If there is no path, set this to "/"; NOTICE >// THE BEGINNING AND ENDING /'s!! >$g_base_path = "/"; > ><snip> > >Any help would be greatly appreciated. > > >Mitchell K. Smith >Service and Information Systems Manager >ePlus Technology of PA >130 Futura Drive >Pottstown, PA 19464 >610-495-7800 ext. 264 >mk...@pa... > > > >_______________________________________________ >Phphelpdesk-help mailing list >Php...@li... >https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help -- Alister Air Ph 9514 1277 IT Manager Fx 9514 1656 Faculty of Science, University of Technology Sydney "The time of your life is the one commodity that you can sell but never buy back." -- Bob Black |
From: Matt G. <ma...@ma...> - 2001-11-06 00:01:59
|
<html> Mitchell,<br> Your problem is not virtual servers. It's PHP. Here's a dialogue that happened earlier.<br> <br> Matt<br> -----------------------<br> Hi Scott,<br> As I just emailed to another person, PHP is not installed with mySQL support on your server. I use Debian, and for me I could use apt-get install php-mysql to install PHP with mySQL support. It's possible that there's a rpm around that will do the same thing, but as I'd rather not use Red Hat I can't say for sure. If not, then you're going to have to compile PHP4 from source with mySQL support. This is not as scary as it sounds - the source documentation will tell you what you need to do.<br> If the writer(s) of phphelpdesk are around, is it worth putting something like this in the/a FAQ? Perhaps it's just me, but I've noticed two emails today about the same issue. I don't read this list too closely, but I imagine there's a lot more of this going around.<br> And finally, I reckon phphelpdesk is great, and I'm using it in my area, with 250 or so users. I've even got a wish list, but I reckon I'll save that for later :-)<br> Alister<br> At 03:24 PM 10/10/2001, scott bakalor wrote: <br> ok I installed the php helpdesk and got errors<br> installed to <a href="http://www.hijinksdesign.com/support/" eudora="autourl"><font color="#0000FF"><u>http://www.hijinksdesign.com/support/</a><br> </u></font>Fatal error: Call to undefined function: mysql_connect() in /home/DESIGN-WEB/www/support/includes/connect.inc.php on line 10<br> <br> any help is appreciated I used the red hat rpm to install php-4.0.4pl1<br> -----------------------------------------------------------------------------------------------------------------------<br> <br> To get this working on Red Hat 7.1 I instaled the php-4.0.4pl1 rpm then installed the MySQL-shared-3.23.42 rpm as this has a file that will be needed later. Then the last step is to install the php-mysql-4.0.4pl1 rpm.<br> All these can be found at <a href="http://www.rpmfind.net/" eudora="autourl"><font color="#0000FF"><u>www.rpmfind.net</a><br> </u></font>installing these will allow php helpdesk to run standard no modifications.<br> - Scott<br> --------------------------------------------------------------------------------------------------------<br> -----------------------<br> <br> At 11:39 AM 11/5/2001 -0500, you wrote:<br> <blockquote type=cite class=cite cite>Greetings. I need some help getting the helpdesk setup.<br> <br> In the INSTALL file there were no instructions for setting up the Apache<br> directives for the helpdesk.<br> Everything else seemed to go okay including setting up mysql.<br> <br> I modified my httpd.conf file like so:<br> <br> <VirtualHost 172.31.1.32><br> <br> DocumentRoot /websites/helpdesk<br> ServerName helpdesk<br> ServerAdmin mk...@pa...<br> <br> <Directory /websites/helpdesk><br> AllowOverride None<br> order allow,deny<br> allow from all<br> </Directory><br> <br> ErrorLog /websites/helpdesk/logs/errors.log<br> CustomLog /websites/helpdesk/logs/access.log combined<br> <br> </VirtualHost><br> <br> When I browse to <a href="http://helpdesk/" eudora="autourl">http://helpdesk</a> I get the following error:<br> <br> Fatal error: Call to undefined function: mysql_connect() in<br> /websites/helpdesk/includes/connect.inc.php on line 10<br> <br> My general.conf.php looks like this:<br> <br> <snip><br> <br> /*<br> If you are using <a href="http://someaddress.com/phphelpdesk" eudora="autourl">http://someaddress.com/phphelpdesk</a>, then you must set the<br> base url to "<a href="http://someaddress.com/phphelpdesk/" eudora="autourl">http://someaddress.com/phphelpdesk/</a>" Notice the '/' at the<br> end<br> you must put that in there. If you are using a virtual host such as<br> <a href="http://phphelpdesk.somecompany.com/" eudora="autourl">http://phphelpdesk.somecompany.com</a>, then you can just leave it empty with<br> the quotes touching "";<br> */<br> $g_base_url = ""; //base url location<br> <br> // you HAVE to set your domain name here, with no HTTP:<br> // or / at the end or anything...<br> $g_domain = "helpdesk";<br> <br> // this is the path from the last part of the $g_base_url<br> // parameter. If there is no path, set this to "/"; NOTICE<br> // THE BEGINNING AND ENDING /'s!!<br> $g_base_path = "/";<br> <br> <snip><br> <br> Any help would be greatly appreciated.<br> <br> <br> Mitchell K. Smith<br> Service and Information Systems Manager<br> ePlus Technology of PA<br> 130 Futura Drive<br> Pottstown, PA 19464<br> 610-495-7800 ext. 264<br> mk...@pa...<br> <br> <br> <br> _______________________________________________<br> Phphelpdesk-help mailing list<br> Php...@li...<br> https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help</blockquote></html> |