looseman Posted June 20, 2004 Posted June 20, 2004 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!
kwikone Posted June 21, 2004 Posted June 21, 2004 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.