DHIS2 with openLDAP

See also questions close to this topic

• ERROR: invalid byte sequence for encoding WITH psql

  I've seen numerous issues in other posts with the copy command and:

  ERROR:  invalid byte sequence for encoding "UTF8": 0xfc
  

  And the consensus in these posts appears to be to specify the encoding in the command you're doing the copy with. I have done so:

  psql -h localhost -p 5432 -d BOBDB -U BOB -c "\COPY \"BOBTB01\" FROM 'C:\Temp\file.csv' with csv HEADER ENCODING 'WIN1252'";
  Password for user BOB:
  **ERROR:  character with byte sequence 0x81 in encoding "WIN1252" has no equivalent in encoding "UTF8"
  CONTEXT:  COPY BOBTB01, line 76589**
  

  So, that confused me and I changed to UTF8 to WIN1252 and having done so I get a slightly different error, the failure is on a different line and the text is slightly different.

  psql -h localhost -p 5432 -d BOBDB -U BOB -c "\COPY \"BOBTB01\" FROM 'C:\Temp\file.csv' with csv HEADER ENCODING 'UTF8'";
  Password for user BOB:
  **ERROR:  invalid byte sequence for encoding "UTF8": 0xfc
  CONTEXT:  COPY BOBTB01, line 163**
  

  This is the encoding shown in the database:

  show client_encoding;
   client_encoding
  -----------------
   UTF8
  (1 row)
  

  The file is from a reliable source and I happen to have "R" installed which also does .csv import. The file was pulled into "R" without issue, that's making me think it's not the file but something else. Is there another switch or syntax that can bypass these issues perhaps?

  I'm not sure what is wrong.

  Can you help?

  Thanks.
• Whats missing on my Ruby 'Inverse Of' relationship

  I know this topic has been addressed, but I have been at this for 2 days and I'm just stuck. I know inverse of does not create a new query, so should I use another method?

  Question: How to set up an 'inverse of' with a has_one, belongs_to situation & same class..

  Explanation: A user 'has_one :spouse' and 'belongs_to :spouse_from'. They are inverse of each other. When a User signs up, they can invite their significant other. For Example

  1. user_a invites & creates user_b
  2. user_b.spouse_id is set to user_a.id
  3. In a separate method I want to be able to update like.. user_a.spouse_id = user_a.spouse.id

  The only association that works at this point is user_b.spouse.

   Class User
    has_one :spouse, class_name: 'User', foreign_key: :spouse_id, dependent: :nullify, inverse_of: :spouse_from
  
  
    belongs_to :spouse_from, class_name: 'User', foreign_key: :spouse_id, inverse_of: :spouse, optional: true
  
