Hi All,
I got the dreaded Error 0 can not connect to host localhost problem after CS 1 (the version I'm using for various reasons) was able to create tables for my database.
I fought with this for hours today and ripped out most of my hair
.
I was getting the Error 0 Can not connect to host localhost error after successfully installing CS 1. This error displayed itself after CS populated the MySQL tables when I clicked the "here" link that leads to the main index page.
The "Error 0...." message appeared at the top of the page and nothing functioned.
Short answer: I uploaded my files for CS1 using WinSCP secure FTP through logging into the server as "root". I thought I was uploading in Binary mode - but either way, this did not work.
When I uploaded using a direct FTP client, like WSFTP and logging directly into the website (not server root) and uploaded all files binary, everything worked fine!
Here's the long answer, I'm going to post it in the forums, as other users have had similar issues;
Installing Content Solution 1.0 on ISPConfig CENTOS 4.x server
1.) Add website via ISPConfig Interface, specify use of a MySQL database.
2.) DO not select PHP SAFE MODE.
3.) Specify 1 database for use with Content Solution.
4.) Add a web site user and password, make sure to save password for use with FTP.
5.) Add DNS nameservers and entries, NS1 and NS2 records if necessary.
6.) Login with FTP via web user and password DO NOT USE WINSCP to transfer files!
7.) Upload using WSFTP binary mode to cs folder.
8.) Chmod 777 the "common" folder.
9.) Go to PHPmyadmin, add a database "abcd".
10.) Go to privileges, add a user "1234" WITHOUT GLOBAL access.
11.) Then add user 1234 to database abcd, granting all permissions, but NO GLOBAL Access.
12.) Load mydomain.com/cs/manage/install.
13.) Fill in appropriate info per MySQL install.
14.) Click submit and then "here"
15.) Rock and roll.
So happy it finally works!:cool:
