moved site, database weirdness and fairy magic [SOLVED]

Joomla version 1.5 is end-of-life and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
mrazy
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Wed Feb 17, 2010 3:19 pm

moved site, database weirdness and fairy magic [SOLVED]

Post by mrazy » Wed Feb 17, 2010 3:37 pm

I created a temporary site in a subfolder on my site: mysite.com/newInsuranceSite
It was truly beautiful, so much so the client said, “It is good, make it live!”

I installed Joomla on the client's new site: newInsuranceSite.com. I copied all the files and folders from the temp site to the live site. I emptied the database and imported the information from the temp's site database.

And the site works! It's still lovely. But apparently it's running on magic. (Obviously web fairy magic). The configuration.php was copied from the old site and has the old database referenced. And it works. I’m assuming the new site works with links to the old database because both sites are hosted by the same company (if this isn’t the answer, I refer you back to the fairy theory).

However, when I change the config file to match the new database, I get the error:
Database Error: Unable to connect to the database: Could not connect to MySQL.

I know the new site has the right info in the database, I’ve checked. I’ve double checked spelling.
I keep thinking, if it ain’t broke, don’t fix it. But, it just feels like bad practice.

Old (magically working) database info:

Code: Select all

var $dbtype = 'mysql';
	var $host = 'localhost';
	var $user = 'secretar_jo151';
	var $db = 'secretar_jo151';
	var $dbprefix = 'jos_';
New (oddly not working) database info:

Code: Select all

var $dbtype = 'mysql';
	var $host = 'localhost';
	var $user = ‘howardc_jo151';
	var $db = ‘howardc_jo151';
	var $dbprefix = 'jos_';
Unfortunately my php/mysql knowledge is nil, so I’m not able to futz around it to try to figure it out.
Thoughts? Ideas?
Thank you bunches in advance!
Last edited by mrazy on Thu Feb 18, 2010 5:05 pm, edited 1 time in total.

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 28193
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: moved site, database weirdness and fairy magic

Post by imanickam » Thu Feb 18, 2010 2:26 am

Make sure that the user name howardc_jo151 has been granted all the privileges to the database howardc_jo151.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
Former Joomla! Translations Coordination Team Lead
Eegan - Support the poor and underprivileged

mrazy
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Wed Feb 17, 2010 3:19 pm

Re: moved site, database weirdness and fairy magic

Post by mrazy » Thu Feb 18, 2010 3:00 am

imanickam, i am truly appreciative of your response. and in reply, i offer you a really dumb question. how do i grant database privileges?

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 28193
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: moved site, database weirdness and fairy magic

Post by imanickam » Thu Feb 18, 2010 3:22 am

It all depends on the service provider and how the database is setup. I suggest referring to the service provider's documentation about this.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
Former Joomla! Translations Coordination Team Lead
Eegan - Support the poor and underprivileged

cvoogt
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 211
Joined: Wed Sep 27, 2006 1:10 am
Location: Sterling, VA, USA
Contact:

Re: moved site, database weirdness and fairy magic

Post by cvoogt » Thu Feb 18, 2010 4:33 am

with cPanel;
go to MySQL Databases.
Delete the user you're having problems with. Create the user again, using the same username and password you've been trying. After that's done and you'tre back at the database management page, add the user to your database in the section "Add User To Database". On the next screen, tick "All Privileges" and click Make Changes.

mrazy
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Wed Feb 17, 2010 3:19 pm

Re: moved site, database weirdness and fairy magic

Post by mrazy » Thu Feb 18, 2010 3:55 pm

cvoogt,
thank you. with your detailed instructions i was able to delete the user, create a new user with the same settings and give all permissions.
unfortunately it doesn't seemed to have changed anything. the site still works with the link to the old database, and i am continuing to get the same error if i use the current database information.
at least i learned something new today. thanks for that!
any other ideas?

cvoogt
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 211
Joined: Wed Sep 27, 2006 1:10 am
Location: Sterling, VA, USA
Contact:

Re: moved site, database weirdness and fairy magic

Post by cvoogt » Thu Feb 18, 2010 4:19 pm

are you sure about using localhost and not, say, mysql45.yourhost.com (for example? Sometimes hosts require use of a specific host name, rather than localhost. You may need to ask your host about this, or look for this when editing your database setup in your hosting control panel.

mrazy
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Wed Feb 17, 2010 3:19 pm

Re: moved site, database weirdness and fairy magic

Post by mrazy » Thu Feb 18, 2010 5:04 pm

i have conquered! with your help of course.
even though i had deleted the user, and added the user again. somewhere along the line the user disappeared *poof* (i refuse to admit user error here)
i looked again and saw that the database didn't have a user attached to it. added the user, changed the config file, thanked the magic fairies for all their help, and voila! a working site, with the correct database.
thank you cvoogt and imanickam for pointing me in the right direction, i couldn't have done it without you.

cvoogt
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 211
Joined: Wed Sep 27, 2006 1:10 am
Location: Sterling, VA, USA
Contact:

Re: moved site, database weirdness and fairy magic [SOLVED]

Post by cvoogt » Thu Feb 18, 2010 6:59 pm

no problem, glad I could help.

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 28193
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: moved site, database weirdness and fairy magic [SOLVED]

Post by imanickam » Fri Feb 19, 2010 2:07 am

You are welcome... Glad to be of help... Now, you are the expert in database connectivity.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
Former Joomla! Translations Coordination Team Lead
Eegan - Support the poor and underprivileged


Locked

Return to “Installation 1.5”