Project

General

Profile

Bug #1247

Setup with PostgreSQL fails to create new users

Added by davidstrauss over 10 years ago. Updated almost 2 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Quassel Core
Target version:
-
Start date:
10/17/2013
Due date:
% Done:

0%

Estimated time:
Version:
0.9-pre
OS:
Linux

Description

Based on web searches for "Unable to add user", this is not an uncommon problem.

[root@quassel ~]# su - quassel -c "quasselcore --select-backend=PostgreSQL" 
("QSQLITE", "QPSQL7", "QPSQL") 
("QSQLITE", "QPSQL7", "QPSQL") 
Default values are in brackets
Username (quassel): 
Password: 
Hostname (localhost): 
Port (5432): 
Database (quassel): 
Storage Schema is missing! 
NOTICE:  CREATE TABLE will create implicit sequence "quasseluser_userid_seq" for serial column "quasseluser.userid" 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "quasseluser_pkey" for table "quasseluser" 
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "quasseluser_username_key" for table "quasseluser" 
NOTICE:  CREATE TABLE will create implicit sequence "sender_senderid_seq" for serial column "sender.senderid" 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sender_pkey" for table "sender" 
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "sender_sender_key" for table "sender" 
NOTICE:  CREATE TABLE will create implicit sequence "identity_identityid_seq" for serial column "identity.identityid" 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "identity_pkey" for table "identity" 
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "identity_userid_identityname_key" for table "identity" 
NOTICE:  CREATE TABLE will create implicit sequence "identity_nick_nickid_seq" for serial column "identity_nick.nickid" 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "identity_nick_pkey" for table "identity_nick" 
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "identity_nick_identityid_nick_key" for table "identity_nick" 
NOTICE:  CREATE TABLE will create implicit sequence "network_networkid_seq" for serial column "network.networkid" 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "network_pkey" for table "network" 
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "network_userid_networkname_key" for table "network" 
NOTICE:  CREATE TABLE will create implicit sequence "buffer_bufferid_seq" for serial column "buffer.bufferid" 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "buffer_pkey" for table "buffer" 
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "buffer_userid_networkid_buffercname_key" for table "buffer" 
NOTICE:  CREATE TABLE will create implicit sequence "backlog_messageid_seq" for serial column "backlog.messageid" 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "backlog_pkey" for table "backlog" 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "coreinfo_pkey" for table "coreinfo" 
NOTICE:  CREATE TABLE will create implicit sequence "ircserver_serverid_seq" for serial column "ircserver.serverid" 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ircserver_pkey" for table "ircserver" 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "user_setting_pkey" for table "user_setting" 
2013-10-17 00:36:19 Info: PostgreSQL Storage Backend is ready. Quassel Schema Version: 16 
Switched backend to: PostgreSQL 
No currently active backend. Skipping migration. 
New backend does not support migration: PostgreSQL 
Add a new user:
Username: straussd
Password: 
Repeat Password: 
Unable to add user: straussd

History

#1 Updated by davidstrauss over 10 years ago

A workaround is explicitly adding the user post-setup. We can downgrade this from "urgent" since there is a way to get it working anyway.

[quassel@quassel ~]$ quasselcore --add-user
("QSQLITE", "QPSQL7", "QPSQL") 
2013-10-17 01:20:17 Info: PostgreSQL Storage Backend is ready. Quassel Schema Version: 16 
Add a new user:
Username: straussd
Password: 
Repeat Password: 
Added user straussd successfully!

#2 Updated by Anonymous over 10 years ago

  • Priority changed from Urgent to Normal

#3 Updated by jjakob almost 2 years ago

Still present in 0.14.0.

Also available in: Atom PDF