Welcome to the LimeSurvey Community Forum

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!

I just want something like the administration login page.I don't know much about LDAP or OAuth.Which plugin should i use?

strong920326 wrote:

I know there have a token, But it doesn't fit our needs.
 

What kind of user data do you want do use?

Denis showed a lot of plugins. I haven't used them but tried to understand what their purpose is.
Perhaps Denis can correct me or add a comment to make purpose or limits clear.

Userdata resides in an external datasource
LdapTokenAuthenticate   LDAP-Server

WebserverTokenAuthenticate  Basic HTTP authentication
developer.mozilla.org/en-US/docs/Web/HTTP/Authentication

OrcidAuthenticate OAuth via ORCID ID
orcid.org/
Looks like not suitable for many projects outside the research community.
Is there another way to get a ORCID ID beside registering via
orcid.org/register ?

LimeSurvey tokentable is used to register a new token and an password attribute.
extraRegisterPassword
registerQuickh

Your LimeSurvey version: 5.6.42
Own server or LimeSurvey hosting: Own
==================
We switched from LimeSurvey 3 to 5.

When I created new users in LimeSurvey 3, there was the option that said that the user will use LDAP Auth and I just had to fill in the username and click on create. That worked fine.

Now in LimeSurvey 5 when I create new users there is no option for authentication type and I have to fill in all the fields like mail address, username, firstname lastname, then create the user. Go to the users permissions and switch authentication type to LDAP.  That is not very userfriendly/convenient.

Is there a way to get the old behaviour back, is there some switch or config that I can set?

(I hope this is the right section for my topic)

Please help us help you and fill where relevant:
Your LimeSurvey version: limesurvey6.3.1+231023
Own server or LimeSurvey hosting: Self hosted VPS (Cpanel / WHM)
Survey theme/template: default
==================
Hi guys.

I just wanted to check with everyone here in order to identify if this is a bug that needs to be filed.  Details:

1) I have a VPS with a hosting company and an absolutely default install with Cpanel and WHM.  The hosting company is responsible for managing the VPS, I do not fiddle with the config.

2) Example of successful installation - I also have shared hosting accounts with the same company and can install Limesurvey wither with Softaculous provided by Cpanel or by using the CE edition of the Limesurvey installer.  I tested successful installations on the hosting environment, there were no issues.

3) Example of problem installation - On the VPS instance, I went through the installation process many many times just to make sure I am familiar enough with it and the results are always the same:

a) The installation process completes perfectly and I can log into the Limesurvey admin / control panel.

b) Once I am logged in, everything "seems" to work for the most part, I don't see any particular issues staring at me.  The admin panel looks the same as in all other installs that I have tested.

c) However, the following links generate the CDbException error:

* Themes link on main dashboard.  Error:  CDbExceptionCDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-01_templates AS template ON `t`.`template_name` = template.name WHERE ((t.sid I' at line 1

* Global settings on the main dashboard. Error: CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-01_templates AS template ON `t`.`template_name` = template.name WHERE ((t.sid I' at line 1

* List surveys on main dashboard.  Error: CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-01_templates AS template ON `t`.`template_name` = template.name WHERE ((t.sid I' at line 1

Strangely, create survey, manage survey administrators and label sets seem to work / render just fine.  I did not go very deep into testing every single link as these are curious enough to start the conversation here.

4) Details about VPS:

Mysql: Server version: 8.0.34
Php: 8.0.30
Memory: 1024mb
Pre-installation check for limesurvey 6.3.1: We have everything exept the PHP LDAP library as we don't need that feature.

5) Questions

Any thoughts on what might be causing this issue?  I am surprised to see an sql statement syntax error given that the latest version of Mysql seems to be 8.1.0 and we aren't there yet on our VPS. 

Thanks.

Please help us help you and fill where relevant:
Your LimeSurvey version: LimeSurvey Community Edition Version 6.1.8+230717
Own server or LimeSurvey hosting: own server
Survey theme/template: vanilla & sea green for admin
Plugins used: LDAP
==================
Dear LimeSurvey community,

is it possible to configure our own limesurvey instance to verify the authenticity of the senders mail-address with our own mail server? LDAP is already implemented and functionable.
Currently it is possible to send mails from "non-existing" mail accounts. E.g. below:
M.Mustermann@example-university.com -> would be verified and sent
iAmANonExistingMailAdress@example-university.com -> would be deemed non existing and mail will be dropped

At the moment both mails would be send without further verification.

Thanks in advance!

Muchas gracias por la respuesta, muy amable!

Siento no poder mostrar imagénes o enlaces, pero cada vez que trato de insertarlas desaparecen del post final. La tabla múltiple se veria más o menos así
TRABAJADOR/A                                                     ACTITUD/COMPORTAMIENTO
                                             Horario                    Aspecto/Higiene                 Orden               Objetivos
Juan Pérez
Antonio Rodriguez
José Gonzalez

y las simples pues mas o menos así:

TRABAJADOR/A                                                     ACTITUD/COMPORTAMIENTO
                                             Horario                    Aspecto/Higiene                 Orden               Objetivos
Juan Pérez


TRABAJADOR/A                                                     ACTITUD/COMPORTAMIENTO
                                             Horario                    Aspecto/Higiene                 Orden               Objetivos
Antonio Rodriguez


TRABAJADOR/A                                                     ACTITUD/COMPORTAMIENTO
                                             Horario                    Aspecto/Higiene                 Orden               Objetivos
José Gonzalez

Ayúdenos a ayudarle y rellene los siguientes campos:.
Su versión de LimeSurvey: 6.2.6+230904
Servidor propio o LimeSurvey Cloud: Propio
Plantilla de diseño utilizada: 
==================
Hola buenos días, espero explicarme bien, me han encargado realizar una encuesta para el departamento de RRH, en la que cada jefe de dpto. se conecte a traves de sus credenciales LDAD (ya lo tienen) y puedan hacer una valoración de sus trabajadores.
Esa información se encuentra en una BDD de SQL a la que se podria acceder a traves de una consulta, por ejemplo:
 Mª Carmen López > Juan Pérez, Antonio Rodriguez y José Gonzalez

La pregunta es: 
¿Se podría crear automáticamente una encuesta en la que se rellene la primera columna con los trabajadores?


O en caso negativo, ¿se podrían crear automáticamente tantas encuestas individuales como trabajadores tenga un jefe? 




Muchas gracias de antemano