Your LimeSurvey version: LimeSurvey Community Edition Version 6.4.0+231218
Own server or LimeSurvey hosting: Own server
Survey theme/template: fruity
==================

Goodmorning everyone,

I am trying to import the existing users I have into my LimeSurvey system. Sadly I found out there isn't a way to have external database support for login.
In any case, i built the csv file to be imported, but every time I upload it - only one user gets uploaded and then I get this error:

500: Internal Server Error CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-global-auth_db-12' for key 'lime_idx1_permissions'An internal error occurred while the Web server was processing your request.

Also, I have an additional question. I have the password of my users encrypted in my original database, what value/format should I include in the csv file? - of course I don't have the encrypted passwords!

Thanks in advance,
Have a nice day!

Your LimeSurvey version: latest (installed today, 18/12/2023)

This is not helpful. What is the latest today, might not be the lasted tomorrow. You just look at the bottom of your admin pages and take the exact version from there. Otherwise you just make us to look up what the latest release was on 18/12/2023. Help us to help you by making it easy for us.

Also: Currently there are 2 latest versions. One for the LS5 branch, one for the LS6 branch. Actually it is 3, if we still count LS 3 ( community.limesurvey.org/downloads/ ). But as LS 3 finally seems to be EOL and not supported anymore, I won't count that anymore.

Given the screenshot, I would assume yours is LS6, but why not just copying the version number from the bottom of the admin screen. Takes probably less time than to write the date.

Installed version is: LimeSurvey Community Edition Version 6.4.0+231218

OpenStudio wrote:

I am trying to import the existing users I have into my LimeSurvey system. Sadly I found out there isn't a way to have external database support for login.
 

? We have AuthLDAP, Authwebserver and a lot of Authentoification plugin.
We allow a lot of other database for login !

Else : for your issue : community.limesurvey.org/bug-tracker/

Thanks a lot!
Can I ask you two more things?
1. how are the data encrypted in the database? because I am trying to integrate it in my own dashboard, and I need to to manipulate the data directly from php/mysql - but for example the email, etc.. are encrypted using the secret key (but I don't know the method)

2. where can I find the list of authentication plugins? because I cannot use LDAP/Shibboleth and I don't have Wordpress. May you help me?

Thanks a lot for the original error, I have opened a bug ticket

Have a nice day!

OpenStudio wrote:

1. how are the data encrypted in the database? because I am trying to integrate it in my own dashboard, and I need to to manipulate the data directly from php/mysql - but for example the email, etc.. are encrypted using the secret key (but I don't know the method)

Then don't encrypt it.

OpenStudio wrote:

2. where can I find the list of authentication plugins? because I cannot use LDAP/Shibboleth and I don't have Wordpress. May you help me?

Best is to know what method do you have currently.

DenisChenu wrote:

OpenStudio wrote:

1. how are the data encrypted in the database? because I am trying to integrate it in my own dashboard, and I need to to manipulate the data directly from php/mysql - but for example the email, etc.. are encrypted using the secret key (but I don't know the method)

Then don't encrypt it.

OpenStudio wrote:

2. where can I find the list of authentication plugins? because I cannot use LDAP/Shibboleth and I don't have Wordpress. May you help me?

Best is to know what method do you have currently.

The solution has been given in the meaning in another post - forums.limesurvey.org/forum/development/...ption?start=0#253700

DenisChenu wrote:

OpenStudio wrote:

2. where can I find the list of authentication plugins? because I cannot use LDAP/Shibboleth and I don't have Wordpress. May you help me?

Best is to know what method do you have currently.

Currently I have a users table with username, email, password fields and my login system is handled with $_SESSION variables. Please tell me if you need any extra info, thanks in advance!

> Currently I have a users table with username, email, password fields and my login system is handled with $_SESSION variables. Please tell me if you need any extra info, thanks in advance!

You want to fill session yourself ?
And : user is connected ?

Then : just create a AuthBySession : inspired by AuthByWebserver : github.com/LimeSurvey/LimeSurvey/blob/8c...uthwebserver.php#L63

Could you guide me through it?
I am not really advanced in this aspect

Thanks a lot if you can, or if you have any example!

OpenStudio wrote:

Thanks a lot if you can, or if you have any example!
 

The webserver auth plugi is an example.

Just use $_SESSION in place of $_SERVER.

But : yes, need to develop PHP : contact a PHP developer maybe.
Else : www.sondages.pro/contact.html