• Normalizing data in postgresql

  Flag This application will read an iTunes library in comma-separated-values (CSV) and produce properly normalized tables as specified below. Once you have placed the proper data in the tables, press the button below to check your answer.

  We will do some things differently in this assignment. We will not use a separate "raw" table, we will just use ALTER TABLE statements to remove columns after we don't need them (i.e. we converted them into foreign keys).

  We will use the same CSV track data as in prior exercises - this time we will build a many-to-many relationship using a junction/through/join table between tracks and artists.

  To grade this assignment, the program will run a query like this on your database and look for the data it expects to see:

  
  SELECT track.title, album.title, artist.name
  FROM track
  JOIN album ON track.album_id = album.id
  JOIN tracktoartist ON track.id = tracktoartist.track_id
  JOIN artist ON tracktoartist.artist_id = artist.id
  ORDER BY track.title
  LIMIT 3;
  

  Expected out put is this

  The expected result of this query on your database is: title album artist A Boy Named Sue (live) The Legend Of Johnny Cash Jo

  
  DROP TABLE album CASCADE;
  CREATE TABLE album (
      id SERIAL,
      title VARCHAR(128) UNIQUE,
      PRIMARY KEY(id)
  );
  
  DROP TABLE track CASCADE;
  CREATE TABLE track (
      id SERIAL,
      title TEXT, 
      artist TEXT, 
      album TEXT, 
      album_id INTEGER REFERENCES album(id) ON DELETE CASCADE,
      count INTEGER, 
      rating INTEGER, 
      len INTEGER,
      PRIMARY KEY(id)
  );
  
  DROP TABLE artist CASCADE;
  CREATE TABLE artist (
      id SERIAL,
      name VARCHAR(128) UNIQUE,
      PRIMARY KEY(id)
  );
  
  DROP TABLE tracktoartist CASCADE;
  CREATE TABLE tracktoartist (
      id SERIAL,
      track VARCHAR(128),
      track_id INTEGER REFERENCES track(id) ON DELETE CASCADE,
      artist VARCHAR(128),
      artist_id INTEGER REFERENCES artist(id) ON DELETE CASCADE,
      PRIMARY KEY(id)
  );
  
  \copy track(title,artist,album,count,rating,len) FROM 'library.csv' WITH DELIMITER ',' CSV;
  
  INSERT INTO album (title) SELECT DISTINCT album FROM track;
  UPDATE track SET album_id = (SELECT album.id FROM album WHERE album.title = track.album);
  
  INSERT INTO tracktoartist (track, artist) SELECT DISTINCT ...
  
  INSERT INTO artist (name) ...
  
  UPDATE tracktoartist SET track_id = ...
  UPDATE tracktoartist SET artist_id = ...
  
  -- We are now done with these text fields
  ALTER TABLE track DROP COLUMN album;
  ALTER TABLE track ...
  ALTER TABLE tracktoartist DROP COLUMN track;
  ALTER TABLE tracktoartist ...
  
  SELECT track.title, album.title, artist.name
  FROM track
  JOIN album ON track.album_id = album.id
  JOIN tracktoartist ON track.id = tracktoartist.track_id
  JOIN artist ON tracktoartist.artist_id = artist.id
  LIMIT 3;
  

  What am i doing wrong with the code?
• how do i store maven dependencies inside docker image using a Dockerfile

  so im making a spring boot application that im supposed to put in and run from a docker container, and i would like to build the whole image using a docker file.
  im using this dockerFile:

  FROM openjdk:8-jdk-alpine
  ADD . /analytics-service
  WORKDIR /analytics-service
  ENTRYPOINT ./mvnw spring-boot:run 
  

  when i create the image it just copies the files, and only after i run it, it starts downloading all the maven dependencies. which takes a while, given that i will be running a few containers. so how do i do it ? i want it to get all the dependencies when the image is created, so when i create a container it doesnt start downloading.
• Uncaught Error: Class 'Service\UsersService' not found

  I'm trying to run my php-based application, which connects to a mysql DB, launched through docker-compose.

  i get this message when i connect to localhost:

  Fatal error: Uncaught Error: Class 'Service\UsersService' not found in /var/www/html/dic/users.php:3 Stack trace: #0 /var/www/html/web/index.php(3): require() #1 {main} thrown in /var/www/html/dic/users.php on line 3

  user.php

  <?php
  
  return new Service\UsersService(
      require "../config/db-connection.php"
  );
  

  UsersService.php

  <?php
  
  namespace Service;
  
  use Entity\User;
  use PDO;
  
  class UsersService
  {
      protected $db;
  
      public function __construct(PDO $db)
      {
          $this->db = $db;
      }
  
      public function getLastJoined(): array
      {
          return $this->db->query(
              "SELECT id, joined, name FROM user ORDER BY joined DESC LIMIT 10"
          )->fetchAll(PDO::FETCH_CLASS, User::class);
      }
  
      public function getById(string $id): ?User
      {
          $user = $this->db->query("SELECT id, joined, name FROM user WHERE id = " . $this->db->quote($id))->fetchObject(User::class);
  
          return ($user === false) ? null: $user;
      }
  }
  

  index.php

  <?php
  
  $lastJoinedUsers = (require "../dic/users.php")->getLastJoined();
  
  switch (require "../dic/negotiated_format.php") {
      case "text/html":
          (new Views\Layout(
              "Twitter - Newcomers", new Views\Users\Listing($lastJoinedUsers), true
          ))();
          exit;
  
      case "application/json":
          header("Content-Type: application/json");
          echo json_encode($lastJoinedUsers);
          exit;
  }
  
  http_response_code(406);
  

  I appreciate any help!!
