Auto Gallery MySQL Installation help!

[Dan S]

I just got a new server and need to reinstall AGsql.<br /><br />I have done it before on that domain, but this time it drives me nuts.<br />No paths changed etc, everything is the same.<br /><br />But the init.cgi keeps giving me 500 errors.<br /><br />I double checked paths to perl a few times on all cgi + pl files. I set permissions also a few times. I uploaded all files again to make sure all is uploaded in ASCII. It is still giving me the damn 500.<br /><br />The error logs say<br />Premature end of script headers<br /><br />Their Tech Support says<br /><br />"Generally this indicates that there is a problem with your permissions settings. You will want to make sure all of the files you uploaded have correct permissions, point to the correct location of Perl on your server, and were uploaded in ASCII mode. Beyond that, your best bet is to contact your server administrator to get any special instructions for running CGI scripts on their servers. "<br /><br />Yeah yeah,<br />but I really double checked everything. Doesnt work. I remember having the same problem when I first installed it. But cant remember how to fix it.<br /><br />Anyone?

[WiredGuy]

Go into the scripts and paste this line of code:<br />use CGI::Carp (fatalsToBrowser);<br /><br />When you get the 500 error it will display the exact error rather than 500 internal error. It will tell you the actual script, line and reason so you can debug it much better.<br /><br />WG

[Dan S]

anywhere in the scripts?

[Dan S]

Hmm, it still only says 500 error

[WiredGuy]

Paste it where all other inclusions are (include, use, etc.). If none, then towards top of the script (after the location to perl though). If that doesn't work, then either your server doesn't have that module (it is a standard module so you should have it), or then the script has even something more basic that's flawed (ie: not uploaded in ascii or something). Try telnet/ssh into your server and simply running the script as perl init.pl and see what it gives.<br /><br />I know you already double checked the basic things, so start debugging this thing by running perl on the script and trying to trace where the problem is. It doesn't seem to be a basic problem if you've tried everything your posted.<br /><br />WG

[Dan S]

Executed in telnet it says<br />Segmentation fault (core dumped)

[eromedia]

I can tell you what is the problem. Its because the new server you're using, the security is different. Just do a chmod on the directory, instead of using 777, use 755, or vice versa...<br /><br />It will fix your problem.<br /><br />a 500 server error is not because you done something wrong.<br /><br />Good luck<br /><br />Mav

[Dan S]

I have read about different security settings before, and tried setting 755 permission on the directories.<br /><br />the structure is like<br /><br />/cgi-bin/agp/<br />/cgi-bin/agp/admin/<br />/cgi-bin/agp/data/<br />/cgi-bin/agp/templates/<br /><br />the file is /cgi-bin/agp/init.cgi<br />it is supposed to initialize the software for the first run.<br /><br /> </font><blockquote><font size="1" face="Verdana, Arial">code:</font><hr /><pre style="font-size:x-small; font-family: fixed;"> <br />eval {<br /> require 'ags.pl';<br /> require 'sql.pl';<br /> $dbh = $ags::dbh;<br /> main();<br />};</pre><hr /></blockquote><font size="2" face="Verdana, Arial">the file requires these to files which define the use of the mysql databse I believe.<br />Is it possible that the problem has something to do with the mysql database?

[SuperGuy]

Dan, try editting the scripts and putting in the *exact* path to where the files are in the includes/requires.<br /><br />ie. instead of require ../somefile.cgi<br /><br />require /home/somedir/cgi-bin/agp/somefile.cgi

[Joshua]

I had the same problem with just AGP, installing it on a new server. I just chmoded the files like eromedia said to the opposite, if it said 777 I did 755 and vise versa. Only for those getting 500 errors though. <img border="0" title="" alt="[Confused]" src="confused.gif" />