thumb Posted June 12, 2011 Share Posted June 12, 2011 I moved my site to another host and did all the needed changes to the configure.php in both the includes and the admin/includes to match the new server. I created a new database with the same name except that the old host had a name1_dbname and the new host has a namec_dbname. I imported the database from the old host into the new database with no problems. I then created a new user namec_admin(old host was name1_admin) and added it to the new database. Everything seemed to go smoothly.... Then when I tried to access the OSC I get this error: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'namec_admin'@'localhost' (using password: YES) in /home2/namec/public_html/original/includes/functions/database.php on line 19 Unable to connect to database server! When I try to access the OSC Admin I get a login screen but it will not take what I created when I made the new database and new username. I must be missing something but I can not figure it out. BTW, right now I'm using version 2.2.1 but as soon as I can get this one up and running, I'll upgrade to the newest version after I convert the database over. Link to comment Share on other sites More sharing options...
Guest Posted June 12, 2011 Share Posted June 12, 2011 Tim, There is NO osCommerce version 2.2.1 so I will assume you meant 2.3.1. I would suggest checking the two configure.php files again. The catalog side has a database issue and the admin side is connecting to the database, but is suffering the well known log in issue. Chris Link to comment Share on other sites More sharing options...
thumb Posted June 12, 2011 Author Share Posted June 12, 2011 Sorry, it's 2.2 RC1 For some reason the cart amazingly started working without me doing anything but I still can not get into the admin of the store. I've used the username and password I've been using on the old host for 4 years so it should be the same. I'll keep poking around and see what is going on Link to comment Share on other sites More sharing options...
Guest Posted June 12, 2011 Share Posted June 12, 2011 Well, RC1 didn't have an actual administrators table in the database, it was only protected with either an .htaccess password or a password protected directory as set in your hosting account file manager. I would suggest looking at the /admin/.htaccess to determine if that is the case first, since the new hosting account file manager wouldn't have one set up yet unless you did it (and you should remember doing that). Chris Link to comment Share on other sites More sharing options...
thumb Posted June 12, 2011 Author Share Posted June 12, 2011 There is a .htpasswd in the admin folder along with the .htaccess that calls for it. It was uploaded from the old host. Link to comment Share on other sites More sharing options...
NodsDorf Posted June 12, 2011 Share Posted June 12, 2011 look at your .htaccess it will reference your location to htpasswd file. Switching host will cause the path to that file to change. Your old host may have been something like /home/web3s/public_html/catalog/admin/.htpasswd While your new host maybe something different like /home4/zroc72/public_html/catalog/admin/.htpasswd Link to comment Share on other sites More sharing options...
Guest Posted June 12, 2011 Share Posted June 12, 2011 There is a .htpasswd in the admin folder along with the .htaccess that calls for it. It was uploaded from the old host. That's the issue !! Chris Link to comment Share on other sites More sharing options...
thumb Posted June 13, 2011 Author Share Posted June 13, 2011 Thanks for all the help guys, everything is now working and yes the .htaccess had the old path which I changed. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.