Welcome, Guest. Please login or register.
Did you miss your activation email?
09 May 2008, 15:00

Login with username, password and session length
Home Chat Help Search Calendar Login Register
Pages: [1]
Print
Author Topic: Migrating to another DB  (Read 259 times)
0 Members and 1 Guest are viewing this topic.
nvp007
Forum Member
*

Karma: 0
Offline Offline

Posts: 3


« on: 28 Mar 2008, 08:15 »

Today i've migrated a site to another domain, and edited the config.php file. When i go to my site (see http://swatunitclan.com, i see a mysql error telling me that user swatunit_dummy is not allowed. But swatunit_dummy is now swat_dummy and i've edited this in my config file. I've already cleared the cache...

My current config file:

Code:
<?php


#CMS Made Simple Configuration File
#Please clear the cache (Site Admin->Global Settings in the admin panel)
#after making any changes to path or url related options

#-----------------
#Database Settings
#-----------------

#This is your database connection information.  Name of the server,
#username, password and a database with proper permissions should
#all be setup before CMS Made Simple is installed.
$config['dbms'] = 'mysql';
$config['db_hostname'] = 'localhost';
$config['db_username'] = 'XXXXX';
$config['db_password'] = 'XXXXX';
$config['db_name'] = 'XXXXX';

#If app needs to coexist with other tables in the same db,
#put a prefix here.  e.g. "cms_"
$config['db_prefix'] = 'cms_';

#Use persistent connections?  They're generally faster, but not all hosts
#allow them.
$config['persistent_db_conn'] = false;

#Use ADODB Lite?  This should be true in almost all cases.  Note, slight
#tweaks might have to be made to date handling in a "regular" adodb
#install before it can be used.
$config['use_adodb_lite'] = true;

#-------------
#Path Settings
#-------------

#Document root as seen from the webserver.  No slash at the end
#If page is requested with https use https as root url
#e.g. http://blah.com
$config['root_url'] = 'http://swatunitclan.com';
if(isset(
$_SERVER['HTTPS']) && $_SERVER['HTTPS']=='on')
{
$config['root_url'] = str_replace('http','https',$config['root_url']);
}

#Path to document root. This should be the directory this file is in.
#e.g. /var/www/localhost
$config['root_path'] = '/home/swat/public_html';

#Name of the admin directory
$config['admin_dir'] = 'admin';

#Where do previews get stored temporarily?  It defaults to tmp/cache.
$config['previews_path'] = '/home/swat/public_html/tmp/cache';

#Where are uploaded files put?  This defaults to uploads.
$config['uploads_path'] = '/home/swat/public_html/uploads';

#Where is the url to this uploads directory?
$config['uploads_url'] = $config['root_url'] . '/uploads';


#---------------
#Upload Settings
#---------------

#Maxium upload size (in bytes)?
$config['max_upload_size'] = 25000000;

#Permissions for uploaded files.  This only really needs changing if your
#host has a weird permissions scheme.
$config['default_upload_permission'] = '664';

#------------------
#Usability Settings
#------------------

#Allow smarty {php} tags?  These could be dangerous if you don't trust your users.
$config['use_smarty_php_tags'] = false;

#CMSMS Debug Mode?  Turn it on to get a better error when you
#see {nocache} errors.
$config['debug'] = false;

#Automatically assign alias based on page title?
$config['auto_alias_content'] = true;

#------------
#URL Settings
#------------

#Show mod_rewrite URLs in the menu? You must enable 'use_hierarchy' for this to work for modules
$config['assume_mod_rewrite'] = true;

#Extension to use if you're using mod_rewrite for pretty URLs.
$config['page_extension'] = '';

#If you don't use mod_rewrite, then would you like to use the built-in
#pretty url mechanism?  This will not work with IIS and the {metadata} tag
#should be in all of your templates before enabling.
$config['internal_pretty_urls'] = false;

#If you're using the internal pretty url mechanism or mod_rewrite, would you like to
#show urls in their hierarchy?  (ex. http://www.mysite.com/parent/parent/childpage)
$config['use_hierarchy'] = true;

#If using none of the above options, what should we be using for the query string
#variable?  (ex. http://www.mysite.com/index.php?page=somecontent)
$config['query_var'] = 'page';

#--------------
#Image Settings
#--------------

