View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Initial setup and postgresql with no user dbname - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Initial setup and postgresql with no user dbname

More
17 Juil 2023 16:04 #1 by mikael.cordon@gmail.com
Hello,

I am installing a new instance of ProjeQtOr with PostgreSQL database, but I am facing a connection problem:

SQLSTATE[08006] [7] FATAL: no pg_hba.conf entry for host "***.***.***.***", user "xpqotestle", database "xpqotestle", SSL off
dsn = pgsql:host=********;port=5432

pg_hba.conf is well configured. The dbuser xpqotestle has no database named xpqotestle: totally normal by our database naming rules. The dbuser should connect to database named xpqop1_test, which is already created and which is specified in the setup form.

The problem seem to be: with no database specified on the first connection test (seen in tool/configCheck.php), PDO_pgsql try to connect to default dbuser database.

How to deal this?
 

Please Connexion or Create an account to join the conversation.

More
17 Juil 2023 17:54 #2 by babynus
If you know what is wrong, change it in file parameters.php.
Or you can replay the configuration : just remove file tool/parametersLocation.php.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
17 Juil 2023 18:13 #3 by mikael.cordon@gmail.com
In fact, parameter.php is not created, the checks fails.
If I modify tool/configCheck.php to take the dbname into account on the first connection check ("check without database") it works.
When using pgsql, and dbname different from dbuser (and there is no db with the same name as dbuser) the check fails.

Please Connexion or Create an account to join the conversation.

More
21 Juil 2023 14:57 #4 by babynus
With PostgreSql DB should be created first.
Then dedicated user should be created and set as owner od DB.
Then DB name can be different from DB User

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
21 Juil 2023 16:58 #5 by mikael.cordon@gmail.com
Well, I could get around the problem (I hacked configCheck.php). But I am pretty sure the DB was created before the user, and sure that the user was the owner of the DB.

I am on holiday, but I would try to reproduce the situation.

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.034 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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