[ic] indirect_login with AUTO_INCREMENT field

[Stefan Hornburg]

Bill Carr wrote:
> I can not figure out how to use indirect_login and an AUTO_INCREMENT  
> username column with my UserDB to create a new account.
> 
> mysql> SHOW CREATE TABLE userdb;
> CREATE TABLE `userdb` (
>   `username` int(11) NOT NULL auto_increment,
>   `email` varchar(128) NOT NULL default '',
>   `password` varchar(20) NOT NULL default '',
>   `acl` text,
> ...
> 
> I've tried all kinds of combinations like below.
> UserDB    default    <<EOD
> {
>     userminlen        => 1,
>     passminlen        => 1,
>     crypt        => 0,
>     time_field        => 'mod_time',
>     database        => 'userdb',
>     indirect_login  => 'email',
>     logfile        => 'userdb.log',
>     sql_counter        => 'userdb:username',
>     assign_username => 1
> }
> 
> I always end up with two records in my UserDB like so:
> mysql> SELECT username,email,password FROM userdb ORDER BY username  
> DESC LIMIT 2;
> +----------+--------------------------+----------+
> | username | email                    | password |
> +----------+--------------------------+----------+
> |     1724 |                          | password |
> |     1723 | bill at bottlenose-wine.com |          |
> +----------+--------------------------+----------+
> 
> It seems like I could make sure I have a numeric counter file with a  
> value at least as high as MAX(username) but that seems like something  
> that should be able to be avoided. Is there a way to use an  
> AUTO_INCREMENT username column with indirect_login in Interchange?

The problem is that IC creates first a record with just 
username/password and fills in the details later. Personally, I think
accounts should created in an atomic operation.

Bye
	Racke



-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team