View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Cloned Environnement -> Undefined variable: connexion in DataCloning.php - ProjeQtOr
 
 

[SOLVED] Cloned Environnement -> Undefined variable: connexion in DataCloning.php

More
07 Jun 2022 09:25 - 07 Jun 2022 09:26 #1 by iFlorian
Cloned Environnement -> Undefined variable: connexion in DataCloning.php was created by iFlorian
Hi there,

I'v met a bug when I wanted to test cloned environnement, here the log: 
2022-06-07 09:10:12.495 ***** ERROR ***** [V9.5.4] ERROR *****
2022-06-07 09:10:12.503 ***** ERROR ***** [V9.5.4] on file '/var/www/projeqtortest/projeqtor/model/DataCloning.php' at line (1099)
2022-06-07 09:10:12.503 ***** ERROR ***** [V9.5.4] cause = Undefined variable: connexion
2022-06-07 09:10:12.503 ***** ERROR ***** [V9.5.4] Undefined variable: connexion in DataCloning.php at line 1099
2022-06-07 09:10:12.503 ***** ERROR ***** [V9.5.4] Error while executing CRON script : fix the source issue and manually restart the CRON Process
2022-06-07 09:10:14.392 ***** ERROR ***** [V9.5.4] EXCEPTION *****
2022-06-07 09:10:14.393 ***** ERROR ***** [V9.5.4] on file '/var/www/projeqtortest/projeqtor/model/DataCloning.php' at line (676)
2022-06-07 09:10:14.393 ***** ERROR ***** [V9.5.4] cause = Call to a member function exec() on null
2022-06-07 09:10:14.393 ***** ERROR ***** [V9.5.4]    => #0 /var/www/projeqtortest/projeqtor/tool/cronExecutionStandard.php (154) -> createDataCloning()
2022-06-07 09:10:14.393 ***** ERROR ***** [V9.5.4]    => #2 /var/www/projeqtortest/projeqtor/model/Cron.php (545) -> call_user_func()
2022-06-07 09:10:14.393 ***** ERROR ***** [V9.5.4]    => #3 /var/www/projeqtortest/projeqtor/tool/cronRun.php (33) -> run()
2022-06-07 09:10:14.393 ***** ERROR ***** [V9.5.4] Call to a member function exec() on null
2022-06-07 09:10:14.393 ***** ERROR ***** [V9.5.4] Exception while executing CRON script : fix the source issue and manually restart the CRON Process
2022-06-07 09:10:15.127 ***** ERROR ***** [V9.5.4] CRON abnormally stopped

We use Projeqtor 9.5.4 on php7.4-fpm  with PostGreSQL 14 Database

Thanks a lot,

Best regard,
Florian
“Be a yardstick of quality. Some people aren't used to an environment where excellence is expected.” ~ Steve Jobs
"...and while some may see them as the crazy ones, we see genius, because the ones who are crazy enough to think that they can change the world, are the ones who do." ~ Think Different
Last edit: 07 Jun 2022 09:26 by iFlorian.

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

More
07 Jun 2022 10:44 #2 by iFlorian
Replied by iFlorian on topic Cloned Environnement -> Undefined variable: connexion in DataCloning.php
Last news: 
Now, I'v only this error in the log :
2022-06-07 10:40:09.016 ***** ERROR ***** [V9.5.4] Erreur simulation - Impossible de créer la base de données
even with Script log... 

I can see the new databases in postgresql : 
                                          Liste des bases de données
       Nom       | Propriétaire  | Encodage | Collationnement | Type caract. |         Droits d'accès
-----------------+---------------+----------+-----------------+--------------+---------------------------------
 postgres        | postgres      | UTF8     | fr_FR.utf8      | fr_FR.utf8   | =T/postgres                    +
                 |               |          |                 |              | postgres=CTc/postgres
 projeqtortest   | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   | projeqtortest=CTc/projeqtortest
 simu_boexgt     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |
 simu_ktuvcf     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |
 simu_lljiyz     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |
 simu_ugmhds     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |
 simu_ycyjzz     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |
 template0       | postgres      | UTF8     | fr_FR.utf8      | fr_FR.utf8   | =c/postgres                    +
                 |               |          |                 |              | postgres=CTc/postgres
 template1       | postgres      | UTF8     | fr_FR.utf8      | fr_FR.utf8   | =Tc/postgres                   +
                 |               |          |                 |              | postgres=CTc/postgres
 template1_old   | postgres      | UTF8     | fr_FR.utf8      | fr_FR.utf8   | postgres=CTc/postgres
And I can create table with my user in the simu database... so why It's not working ? 
 
“Be a yardstick of quality. Some people aren't used to an environment where excellence is expected.” ~ Steve Jobs
"...and while some may see them as the crazy ones, we see genius, because the ones who are crazy enough to think that they can change the world, are the ones who do." ~ Think Different

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

More
08 Jun 2022 13:55 #3 by babynus
Replied by babynus on topic Cloned Environnement -> Undefined variable: connexion in DataCloning.php
To use the simulation feature, DB user muwt have rights to create new DB "with grant options"
Babynus
Administrator of ProjeQtOr web site

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

More
09 Jun 2022 09:01 #4 by iFlorian
Replied by iFlorian on topic Cloned Environnement -> Undefined variable: connexion in DataCloning.php
Hi,
Thanks for your answer but the DB user called "projeqtortest" has already the good rights, see : 
postgres-# \du+
                                                      Liste des rôles
  Nom du rôle  |                                    Attributs                                    | Membre de | Description
---------------+---------------------------------------------------------------------------------+-----------+-------------
 postgres      | Superutilisateur, Créer un rôle, Créer une base, Réplication, Contournement RLS | {}        |
 projeqtortest | Superutilisateur, Créer un rôle, Créer une base, Réplication, Contournement RLS | {}        |

postgres-# \l
                                          Liste des bases de données
       Nom       | Propriétaire  | Encodage | Collationnement | Type caract. |         Droits d'accès
-----------------+---------------+----------+-----------------+--------------+---------------------------------
 postgres        | postgres      | UTF8     | fr_FR.utf8      | fr_FR.utf8   | =T/postgres                    +
                 |               |          |                 |              | postgres=CTc/postgres
 projeqtortest   | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   | projeqtortest=CTc/projeqtortest
 simu_lnbcdk     | projeqtortest | UTF8     | fr_FR.utf8      | fr_FR.utf8   |

Thanks for your help,

Best regards,
Florian
“Be a yardstick of quality. Some people aren't used to an environment where excellence is expected.” ~ Steve Jobs
"...and while some may see them as the crazy ones, we see genius, because the ones who are crazy enough to think that they can change the world, are the ones who do." ~ Think Different

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

More
12 Jun 2022 12:36 #5 by babynus
Replied by babynus on topic Cloned Environnement -> Undefined variable: connexion in DataCloning.php
Hi,

I see in your log a DB called 'simu_lnbcdk'.
Was it present before the clone process ?
If not, it means the process correctly creates the DB, but an error occurs somewhere else
(all DB population is in the same try / catck block so any other error will raise same error message)
Babynus
Administrator of ProjeQtOr web site

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

More
12 Jun 2022 12:49 #6 by babynus
Replied by babynus on topic Cloned Environnement -> Undefined variable: connexion in DataCloning.php
We'll add some extra debugging code in V9.5.5 to help debug this point.
Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynus, protion
Time to create page: 0.049 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.

Login Form