User registration issue

[ericrosenbaum]

reported by @aytac here:

Hi there,

There is a problem with the registration process on the site.
http://beetleblocks.com/api/users with this url we can see all registered user at the moment.
When you basically click http://beetleblocks.com/signup blank registration form you can see the users via site api.

Also when you submit the fully filled form it gives us an another error as well.
http://beetleblocks.com/api/users/new

[danielkschneider]

I get this when I try to register. Greetings !

Error

/usr/local/share/lua/5.1/lapis/db/postgres.lua:81: INSERT INTO "users" ("password", "joined", "username", "email", "isadmin") VALUES ('$2b$11$VEf.YvR77eZ62/3jNtIAA.nLwb.hKw.htJI6Wq7vDUS6phHqqoRWi', '2020-01-24 15:34:12', 'dks', 'daniel.schneider@unige.ch', FALSE) RETURNING "username"
ERROR: value for domain dom_username violates check constraint "dom_username_check"

Traceback

stack traceback:
[C]: in function 'error'
/usr/local/share/lua/5.1/lapis/db/postgres.lua:81: in function 'insert'
/usr/local/share/lua/5.1/lapis/db/postgres/model.lua:190: in function 'create'
./api.lua:297: in function 'handler'
/usr/local/share/lua/5.1/lapis/application.lua:130: in function 'resolve'
/usr/local/share/lua/5.1/lapis/application.lua:161: in function </usr/local/share/lua/5.1/lapis/application.lua:159>
[C]: in function 'xpcall'
/usr/local/share/lua/5.1/lapis/application.lua:159: in function 'dispatch'
/usr/local/share/lua/5.1/lapis/nginx.lua:205: in function 'serve'
content_by_lua(nginx.conf.compiled:33):2: in function <content_by_lua(nginx.conf.compiled:33):1>

[bromagosa]

Hmm, I see. Your username is too short, it should be at least 4 chars long.

It seems I forgot to return an error message to users when they try to register an invalid username... sorry about that and thanks for reporting, I'll see if I can find some time to fix this!

[ksdavidc]

Still happening...different error:

Error /usr/local/share/lua/5.1/lapis/db/postgres.lua:81: INSERT INTO "users" ("password", "joined", "username", "email", "isadmin") VALUES ( [clipped], FALSE) RETURNING "username" ERROR: could not extend file "base/16387/46854": No space left on device Traceback stack traceback: [C]: in function 'error' /usr/local/share/lua/5.1/lapis/db/postgres.lua:81: in function 'insert' /usr/local/share/lua/5.1/lapis/db/postgres/model.lua:190: in function 'create' ./api.lua:297: in function 'handler' /usr/local/share/lua/5.1/lapis/application.lua:130: in function 'resolve' /usr/local/share/lua/5.1/lapis/application.lua:161: in function </usr/local/share/lua/5.1/lapis/application.lua:159> [C]: in function 'xpcall' /usr/local/share/lua/5.1/lapis/application.lua:159: in function 'dispatch' /usr/local/share/lua/5.1/lapis/nginx.lua:205: in function 'serve' content_by_lua(nginx.conf.compiled:33):2: in function <content_by_lua(nginx.conf.compiled:33):1>

[bromagosa]

Ouch! That's a different story! We're out of disk space! Let me work on that...

[bromagosa]

Please try again now. I've manually removed some stuff to free up a bit of space, and hopefully @gitduks will upgrade our server instance with more storage soon :)

[bromagosa]

Actually, it seems the log files were using up ALL of that space. I've just trimmed them to the last 100,000 entries and that liberated enough space for many more years to come 😆

[ksdavidc]

Well done. I didn't have high hopes for an answer to such an old thread, but yay. Thanks! Happilly on board.