Forum Activity for @derrickhand300

derrickhand300
@derrickhand300
02/13/18 09:26:01AM
1,353 posts

How to move a production site to a staging server


Installation and Configuration

the folder you stated data/config/config.php still contains the old database details!
I have been editing the config.php file in public_html
so there is a difference?
I will let you know...
derrickhand300
@derrickhand300
02/13/18 09:20:56AM
1,353 posts

How to move a production site to a staging server


Installation and Configuration

Here is what i have in the config.php file (password removed)
<?php
$_conf['jrCore_db_host'] = 'localhost';
$_conf['jrCore_db_port'] = '3306';
$_conf['jrCore_db_name'] = 'american_rough_neckcity';
$_conf['jrCore_db_user'] = 'american_rough';
$_conf['jrCore_db_pass'] = 'xxxxxxx';
$_conf['jrCore_base_url'] = 'https://www.americandriller.com';
$_conf['jrCore_ffmpeg_binary'] = '/usr/bin/ffmpeg';

And here is the default htaccess file I am using
# Jamroom Apache .htaccess file
DirectoryIndex modules/jrCore/router.php

Options +FollowSymLinks
Options -MultiViews -Indexes

# Use ETags
<IfModule mod_headers.c>
Header unset ETag
FileETag None
# Expires for CSS, JS and Images
<FilesMatch ".(ico|jpg|jpeg|png|gif|js|css|swf)$">
Header set Expires "Thu, 15 Apr 2020 20:00:00 GMT"
</FilesMatch>
<FilesMatch ".(eot|ttf|otf|woff)">
Header set Access-Control-Allow-Origin "*"
</FilesMatch>
</IfModule>

# Compress everything we can
<IfModule mod_filter.c>
AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript text/javascript-x application/javascript
</IfModule>

# All requests through the router
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteRule ^modules/.*\.tpl$ - [F,L,NC]
RewriteRule ^skins/.*\.tpl$ - [F,L,NC]
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-l
RewriteRule ^(.*)$ modules/jrCore/router.php?_uri=$1 [NC,L]
</IfModule>

updated by @derrickhand300: 02/13/18 09:22:49AM
derrickhand300
@derrickhand300
02/13/18 09:16:43AM
1,353 posts

How to move a production site to a staging server


Installation and Configuration

(above passwords removed)
Those last 2 she speaks of are a store and a directory installed as sub folders...i have not messed with them yet- not until i get the JR part working
updated by @derrickhand300: 02/13/18 09:18:25AM
derrickhand300
@derrickhand300
02/13/18 09:14:19AM
1,353 posts

How to move a production site to a staging server


Installation and Configuration

Thanks brian...here are the actions my server took
"Hello,

I found the following sql files in the backup:

-rw-r--r-- root/root 6013356 2018-02-13 00:11 mysql/rough_ocart33.sql
-rw-r--r-- root/root 1276720 2018-02-13 00:11 mysql/rough_directory.sql
-rw-r--r-- root/root 16152757 2018-02-13 00:11 mysql/rough_neckcity.sql

I am leaving these backups in place in a newly the newly created mysql/ directory under /home/americandriller/public_html.


I created the following database for the file /home/americandriller/public_html/config.php :

User: american_rough
Database: american_rough_neckcity
Password:

Now, you just need to edit the file with these credentials and the new domain.

I found the following configuration file as well:

/home/americandriller/public_html/directory/defaults.php

I created this database for this sql data:

User: american_curtis
Database: american_rough_directory
Password:


Regarding the last sql files, which seems to be used in the following configuration files, I created the database with the details below (so you will need to update the configuration files):

./store/admin/config.php
./store/shipstation/config.php
./store/config.php
./store_2_11.bak/admin/config.php
./store_2_11.bak/shipstation/config.php
./store_2_11.bak/config.php
./store.bak/admin/config.php
./store.bak/shipstation/config.php
./store.bak/config.php


User: american__ocart3
Database: american_ocart33
Password:


The data is the sql backup files has been imported into each newly created database. Now, all that you should have to do is to edit the configuration files with the new databases' information, and then replace the .htaccess file with a default, and any other instructions as advised by the CMS support team.


Thanks,

----------
Kayla A."

Then i changed the config.php and uploaded a new default copy of htaccess...still no go
updated by @derrickhand300: 02/13/18 09:17:48AM
derrickhand300
@derrickhand300
02/13/18 06:46:46AM
1,353 posts

How to move a production site to a staging server


Installation and Configuration

Thanks-I have done all of the above here is what i have
https://www.americandriller.com/

If you add index.html to the url you can see part of a site
https://www.americandriller.com/index.html

I cant run an integrity check because I cant log in...but i have run repair.php bit changes nothing

also notice all the links on the staging site when you click them go to the production site
derrickhand300
@derrickhand300
02/12/18 11:30:33PM
1,353 posts

How to move a production site to a staging server


Installation and Configuration

Thats the version I downloaded 1 hours ago...I will download it again...does the htaccess HAVE to be in jrCore/root..or can i use the one thats in public_html?
derrickhand300
@derrickhand300
02/12/18 08:14:21PM
1,353 posts

How to move a production site to a staging server


Installation and Configuration

michael:
For the .htaccess file, use a default one from a fresh jamroom install. that has no domian names in it.

you can find a copy of it at:
/modules/jrCore/root/.htaccess

copy it to your root folder.

Sorry...Im not finding a /root/ folder in jrCore
Capture.JPG Capture.JPG - 77KB
derrickhand300
@derrickhand300
02/12/18 07:45:18PM
1,353 posts

How to move a production site to a staging server


Installation and Configuration

Dumb question...
Can I just make a compressed copy in cpanel of the site - then unzip it on the new site and drag all the files to public_html folder?
8 GB takes a day here downloading it ftp with my connection then uploading it...
I notice JR Docs say to unzip a new install of jamroom on your pc then upload it via FTP....just wonder if i can install using this much faster route?
Both cpanel accounts are on the same server...
updated by @derrickhand300: 02/12/18 07:46:58PM
derrickhand300
@derrickhand300
02/12/18 07:24:30PM
1,353 posts

How to move a production site to a staging server


Installation and Configuration

Thanks i will try again- thats pretty much what i did twice today- each time i ended up with a site that was just a 500 error
derrickhand300
@derrickhand300
02/12/18 07:19:22PM
1,353 posts

How to move a production site to a staging server


Installation and Configuration

Thanks-but what about the database having a different name?
Also the htaccess file still has the url's from the previous url...
updated by @derrickhand300: 02/12/18 07:21:18PM
  11