Topic: Bulk Import of users

[FISKO]

Hi How can I bulk import users to sme server 7?
I tried the old bulk import versions as shown on the site and it fails with
---------------------------
Error
---------------------------
Command 'perl script.pl ./adduser user_list/user_pupils.txt'
failed with return code 0 and error message
*WARNING* esmith::config(/home/e-smith/accounts) called with old database path. The following package needs to be updated:  at /usr/lib/perl5/site_perl/esmith/config.pm line 374
   esmith::config::TIEHASH('esmith::config', '/home/e-smith/accounts') called at script.pl line 11.
---------------------------
OK  
---------------------------

Any ideas?
Thanks

[kmac]

Search for lat (lazy admin tools)
It uses a .csv file that can create users, passwords, groups, etc.

[stephen noble]

   esmith::config::TIEHASH('esmith::config', '/home/e-smith/accounts') called at script.pl line 11.

line 11 of your script
see the sticky referring to changed db locations

[FISKO]

sorry new to sme server how do I cure my problem?
thanks

[del]

Hi FISKO,

Welcome to SME
Take a look here: http://mirror.contribs.org/smeserver/contribs/mblotwijk/Contribs/lazy-admin-tools/
This may help

Regards,
Del

[FISKO]

How do I install the RPM? can I do this via winscp? and how?
Thanks

[del]

Hi FISKO,

You need to download the rpm, I normally do this to my Windows PC desktop and then move it to the server using winscp. I created an i-bay called contribs on my server and this is where I put my rpms (in a folder,for example called lat_tools which I create beforehand) and then I use putty and cd to the folder, in this example:

cd /home/e-smith/files/ibays/contribs/files/lat_tools

Then you can do the command:

yum localinstall ./*.rpm

Then you can read the manual etc that is available for download here:
http://mirror.contribs.org/smeserver/contribs/mblotwijk/Contribs/lazy-admin-tools/
This will tell you how to use the tools.

Good luck,
Del

[FISKO]

Thanks for your help, will try your suggestions  

[FISKO]

Hi still having problems, now fails with:
---------------------------
Error
---------------------------
Command 'lat-users -a -i /root/users.list'
failed with return code 2 and error message
*WARNING* esmith::config(/home/e-smith/accounts) called with old database path. The following package needs to be updated:  at /usr/lib/perl5/site_perl/esmith/config.pm line 374
   esmith::config::TIEHASH('esmith::config', '/home/e-smith/accounts') called at /usr/sbin/lat-users line 17
Can't find /root/users.list..
---------------------------
OK  
---------------------------
any ideas? thanks once again

[mmccarn]

It looks like the link provided earlier points you to a 2004 version of lazy admin tools for SME 6

Here's a post on how to download & install a version that I've tested on SME 7: http://forums.contribs.org/index.php?topic=37284.0

The download link in that post points to smeserver-lazy_admin_tools-0.9.1-2 from October 2006 in jbennett's contribs folder: http://mirror.contribs.org/smeserver/contribs//jbennett/sme7/lat/

I suspect you should uninstall the older rpm before installing the new one...

Find out what version you have installed with

Code: [Select]

rpm -q smeserver-lazy_admin_tools

Remove it with:

Code: [Select]

yum remove smeserver-lazy_admin_tools or

Code: [Select]

rpm -e  smeserver-lazy_admin_tools

[FISKO]

Wow thanks for your help all now works great!
Next prob is how to keep all these settings and migrate to a faster PC  

[mmccarn]

'affa' will let you migrate everything (with a little effort)

'lat-dump' will dump (most?) of your sme configuration to files and create a script called 'lat-restore' to re-apply them to the same or another server...

Run 'lat-dump' - if all the configs you want to save are in the output files, you're golden!

'lat-dump' specifically dumps all the settings and account info for SME 6.  The october update simply changed the routines that access the SME config db, but didn't change any of the items dumped.

[FISKO]

Thanks again,  

[del]

Hi FISKO,

Sorry about the dud link  I just did a search and that was the first one that came up I never thought to see if there was another one  Again I am sorry, but I am glad that you have it sorted out now

Regards,
Del