Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

admin pwd don't wor...
 
Notifications
Clear all

admin pwd don't work after online hosting

7 Posts
2 Users
0 Reactions
8,507 Views
(@lunch)
Posts: 6
Active Member
Topic starter
 
[#4774]

Dear all,
i have an existing website working perfectly
i created a sub-domaine inside to host Projeqtor
i have copied projeqtor files inside the folder properly
for the installation i have used the same database of the existing website
i can see the projeqtor interface display well but i can't get acces with admin/admin
please i need your help


 
Posted : 12 Nov 2017 17H01
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Try and clean cache and cookies


 
Posted : 12 Nov 2017 17H05
(@lunch)
Posts: 6
Active Member
Topic starter
 

Thank you for your faster response, i have cleaned cache and cookies of my browser but it still not working, see attached file;

please can you help?
Thank you


 
Posted : 12 Nov 2017 17H55
(@lunch)
Posts: 6
Active Member
Topic starter
 

I got a log file:

2017-11-12 15:45:24.151 ** ERROR ** [] ERROR **
2017-11-12 15:45:24.152
** ERROR ** [] on file '/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/tool/projeqtor.php' at line (2797)
2017-11-12 15:45:24.153
** ERROR ** [] cause = set_time_limit(): Cannot set max execution time limit due to system policy
2017-11-12 15:46:53.885
** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'atezcorporation.parameter' doesn't exist
2017-11-12 15:46:53.886
** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2017-11-12 15:46:53.887 ** ERROR ** [] Strack trace :
2017-11-12 15:46:53.887 ** ERROR ** [] #0 Sql->query called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2255]
2017-11-12 15:46:53.889 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/Parameter.php:895]
2017-11-12 15:46:53.890 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/UserMain.php:139]
2017-11-12 15:46:53.891 ** ERROR ** [] #3 UserMain->__construct called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/User.php:38]
2017-11-12 15:46:53.892 ** ERROR ** [] #4 User->__construct called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/tool/projeqtor.php:2939]
2017-11-12 15:46:53.893 ** ERROR ** [] #5 getSessionUser called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/tool/projeqtor.php:155]
2017-11-12 15:46:53.894 ** ERROR ** [] #6 require_once called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/view/main.php:37]
2017-11-12 15:47:30.740 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'atezcorporation.resource' doesn't exist
2017-11-12 15:47:30.742 ** ERROR ** [] For query : desc resource
2017-11-12 15:47:30.742 ** ERROR ** [] Strack trace :
2017-11-12 15:47:30.743 ** ERROR ** [] #0 Sql->query called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:3255]
2017-11-12 15:47:30.744 ** ERROR ** [] #1 SqlElement->getFormatList called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2836]
2017-11-12 15:47:30.744 ** ERROR ** [] #2 SqlElement->getDataType called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2218]
2017-11-12 15:47:30.745 ** ERROR ** [] #3 SqlElement->getSqlElementsFromCriteria called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2489]
2017-11-12 15:47:30.746 ** ERROR ** [] #4 SqlElement->getSingleSqlElementFromCriteria called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/tool/getHash.php:48]
2017-11-12 15:47:30.747 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'atezcorporation.resource' doesn't exist
2017-11-12 15:47:30.747 ** ERROR ** [] For query : select * from resource where resource.name='admin' and resource.isUser = '1'
2017-11-12 15:47:30.748 ** ERROR ** [] Strack trace :
2017-11-12 15:47:30.749 ** ERROR ** [] #0 Sql->query called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2255]
2017-11-12 15:47:30.750 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2489]
2017-11-12 15:47:30.751 ** ERROR ** [] #2 SqlElement->getSingleSqlElementFromCriteria called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/tool/getHash.php:48]


 
Posted : 12 Nov 2017 18H40
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

It seems acces to database is not correct.
Check config in parameters.php file.


 
Posted : 12 Nov 2017 19H26
(@lunch)
Posts: 6
Active Member
Topic starter
 

Here is my parameters.php
<?php
// =======================================================================================
// Automatically generated parameter file
// =======================================================================================
$paramDbType = 'mysql';
$paramDbHost = 'atezcorporation.com.mysql';
$paramDbPort = '3306';
$paramDbUser = 'atezcorporation';
$paramDbPassword = '##########';
$paramDbName = 'atezcorporation';
$paramDbDisplayName = 'projeqtor';
$paramDbPrefix = '';
$SslKey = '';
$SslCert = '';
$SslCa = '';
$paramLdap_allow_login = 'false';
$paramLdap_base_dn = 'dc=mydomain,dc=com';
$paramLdap_host = '127.0.0.1';
$paramLdap_port = '389';
$paramLdap_version = '3';
$paramLdap_search_user = 'cn=Manager,dc=mydomain,dc=com';
$paramLdap_search_pass = 'secret';
$paramLdap_user_filter = 'uid=%USERNAME%';
$paramMailSender = '';
$paramMailReplyTo = '';
$paramAdminMail = '';
$paramMailSmtpServer = '127.0.0.1';
$paramMailSmtpPort = '25';
$paramMailSendmailPath = '';
$paramDefaultPassword = 'projeqtor';
$paramPasswordMinLength = '5';
$paramDefaultLocale = 'fr';
$paramDefaultTimezone = 'Africa/Douala';
$currency = 'XAF';
$currencyPosition = 'after';
$paramFadeLoadingMode = 'true';
$paramIconSize = '22';
$defaultTheme = 'ProjeQtOrFlatBlue';
$paramAttachmentDirectory = '../files/attach/';
$paramAttachmentMaxSize = '2097152';
$paramReportTempDirectory = '../files/report/';
$paramMemoryLimitForPDF = '512';
$logFile = '../files/logs/projeqtor_${date}.log';
$logLevel = '2';


 
Posted : 12 Nov 2017 23H14
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

OK.
You are on first steps of installation.
Your database is empty, and possibly does not exist.
Check that database exists and is empty.
If it does not exist, you'll have to create it manually, as you use a hosted space, and your provider will rejet automatic creation.
If it exists and is not empty, possibly you use it for another application, so use dedicate paramDbPrefix to avoid conflicts


 
Posted : 13 Nov 2017 18H59
Share:

Scroll to Top