#Which program should be used for handling thumbnails in the image manager.
#See http://wiki.cmsmadesimple.org/index.php/User_Handbook/Admin_Panel/Content/Image_Manager for more
#info on what this all means
$config['image_manipulation_prog'] = 'GD';
$config['image_transform_lib_path'] = '/usr/bin/ImageMagick/';

#Default path and URL for uploaded images in the image manager
$config['image_uploads_path'] = '/home/swat/public_html/uploads/images';
$config['image_uploads_url'] = $config['root_url'] . '/uploads/images'


#------------------------
#Locale/Encoding Settings
#------------------------

#Locale to use for various default date handling functions, etc.  Leaving
#this blank will use the server's default.  This might not be good if the
#site is hosted in a different country than it's intended audience.
$config['locale'] = '';

#In almost all cases, default_encoding should be empty (which defaults to utf-8)
#and admin_encoding should be utf-8.  If you'd like this to be different, change
#both.  Keep in mind, however, that the admin interface translations are all in
#utf-8, and will be converted on the fly to match the admin_encoding.  This
#could seriously slow down the admin interfaces for users.
$config['default_encoding'] = '';
$config['admin_encoding'] = 'utf-8';

#---------------------------------------------
#Use the old stylesheet logic?  It's much slower, but it works with older
#versions of CMSMS.  You'll also need this set to true if there is a module
#that uses a stylesheet callback.  Leave it as false instead you really
#need it.
$config['old_stylesheet'] = false;

# URL of the Admin Panel section of the User Handbook
$config['wiki_url'] = 'http://wiki.cmsmadesimple.org/index.php/User_Handbook/Admin_Panel';

#Enable backwards compatibility mode?  This basically will allow some
#modules written before 1.0 was released to work.  Keep in mind that this
#will use a lot more memory and isn't guaranteed to fix the problem.
$config['backwards_compatible'] = false;

#Not used anymore... kept around, just in case
$config['disable_htmlarea_translation'] = false;
$config['use_Indite'] = true;
?>


Can somebody help? Thanx  Smiley
« Last Edit: 28 Mar 2008, 14:44 by alby » Logged
alby
Member Support Team
Support Guru
Power Poster
****

Karma: 99
Offline Offline

Posts: 2125

Location: Ferrara, Italy


My kids


« Reply #1 on: 28 Mar 2008, 14:46 »

Never post your mysql params!!!!

Can somebody help? Thanx  Smiley

Your CMSMS works well (config is ok, I see your site)
You have a error in pubb embed (other site?)

Alby
Logged

Member CMSMS Support Team
Italian Forum Moderator - Italian admin Project

Plugins: Geolocate hostip - Multiple random image - Image rotator (PLEASE test beta) - Content Pagination (TEST PLEASE)

Modules: ForumMadeSimple - Howto (FMS)

Multilingual: CMSMS MLE 1.2.4b - Doc/Howto/Tips (#9)
blast2007
Forum Member
*

Karma: 1
Offline Offline

Posts: 161

Location: Italy



« Reply #2 on: 28 Mar 2008, 17:55 »

Trying to connect to your site get:

Error: Unable to connect to MySQL and select database. MySQL reported: Access denied for user 'swatunit_dummy'@'localhost' (using password: YES).

It seems to be a mysql password error or missing permissions for that user on db.
Check permissions on db with phpmysql or similar and password.

Regards
blast
« Last Edit: 28 Mar 2008, 17:57 by blast2007 » Logged
alby
Member Support Team
Support Guru
Power Poster
****

Karma: 99
Offline Offline

Posts: 2125

Location: Ferrara, Italy


My kids


« Reply #3 on: 29 Mar 2008, 08:12 »

It seems to be a mysql password error or missing permissions for that user on db.

From html source I see an embed page into the page with: "PunBB / Error" with title.
Probably he has updated the mysql user of CMSMS site but he forgot to update the mysql user of PunBB forum!

Alby
Logged

Member CMSMS Support Team
Italian Forum Moderator - Italian admin Project

Plugins: Geolocate hostip - Multiple random image - Image rotator (PLEASE test beta) - Content Pagination (TEST PLEASE)

Modules: ForumMadeSimple - Howto (FMS)

Multilingual: CMSMS MLE 1.2.4b - Doc/Howto/Tips (#9)
Pages: [1]
Print
Jump to: