- Posts: 13
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
User login and restore
- laura881
- Topic Author
- Offline
- New Member
Less
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
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.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
4 years 5 months ago #190043
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
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.
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 13
- Thank you received: 0
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
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.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
4 years 5 months ago #190047
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
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?
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 13
- Thank you received: 0
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
postgresql 9.6
backup with:
pg_dumpall --no-owner > backup.sql
restore:
psql < backup.sql
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
4 years 5 months ago #190087
by DenisChenu
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.
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
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 13
- Thank you received: 0
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:
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
4 years 5 months ago #190111
by DenisChenu
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.
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 13
- Thank you received: 0
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":
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
4 years 5 months ago #190122
by DenisChenu
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.
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 13
- Thank you received: 0
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?
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
4 years 5 months ago #190130
by DenisChenu
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.
Replied by DenisChenu on topic User login and restore
Something like
INSERT INTO `lime_users` …
Some lines with you already existing admin name …
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.