• Docker compose specified port not mapping to connect to the health check endpoint

  I am a newbie to docker. This is the layout I am working with. I have 2 projects in the docker compose file. A dotnet6 web api and a mvc web app. In the web api startup.cs I have the following code to get health statuses using AspNetCore.HealthChecks.UI, If I browse to the endpoint I get a json object of health check values (this part works)

  app.UseEndpoints(endpoints =>
     {
      endpoints.MapControllers();
      endpoints.MapHealthChecks("/hc", new HealthCheckOptions
        {
          Predicate = _ => true,
          ResponseWriter = UIResponseWriter.WriteHealthCheckUIResponse
        });
    });
  

  I have a WebStatus .Net core MVC app whose job is to display health stats using the healthcheck UI. The appsetting for this is:

  {
    "HealthChecks-UI": {
      "HealthChecks": [
        {
          "Name": "TestApp API Health Check",
          "Uri": "https://localhost:7100/hc"
        },
        {
          "Name": "TestApp API Health Check (Local)",
          "Uri": "https://localhost:7141/hc"
        }
      ],
      "Webhooks": [
        {
          "Name": "",
          "Uri": "",
          "Payload": "",
          "RestoredPayload": ""
        }
      ],
      "EvaluationTimeOnSeconds": 10,
      "MinimumSecondsBetweenFailureNotifications": 60
    },
    "Logging": {
      "LogLevel": {
        "Default": "Information",
        "Microsoft": "Warning",
        "Microsoft.Hosting.Lifetime": "Information"
      }
    },
    "AllowedHosts": "*"
  }
  
  

  And the docker compose file is as shown below

  version: '3.4'
  
  services:
    testapp.api:
      environment:
        - ASPNETCORE_ENVIRONMENT=Development
        - ASPNETCORE_URLS=https://+:443;http://+:80
      ports:
        - "8005:80"
        - "7100:443"
      volumes:
        - ${APPDATA}/Microsoft/UserSecrets:/root/.microsoft/usersecrets:ro
        - ${APPDATA}/ASP.NET/Https:/root/.aspnet/https:ro
  
    webstatus:
      environment:
        - ASPNETCORE_ENVIRONMENT=Development
        - ASPNETCORE_URLS=https://+:443;http://+:80
        - HealthChecksUI__HealthChecks__0__Name=Test App API Health Check
        - HealthChecksUI__HealthChecks__0__Uri=https://testapp.api/hc
      ports:
        - "8006:80"
        - "7101:443"
      depends_on:
        - testapp.api
      volumes:
        - ${APPDATA}/Microsoft/UserSecrets:/root/.microsoft/usersecrets:ro
        - ${APPDATA}/ASP.NET/Https:/root/.aspnet/https:ro
  
  

  If I start both the projects without docker, everything works, the WebStatus app shows the health status of the api as expected! However it doesn't work when I use docker compose to run this. The url I use to get to the webstatus app is https://localhost:7101/healthchecks-ui#/healthchecks

  
• Can we use openldap proxy with opendj server as backend

  I am trying to use openldap proxy as a proxy against an opendj server instance. I am getting following error when I try to do ldap search via proxy.

  May  6 10:05:44 openldapproxy slapd[42116]: conn=1001 op=0 BIND dn="cn=Directory Manager" method=128
  May  6 10:05:44 openldapproxy slapd[42116]: conn=1001 op=0 RESULT tag=97 err=49 text=
  May  6 10:05:44 openldapproxy slapd[42116]: conn=1001 op=1 UNBIND
  May  6 10:05:44 openldapproxy slapd[42116]: conn=1001 fd=11 closed
  

  When I use openldap proxy against an openldap sever instance it works properly. I am not using any proxy cache. Can openldap proxy work with opendj or there is some RFC implementation missing.
