Shared SSL Configuration on a Different Server

[libraschld]

Hi Im am still new to PHP but have an OS commerce site working fine using a shared SSL Server.

 

 

I have another website that is running OSCommerce and we purchased another Shared SSL for this domain but cannot get it to connect to the Database.

 

We have been advised that this is because the secure server is located on a different machine to the one running our website. The host company have not been very helpful they say we can't move our site to the same server as the SSL as it is a very busy site and therefore cannot be moved to the other server.

 

Is there a way to change the config so that it can remotely connect and what information do I need exactly from the hosting company to do this.

 

This is how I have it set up at the moment as localhost didn't work for the database connection. Still doesn't work with this.

 

define('HTTP_SERVER', 'http://www.mydomain.co.uk'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://www.mydomain.co.uk');

define('HTTPS_CATALOG_SERVER', 'https://secure.ispdomain.com/secure/mydomain');

define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module

// define our database connection

define('DB_SERVER', 'http://www.mydomain.co.uk'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'uname');

define('DB_SERVER_PASSWORD', 'password');

define('DB_DATABASE', 'database name');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

 

 

 

This is the message I get from Admin in the secure server area

 

Warning: mysql_connect(): Unknown MySQL Server Host 'http' (1) in /home/ISP/public_html/secure/domain/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

This is the message I get for catalog

 

Warning: mysql_connect(): Unknown MySQL Server Host 'http' (1) in /home/ISP/public_html/secure/mxwholesale/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

 

Any help would be greatly appreciated I am about to lose all my hair and thats not to good for a girlie.

 

Thanks