~emersion/soju#180: 
user not found: sql: no rows in result set

i'm trying to setup soju for personal use. i've ran sojuctl create-user jole. if i rerun it it again prompts me for a password, and if i hit enter i get 2022/01/06 12:06:10 failed to create user: UNIQUE constraint failed: User.username

if i try to connect (in weechat)

libera  -- | irc: client capability, server supports: invite-notify cap-notif
           | draft/extended-monitor away-notify extended-join message-tags
           | batch account-tag soju.im/bouncer-networks echo-message
           | multi-prefix account-notify soju.im/bouncer-networks-notify
           | setname sasl=PLAIN draft/chathistory server-time
libera  -- | irc: client capability, requesting: cap-notify away-notify
           | multi-prefix account-notify server-time
libera  -- | irc: client capability, enabled: cap-notify away-notify
           | multi-prefix account-notify server-time
libera  -- | * Invalid username or password

in /var/log/soju.log i get

2022/01/06 12:07:34 server listening on "ircs://0.0.0.0:6697"
2022/01/06 12:07:42 downstream "REDACTED:42240": new connection
2022/01/06 12:07:42 downstream "REDACTED:42240": failed authentication for "jole": user not found: sql: no rows in result set
Status
RESOLVED FIXED
Submitter
~jole
Assigned to
No-one
Submitted
4 months ago
Updated
4 months ago
Labels
No labels applied.

~jole 4 months ago

should've added: running on alpine 3.12, installed through repos

#/etc/soju/config
db sqlite3 /var/lib/soju/main.db
log fs /var/lib/soju/logs/

listen ircs://0.0.0.0:6697
hostname REDACTED

~jole 4 months ago

the .db seems to be written to the working directory by default, this seems to work:

sojuctl -config /etc/soju/config create-user jole

~emersion REPORTED FIXED 4 months ago

Closing since you found the cause.

Register here or Log in to comment, or comment via email.