Forum

1ere install, impos...
 
Notifications
Clear all

1ere install, impossible de se connecter

11 Posts
3 Users
0 Reactions
14.5 K Views
(@hesiode)
Posts: 7
Active Member
Topic starter
 
[#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


 
Posted : 24 Sep 2014 16H28
(@babynus)
Posts: 14952
Member Admin
 

Please post in english.
_____

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


 
Posted : 24 Sep 2014 16H30
(@hesiode)
Posts: 7
Active Member
Topic starter
 

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..


 
Posted : 24 Sep 2014 16H33
(@hesiode)
Posts: 7
Active Member
Topic starter
 

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'


 
Posted : 24 Sep 2014 16H38
(@babynus)
Posts: 14952
Member 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 ?


 
Posted : 24 Sep 2014 18H32
(@hesiode)
Posts: 7
Active Member
Topic starter
 

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 ;


 
Posted : 24 Sep 2014 18H41
(@babynus)
Posts: 14952
Member 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.


 
Posted : 24 Sep 2014 22H21
(@hesiode)
Posts: 7
Active Member
Topic starter
 

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 ?


 
Posted : 25 Sep 2014 0H19
(@babynus)
Posts: 14952
Member 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)


 
Posted : 25 Sep 2014 1H30
(@hesiode)
Posts: 7
Active Member
Topic starter
 

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


 
Posted : 25 Sep 2014 23H51
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/

 
Posted : 26 Sep 2014 12H14
Share:

Scroll to Top