Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

User login and restore

  • laura881
  • laura881's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 5 months ago #190037 by laura881
User login and restore was created by 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
The topic has been locked.
More
4 years 5 months ago #190043 by jelo
Replied by jelo on topic 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
The topic has been locked.
  • laura881
  • laura881's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 5 months ago #190046 by laura881
Replied by laura881 on topic User login and restore
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
The topic has been locked.
More
4 years 5 months ago #190047 by jelo
Replied by jelo on topic 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
The topic has been locked.
  • laura881
  • laura881's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 5 months ago #190048 by laura881
Replied by laura881 on topic User login and restore
Limesurvey Version: Version 3.17.16+190906
postgresql 9.6

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

restore:
psql < backup.sql
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 5 months ago #190087 by DenisChenu
Replied by DenisChenu on topic User login and restore
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 .
I don't answer to private message.
The topic has been locked.
  • laura881
  • laura881's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 5 months ago #190103 by laura881
Replied by laura881 on topic User login and restore
Hi DenisChenu,

here my output when grep lime_users:
Code:
-- 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);
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 5 months ago #190111 by DenisChenu
Replied by DenisChenu on topic User login and restore
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 .
I don't answer to private message.
The topic has been locked.
  • laura881
  • laura881's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 5 months ago #190121 by laura881
Replied by laura881 on topic User login and restore
thx for your feedback.
And here my output when i grep for "users":
Code:
-- 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);
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 5 months ago #190122 by DenisChenu
Replied by DenisChenu on topic User login and restore
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 .
I don't answer to private message.
The topic has been locked.
  • laura881
  • laura881's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 5 months ago #190123 by laura881
Replied by laura881 on topic User login and restore
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?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 5 months ago #190130 by DenisChenu
Replied by DenisChenu on topic User login and restore
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 .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose