jobberBase Community

solutionz

Member

Registered: 2012-03-04

Posts: 12

Dreaded 500- Internal Server Error -- :( HELP!!!!

Followed instructions exactly. when i visit the landing page which should be getajobinnyc.com/jb i get the 500 error.

Some background on my server:
========================================================
server 2008 r2
iis7
php 5.3.6
MYSQL 5.2.37 (MySQL workbench, not using phpmyadmin)
CGI enabled + URL rewrite = see screenshot of iis, http://getajobinnyc.com/cgirewrite.png
========================================================

i have a dynamic ip that is managed by afraid-dns (eventhough my ip has never changed in over 3 years)
I created a new db user that is allowed through my host - see screenshot, http://getajobinnyc.com/mysql.png
i created new connection with host and tested with new user = success = http://getajobinnyc.com/mysql2.png

ok so db is 100%
routing is 100%
file permissions is 100% (no i did not right click and unchech read only only, i set permissions specifically for iis users to have write access on all necessary folders and sub folders.)

Time to configure the environment ... ... . ..

Dump of config.envs.php

<?php
/**
* Define environments
*
*/

// local (http://localhost/jobberbase/public)
$__instances['local'] = array(
    // should be a unique part of the url (or the entire url if you wish)
    'prefix' => 'localhost',
    // mysql credentials
    'db_host' => 'localhost',
    'db_port' => 3306,
    'db_user' => 'websql',
    'db_password' => 'canttellyouthat',
    'db_name' => 'jobberbase',
    'db_prefix' => '',
    // your site's full url
    'app_url' => 'http://getajobinnyc.com/jb/',
    // error reporting
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'On',
    // environment setting 1 (use 'local' for localhost/testing OR 'online' for live, production environment)
    'location' => 'local',
    // environment setting 2 (use 'dev' together with 'local' in the previous setting OR 'prod' with 'online')
    'environment' => 'dev',
    //'apache_mod_rewrite', 'iis_url_rewrite' -microsoft URL Rewrite module, 'iis_isapi_rewrite'
    'rewrite_mode' => 'iis_url_rewrite'
);

// live (http://www.yourjobberbasedomain.com)
$__instances['live'] = array(
    'prefix' => 'getajobinnyc.com/jb/',
    'db_host' => 'c-71-56-212-122.hsd1.co.comcast.net',
    'db_port' => 3306,
    'db_user' => 'websql',
    'db_password' => 'canttellyouthat',
    'db_name' => 'jobberbase',
    'db_prefix' => '',
    'app_url' => 'http://getajobinnyc.com/jb/',
    'ini_error_reporting' => E_ALL,
    'ini_display_errors' => 'Off',
    'location' => 'online',
    'environment' => 'prod',
    'rewrite_mode' => 'iis_url_rewrite'
);

// setup current instance
foreach ($__instances as $__instance)
{
    // http requests
    if (isset($_SERVER['HTTP_HOST']))
    {
        $_compare_to = $_SERVER['HTTP_HOST'];
    }

    if (strstr($_compare_to, $__instance['prefix']))
    {
        define('DB_HOST', $__instance['db_host']);
        define('DB_PORT', $__instance['db_port']);
        define('DB_USER', $__instance['db_user']);
        define('DB_PASS', $__instance['db_password']);
        define('DB_NAME', $__instance['db_name']);
        define('DB_PREFIX', $__instance['db_prefix']);

        // values kind of redundant, they indicate wether this is a live/production or dev/testing environment
        define('LOCATION', $__instance['location']);
        define('ENVIRONMENT', $__instance['environment']);
       
        // base url of the app
        define('APP_URL', $__instance['app_url']);
        define('REWRITE_MODE', $__instance['rewrite_mode']);
        // error reporting
        ini_set('error_reporting', $__instance['ini_error_reporting']);
        ini_set('display_errors', $__instance['ini_display_errors']);
       
        break;
    }
}
?>

================================================================

looks good to me, u can see in the MYSQL screenshot i have 2 conections running one for  local and one for outside connections.

im not sure what the problem is?

================================================================

heres my htaccess dump:

#AddType x-mapp-php5 .php
#AddHandler x-mapp-php5 .php

RewriteEngine on

Options +FollowSymlinks

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . index.php [L]

ErrorDocument 404 /page-unavailable/

<files ~ "\.tpl$">
order deny,allow
allow from none
deny from all
</files>

---------------------------------------------------------------------------------------------------------------------

So ofcourse i start reading the forums and what i gather is its an .htaccess issue, so i followed all the earlier posts, like:

1. commenting Options +FollowSymlinks
2. commenting and uncommenting first 2 lines "Add"
3. adding rewrite /base

----------------------------------------------------------------------------------------------------------------------

Im pooped, any helped is appreciated . . .. ..

putypuruty

Administrator

From: Oradea, Romania

Registered: 2008-08-20

Posts: 1,042

Re: Dreaded 500- Internal Server Error -- :( HELP!!!!

Hi!

Please change the prefix in the $instances['live'] part to getajobinnyc.com and see if it works.

solutionz

Member

Registered: 2012-03-04

Posts: 12

Re: Dreaded 500- Internal Server Error -- :( HELP!!!!

Ok made the change and still wouldnt load, so i went to page directly which is http://getajobinnyc.com/jb/index.php and i get

Fatal error: Smarty error: unable to write to $compile_dir 'C:\inetpub\wwwroot\GetaJobinNYC\jb\_templates\default\_cache'. Be sure $compile_dir is writable by the web server user. in C:\inetpub\wwwroot\GetaJobinNYC\jb\_includes\smarty\libs\Smarty.class.php on line 1093

so it seems my permissions on iis is not correct. i dont understand because i set the iis_iusr account to full control = http://getajobinnyc.com/perm.png

however i still get error any ideas?

solutionz

Member

Registered: 2012-03-04

Posts: 12

Re: Dreaded 500- Internal Server Error -- :( HELP!!!!

Ok so i fixed permissions, and am able to access http://getajobinnyc.com/jb/index.php but it doesnt look right, theres no formatting. can someone tell me why it looks like this

solutionz

Member

Registered: 2012-03-04

Posts: 12

Re: Dreaded 500- Internal Server Error -- :( HELP!!!!

i also notice every single link on page http://getajobinnyc.com/jb/index.php points to an url that doesnt exist so i get a 404 error.

For example the first link on top is "site widget" and it points to http://getajobinnyc.com/jbwidgets which doesnt exist. im lost now

also i still get error 500 if i go to http://getajobinnyc.com/jb i must go to http://getajobinnyc.com/jb/index.php to see anything (then the formatting is off)

any help is appreciated!

solutionz

Member

Registered: 2012-03-04

Posts: 12

Re: Dreaded 500- Internal Server Error -- :( HELP!!!!

ok made some progress, i deleted

<defaultDocument>
            <files>
                <add value="index.php" />
            </files>
</defaultDocument>

from the web.config in root and admin and now i can land on page by going to http://getajobinnyc.com/jb

however formatting still isnt there and links point to directories that stil ldont exist is this a rewrite issue?

putypuruty

Administrator

From: Oradea, Romania

Registered: 2008-08-20

Posts: 1,042

Re: Dreaded 500- Internal Server Error -- :( HELP!!!!

Hi!

The fact that the formatting is wrong is most likely caused by the fact that the app_url in your $__instances['live'] is wrong. Make sure that it's set to http://getajobinnyc.com/jb/ (notice the ending slash).

Hope it helps!

solutionz

Member

Registered: 2012-03-04

Posts: 12

Re: Dreaded 500- Internal Server Error -- :( HELP!!!!

no man, it was already set to that. what else you got?

solutionz

Member

Registered: 2012-03-04

Posts: 12

Re: Dreaded 500- Internal Server Error -- :( HELP!!!!

o shit, looks like i replaced the config when i tried to reinstall and the slash was not there. All is working now TYVM for your time, word to big burd!