The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.



Post new topic Reply to topic  [ 9 posts ] 
Author Message
PostPosted: Sun Sep 04, 2011 6:42 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Sep 04, 2011 4:44 pm
Posts: 14
Hello,

Everything was running fine until I decided to change MySQL:

User Password
&
Database User Name and Password

Host told be check if the data in code matched these new passwords and wouldn't say how.

Can anyone help me on this?

Thanks in advance.

Kind regards


Top
 Profile  
 
PostPosted: Sun Sep 04, 2011 6:48 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Wed Aug 13, 2008 2:57 am
Posts: 20416
Location: Chennai, India
The username and the password for the MySQL database is stored in the file configuration.php that is located in the directory where Joomla! is installed.
Code:
   var $user = '';                     // MySQL username
   var $password = '';                  // MySQL password

Note: Make a copy of the file before modifying it.

_________________
- Ilagnayeru (MIG) Manickam
http://www.eegan.org - helping the poor and underprivileged
educate. empower. enrich.
Support the poor and underprivileged


Top
 Profile  
 
PostPosted: Sun Sep 04, 2011 7:33 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Sep 04, 2011 4:44 pm
Posts: 14
Dear Imanickam,

Thank you for your quick reply.
I have opened the configuration.php and apparently the username and passwords match.
So I don't know what can be wrong here.
It's weird that some of the command lines are duplicated. Is this OK?
Just so you know, I have changed MySQL:
User Password: myhut
&
Database User Name: myhut
Password: myhut

I have copied a pasted the it's content bellow:

<?php
$mosConfig_MetaAuthor = '1';
$mosConfig_MetaDesc = 'Joomla - the dynamic portal engine and content management system';
$mosConfig_MetaKeys = 'Joomla, joomla';
$mosConfig_MetaTitle = '1';
$mosConfig_absolute_path = '/services/webpages/util/e/k/myhut.site.aplus.net/public';
$mosConfig_admin_expired = '1';
$mosConfig_allowUserRegistration = '1';
$mosConfig_back_button = '1';
$mosConfig_cachepath = '/services/webpages/util/e/k/myhut.site.aplus.net/public/cache';
$mosConfig_cachetime = '900';
$mosConfig_caching = '0';
$mosConfig_db = 'myhut';
$mosConfig_dbprefix = 'joomla1_';
$mosConfig_debug = '0';
$mosConfig_dirperms = '';
$mosConfig_editor = 'tinymce';
$mosConfig_enable_log_items = '0';
$mosConfig_enable_log_searches = '0';
$mosConfig_enable_stats = '0';
$mosConfig_error_message = 'This site is temporarily unavailable.<br /> Please notify the System Administrator';
$mosConfig_error_reporting = '-1';
$mosConfig_favicon = 'favicon.ico';
$mosConfig_fileperms = '';
$mosConfig_fromname = 'The Home of myhut';
$mosConfig_frontend_login = '1';
$mosConfig_frontend_userparams = '1';
$mosConfig_gzip = '0';
$mosConfig_helpurl = 'http://help.joomla.org';
$mosConfig_hideAuthor = '1';
$mosConfig_hideCreateDate = '1';
$mosConfig_hideEmail = '0';
$mosConfig_hideModifyDate = '1';
$mosConfig_hidePdf = '0';
$mosConfig_hidePrint = '0';
$mosConfig_hits = '1';
#$mosConfig_host = 'localhost';
#$mosConfig_host = "sqlc40c.czone.com";
#$mosConfig_host = "sqlc40c.czone.com";
$mosConfig_host = "sqlc40c.czone.com";



