Forums

Cannot access live site after transfering from Xampp

Permalink
I am a novice and have been working on my site for a long time and am now ready to make it live. I created a new empty database and imported the database from my test site. As I am keeping my original site running atm, I created a sub folder and transferred my test site to there. My problem is I am getting a database error (image attached) saying access denied I have modified the database.php file with the usermane and password I used when I created the database on the live site, code below. The cache folder has been emptied. I have been trying to get the site running for a while and don't know what to do to get it right. I would really appreciate it if someone could check out why I cannot get the site running.

Many thanks
Phil 

<?php
return array(
    'default-connection' => 'concrete',
    'connections' => array(
        'concrete' => array(
            'driver' => 'c5_pdo_mysql',
            'server' => 'localhost',
            'database' => 'tambopcdb',
            'username' => 'DBname',
           'password' => 'password',
            'charset' => 'utf8'
        )
    )
);

1 Attachment

tambopc
 
mesuva replied on at Permalink Reply
mesuva
When you transfer and set up a database to a new host there are three steps you generally need to do:

- create a new blank database and import the data dump
- create a new database user
- give that new user permissions to perform operations on the newly created database.

It's that last step that is often missed. If you are using cPanel hosting, there's a spot where you can pick both the database and the user and assign permissions, it's under a heading "Add User to Database" I believe.
tambopc replied on at Permalink Reply
tambopc
Hi mesuva
I created the user and ticked the 'all privileges' box so all permissions are there. I don't know what else to do.


Phil
thefrys01@bigpond.com
CAUTION: The information contained in this e-mail is of a confidential nature and its sole use is for communication purposes between the sender and addressee. If you have received this e-mail in error, please notify us at the above email address All emails are certified virus free by AVG Internet Security

-----Original Message-----
From: concrete5 Community [mailto:discussions@concretecms.com]
Sent: Monday, 23 January 2017 9:40 PM
To: thefrys01@bigpond.com
Subject: Cannot access live site after transfering from Xampp : Installation Help
tambopc replied on at Permalink Reply
tambopc
I have checked and rechecked the database settings and I cannot see anything wrong. I am hoping there is somebody in the community that would be willing to have a look through cpanel to fix the issue.

Phil
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Hi tambopc
Send me a Private Message with the details and I will take a look for you..
tambopc replied on at Permalink Reply
tambopc
Thanks Weyboat
I have never sent a private message before, Can you explain please.
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Click on my Avatar image and click View Profile, then click Send Message..
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
I have replied to your message..
ConcreteOwl replied on at Permalink Best Answer Reply
ConcreteOwl
Okay Phil
A few things wrong here..
Your database name and username were wrong,
They should start with tambopc_ followed by the name..
So If your username was bloggs it would become tambopc_bloggs.
Same for your database name, if your database name was mydatabase, it would become tambopc_mydatabase.
I have edited the database php file with the correct info, BUT the main problem is that the database has been created using all lowercase table names.
This will need to be edited to case sensitive table names.
I will download the files and the database onto my WAMP server and make the modifications..
I will contact you again when I have finished.
Regards
Weyboat
tambopc replied on at Permalink Reply
tambopc
Thank you Weyboat
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
I will need the login details for the website.
Can you send them by Private Message..
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Don't worry, I have managed to login now.
tambopc replied on at Permalink Reply
tambopc
great
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Take a look here.
http://www.c57.tambopc.org.au/
tambopc replied on at Permalink Reply
tambopc
That's looking great. Is that the address I need to use all the time? Can I move the folder structure into the root of my site when I want to go live so I just usehttp://tambopc.org.au ?
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Yes your assumptions are correct, when you are happy with your editing you can delete your existing site and move everything from the c57 folder into the root.
At that point you will need to edit the new htaccess file I added and change this line
RewriteBase /C57/

To this
RewriteBase /
tambopc replied on at Permalink Reply
tambopc
Weyboat
I am so very thankful for your help in sorting out my issues and getting the website working live. It is people like you in the Concrete5 Community that makes using Concrete5 the best CMS to develop with.
Once again THANK YOU.
Phil