RE: [Web-cyradm] creating new users directly in mysql

[Marcel Hartmann]

Hello,

 

have you tested a normal web-cyradm? On the same DB?

 

If you create a User you must have a Entry in:

 

1. accountuser    -> pam auths pop|imap|smtp|sieve

2. virtual            ->  postfix virtual domains, canonical maps and mydestination

 

Greets Marcel

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 4:06 PM
To: web-cyradm@web-cyradm.org
Subject: [Web-cyradm] creating new users directly in mysql

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

 

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';

Query OK, 2 rows affected (0.00 sec)
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

 

 

 

 

 

 

 

 

 

 

 

_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch

_______________________________________________
Web-cyradm mailing list
Web-cyradm@web-cyradm.org
http://www.web-cyradm.org/mailman/listinfo/web-cyradm