Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Mysql on another host


looseman

Recommended Posts

Posted

Mysql server is running on my local pc, but oscommerce is install on other webserver

 

I installed OS-commerce on my local pc has not problem, but once I tried install it on a pay webhosting and got problems

 

Parse error: parse error, unexpected $end in C:\Clients\xxxxx\xxxxx.com\www\shop\install\templates\pages\install_2.php on line 211

 

after I hit [contiune] on step 1 with enable [X] Import Catalog Database:

if I disable it, i can go step 2-5

after step 5 after I filled mysql info, then I got

 

Parse error: parse error, unexpected $end in C:\Clients\bennywong\ubeez.com\www\shop\install\templates\pages\install_7.php on line 191

 

I emailed to customer suppert, and repied

 

For your OS-commerce problem below, our wild guess is that the write

permission may not have turned on in your account. We will set the write

permission on your account now. However PHP on NT should be functional as we

have extensively tested it before.

 

BTW:customer suppert always useless, I asked thier NT server's perl path, he replied me a URL to a FAQ page, there hasn't useful info I needed, the host is running on NT, I need the perl path should be c:\perl\bin...something like that, the FAQ page is only provide the path for UNIX....sign...

 

Then I try again, I got the same problem, and I used mysql.php to test

 

I think is the connection problem which was the oscommerce couldn't get connect to my mysql server...

 

whatever how I set mysql.php with my ip xxx.xxx.xxx.xxx, it always try connect to localhost the webserver I installed(pay hosting).

 

<?php

$mysql_host = "MY IP"; // host name <point to my server>

$mysql_user = "xxxx"; // username

$mysql_pass = "xxxx"; // password

$mysql_database = "phpshop"; // database

// connect

mysql_connect ($mysql_host, $mysql_user, $mysql_pass) or die(mysql_error());

mysql_select_db ($mysql_database) or die(mysql_error());

?>

 

I tested the mysql.php becouse I got this problem also when I manually config those configure.php files

 

define('DB_SERVER', 'xxx.xxx.xxx.xxx'); already set it to my server's ip

 

Warning: mysql_connect(): Host 'xxxxxx.' is not allowed to connect to this MySQL server in C:\www\mysql.php on line 7

Host 'xxxxxx' is not allowed to connect to this MySQL server

 

ofcouse it isnt allowed, that is not my pc's mysql server...I don't wanna pay for it, so I would use my own mysql server

 

Question!! how can I fix this problem,

how can I make the oscommerce to connect to my pc..not pay hosting

 

NT webserver => Installed oscommerce

my pc => Installed mysql server

on different places

 

this is the oscommerce's problem ? or problem on that NT webserver's setting?

 

please help anyone!

Posted

First, you should get yourself some type of DNS service for your PC (checkout ipupdater.com, or any of the others that have this service) so that your PC will be known to DNS calls (your PC would be known as, for example, mypc.ipupdater.com).

 

Second, use that name (mypc.ipupdater.com) for the $mysql_host

 

If you have your MySQL server running on a non-standard port (for example: 988) then the $mysqlhost = "mypc.ipupdater.com:988".

 

Also, you need to verify that your inbound MySQL port (standard is 3306) is allowed through by your ISP (for example: :angry: Cox.net in the U.S. DOES NOT ALLOW about 95% of all (65535) ports --> one of which they don't allow on inbound is the MySQL port 3306, so you would always get a failure to connect unless you changed your MySQL server port to be one they allowed for inbound connections). There are several sites where you can do port scanning (see www.grc.com for their port scanner) to see whether or not the port is blocked by your ISP.

 

Kerry

Archived

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

×
×
  • Create New...