Please help us help you and fill where relevant:
Your LimeSurvey version: [5.6.40]
Own server or LimeSurvey hosting: own

==================
How to show respondent answers from database in external .php file if question attribute "Encrypted" is used to enable data encryption?
select id, submitdate, AES_DECRYPT(1X2X3SQ001, 'key'); returns NULL

Tryed

require_once '/path/vendor/autoload.php'; // Adjust the path to the autoload.php file

use LimeSurvey\Survey\Repository as SurveyRepository;
use LimeSurvey\Token\Provider as TokenProvider;

$surveyRepository = new SurveyRepository();
$tokenProvider = new TokenProvider();

$surveyId = 123;
$tokens = $tokenProvider->getTokens($survey);

foreach ($tokens as $token) {
    $participantToken = $token->getToken();
    $responseData = $tokenProvider->getResponseData($survey, $participantToken);
 
    // Display the participant's token
    echo "Token: $participantToken <br>";
 
    // Display the question answers
    foreach ($responseData as $questionId => $questionData) {
        echo "Question ID: $questionId <br>";
        
        foreach ($questionData as $subQuestionId => $answer) {
            echo "Sub-Question ID: $subQuestionId <br>";
            echo "Answer: $answer <br>";
        }
    }
 
    echo "<br>";
}
with LimeSurvey\Survey\Repository not found error.

[/code]
[/code]

PHP Fatal error: Uncaught SodiumException: sodium_crypto_secretbox_open(): Argument #2 ($nonce) must be SODIUM_CRYPTO_SECRETBOX_NONCEBYTES bytes long in

Did you manage to solve?
I am also having the same necessity/issue!

OpenStudio wrote:

Did you manage to solve?
I am also having the same necessity/issue!

 

Hello.
No I don`t still trying.
I know uncrypted data is shown in admin menu.
You can track issue in stackoverflow.com

Moving it to development section

Some code
github.com/LimeSurvey/LimeSurvey/blob/41...re/LSSodium.php#L135

Maybe need base64_decode ?

DenisChenu wrote:

Some code
github.com/LimeSurvey/LimeSurvey/blob/41...re/LSSodium.php#L135

Maybe need base64_decode ?

Error in nonce or key format. You can see at line 139 they are not decoded.
But i think they encoded in Limesurvey config file and one should decrypt nonce and key before use.

Main mystery is how to decrypt nonce and key from config file to solve Argument #2 ($nonce) must be SODIUM_CRYPTO_SECRETBOX_NONCEBYTES bytes long in problem in sodium_crypto_secretbox_open() function.
 

github.com/LimeSurvey/LimeSurvey/blob/41...ore/LSSodium.php#L64
github.com/LimeSurvey/LimeSurvey/blob/41...ore/LSSodium.php#L71

?

Tryed sodium_hex2bin() function on them like this. Without any error, but no decryption, clean error.log in apache, status 200 in access log, but just blank variable without data  
applyed base64_decode() on

works fine. Feel free to use this solution on external .php data output with nonce and key from secure.php in config directory.

Great ! You got it !!

Thank you for your help.

For reference, if someone may need to encrypt the data instead:

OpenStudio wrote:

For reference, if someone may need to encrypt the data instead:

Code:

base64_encode(sodium_crypto_secretbox($data,sodium_hex2bin($encryptionnonce),sodium_hex2bin($encryptionsecretboxkey)))

 

Thank you OpenStudio.
Tryed to write, that no need to my messages was marked as spam.