Forum

Forums
Requests
Ask questions
Upgrade in progress...
 
Notifications
Retirer tout

Upgrade in progress Only admin user can connect.

 
Page 3 / 4
Ask questions
Dernier post par Sebastian Il y a 10 ans
47 Posts
3 Utilisateurs
0 Reactions
40.3 {numéro}K Vu
RSS
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

Thanks, this helps but I still need more debuggin.
Attached is another patch with extra debugging.
Thanks to operate as previously

projeqtor_2016-10-19-2.zip

 
Posté : 19 Oct PM 14:1010
 Fernando Sierra
(@gnduser)
Posts: 42
Active Member
Début du sujet
 

Output in the log is

2016-10-19 14:53:53.058 ----- DEBUG ----- loginCheck : no user with name 'admin'
2016-10-19 14:53:53.058 ===== TRACE ===== Login error for user 'admin'

Do you need some other log content?


 
Posté : 19 Oct PM 15:1010
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

Very Strange.
Logs seem to tell your database is not empty :silly:

Here is another patch with some extra log to try and understand

projeqtor_2016-10-19-3.zip

 
Posté : 19 Oct PM 16:1010
 Fernando Sierra
(@gnduser)
Posts: 42
Active Member
Début du sujet
 

2016-10-19 17:46:05.414 ----- DEBUG ----- loginCheck : current db version = 'V0.3.0'
2016-10-19 17:46:05.414 ----- DEBUG ----- loginCheck : no user with name 'admin'
2016-10-19 17:46:05.415 ===== TRACE ===== Login error for user 'admin'

Thanks for long time dedicated to this topic


 
Posté : 19 Oct PM 18:1010
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

Your database is not empty.
Try and delete all tables in the database.


 
Posté : 19 Oct PM 18:1010
 Fernando Sierra
(@gnduser)
Posts: 42
Active Member
Début du sujet
 

Delete or empty?

All of them?


 
Posté : 19 Oct PM 18:1010
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

Delete (drop table)
Yes, all tables in projeqtor database.
On first install database should be empty.


 
Posté : 19 Oct PM 18:1010
 Fernando Sierra
(@gnduser)
Posts: 42
Active Member
Début du sujet
 

empty database.

Load th web and after neraly a minute appears this:

ERROR : error_log(../files/config/parameters.php): failed to open stream: Permission denied
in file.php
at line 32


 
Posté : 19 Oct PM 18:1010
 Fernando Sierra
(@gnduser)
Posts: 42
Active Member
Début du sujet
 

Projqtor log...(only final lines)
2016-10-19 18:29:18.696 ** ERROR ** ERROR **
2016-10-19 18:29:18.696 ** ERROR ** on file '/var/www/html/projeqtor/tool/file.php' at line (32)
2016-10-19 18:29:18.696 ** ERROR ** cause = error_log(../files/config/parameters.php): failed to open strea$
2016-10-19 18:29:45.060 ----- DEBUG ----- loginCheck : current db version = 'V0.3.0'
2016-10-19 18:29:45.061 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 T$
2016-10-19 18:29:45.061 ** ERROR ***** For query : select * from user where user.name='admin' and user.isUs$
2016-10-19 18:29:45.061 ** ERROR ** Strack trace :
2016-10-19 18:29:45.061 ** ERROR ** #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/S$
2016-10-19 18:29:45.061 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/p$
2016-10-19 18:29:45.061 ----- DEBUG ----- loginCheck : no user with name 'admin'
2016-10-19 18:29:45.061 ===== TRACE ===== Login error for user 'admin'
2016-10-19 18:29:49.791 ----- DEBUG ----- loginCheck : current db version = 'V0.3.0'
2016-10-19 18:29:49.792 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 T$
2016-10-19 18:29:49.792 ** ERROR ** For query : select * from user where user.name='admin' and user.isUs$
2016-10-19 18:29:49.792 ** ERROR ** Strack trace :
2016-10-19 18:29:49.792 ** ERROR ** #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/S$
2016-10-19 18:29:49.792 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/p$
2016-10-19 18:29:49.792 ----- DEBUG ----- loginCheck : no user with name 'admin'
2016-10-19 18:29:49.792 ===== TRACE ===== Login error for user 'admin'


 
Posté : 19 Oct PM 18:1010
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

PorjeQtOr need to write in parameters.php, and this file is readonly...

have all r/w during install process to avoid this.

chmod -R 777 /var/www/html/preojeqtor

you'll reverse to 755 when all is OK.

