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.

Conflict between Pr...
 
Notifications
Clear all

Conflict between ProjeQtOr and Bitnami SuiteCRM

10 Posts
2 Users
0 Reactions
8,747 Views
(@eliot)
Posts: 5
Active Member
Topic starter
 
[#2628]

Hello everyone,

We have installed a PHP application named "Bitnami SuiteCRM" and, after that, we installed ProjeQtOr, using the Apache and MySQL servers SuiteCRM had installed.

The problem is we can't run ProjeQtor properly when we use the same brower to open both applications.

Here are the steps :
1. Login to ProjeQtor
2. Browse ProjeQtOr. No problem.
3. Login to SuiteCRM in another tab.
4. Try to browse ProjeqtOr. Nothing happens anymore when you click the menu.

The problem only occurs when the same user uses the same browser to access both applications. So this seems to be a SESSION issue.

I have been investigating and found that a ticket had already been opened about a SESSION problem:

Ticket #1729: Store current user out of $_SESSION['user'] to avoid conflict with other applications

But this issue seems to have been fixed with 5.0.1... and we use 5.0.5.

Any idea?

Thanks for sharing knowledge.


 
Posted : 29 Sep 2015 18H58
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Conflict may come from other share value.
To be sure, could you add 1 line on line 129 of /tool/projeqtor.php, like this :

/*
 * ============================================================================ main controls ============================================================================
 */
debugLog($_SESSION);

Then run test (blocking one), retrieve projeqtor log file and post it here (or send it to support@projeqtor.org)

Thanks.


 
Posted : 29 Sep 2015 22H09
(@eliot)
Posts: 5
Active Member
Topic starter
 

Thanks for your answer, babynus.
Which log file do you need?

EDIT: I found this one: "projeqtorfileslogsprojeqtor_20150930.log"
I paste it below (I only changed the username mentioned).

2015-09-30 09:55:06.054 ===== TRACE ===== NEW CONNECTED USER 'eliot'
2015-09-30 11:07:58.681 ===== TRACE ===== NEW CONNECTED USER 'eliot'

Nothing special. It just mentions my two connection tests this morning.


 
Posted : 30 Sep 2015 12H58
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

ProjeQtOr log file.
By default it is stored in /files/logs : 1 file per day.
Log files are also available through admin screen in ProjeQtOr (you don't have to connect to server to download log file...)


 
Posted : 30 Sep 2015 13H15
(@eliot)
Posts: 5
Active Member
Topic starter
 

I found it while you were answering (I edited my previous post).


 
Posted : 30 Sep 2015 13H19
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Sorry, you also have to change log level to 3 in parameters.php file :

$logLevel='3';

 
Posted : 30 Sep 2015 14H54
(@eliot)
Posts: 5
Active Member
Topic starter
 

There are 2 parameters.php files :
- "projeqtorfilesconfigparameters.php"
- "projeqtortoolparameters.php"

I did not know which one I had to edit so I edited both.

As a result, the log file size dramatically increased (more than 70,000 lines whereas I only logged and tried to browse).
Do you want me to search for something inside instead of posting/sending such a big file?


 
Posted : 30 Sep 2015 16H08
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

You can post whole file or just last 1000 lines , as you want.


 
Posted : 30 Sep 2015 16H32
(@eliot)
Posts: 5
Active Member
Topic starter
 

So please find below the last 1,000 lines of the log file.

Here are the steps I followed this time :
1. Login to ProjeQtOr
2. Browse ProjeQtOr. Everything's ok.
3. Display the login page of SuiteCRM in another tab, without even actually logging in.
4. Try to Browse ProjeQtOr. The login page of ProjeQtOr appears in the main frame of the page.

Seems like the login page of SuiteCRM manages to destroy the session initiated by ProjeQtoR.

The log:

2015-09-30 13:50:53.088 ----- DEBUG -----         Users => Array 
2015-09-30 13:50:53.090 ----- DEBUG -----         Array[1]
2015-09-30 13:50:53.092 ----- DEBUG -----            module => Array 
2015-09-30 13:50:53.093 ----- DEBUG -----            Array[8]
2015-09-30 13:50:53.095 ----- DEBUG -----               access => Array 
2015-09-30 13:50:53.097 ----- DEBUG -----               Array[3]
2015-09-30 13:50:53.098 ----- DEBUG -----                  id => 90caa4d7-0ba6-0046-474a-54c21d4f8765
2015-09-30 13:50:53.100 ----- DEBUG -----                  aclaccess => 89
2015-09-30 13:50:53.102 ----- DEBUG -----                  isDefault => 1
2015-09-30 13:50:53.105 ----- DEBUG -----               delete => Array 
2015-09-30 13:50:53.107 ----- DEBUG -----               Array[3]
2015-09-30 13:50:53.108 ----- DEBUG -----                  id => 9499aef5-f90a-4b58-229c-54c21d058db4
2015-09-30 13:50:53.110 ----- DEBUG -----                  aclaccess => 90
2015-09-30 13:50:53.112 ----- DEBUG -----                  isDefault => 1
2015-09-30 13:50:53.115 ----- DEBUG -----               edit => Array 
2015-09-30 13:50:53.117 ----- DEBUG -----               Array[3]
2015-09-30 13:50:53.118 ----- DEBUG -----                  id => 9499ae7b-a660-1209-55f9-54c21d28cfea
2015-09-30 13:50:53.120 ----- DEBUG -----                  aclaccess => 90
2015-09-30 13:50:53.122 ----- DEBUG -----                  isDefault => 1
2015-09-30 13:50:53.125 ----- DEBUG -----               export => Array 
2015-09-30 13:50:53.127 ----- DEBUG -----               Array[3]
2015-09-30 13:50:53.128 ----- DEBUG -----                  id => 98689f3d-76d3-32f3-7c15-54c21dbf79c4
2015-09-30 13:50:53.130 ----- DEBUG -----                  aclaccess => 90
2015-09-30 13:50:53.132 ----- DEBUG -----                  isDefault => 1
2015-09-30 13:50:53.135 ----- DEBUG -----               import => Array 
2015-09-30 13:50:53.137 ----- DEBUG -----               Array[3]
2015-09-30 13:50:53.138 ----- DEBUG -----                  id => 9499abbb-7a7c-2109-4e67-54c21db7a58f
2015-09-30 13:50:53.140 ----- DEBUG -----                  aclaccess => 90
2015-09-30 13:50:53.142 ----- DEBUG -----                  isDefault => 1
2015-09-30 13:50:53.145 ----- DEBUG -----               list => Array 
2015-09-30 13:50:53.147 ----- DEBUG -----               Array[3]
2015-09-30 13:50:53.148 ----- DEBUG -----                  id => 9499aa99-4b68-1834-e1e3-54c21d83bb8c
2015-09-30 13:50:53.150 ----- DEBUG -----                  aclaccess => 90
2015-09-30 13:50:53.152 ----- DEBUG -----                  isDefault => 1
2015-09-30 13:50:53.155 ----- DEBUG -----               massupdate => Array 
2015-09-30 13:50:53.156 ----- DEBUG -----               Array[3]
2015-09-30 13:50:53.158 ----- DEBUG -----                  id => 986897fe-2378-01c6-5743-54c21d84f321
2015-09-30 13:50:53.160 ----- DEBUG -----                  aclaccess => 90
2015-09-30 13:50:53.162 ----- DEBUG -----                  isDefault => 1
2015-09-30 13:50:53.165 ----- DEBUG -----               view => Array 
2015-09-30 13:50:53.166 ----- DEBUG -----               Array[3]
2015-09-30 13:50:53.168 ----- DEBUG -----                  id => 90caaadf-0243-4bd6-1f07-54c21d944d66
2015-09-30 13:50:53.170 ----- DEBUG -----                  aclaccess => 90
2015-09-30 13:50:53.172 ----- DEBUG -----                  isDefault => 1
2015-09-30 13:50:53.181 ----- DEBUG -----   login_user_name => 
2015-09-30 13:50:53.183 ----- DEBUG -----   login_password => 
2015-09-30 13:50:53.184 ----- DEBUG -----   lpage => 1443613820
2015-09-30 13:50:53.186 ----- DEBUG -----   lang => fr
2015-09-30 13:50:53.188 ----- DEBUG -----   globalParamatersArray => Array 
2015-09-30 13:50:53.189 ----- DEBUG -----   Array[110]
2015-09-30 13:50:53.191 ----- DEBUG -----      dbVersion => V5.0.5
2015-09-30 13:50:53.193 ----- DEBUG -----      startAM => 08:00
2015-09-30 13:50:53.194 ----- DEBUG -----      endAM => 12:00
2015-09-30 13:50:53.196 ----- DEBUG -----      startPM => 14:00
2015-09-30 13:50:53.198 ----- DEBUG -----      endPM => 18:00
2015-09-30 13:50:53.199 ----- DEBUG -----      dayTime => 8.00
2015-09-30 13:50:53.201 ----- DEBUG -----      alertCheckTime => 60
2015-09-30 13:50:53.203 ----- DEBUG -----      cronSleepTime => 10
2015-09-30 13:50:53.204 ----- DEBUG -----      cronCheckDates => 30
2015-09-30 13:50:53.206 ----- DEBUG -----      ldapDefaultProfile => 5
2015-09-30 13:50:53.208 ----- DEBUG -----      ldapMsgOnUserCreation => NO
2015-09-30 13:50:53.209 ----- DEBUG -----      csvSeparator => ;
2015-09-30 13:50:53.211 ----- DEBUG -----      referenceFormatPrefix => {PROJ}-{TYPE}-
2015-09-30 13:50:53.213 ----- DEBUG -----      changeReferenceOnTypeChange => NO
2015-09-30 13:50:53.215 ----- DEBUG -----      draftSeparator => _draft
2015-09-30 13:50:53.216 ----- DEBUG -----      documentRoot => ../files/documents
2015-09-30 13:50:53.218 ----- DEBUG -----      billPrefix => BILL
2015-09-30 13:50:53.220 ----- DEBUG -----      billSuffix => _FR
2015-09-30 13:50:53.221 ----- DEBUG -----      billNumSize => 5
2015-09-30 13:50:53.223 ----- DEBUG -----      billNumStart => 10000
2015-09-30 13:50:53.225 ----- DEBUG -----      displayResourcePlan => initials
2015-09-30 13:50:53.226 ----- DEBUG -----      maxProjectsToDisplay => 25
2015-09-30 13:50:53.228 ----- DEBUG -----      paramMailTitleStatus => [${dbName}] ${item} #${id} moved to status '${status}' : "${name}"
2015-09-30 13:50:53.230 ----- DEBUG -----      paramMailTitleResponsible => [${dbName}] ${responsible} is now responsible of ${item} #${id} : "${name}"
2015-09-30 13:50:53.231 ----- DEBUG -----      paramMailTitleNote => [${dbName}] New note has been posted on ${item} #${id} : "${name}"
2015-09-30 13:50:53.233 ----- DEBUG -----      paramMailTitleAttachment => [${dbName}] New attachment has been posted on ${item} #${id} : "${name}"
2015-09-30 13:50:53.235 ----- DEBUG -----      paramMailTitleNew => [${dbName}] ${item} #${id} has been created : "${name}"
2015-09-30 13:50:53.236 ----- DEBUG -----      cronCheckImport => 60
2015-09-30 13:50:53.238 ----- DEBUG -----      cronImportDirectory => ../files/import
2015-09-30 13:50:53.240 ----- DEBUG -----      cronImportLogDestination => file
2015-09-30 13:50:53.241 ----- DEBUG -----      cronImportMailList => 
2015-09-30 13:50:53.243 ----- DEBUG -----      cronDirectory => ../files/cron
2015-09-30 13:50:53.245 ----- DEBUG -----      paramMailTitleDirect => [${dbName}] message from ${sender} : ${item} #${id}
2015-09-30 13:50:53.247 ----- DEBUG -----      maxItemsInTodayLists => 100
2015-09-30 13:50:53.248 ----- DEBUG -----      msgClosedApplication => Application is closed. 
Only admin user can connect. 
Please come back later.
2015-09-30 13:50:53.250 ----- DEBUG -----      paramMailBodyUser => You are welcome to ${dbName} at ${url}.
Your login is ${login}.
Your password is initialized to ${password}
You will have to change it on first connection.

In case of an issue contact your administrator at ${adminMail}. 2015-09-30 13:50:53.252 ----- DEBUG ----- paramMailTitleUser => [${dbName}] message from ${sender} : Your account information 2015-09-30 13:50:53.253 ----- DEBUG ----- paramMailTitleNoteChange => [${dbName}] A note has been modified on ${item} #${id} : "${name}" 2015-09-30 13:50:53.255 ----- DEBUG ----- paramMailTitleDescription => [${dbName}] Description has been modified on ${item} #${id} : "${name}" 2015-09-30 13:50:53.257 ----- DEBUG ----- paramMailTitleResult => [${dbName}] Result has been modified on ${item} #${id} : "${name} 2015-09-30 13:50:53.258 ----- DEBUG ----- paramMailTitleAssignment => [${dbName}] New assignment has been added on ${item} #${id} : "${name}" 2015-09-30 13:50:53.260 ----- DEBUG ----- paramMailTitleAssignmentChange => [${dbName}] An assignment has been modified on ${item} #${id} : "${name}" 2015-09-30 13:50:53.262 ----- DEBUG ----- paramMailTitleAnyChange => [${dbName}] ${item} #${id} has been modified : "${name}" 2015-09-30 13:50:53.263 ----- DEBUG ----- documentReferenceFormat => {PROJ}-{TYPE}-{NUM}-{NAME} 2015-09-30 13:50:53.265 ----- DEBUG ----- versionReferenceSuffix => -{VERS} 2015-09-30 13:50:53.267 ----- DEBUG ----- realWorkOnlyForResponsible => NO 2015-09-30 13:50:53.268 ----- DEBUG ----- maxDaysToBookWork => 5 2015-09-30 13:50:53.270 ----- DEBUG ----- cronCheckEmails => -1 2015-09-30 13:50:53.272 ----- DEBUG ----- paramTopIconSize => 32 2015-09-30 13:50:53.274 ----- DEBUG ----- paramMailTitleApprover => [${dbName}] message from ${sender} : You need to approve a document 2015-09-30 13:50:53.275 ----- DEBUG ----- paramMailBodyApprover => [${dbName}] You are approver of Document #${id} : "${name}".
Please access this document and follow approval process. 2015-09-30 13:50:53.277 ----- DEBUG ----- consolidateValidated => IFSET 2015-09-30 13:50:53.279 ----- DEBUG ----- paramDbDisplayName => Gestion projet 2015-09-30 13:50:53.280 ----- DEBUG ----- paramMailTitle => 2015-09-30 13:50:53.282 ----- DEBUG ----- paramMailMessage => 2015-09-30 13:50:53.284 ----- DEBUG ----- paramMailSender => 2015-09-30 13:50:53.285 ----- DEBUG ----- paramMailReplyTo => 2015-09-30 13:50:53.287 ----- DEBUG ----- paramAdminMail => 2015-09-30 13:50:53.289 ----- DEBUG ----- paramMailSmtpServer => localhost 2015-09-30 13:50:53.290 ----- DEBUG ----- paramMailSmtpPort => 25 2015-09-30 13:50:53.292 ----- DEBUG ----- paramMailSendmailPath => 2015-09-30 13:50:53.294 ----- DEBUG ----- paramMailShowDetail => 2015-09-30 13:50:53.295 ----- DEBUG ----- paramLdap_allow_login => false 2015-09-30 13:50:53.297 ----- DEBUG ----- paramLdap_base_dn => dc=mydomain,dc=com 2015-09-30 13:50:53.299 ----- DEBUG ----- paramLdap_host => localhost 2015-09-30 13:50:53.300 ----- DEBUG ----- paramLdap_port => 389 2015-09-30 13:50:53.302 ----- DEBUG ----- paramLdap_version => 3 2015-09-30 13:50:53.304 ----- DEBUG ----- paramLdap_search_user => cn=Manager,dc=mydomain,dc=com 2015-09-30 13:50:53.305 ----- DEBUG ----- paramLdap_search_pass => secret 2015-09-30 13:50:53.307 ----- DEBUG ----- paramLdap_user_filter => uid=%USERNAME% 2015-09-30 13:50:53.309 ----- DEBUG ----- paramDefaultPassword => projeqtor 2015-09-30 13:50:53.310 ----- DEBUG ----- paramPasswordMinLength => 5 2015-09-30 13:50:53.312 ----- DEBUG ----- lockPassword => 2015-09-30 13:50:53.314 ----- DEBUG ----- paramDefaultLocale => fr 2015-09-30 13:50:53.316 ----- DEBUG ----- paramDefaultTimezone => Europe/Paris 2015-09-30 13:50:53.317 ----- DEBUG ----- currency => € 2015-09-30 13:50:53.319 ----- DEBUG ----- currencyPosition => after 2015-09-30 13:50:53.320 ----- DEBUG ----- paramFadeLoadingMode => true 2015-09-30 13:50:53.322 ----- DEBUG ----- paramRowPerPage => 2015-09-30 13:50:53.324 ----- DEBUG ----- paramIconSize => 32 2015-09-30 13:50:53.326 ----- DEBUG ----- defaultTheme => ProjeQtOr 2015-09-30 13:50:53.327 ----- DEBUG ----- paramPathSeparator => 2015-09-30 13:50:53.329 ----- DEBUG ----- paramAttachmentDirectory => ../files/attach/ 2015-09-30 13:50:53.331 ----- DEBUG ----- paramAttachmentMaxSize => 2097152 2015-09-30 13:50:53.332 ----- DEBUG ----- paramReportTempDirectory => ../files/report/ 2015-09-30 13:50:53.334 ----- DEBUG ----- paramMemoryLimitForPDF => 512 2015-09-30 13:50:53.336 ----- DEBUG ----- defaultBillCode => 2015-09-30 13:50:53.337 ----- DEBUG ----- paramMailEol => CRLF 2015-09-30 13:50:53.339 ----- DEBUG ----- defaultProfile => 5 2015-09-30 13:50:53.341 ----- DEBUG ----- imputationUnit => days 2015-09-30 13:50:53.342 ----- DEBUG ----- workUnit => days 2015-09-30 13:50:53.344 ----- DEBUG ----- ganttPlanningPrintOldStyle => NO 2015-09-30 13:50:53.346 ----- DEBUG ----- displayOnlyHandled => NO 2015-09-30 13:50:53.347 ----- DEBUG ----- setHandledOnRealWork => NO 2015-09-30 13:50:53.349 ----- DEBUG ----- setResponsibleIfSingle => NO 2015-09-30 13:50:53.351 ----- DEBUG ----- setResponsibleIfNeeded => NO 2015-09-30 13:50:53.353 ----- DEBUG ----- paramLockAfterWrongTries => 2015-09-30 13:50:53.354 ----- DEBUG ----- passwordValidityDays => 2015-09-30 13:50:53.356 ----- DEBUG ----- rememberMe => YES 2015-09-30 13:50:53.358 ----- DEBUG ----- initializePassword => NO 2015-09-30 13:50:53.359 ----- DEBUG ----- referenceFormatNumber => 2015-09-30 13:50:53.361 ----- DEBUG ----- preserveUploadedFileName => NO 2015-09-30 13:50:53.363 ----- DEBUG ----- filenameCharset => 2015-09-30 13:50:53.364 ----- DEBUG ----- getVersion => YES 2015-09-30 13:50:53.366 ----- DEBUG ----- cronCheckEmailsHost => 2015-09-30 13:50:53.368 ----- DEBUG ----- cronCheckEmailsUser => 2015-09-30 13:50:53.369 ----- DEBUG ----- cronCheckEmailsPassword => 2015-09-30 13:50:53.371 ----- DEBUG ----- paramMailReplyToName => 2015-09-30 13:50:53.373 ----- DEBUG ----- paramMailSmtpUsername => 2015-09-30 13:50:53.374 ----- DEBUG ----- paramMailSmtpPassword => 2015-09-30 13:50:53.378 ----- DEBUG ----- application => PROJEQTOR 2015-09-30 13:50:53.379 ----- DEBUG ----- ProjeQtOr_projeqtor => Array 2015-09-30 13:50:53.381 ----- DEBUG ----- Array[1] 2015-09-30 13:50:53.383 ----- DEBUG ----- _tablesFormatList => Array 2015-09-30 13:50:53.384 ----- DEBUG ----- Array[2] 2015-09-30 13:50:53.386 ----- DEBUG ----- Parameter => Array 2015-09-30 13:50:53.388 ----- DEBUG ----- Array[5] 2015-09-30 13:50:53.389 ----- DEBUG ----- id => int(12) unsigned 2015-09-30 13:50:53.391 ----- DEBUG ----- iduser => int(12) unsigned 2015-09-30 13:50:53.393 ----- DEBUG ----- idproject => int(12) unsigned 2015-09-30 13:50:53.394 ----- DEBUG ----- parametercode => varchar(100) 2015-09-30 13:50:53.396 ----- DEBUG ----- parametervalue => varchar(4000) 2015-09-30 13:50:53.399 ----- DEBUG ----- Message => Array 2015-09-30 13:50:53.401 ----- DEBUG ----- Array[9] 2015-09-30 13:50:53.403 ----- DEBUG ----- id => int(12) unsigned 2015-09-30 13:50:53.404 ----- DEBUG ----- idproject => int(12) unsigned 2015-09-30 13:50:53.406 ----- DEBUG ----- name => varchar(100) 2015-09-30 13:50:53.408 ----- DEBUG ----- idmessagetype => int(12) unsigned 2015-09-30 13:50:53.409 ----- DEBUG ----- description => varchar(16777215) 2015-09-30 13:50:53.411 ----- DEBUG ----- idprofile => int(12) unsigned 2015-09-30 13:50:53.413 ----- DEBUG ----- iduser => int(12) unsigned 2015-09-30 13:50:53.415 ----- DEBUG ----- idle => int(1) unsigned 2015-09-30 13:50:53.416 ----- DEBUG ----- showonlogin => int(1) unsigned

EDIT: I get a forum error each time I try to post the last 1,000 lines. So I posted a little less than the last 200 lines. Hope this will be enough.


 
Posted : 30 Sep 2015 17H00
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

It' too short.
Please send log file to support@projeqtor.org (zipped it should not be very big)


 
Posted : 30 Sep 2015 17H08
Share:

Scroll to Top