Server 5.11 Profile Manager Admin Site blank/empty

After about one month without access to my PM admin page I've manage to get back access.

This is what I've done (try at your own risk):

Turn off PM (via ServerApp or Terminal sudo serveradmin stop devicemgr)

delete open tasks: sudo -u _devicemgr psql -U _devicemgr -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL-12 -c "DELETE FROM library_item_tasks WHERE completed_at IS NULL"

delete finished tasks (this took very very long since it was about 49000 tasks to delete): sudo -u _devicemgr psql -U _devicemgr -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL-12 -c "DELETE FROM library_item_tasks WHERE completed_at IS NOT NULL"

Turn on PM again (via ServerApp or Terminal sudo serveradmin start devicemgr)

Hope this might be helpful. If so, please let me know!

Try this hope it helps...

"Copy and Open pg_hba.conf"

Library/Server/ProfileManager/postgreSQL/

In that folder you have the file pg_hba.conf

copy that file to desktop open it with

text editor (you must have write permission to that file)

and add the line in that file (below)(add this line)

Before do stop profilemanager service

copy back the file to Library/Server/ProfileManager/postgreSQL/

and restart the hole machine.

Hope that helps

This is the pg_hba.conf file

# PostgreSQL Client Authentication Configuration File

# ===================================================

#

# Refer to the "Client Authentication" section in the PostgreSQL

# documentation for a complete description of this file.

#

# TYPE DATABASE USER ADDRESS METHOD

local all root peer

local all _devicemgr peer

local devicemgr_v2m0 devicemgrd trust

local devicemgr_v2m0 webadmin trust

local devicemgr_v2m0 deviceservice trust

local devicemgr_v2m0 dmscepservice trust

local devicemgr_v2m0 authservice trust (add this line)

# Allow replication connections from localhost, by a user with the replication privilege.

local replication _devicemgr trust

local all all reject

I've got two solutions or workarounds which might help (from a good colleague):

1: To get it to run again, he runs the following in terminal:

sudo serveradmin stop devicemgr

/Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/config/refreshDB

sudo serveradmin start devicemgr

Then he deletes all active tasks.

2.: to keep it running:

After executing the code above he has left a safari window/tab with profile manager open on the server. So far, the problem has not occured again. Might be it does not occur as long as a PM-tab remains open constantly.

I'm really looking forward to hearing if that works for you as well.

Dont know if this help but you can try, go to Library/Server/ProfileManager/Data/PostgreSQL and look in the file pg_hba.conf if you not have this entry, try to add it (local devicemgr_v2m0 authservice trust) underscore between devicemgr and v2m0

You can test

No solution. I called Apple they took all the info from my server . Came back and said multiple people are having the issue and they are working on a fix. They offered no timetable for a fix and that was weeks ago. The fix will be in a software update.

Webinterface can be reached again after a little waiting time. Thanks a lot!

Hi, I was on the phone with Apple Enterprise support today. They cannot solve the problem. Also told me that it will be in the next server app update, but cannot say when it will be released.

@Loopi: If you've found a solution or workaround, it would be great if you could let us know. Who knows when the update will be released.

No, since the problem occurs on a productive system (managing about 240 devices) I don't want to risk anything. So no beta on my system.

At present, my PM Admin site is visible again. Hope it stays that way.

I was told by a collegue with the same problem that his postgres-process is running at 100% (or close to it) whenever the problem occurs. Can you verify that? (I can't at the moment, since the problem seems to be temporarily gone here).

I'm from Japan and I'm experiencing the same situation. The same thing happens even if I use the time machine to restore before the situation got worse.

Is there any way to solve this problem...><

Unfortunately, I haven't got a solution at hand. I was only told that it will be fixed in the next server app update.

tbh I have no idea what caused it to work again. I did a restart, tried different browsers (on the mac itself and on other devices), tried private browsing, deleted browser cache. But I've tried all of this before and all of this did not work.

I then called Apple support, and while I was on the phone it started to work again (sometimes very slowly, though). But neither they nor I did anything. They did not even have accesss to my mac. So I guess it might as well be just sheer luck.

[Edited by Moderator]

Hey craigboy, where can I find this B_E_T_A? It's not in the normal public b_e_t_a program, is it? Is it in the developers?

(btw: It's so annoying that this forum constantly removes parts of post or even complete posts only because you use the word b_e_t_a)

Apple fixed the issue for me by doing this.

1.) Make sure you have a backup.

2.) Open terminal session and type this

sudo -Hu _devicemgr psql -U _devicemgr -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL-12

Press enter

3.) Then type this

CREATE OR REPLACE FUNCTION dm_cleanup_completed_tasks(max_tasks integer = 200) RETURNS void LANGUAGE plpgsql VOLATILE SECURITY DEFINER AS $$

<<__fn__>>

BEGIN

DELETE

FROM library_item_tasks

WHERE id IN (SELECT t.id

FROM library_item_tasks AS t

WHERE t.completed_at IS NOT NULL

ORDER BY t.updated_at DESC

OFFSET max_tasks

LIMIT 200);

END __fn__;

$$;

Type control d to end.

4.) Try accessing profile manager. It took a couple minutes for me but it eventually came up. It then took forever to load everything back in when clicking on things but it did.