[Devel] [ openser-Bugs-1447266 ] openserctl add does not check for Table aliases

[SourceForge.net]

Bugs item #1447266, was opened at 2006-03-10 14:58
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1447266&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: ver 1.0.x
Status: Open
Resolution: None
Priority: 5
Submitted By: Bernie Hoeneisen (bhoeneis)
Assigned to: Nobody/Anonymous (nobody)
Summary: openserctl add does not check for Table aliases

Initial Comment:
~> openserctl add z554 at xyz.switch.ch secret some at email.net

results in:
  new user added

although an alias "z554" already exists in the aliases
table.


---

The following MySQL statements are exectuted by openser:


060310 15:47:41           260 Connect    
openserro at localhost on openser
                    260 Query       select count(*)
from subscriber             where username='z554' and
domain='xyz.switch.ch'
                    260 Quit
                    261 Connect     openserro at localhost
on openser
                    261 Query       select count(*)
from dbaliases              where alias_username='z554'
and alias_domain='xyz.switch.ch'
                    261 Quit
                    262 Connect     openser at localhost
on openser
                    262 Query       insert into
subscriber                      (username,domain,HA1, 
                
HA1B,password,email_address,datetime_created,         
            phplib_id)                      values
('z554','xyz.switch.ch','0a4aae2ed77cd1b0e672747285aecdab','f7f9a84091c2540887940876a201084e','secret','some at email.net',now(),'0a4aae2ed77cd1b0e672747285aecdab')
                    262 Quit


---

Proposal for Resolution: check also Table 'aliases' (in
addition to dbaliases) 


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1447266&group_id=139143