Forum (FR)

[SOLVED] Installati...
 
Notifications
Retirer tout

[SOLVED] Installation error with mysql

7 Posts
3 Utilisateurs
0 Reactions
13.5 {numéro}K Vu
(@dubal)
Posts: 6
Active Member
Début du sujet
 
[#2872]

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.


 
Posté : 9 Jan PM 22:011
(@babynus)
Posts: 14952
Membre Admin
 

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 😉


 
Posté : 10 Jan PM 20:011
(@dubal)
Posts: 6
Active Member
Début du sujet
 

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?


 
Posté : 10 Jan PM 21:011
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 10 Jan PM 21:011
(@dubal)
Posts: 6
Active Member
Début du sujet
 

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?


 
Posté : 10 Jan PM 22:011
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 11 Jan AM 01:011
ANTOINE Philippe
(@antoine_p)
Posts: 4
Active Member
 

Sorry.This post was an error. I can not delete it.


 
Posté : 7 Mar PM 14:033
Share:
Retour en haut