Forum

1ere install, impos...
 
Notifications
Retirer tout

1ere install, impossible de se connecter

11 Posts
3 Utilisateurs
0 Reactions
14.5 {numéro}K Vu
(@hesiode)
Posts: 7
Active Member
Début du sujet
 
[#2012]

Bonjour,

je viens de faire une 1ere install tout propre toute neuve et je ne peux pas me connecter avec admin/admin il me met :
"Paramètres de connexion incorrects"

Alors que dans la base table resource, tout me parait OK.

merci


 
Posté : 24 Sep PM 16:099
(@babynus)
Posts: 14952
Membre Admin
 

Please post in english.
_____

Try and refresh browser cache (F5) and try again.


 
Posté : 24 Sep PM 16:099
(@hesiode)
Posts: 7
Active Member
Début du sujet
 

Ok

I just install projeqtor for the first time, and i cant to connect with admin/admin.

i have this message :
"Invalid login parameters"

In the database, resource table, i have 2 lines admin & Guest with good password (21232f297a57a5a743894a0e4a801fc3 => admin) but dont work..


 
Posté : 24 Sep PM 16:099
(@hesiode)
Posts: 7
Active Member
Début du sujet
 

Log :

2014-09-24 14:37:11 ** ERROR ** Error on SqlElement to get 'loginTry' for Class 'User' : field 'loginTry' not found in Database.
2014-09-24 14:37:11 ** ERROR ** Error on SqlElement to get 'apiKey' for Class 'User' : field 'apiKey' not found in Database.
2014-09-24 14:37:11 ** ERROR ** Error on SqlElement to get 'dontReceiveTeamMails' for Class 'User' : field 'dontReceiveTeamMails' not fo
und in Database.
2014-09-24 14:37:11 ** ERROR ** Error on SqlElement to get 'salt' for Class 'User' : field 'salt' not found in Database.
2014-09-24 14:37:11 ** ERROR ** Error on SqlElement to get 'crypto' for Class 'User' : field 'crypto' not found in Database.
2014-09-24 14:37:11 ** ERROR ** Error on SqlElement to get 'cookieHash' for Class 'User' : field 'cookieHash' not found in Database.
2014-09-24 14:37:11 ** ERROR ** Error on SqlElement to get 'passwordChangeDate' for Class 'User' : field 'passwordChangeDate' not found
in Database.
2014-09-24 14:37:11 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exis
t
2014-09-24 14:37:11 ** ERROR ** For query : desc user
2014-09-24 14:37:11 ** ERROR ** Strack trace :
2014-09-24 14:37:11 ** ERROR ** #0 Sql->query called at [*/www/model/persisten
ce/SqlElement.php:2107]
2014-09-24 14:37:11 ** ERROR ** #1 SqlElement->getFormatList called at [*/www/
model/persistence/SqlElement.php:1875]
2014-09-24 14:37:11 ** ERROR ** #2 SqlElement->getDataType called at [*/www/mo
del/persistence/SqlElement.php:1412]
2014-09-24 14:37:11 ** ERROR ** #3 SqlElement->getSqlElementsFromCriteria called at [*/www/tool/loginCheck.php:36]
2014-09-24 14:37:11 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exis
t
2014-09-24 14:37:11 ** ERROR ** For query : select * from user where user.name='admin' and user.isUser = '1'
2014-09-24 14:37:11 ** ERROR ** Strack trace :
2014-09-24 14:37:11 ** ERROR ** #0 Sql->query called at [/*/www/model/persisten
ce/SqlElement.php:1445]
2014-09-24 14:37:11 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [*/www/tool/loginCheck.php:36]
2014-09-24 14:37:11 ===== TRACE ===== Login error for user 'admin'


 
Posté : 24 Sep PM 16:099
(@babynus)
Posts: 14952
Membre Admin
 

Logs show the database is not correct.
Some required fields are missing intale Resource.

Did you have any error while installing ?
Are you installing new version over existing database ?


 
Posté : 24 Sep PM 18:099
(@hesiode)
Posts: 7
Active Member
Début du sujet
 

No errors while installing.
Its new version, i tried 3 times, 3 times dont work.
I have 107 tables in my database.

In log it say :
select * from user where user.name='admin' and user.isUser = '1'

But in database file i dont have sql who create this table, but i have "resource" :

--
-- Structure de la TABLE `${prefix}resource` (old name = user)
--

CREATE TABLE `${prefix}resource` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`fullName` varchar(100) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`description` varchar(4000) DEFAULT NULL,
`password` varchar(100) DEFAULT NULL,
`idProfile` int(12) DEFAULT NULL,
`isResource` int(1) unsigned DEFAULT '0',
`isUser` int(1) unsigned DEFAULT '0',
`locked` int(1) unsigned DEFAULT '0',
`idle` int(1) unsigned DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;


 
Posté : 24 Sep PM 18:099
(@babynus)
Posts: 14952
Membre Admin
 

Hi,

Table "user" has been replaced with table "resource" in V3.0.0, for PostgreSql compatibility.
So it is normal you don't have a "user" table.

The select for "user" gives me a hint.
It seems some test gives a weird result on your configuration.
1) On what OS / version is running your PHP server ?
What version of PHP ?
What version of MySql ?

