Hello
all,
I have a list of
users I have to insert into web-cyradm user list.
I've created Cyrus
accounts using modified Enrique script (attached), I've modified it a little so
it suits short usernames I use (leon instead of leon.ns.edu.XX) and ACL issues.
That's working fine and users have been created and I can see them using "lm"
command.
Now I had to insert
these users into mysql:
I've created
userssql_add.txt file, which looks like this:
sleshem:dV2HgJefAbFqI:edu.haifa.ac.il:edu.haifa.ac.il:Shosh:Leshem
aklemer:tguxshr/unccc:edu.haifa.ac.il:edu.haifa.ac.il:Anat:Klemer
aklemer:tguxshr/unccc:edu.haifa.ac.il:edu.haifa.ac.il:Anat:Klemer
And this is for
mysql import:
# mysql
--local-infile=1 -u root -p
mysql> USE mail;
mysql> LOAD DATA LOCAL INFILE '/srv/www/import_users/userssql_add.txt'
INTO TABLE accountuser
FIELDS TERMINATED BY ':'
LINES TERMINATED BY '\n';
mysql> USE mail;
mysql> LOAD DATA LOCAL INFILE '/srv/www/import_users/userssql_add.txt'
INTO TABLE accountuser
FIELDS TERMINATED BY ':'
LINES TERMINATED BY '\n';
Query OK, 2 rows
affected (0.00 sec)
Records: 2 Deleted: 0 Skipped: 0 Warnings: 0
Records: 2 Deleted: 0 Skipped: 0 Warnings: 0
These 2 users are
added to accountuser table.
I can connect and
authenticate without any problem with these user credentials
The problem is in
web interface:
I can see these
users in the list of the accounts but 'Email address', 'Name',
'Shurename' columns are empty for these 2 users
:)
When I go to 'Edit
Account' for these users I got no info on these users, and If I go to 'Edit
Account' for other users I get 'Anat Klemer' (these are Name and Surename
of the second user I've inserted) in Name and Surename for all of the old
accounts.
Am I doing something
wrong with MySQL import (may be there is additional tables like 'virtual' I
should populate or some index problem) or is it because of the fact that
I'm using Marcels' version for with 'Name', 'Shurename'
?
Any
ideas?
Best
Regards,
Leon
cyr_adduser.pl
Description: cyr_adduser.pl
_______________________________________________ This mailing list is hosted and supported by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________ Web-cyradm mailing list [email protected] http://www.web-cyradm.org/mailman/listinfo/web-cyradm
