Hi,
Natively, the auth_db supports only SQL databases.
Options you have:
1) try simulating an SQL DB from a noSQL one, by using the db_cachedb
module [1]
2) use the pv_proxy_authorize() function [2] and push the credentials
from script level - and you can have the prior loaded from Mongo via the
cache_fetch() [3] function.
[1] https://opensips.org/html/docs/modules/3.4.x/db_cachedb.html
[2]
https://opensips.org/html/docs/modules/3.4.x/auth.html#func_pv_proxy_authorize
[3]
https://www.opensips.org/Documentation/Script-CoreFunctions-3-4#cache_fetch
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
https://www.opensips-solutions.com
https://www.siphub.com
On 11/1/23 9:07 AM, Harsh Patel via Users wrote:
I am currently using MySQL to proxy authorization using the
*auth_db*module. I am utilizing the *proxy_authorize*function to
authorize users in a MySQL table, and it is working perfectly.
However, I need to switch to *MongoDB* as my database instead of
MySQL. The issue is that it appears *auth_db* only supports *MySQL*
and *PostgreSQL* databases. *My concern is that I must use MongoDB as
the database for authorization in OpenSIPS. Is it possible to
authorize users in OpenSIPS using MongoDB with the auth_db module, or
should I consider an alternative module or approach?*
*
*
*Load auth_db module*
loadmodule "auth_db.so"
modparam("auth_db", "db_url",
"mysql://DB_USER:DB_PASSWORD@DB_HOST/DB_NAME")
modparam("auth_db", "load_credentials", "$avp(tmp_id)=id")
modparam("auth_db", "calculate_ha1", yes)
modparam("auth_db", "password_column", "password")
check condition in routes.
if (!proxy_authorize("", "TABLE)_NAME")) {
proxy_challenge("", "0");
exit;
*}*
Best Regards,
----
Harsh Patel
Team Lead.
Inextrix Technologies Pvt Ltd (www.inextrix.com)
Mo: +1 315 898 1049
https://www.inextrix.com/
Disclaimer:
The information contained in this communication is confidential and
may be legally privileged. It is intended solely for the use of the
individual or entity to whom it is addressed and others authorized to
receive it. If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking action
in reliance on the contents of this information is strictly prohibited
and may be unlawful. Please notify the sender immediately and destroy
all copies of this message and any attachments contained in it.
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
