By: Anonymous: Jason () Feb 08 2011 13:30 pm (Read 2453 times)
Could someone point me in a direction where I could find information on the process of restoring from a gl fusion backup.... I'm sure it's here but I'm having a hard time finding it... much appreciated.
I think that I made a little head way on this. Unfortunately site isn't back up but I feel a little closer.
One thing that really confused me was that my backup was a complete backup of everything on the server so there was a lot more there then just my glFusion content and information. So with that sorted out ... I was able to pull and seperate the public and private files needed. Uploaded those onto the new server. Next I found the sql backup in private/backups and used phpmyadmin to import those into the new database.... changed my db-config and site config files to the correct paths. At this point I was able to get fusionrescue working and logged in so I corrected the paths there and saved.
I'm still at the " There has been an error in building this page. Please try again later. " point but I feel like it's all a little closer to being solved.
All the old files look good.. ( which is a 1.1.8 version )
and the database populated the way that I thought it would...
if anyone can think of anything I might of missed I'd sure appreciate it
It sounds like you've followed the directions in the Moving glFusion to a new site / URL which is basically the steps you follow to backup / restore a site to a new server or location. One step that folks seem to always miss is to make sure you:
Delete the private/data/layout_cache/$$$config$$$.cache file from your new site install.
This file contains a cached copy of the old config settings, so you want to make sure it is deleted so everything is re-read from the database after running fusionrescue.
If you are still having problems, try enabling root debug in the siteconfig.php file:
PHP Formatted Code
// | Root debug - Display detailed error messages. |
// | |
// | NOTE: This option should not be enabled on production sites since it |
// | will display configuration options and other details that could |
// | expose confidential data such as database logins, etc. |
$_SYSTEM['rootdebug'] = false;
Set this value to true and it will give more detailed error messages. One thing to note is that sometimes the system will crash before all the style info has been sent, so you end up with a black screen. Hit Ctrl-A in your browser and it will highlight any text that might be hidden (because both foreground and background are set to black).
Working on this again ... I did delete the $$$cache$$$ file... and was still getting the same trouble building page error... so I turned on the root debug and this is what it was showing:
PHP Formatted Code
An error has occurred:
This is being displayed as "Root Debugging" is enabled in your glFusion siteconfig.php.
If this is a production website you should disable this option once you have resolved any issues you are troubleshooting.
2 - mysql_connect() [function.mysql-connect]: Access denied for user 'xxxx'@'localhost' (using password: YES) @ /xxxx/xxxx/xxxx/system/databases/mysql.class.php line 125
Not sure if this helps ... I took a look at that line and could not make much sense of it other then the error is coming from a login and pass not being good ... any ideas are appreciated and I will continue to look here.
That error is pretty specific. What it means is that the database username / password you have in your private/db-config.php file is not correct for the database server.
Help me understand what you are doing. For example, are you moving the site to a new host or a new server? If you are, when you created the database for glFusion (the one you restored the backup to), did you setup the same username / password for it? If not, you'll need to edit private/db-config.php and put the proper credentials there.
I'm trying to restore from an old backup. Which it's a little more then just a move, it's sort of a restore from a full backup that I had taken back during version 1.1.8. So this all started with extracting the Private and Public_html files and placing them followed by importing the sql dump in private/backup. Then deleted the $$$cache$$$ file ... and next I changed the site config and the db_config files to reflect the new server information. Also went in with fusionrescue.php and corrected all the paths. That is pretty much where I'm at right now.
Can you double check that you have the new username / password correct in the db-config.php file. Double check for typos.
Also, double check the $_CONF['path'] setting in public_html/siteconfig.php. Make sure it points to the directory that contains the db-config.php file. I guess it could be possible that you are pointing to a different db-config.php since you are moving things. I doubt it, but no harm double checking.
Based on the error message you showed earlier, it is pretty clear that the username / password is not correct.
That error sounds like the database restore did not completely restore everything. The plugins table is a standard glFusion table that has existed in all versions of glFusion. So, I'm guessing the restore didn't actually restore that table, and possible others too....
One item I notice, normally we place a prefix of gl_ before each table name. In your case, there is no prefix based on the error message. The prefix is set in db-config.php:
PHP Formatted Code
$_DB_table_prefix = 'gl_';
Did you old site have a prefix? If so, you'll need to make sure to use the same prefix.
just took a look at things through PHPmyadmin and in the table for bad_behavior2 all the request_uri 's are of the old values from the previous server... might be the cause of this...
No, Bad Behavior logs the URI that is rejected, so my guess is that you restored that table so it has all the old URIs that were rejected. It doesn't have anything to do with the configuration. See my previous post, I think it is the table prefix that is the problem.
When you look at the database with phpMyAdmin, what is the name of the plugins table, does it look like gl_plugins?
Would it be possible for me to get access to phpMyAdmin on your site? I think we can get to the bottom of this a little faster if I can take a look at the database directly. You can email me at email@example.com if this is a possibility.