linking two sites to one database

[Tjobbe]

I have my oscommerce store one two sites, on is on a normal server and the other on a secure server. the both have complaetely different urls, of course.

 

What i want to do is have the secure server use the mysql database from the other server, I have the ip address of the database server, which i have enterred on the

 

  define('DB_SERVER', 'the.ip.goes.here');

 

I have done the above, but it will not work, is this possible what I am trying, can anyone help or give me any advice?

 

thanks in advance.

[Iggy]

Can you connect to that server via telnet and login? mySQL generally runs on port 3306 for that purpose but ask your host if they allow access via the intarweb or if it will only accept connections via localhost.

 

Hope that helps!

Iggy

[Tjobbe]

I managed to do it, dont ask me how but it works now, sort of!

 

Warning: main(includes/languages/.php): failed to open stream: No such file or directory in /home/bagnbox/public_html/includes/application_top.php on line 268

Warning: main(includes/languages/.php): failed to open stream: No such file or directory in /home/bagnbox/public_html/includes/application_top.php on line 268

Fatal error: main(): Failed opening required 'includes/languages/.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bagnbox/public_html/includes/application_top.php on line 268

 

I get this on my index.php page at: http://www.boxes-bags.com/ but: http://www.speedydns.info/~bagnbox is fine, whats going on here?

[Iggy]

Warning: main(includes/languages/.php)

 

That's basically a file not found for include. What language are you using and check that it exists?

 

Iggy