Install fails at db settings page

[uniquehandle]

I have apache (via xampp, thus php 5) running on port 8001. Probably that is contributing to the error I'm getting. Step by step, here is what I did at the db settings page:

- left all of the default settings alone, including localhost for host name
- tried to download the xml schema file
- got an error message, which I can't repro any more and can't offer any detail on (sorry)
- tried the install db & write cfg button, with the same result
- changed the db host name to localhost:8001
- tried both the xml dl and the install db & write cfg again, resulting in this msg: "Security Check: dotProject seems to be already configured. Communication broken for Security Reasons!"
- if I try to nav to the root dir of dotproject, I see this error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dp_user'@'localhost' (using password: YES) in E:\apachefriends\xampp\htdocs\dotproject\lib\adodb \drivers\adodb-mysql.inc.php on line 327
FATAL ERROR: Connection to database server failed

I should probably note, it is not clear to me if I'm supposed to leave the default database user "db_user" and the suggested password intact on the form, and have the install routine create them; or if I'm supposed to put in an existing user acct and pswd? I've done both, neither solves this issue. I've noticed that a lot of these sorts of install scripts, at this stage, don't make it clear if one is supposed to enter an existing acct with the proper perms, or allow the install routine to create a new user etc.

I'm clueless, what have I done wrong? Thanks!

[pedroa]

Does mysql know you are trying to run it on port 8001?
Verify your configuration, there is a MYSQL section in php.ini, by the way...

Pedro A.

[uniquehandle]

Hi Pedroa

I've modified the php.ini at E:\apachefriends\xampp\php\php.ini to

mysql.default_port = 8001

and restarted mysql, and I still get the same error. You didn't respond about the user names, if I need to create those manually, so I guess I don't. There is no dotProject db yet in mySQL.

Thanks

[pedroa]

Since that's a php setting you should restart php and mysql.
Make sure mysql is running in the right port.
The accounts should allways be a mysql account with the right mysql permissions.

Pedro A.

[uniquehandle]

Hmmm...new error:

Progress:
Applying database updates
There were 198 errors in 198 SQL statements
There were 6 errors in 7 SQL statements
There were 7 errors in 8 SQL statements
There were 2 errors in 2 SQL statements
Applying data modifications

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in E:\apachefriends\xampp\htdocs\dotproject\lib\adodb \drivers\adodb-mysql.inc.php on line 327
FATAL ERROR: Connection to database server failed

I might have thought that this at least indicates that the db was created, but it has not been.

[pedroa]

If your mysql user/password is right my guess is that mysql is in another frequency (port).

Pedro A.

[yogeshwar3]

Hi, I'm also getting the same error, so i gave the correct username and password and now the error is

Database Installation Feedback: Not Created
No Database Connection available! Access denied for user 'db_user'@'localhost' (using password: YES)
Please note that errors relating to dropping indexes during upgrades are NORMAL and do not indicate a problem.

Config File Creation Feedback: Config file written successfully
Login and Configure the dotProject System Environment


the apache error.log shows the following:
"PHP Notice: Undefined index: mode in c:\\Program files\\Apache Group\\Apache2\\htdocs\\dotproject\\install\\db.ph p on line 12"

what should i do now....

[pedroa]

Double check your mysql user permissions.
Verify your docs/check.php

Pedro A.

[uniquehandle]

Well, I really have no idea what I'm doing here. I'll review:

I have apache and mysql installed via xampp on winxp.
I've modified apache so that it's running on port 8001 so that is stays out of the way of IIS.
In php.ini I've set the defualt mysql port to 8001. But I didn't change anything in mysql which I'm sure is a mistake. I'm trying to figure out how to do that. But, is this right, that both apache and mysql are supposed to be using the same port? I don't see the connection. Apache needed to have it's port moved over because IIS is using port 80. What does that have to do with mysql? I'll not do anything else till I hear from you. And I really appreciate your help. I'd sure like to get this running so that I can evaluate it. Thanks.

[pedroa]

uniquehandle,

You are making a whole lot of confusion here.

Why didn't you asked:

"I have IIS and Apache and I want them to work on a different port?"

This would be easier for me to understand... believe it it would...

IIS works on port 80 by default and Apache too, and do you want Apache to work on port 8001, and that's all!

So:

1. Undo all the things you have done like "I've set the defualt mysql port to 8001" and "mysql.default_port = 8001", undo those things so they worked exactly as before (their defaults).

2. Now, if it is Apache that must behave you have to edit the httpd.conf, and the port that Apache is listening, so search the line that says:

Listen 80

and change it to:

Listen 8001

if you have a line that says:

ServerName yourserver.com:80

change that too to:

ServerName yourserver.com:8001

And that's all, now if you point your browser to

http://localhost:8001/dotproject/

You should have it running, and if you point to http://localhost/ you should have IIS default page comming up too.

Allright now?

Pedro A.

[uniquehandle]

Hi Pedroa

I have no idea how I should proceed.

I do not have any problem with Apache (XAMPP), I had it set up on port 8001 before I started working with the dotProject install. It server html and php pages fine without conflict with IIS on port 80.

MySQL (XAMPP) also runs fine. It did before I changed some things because of this discussion, and it runs fine after those mods. I only changed the mySQL settings because you thought it would help.

The only perceptable problem is that after the MySQL page of the dotProject install, I get the failure "Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'rootadmim'@'localhost' (using password: YES) in d:\apachefriends\xampp\htdocs\dotproject\lib\adodb \drivers\adodb-mysql.inc.php on line 327". Process is listed as "Creating config".

So here is where I am. I revered the mod in php.ini, so that the mysql port setting is blank as it was at the beginning. I have no mysql db named "dotproject". I've never created one, as the instructions seem to imply that the db needed will be automatically generated. I have tried leaving the default values on the DB Settings form for user name and password, and I have also tried entering the mysql admin name and password.

What should I try next? Thanks

[pedroa]

"- changed the db host name to localhost:8001"

Have you undone this too?
Should be localhost only.

... also verify your mysql username/password too.
If there is a db, drop it, if there is a includes/config.php, delete it.
Go to the installer again, I see what happens...

I have Apache working in port 8001 and mySQL in its 3306 listening port (default) and everything is ok.

Pedro A.

[uniquehandle]

Yes the db host was at simple localhost.

Apache and MySQL work fine for other php apps I have installed (like the CMS e107). I've deleted the prev install attempt of dotproject. There is no dot project db. I restarted the install attempt and accepted all of the default values, including the user and password.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dp_user'@'localhost' (using password: YES) in E:\apachefriends\xampp\htdocs\dotproject\lib\adodb \drivers\adodb-mysql.inc.php on line 327

dotProject Installer
Progress:
Creating config

[uniquehandle]

What's the next step?

[pedroa]

Test your mysql connectivity/grants, this is not directly related with dP...
So solve your problem with mysql first (like creating the user and grant him mysql permissions)

If you can't solve this you won't get trough...

Pedro A.