Forcing UID value

Simos

@baris i'm using Redis not mongoDB

127.0.0.1:6379> HGET user:1 auid
"3074"

PitaJ

@Simos the equivalent code would be

ZSCORE auid:uid 1

Simos

@PitaJ @baris

127.0.0.1:6379> HGET user:1 auid
"3074"
127.0.0.1:6379> ZSCORE auid:uid 1
(nil)
127.0.0.1:6379>

it say nil

<baris>

run this type auid:uid

Simos

@baris said in Forcing UID value:

type auid:uid

127.0.0.1:6379> type auid:uid
none
127.0.0.1:6379>

<baris>

That means auid:uid doesn't exist so your code doesn't actually write anything into it.

Simos

@baris so why i can get it in the hash ? auid exist ...

127.0.0.1:6379> HGETALL user:1

"username"
"Simos"
"userslug"
"simos"
"email"
"[email protected]"
"joindate"
"1542893552374"
"lastonline"
"1543850453258"
"picture"
""
"fullname"
""
"location"
""
"birthday"
""
"website"
""
"signature"
""
"uploadedpicture"
""
"profileviews"
"2"
"reputation"
"0"
"postcount"
"1"
"topiccount"
"1"
"lastposttime"
"1542893552974"
"banned"
"0"
"status"
"online"
"gdpr_consent"
"0"
"acceptTos"
"0"
"uid"
"1"
"password"
"XXXXXXXXXXXXXXXXXXXXXXXXXX"
"passwordExpiry"
"0"
"groupTitle"
"["administrators"]"
"auid"
"3074"

<baris>

@Simos said in Forcing UID value:

"auid"
"3074"

It exists as part of the user hash, but if you don't save it into auid:uid then sortedSetScore will always return null. You need to set it into auid:uid as well with db.sortedSetAdd('auid:uid', uid, auid, callback);

Simos

@baris i'm losing my self again ... i've already added that value to user hash on user create, in wich part of plugin now i've to save it into auid:uid with the function you have mentioned ?
I'm new to redis ... pheraps i'm confused because i usually use mysql , but i 've understand that is completly different.

<baris>

Gotto do it when you create the user, so same place as you set it in user hash.

Simos

@baris
I suppose after user creation ... as i don't understand how i should pass uid before having it ...

<baris>

Yes, you should be able to do it in action:user.create

Simos

@baris how can i do for already existent user who already have auid but only in hash ?

<baris>

You need to load the value from the user hash and call db.sortedSetAdd('auid:uid', uid, auid, callback);

Simos

@baris my problem problem is :

how i can call db.sortedSetAdd('auid:uid', uid, auid, callback); on action:user.create ? i don't have uid until user is already created.

@baris said in Forcing UID value:

You need to load the value from the user hash and call db.sortedSetAdd('auid:uid', uid, auid, callback);

i mean some command to do it using redis-cli

<baris>

@Simos said in Forcing UID value:

action:user.create

This hook is fired after user is created, if you need to set it for users that are already in the database you need to go through them with a script and call it.

Simos

\o/ I've finally get the plugin work !!! Thanks a lot to all for your patience.
I'll publish soon it on github with a readme and instruction to have user login check rest api with anope IRC services, hoping it will be useful for someone

Simos

@baris wich action hook i can use to fix existent users and apply db.sortedSetAdd('auid:uid', uid, auid, callback); for them ?
this is my full plugin https://github.com/SimosNap/nodebb-plugin-login-anope

<baris>

Hooks won't let you fix existing users, you need to write custom script to run through all the users and fix the association.

You can use this template

/*globals require, console, process */
'use strict';

var nconf = require('nconf');
var async = require('async');

nconf.file({
	file: 'config.json'
});

nconf.defaults({
	base_dir: __dirname,
	views_dir: './build/public/templates',
});

var db = require('./src/database');

db.init(function(err) {
	if (err) {
		console.log("NodeBB could not connect to your database. Error: " + err.message);
		process.exit();
	}

	fixAssociation(function (err) {
		if (err) {
			console.error(err);
			process.exit();
		}
		console.log('done');
		process.exit();
	});
});

function fixAssociation(callback) {
// implement code
}

Simos

@baris thanks.

I've just 2 new problems :

https://github.com/SimosNap/nodebb-plugin-login-anope/blob/master/library.js#L116
it look it can't change email what's wrong ?
on IRC nicknames can also contain same special chars for example "nick`out" , i've seen that if an user switch to one of this nickname, i've seen that nodebb preserve the old username, any suggestion for this ?