User login and restore

Mehr
5 Monate 1 Woche her #190037 von laura881
User login and restore wurde erstellt von laura881
Hello everybody,

how can I get it back when I do a backup of Limsurvey's database with dumpall that users can log in again without having to re-register?

Backup the database with:
pg_dumpall --no-owner> backup.sql "

Let's say I rebuild LimeSurvey and restore my backup.
Then the users should be available again and can log in normally WITHOUT registering again.

How do you get that?
Or is it normal that the users have to register again?


LG
Laura

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

LimeSurvey Partners
Mehr
5 Monate 1 Woche her #190043 von jelo
jelo antwortete auf User login and restore
If you restore the complete database and survey users authentication is via the database, there is no need for user re-registration. If you have issues it might come down to different versions of LimeSurvey doing the restore.

You seem to use PostgreSQL, which might hold some additional surprises cause LimeSurvey is not tested against PostgreSQL that much.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190046 von laura881
thank you for the fast reply.
I use exact the same Limesurvey version for the restore.

If I rebuild my limesurvey and restore my backup than the users have to re-register it again.
How can I fix that ?

Many thanks :)

Regards,
Laura

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190047 von jelo
jelo antwortete auf User login and restore
What version is used?
What of the environment is different?
How did you restore the limesurvey application?

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190048 von laura881
Limesurvey Version: Version 3.17.16+190906
postgresql 9.6

backup with:
pg_dumpall --no-owner > backup.sql

restore:
psql < backup.sql

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190087 von DenisChenu
If they need to register again : it's seems they are not in current user.
Then : can you look at
1. User list
2. lime_users table in restored DB
3. lime_users table creation in sql file (grep is great)
4. lime_users table in original DB

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190103 von laura881
Hi DenisChenu,

