[ic] indirect_login with AUTO_INCREMENT field
Bill Carr
bill at bottlenose-wine.com
Wed Sep 27 16:26:20 EDT 2006
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?
Bill Carr
Bottlenose - Wine & Spirits eBusiness Specialists
(877) 857-6700
http://www.bottlenose-wine.com
Download vCard
More information about the interchange-users
mailing list