Database name and DB username change.

[paschal-lamb]

I use a hosting service and have been forced to change the database name and DB username because of an upgrade from mysql v3.23 to v5. What must I do to my joomla 1.5 install in order to be able to access the db with the new DB name and username? The password has not changed.
Thanks.

[CodeLab]

I Think Just Changing Appropriate Details In Configuration.php Is All You Need To Do.

[celli]

I am having trouble understanding what to change in my 'configuration.php' file
I hope someone can help with this :

these seem to be the key items that need changing:

Code: Select all

        var $log_path = '/home/users/web/b1228/sl.jdfadver/public_html/4healing/logs';

	var $tmp_path = '/home/users/web/b1228/sl.jdfadver/public_html/4healing/tmp';

	var $ftp_root = '/public_html/4healing';

	var $host = 'jdfadver.startlogicmysql.com';

	var $smtphost = 'jdfadver.startlogicmysql.com';

if the database lives here :
http://www.micelistudios.com/4healing

what do I set the above values to be ? I seem to have tried all options but I still get this message:
Database Error: Unable to connect to the database:Could not connect to MySQL

[CodeLab]

Make Sure, Values For Database Information Are Correct In Your Configuration.php File

var $dbtype = 'mysql';
var $host = 'localhost'; \\ Mostly You Can Leave It As Localhost
var $user = 'YOUR DB USER'
var $db = 'YOUR DB NAME'
var $dbprefix ='jos_'
var $password = 'YOUR DB PASSWORD'

[celli]

thanks so much for the reply. I have 1 question :

What about the path to the database ?
My database lives on a different server, do I need the absolute path to that database

...I just don't know where I need to enter that in the 'configuration.php' file.

[CodeLab]

Ok Database path Goes Here

var $host = 'DB HOST/PATH'

You Cannot Put Localhost Here,
You Can Find In Your Control Panel, What To Use As DB Host
Mostly It Will Be An IP Address

Or Ask From Your Hosting Service About Database Access Host...

[celli]

thanks. can you put in a sample of what that might look like ?
is the path the absolute path like : www.somedomain.com/directory1/subdirectory

var $host = 'DB HOST/PATH'

[CodeLab]

Database Server Cannot Be Something Like
http://www.somesite.com/somedir

It Is The Server, Not The Directory
It Will Be Some IP Address Like
213.167.25.213
Or It Can Be Server Name.

You Can Find It In Your Control Panel Or Ask From Your Hosting Service...

[celli]

i see. thank you so much for your replies...this helps a great deal.
One more small question.

The PATH can be something like this...right ?
/www.somesite.com/somedir

[CodeLab]

If You Are Talking About Configuration.php Parameters Like
var $log_path
var $tmp_path
And So On, Then These Have Path Like
'/home/users/web/b1228/sl.jdfadver/public_html/4healing/tmp' ......
I Dont Think
www.somesite.com/somedir
Kind Of Paths Will Work For
var $log_path And var $tmp_path


And Yeah I Would Like To Know If You managed To Bring Your Site Up In Working

[celli]

thanks again. your going to kill me with all these questions, but I have one more.
this : "/home/users/web/b1228/sl...'
is it always home ? I notice every joomla config file uses this "home" and "users" and "web" what do these stand for ?
and the "b1228" and "si" I am not sure if this is something I should include either ?

thank you so much, it is getting clearer!

[CodeLab]

Its Path Of Your Sites Directory On Your Server
I Think It Always Starts With /home

You Can Actually Compare This To Something Like
C:\Docs\Something\Something\Folder\
As A Path To Some Directory On Your Local Computer

Genreally Its Like This
/home/<YOUR USERNAME>/public_html

But Depends On Your Server...

Hope This Helps

[LukeDouglas]

I have attached a document I created and use to secure my clients Joomla installations. Feel free to distribute to your friends and associates if you feel it is a good guide.