Profile Manager Suddenly Not Pushing Settings

[cshephard]

Hi everyone

 

I am suddenly having problems with pushing settings on profile manager. I had it setup so that some settings would apply to machine groups and other settings to OD groups that contained AD users. I had to add all AD users to the groups because adding AD groups would not work.

 

This worked fine and now suddenly I noticed yesterday the user group settings were no longer pushing but machine settings were. I made a change to the group which left 90 odd pending tasks. I wanted to clear these and found a couple of commands that I thought would do it. I firstly tried this one

 

sudo psql -U _devicemgr -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL -c "DELETE FROM library_item_tasks WHERE completed_at IS NOT NULL"

This one didn't work so tried this one

 

sudo psql -U _devicemgr -d devicemgr_v2m0 -h /Library/Server/ProfileManager/Config/var/PostgreSQL -c "DELETE FROM library_item_tasks"

 

Since running this one, I cannot push any settings. They don't even show up as a pending task. I don't know if I have broken the SQL or not. I don't know anything about SQL so have no idea I am tempted to just wipe it all and start again but would like to try and fix it if I can as the students still need to work on them.

 

We run Yosemite on all the macs and I yesterdayy upgraded Server app to the latest version hoping that would help. Any help would be much appreciated as I am all out of ideas.

 

Thanks in advance!

[DMcCoy]

Is the push notification certificate still valid?

[cshephard]

It was and I tried renewing it and that still didn't work. We had problems when we first set the system up and it turned out that we didn't have the right ports unblocked on our firewall. We haven't changed those and the DNS is all the same as well.

 

Could running that command have broken anything?