Hubcap Posted July 4, 2010 Posted July 4, 2010 I had three problems, and need help with the third. (Please) 1. Fixed------SSL expired-- purchased and working 2. Fixed---- "Unable to connect to database server!" when I tried to access store as web user Fixed by changing webuser password Some how it was not not long enough and I had to add 1 letter. 3: "Unable to connect to database server!" is all I get when I try to access the On Line Merchant Tool I re-entered the password (where you change it and saved it but that did not help) I've been searching and reading the to forum for two days to no avail.... Help would be deeply appreciated (This is an inherited site from previous owner, I'm learning the hard way)
germ Posted July 4, 2010 Posted July 4, 2010 The login credentials for admin database access are stored in the file admin/includes/configure.php using theses lines (close to the bottom of the file): define('DB_SERVER', '<your site specific data goes here>'); define('DB_SERVER_USERNAME', '<your site specific data goes here>'); define('DB_SERVER_PASSWORD', '<your site specific data goes here>'); define('DB_DATABASE', '<your site specific data goes here>'); If you have access on the catalog side, then you should transfer the data for those lines from the file: /catalog/includes/configure.php Into: /catalog/admin/includes/configure.php Let me be as clear as glass on this. DO NOT COPY THE ENTIRE FILE FROM THE CATALOG SIDE TO THE ADMIN SIDE. Just the data from the lines of code I posted. Also be aware of the tidbit below: In the includes FOLDER (catalog and admin) where the normal configure.php files are there is a FOLDER named local On some installs there may be a configure.php inside the local FOLDER (catalog and admin) If there is, anything in it overrides anything in the normal configure.php files. If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Hubcap Posted July 4, 2010 Author Posted July 4, 2010 NEW There is nothing but a text file in my local folder At the moment my code lines referenced below are identical in both catalog/includes and the admin/includes IS the code exactly the same for the lines listed below in the catalog/includes and the admin/includes or should I substitute the admin username and password in the admin/includes the other lines listed below are the same define('DB_SERVER', '<your site specific data goes here>'); define('DB_SERVER_USERNAME', '<your site specific data goes here>'); define('DB_SERVER_PASSWORD', '<your site specific data goes here>'); define('DB_DATABASE', '<your site specific data goes here>'); Hubcap The login credentials for admin database access are stored in the file admin/includes/configure.php using theses lines (close to the bottom of the file): define('DB_SERVER', '<your site specific data goes here>'); define('DB_SERVER_USERNAME', '<your site specific data goes here>'); define('DB_SERVER_PASSWORD', '<your site specific data goes here>'); define('DB_DATABASE', '<your site specific data goes here>'); If you have access on the catalog side, then you should transfer the data for those lines from the file: /catalog/includes/configure.php Into: /catalog/admin/includes/configure.php Let me be as clear as glass on this. DO NOT COPY THE ENTIRE FILE FROM THE CATALOG SIDE TO THE ADMIN SIDE. Just the data from the lines of code I posted. Also be aware of the tidbit below: In the includes FOLDER (catalog and admin) where the normal configure.php files are there is a FOLDER named local On some installs there may be a configure.php inside the local FOLDER (catalog and admin) If there is, anything in it overrides anything in the normal configure.php files.
germ Posted July 4, 2010 Posted July 4, 2010 What you have posted defies everything I know about logic and how the software works. The only other bit of advice I can muster at the moment would be this: If you're making changes to the config file locally then using FTP to transfer to the site, check the files on the server to be sure they say what you think they say. Sometimes permissions on the config files disallow successful replacment vis FTP. If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Hubcap Posted July 5, 2010 Author Posted July 5, 2010 Thanks for taking the time to explain the above CODE. I messed something up in the admin/includes and some how the login screen for the merchant came up and asked for a new password but it would not save it. It did the same thing 5 times. I then renamed the admin and used a backup of the one that was not working from this morning and I was again prompted for a new user and password, this time it saved it and I was able to login. I get more confused every day... Sorry I cannot explain why its working. Hubcap NEW There is nothing but a text file in my local folder At the moment my code lines referenced below are identical in both catalog/includes and the admin/includes IS the code exactly the same for the lines listed below in the catalog/includes and the admin/includes or should I substitute the admin username and password in the admin/includes the other lines listed below are the same define('DB_SERVER', '<your site specific data goes here>'); define('DB_SERVER_USERNAME', '<your site specific data goes here>'); define('DB_SERVER_PASSWORD', '<your site specific data goes here>'); define('DB_DATABASE', '<your site specific data goes here>'); Hubcap
Recommended Posts
Archived
This topic is now archived and is closed to further replies.