skyfoxbob

Topic: How do you install Apache

I'm new to this (jobberbase) and never have used Apache. How do I install apache for jobberbase?

putypuruty

Re: How do you install Apache

Hi!

I assume that you have Windows and thus I recommend that you install XAMPP - this is a software suite that contains everything you need to run jobberbase: Apache, PHP, MySQL and phpmyadmin.

You can find it here: http://www.apachefriends.org/en/xampp-windows.html. I recommend that you use the .exe version (http://www.apachefriends.org/download.p … -1.7.3.exe)

Good luck!

skyfoxbob

Re: How do you install Apache

I install XAMPP, now what do I do with it? This is my first time working with Apache.

testgigs

Re: How do you install Apache

Local install=

Download JB
place files _includes, _templates, etc in htdocs
rename config_default to config
create jobberbase_db via mysql admin in xamp
import jobberbase_sql file

hope this helps.. If your after tips on production install refer to the jb wiki

www.gigajobs.com.au / Aussie IT Jobs

skyfoxbob

Re: How do you install Apache

really need some help here so I listed everything I have done so far. I have a windows based site. Its hosted by godaddy.

1. I have PHP 5.2.5 and MySql. The Apache module mod_rewrite I'm not sure about, can't find any info on this and have never used it before.

2. My hosting allow up to 25 databases.
DB_PREFIX with jb_
Replaced all occurrences of CREATE TABLE IF NOT EXISTS with CREATE TABLE IF NOT EXISTS 'jb_
Replaced all occurrences of INSERT INTO ' with INSERT INTO 'jb_
The database was imported with jb_ string prepened to all tables.

3. Renamed config_default.php to config.php and updated the following

                          define('DB_HOST', '72.167.233.37');
        define('DB_PORT', 3306);
        define('DB_USER', 'jobbaselisting');
        define('DB_PASS', '');
        define('DB_NAME', 'jobbaselisting');
        define('DB_PREFIX', 'jb_');
        define('LOCATION', 'local');
        define('ENVIRONMENT', 'dev');
    }
    // MySQL + misc settings for production environment
    else
    {
        define('DB_HOST', '72.167.233.37');
        define('DB_PORT', 3306);
        define('DB_USER', 'jobbaselisting');
        define('DB_PASS', '');
        define('DB_NAME', 'jobbaselisting');
        define('LOCATION', 'online');
        define('DB_PREFIX', 'jb_');
        define('ENVIRONMENT', 'prod');

4. Uploaded everything to the server.

5. Set write access

6. Opened config and this is what I get with <require_once'_includes/class.Db.php>
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2003): Can't connect to MySQL server on '72.167.233.37' (10061) in D:\Hosting\4537780\html\joblist\_includes\class.Db.php on line 20

Warning: mysqli::query() [function.mysqli-query]: Couldn't fetch Db in D:\Hosting\4537780\html\joblist\_includes\class.Db.php on line 72

Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch Db in D:\Hosting\4537780\html\joblist\_includes\class.Db.php on line 73

Warning: mysqli::query() [function.mysqli-query]: Couldn't fetch Db in D:\Hosting\4537780\html\joblist\_includes\class.Db.php on line 31

Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch Db in D:\Hosting\4537780\html\joblist\_includes\class.Db.php on line 32

Fatal error: Call to a member function fetch_assoc() on a non-object in D:\Hosting\4537780\html\joblist\_includes\class.JobberSettings.php on line 23

this is what I get with <require_once'_includes/class.Db.MySql.php>

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '72.167.233.37' (10061) in D:\Hosting\4537780\html\joblist\_includes\class.Db.MySql.php on line 31

Fatal error: Uncaught exception 'Exception' with message 'Cannot connect' in D:\Hosting\4537780\html\joblist\_includes\class.Db.MySql.php:42 Stack trace: #0 D:\Hosting\4537780\html\joblist\config.php(102): Db->__construct('72.167.233.37', 'jobbaselisting', '*************', 'jobbaselisting', 3306) #1 D:\Hosting\4537780\html\joblist\index.php(14): require_once('D:\Hosting\4537...') #2 {main} thrown in D:\Hosting\4537780\html\joblist\_includes\class.Db.MySql.php on line 42

I don't know anything about Apache, any ideas out there.

skyfoxbob

Re: How do you install Apache

This is the error I come up with

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '72.167.233.37' (10061) in D:\Hosting\4537780\html\joblist\_includes\class.Db.MySql.php on line 31

Fatal error: Uncaught exception 'Exception' with message 'Cannot connect' in D:\Hosting\4537780\html\joblist\_includes\class.Db.MySql.php:42 Stack trace: #0 D:\Hosting\4537780\html\joblist\config.php(102): Db->__construct('72.167.233.37', 'jobbaselisting', '******', 'jobbaselisting', 3306) #1 D:\Hosting\4537780\html\joblist\index.php(14): require_once('D:\Hosting\4537...') #2 {main} thrown in D:\Hosting\4537780\html\joblist\_includes\class.Db.MySql.php on line 42

Can anybody help with this?