Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: hanscees on April 26, 2006, 11:54:23 PM

Title: dotproject: what user for mysql?
Post by: hanscees on April 26, 2006, 11:54:23 PM
Hi,
I am trying to install dotproject:
http://docs.dotproject.net/tiki-index.php?page=Installation+Instructions

But when I try to install it no mysql database can be installed:

Database Installation Feedback:     Not Created
No Database Connection available! Access denied for user 'root'@'localhost' (using password: YES)

I have tried as user root and admin with the password I created for these. But no success.

Any hints why this goes wrong and how to do it beter are greatly apreciated. I am afraid I have a very limited experience with databases.

Hans-Cees

ps I have created an ibay called dotproject and a domain dotproject-test.com. Added the domain to my hosts file.
downloaded the installer:
wget \
http://surfnet.dl.sourceforge.net/sourceforge/dotproject/dotproject-v2.0.2.tar.gz
untarred it.

I can access the installer then by :
http://dotproject-test.com/dotproject/install/
Title: dotproject: what user for mysql?
Post by: byte on April 27, 2006, 12:09:43 AM
You should be able to select password as NO, I'm pretty sure because the myslq password is generated automatically and is a long complex password. Maybe someone can clarifer clearer
Title: dotproject: what user for mysql?
Post by: hanscees on April 27, 2006, 12:15:40 AM
Quote from: "byte"
You should be able to select password as NO, I'm pretty sure because the myslq password is generated automatically and is a long complex password. Maybe someone can clarifer clearer

I do not understand this I am afraid. Without password no success either. I have to fill in a password I think?

Without password I get:

Database Installation Feedback:     Not Created
No Database Connection available! Access denied for user 'root'@'localhost' (using password: NO)
Please note that errors relating to dropping indexes during upgrades are NORMAL and do not indicate a problem.
Title: dotproject: what user for mysql?
Post by: monoman on April 27, 2006, 01:12:08 AM
Setting up dotProject is a very easy if you do it right.

1.  Don't use "root" as either dotProject administrator, or for mysql.

2.  Use mysql_setpermission to create a database (option 2), and call it whatever you want.  You will be propted to create a user, and a password if you want, which you do.  Use localhost only.

3.  Don't quit mysql_setpermission yet.  Select option 7, and provide it with the same information.

4.  Enable PHPBasedir (I'm guessing you've installed it in an iBay, say "dotproject") as follows:

> /sbin/e-smith/db accounts setprop dotproject PHPBaseDir /home/e-smith/files/ibays/dotproject/:/tmp

> /sbin/e-smith/signal-event ibay-modify dotproject

5.  If you are using an ibay, delete index.html from the html dir.

6.  Start the dotProject install  http://yourservernamegoeshere/dotproject

Cheers
Title: dotproject: what user for mysql?
Post by: hanscees on April 27, 2006, 10:21:59 PM
Quote from: "monoman"
Setting up dotProject is a very easy if you do it right.
Cheers


so is life:-)

but very many thanks. I got it running now. I will see if I can make a vmware available with dotproject installed.

Here is the howto I made for this:
http://www.hanscees.com/sme7/dotproject4sme7.html

Now I will go and dig into dotproject.

Hans-Cees