2) could you check content of parameterValue in table parameter for parameterCode='dbVersion'
What version do you get ?

3) can you try simply to comment line 32 in /tool/loginCheck.php

//User::setOldUserStyle();

and try to connect again

4) if it works, could you please try to replace lines 31 to 33 in /tool/loginCheck.php with this :

  if (Sql::getDbVersion() and Sql::getDbVersion()!=$version and version_compare(substr(Sql::getDbVersion(),1), '3.0.0','<')) {
  	User::setOldUserStyle();
  }

Test again. If it works, I'll keep this as fix for next version.


 
Posté : 24 Sep PM 22:099
(@hesiode)
Posts: 7
Active Member
Début du sujet
 

1/ Linux CentOS 6.4
php 5.4.32
mysql 5.5

2/ 0.3.0 (??)
in projektor.php i have 4.4.2

in logs i feel script stop before end :
the last line :
2014-09-24 22:01:24 ===== TRACE ===== =====================================
2014-09-24 22:01:24 ===== TRACE =====
2014-09-24 22:01:24 ===== TRACE ===== VERSION V3.2.0
2014-09-24 22:01:24 ===== TRACE =====
2014-09-24 22:01:24 ===== TRACE ===== Table "opportunity" altered.
2014-09-24 22:01:25 ===== TRACE ===== Table "risk" altered.
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "importable".
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "linkable".
2014-09-24 22:01:25 ===== TRACE ===== Table "health" created.
2014-09-24 22:01:25 ===== TRACE ===== 5 lines inserted into table "health".
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "menu".
2014-09-24 22:01:25 ===== TRACE ===== 7 lines inserted into table "habilitation".
2014-09-24 22:01:25 ===== TRACE ===== Table "project" altered.
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "report".
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "reportparameter".
2014-09-24 22:01:25 ===== TRACE ===== Table "audit" created.
2014-09-24 22:01:25 ===== TRACE ===== Index "auditUser" created.
2014-09-24 22:01:25 ===== TRACE ===== Index "auditSessionId" created.
2014-09-24 22:01:25 ===== TRACE ===== 1 lines inserted into table "menu".
2014-09-24 22:01:25 ===== TRACE ===== 7 lines inserted into table "habilitation".
2014-09-24 22:01:25 ===== TRACE ===== Table "auditsummary" created.

I do a new install and its the same thing (but not at the same place) :
2014-09-24 22:17:42 ===== TRACE ===== =====================================
2014-09-24 22:17:42 ===== TRACE =====
2014-09-24 22:17:42 ===== TRACE ===== VERSION V3.3.0
2014-09-24 22:17:42 ===== TRACE =====
2014-09-24 22:17:42 ===== TRACE ===== Table "today" created.
2014-09-24 22:17:43 ===== TRACE ===== Index "todayUser" created.
2014-09-24 22:17:43 ===== TRACE ===== Table "todayparameter" created.
2014-09-24 22:17:43 ===== TRACE ===== Index "todayParameterUser" created.
2014-09-24 22:17:43 ===== TRACE ===== Index "todayParameterReport" created.
2014-09-24 22:17:43 ===== TRACE ===== Index "todayParameterToiday" created.
2014-09-24 22:17:43 ===== TRACE ===== 2 lines inserted into table "today".
2014-09-24 22:17:43 ===== TRACE ===== 2 lines inserted into table "today".
2014-09-24 22:17:43 ===== TRACE ===== 2 lines inserted into table "today".
2014-09-24 22:17:43 ===== TRACE ===== 2 lines inserted into table "today".
2014-09-24 22:17:43 ===== TRACE ===== 2 lines inserted into table "today".

may be i should increase set_time_limit ?


 
Posté : 25 Sep AM 00:099
(@babynus)
Posts: 14952
Membre Admin
 

You're right, the issue is here : upgrade is uncomplete.

I should have checked on your previous post : you must get 127 tables.

You solution is correct : increase set_tilme_limit
In fact the script does it, if PHP setting allows it.

Another way is to update database step by step, playing wih $version in /tool/projeqtor.php.
(usefull for hosted versions when provider will not change set_time_limit)
Fist set to V1.0.0 and go to login screen (that should show upgrade in progress message) and log in as admin.
Don't go further, set $version to V2.0.0 and do same thing again.
And so on until you get to V4.4.2.
To go faster, as log file shows, you can go directly to V3.3.0 and then to V4.4.2 (two steps only)


 
Posté : 25 Sep AM 01:099
(@hesiode)
Posts: 7
Active Member
Début du sujet
 

Hi,

Finally i have make install on my local computer and i make database dump and import on my server.
Dont know why my server is so slow...

Anyway, thank you for your help


 
Posté : 25 Sep PM 23:099
VAUCHEY
(@protion)
Posts: 138
Active Member
 

Hello

The slowness has to come from the hardware configuration or software emulation php, not the soft
------------------------------------------------------------------------------------------------------
Bonjour

La lenteur doit venir de la configuration matériel ou du logiciel d'émulation php, et non du soft


http://www.vkv.iea45.fr/

 
Posté : 26 Sep PM 12:099
Share:
Retour en haut