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 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
To use the simulation feature, DB user muwt have rights to create new DB "with grant options"
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
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)
We'll add some extra debugging code in V9.5.5 to help debug this point.
Hi,
The DB called "simu__lnbcdk" was well created by ProjeQtOr, it wasn't here befor.
Thanks for extra debugging, I hope we will see the issue with that.
Wait & see...
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
Hi,
I've installed the last version 9.5.5 and we can see this error in log :
2022-06-15 15:20:06.890 ===== TRACE ===== first_test - Début de création de l'environnement 2022-06-15 15:20:06.894 ===== TRACE ===== first_test - Début de la copie de la base de données simu_nbedig 2022-06-15 15:20:06.894 ----- DEBUG ----- => Create Database simu_nbedig 2022-06-15 15:20:07.048 ----- DEBUG ----- => Connect to new DB simu_nbedig 2022-06-15 15:20:07.067 ----- DEBUG ----- => Create Table accessprofile 2022-06-15 15:20:07.073 ----- DEBUG ----- => Create Table accessright 2022-06-15 15:20:07.102 ----- DEBUG ----- => Create Table accessscope 2022-06-15 15:20:07.107 ----- DEBUG ----- => Create Table accessscopespecific 2022-06-15 15:20:07.112 ----- DEBUG ----- => Create Table action 2022-06-15 15:20:07.117 ----- DEBUG ----- => Create Table activity 2022-06-15 15:20:07.129 ----- DEBUG ----- => Create Table activityprice 2022-06-15 15:20:07.134 ----- DEBUG ----- => Create Table activityworkunit 2022-06-15 15:20:07.138 ----- DEBUG ----- => Create Table affectation 2022-06-15 15:20:07.145 ----- DEBUG ----- => Create Table alert [... many create Table lines after....] 2022-06-15 15:20:09.125 ----- DEBUG ----- => Create Table workflowstatus 2022-06-15 15:20:09.146 ----- DEBUG ----- => Create Table workperiod 2022-06-15 15:20:09.155 ----- DEBUG ----- => Create Table worktoken 2022-06-15 15:20:09.161 ----- DEBUG ----- => Create Table worktokenclientcontract 2022-06-15 15:20:09.167 ----- DEBUG ----- => Create Table worktokenclientcontractwork 2022-06-15 15:20:09.172 ----- DEBUG ----- => Create Table worktokenmarkup 2022-06-15 15:20:09.179 ----- DEBUG ----- => Create Table workunit 2022-06-15 15:20:09.181 ----- DEBUG ----- => Execute script to create all tables 2022-06-15 15:20:09.239 ** ERROR ** [V9.5.5] Erreur simulation - Impossible de créer la base de données 2022-06-15 15:20:09.239 ** ERROR ** [V9.5.5] SQLSTATE[42703]: Undefined column: 7 ERREUR: la colonne « id » de la relation « accessprofile » n'existe pas
Thanks for 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
It seems the user, that created the DB, cannot create tables on the DB.
The user "projeqtortest" can create table. If I use psql with this user on the DB "simu_lnbcdk", I can create a table intituled "test" :
projeqtortest=# c simu_lnbcdk Connexion SSL (protocole : TLSv1.3, chiffrement : TLS_AES_256_GCM_SHA384, bits : 256, compression : désactivé) Vous êtes maintenant connecté à la base de données « simu_lnbcdk » en tant qu'utilisateur « projeqtortest ». simu_lnbcdk=# create table test (col_test varchar(20)); CREATE TABLE simu_lnbcdk=# select * from test; col_test ---------- (0 ligne) simu_lnbcdk=# dt Liste des relations Schéma | Nom | Type | Propriétaire ---------------+------+-------+--------------- projeqtortest | test | table | projeqtortest (1 ligne)
“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
I tested creating the access profile of the table with the database table script projeqtortest which is as follows:
CREATE TABLE IF NOT EXISTS projeqtortest.accessprofile
(
id integer NOT NULL DEFAULT nextval('accessprofile_id_seq'::regclass),
name character varying(100) COLLATE pg_catalog."default" DEFAULT NULL::character varying,
description text COLLATE pg_catalog."default" DEFAULT NULL::character varying,
idaccessscoperead numeric(12,0) DEFAULT NULL::numeric,
idaccessscopecreate numeric(12,0) DEFAULT NULL::numeric,
idaccessscopeupdate numeric(12,0) DEFAULT NULL::numeric,
idaccessscopedelete numeric(12,0) DEFAULT NULL::numeric,
sortorder numeric(3,0) DEFAULT NULL::numeric,
idle numeric(1,0) DEFAULT '0'::numeric,
isnonproject numeric(1,0) DEFAULT 0,
isextended numeric(1,0) DEFAULT 0,
CONSTRAINT accessprofile_pkey PRIMARY KEY (id)
)
TABLESPACE pg_default;
And I get this error :
ERREUR: la relation « accessprofile_id_seq » n'existe pas
LIGNE 3 : id integer NOT NULL DEFAULT nextval('accessprofile_id_se...
I've tried to create sequence with script of projeqtortest's database which is as follow :
CREATE SEQUENCE IF NOT EXISTS projeqtortest.accessprofile_id_seq INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 OWNED BY accessprofile.id;
And I get this error :
ERREUR: la relation « accessprofile » n'existe pas
I have to delete the last line "OWNED BY accessprofile.id" If I want to succeed in creating the sequence.
After, I can create the table accessprofile without error.
I hope that could be help you to resolve this issue.
EDIT: Of course, I can create sequences & functions with projeqtortest user.
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
I've got this problem too...
I cannot delete a simulation database:
2022-06-16 17:10:07.585 ===== TRACE ===== Début de suppression d'un environnement de simulation - base test
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] ERROR **
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] on file '/var/www/html/projeqtor/model/DataCloning.php' at line (1102)
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] cause = Undefined variable: connexion
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] Undefined variable: connexion in DataCloning.php at line 1102
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] Error while executing CRON script : fix the source issue and manually restart the CRON Process
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] EXCEPTION **
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] on file '/var/www/html/projeqtor/model/DataCloning.php' at line (986)
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] cause = Call to a member function exec() on null
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] => #0 /var/www/html/projeqtor/tool/cronExecutionStandard.php (157) -> deleteDataCloning()
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] => #1 /var/www/html/projeqtor/model/Cron.php (547) -> dataCloningCheckRequest()
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] => #2 /var/www/html/projeqtor/tool/cronRun.php (33) -> run()
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] Call to a member function exec() on null
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] Exception while executing CRON script : fix the source issue and manually restart the CRON Process
2022-06-16 17:10:07.586 ** ERROR ** [V9.5.5] CRON abnormally stopped
Hi,
Last issue is different, you just cannot connect to the db with credentials.
Hi,
I have installed the V10 (congratulations for better performances ! ) and I always have the same issue:
2022-06-22 11:50:03.832 ----- DEBUG ----- => Create Table workperiod 2022-06-22 11:50:03.839 ----- DEBUG ----- => Create Table worktoken 2022-06-22 11:50:03.844 ----- DEBUG ----- => Create Table worktokenclientcontract 2022-06-22 11:50:03.850 ----- DEBUG ----- => Create Table worktokenclientcontractwork 2022-06-22 11:50:03.854 ----- DEBUG ----- => Create Table worktokenmarkup 2022-06-22 11:50:03.859 ----- DEBUG ----- => Create Table workunit 2022-06-22 11:50:03.860 ----- DEBUG ----- => Execute script to create all tables 2022-06-22 11:50:04.583 ** ERROR ** [V10.0.0] Erreur simulation - Impossible de créer la base de données 2022-06-22 11:50:04.583 ** ERROR ** [V10.0.0] SQLSTATE[42703]: Undefined column: 7 ERREUR: la colonne « id » de la relation « accessprofile » n'existe pas
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
OK,
So our technical improvment on V10 about UTF8 is not enough.
We keep the ticket open for further investigation.
Thanks for testing.