Currently Being ModeratedNov 2, 2011 7:40 AM (in response to plg)
OK so I found a solution myself ... a bit heavy-handed, but it worked.
in postgreSQL delete all rows in the "devices" table in the device_management database
Then all registered devices are gone and I was able to re-enroll no problem.
There's probably a way of only deleting one row (the bad device) from the devices table but my SQL is not up to snuff and frankly after 30min of searching for how to do it I gave up and just deleted all rows.
Currently Being ModeratedNov 8, 2011 4:30 PM (in response to plg)
I'm having the same issue with a replcament iPhone 4.
I'm used to MySQL and not postgreSQL, could you give a little more detail on how you got the the database please?
thanks in advance
Currently Being ModeratedNov 9, 2011 10:42 AM (in response to burti)
I used pgAdmin (download from here: http://www.pgadmin.org/) to open up the relevant database ... there was a lot of fiddling to get the username & pw for the postgresql database configured so that pgAdmin could access it. To tell you the truth I didn't document every step (I should have) and so I can't give you a step-by-step.
Currently Being ModeratedNov 24, 2011 9:35 AM (in response to plg)
After finding the the Key ("ICCID") in /Library/Server/ProfileManager/Logs/profilemanager.log
I ran sudo -u _devicemgr psql device_management to connect to the postgres database.
typed \x on; to enable sane output
then i ran the query SELECT * FROM devices WHERE "ICCID" LIKE '0000 0000 0000 0000 0000';
but with the numbers from my log file instead.
Please note that " and ' are important and means different thing in pgsql.
That shows the data for that device in the database.
Then I ran DELETE FROM devices WHERE "ICCID" LIKE '0000 0000 0000 0000 0000';
(again with the numbers from the log file)
That removes the matching row from the database and solved my problem without having to
remove all devices.
Currently Being ModeratedDec 5, 2011 4:40 AM (in response to burti)
After restoring the whole postgresql as Profile Manager didn't exist when I wanted to try Gnitset fix, I finally go my iPhone sorted and enroled!
Fantastic. Thanks again GnitSet!
Currently Being ModeratedApr 29, 2012 9:10 PM (in response to Gnitset)
i just want to express my thanks to you gnitset. have been trying to trouble shoot it for past 2 days and finally came across your post.. it worked like a charmed!.
anyway , for benefit of those who is not familiar with mac,
go to utility --> Console and type in gnitset command. it should work.
Currently Being ModeratedMay 18, 2012 8:03 AM (in response to plg)
Could you provide some details on how to connect/configure adding a server in pgadmin? I'm unfamiliar with how to connect and what database you're referring to. Thanks for any help you can provide.