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
Please post in english.
_____
Try and refresh browser cache (F5) and try again.
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..
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'
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 ?
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 ;
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.
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 ?
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)
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
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/