{"id":43,"date":"2017-10-09T10:23:00","date_gmt":"2017-10-09T10:23:00","guid":{"rendered":"https:\/\/linuxadmin.melberi.com\/uncategorized\/openproject-ldap-active-directory"},"modified":"2017-10-09T15:15:00","modified_gmt":"2017-10-09T15:15:00","slug":"openproject-ldap-not-working","status":"publish","type":"post","link":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working","title":{"rendered":"OpenProject Ldap Authentication Not Working"},"content":{"rendered":"<p>How to Configure LDAP Authentication in OpenProject.\u00a0Active Directory\u00a0Authentication Not Working | Solved<\/p>\n<h3><u>Error:<\/u><\/h3>\n<p>Ldap Authentication Not working in Openldap.<\/p>\n<h3 style=\"text-align: left;\"><u>Reason:\u00a0<\/u><\/h3>\n<p>There is a bug in the auth_sources table.<\/p>\n<p>&#8220;type&#8221; field in the auth_sources table in the database was not filled in. After setting the value of \u00a0auth source to &#8216;LdapAuthSource&#8217;, Ldap Authentication started working.<\/p>\n<h3><u>Solution:<\/u><\/h3>\n<p>Login to MYSql Database<\/p>\n<p><strong>#mysql -u root -p \u00a0(enter the admin password)<\/strong><br \/>\n<strong> #show databases;<\/strong><br \/>\n<strong> #use openproject_db<\/strong><br \/>\n<strong> #update auth_sources set type = &#8216;LdapAuthSource&#8217;;<\/strong><\/p>\n<p>Thats all,<\/p>\n<h3 style=\"text-align: left;\"><b><u>Authentication Mode (LDAP) Config:<\/u><\/b><\/h3>\n<div class=\"separator\" style=\"clear: both; text-align: center;\"><a style=\"clear: left; float: left; margin-bottom: 1em; margin-right: 1em;\" href=\"http:\/\/3.bp.blogspot.com\/-Rf9ZZEj2SvA\/VcSGO1gDsqI\/AAAAAAAABdU\/-PM03c8pbmw\/s1600\/openldap%2Bldap%2Bauth.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"OpenProject Ldap Authentication \" src=\"https:\/\/www.melberi.com\/linuxadmin\/wp-content\/uploads\/sites\/3\/2015\/08\/openldapldapauth.jpg\" alt=\"OpenProject Ldap Authentication \" width=\"458\" height=\"640\" border=\"0\" \/><\/a><\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Configure LDAP Authentication in OpenProject.\u00a0Active Directory\u00a0Authentication Not Working | Solved Error: Ldap Authentication Not working in Openldap. Reason:\u00a0 There is a bug in the auth_sources table. &#8220;type&#8221; field&#8230; <a href=\"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":209,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[91,117],"tags":[],"class_list":["post-43","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ldap","category-openproject"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"How to Configure LDAP Authentication in OpenProject. Active Directory Authentication Not Working | Solved Error: Ldap Authentication Not working in Openldap. Reason: There is a bug in the auth_sources table. &quot;type&quot; field in the auth_sources table in the database was not filled in. After setting the value of auth source to &#039;LdapAuthSource&#039;, Ldap Authentication started working. Solution:\" \/>\n\t<meta name=\"robots\" content=\"max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n\t<meta name=\"author\" content=\"admin\"\/>\n\t<meta name=\"msvalidate.01\" content=\"F5B964E0B63F681BBDE95AB72193D75E\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working#article\",\"name\":\"OpenProject Ldap Authentication Not Working - Linux How To\",\"headline\":\"OpenProject Ldap Authentication Not Working\",\"author\":{\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/author\\\/admin#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2015\\\/08\\\/openldapldapauth.jpg\",\"width\":460,\"height\":640},\"datePublished\":\"2017-10-09T10:23:00+00:00\",\"dateModified\":\"2017-10-09T15:15:00+00:00\",\"inLanguage\":\"en-US\",\"commentCount\":2,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working#webpage\"},\"articleSection\":\"LDAP, OPENPROJECT\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/category\\\/ldap#listItem\",\"name\":\"LDAP\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/category\\\/ldap#listItem\",\"position\":2,\"name\":\"LDAP\",\"item\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/category\\\/ldap\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working#listItem\",\"name\":\"OpenProject Ldap Authentication Not Working\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working#listItem\",\"position\":3,\"name\":\"OpenProject Ldap Authentication Not Working\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/category\\\/ldap#listItem\",\"name\":\"LDAP\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/#organization\",\"name\":\"Linux How To\",\"url\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2021\\\/06\\\/MelB.png\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working\\\/#organizationLogo\",\"width\":320,\"height\":320},\"image\":{\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/author\\\/admin#author\",\"url\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/author\\\/admin\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1ee7acbcab1a0ae6b35481c34cd31ee5c4d15292f5a1e069321cd34f1ceccd11?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"admin\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working#webpage\",\"url\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working\",\"name\":\"OpenProject Ldap Authentication Not Working - Linux How To\",\"description\":\"How to Configure LDAP Authentication in OpenProject. Active Directory Authentication Not Working | Solved Error: Ldap Authentication Not working in Openldap. Reason: There is a bug in the auth_sources table. \\\"type\\\" field in the auth_sources table in the database was not filled in. After setting the value of auth source to 'LdapAuthSource', Ldap Authentication started working. Solution:\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/author\\\/admin#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/author\\\/admin#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2015\\\/08\\\/openldapldapauth.jpg\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working\\\/#mainImage\",\"width\":460,\"height\":640},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/openproject\\\/openproject-ldap-not-working#mainImage\"},\"datePublished\":\"2017-10-09T10:23:00+00:00\",\"dateModified\":\"2017-10-09T15:15:00+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/#website\",\"url\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/\",\"name\":\"Linux How To\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.melberi.com\\\/linuxadmin\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"OpenProject Ldap Authentication Not Working - Linux How To","description":"How to Configure LDAP Authentication in OpenProject. Active Directory Authentication Not Working | Solved Error: Ldap Authentication Not working in Openldap. Reason: There is a bug in the auth_sources table. \"type\" field in the auth_sources table in the database was not filled in. After setting the value of auth source to 'LdapAuthSource', Ldap Authentication started working. Solution:","canonical_url":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working","robots":"max-snippet:-1, max-image-preview:large, max-video-preview:-1","keywords":"","webmasterTools":{"msvalidate.01":"F5B964E0B63F681BBDE95AB72193D75E","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working#article","name":"OpenProject Ldap Authentication Not Working - Linux How To","headline":"OpenProject Ldap Authentication Not Working","author":{"@id":"https:\/\/www.melberi.com\/linuxadmin\/author\/admin#author"},"publisher":{"@id":"https:\/\/www.melberi.com\/linuxadmin\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.melberi.com\/linuxadmin\/wp-content\/uploads\/sites\/3\/2015\/08\/openldapldapauth.jpg","width":460,"height":640},"datePublished":"2017-10-09T10:23:00+00:00","dateModified":"2017-10-09T15:15:00+00:00","inLanguage":"en-US","commentCount":2,"mainEntityOfPage":{"@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working#webpage"},"isPartOf":{"@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working#webpage"},"articleSection":"LDAP, OPENPROJECT"},{"@type":"BreadcrumbList","@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.melberi.com\/linuxadmin\/#listItem","position":1,"name":"Home","item":"https:\/\/www.melberi.com\/linuxadmin\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.melberi.com\/linuxadmin\/category\/ldap#listItem","name":"LDAP"}},{"@type":"ListItem","@id":"https:\/\/www.melberi.com\/linuxadmin\/category\/ldap#listItem","position":2,"name":"LDAP","item":"https:\/\/www.melberi.com\/linuxadmin\/category\/ldap","nextItem":{"@type":"ListItem","@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working#listItem","name":"OpenProject Ldap Authentication Not Working"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.melberi.com\/linuxadmin\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working#listItem","position":3,"name":"OpenProject Ldap Authentication Not Working","previousItem":{"@type":"ListItem","@id":"https:\/\/www.melberi.com\/linuxadmin\/category\/ldap#listItem","name":"LDAP"}}]},{"@type":"Organization","@id":"https:\/\/www.melberi.com\/linuxadmin\/#organization","name":"Linux How To","url":"https:\/\/www.melberi.com\/linuxadmin\/","logo":{"@type":"ImageObject","url":"https:\/\/www.melberi.com\/linuxadmin\/wp-content\/uploads\/sites\/3\/2021\/06\/MelB.png","@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working\/#organizationLogo","width":320,"height":320},"image":{"@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/www.melberi.com\/linuxadmin\/author\/admin#author","url":"https:\/\/www.melberi.com\/linuxadmin\/author\/admin","name":"admin","image":{"@type":"ImageObject","@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/1ee7acbcab1a0ae6b35481c34cd31ee5c4d15292f5a1e069321cd34f1ceccd11?s=96&d=mm&r=g","width":96,"height":96,"caption":"admin"}},{"@type":"WebPage","@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working#webpage","url":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working","name":"OpenProject Ldap Authentication Not Working - Linux How To","description":"How to Configure LDAP Authentication in OpenProject. Active Directory Authentication Not Working | Solved Error: Ldap Authentication Not working in Openldap. Reason: There is a bug in the auth_sources table. \"type\" field in the auth_sources table in the database was not filled in. After setting the value of auth source to 'LdapAuthSource', Ldap Authentication started working. Solution:","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.melberi.com\/linuxadmin\/#website"},"breadcrumb":{"@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working#breadcrumblist"},"author":{"@id":"https:\/\/www.melberi.com\/linuxadmin\/author\/admin#author"},"creator":{"@id":"https:\/\/www.melberi.com\/linuxadmin\/author\/admin#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.melberi.com\/linuxadmin\/wp-content\/uploads\/sites\/3\/2015\/08\/openldapldapauth.jpg","@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working\/#mainImage","width":460,"height":640},"primaryImageOfPage":{"@id":"https:\/\/www.melberi.com\/linuxadmin\/openproject\/openproject-ldap-not-working#mainImage"},"datePublished":"2017-10-09T10:23:00+00:00","dateModified":"2017-10-09T15:15:00+00:00"},{"@type":"WebSite","@id":"https:\/\/www.melberi.com\/linuxadmin\/#website","url":"https:\/\/www.melberi.com\/linuxadmin\/","name":"Linux How To","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.melberi.com\/linuxadmin\/#organization"}}]}},"aioseo_meta_data":{"post_id":"43","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2021-03-11 17:26:44","updated":"2026-10-21 17:36:07","focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/43","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/comments?post=43"}],"version-history":[{"count":4,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/43\/revisions"}],"predecessor-version":[{"id":601,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/43\/revisions\/601"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/media\/209"}],"wp:attachment":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/media?parent=43"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/categories?post=43"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/tags?post=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}