$mosConfig_icons = '1';
$mosConfig_item_navigation = '1';
$mosConfig_lang = 'english';
$mosConfig_lifetime = '900';
$mosConfig_link_titles = '0';
$mosConfig_list_limit = '30';
$mosConfig_live_site = 'http://myhut.com';
$mosConfig_locale = 'en_GB';
$mosConfig_mailer = 'mail';
$mosConfig_mailfrom = 'myemail@myemail.com';
$mosConfig_ml_support = '0';
$mosConfig_multipage_toc = '1';
$mosConfig_offline = '0';
$mosConfig_offline_message = 'This site is down for maintenance.<br /> Please check back again soon.';
$mosConfig_offset = '8';
$mosConfig_offset_user = '0';
$mosConfig_pagetitles = '1';
$mosConfig_password = 'myhut2006';
$mosConfig_readmore = '1';
$mosConfig_secret = 'hkdEcU7N1wvmz4ba';
$mosConfig_sef = '0';
$mosConfig_sendmail = '/usr/sbin/sendmail';
$mosConfig_session_life_admin = '1800';
$mosConfig_session_type = '0';
$mosConfig_shownoauth = '0';
$mosConfig_sitename = 'The Home of myhut';
$mosConfig_smtpauth = '0';
#$mosConfig_smtphost = 'localhost';
#$mosConfig_smtphost = "localhost";
#$mosConfig_smtphost = "localhost";
$mosConfig_smtphost = "localhost";



$mosConfig_smtppass = '';
$mosConfig_smtpuser = '';
$mosConfig_uniquemail = '1';
$mosConfig_user = 'myhut';
$mosConfig_useractivation = '1';
$mosConfig_vote = '0';
setlocale (LC_TIME, $mosConfig_locale);
?>


Top
 Profile  
 
PostPosted: Sun Sep 04, 2011 7:36 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Sep 04, 2011 4:44 pm
Posts: 14
By the way, I did not find the exact code you mentioned:

var $user = ''; // MySQL username
var $password = ''; // MySQL password


Top
 Profile  
 
PostPosted: Sun Sep 04, 2011 8:24 pm 
Joomla! Master
Joomla! Master
Online

Joined: Mon Oct 27, 2008 9:27 pm
Posts: 13731
Location: Akershus, Norway
$mosConfig_password = 'myhut2006';

Looks like you are running joomla 1.0 where the configuration file is different from J1.5


Top
 Profile  
 
PostPosted: Mon Sep 05, 2011 6:37 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Sep 04, 2011 4:44 pm
Posts: 14
Nope, I am using Joomla! 1.5.21 Stable.
How is this possible? Why is my code different that J1.5?
Many thanks

By the way, the host solved the problem but they did not tell what was done to fix it. I have requested and explanation so that it does not remain a mystery.
kind regards


Top
 Profile  
 
PostPosted: Mon Sep 05, 2011 10:18 am 
Joomla! Master
Joomla! Master
Online

Joined: Mon Oct 27, 2008 9:27 pm
Posts: 13731
Location: Akershus, Norway
A J1.5 configuration.php does not contain any $mosConfig. That is J1.0


Top
 Profile  
 
PostPosted: Mon Sep 05, 2011 3:04 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sun Sep 04, 2011 4:44 pm
Posts: 14
Hi,
I have found out what I was doing wrong.
I was looking at the configuration.php file from the /joomla (database details) directory and not from the configuration.php file on the /private directory (server settings).


Top
 Profile  
 
PostPosted: Sun Apr 29, 2012 11:41 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Aug 17, 2009 8:45 pm
Posts: 19
Check the table prefix consistency
Had the same problem after changing hosts
Site would appear absolutely empty
Now, this is where you have to remember that after moving a joomla site, you probably have uploaded a mysql database where all jos_ prefixes were renamed to bak_
Therefore if you change
var $dbprefix = 'jos_';
to
var $dbprefix = 'bak_';
in configuration file, it will work.

But if you have at the same time jos_ and bak_ tables, not everything will work.

Therefore, if you see on your PMA that you have varying table prefixes, you should open the whole mysql dump in a text editor and find/replace all differing values to a single one,
If i referer to my earlier example, change them all to jos_ or bak_ depending on what prefix is declared in your config file.

Even better, change them all to a new value - will help protect against hacking.
You could change all bak_ AND jos_ entries to something like xxx_ or yyy_....

Hope this helps.

_________________
My occupation : le Référencement SEO
My hobby : l'actualité des mobiles et ordinateurs portables


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 



Who is online

Users browsing this forum: mudhouse, Slackervaara and 17 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group