Unable to create admin account during a GMS migration process.

  • 7000489
  • 27-May-2008
  • 10-Dec-2013

Environment

GroupWise Mobile Server Windows edition
GroupWise Mobile Server Linux edition

Situation

During a migration process when adopting Windows SyncDB.db and SyncDB.log files in a Linux environment, database editing tool complains about non-unique entry for a line to create new admin account.
This happens in a step when using the dbisqlc editor:
delete from IMSERVERCONFIG;

insert into IMADMINISTRATOR values(1,'admin', 'Initial

administrator',2,-1,0,NOW(),NULL,0);

delete from IMATTRIBUTES where ATTRNAME='NotificationHandlers';

delete from IMATTRIBUTES where ATTRNAME='FolderHandlers';

Resolution

Databases from Windows platform might have some existing or obsolete admin account information. There are few options to fix this problem within the dbisqlc database tool:
  • You can delete any obsolete 'admin' account information. First type following command - delete from IMSERVERCONFIG; and then hit F9 to execute it. Next remove any obsolete admin entries from a database table - delete from IMADMINISTRATOR; and hit F9 to execute it. Then type the rest of commands:

insert into IMADMINISTRATOR values(1,'admin', 'Initial

administrator',2,-1,0,NOW(),NULL,0);

delete from IMATTRIBUTES where ATTRNAME='NotificationHandlers';

delete from IMATTRIBUTES where ATTRNAME='FolderHandlers';
  • If you do not succeed, the you can create any other than 'admin' account name, for instance 'anyadmin'. Corresponding commands to achieve that looks like following example:

delete from IMSERVERCONFIG;

insert into IMADMINISTRATOR values(1,'anyadmin', 'Initial

administrator',2,-1,0,NOW(),NULL,0);

delete from IMATTRIBUTES where ATTRNAME='NotificationHandlers';

delete from IMATTRIBUTES where ATTRNAME='FolderHandlers';

This will create 'anyadmin" account that you can use for administering GMS on Linux.