Gossamer Forum
(Advanced Search)
for
Home : Products : Others : MySQLMan :

Internal Server Error!!

Nov 22, 2002, 11:45 AM
Mark2
User (344 posts)
Nov 22, 2002, 11:45 AM
Post #1 of 7
Views: 4769
Shortcut
Quote Reply
Internal Server Error!!
Since I have LINKS SQL installed on my system, and I am getting an Internal Server Error, whenever you click on "Mysql" link at the top of MySQLMan (Top : "Mysql" : profiles)
Are the paths wrong? or premessions, or perl/mysql versions?????
Any idea is greatly appreciated it.


I get:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

and here is mysql.cgi header:
Code:
#
# Auto set the path. If the path is not set automatically then
# uncomment the following line and fill in the full path.
#
#
use lib '/home/pages/mydomain/cgi-bin/links/admin';
use lib '/path/to/MySQLMan';
#
# (You may need change the auto set path part of mysql.cfg as well.)

Thank you
Mark
Nov 22, 2002, 12:15 PM
Chaz
Enthusiast (819 posts)
Nov 22, 2002, 12:15 PM
Post #2 of 7
Views: 4715
Shortcut
Quote Reply
Re: [Mark2] Internal Server Error!! In reply to
Hey Mark,

What does your error log say? Are the other links working? You didn't give quite enough info for me to really help.

Regards,
Charlie
Nov 22, 2002, 12:33 PM
Mark2
User (344 posts)
Nov 22, 2002, 12:33 PM
Post #3 of 7
Views: 4709
Shortcut
Quote Reply
Re: [Chaz] Internal Server Error!! In reply to
Hi Charlie,
I got this:

Code:
Running mysql.cgi from telnet session:
======================================

Set-Cookie: MySQLMan_url=mysql.cgi; path=/
Date: Fri, 22 Nov 2002 19:57:07 GMT
Content-type: text/html

Segmentation fault




And also, I got this on the browser even though I have the templates is set to 0777
=====================================

CGI ERROR
==========================================
Error Message : fatal undef error: GT::Template (1579): Unable to create compiled template directory './templates/compiled'. Reason: Permission denied at html.pl line 64.

Script Location : mysql.cgi
Perl Version : 5.00404

- - - -
- - - -

Stack Trace
-------------------------------------------
(main::cgierr) called from (mysql.cgi) line (37)


Also, I looked at the cfg file and it has the paths,...
Code:
# FILES
# --------------------------------------------------------
# the URL to mysql.cgi.
# You can set it as "mysql.cgi" to make it relative.
script_url => "mysql.cgi",

# The URL to home/top. It is used for the link TOP on each page
# in the tool bar.
home_url => "/",

# The PATH to the template directory.
template_dir => $SCRIPT_PATH . "/templates",

# CONNECTION

Andy Idea..
Thanks
Mark
Nov 22, 2002, 12:40 PM
Chaz
Enthusiast (819 posts)
Nov 22, 2002, 12:40 PM
Post #4 of 7
Views: 4704
Shortcut
Quote Reply
Re: [Mark2] Internal Server Error!! In reply to
Try changing the permissions on the template dir to 775 or 777 and see if that helps. If not, use the full path for this line: template_dir => $SCRIPT_PATH . "/templates",. You can also try making the compiled dir yourself.

Let me know how that goes.

~Charlie
Nov 22, 2002, 1:07 PM
Mark2
User (344 posts)
Nov 22, 2002, 1:07 PM
Post #5 of 7
Views: 4709
Shortcut
Quote Reply
Re: [Chaz] Internal Server Error!! In reply to
I tried both methods and still getting the same error.
Could that be the following line:
use lib '/path/to/MySQLMan';
from this thread above... because, somehow, this line does not look right...

Thanks
Mark
Nov 22, 2002, 1:32 PM
Chaz
Enthusiast (819 posts)
Nov 22, 2002, 1:32 PM
Post #6 of 7
Views: 4705
Shortcut
Quote Reply
Re: [Mark2] Internal Server Error!! In reply to
You can safely remove use lib '/path/to/MySQLMan'; but that shouldn't be causing the problem. It's generally a problem with the path or permissions for the template dir. Did you try creating the compiled dir yourself and setting the permissions to 777? Double check your path too.

~Charlie
Nov 22, 2002, 1:51 PM
Mark2
User (344 posts)
Nov 22, 2002, 1:51 PM
Post #7 of 7
Views: 4690
Shortcut
Quote Reply
Re: [Chaz] Internal Server Error!! In reply to
Well! I tried to creat the compiled directory and set it up to 777/775/755 and still got the same error.
I truly have know idea why this is happening, I have everthing in this directory mysqlman with the following premissions:
Code:
templates File Folder 22-Nov-2002 15:19 rwx rwx rwx
html.pl 43 kb Script File 02-Jan-2002 19:46 rw- r-- r--
mysql.cfg 3 kb unknown 22-Nov-2002 14:21 rw- r-- r--
mysql.cgi 120 kb Script File 22-Nov-2002 15:25 rwx r-x r-x
README 13 kb unknown 03-Jan-2002 19:39 rw- r-- r--

Somehow, it is only few cgi scripts that do not work and give the same errors (user monitor update profile script, Top:"MySQL",Profiles, and Databases: "List" )

Thank you again
Mark