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

[SourceForge.net]

Bugs item #1447266, was opened at 2006-03-10 16:58
Message generated for change (Comment added) made by bogdan_iancu
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: tools
Group: ver 1.0.x
>Status: Closed
>Resolution: Out of Date
Priority: 5
Submitted By: Bernie Hoeneisen (bhoeneis)
>Assigned to: Bogdan (bogdan_iancu)
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) 


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

>Comment By: Bogdan (bogdan_iancu)
Date: 2006-03-15 18:11

Message:
Logged In: YES 
user_id=1275325

this is already fixed in 1.1.0 version. Functionlity
upgrades are not backported to the stable releases.

for user rm , indeed the aliases are not removed - please
submit a new bug about this

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

Comment By: Bernie Hoeneisen (bhoeneis)
Date: 2006-03-10 17:03

Message:
Logged In: YES 
user_id=1441804

The same applies to openserctl rm z554
(aliases Table is not emptied)

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

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