NB : some tables may have been created, drop all again before retry.


 
Posté : 19 Oct PM 18:1010
 Fernando Sierra
(@gnduser)
Posts: 42
Active Member
Début du sujet
 

Solved...working

Thank you very much for your time.


 
Posté : 19 Oct PM 19:1010
 Sebastian
(@sebas13)
Posts: 4
New Member
 

Hi
I'm trying to install projeqtor in an machine with windows server 2008 x64, but always I have the message of "Upgrade in progress" and when I try to login with admin/admin I have the message "Invalid login parameters". I tried to change the attributes of folder of projeqtor but I have the problem yet. If you can help me please with some tip or suggestion I'd appreciate it very much.

Best regards
Sebastian

2016-10-25 13:06:26.643 ..... SCRIPT .... ::1 /projeqtor/view/index.php
2016-10-25 13:06:26.947 ..... SCRIPT .... ::1 /projeqtor/view/main.php
2016-10-25 13:06:26.965 ..... SCRIPT .... ::1 Page=main.php
2016-10-25 13:06:26.966 ..... SCRIPT .... ::1 ->/view/login.php
2016-10-25 13:06:27.665 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 13:06:27.701 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 13:06:27.714 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 13:06:27.733 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 13:06:27.744 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 13:06:27.766 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 13:06:27.778 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 13:06:27.799 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 13:06:27.811 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 13:06:27.834 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 13:06:27.846 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 13:06:27.870 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 13:22:07.426 ..... SCRIPT .... ::1 /projeqtor/tool/getHash.php
2016-10-25 13:22:07.445 ..... SCRIPT .... ::1 Page=getHash.php
2016-10-25 13:22:07.505 ..... SCRIPT .... ::1 /projeqtor/tool/loginCheck.php
2016-10-25 13:22:07.522 ..... SCRIPT .... ::1 Page=loginCheck.php
2016-10-25 13:22:07.524 ..... SCRIPT .... ::1 ->/tool/loginCheck.php
2016-10-25 13:22:07.558 ===== TRACE ===== Login error for user 'admin'


 
Posté : 25 Oct PM 16:1010
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

In most cases, errors on first connection are due to incorrect LDAP pârameters.
Try and remove all LDAP parameters in parameters.php and test again.


 
Posté : 25 Oct PM 16:1010
 Sebastian
(@sebas13)
Posts: 4
New Member
 

I removed all
$paramLdap_allow_login = 'false';
$paramLdap_base_dn = '';
$paramLdap_host = '';
$paramLdap_port = '';
$paramLdap_version = '';

but I have the problem yet

2016-10-25 14:46:17.173 ..... SCRIPT .... ::1 /projeqtor/view/main.php
2016-10-25 14:46:17.192 ..... SCRIPT .... ::1 Page=main.php
2016-10-25 14:46:17.193 ..... SCRIPT .... ::1 ->/view/login.php
2016-10-25 14:46:17.971 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 14:46:17.992 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 14:46:18.000 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 14:46:18.013 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 14:46:18.021 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 14:46:18.037 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 14:46:18.043 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 14:46:18.060 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 14:46:18.069 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 14:46:18.079 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 14:46:18.086 ..... SCRIPT .... ::1 /projeqtor/tool/saveDataToSession.php
2016-10-25 14:46:18.104 ..... SCRIPT .... ::1 Page=saveDataToSession.php
2016-10-25 14:46:26.780 ..... SCRIPT .... ::1 /projeqtor/tool/getHash.php
2016-10-25 14:46:26.797 ..... SCRIPT .... ::1 Page=getHash.php
2016-10-25 14:46:26.855 ..... SCRIPT .... ::1 /projeqtor/tool/loginCheck.php
2016-10-25 14:46:26.873 ..... SCRIPT .... ::1 Page=loginCheck.php
2016-10-25 14:46:26.875 ..... SCRIPT .... ::1 ->/tool/loginCheck.php
2016-10-25 14:46:26.884 ===== TRACE ===== Login error for user 'admin'


 
Posté : 25 Oct PM 16:1010
 Sebastian
(@sebas13)
Posts: 4
New Member
 

Hi
Thanks for your soon answer, I don't know if it's possible that the decrypting function don't work fine, because I find that the program make an AES 256 encryptation and the IIS only work with 128.

Bye
thanks


 
Posté : 26 Oct AM 10:1010
Page 3 / 4
Forum Jump:
  Sujet précédent
Sujet suivant  
Share:
Retour en haut