here my output when grep lime_users:
-- Name: lime_users; Type: TABLE; Schema: public; Owner: -
CREATE TABLE lime_users (
-- Name: lime_users_uid_seq; Type: SEQUENCE; Schema: public; Owner: -
CREATE SEQUENCE lime_users_uid_seq
-- Name: lime_users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
ALTER SEQUENCE lime_users_uid_seq OWNED BY lime_users.uid;
-- Name: lime_users uid; Type: DEFAULT; Schema: public; Owner: -
ALTER TABLE ONLY lime_users ALTER COLUMN uid SET DEFAULT nextval('lime_users_uid_seq'::regclass);
-- Data for Name: lime_users; Type: TABLE DATA; Schema: public; Owner: -
COPY lime_users (uid, users_name, password, full_name, parent_id, lang, email, htmleditormode, templateeditormode, questionselectormode, one_time_pw, dateformat, created, modified) FROM stdin;
-- Name: lime_users_uid_seq; Type: SEQUENCE SET; Schema: public; Owner: -
SELECT pg_catalog.setval('lime_users_uid_seq', 2, true);
-- Name: lime_users lime_users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
ALTER TABLE ONLY lime_users
    ADD CONSTRAINT lime_users_pkey PRIMARY KEY (uid);
CREATE UNIQUE INDEX lime_idx1_users ON lime_users USING btree (users_name);
CREATE INDEX lime_idx2_users ON lime_users USING btree (email);

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190111 von DenisChenu
Seems (unsure) there are no users in your SQL file ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190121 von laura881
thx for your feedback.
And here my output when i grep for "users":
-- Name: lime_map_tutorial_users; Type: TABLE; Schema: public; Owner: -
CREATE TABLE lime_map_tutorial_users (
-- Name: lime_users; Type: TABLE; Schema: public; Owner: -
CREATE TABLE lime_users (
    users_name character varying(64) DEFAULT ''::character varying NOT NULL,
-- Name: lime_users_uid_seq; Type: SEQUENCE; Schema: public; Owner: -
CREATE SEQUENCE lime_users_uid_seq
-- Name: lime_users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
ALTER SEQUENCE lime_users_uid_seq OWNED BY lime_users.uid;
-- Name: lime_users uid; Type: DEFAULT; Schema: public; Owner: -
ALTER TABLE ONLY lime_users ALTER COLUMN uid SET DEFAULT nextval('lime_users_uid_seq'::regclass);
-- Data for Name: lime_map_tutorial_users; Type: TABLE DATA; Schema: public; Owner: -
COPY lime_map_tutorial_users (tid, uid, taken) FROM stdin;
7       1       \N      7       tokens  Survey participant settings     Participant settings    Set additional options for survey participants  users   fontawesome                     updatesurveylocalesettings      editLocalSettings_main_view     /admin/survey/subview/accordion/_tokens_panel           surveylocale    read    \N      _tabTokens      en-GB   0       1       2019-09-23 12:55:29    02019-09-23 12:55:29     0
27      3       \N      5       cpdb    Central participant database    Central participant database    Central participant database    users   fontawesome             admin/participants/sa/displayParticipants                                       tokens  read    {"render": {"link": {}}}                en-GB   1       1       2019-09-23 12:55:29     0       2019-09-23 12:55:29     0
-- Data for Name: lime_users; Type: TABLE DATA; Schema: public; Owner: -
COPY lime_users (uid, users_name, password, full_name, parent_id, lang, email, htmleditormode, templateeditormode, questionselectormode, one_time_pw, dateformat, created, modified) FROM stdin;
-- Name: lime_users_uid_seq; Type: SEQUENCE SET; Schema: public; Owner: -
SELECT pg_catalog.setval('lime_users_uid_seq', 2, true);
-- Name: lime_map_tutorial_users lime_map_tutorial_users_pk; Type: CONSTRAINT; Schema: public; Owner: -
ALTER TABLE ONLY lime_map_tutorial_users
    ADD CONSTRAINT lime_map_tutorial_users_pk PRIMARY KEY (uid, tid);
-- Name: lime_users lime_users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
ALTER TABLE ONLY lime_users
    ADD CONSTRAINT lime_users_pkey PRIMARY KEY (uid);
-- Name: lime_idx1_users; Type: INDEX; Schema: public; Owner: -
CREATE UNIQUE INDEX lime_idx1_users ON lime_users USING btree (users_name);
-- Name: lime_idx2_users; Type: INDEX; Schema: public; Owner: -
CREATE INDEX lime_idx2_users ON lime_users USING btree (email);

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190122 von DenisChenu
Did you find yourself where user was added in your SQL file ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190123 von laura881
do you mean a TABLE with users ? or lime_users ?
like you can see is that my output from my backup sql file.
can you recognize something? is there something missing?

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190130 von DenisChenu
Something like

INSERT INTO `lime_users` …

Some lines with you already existing admin name …

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
An error happen ? Before make a new topic : remind the Debug mode .

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190133 von laura881
i searched for "INSERT INTO" but couldnt found anything.

I get this result, when I search for a admin user which I created(I changed name to Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!):
698698  1       1       Demo Name  N       \N      \N      Demo.name@domain.com   N               G       N       fruity  en              N       N       N       Y       3       N       N      NN       N       2019-10-21 09:09:50     0       N       N       N       Y       Y       N       N       N       N       Demo.name@domain.com   \N                      15      Y       B       N      X\N      N       \N      \N      \N      \N      \N      Y       Y       0       0       N       N       \N      \N
2       Demo   $2y$10$2kasgEz5ZgtPq0RQ26q6u.Z1ZjpcbP9CiNlE64jJbEL.Pst/AVJm.    Demo name  1       auto    Demo.name@domain.com   default default default \N      1       2019-10-21 09:10:44.808071      \N

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her - 5 Monate 1 Woche her #190138 von DenisChenu
Since you give really less information than asked (because just have this line explain NOTHING !

DenisChenu schrieb: 2. lime_users table in restored DB

Since it's not a LimeSurvey issue (in my opinion)

I leave …

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
An error happen ? Before make a new topic : remind the Debug mode .
Letzte Änderung: 5 Monate 1 Woche her von DenisChenu.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
5 Monate 1 Woche her #190139 von laura881
here my Lime_users table in the restored DB:
public | lime_users                            | table | limesurvey
(46 rows)
 
limesurvey=# \d lime_users
                                           Table "public.lime_users"
        Column        |            Type             |                        Modifiers
----------------------+-----------------------------+----------------------------------------------------------
 uid                  | integer                     | not null default nextval('lime_users_uid_seq'::regclass)
 users_name           | character varying(64)       | not null default ''::character varying
 password             | text                        | not null
 full_name            | character varying(50)       | not null
 parent_id            | integer                     | not null
 lang                 | character varying(20)       |
 email                | character varying(192)      |
 htmleditormode       | character varying(7)        | default 'default'::character varying
 templateeditormode   | character varying(7)        | not null default 'default'::character varying
 questionselectormode | character varying(7)        | not null default 'default'::character varying
 one_time_pw          | text                        |
 dateformat           | integer                     | not null default 1
 created              | timestamp without time zone |
 modified             | timestamp without time zone |
Indexes:
    "lime_users_pkey" PRIMARY KEY, btree (uid)
    "lime_idx1_users" UNIQUE, btree (users_name)
    "lime_idx2_users" btree (email)
 
limesurvey=#

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha