View Issue Details

This bug affects 1 person(s).
 18
IDProjectCategoryView StatusLast Update
16499Bug reportsCentral participant databasepublic2021-03-29 12:31
Reporterggna Assigned Top_teichmann  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version4.3.4 
Summary16499: Argument 1 must be at least CRYPTO_SIGN_BYTES long
Description

I tried to add to CPDB two participants from an existing survey, and immediately after was not able to access the CPDB because "Argument 1 must be at least CRYPTO_SIGN_BYTES long".

Having direct access to the MySQL database, I identified and looked into the table named lime_participants, and saw that all other participants had their own "firstname" and "lastname" encrypted, whereas these fields were plainly readable (unencrypted) for the two participants transferred from my survey.

I had them manually removed (via the MySQL commands:

delete from lime_participants where firstname="Aaron";
delete from lime_participants where firstname="Zack";

) and the system started working again (i.e. I could again access the CPDB from the website).

I conclude that the script which transfers participants from one survey to the CPDB does not pre-encrypt the required fields.

Steps To Reproduce

Add participants to survey.
Transfer those participants to CPDB.

TagsNo tags attached.
Bug heat18
Complete LimeSurvey version number (& build)Version 4.3.3+200707
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL
Server OS (if known)
Webserver software & version (if known)last
PHP Version7.2

Relationships

has duplicate 15927 closedcdorin Absturz Teilnehmerdatenbank 

Users monitoring this issue

There are no users monitoring this issue.

Activities

cdorin

cdorin

2020-12-23 17:44

reporter   ~61121

@eddylackmann is this issue for you? :)

LimeBot

LimeBot

2020-12-28 10:36

administrator   ~61172

Last edited: 2020-12-28 10:53

@cdorin i will take a look at it

p_teichmann

p_teichmann

2021-03-29 10:35

administrator   ~63673

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=31418

lime_release_bot

lime_release_bot

2021-03-29 12:31

administrator   ~63688

Fixed in Release 4.4.15+210329

Related Changesets

LimeSurvey: master be5981ca

2021-03-17 10:25:32

p_teichmann

Details Diff
Fixed issue 16499: CPDB table not accessible after copying unencrypted Participant to CPDB Affected Issues
16499
mod - application/models/Participant.php Diff File

Issue History

Date Modified Username Field Change
2020-07-16 11:45 ggna New Issue
2020-12-23 17:44 cdorin Note Added: 61121
2020-12-28 10:36 LimeBot Note Added: 61172
2020-12-28 10:53 cdorin Priority none => high
2020-12-28 10:53 cdorin Status new => confirmed
2020-12-28 10:53 cdorin Sync to Zoho Project => |Yes|
2021-02-03 19:15 cdorin Relationship added has duplicate 15927
2021-03-26 14:41 c_schmitz Assigned To => p_teichmann
2021-03-26 14:41 c_schmitz Status confirmed => assigned
2021-03-29 10:35 p_teichmann Changeset attached => LimeSurvey master be5981ca
2021-03-29 10:35 p_teichmann Note Added: 63673
2021-03-29 10:35 p_teichmann Resolution open => fixed
2021-03-29 12:31 lime_release_bot Sync to Zoho Project Yes => |Yes|
2021-03-29 12:31 lime_release_bot Note Added: 63688
2021-03-29 12:31 lime_release_bot Status assigned => closed