Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Moving to new server


trimorphous

Recommended Posts

Hi All,

 

I have had oscommerce running perfectly on a test server for some time and the site is now ready to be launched on a different server. I have transfered everything over and installed the database using phpmyAdminwhich went smoothly and I have changed the config file to direct to the new database location.

 

My problem started when I tried to logon to the oscommerce admin section, basically the site is trying to access the old database on a different server, giving the following message.

 

Warning: mysql_connect(): Access denied for user 't------f_osc1'@'localhost' (using password: YES) in /home/sites/------------------.org.uk/public_html/shop/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

I have spent the last couple of hours looking for similar problems on here but can't find anything, has anyone got any suggestions, my guess is a file pointing to the old server but after a search of the shop I cannot find anything.

 

A little help from the more experienced users here would be very much appreciated at this point.

 

Thanks, Colin Needham

Link to comment
Share on other sites

Hi Colin,

 

I was reading here today when someone else had the same problem. I don't remember the exact post, but I do remember this:

 

The person was told to check

 

/includes/configure.php

 

and

 

/iadmin/includes/configure.php

 

and look near the bottom of the pages and you will see your database information. Compare it to what you have setup on your new server, and if anything is different, you'll need to either change the server info to reflect the files info, or change the files info to reflect the servers info.

 

I had a database issue myself today, and it was corrected after reading the post.

 

Hope that helps!

 

 

Kevin

"What I didn't know yesterday, I know today & will remember tomorrow"

(By Kwalker)

 

What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download?

Link to comment
Share on other sites

Kevin,

 

Thanks very much, that worked perfectly, I thought there may be another file somewhere but I just couldn't see it admin/includes/configure.php was the missing link.

 

I have had the same problem on a buletin board as well today so I guess that was a similar problem.

 

Hope I can return the favour some time.

 

Best regards,

 

Colin Needham

Link to comment
Share on other sites

Kevin,

 

Thanks very much, that worked perfectly, I thought there may be another file somewhere but I just couldn't see it admin/includes/configure.php was the missing link.

 

I have had the same problem on a buletin board as well today so I guess that was a similar problem.

 

Hope I can return the favour some time.

 

Best regards,

 

Colin Needham

 

You're welcome!

 

Kevin

"What I didn't know yesterday, I know today & will remember tomorrow"

(By Kwalker)

 

What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...