Display

Fri, 29 Apr 2022 15:43:29 -0700 from hubzilla

frank schleusener wrote the following post Fri, 29 Apr 2022 15:43:28 -0700

installation gets stuck at first login

i have been using hubzilla earlier, many years ago, running my own hub and getting quite a bit into the details, including code. now i'm trying to set up a hub again on my digitalOcean VPS using nginx & mariaDB. all installation steps using the web interface completed successfully, but after registering the first account i can't log in, the login form keeps re-appearing.

my details make it into the table 'register,' but the user never gets added to the 'users' table. i see neither relevant nginx errors in the logs, nor from mariaDB. nginx can write to .../store/..., xchan & smarty files are being created, doesn't look like a permissions problem.

i tried to find something relevant by searching this forum, but nothing turned up. seems like there should be an easy solution, but right now i'm baffled. can anyone point me in the right direction?

Fri, 29 Apr 2022 15:59:40 -0700

After you registered the first account, did you get an email token and enter it? You'll probably need that.

If not, you can use a DB editor and change account.account_flags for your account to 0 - which is what will happen when you enter a correct email validation token.

If the validation worked but you still can't login, clear your browser cookie cache for the site and try again; especially if you had some other software running on that domain previously.

Fri, 29 Apr 2022 18:18:41 -0700

I hope this is just a typo because there is no 'users' table in Hubzilla. It's called 'channel'. It will nearly always have the system channel as channel_id 1 and channel_id 2 probably belongs to you if it exists. If it isn't there, see if you have an entry in the 'account' table and that (as mentioned earlier account.account_flags) is 0.

Even if it appears that login is unsuccessful, once you have tried to login, see if you can visit

https://{yoursite.whatever}/new_channel which is where it should go after verification.

Years ago we had login troubles if there was something wrong with the 'session' table; but I haven't seen any issues related to that in a very long time.

And caveat: I haven't used Hubzilla in several years. Hopefully somebody who is more up-to-date on its current internal workings will offer advice.

Fri, 29 Apr 2022 22:36:10 -0700

Bloody hell. There's a users table now. Big apology. There was some work done on the registration system last year iirc.
In any case I've got a test site with a bunch of channels and the users table is empty and it still works, so it seems like it isn't all that important. Now I'll have to go read through and find out what it does. But the important thing is to be able to login. This will require somebody who knows the current code.

phani00 (hubzilla)

Sat, 30 Apr 2022 03:30:07 -0700 from hubzilla

that came in further above when i wrote the 'users' table was empty, assuming it had something to do with users being registered, and @mike said there was no such table in hubzilla. that table exists now, but got nothing to do with user- or channel registration. in my case, it's still empty.