omaddu bulk operation fails -> No users in Admin Console

[jsauer]

Hi, I tried to add some 50 users to a fresh Scalix 11.3.0.U1 installation. We have a small business edition with 50 premium users.

I used

Code: Select all

omaddu --bulk -e -p 12345 --class limited -few scalix userimport.txt

The format of the import file is

Code: Select all

@ Armiwal
@ Ramli Rasyid
@ Ansarullah
@ Arfah Salwah


Some users have just one name. Unfortunately I overlooked one double entry. Meaning two persons with just one name happen to have the same

omaddu complained about that and quit service with an error message reporting duplicate users. (unfortunately the error message is not at hand anymore)

Since that time I can not retrieve the users list in the sac admin console.
SAC is prompting "incomplete list ..." in the users list pane
and pops up a dialog stating ]"Could not retrieve the list of users"

Code: Select all

omshowu -m scalix

prints a bunch of users stopping with the one from the import file just one position before the first occurance of the duplicate name. In total 37 including sxadmin and sxqueryadmin

Code: Select all

omldapsearch "( omCn=*)" | grep omCn

gives me exact the same users plus some more sx*admin accounts if I omit those the list has also 37 users

After reading some messages in the scalix community forum I run

Code: Select all

omscan -u
omexeccda
omshut
omrc


But still the same problem

As this is a fresh install I am just about to wipe out the whole installation and do a fresh install, but this system is expected to host about 300 users and if it will happen again in future....

Just for reference before I tried the bulk operation with omaddu I did a single user creation with
omaddu -n "first last/scalix" -p 12345
which worked pretty well!

Any suggestions?

Thanks
Joerg

[jsauer]

Hi, just a follow up by myself as there is more trouble around

As nobody replied by now (no complaint) I made a full backup of the original system (virtual machines make this easy ) and uninstalled scalix completely.

Then I did a fresh complete scalix installation.

After that I directly run

Code: Select all

omaddu --bulk -e -p pass --class limited scalix usersimport.txt

Just to get another complaint as I forgot the dot after the title for one user in the file.
The line looked like

Code: Select all

@ First Last TA

Should be

Code: Select all

@ First Last TA.

The result is the same as in my previous post:
Incomplete list ... and Could not retrieve list of users!

I did another uninstall and fresh install, corrected the import file and run omaddu with the parameters from above.
This time no complaints and everything looked fine in the first moment when I logged into SAC. All users in the list.

But when I tried to select one user I got a pop up dialog with the message

Could no longer find selected item in the directory. It was probably deleted by another administrator.

So what is wrong with omaddu or scalix or my installation?
I have OpenSuse 10.2 basic text installation, fully updated with YOU and only installed all required packages for scalix as mentioned in the docs and all required packages to get vmware-tools installed. Thats it.

If I have time I will try CentOS later as this is directly derived from RedHat Enterprise and might work better even if not officially supported by Scalix. But OpenSuse should work, shouldn't it?

Hope somebody can follow up!
Joerg

[Valerion]

Mmm .. could be an issue with omaddu. Maybe the easiest way around this is to write a script (perl?) that reads each entry in the file, generates a omaddu command to add that specific mailbox and outputs that to a file. You can then review that for errors/duplications and run all the commands at once when done.

Haven't seen your behaviour before, so I don't know where to start on debugging this, but it looks like something got messed up in your SYSTEM directory.

[bikerider]

I've had the same problem now, a simple import
has turned a deployment into a debacle
From sac I can't every user comes up with the
same error.

New install

redhat 5.1 file layout was @ 1stname lastname
omaddu --bulk --class limited -p xxxxx -e xmail /tmp/email_user_list2.csv

finished with out errors
I ran the conf.dump and edited out everything but the broken users
file format "John Harris /xmail/CN=John Harris" per line
and ran omdelu -f fscked.users and it did delete the
users..

Still need a way to bulk add users for tomorrow morning.

[Valerion]

I would have by now dumped omaddu --bulk and written my own script if I was you Use a perl script to parse your CSV, then create individual omaddu commands from that you output to a file. Give it a once-over to ensure nothing is broken and run the script.

Personally I prefer this method to using omaddu --bulk, gives me more flexibility the way I normally work.

[shouvikb]

Is there a way to tweak this script to assign different passwords to each user.

Thanks,

Shouvik

SSPUK