• Did I import inetOrgPerson schema correctly for OpenLDAP on Alpine Linux?

  I'm trying to import a user into OpenLDAP on Alpine Linux. Here's the LDIF that I named searchUser.ldif:

  # Search account
  dn: uid=search,dc=home
  changetype: add
  objectClass: top
  objectClass: person
  objectClass: inetOrgPerson
  cn: search
  sn: search
  uid: search
  

  The command I used to import it is:

  ldapadd -x -D "cn=Manager,dc=home" -w supersecret -f searchUser.ldif
  

  The error I get is:

  ldap_add: Invalid syntax (21) additional info: objectClass: value #2 invalid per syntax
  

  My understanding of this is the objectClasses are numbered, starting with 0, and that #2 indicates the problem is with inetOrgPerson.

  I've done this successfully using OpenLDAP on Raspberry Pi OS (debian). However, I get the feeling the Debian package automates some configuration steps that the Alpine package does not. One of those steps I think Debian does during the package install is to import inetOrgPerson schema.

  I've tried to do the schema import manually. Here are the steps I took prior to trying the LDIF import...

  I scripted my install of OpenLDAP on Alpine, like so:

  export DOMAIN="dc=home"
   
  echo "Installing packages..."
  apk add openldap openldap-back-mdb openldap-clients
   
  echo "Configuring for v2.3+ style slapd.d config directory..."
  install -m 755 -o ldap -g ldap -d /etc/openldap/slapd.d
  sed -i~ \
    -e 's/^cfgfile=/#cfgfile=/' \
    -e 's/^#cfgdir=.*/cfgdir=\"\/etc\/openldap\/slapd.d\"/' \
    /etc/conf.d/slapd
  rm /etc/openldap/slapd.conf
   
  echo "Customizing for domain: ${DOMAIN}..."
  sed -i~ \
    -e 's/\.la$/.so/' \
    -e "s/dc=my-domain,dc=com/${DOMAIN}/" /etc/openldap/slapd.ldif
   
  echo "Importing configuration..."
  slapadd -n 0 -F /etc/openldap/slapd.d -l /etc/openldap/slapd.ldif
  chown -R ldap:ldap /etc/openldap/slapd.d/*
   
  echo "Configuring slapd service..."
  install -m 755 -o ldap -g ldap -d /var/lib/openldap/run
  service slapd start
  rc-update add slapd
  

  The slapd service started and I could connect to it with command-line tools and from a client over port 389. So far, so good.

  The next thing I did was to import schema for cosine and inetOrgPerson. I believe the Debian package did this automatically, because I don't recall having to do this previously.

  Here's what I did on Alpine to import the schema:

  slapadd -n 0 -F /etc/openldap/slapd.d -l /etc/openldap/schema/cosine.ldif
  slapadd -n 0 -F /etc/openldap/slapd.d -l /etc/openldap/schema/inetorgperson.ldif
  

  There were no errors.

  I then created an organization using the command ldapadd -x -D "cn=Manager,dc=home" -w secret -f org.ldif and this LDIF as org.ldif:

  dn: dc=home
  objectclass: dcObject
  objectclass: organization
  o: Home
  dc: home
  
  dn: cn=Manager,dc=home
  objectclass: organizationalRole
  cn: Manager
  

  This too was successful.

  I can also create organizational units with this LDIF:

  # Organizational unit for users
  dn: ou=People,dc=home
  changetype: add
  objectClass: organizationalUnit
  ou: People
  
  # Organizational unit for groups.
  dn: ou=Groups,dc=home
  changetype: add
  objectClass: organizationalUnit
  ou: Groups
  

  So I think my server is okay, but I may have done something wrong with the inetOrgPerson schema import that's causing the Invalid syntax (21) error.

  Is the way I'm importing the inetOrgPerson schema correct? Is there a way to verify it?
• DHIS2 core docker container restarting due to missing privileges for chown

  I'm following this guide to launch a docker container of DHIS2 on a Mac (Big Sur) and the core container keeps restating on me because Tomcat's server.xml can't be chowned. Here's the tail of the log:

    inflating: /usr/local/tomcat/webapps/ROOT/dhis-web-sms-configuration/safari-pinned-tab.svg  
    inflating: /usr/local/tomcat/webapps/ROOT/dhis-web-sms-configuration/package.json  
    inflating: /usr/local/tomcat/webapps/ROOT/dhis-web-sms-configuration/favicon.ico  
    inflating: /usr/local/tomcat/webapps/ROOT/dhis-web-sms-configuration/service-worker.js  
    inflating: /usr/local/tomcat/webapps/ROOT/dhis-web-sms-configuration/favicon-48x48.png  
    inflating: /usr/local/tomcat/webapps/ROOT/dhis-web-sms-configuration/manifest.webapp  
    inflating: /usr/local/tomcat/webapps/ROOT/META-INF/maven/org.hisp.dhis/dhis-web-portal/pom.xml
    inflating: /usr/local/tomcat/webapps/ROOT/META-INF/maven/org.hisp.dhis/dhis-web-portal/pom.properties  
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  chown: changing ownership of '/usr/local/tomcat/conf/server.xml': Operation not permitted
  

  This is the docker-compose.yml file:

  version: '3'
  services:
    core:
      image: "${DHIS2_CORE_IMAGE}"
      user: root
      restart: always
      volumes:
        - ${DHIS2_CORE_CONFIG:-./config/DHIS2_home/dhis.conf}:/DHIS2_home/dhis.conf
        - ./config/server.xml:/usr/local/tomcat/conf/server.xml
        - ./config/DHIS2_home:/DHIS2_home
      environment:
        CATALINA_OPTS: "-Dcontext.path='${DHIS2_CORE_CONTEXT_PATH:-}'"
      depends_on:
        - "db"
    db:
      image: "mdillon/postgis:10-alpine"
      command: "postgres -c max_locks_per_transaction=100"
      restart: always
      volumes:
        - datadb:/var/lib/postgresql/data
      environment:
        POSTGRES_DB: dhis2
        POSTGRES_USER: dhis
        POSTGRES_PASSWORD: dhis
    gateway:
      image: "jwilder/nginx-proxy:alpine"
      restart: always
      ports:
        - "${DHIS2_CORE_PORT}:80"
      volumes:
        - ./config/nginx.conf:/etc/nginx/nginx.conf:ro
        - ./.apps:/data/apps:ro
        - /var/run/docker.sock:/tmp/docker.sock:ro
  volumes:
    datadb:
    home:
  

  I added the user: root there but it made no difference. With the container restarting I get a 502 Bad Gateway when I try to access the instance via http://localhost:8080. It would seem as if the user that inflates the files does not have enough privileges to do a chown on the server.xml file.

  Is there a way to permanently fix this? Is there an elevated way to bring the cluster up or a way to change the effective permission of the user in the container?
• embedding dhis2 map in to javascript web application

  I'm trying to embed dhis2 map to my web application but I am facing an issue which says DHIS is not not define. Please can anyone help me to solve this? Here is the code:

  var base = "server.com";
   $(document).ready(function(){
      Ext.onReady( function() {
          Ext.Ajax.request({
          url: base + "dhis-web-commons/security/login.action",
          method: "POST",
           params: { j_username: "my_username", j_password: "my_password" },
           headers:{'Content-Type': 'application/json'},
           success: setLinks,
           failure: function(response) {
               console.log("logged in failed, try again later");
           }
          });
        });
   })
  function setLinks(){
      DHIS.getMap({ url: base, el: "map1", id: "map_id" });
  }```