plg

Q: can't enrol new iPhone using profile manager

I had an iPhone 4 enrolled using profile manager on Lion Server, no problem. Push notifications were working, all was good.

 

Then I bought an iPhone 4S, and took the micro-SIM card out of the iPhone 4, and stuck it into the iPhone 4S, and tried to enroll the iPhone 4S. I'm getting errors on the console:

 

ProfileManager[462]: ActiveRecord::StatementInvalid (PGError: ERROR:  duplicate key value violates unique constraint "devices_ICCID_key"

          DETAIL:  Key ("ICCID")=(8930 2720 4010 2940 1034) already exists.

 

and the device shows up as "new device" and the push notifications just hang, it won't get enrolled.

 

I did de-enroll the old one first before trying to enroll the new one...

 

any ideas? this kind of *****

Posted on Nov 2, 2011 6:29 AM

Close

Q: can't enrol new iPhone using profile manager

  • All replies
  • Helpful answers

Previous Page 2
  • by cragiboy,

    cragiboy cragiboy Jan 9, 2013 5:39 AM in response to plg
    Level 1 (9 points)
    Servers Enterprise
    Jan 9, 2013 5:39 AM in response to plg

    since updating to OS X Server 2.2 i can not connect to database.

     

    the command "sudo -u _devicemgr psql device_management" is not working.

     

    error: psql: FATAL:  role "_devicemgr" does not exist

     

    how can i connect to database to delete an ICCID?

  • by Gnitset,

    Gnitset Gnitset Jan 9, 2013 5:07 PM in response to cragiboy
    Level 1 (0 points)
    Jan 9, 2013 5:07 PM in response to cragiboy

    They changed how to connect to postgres.

     

    Try this instead:

    sudo -u _postgres psql -h '/Library/Server/PostgreSQL For Server Services/Socket/' device_management

     

    Hope it works.

  • by cragiboy,

    cragiboy cragiboy Jan 9, 2013 11:02 PM in response to plg
    Level 1 (9 points)
    Servers Enterprise
    Jan 9, 2013 11:02 PM in response to plg

    this works fine!

     

    thank you Gnitset.

  • by Sensemann,

    Sensemann Sensemann Jan 15, 2013 4:55 AM in response to plg
    Level 1 (0 points)
    Jan 15, 2013 4:55 AM in response to plg

    Hi all reader of this thread,

    please commit a feedback about this profile manager issue at http://www.apple.com/feedback

    I've gone through different Apple support departments, and at least the German Apple Care Mac OS X Server devision had told me, that the advisor personal knows about this ICCID problem. He often had cased with this issue and he suggested the same solution to alter the devicemanager database with SQL commands.

    BUT THIS CAN'T BE THE SOLUTION Apple will give fore their customers!

    We have to inform Apple that the current implementation of profile manager is unsuitable.

     

    Here is a thread how to update the old effect iOS device so it's still present in the database:

    https://discussions.apple.com/message/17318643#17318643

     

    Thanks

    Jens

  • by sid1992,

    sid1992 sid1992 Jan 23, 2013 6:37 AM in response to Sensemann
    Level 1 (0 points)
    Jan 23, 2013 6:37 AM in response to Sensemann

    Hello

     

    I have download the pgAdmi but i can't find the profile manager database, can you tell me how can connect the the profile manager database in pgAdmin?

     

    Thank you very very much

     

    Greeting

  • by CMIT,

    CMIT CMIT Jun 23, 2013 7:33 PM in response to Gnitset
    Level 1 (0 points)
    Jun 23, 2013 7:33 PM in response to Gnitset

    The Socket directory doesn't exist on my server.... Have I done something wrong? I can enroll, manage, and remove devices, however the whole experience is slow, a lot of the pushes fail instantly... very confusing and annoying.. I was hoping to reindex all the tables following a tutorial from krypted.com but I keep getting the FATAL: device_management does not exist error...

     

    I have setup pgAdmin3 and connected to the postgres database but I can't see a table called device_management... has something changed in OS X Server 2.2.1?

     

    Thanks,

  • by Gnitset,

    Gnitset Gnitset Jun 24, 2013 2:28 AM in response to CMIT
    Level 1 (0 points)
    Jun 24, 2013 2:28 AM in response to CMIT

    I just checked, I'm running Server 2.2.1 and this command still works for me:

    sudo -u _postgres psql -h '/Library/Server/PostgreSQL For Server Services/Socket/' device_management

     

    if you run this command it should look something like this:

    $ sudo ls -la '/Library/Server/PostgreSQL For Server Services/Socket/'

    total 8

    drwxr-xr-x  4 _postgres  _postgres  136 14 Mar 10:09 .

    drwxr-xr-x  6 _postgres  _postgres  204  9 Jan 22:44 ..

    srwxrwx---  1 _postgres  _postgres    0 24 Jun 11:02 .s.PGSQL.5432

    -rw-------  1 _postgres  _postgres  126 24 Jun 11:02 .s.PGSQL.5432.lock

  • by Brinken,

    Brinken Brinken Aug 5, 2013 5:22 AM in response to plg
    Level 1 (0 points)
    Aug 5, 2013 5:22 AM in response to plg

    Hey

     

    How to delete a iPad when it dos'et have a ICCID (no simcard) and you only know the Serial no.

     

    I usually use this command when I delete a device.

     

    sudo -u _postgres psql -h '/Library/Server/PostgreSQL For Server Services/Socket/' device_management

     

    DELETE FROM devices WHERE "ICCID" LIKE '8945 0133 1109 0152 5806';

     

     

    Thanks

  • by Gnitset,

    Gnitset Gnitset Aug 5, 2013 5:36 AM in response to Brinken
    Level 1 (0 points)
    Aug 5, 2013 5:36 AM in response to Brinken

    Hi

     

    You can list you devices by running this command in psql:

    SELECT id,"DeviceName" FROM devices;

     

    And the delete by id:

    DELETE FROM devices WHERE id=X; -- Replace X with the id.

  • by MBrown70,

    MBrown70 MBrown70 Aug 10, 2013 1:39 PM in response to plg
    Level 1 (0 points)
    Aug 10, 2013 1:39 PM in response to plg

    I found the easiest solution was to go to my mobile provider and get a new sim card.  Problem solved without risky sql statements. Going foward if I get a new device I will just get a new sim card, this took hours to figure out so the $10 spent on the new card was well worth it.

Previous Page 2