Thanks for your help Michel.
Please let know how do i login NS users in odoo12. After installation i have created users on nethserver portal. but same created users are not able to login in odoo12. Please help to connect both.
Both are on same server.
Hi Hitest,
You have to create the users in Odoo not in NethServer.
You can also import users to Odoo but it has to be from a CSV file.
I you have just a few users, it is better to create them.
If you have a lot of users, you can use LibreOffice Calc to convert TSV file to CSV but Odoo will not be able to use the encrypted password from the CSV file… Much better to create the users manually.
Michel-André
Hi Michel,
i wanted to centralize login system with odoo and NS7. like LDAP.
If i create user in NS7 it automatically creates in odoo
There should be an ldap module, here are some configuration hints:
You can get the needed LDAP/AD information in old server manager “domain accounts” or new server manager in “users and groups/details” or on command line with account-provider-test dump
Dear @mrmarkuz,
Very Nice post, and also i have followed same post for odoo11 installation. Installation done successfully without an error. All services systemctl start odoo11 showing status active.
netstat -tulnp is also showing 8069 port occupied.
EVEN ALL FIREWALL THING IS DISABLED.
BUT I AM NOT ABLE TO ACCESS WEBPAGE ON MY BROWSER - http:// url:8069
Please help solve this issue.
curl -I http://ip :8069
Do you want to reach the site on public IP?
Then you need to change the firewall settings to allow access from red.
config set fw_odoo service status enabled TCPPort 8069 access green,red
signal-event firewall-adjust
Do you get an error message in browser?
Thanks
This is solved by using reverse proxy defined virtual host.
Problem solved !
BUT I WANT TO INTEGRATE WITH NS LDAP with odoo Ldap plugin.
i have filled all info provided by this command “account-provider-test dump” LDAP info in odoo ldap plugin but still user is not syncing with each other.
please support to find this problem .
These LDAP settings work for me:
Server Information
LDAP Server address: 127.0.0.1
LDAP Server port: 389
Use TLS: no
Login Information
LDAP binddn: cn=ldapservice,dc=directory,dc=nh
LDAP password: password of ldapservice user
Process Parameter
LDAP base: dc=directory,dc=nh
LDAP filter: (&(objectClass=person)(uid=%s))
Sequence: 10
User Information
Create User: yes
Template User: [Demo User] (just for testing, create a template user for production)
For AD settings see Howto install Odoo 10
Hi @mrmarkuz ,
Thanks for reply.
i did same settings but users are not replicated. My odoo11 is with NS reverse proxy and hosted on same server, as followed your post. please see below settings. Please help me to resolve this.
There’s no replication of all users.
When you login to Odoo with an LDAP user the first time, the user is created from the template user in the odoo database.
Hi @mrmarkuz,
I couldn’t understand this point of integration. NS has Ldap and Odoo is connected with NS Ldap, Conceptually NS users should login in odoo and odoo users should login in NS.
why if you create a user with Odoo not be able to use the same login credential for Mattermost or nextcloud or email or other services in NS7 vice-versa.
Please clear my doubts. Great thanks to you.
Regards
Hitesh
I’m sorry, this is how the Odoo module works.
On Odoo login, the user login is checked against the odoo database. If there’s no user entry then LDAP is searched. If the user is in LDAP database it is created in the odoo database.
Why do you need replication of all users?
If you create a user on Nethserver, you can login to Odoo with this user like you can login to Nextcloud.
Management of LDAP users should be done with Nethserver and not in the served applications.
Mattermost doesn’t use LDAP:
http://docs.nethserver.org/en/v7/team_chat.html#authentication
I want only integrate NS with LDAP and these users should authenticate with odoo. If NS users, they should be able to login.
Hi @mrmarkuz
i have added all setting of NS LDAP and both (NS+odoo) are on the same server. As followed ldap creds.
[root@cloud odoo]# account-provider-test dump
{
“BindDN” : “cn=ldapservice,dc=directory,dc=nh”,
“LdapURI” : “ldap://127.0.0.1”,
“DiscoverDcType” : “dns”,
“StartTls” : “”,
“port” : 389,
“host” : “127.0.0.1”,
“isAD” : “”,
“isLdap” : “1”,
“UserDN” : “ou=People,dc=directory,dc=nh”,
“GroupDN” : “ou=Groups,dc=directory,dc=nh”,
“BindPassword” : “_8CNwb_SkSf9cHkZ”,
“BaseDN” : “dc=directory,dc=nh”,
“LdapUriDn” : “ldap:///dc%3Dzenlab%2Cdc%3Dit”
}
But when i am integrating with odoo Ldap module and written all settings into required fields. But i am not getting any successfull logs, pls go through my logs.
pls help me to troubleshoot this.
Please check if you use a correct LDAP filter.
In your screenshot you use an LDAP filter for Active Directory. In LDAP uid is used instead of samaccountname.
Hi,
i have tried this LDAP filter: (&(objectClass=person)(uid=%s)) But still not solved.
What exactly is not working now?
From the logs it looks like the odoo user is created when logging in as ldap user so you should be able to login with LDAP users.
LDAP users means (Nethserver Users) are not able to login in odoo. This the issue.
Did you try to use only the username without domain like “test34” instead of "test34@domain.com" at login?
