Bug #1247
Setup with PostgreSQL fails to create new users
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 about 11 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 about 11 years ago
- Priority changed from Urgent to Normal
#3 Updated by jjakob over 2 years ago
Still present in 0.14.0.