Community

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Searching for a user by the "location" field

General Discussion

2 Posts 2 Posters 279 Views

K Offline

K Offline
kfirba
wrote on last edited by

#1

Hey!

We are using the Postgress database driver to store our data.
When we imported all users, we used the "location" field to store the user's id.

What I need now is a way to get nodebb's user id by the "location" field. What I want is to reverse-sync the ids back to our main DB.

I've tried to hunt around the source code, but couldn't find a way to do it. Is there any way I can achieve that?

Thanks!
1 Reply Last reply
0
J Offline

J Offline
JJSagan
wrote on last edited by JJSagan

#2

I don't have an answer for you...
However, I did note that you are using PG. To that end, make sure to update the driver:
https://community.nodebb.org/topic/13480/redactor-error-handler-postgresql-error-on-8000-characters-message
1 Reply Last reply
0

Suggested Topics

T

Mention all users
Scheduled Pinned Locked Moved General Discussion

0 Votes

2 Posts

287 Views

D

You could create a group "all" which is private - hidden - no tags.

Every user is member of this group. So you cloud mention the group @all where all users are members.

Greets
B

Average user can't upload vidoes
Scheduled Pinned Locked Moved General Discussion

0 Votes

6 Posts

1633 Views

L

I too have problem with uploading and could you find a solution for this
M

Trying to purge users from command line `node purge.js user`.
Scheduled Pinned Locked Moved Solved General Discussion node purge userapi

0 Votes

3 Posts

1555 Views

M

@baris Hm was doing similar approach, please check my another question with path.js error.
U

Design decision for User integration
Scheduled Pinned Locked Moved General Discussion

0 Votes

2 Posts

933 Views

J

The recommended method of sharing sessions between two separate and distinct applications is through OAuth2. We recommend this approach because NodeBB maintains its own user records, so that we can keep track of user-related metrics and other data. Relying on another database would be tricky, prone to breaking, and quite possibly dangerous.

Luckily, it's quite straightforward to get things working with OAuth2!

The first step is getting your application to expose an OAuth2 endpoint. If you're running a Node.js based app, you can use a module called OAuth2orize.

Once that is set up, you'll want to take a look at the SSO plugin skeleton for customised OAuth deployments -- nodebb-plugin-sso-oauth. You'll take this plugin, fork it, and modify it to communicate with your OAuth endpoint.

Once everything is working properly, you should be able to register and log in/out via your web app.
A

How to block registration from invalid emails? New User Registration Spam
Scheduled Pinned Locked Moved General Discussion

0 Votes

4 Posts

1942 Views

A

@a_5mith That's awesome!

Copyright © 2023 NodeBB | Contributors