Forum

Conflict between Pr...
 
Notifications
Retirer tout

Conflict between ProjeQtOr and Bitnami SuiteCRM

10 Posts
2 Utilisateurs
0 Reactions
8,723 Vu
(@eliot)
Posts: 5
Active Member
Début du sujet
 
[#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.


 
Posté : 29 Sep PM 18:099
(@babynus)
Posts: 14952
Membre 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.


 
Posté : 29 Sep PM 22:099
(@eliot)
Posts: 5
Active Member
Début du sujet
 

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.


 
Posté : 30 Sep PM 12:099
(@babynus)
Posts: 14952
Membre 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...)


 
Posté : 30 Sep PM 13:099
(@eliot)
Posts: 5
Active Member
Début du sujet
 

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


 
Posté : 30 Sep PM 13:099
(@babynus)
Posts: 14952
Membre Admin
 

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

$logLevel='3';

 
Posté : 30 Sep PM 14:099
(@eliot)
Posts: 5
Active Member
Début du sujet
 

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?


 
Posté : 30 Sep PM 16:099
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 30 Sep PM 16:099
(@eliot)
Posts: 5
Active Member
Début du sujet
 

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.


 
Posté : 30 Sep PM 17:099
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 30 Sep PM 17:099
Share:
Retour en haut