Step 4 Installation problem... please help

[stewdawg35]

I have been through the various threads and can't seem to figure out how to fix our problem.

We are running MySQL 4.1, and have phpMyAdmin installed. I have created a database called "cms" and have run the command:

GRANT ALL PRIVILEGES ON cms . * TO cms_user@localhostIDENTIFIED BY 'cms_pass'

However when I choose the following options:

Database Type: MySQL 4.1+
Port: 3307 (that is the port we installed mysql on)
Database Name: cms
Database User: cms_user
Database Password: cms_pass
Table prefix: cms_
Create tables: checked

We get one of two errors:

Connection failed or

Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in C:\www\cms\lib\adodb\drivers\adodb-mysql.inc.php on line 340
Connection failed

Any ideas?

[petert]

the type: MySQL 4.1+ just doens't work. use the 'normal' MySql option

[stewdawg35]

I tried that, I still get the same error. Any other ideas I am desperate. I have deleted and recreated the database and user accounts as well just to make sure that they are correct....

[stewdawg35]

by editing the install.php file on line 337

from:
#$db->debug = true;

to:
$db->debug = true;

I now get this error:
localhost: Missing extension for mysql
Connection failed

Now can anyone help me?

[Kyle]

Patricia,

How about posting your solution for the benefit of the rest of us having the same problem?

Thanks!

[stewdawg35]

I have still been unable to install CMS, however I did install MAMBO on my first attempt, and have since fallen in love with it, it is easy to use and there are endless modules, and add-on components that make it fit any need, not to knock CMS I am sure it is great in its own right, personally I have found MAMBO to be the best solution for my needs.

[Knox Bronson]

I am having the same problem ... same error message, same line of code ...

I read Patricia's replies and went back and double-checked all permissions, made a new "config.php" file in Dreamweaver (just in case - my orig. was made in text editor) ... set the permissions on it, went thru the process a couple more times.

Have emailed my ISP for help, no response yet.

Any other suggestions what I should look at? thanks.

[Knox Bronson]

Thanks, Patricia. I had already tried making a new database, user name, etc., but I went back and did it again, checked all the permissions on the folders, etc.

I am wondering if perhaps all the CMS Made Simple folders and files (I downloaded and unstuffed) are supposed to be their own folder, rather than simply all in the root folder of the site. Could that be it?

thanks.

[Knox Bronson]

Well, I tried putting all the files in a folder, cmsms, within the root directory, rechecked permissions ... no luck.

[knox Bronson]

Yes, that is correct ... i've been entering my database name and user as

djfrien_new - database
djfrien_admin - user (dba)

I am assuming that is the correct way ... when you create your database, c-panel uses your login_[your database name], truncates if necessary ...

thanks again.

[Knox Bronson]

Well, the problem was really simple ... where I created the database and all that, it had the location of the database as localhost

and i was supposed to change it to:

mysql.floridaserver.com

but i didn't realize that. Not sure if it is mentioned in the documentation. It probably is very obvious to most people.

so, the answer is yes, it finally worked.

thanks for all the help.

[Piratos]

In germany there are minimal 2 big hosters they have mysql on another server as the domain.

the reason is the big hardware of the mysql server and the wanted high speed mysql connection of the users.

tere the connection must be an ip - connection and not localhost or so.

only 0,001% of all german domains are using postgresql.