View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Installation error with mysql - ProjeQtOr
 
 

[SOLVED] Installation error with mysql

More
09 Jan 2016 20:51 #1 by dubal
Hi there.
Tried it on 2 different machines: Linux Mint and Centos 6.5.
Unzipped projeqtorV5.1.5.zip in /var/www/html as root.
Do I have to change permissions or ownership of projeqtor or its some specific subdirectories?
Are there some installation instructions that I am missing?
Do I have to edit some config file with some mysql user name and password?
Because this is the error I am getting in red and it is not going away. I cannot proceed further at all:

SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
dsn = mysql:host=127.0.0.1;port=3306

If I type mysql -u root -p at shell prompt, I am able to log into mysql with root's password.
I am stuck there. Please help.
Thanks in advance.

Please Log in or Create an account to join the conversation.

More
10 Jan 2016 18:52 #2 by babynus
Simply password for your mysql user "root" is not correct.
Default proposed value is "mysql", but linux installs set no password : try without a password (set "db password" to empty value)
... but maybe you changed root password on mysql install ;)

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
10 Jan 2016 19:21 #3 by dubal
Replied by dubal on topic Installation error with mysql
Many thanks for your reply babynus.
root is the mysql user.
If I type mysql -u root -p at shell prompt, it asks for password.
If I enter the root's password correctly, it logs into mysql.
I tried leaving the db password column empty. It says this in red: incorrect value for 'Default password for initialization', field is mandatory.
If the default password is hard-coded in some config file, please tell me so that I can amend it.
Let me tell you another thing: None of the files are created or amended so far by the installation process. I had tried chown -R 777 projeqtor . It does not create or modify any file.
There is no parameter file in tool directory.
I did not change the following values in the set up screen:
../files/attach/
../files/report/
../files/logs/projeqtor_${date}.log
../files/config/parameters.php
Do I have to remove dots? Give full path names?
I do not see any logs created anywhere.
What am I doing wrong?

Please Log in or Create an account to join the conversation.

More
10 Jan 2016 19:28 #4 by babynus

I tried leaving the db password column empty. It says this in red: incorrect value for 'Default password for initialization', field is mandatory.

You tried and set to null the default password for projeqtor, this is the default value to set password for new projeqtor users.
What you have to change is "Database password for user", and set it to your mysql "root" user.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
10 Jan 2016 20:21 #5 by dubal
Replied by dubal on topic Installation error with mysql
Figured it out.
Here are my steps to get it to work on Centos 6.5:
1. Unzip into /var/www/html . You need to be root.
2. chmod 777 tool
3. change the default mysql root password to your mysql root password in here: tool/config.php
4. Visit this with your browser: localhost/projeqtor
5. You will see the list of module. Install any modules that are shown missing.
6. Create a directory such as projeqtor somewhere outside the web root. chown apache.apache to that directory.
7. Change the following defaults to this new directory. I used full path names.
../files/attach/
../files/report/
../files/logs/projeqtor_${date}.log
../files/config/parameters.php
8. Changed other params such as time zone, currency, mail ids etc.
Then it worked.
Changed permissions back to normal on tool.
Hope it helps someone.
Question: Is it safe to chown -R apache projeqtor right after unzipping the package in web root?

Please Log in or Create an account to join the conversation.

More
10 Jan 2016 23:12 #6 by babynus

3. change the default mysql root password to your mysql root password in here: tool/config.php

This step is not usefull : you'll be able to change db password on the config screen.

Question: Is it safe to chown -R apache projeqtor right after unzipping the package in web root?

Yes, it is a good practice. With rights 755, all will work fine.
If you want to be even more secured you can set rights to 555 except for following folder (to keep 755) :
/files/* (and/or directories you configures)
/model/custom
/plugin/*
With this configuration, you'll be sure your folders are protected against unextected change.
You'll just have to adapt rights when deploying new version and possible when deploying some plugins.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.047 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.