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 | suppressed | | +----------+--------------------------+----------+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 _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.