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.
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.
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.
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...)
I found it while you were answering (I edited my previous post).
Sorry, you also have to change log level to 3 in parameters.php file :
$logLevel='3';
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?
You can post whole file or just last 1000 lines , as you want.
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.
It' too short.
Please send log file to support@projeqtor.org (zipped it should not be very big)