Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Changing servers


mochi

Recommended Posts

Posted

I need to put my store on a new server, how do i do this without having to reconfigure the entire catalog?

Posted
I need to put my store on a new server, how do i do this without having to reconfigure the entire catalog?

 

Ok this is what i did...I installed Oscommerce on the new server and then replaced the catalog folder with the catalog folder from my already configured Shopping cart that was on the old server.

 

when I try to access the cart I get this error message:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user '*****'@'i********' (using password: YES) in /homepages/39/*******/htdocs/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

is there somewhere i can change the username and password to access the new database???

 

* Removed data for security

Posted

You need to edit the /includes/configure.php and the /admin/includes/configure.php. Those files are where you set your database information and you paths.

 

If you installed the default OSC then replaced the your old catalog folder with the new one you still won't have your store items. What you need to do is take the /includes/configure.php and the /admin/includes/configure.php that were in the default install and place them in your old catalog. That way you will have the right database information and the right paths.

 

You still need a backup of your old database and import it into your new one.

Other great Open Source (Free) programs: (Free as in free speech not free beer)

The Gimp - An image program. | Firefox - All you have to do is add the Web Developer add-on to make this web browser complete. | FileZilla - An ftp program. | Inkscape - A good program to create images with. | Thunderbird - An email program. | Openoffice.org - An office suite that is compatible with MS Office. | Abiword - Another office suite. | Audacity - A sound recording tool. | ddp's Picks | Wordpress - An easy to use blogging software. | Joomla - An easy to use CMS that has ecommerce plug-ins. | Drupal - Another CMS

How do I find these programs? Google Search!

Posted

Afternoon,

 

I seem to be experiancing the same problem. I have change both configure.php files and uploaded them to over write the default files. I have also uploaded the backed up data base to mySQL.

 

I can load my index page up on the site, but with not active links on their, and my admin page has the the following warning.

 

 

Warning: mysql_connect(): Access denied for user '*****'@'*********' (using password: YES) in /home/******/s/*********/user/htdocs/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

 

Hope you guys can help, and be a life saver.

 

Regards

 

Richard Smart

 

* Removed data for security

Posted

Warning: mysql_connect(): Host '******' is not allowed to connect to this MySQL server in *:\******\www\*****\******\includes\functions\database.php on line 19

Unable to connect to database server!

 

This indicates the wrong server DB_SERVER information in the configure.php files

 

Warning: mysql_connect(): Access denied for user: '****@*****' (Using password: *****) in *:\******\www\*****\******\includes\functions\database.php on line 19

Unable to connect to database server!

 

This indicates the wrong username DB_SERVER_USERNAME or password DB_SERVER_PASSWORD information in the configure.php files

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

This indicates that either no database has been created or the wrong database name DB_DATABASE exists in the configure.php files

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Archived

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

×
×
  • Create New...