Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

On line Merchant Admin tool unabel to connect


Hubcap

Recommended Posts

Posted

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)

Posted

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 >

Posted

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.

Posted

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 >

Posted

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

Archived

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

×
×
  • Create New...